Project Manager Data

SONIKA MEHTA

Phone # 630-***-****

Email: *************@*****.***

Summary of experience:

• Over 13 years of IT Experience out of which over 8 years of experience with PepsiCo that includes

experience with SAP with in-depth experience in blueprint, managing, design, delivery of SAP

projects involving SAP BI, Finance, Supply Chain, HCM.

• Led several in house PepsiCo Center Of Excellence (COE) projects for Quaker, Tropicana, and

Gatorade.

• Oracle, and BackOffice Cranberry tool, Ab initio. Knowledge of HANA and BO tools – Lumira, Analysis

for Microsoft Excel, Explorer.

• Worked as a Project Manager for Minor Enhancements. Worked as a Project Manager for our team

Enhancement work. Responsible for project plan. Managed timeline, getting leadership approvals,

Sox Compliance.

• Developed BI on BI solution that enabled user to get Statistics on BI reports, roles, and authorization

information.

• Performed POC on Analysis for Office and BW Workspace in SAP BW Hana environment.

• Experience with Requirement gathering, Effort estimation, Resource management, Impact Analysis,

Solution Design, Preparing Blue Print, Deployment Plan, Functional Spec, Technical Spec,Test

Scripts, Go-Live, knowledge transitions and Hyper-Care.

• Involved in analyzing the enhancement/development requests and preparing the High level

documentation.

• Worked on data extractors from SAP-R/3, flat files, FI and HCM extraction and generic Extractors.

• Key player in designing, creating and maintaining custom Info Objects, Info Cubes, DSO, InfoSet,

Transformations, Data Sources, Info Sources, Transfer and Communication structures, Multi

providers, Applying filtering conditions, Aggregates, Initial, Delta, Full uploading methods, Process

Chains and Job monitoring using ControlM, BIA index, Broadcasting.

• Developed various Bex reports and experience with calculated and restricted key figures, filters,

conditions, exceptions, RRI, Information broadcasting in Bex.

• Experience with creating Business Objects – Universe, Webi, Lumira, Dashboards, Workspace and

Xcelcius reports in SAP HCM

• Developed BO Universes and Webi Reports on SAP HCM SAP HCM sub-modules: Payroll and Time

Management, Benefits, Personnel Administration, Organizational Management

• Good knowledge in authorizations, roles and profiles.

• Experience in performance tuning – compression, partitioning, indexing and aggregates.

• Worked with heterogeneous sources and targets (Databases and flat files) for ETL processes using

ETL and BackOffice Cranberry tool.

• Development and design of ETL methodology for supporting data transformations and processing, in

a corporate wide ETL Solution using Informatica PowerCenter, Oracle, and BackOffice Cranberry

tool. Worked with heterogeneous sources and targets (Databases and flat files) for ETL processes

using ETL and BackOffice Cranberry tool.

• Worked as a key contact for Solution Manager (SM). Conducted brown bag trainings for Solution

Manager, and HP Quality Center.

• Good team player, Strong team orientation & leadership qualities, hardworking, enthusiastic and quick

learner

SKILLS

SAP Technologies: SAP BI Netweaver 2004s, BW 3.x, ECC 4.x/5.0/6.0, ABAP Query, BEx

Analyzer, Bex Browser, Query Designer, Business Objects 4.0

Reports, Webi, Solution Manager 7.0, ABAP, Analysis for Office, BW

Workspace

Data Warehousing: Informatica Power Center 7.x/6.x/5.x, BackOffice Cranberry ETL tool, Ab Initio

Databases: Oracle 9i, Teradata, SQL*PLUS, MS Access, SQL Server 7.0

Programming Languages: SQL, ABAP, PL/SQL, HTML, XML

General: MS Office, Toad, SQL Navigator, PL/SQL Developer, VISIO

Operating Systems: Windows NT, 2000, XP; MS-DOS; Linux; UNIX

PROFESSIONAL EXPERIENCE

PepsiCo, Chicago, Illinois Aug 2008–

Present

Senior SAP BW Developer

• Initiated and led Center Of Excellence (COE) Projects from requirement gathering to knowledge

