SUMMARY

• Customer - focused Solution Architect with 10+ years of leadership experience in improvement-based technical project management and business analysis.
• Demonstrated mastery in facilitating evaluation of requirements for business application integration and service activation; able to consistently deliver enhancements and solutions that drive customer satisfaction and loyalty.
• Proven mentor and trainer, skilled at communicating with all organizational levels and cross-functional teams to develop a shared vision and foster a culture of excellence.
• Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
• Expertise in Installation, migration, maintenance, troubleshooting and overall administration of the Business Objects Suite. Involved in conducting strategic evaluation (Proof of Concepts) of the use of Business Objects XI R3.1/R2.
• Experienced in ETL Methodologies using Business Objects Data Integrator/ Services XI 3.1 with Data Quality & Rapid Mart and worked on Metadata Integration (BOMM-Business Objects Metadata Manager) and EPM (Enterprise Performance Management). Extensively worked on creating complex workspace and analysis of data using OLAP reporting tool Voyager.

TECHNICAL SKILLS

• SAP ECC versions 4.x to 6.xx, implementation and configuration (10)
• SAP SD integration (9)
• SAP MM (10)
• SAP Reporting (7)
• SAP HANA Data Loading using BODS
• S4 HANA
• SAP Solution Manager 7.0/7.1, Knowledge of SAP Basis
• Operating Systems: AIX, Windows XP,Windows 7
• Database: IBM DB6, Oracle, MS SQL Server 2000/2005
• HTML (10)
• JavaScript, XL, HTTP, Lotus Notes Domino (8)
• ARIS 7.2, QC 11.0 and SAP TAO

PROFESSIONAL EXPERIENCE

Confidential

SAP BODS Consultant

Responsibilities:

• Involved in the development, administration and implementation of the Enterprise Data Warehousing EDW process and Data Warehouse.
• Worked extensively on BODS Administration tasks; Installation and upgrades, Creation of JOB Server - Monitoring and scheduling the jobs, Creation of User, Creation of Repository. DBA Activity (Creation of the database and monitor database growth) and Trouble shooting
• Building of the BODS Jobs, Workflows, Data Flows as per the Mapping Specification.
• Worked extensively on different types of transformations like Query transformation, Merge, Case, Validations, Map-operation, History Preserving and Table Comparison transformations, SAP HANA Data Loading using BODS etc.
• Extensively used ETL to load data from flat file and also from the relation database.
• Extracted data from different sources such as Flat files, Oracle to load into Sybase IQ database.
• Ensuring proper Dependencies and Proper running of loads Incremental and Complete loads
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Designed, developed and managed Universes in Business Objects Designer for generating the marketing reports for marketing group users.
• Created universes for Financial billing system and order processing.
• Resolved loops by creating Aliases and Contexts and checked integrity of universes.
• Created hierarchies in universe to provide the users with drill down in reports.
• Involved in optimizing the universe and SQL tuning to increase the query performance.
• Implemented aggregate awareness to ensure the query is pulling the correct level of aggregation.
• Created many financial reports according to the investment deals, facility and outstanding to know the exact amount of net investment in each deals.
• Developed many standard and ad-hoc reports using features like linking documents, crosstab, sections, breaks, ranking, filters, input controls and scheduled reports in Infoview.
• Involved in preparation of Technical design documents.
• Involved in migration, UAT and solved the issues raised by users before migrating to Production.

Confidential

SAP BODS Consultant

Responsibilities:

• Involved in SAP BODS - design, develop, optimize and support MDM processes, including performance tuning of existing processes.
• Worked extensively on BODS Administration tasks; Installation and upgrades, Creation of JOB Server - Monitoring and scheduling the jobs, Creation of User, Creation of Repository. DBA Activity (Creation of the database and monitor database growth) and Trouble shooting.
• Worked on MDM suite of tools to design, develop, optimize and support MDM for various domains. Lead the performance tuning of existing processes
• Managed the partnership with Data Integration Hubs around data modeling, data mappings, data validation, hierarchy management and overall security. Provide continuous enhancement and review of MDM matching rules, data quality and validation processes
• Developed, optimized and supported Informatica PowerCenter components to provide MDM ETL processes for data extraction, transformations and loading of data
• Define, configure and optimize various MDM processes including landing, staging, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries, cleanse functions, batch groups and packages using Informatica MDM
• Define, configure and optimize various MDM processes and stages including data ingestion/acquisition, standardization/enrichment, harmonization and data provisioning using MDM tools

Confidential

SAP BODS Consultant

Responsibilities:

• Participate in Data Mapping workshops and follow-up meetings with the client business and IT teams. Assists in data mapping and GAP analysis between source and target data in BODS as per the blueprint.
• Configured Business Objects Data Services (BODS) to invoke IDOC interface to load data in SAP.
• Worked with Functional SAP/ERP teams closely to understand the gaps, coordinate with business on specific business rules, work with data migration programmers on transformation rules and meet project standards using proven data load tools and methodology.
• Worked extensively on BODS Administration tasks; Installation and upgrades, Creation of JOB Server - Monitoring and scheduling the jobs, Creation of User, Creation of Repository. DBA Activity (Creation of the database and monitor database growth) and Trouble shooting.
• Prepare technical specification document.• Work on the technical details for transforming existing data onto SAP using tools such as BODS & Oracle DB. SAP HANA Data Loading using BODS etc.
• Coordinate with business on specifying rules required to cleanse, standardize existing legacy Master data to meet universal standards using industry proven unique Cleansing Methodology.
• Design/develop/Unit Test all ETL routines in BODS.
• Modify or create new Data Services jobs within DMF to meet project requirements.
• Data cleansing process (Cross reference value changes, Data standardization, Obsolescence, De-duplication, USPS based Enrichment); Execute Transformations.
• Coordinate with technical teams regarding client transports, testing strategies etc.
• Identify data quality issues, provides recommendations for improvement / resolution. Prepare input/output reports and assist business analyst in preparing reconciliation reports.
• Monitor and assist data load team

Confidential

SAP BODS Consultant

Responsibilities:

• Prepare technical specification document.• Work on the technical details for transforming existing data onto SAP using tools such as BODS & Oracle DB.
• Coordinate with business on specifying rules required to cleanse, standardize existing legacy Master data to meet universal standards using industry proven unique Cleansing Methodology
• Enhancement SAP PS functionality in progress calculation method for Project (Percentage of Completion, S-Curve, Earned Value Analysis, etc.).
• Involved in this challenging SAP Engineering, Construction, and Operation (EC&O) project as Project System (PS) team lead. Carried out the Legacy data migration activity for UPM SAP Rollout Project.
• Data Migration for PM module which includes data filtering, creation of LSMW program for data upload, uploading data through LSMW and BDC program.
• Worked for testing activity for the Rollout project. Worked on RWD recording for training material preparation
• Data Migration for PS module which includes creation of Master Templates for data migration master data, data filtering, creation of LSMW program for data upload, uploading data through LSMW & BDC program,
• Preparation of Functional specifications for ABAP Developments. Took the lead in developing migration/load procedures (LSMW) for Material Master and Vendor Master for a global harmonized SAP system.
• The system will create a single, integrated ERP (ECC) system all manufacturing sites in different countries. Once the core system is in place all countries will start to roll-out their data into the system.
• Also authored the Master Data Guidelines for Country roll-outs. Wrote the Functional Specification, developed the Quality and Production test specifications and cut-over plan.
• Worked closely with the business and integration management during all the phases of the project. Provided consultancy to the Pilot Country Roll-Out projects.