SUMMARY

• 9+ years of total IT experience with strong development, Administration and architectural knowledge as SQL Developer, Oracle DBA and Business Objects Data Services.
• Over 6 years of experience with Sap Data Services and data integrator as an ETL tool and over 2 years as a DBA in installation, upgrade, performance tuning in Oracle 12c/11g/10g/9i on various platforms.
• Used Data Services within SAP BI staging process for data quality.
• Developed and supported in Extraction, Transformation and Load process (ETL) using Business Objects Data Services to populate the tables in Data warehouse and Data marts.
• Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Developed complex mappings in Data Integrator to load the data from various sources into the Data Mart, using different transformations like Query, Table Comparison, Merge, Pivot, Reverse Pivot, Lookup, Key Generation, History Preserving, Date Generation, Map Operation and Validation etc.
• Extensively involved in studying the business requirements develop the mapping specifications from the business requirements and the data model. Involved in data modelling and design of the data warehouse.
• Created repositories (Local, Central, Profile and Cleansing) and configured them with Designer, Management console.
• Strong experience in Data Warehousing and ETL.
• Performed Migrations from different data sources to Business Objects.
• Worked with ABAP workflows and IDOCS to extract and to load data in SAP.
• Applied critical patches using oracle utilities.
• Developed the data warehouse to support day-to-day analysis.
• Knowledge on Matapedia category and creating custom cleansing package using Information Steward 4.0.
• Worked on Software Development Life Cycle in Dev, Test, Prod from end to end.
• SDLC (Software Development Life Cycle) Methodology.
• Strong background in designing and deploying end to end integrated solutions with SAP SRM from information gathering to realization.
• Good Experience in usage of direct and conventional path methods for SQL Loader to insert data from flat file to oracle tables.
• Knowledge in Qlikview server and Publisher maintenance.
• Experience in complete project life cycle including documentation, analysis, development and testing.
• Flexible to adopt new environment and willing to learn new technology.
• Excellent technical, communication, interpersonal skills with problem solving skills in real time environments independently and in a team.

TECHNICAL SKILLS

Database: Oracle 12c/11g/10g/9i, SQL Server 2008, 2012, MySQL, DB2, Netezza 4.x.

ETL tools: Business Objects Data Services XI 3.2, 4.0, 4,1 (Designer, Repository Manager, Management Console, Server Manager), Information Steward 4.0, SAP Postal Soft ACE & PRESORT.DQM4SAP solutions 4.0, Informatica Power Center.

Utilities: Oracle 9i Application Server, Export and Import, Data pump, RMANSQL* loader, Toad, PL/SQL, DB Solo 3.0, Erwin Data Modeller, PerlPutty, Log Miner, Information Analyzer, Infosphere Discovery, C++, Unix.

Platforms: Windows XP/2000/NT, Linux (Red Hat), HP UX, AIX, Sun Solaris.

Networking: TCP, IP Addressing and sub netting, static and dynamic routing.

Job Scheduler: Autosys, CronJob, Tidal and BODS.

PROFESSIONAL EXPERIENCE

Confidential, GA

SAP BODS Team Lead

Responsibilities:

• Working with offshore to get the development in 4.0 for batch jobs based on the functional spec and review the code if it matches the technical standards and complete unit testing.
• Transported the code from Development to Quality and then from Quality to Production.
• Mapped the data from various sources to the target systems based on the requirements.
• Created local repositories for each developer.
• Analyzed the database and provide detailed information on their operational and Forecast for future years.
• Extracted the data from Legacy system after creating data stores using ODBC connection.
• Extracted the data from different sources such as flat file, SQL Server and made the required transformation to load the data into the target database.
• Supported all HFM jobs and Anaplan jobs and reconciled the data between SAP and EDW.
• Worked extensively in splitting the files from 2GB to divide into 10 batches (Each of 200 MB) because of firewall restriction between the servers.
• 24X7 support whenever there is an issue in any environment.

Environment: SAP Business Objects Data Services 4.0, 4.2 (Designer, Management Console), SQL Server 2012, SAP ECC, SAP PI, SAP BI.

Confidential, Neenah, WI

SAP BODS Team Lead

Responsibilities:

