SUMMARY:

• Having 18 - years IT experience involved in Semiconductor, Energy & Utilities, Oil & Gas, bank. retail, construction and pharmaceutical sectors.
• Broad knowledge on data integration, data migration, data quality and data modeling.
• Experience using SAP Data Services (BODS), Microsoft SSIS,JAVA and Microsoft technologies
• Exceptionally Motivated Track record that shows adaptability, willingness to learn, collaborate and work with multiple stakeholders for strategic and operational goals . Out-of-the-box thinking and provide solutions in cross functional domains including customers for Global Clients in various industries.
• 11 years of experience in implementing data migration projects including requirement specifications, detailed Functional and Technical documentation for ETL Process.
• Extensive experience in IT Industry involving Software Analysis, Design, Implementation, Coding, Development, Testing and Maintenance with focus on Data warehousing applications using ETL tools like SAP BODS and Microsoft SSIS.
• 9+ years of experience using SAP BODS, 2+ years in using Microsoft SSIS.
• Expertise in integration approaches like EAI, EII & ETL
• Knowledge in building analytical reports using HANA,SAP BO & Qlik
• Understand the overall business requirements create the design & architecture for data integration from disparate source systems
• Extensively used ETL methodology for performing Data Profiling, Data Migration, Data Cleansing, Extraction, Transformation and Loading using various ETL tools and designed data conversions from wide variety of source systems including Netezza, Oracle, DB2, SQL server, Teradata, Hive, Hana and non-relational sources like flat files and XML
• Exposure to build java REST client for retrieving data from source system by invoking API’s.
• Extensively worked on DMS (document management system) migration to SAP.
• Experience in performance tuning of transformations, tracing the bottlenecks and errors in mappings to execute ETL Process.
• Participate in business requirements validation and verification ensuring that all projects are consistent with strategic architecture
• Involved in performance testing of ETL development - applied different performance optimization techniques applicable for data services
• Consulting business stakeholders to evaluate interface between legacy &Target Systems, performance analysis, fail over cases strategies, risk mitigation and resolve customer problems
• Expertise with Relational Databases including Oracle 12c,11g,10g, 9i,8i, DB2, MS-SQL Server 2014/2012/2008/8.5/7.0 and MySql 5.0/4.0
• Expertise in Client-Server Application development using Java, J2EE.
• Worked extensively on VERSATA J2EE based rapid application development tool.
• Hands-on experience on Information Steward 4.X for Data Profiling, Rules Creation & generating Scorecards and Master Data cleansing
• Data quality at all phase of migration projects using SAP Information Steward.
• Real-time data replication using SAP Landscape Transformation Replication Server (advanced way of replicating huge data from SAP) into in-memory database SAP HANA
• Effective Leader, Motivator, Decision Maker, Problem Solver and Team Player with excellent Planning, Coordination, Time Management, Supervision and Organizational Skills.

SKILL:

ETL Technologies: SAP BODS 3.2/4.2,Microsoft SSIS, knowledge in Informatica.

SAP Technologies: HANA, HANA XS Engine, Information Steward, SLT, ISU.

Reporting Technologies: SAP BO, Tableau, Qlik

Database Technologies: Oracle12c,11g,10g,9i, 9.0.2.5/8.1.7/7. x,PL/SQL,MS- SqlServer 2015/2012/2008 , DB2UDB10.x/ 9/8.1/7.2/7.1 , Sybase and Oracle JD Edwards

JAVA EE Technologies: JAVA EE 7/6/5,Java2.0, Servlet3.0 /2.x, JSP2.3/2.x, JDBC 4.0/3.0/2.0/1.0 , HTML, DHTML,XHTML and JavaScript

Web & Application Servers: Tomcat, Websphere, JBoss.

Special Software: Remedy User, Swagger, Postman, Service Now, Putty, WinSCP, Citrix ICA Client, ERwin

Operating Systems: SuSE Linux 12/11.x/10.x, Red Hat Linux 7.0/6.x/5.x, Solaris 10, 9, 8 & 7, AIX 7/6.x/5.x/4.33, HP-UX 11.x/10.x,Windows 2012/2008/2003 Advance Server, and Ms-Dos.

Languages: C, C++ and PERL scripting

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Data Migration Project Lead

Responsibilities:

• Analyzing information to determine, recommend and plan GES (Global Execution System) projects and prepare functional specifications, design document technical specification to meet the actual business process.
• Acquire and interpret business requirements, create technical artifacts, and determine the most efficient/appropriate solution design, thinking from an enterprise-wide view.
• Working in the Data Integration Team to perform data and application integration with a goal of moving more data more effectively, efficiently and with high performance to assist in business critical projects coming up with huge data extraction.
• Built components to synchronize data between legacy (oracle) and SAP systems, data migration between Oracle to SAP ERP.
• Interacted with functional team and source owners regarding data requirement gathering, Designed functional, technical, Data mapping design documents from business requirements.
• Worked with SAP Functional Consultants, Business users, IT Subject Matter Experts and responsible for analyzing and mapping existing Legacy System Data to SAP.
• Developing java REST client for retrieving data from source system by invoking API’s
• Utilizing Jersey Rest Client for invoking REST service and used Jackson API for processing JSON response.
• DMS( Document Management System), Extensively worked on migration of legacy documents as attachments into target systems by using sap BAPI.
• Utilized DRAD,DRAW,CHDR tables to check document availability before loading into target system.
• Created reconciliation batch jobs to ensure the data load consistency.
• Involved in debugging the ETL processes and applied various business validations before loading the data into the target System.
• Planning test strategies & testing approach to avoid conversion risks to maintain consistent SAP material master data.
• Syndicating & Reverse syndicating business critical data for EDW(Enterprise Data Warehouse) users, Supply Chain Management users, Legacy business users.
• Responsible for code migration from DEV to QA, Preprod and Prod in all landscapes using the Release Management Strategy.
• Interacting with business stakeholders to evaluate interface between legacy & target systems, performance analysis, fail over cases strategies, risk mitigation and resolve customer problems.
• Profiling master data (zfabs, zsrts, ferts, boms) out of source systems using SAP Information Steward.
• Using BODS and Information Steward, create and run validation rules to perform data quality assessment, identify and analyze bad data and monitor data quality through scorecards for BOM completeness,BR Completeness, Material Master Storage Location, Warehouse, Cost check etc.
• SLT Realtime replication into HANA system and synchronizing data into oracle for SCM reports.
• Developed HANA calculation views and built analytical reports using Qlik & SAP BO .

