PROFILE SUMMARY

• Total experience of 6 years 2 Months in IT Industry with focus on Data Migration, Data Warehousing & Data Analytics Solutions. Currently working with Deloitte Consulting LLP as Consultant.
• Experience in SAP Business Objects with specialization in SAP BODS, SAP Information Steward, and SAP HANA.
• Core technical experience in working with projects on Datawarehousing, Data Migration/Conversion, Data Profiling and Data Quality across various sources and targets which includes Flats Files, Excel Files, ORACLE DB, SQL Server DB, SAP BW, JDE and SAP ECC.
• Experience in interacting with client for understanding the functional needs and translating functional needs into technical designs.
• Extensive noledge on various load strategies like IDoc, BAPI and Flat File Load and SAP - BODS Administrator activities.
• Confidential level experience of Informatica.
• Implemented productivity enhancement tools in Data Migration projects using VBA, JAVA and C#.
• Capable of quickly ramping up on new technologies. Known and trusted for speed and accuracy of work.
• Consistently given high performance with top rating for continuous 3.5 years in Deloitte and 2.5 years in TCS.

TECHNICAL SKILLS

Tools: SAP BO Data Services, Informatica, HPQC, SAP Information Steward(IS)

Database: Oracle, SQL Server

Languages: SQL, JAVA, C#, VBA .NET

Operating Systems: UNIX, Windows

Others: SAP System (GUI), TOAD

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst and Data Quality Consultant

Responsibilities:

• Did Data Quality Analysis and reported the data quality issues to the client.
• Assisted the client with useful suggestion on quality data that can be substituted in place of missing and incorrect data values in excel reports.
• Implemented the VBA program in Excel spreadsheets to help client generate fresh reports in required format in just one button click theirby reducing a large number of hours of manual effort.
• Made reports to provide various KPIs available to the client like Data Value Score, Data Readiness Score, Potential Readiness Score, Binary Availability, Rank etc.

Technical Environment: The solution design uses Excel spreadsheet and VBA-Macros to generate reports those are easily readable by business analyst.

Confidential

Data Conversion and Data Quality Consultant

Responsibilities:

• Did Data Quality Analysis and reported the data quality issues to the client.
• Assisted the client with useful suggestion on quality data that can be substituted in place of missing and incorrect data values in excel reports.
• Implemented the VBA program in Excel spreadsheets to help client generate fresh reports in required format in just one button click theirby reducing a large number of hours of manual effort.
• Made reports based on various KPIs mentioned by the client like yearly percentage share of various models at market level, model code level etc.

Technical Environment: The solution design uses Excel spreadsheet and VBA-Macros to generate reports those were being used by Tableau platform to generate more specialized reports.

Confidential

Data Conversion and Data Quality Consultant

Responsibilities:

• Did Data Conversion planning and Solution designing at object level.
• Involved in various stages of the projects covering design, code development and multiple test cycles.
• Developed the Conversion objects such as Functional Location, Equipment Master, GL Balances, Material Characteristics, Pricing and Conditions and guided the team members in other conversions and their performance tuning.
• Executed 3 data conversion cutover cycles from offshore location and 1 go-live cycle from client location-Wichita.
• Designed and developed the strategy for highly optimized code of Material Characteristics using BODS script in 80% of the BODS Code.
• Took over the role of BODS Administrator for 2 mock cutover cycles and 1 Go-Live Cycle.
• Singularly performed Data Profiling activities using Information Steward and Address Data Cleansing using the SAP Address packs in SAP BOBJ Data Services.
• Created the Data Quality Scorecards for end user review using SAP-Information Steward rules.
• Developed automated Excel sheet using C# and VBA .NET for the Confidential to reduce manual effort of team members.

Technical Environment: The solution design uses SAP BODS as the tool for data conversion, SQL SERVER 2008 as database, SAP ECC as source and Target System, SAP IS for data quality and cleansing.

Confidential

Data Conversion Consultant

Responsibilities:

• Developed 6 major object as primary owner- GL Balances, Serial Number Master, Inspection Plan, Internal Orders, Packing Instruction. Inventory IM.
• Single point of contact of ABAP Dataflows which were developed for objects like GL Balances, Sales Oder where large volume of data extraction was done. Also. Contributed a technical paper on ABAP Dataflows.
• Assisted in execution of the data conversion cutover cycle.
• Supported the data migration from JDE and OpEx to SAP ECC System using SAP BODS.
• Data Extraction and transformation using BODS utilities and loading using IDoc, BAPI, RFC, and LSMW based on the scenario.
• Learnt JAVAFX and developed BODS Transport tool for automation of the database migration from DEV environment to QUALITY and to PRODUCTION environment.
• Contributed 2 whitepapers to Deloitte based on experience gained from the Confidential - Data Conversion and SAP Data Services in a Validated Environment & BODS-Strategy to extract large volume of data from SAP.
• Performed unit testing, Integration testing of the conversion objects and instantly debugged the object errors.

Technical Environment: The solution design used SAP BODS for data conversion. Data is pulled from SAP using inbuilt BODS adaptors and from JDE and other sources using file extracts. BODS then transforms the data to an acceptable output, which is then loaded into SAP using IDOCs or LSMW as appropriate.

Confidential

ETL Developer

Responsibilities:

• Developer of RP Staging Layer, Reporting & Analysis Layer and Adjustment modules.
• Involved in Requirement Specifications and Solution Specifications discussion with client, TCS testing and TCS Design team.
• Design, Development and testing of new functionalities using Informatica Powercenter 8.6.1,Oracle,Unix
• Reference Data Environment Preparation, Performance tuning using Informatica.
• Performed debugging of the defects raised by UAT testing team before change deployment to production.
• Developed several mappings using various transformations like Router, Filter, Aggregator, Sorter, Source Qualifier, Update Strategy, Lookup (Dynamic and Static) and Expression etc.
• Implemented SCD2 for Dimension Tables.
• Implemented Adjustment Module for Fact table.
• Implemented Star Schema linking Dimension, fact.
• Prepared Database environment for successful reporting through Fact Tables.

Technical Environment: The solution design used Informatica Powercenter 8.6.1, Oracle, and UNIX for extracting the client transactional data to staging and transforming the data to analytical data and providing it to business users in form of star schema.

Confidential

ETL BODS Developer

Responsibilities:

• Analyzed 100’s of standard business rules to be implemented in various standard conversion programs.
• Assisted in preparing the standard reference document ‘Data Services Best Practices Design Guide’.
• Design, Development and testing of template jobs of Functional Location, Equipment Master and Internal Orders.
• Single point of contact for all the lookup table creation and their updates which are used in various data migration objects across the Confidential .
• Performance tuning of long running jobs of GL Balances, Sales Order, Open AR, Material Characteristics.
• Replicated the ABAP dataflow extraction jobs for around 75 SAP tables that significantly improved the performance of extraction jobs from 2 days to 12 hours.

Technical Environment: The solution design used SAP BODS for data conversion, SQL SERVER as the database, Flat Files as source files and SAP ERP as target system.