• Designed and developed the jobs in BODS by understanding the functional specification and mapping document.
• Mapped the data from Netezza database, flatfile to SQL Server database based on the requirements.
• Generated reporting table as per the business requirement.
• Analyzed the database and provide detailed information on their operational and Forecast for future years.
• Based on the requirements, extracted the data from Legacy system after creating data stores using ODBC connection.
• Extracted the data from different sources such as flat file, SQL Server, Netezza database and made the required transformation to load the data into the target database.
• Worked extensively with transferring the files from one location in KC folder to the history folder. Implemented while loops for transferring multiple files.
• 24X7 support whenever there is an issue.

Environment: SAP Business Objects Data Services 4.2 (Designer, Management Console), SQL Server 2012, Netezza NPS 4.x, SAP ECC, MS Office.

Confidential, Bolingbrook, IL

SAP BODS Designer/Team Lead

Responsibilities:

• Involved in installing & configuring SAP Data Services 4.0, 4.1.
• Worked on imported stored procedures from the database into the data store and used that stored procedures in our jobs to be executed.
• Analyzed the database and provide detailed information on their operational and Forecast for future years.
• Based on the requirements, extracted the data from Legacy system by creating data stores using ODBC connection.
• Strong and efficient Governance, Risk Management and Compliance.
• Processed the records in SAP using BAPI function calls.
• Extracted the data from different sources such as flat file, SQL Server 2005, 2008 and made the required transformation to load the data into the target database.
• Designed the jobs in BODS so that the offshore team builds these jobs by seeing the technical specification and mapping document created by understanding the functional specification.
• Worked on processing BW Process Chains to be executed in BW and load the data into the tables.
• Mapped the data from SQL server database, flatfile to HANA systems.
• Also worked extensively on ABAP to get the data from ECC tables and load them into target database.
• Worked with data profiling tools(SAP Information Steward 4.0) for ongoing project to understand the quality of the data before loading into SAP.
• Worked on data quality management using Information Steward and did extensive data profiling.
• Worked extensively on global variables and parameters in BODS 4.1.
• Created custom functions in Data services to use them in the query transform so this improves performance.
• Encrypted and decrypted the data in the database using BODS built in functions.
• Worked in highly complex integrations which involved to build complex XML structure as target by using XSD file.
• Lead the team of 6 members for completing couple of projects.
• Created a dummy file using flat file structure by processing commands through windows.
• Implemented the Data Enrichment step as per the AIO schema.
• Moved the jobs into QA and production through central repository.
• Monitored the performance and suggested with some changes to improve the performance.
• 24X7 support whenever there is an issue.

Environment: SAP Business Objects Data Services 4.0, 4.1(Designer, Repository Manager, Management Console), SQL Server 2005, 2008, 2012, Information Steward 4.0, Oracle 12c, HANA, MS Access 2000, SAP ECC.

Confidential, Waukegan, IL

Data Services Consultant

Responsibilities:

• Installed & configured Data Services XI 3.2.
• Scheduled the jobs so that the job scheduler run the jobs automatically every day.
• Build dimension and fact tables according how the users use for building their reports.
• Based on the requirements, extracted the data from Legacy system by creating data stores using ODBC connection.
• Implemented the Data Enrichment step as per the AIO schema.
• Moved the jobs into QA and production through central repository.
• Developed datawarehouse tables in Oracle R12.
• Owned DQM for SAP solutions and BO PostalSoft applications.
• Administered DQM for SAP Solutions for ECC.
• Developed Real-time jobs for Address validation and Customer dedupe services.
• Extensively used informatica debugger to figure out the problems in mapping.
• Monitored the performance and suggested with some changes to improve the performance.
• Worked on building ETL code for financial objects such as AP, AR, Pending Transactions (which is scheduled every one hour for the users to get the new transactions as per the requirement).
• Data cleansing according to business requirement using Information Steward 4.0 and this can also be performed in Information Analyzer.
• Worked on CDC (change Data Capture) on both Sources and Target level for SCD (Slowly Changing Dimension) Type1, Type2, and Type3.
• Coordinated with the BI team for custom development of data sources to create ODS (Operational DataStorage) as required for various reporting purposes.
• 24X7 support in production whenever there is an issue in production.