transfer to BW production support team. Gathered requirements from Business. Reviewed reports

requirements and got redundant reports requirement merged/ eliminated. Reviewed objects in BW

and provided feedback to process team on merging report requirements or eliminate redundant

reports and leveraging /enhancing existing objects/ reports instead of developing new objects or

reports.

• Managed Project timeline and delivered projects on time and received positive feedback from the

clients on the quality of deliverables.

• Directly involved in meetings with business/process users to understand the requirement and

implemented quality solution.

• Project Manager for the enhancements project.

• Worked with Solution Manager (SM) and used Charm to create, approve, collect objects in transports

and migrated objects to QA and Production.

• Coordinated the activities on production migration with Release Management/ CHARM team and

made sure all the documentation is up to date in Star team/Solution Manager tool CHARM.

• Analyzed highly complex requirements. Provided high level architecture feedback to the process

team. Analyzed BW data and worked on extractors, query, Webi reports, BO Universe and HANA BO

tools – Lumira, Hana Studio, Dashboard, Explorer, Analysis for Excel.

• Created new transformation, DSO’s, Cubes for Transactional cubes to load data from external

systems like Essbase, HR, and Genesis and feed data into AOP Plan Base cubes.

• Created calculated key figures, restricted key figures, different formula variables and cell definitions

for the complex queries and workbooks.

• Used APD (Analysis Process Design) tool to load data from queries into Direct Update type DSOs.

• Enhanced Manufacturing and Supply Chain Transactional cubes to fit for BPS solutions.

• Worked on complex structural Bex reports to show AOP, FCST and Actual data along with YTD, and

QTD data.

• Supported BPS Forecast and AOP allocations by loading data and analyzing the issue. Worked

closely with the BPS team and supported their allocation process.

• .Experience with HCM system. Created Business Objects - Webi Reports and Universe. Worked on

extractors to migrate Hewitt data into HCM system. Gathered requirements, developed Universe and

Webi reports. Tested functionality in the following SAP HCM sub-modules: Payroll and Time

Management, Personnel Administration, Organizational Management

• Led BW statistics project to collect the statistics on SAP BW objects usage, Queries, Multi provider,

and Authorization Roles. Extracted information from the SAP tables and created different extractors to

pull required information in SAP BW area

PepsiCo, Chicago, Illinois Aug 2005–

Aug 2008

Data Analyst:

Responsible for coding for assigned Manufacturing, Logistics, P2P, and OTC conversions using

BackOffice Cranberry ETL tool. Worked on Pepsi Cola North America Material Master, Item

Synchronization, Open Purchase Order, Sample Sales History etc.

Developed stored procedure and rules using BackOffice ETL tool to transform data from multiple

sources including flat files, Excel, SQL Server, and Oracle relational sources. Developed Complex

exception reports related to MM, P2P,Customer Master data.

Analyzed data provided by legacy team. Responsible for identifying gaps in configuration and

mapping between legacy data and SAP/BW. Generated missing value reports and provided

feedback on missing and invalid values.

Reviewed Functional Design (FD) and Field Mapping Document (FMD) with business, legacy,

process and SAP Dev. Team. Responsible for approving (Action to Proceed - ATP) assigned RICEF

Objects.

Validated master data and generated missing configuration, code/decode, Xref, and data

cleansing reports.

Performed Unit, String and Assembly test. Debugged the issues related to logic, missing cross

reference, code/decode data.

Supported and responsible for Informatica ITNWD (code/Decode) extract process to pull data

from XTS to Oracle ITNWD stage database. Also, automated ITNWD refresh process and added

true/false decision session to send out appropriate email notification to users account.

Tuned Extract process Informatica mapping for better performance. Optimized query

performance, session performance for data load process.

Environment: Informatica Power Center 7.1, Erwin, Oracle 9i, MS Windows XP, SQL, PL/SQL,

TOAD, UNIX, Star Team, Eroom, XTS Application, PTS (Profile Tracking System), Caliber RM, SAP

client.

Bristol Myers Squibbs, Princeton, New Jersey

May 2005- Aug 2005

