SUMMARY:

• In - depth knowledge of programming
• Proficiency Information Steward
• Strong conceptual and schematic design skills
• Strong technical detailing skill
• Project planning
• Proficiency in SAP BODS & DQM technology
• Team player
• SAP Data Services Administration
• Off-shore project co-ordination
• SAP HANA with SP6
• Increased core system availability by developing standards and architectural governance and best practices.
• SAP BODS/DQM/Information Steward
• RFC & Job server configuration experience
• Proficient in implementing DQM transforms Address Cleansing, Match & Geocode transforms for real time address cleansing like Geocode address suggestion and batch jobs
• Implemented SAP Information Steward solutions for close to 2 years using Data Insight components -Rules, Score Card, Metapedia.
• Implemented DQM & BODS jobs as Web Services in real time jobs for address suggestion list
• Developed jobs to handle multi-billion data load jobs in an efficient manner with traceability & recovery for all jobs
• Handled heterogeneous DB’s like SAP (DB2),BW, Sales Force, Flat Files, Confidential, MS SQL Server & Oracle as source and targets
• Expert in designing Full-push down & process slicing jobs, which improves the data load performance with minimal consumption of DS Resources
• Implemented SAP BODS/DQM best practices
• Proficient in implementing the transformations MAP-CDC, Hierarchy - Flattening, Table Comparison, MAP-Operation, Validation, Case & Merge
• Information Steward exposure
• Collaborated on client engagement strategy to drive entry into risk-driven project methodology, improving accuracy of project definition, sizing estimates, and yearly resource budget planning
• Improved client relationships and project predictability through shared business and technical perspectives, agreed project roles, risk assessment, use cases, transparent business-aligned development efforts, and time-boxed delivery
• Completed business requirements analysis including the evaluation of systems specifications for Enterprise Application Implementation
• Developed and communicated Web site usage, security policies and standards to all users
• Established policies and procedures for applications in conjunction with the company policy
• Identified, recommended and prioritized new features and applications in conjunction with business leaders and department managers.
• Developed, coded, installed, tested, debugged and documented
• Managed complex BI/DW deployment programs, facilitating acquisition of business requirements
• Prepared design specifications, developed reporting and analytics, tested and managed user adoption
• Managed and implemented successfully multiple off-shore model projects

TECHNICAL SKILLS:

Languages: Crystal Reports 2008, Xcelsius 2008,SQL,Crystal Reports XI, Business Objects, VB Script, Visual BasicPower Builder, PFC, C#, J2EE, HTML, SAP Data Warehouse, XML, XSL

ETL: DTS, Data Integrator, Data Services 3.2/4.0, Information Steward 4.0 DQM

Methodology: AGILE & ASC

ERP: SAP BW, SAP R3 FICO, SAP Rapid Marts, SAP BPC 5.0(Outlook Soft)

Testing Tools: Win Runner

Databases: MS SQL Server, Sybase, Oracle, MS Access, DB2, UDB

Operating System: MS - DOS, Windows, AS400, LINUX & UNIX

Data Warehousing: Manhattan

Tracking Tools: PVCS and Visual Source Safe

MS-Suite: MS-Office Suite, MS Project

PROJECTS HANDLED:

Confidential, Atlanta, GA

Environment: Data Services XI4.2, Confidential 15, SAP 4.6, SQL Server 2008,Linux

Administrator

Responsibilities:

• At Delphi, implemented Confidential 2.3 for Purchasing, Revenue, Accounts Payable and Master Data
• Server setup and configuration
• As part of this implementation, Installed IPS4.0, Data Services 4.2 SP2 - Linux version & SQL Server 2008
• Integrated the environment with Teradata15 including Confidential fast load utilities.
• Tasks include repository creation, configuration, RFC configuration, user setup, Job server configuration and system configuration.
• Configured Confidential product for data extraction for AP,RV,MDM & PU modules from SAP 4.6 and load to Confidential target
• Performance tuning for better data loads from SAP to Confidential
• Model extensions to meet business needs.

Environment: Data Services XI4.0, Confidential 15, SAP ECC, Information Steward 4.0

Architect

Confidential

Responsibilities:

• At Confidential working as an Architect for implementation of Confidential tool
• Working as a POC Architect for multiple customers for TAS Implementation projects and analysis of existing environment, Technical recommendations for best ROE
• Experience in SAP ECC configuration which is required for TAS implementation
• Implementation of Master Data solution using Information Steward
• Creation of Rules, Binding Rules, Score Cards creation and implementation
• Extraction of large volumes of data from SAP ECC to Confidential DB using SAP Data Services with creation of Semantic Layer, BI Layer and Data Model extension as per the customer needs
• Master Data cleansing and recommendations to reduce cost per record maintenance

Confidential, Atlanta, GA

Environment: Data Services XI4.0, MS SQL Server 2008, SAP BW, XML Files

