Narayana Murthy Pitta
SAP Certified Consultant - BODI XI R2 SUN Certified Programmer [Dec’06]
SAP Certified Consultant - HANA1.0 Linked in Profile https://www.linkedin.com/in/narayanapitta/
Having 19-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), SAP HANA and SAP SLT
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.
ETL ( SAP BODS), Data Quality ( SAP Information Steward )& Other Exposures
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.
Understand the overall business requirements create the design & architecture for data integration from disparate source systems
9+ years of experience using SAP BODS, 2+ years in using Microsoft SSIS.
Expertise in integration approaches like EAI, EII & ETL
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, 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
Hands-on experience on Information Steward 4.X for Data Profiling, Rules Creation & generating Scorecards and Master Data cleansing
Expertise in Client-Server Application development using Java, J2EE.
Worked extensively on VERSATA J2EE based rapid application development tool.
SAP BODS 3.2/4.2, Microsoft SSIS, knowledge in Informatica.
HANA, HANA XS Engine, Information Steward, SLT, ISU.
SAP BO, Tableau, Qlik
Oracle12c,11g,10g,9i,PL/SQL,MS- SqlServer2015, Sybase and Oracle JD Edwards
JAVA EE Technologies:
Web & Application Servers:
Tomcat, Websphere, JBoss.
Remedy User, Swagger, Postman, Service Now, Putty, WinSCP,
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.
C, C++ and PERL scripting
Training on Versata in Exensys Software Solutions Ltd
Training on CMMI level 5 in Exensys Software Solutions Ltd
Corporate Training on SSIS,SAP BODS
Masters in Information Technology from SHIATS University, India.
Bachelor of science in Computer Science from Andhra University, India.
Stryker (Allendale, NJ, US) (May’18– till date)
SAP BODS consultant
Stryker is one of the world’s leading medical technology companies and, together with our customers, is driven to make healthcare better.
Involving in Athena project development activities
Coordinating with onsite offshore teams, handling incidents and closing the tickets on priority base.
Involved with multiple teams to identify root cause and fixing the business data issues
Involved in monthly and weekly sales reports.
Support and perform cutover activities and tasks (tasks related to implementation of development objects or project deliverables in multiple systems).
Implemented BODS batch jobs to extract multiple source systems data and load into SAP HANA system.
Developed preload and post load BODS jobs which determines the data load information for further analysis.
Improved the performance of BODS jobs by using different methodologies.
Responsible for code migration from DEV to QA, Preprod and Prod in all landscapes using the Release Management Strategy.
Environment: SAP BODS,SAP S4, Callidus, SAP BW/4HANA,
Maxim Integrated (San Jose, CA, US) (July’14–Mar’18)
Data Migration Project Lead
GES project is an SAP based solution to replace multiple old Legacy ERP system ( MAXCIM& COMETS) and enable a single integrated Supply-to-Market execution system. The goal is to migrate multiple source systems to SAP also keeping the Legacy systems live by sending back the data created in target to source systems and data synchronizing to EDW
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.
Worked 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.
Designed and developed material master job which loads delta records into target system.
Designed and developed one-time load batch jobs to meet business requirements
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.
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.
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.
Technologies used : BODS 4.2,Information Steward, Oracle 10g, SQL Server DWH,,Java 7,Jersey Rest Client, Jackson API.
Applied Materials (Santa Clara,CA,US) (Nov’13 – May’14)
Data Migration Project Lead
Applied Materials is a leading equipment supplier to the semiconductor, liquid crystal display (TFT-LCD)
and solar PV industries.
Primarily worked on Data Conversion and Data Quality.
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
National Grid USFP (May’12 – Oct’13)
Data Migration Module Lead
NGUSFP (Migration, Archiving & NG metering )
The solution offers data migration from legacy systems to make use of single platform SAP, migration of data from existing SAP ECC system to SAP ISU and build new reports in SAP ECC and SAP-ISU
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 National Grid 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
CSC (July ’10 to Mar’12 ) SAP Technical Lead
Monarch & Eureka : Business units request subsets of Basic Worker Data (BWD), Active, Termed employees data from the ATS with their various internal CSC systems.
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.
Exensys Software Solutions Ltd (April ‘03 to June ‘10)
Sr Project Leader
GSG ( Global Services Group) : Responsible for providing solutions across multiple projects
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.
Worked 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.
GS Soft (Oct 1999 to March 2003 )
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.