Environment: SAP Business Objects Data Services XI 4.0 SP1(Designer, Repository Manager, Management Console, Server Manager), Information Steward 4.0, Oracle 11g, MS Access 2000, Windows 2003 server/XP.

Confidential, Houston, TX

Data Services Lead

Responsibilities:

• Installed & configured Data Services XI 3.2.
• Created the Local Repositories, Central Repositories, Profiler Repositories in DB2 and configured the Local, Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3.
• Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
• Based on the requirements, extracted the data from Legacy system by creating data stores using ODBC connection.
• Extracted the data from R3 table and generated the lookup tables.
• Implemented the Data Enrichment step as per the AIO schema.
• Proposed and developed custom loading jobs, when the expected results were unexpectedly failing at BW end.
• Created new objects end to end mapping from staging followed by mapping, validation, enrichment and carried out the segment through IDOC.
• Loaded the data into SAP using LSMW, IDOC’s and ABAP Load process.
• Used different transaction code to process the IDOC’s, check the IDOC status, and also for seeing the log extracts.
• Moved the jobs into QA and production through central repository.
• Monitored the performance and suggested with some changes to improve the performance.
• Involved in data cleansing activities.
• Involved in create general and advanced profiling and check the duplicate values and sorted out and cleansed the required data according to the business requirement using Information Steward 4.0.

Environment: SAP Business Objects Data Services XI 3.2 SP1(Designer, Repository Manager, Management Console, Server Manager), Information Steward 4.0, SAP ECC 6.0, SQL server-2008, MS Access 2000, Windows 2003 server/XP.

Confidential, Fort worth, TX

Data Services Architect

Responsibilities:

• Installed & configured Data Services XI 4.0 SP1 in Development & Production Server.
• Created the Local Repositories, Central Repositories and configured the Local, Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3.
• Automated the Informatica jobs using UNIX shell scripting.
• Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
• Based on the requirements, extracted the data from IBM Main frames by creating data stores using ODBC connection.
• Participated in meeting with SAP functional team and Legacy team for getting the mapping to load the data into Customer Master IDOC (DEBMAS06).
• Created the user security in IPS and created DS Developer and Admin roles.
• Worked on data assessment(Data-Insight) in information steward
• Extracted the data from R3 table and generated the lookup tables using ABAP dataflow.
• Implemented the Data Enrichment step as per the AIO schema.
• Used WE05 transport code to check the IDOC status.
• Moved the jobs into QA and production.

Environment: SAP Business Objects Data Services XI 4.0 SP1(Designer, Repository Manager, Management Console, Server Manager), SAP ECC 6.0, Oracle R12, SQL server-2008, MS Access 2000, Windows 2003 server/XP.

Confidential, Pittsburgh, Pa

Data Migration Consultant/DBA

Responsibilities:

• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g, SQL server 2005 and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, SQL, Filter, Expression and Update Strategy.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Tuned the Informatica mappings for optimal load performance.
• Worked on the loading the full load and delta load. Used the scripts and custom functions to manage the delta load.
• Gathered Functional requirements from the business team to get the proper mappings done.
• Involved in moving the jobs to QA and production environment and tested in the QA environments.
• Documented installations and mapping rules.

Environment: Informatica Power Center 8.6, SQL SERVER 2005, MS Access 2010, Windows 2008.

Confidential

Oracle DBA/SQL Developer

Responsibilities:

• Installation and Creation of Databases based on specifications.
• Creating, managing and maintaining Table spaces, Partition Tables, database structure, Storage Allocation, Table, Index and Rollback segments.
• Server managed Backup using RMAN, Logical Export and Import, developed scripts for Cold & Hot Backups.
• Tuning the databases for optimization and Analyzing SQL queries using Explain Plans, TKprof, SQL Trace, Dictionary Views, Stats pack, Utlstat.
• Creating Users and maintaining System Security, Defining profiles and Roles with suitable Permissions, Synonyms, Views, Sequences, Contexts for stored Procedures, Packages & Triggers.
• Supported developers during batch jobs to increase rollback segments and Archive log space for additional month end updates to the system.
• Allocating system storage requirements, Capacity Planning and troubleshooting the database.
• Data Loading from Flat files using SQL*Loader.
• Maintenance of Development team on various Servers.