Technologies used: BODS 4.2, SLT, HANA 2.0, HANA XS Engine, Information Steward, Oracle 10g, SQL Server DWH, Business Objects, Qlik, SAP BO and SAP ECC 6.0,Java 7,Jersey Rest Client, Jackson API.

Confidential, Santa Clara, CA

Data Migration Project Lead

Responsibilities:

• Explore prebuilt source system APIs, mappings, develop and maintain data sets as needed for target system using SAP BODS
• Worked on postman tool for API testing/verification.
• Worked in Customer master Harmonization. Implemented Data Quality and used Information Steward for quality related jobs.
• Using SAP BODS, data from the staging table is processed and cleansed of the junk data based on business requirements. Based on the criticality of the validation, messages or exception was registered in the underlying table and raised at data services level.
• Implemented Data Quality and used Information Steward, SAP BODS for quality related jobs.

Technologies used: BODS 4.1, Java 7.0,Oracle 10g, SAP ECC 6.0,SAP Information Steward 4.1,4.2, Postman.

Confidential

Data Migration Module Lead

Responsibilities:

• Data migration using BODS to consolidate onto a single SAP platform and participated in Data Archive project
• Implemented ISU asset repository system to carry out the Asset maintenance through scheduling in ECC for metering business of Confidential which migrates data using BODS from existing SAP ECC system to ISU and build new reports in ECC and ISU.
• Interaction with Business process owner's and SME's to Identify the Data Cutover, Data quality and Historical data Requirements.
• Worked with SAP on Archive Project Architecture.
• Interacting with the Architect for the requirements and data type conversions and resolving the data issue at the time of development
• Created different transformations for loading the data into oracle database e.g. Query transformation, Merge, pivot, Case, Table comparison, Key Generation and map operation transformation

Technologies used: BODS 4.0, Oracle 10g, SAP ECC 6.0, Toad, SAP ISU, SAP Netweaver ILM

Confidential

SAP Technical Lead

Responsibilities:

• Interacting with the Business analysts and the IT Process teams in gathering the business requirements to design and develop integration project.
• Performed data manipulations using various SSIS transformations like DataflowTask,FileTP task,FlatFileSource,OLE DB Source,OLE DB Destination,Lookup,Merge,Merge Join,Sort,Union All and many more.

Technologies used: Microsoft SSIS, Oracle 10g.

Confidential

Sr Project Leader

Responsibilities:

• Designing, Implementing, utilizing Java tools in business, web and client server environments
• Implementing EAI (using SAP XI/PI) & ETL (using SAP BODS) projects.
• Worked as a BODS developer in production support team for Supply Chain Management in ETL.
• Key responsibility is to ensure safe transfer of data from source systems to ETL source staging area and from ETL target staging area to the target system
• Deploying and Configuring Dev, Integration, QA, UAT, Prod and DR environment.
• Working on Rapid Mart and Ds Jobs in different areas like Account payables, Account receivables and production planning, warehouse management, COPA.
• Involved in gathering the requirements, understand the current LDWH, prepared design data flow of adopting EDW by implementing SAP BOBJ CC & GL Rapid Marts Rapid Marts
• Scheduled Batch jobs using Data Services Management Console.
• Preparing the Root Cause Analysis documents in case of major issues.
• Performed reverse engineering of ETL interface specific jobs.
• Involved in rectification of load failure errors like Master Data loads and Transaction data load.
• Direct interaction with clients regarding any deliverables, issues or knowledge transfer.
• Designed and developed the automated trading software for Back testing historical trading data in java platform using Versata.

Technologies used: BODS 3.2, Oracle 10g, SAP ECC 5.0, SAP XI/PI,SQLDeveloper, SAP RAPID MARTS and Versata.

Confidential

Developer

Responsibilities:

• Worked as a team with functional analysts and business analysts in designing, developing, testing, implementing and supporting Java & Microsoft applications.
• Involved in implementing specific functions and coding for specific requirements according to the initiative
• Involved in SDLC
• Involved in Manual, Black Box and Unit Testing
• Coordinating with client for delivering quality of solutions developed the web pages by using the html and Java script
• Developed the database retrieval and validations by using the JSP and java script

Technologies used: Windows 2000, Oracle, Tomcat, JSP, Java, Servlets, Software Ms SQL Server, Visual Basic 6.0.