Database and Data warehouse Consultant

Worked on Data Warehousing applications, directly responsible for the Extraction, Cleansing,

Transformation and Loading of data from heterogeneous data sources to targets (Like XML, Oracle,

Flat Files)

Created Source definitions, Target definitions, Mappings, Reusable transformations, and

Mapplets.

Created and validated active/passive, connected/ unconnected transformations.

Used Parameter or Configuration files to manage changing variables, sources & targets

definitions Used PL/SQL for creation of stored procedures for removing the indexes before the data

was bulk loaded, rebuilt the indexes after data load completed and for data extraction using

cursors.

Implemented control tables in Oracle database for data extraction process.

Used Oracle Bulk loader SQL Loader to load data.

Created XML templates and UNIX scripts to extract data from the tables.

Involved in data cleansing. Performed data validation checks.

Performance tuning of the mappings and sessions

Environment: Informatica Power Center 7.1, Oracle 9i, PL/SQL, TOAD, SQL Navigator 4, UNIX shell

scripting.

Manugistics Inc. (Now JDA Software) Rockville, Maryland

Jan 2004– Mar 2005

Application Hosting Analyst

Participated in all phases including requirement analysis, client interaction, and testing, support

and documentation.

Maintained and administered client oracle database, performed table spaces check on daily basis

and performed weekly backups. Database monitoring, tuning and extension of table spaces on

daily basis.

Led projects directly related to improvement of processes by recoding, enhancing, and testing

scripts to speed up data processing time using PL/SQL, SQL, UNIX, and Perl.

Automated and scheduled batch jobs in CA-s Unicenter TNG, using Job Scheduler (Workload

Management) to schedule and track jobs and monitor performance of one or more servers in

heterogeneous environment.

Worked closely with the Manugistics Consulting Group to provide post-implementation support

and proactively contacted clients to ensure high level of satisfaction.

Environment: Informatica PowerCenter 6.2, Erwin, Oracle 9i, PL/SQL, UNIX shell scripting, Perl,

SQL*LOADER, Visio.

Current Technologies, Germantown, Maryland: Jun 2003-

Jan 2004

Software Engineer Intern

Worked extensively on Data warehousing, Informatica ETL tool to design mappings to move data

from source to target database-using transformation.

Designed and developed database to tracks client online registration, service usability and

charges.

Developed process flow model and various data flow diagrams for process models.

Developed mappings and reusable mapplets using ETL tool Informatica PowerCenter 6.2 to

transform data from multiple sources including flat files, COBOL sources, XML, SQL Server, and

Oracle relational sources.

Developed and maintained SQL scripts and stored procedures.

Imported and exported data from Production to development box using SQL *Loader utility.

Database monitoring, user lock checking, extending table space, and tuned database on daily

basis.

Designed and developed address line standardization program using Java and XML to reformat

address entered by user/operator to conform to U.S. Postal Service-s addressing standards.

Implemented network time protocol (NTP), which synchronized computer clocks through Internet,

on Linux server and client machines to maximize timing accuracy of network. Initiated network file

system (NFS) in Linux networked environment.

Installed, Configured, and Implemented Concurrent Versions System on Red Hat Linux server.

Handled annotation & documentation of power line server source code, creating headers for source

code & used Concurrent Versions System (CVS) to build entire project and write administration

procedures.

Created disaster recovery implementation methodology for Linux operations in network

environment and successfully restored data from backups.

Tested Perl scripts to restore data on server by executing disaster recovery scripts.

Environment: Informatica PowerCenter 6.2, MS SQL Server 2000, MS Windows 2000/XP, SQL,

PL/SQL, TOAD, Sun Solaris, shell scripting, Linux Red Hat, SQL*LOADER, Visio

EDUCATION

B.S., Business Administration with Computer Studies, University of Maryland, College Park,

Maryland

B.S., Commerce, University of Delhi, New Delhi, India

AWARDS AND TRAINING

Received Value in Practice award from CIO

Oracle 9i Certified PL/SQL developer

Certificate, Management Foundations and Total Quality Management

Contact this candidate