Sonia Goyal
HANA, Patiala
Summary
To work with the best brains in the world in a dynamic organization where the challenging environment provides me an opportunity for continuous learning and growth and to use my skills, enthusiasm, and positive outlook to fuel the company’s growth.
Overview
16
16
years of professional experience
Work History
Basis Consultant
Ingram Micro, SAP
SAC Planning Consultant
SAP
02.2021 - Current
- Know how to configure SAC models and Dimensions
- Configured Data actions in stories
- Successfully created dashboard stories in SAC using responsive pages and canvas pages
- Successfully displays stories in mobile app using Responsive pages
- Implemented Complex calculations using SAC Stories
- Worked on Cross Model Copy to copy the data from one model to another
- Created stories using Datasets
- Know how to filter data in the stories using story filters or page filters
- Know how to use linked analysis on charts in stories
- Run Smart discovery in the stories
- Created Dashboards using different types of charts
- Visualize data in interactive stories with widgets such as charts and tables
- Know how to do levelling in filters of stories
- Know how to visualize data using Geo Maps.
PHP Web Developer
Punjab, Water
09.2015 - 02.2020
- SBM Website (Mission Swachh Punjab)
- Website :, I have developed and maintaining SBM website (Mission Swachh Punjab) for keeping records of toilets construction of beneficiaries of rural areas of all districts of Punjab
- Daily new modules related to Funds, Audit, Campaign are added to this website.
Member of Family Welfare
District Legal Service Authority
10.2017 - 09.2018
- Worked as a member of Family Welfare Committee, which has been constituted as per the guidelines of Hon’ble Supreme Court to resolve matrimonial disputes.
Freelancer
E
01.2013 - 09.2015
- I have developed many websites of, , Property, Videos displaying, Coupon deals and many more
- I have also developed a website based on videos, in which user can like it and comments on the same
- User can also add any topic of his interest and do discussions with his friends on it (www.dictaview.com)
- I have also developed on the coupon deals project in which we provide coupons to the users for the various shops of city.
SAP Basis Consultant
Larsen & Toubro Infotech Ltd
11.2012 - 01.2012
Team Size
Larsen & Toubro Infotech Ltd
11.2009 - 01.2012
- 10-15
- Environment : SAP ECC 6.0, BI 7.0, SCM, SRM, SAP NetWeaver 2004s, SAP Portal 7.0, TREX, MDM
- Company profile:
- Ingram Micro, USA world’s largest technology distributor & a leading technology Sales, Marketing & Logistics Company
- This fortune 100 company distributes and markets IT products from computer hardware suppliers, networking equipment suppliers, and software publishers
- Responsibilities:
- Installation & basic configuration of ECC, BI landscape and portal
- Performing Pre and Post Installation Activities
- CUA Installation & Configuration
- Applying Support Packs & Add-ons using SPAM & SAINT tools
- Deployment of Support Packages Stacks through SDM and JSPM tools
- Configuring Transport Management System (STMS) and Transport Systems for different transport requirements in three system landscape
- Exposure to SAP OS level in Linux/Unix/AIX platform
- Client administration: Created client, define client settings, performed client Copy, Remote Client copy, Client Export, and Import
- User administration like creating users, Assigning Authorizations roles, profiles to users, Locking and Deletion of Users
- Mass user creation using LSMW
- Performed kernel upgrade
- Transporting User requests through STMS
- Importing transports at OS level copying co files and data files to trans directory
- CCMS Registration at OS level
- Daily SAP health check, resolving the issues and directing functional issues to respective teams
- Giving support to the end users by resolving the issues
- Analyzing Dumps, Failed Jobs, System errors, and Printer problems
- Extending the Table space by adding or resizing the Data file using BR Tools
- Setting up of Operation Modes
- Providing Security Support for different systems by creating users, assigning the roles, Locking, and unlocking the users
- Database Administration
- Background Job management: Scheduling Background job, Checking Background job Status and restart the job, Deleting Old Background Jobs
- Parameters setting to improve the system performance
- Creation of RFC connections
- Opening OSS R/3, WTS and HTTP connections at service market place
- Creation of access keys, object keys and OSS ids at service market place
- System backup and restore strategy and execution
- Handover systems to customer after successful validations
- Worked on Config Tool and Visual Admin Tool
- Creation of users, assigning roles in EP using User admin tool
- Monitoring the Java system performance
- Troubleshooting the Java system problems
- Gave KT to new people joined Ingram Micro project regarding INGRAM complex landscape and processes, how to use Remedy Tool and daily activities used in the project
- Project-2 : SAP Installations, Monitoring and Troubleshooting SAP System
Basis Consultant
SAP, Larsen & Toubro Infotech Ltd
10.2010 - 02.2011
- Worked parallely with above mentioned project Ingram Micro)
- Team Size : 4, Oracle10g, 9i, L&T Infotech’s SAP Center of Excellence (CoE) provides thought partnership to clients in emerging technologies
- The CoE focuses on creating innovative solutions and rapid prototypes that helps showcase technology impact on business as well as supporting project teams
- Responsibilities:
- Installation of SAP NetWeaver2004s with oracle 10g
- Installed and configured Central User Administration (CUA)
- System copy of SRM 7.0 with oracle 11g
- Java Add-In Installation for ABAP system
- System Copy (Homogenous /Heterogeneous)
- Implemented Kernel Upgrade and sap notes application
- Applying Support Packs & Add-ons using SPAM & SAINT tools
- Exposure to SAP OS level in Linux/Unix/AIX platform
- SAP System Monitoring for health check IT Experience (Non SAP)
- Project-1 : Live Website including ecommerce and many others
Software Engineer
Neoventis
04.2009 - 10.2009
- Neoventis, has been a pioneer in the Internet & the Web solutions business since 2003 and has grown from scratch to a leadership position in a very short span of time
- With a client base of over 350 National and International clients who endorse the quality and service of our organization
- Responsibilities: Creating websites using a blend of PHP, Javascript and HTML
- Also worked on interfacing existing web layouts to different payment gateways
- Website for children in English and Hebrew Language
Software Trainee
smartData Enterprise (I) Ltd
01.2008 - 07.2008
- Company profile: smartData, is a CMMI 3 company with strong competencies in Open Source & Microsoft platform
- Our cost effective Software Development provides high quality software solutions to partners globally
- Our proven competency in software development & offshore software outsourcing industry is known globally with major clients in US, UK, Canada, Israel, Australia, Middle East, Pan Pacific region and more
- Responsibilities: Creating website in different languages using audio, video and chatting features
- Achievements
- Received certificate of appreciation for quickly learning and adapting to process in Ingram Micro project
- Won SECOND PRIZE for excellence in academics.
Education
B.Tech - CSE
Punjab Technical University
undefined
Central Board of Secondary Education (C.B.S
MBA - Finance + HR
Maharaja Ranjit Singh Technical University
2021
MBA - IT, Correspondence
Symbiosis centre for Distance Learning
2010
12 - undefined
Punjab School Education Board (P.S.E.B)
2004
Skills
- Skill set
- Domain :
- SAP SAC Planning, SAP Basis, SAP HANA , Web Application Development
- Operating System : AIX, HP-UX, Linux, Windows 7, Windows Vista, Windows server 2008
- Tools/ DB / Packages : HANA 20, Oracle 10g, Remedy, My SQL, SQL server 2000, Win SCP
- Programming Languages : PHP (50), JavaScript, HTML
- Role :
- SAP HANA Administrator
- Duration : Dec’2021 – Till Now
- Responsibilities:
- Experienced in SAP HANA 10, SAP HANA 20 Installation
- Implementation and Administration of SAP HANA database
- Experience in monitoring, tuning, and troubleshooting of SAP HANA database
- HANA system administration using SAP HANA cockpit and HANA studio
- Experience in HANA Installation and HANA database version upgrade
- Experienced in OS/DB migration including HANA DB
- Excellent expertise in major UNIX/Linux based OS
- Expertise in SAP HANA administration and security setup
- Backup& Recovery in SAP HANA
- Creating users and assigning roles in SAP HANA
- Tuning parameters in SAP HANA
- Tenant database creation and restoration
- HANA Cockpit installation and maintenance
- Start/Stop HANA systems
Timeline
SAC Planning Consultant
SAP
02.2021 - Current
Member of Family Welfare
District Legal Service Authority
10.2017 - 09.2018
PHP Web Developer
Punjab, Water
09.2015 - 02.2020
Freelancer
E
01.2013 - 09.2015
SAP Basis Consultant
Larsen & Toubro Infotech Ltd
11.2012 - 01.2012
Basis Consultant
SAP, Larsen & Toubro Infotech Ltd
10.2010 - 02.2011
Team Size
Larsen & Toubro Infotech Ltd
11.2009 - 01.2012
Software Engineer
Neoventis
04.2009 - 10.2009
Software Trainee
smartData Enterprise (I) Ltd
01.2008 - 07.2008
Basis Consultant
Ingram Micro, SAP
B.Tech - CSE
Punjab Technical University
undefined
Central Board of Secondary Education (C.B.S
MBA - Finance + HR
Maharaja Ranjit Singh Technical University
MBA - IT, Correspondence
Symbiosis centre for Distance Learning
12 - undefined
Punjab School Education Board (P.S.E.B)
Similar Profiles
Dilpreet KaurDilpreet Kaur
Repair Associate specialist at Ingram microRepair Associate specialist at Ingram micro
Alexis TORREZAlexis TORREZ
Chargé de relation commerciale at Ingram Micro FranceChargé de relation commerciale at Ingram Micro France
VANSHIKA SRIVASTAVAVANSHIKA SRIVASTAVA
Professional Sales Associate at Ingram Micro IndiaProfessional Sales Associate at Ingram Micro India
Ravneet KaurRavneet Kaur
Marketing Coordinator (Patiala,Punjab) at Lally Infosys Pvt. Ltd.Marketing Coordinator (Patiala,Punjab) at Lally Infosys Pvt. Ltd.
Nishita BansalNishita Bansal
State and Local Tax Associate II at PwCState and Local Tax Associate II at PwC