Architect

Responsibilities:

• Tasks include Blue Print discussion, Architecting the solution & implementation.
• Involved in design and implementation for the activities like extract multiple XML files data, parse it, define the business rules, data massaging, build the relationships between multiple data objects and load it to SAP BW system.

Confidential

Environment: Data Services XI4.0, SAP HANA SP 7.0

Architect

Responsibilities:

• My role in this project is to design the POC solution to load Billions of records from Confidential to SAP HANA System and prove the performance of SAP HANA System.
• Technologies used SAP Data Services 4.0, Confidential, SAP HANA, Flat Files & SAP Business Objects

Confidential

Environment: Data Services XI4.0, MS SQL Server 2008, Confidential 13.0, Flat File

Architect

Responsibilities:

• The scope of this project is to load retailer specific POS data from multiple flat file systems to Confidential by utilizing SAP Data Services transformations.
• Admin activities like setup the QA & Prod environments, security, local & central repository setup, Tivoli job scheduling, job migration, Optimization and production planning.
• As an Architect I designed a solution to on-board multiple retailer’s data load with single table driven approach v/s retailer specific table/DS job approach.
• Data Services 4.0 used as an ETL tool for loading data from flat file to DB with required transformation lookups and data format. Merge, Query, Validation transformations were used for data load.
• Confidential Parallel Transport (TPT) was implemented for faster load. Around 89Million records are loaded from 1289 flat files in 15minutes.
• Confidential SQL scripting task for creating views & macros.
• With this solution on-boarding a retailer is less than 2days compared to 3months with the retailer specific approach and the solution I proposed is more robust and dynamic with no hard coding etc.
• The solution also provided alert system with job specific details for all the recipients in each environment.

Confidential

Environment: SAP ECC6.0, SAP BW, Data Services XI4.0, Business Objects XI 4.0BPC 7.5

Senior Lead Consultant

Responsibilities:

• Admin activities like setup the QA & Prod environments, security, local & central repository setup, Tivoli job scheduling, job migration, Optimization and production planning.
• As a senior lead consultant, analysed end to end performance and implemented optimization process in Data Services which improved the performance and able to load 6 to 7Bln records in 14.3hours.
• I am involved in discussions with various teams from support, admin DBA & Network teams to any data failures and latency issues.
• The data loads performance improved by 45% after the optimization.

Confidential, Indianapolis, IN

Environment: SAP Rapid Marts, Oracle 10g, Business Objects XI R3.2, Data Services XI3.2Data Quality XI3.2

Senior Consultant

Responsibilities:

• This position is for implementing SAP Rapid Marts3.2 for multiple functional modules.
• Make effective & feasible recommendations for implementing the solution.
• My role is analysing SAP Rapid Marts, development, and design of BO Universe, WEBI Reports, workflows & data flows for data transfer from SAP R3 to BO Data warehouse.
• Admin activities like job scheduling, job migration, Optimization and production planning.
• Integration of Accounts Payable & Purchasing Rapid Marts.
• Implemented SAP DQM transforms for Address Cleansing, Match & De-Duplication
• Rapid mart module customization per customer requirements.
• Type2 data history preservation implemented using Map Operation & History Preserving transforms.
• Performance Optimization was implemented using Pull Push Down, Process Slicing & Degree of Parallelism techniques.
• Out of the box data flows & workflows verification in using Data ServicesCreation of new workflows, data flows or customize SAP provided workflows, data flows & Universes to meet the customer needs. Recoverable jobs, workflow creation & modification.
• Implementation of Data Quality Blueprint packages like Data Quality - USA, Data Quality - UDC & Data Quality - Custom Functions.
• Analysis of Data Services 4.0 for future migration from Data Services XI3.2
• Assist offshore team in development activities & monitor the tasks.

Confidential, Detroit, MI

Environment: Crystal Reports XI/ 2008, Oracle 10g, IKA System, Solomon, Business Objects and Xcelsius 2008

Report Lead

Responsibilities:

• Installation and configuration of Crystal Report Server 2008/Tomcat on Windows 2008, X64bit environment.
• Administration of Crystal Report Server 2008, SSO configuration, migration of reports to Crystal Reports 2008 from Crystal Reports XI.
• Involved in migration of Unix based claim system (DST) to Web based claim system (IKA).Analysis of migration data, verification of end to end business process, identifying the issues, discussion with users on implementation.
• Development of Dashboard reports using Xcelsius like membership growth, sales growth, claims frequency. What if analysis of the duplicate claims by multiple submission from PCP & providers.
• Development of Stored procedures, Views and Oracle db administration.
• Development of Accounts Payable & Accounts Receivable reports using Crystal Reports XI.
• Report publishing on Web interfaces like WEBI & SharePoint servers.
• Provide ad-hoc data for analysis of data.
• Help other report developers with technical & business process.