SUMMARY:

• Over 13 years of experience in Information Technology that includes 5+ years of experience in SAP BO Data Services applications and over 4 years of experience in SAP Migration Projects on various domains like Retail, Energy Services, Telecom, and Insurance
• 5+ Years of Experience in ETL with Different Versions of Business Objects Data Services/Data Integrator
• Expert skills in Data Services/Data Integrator in design, creation, and implementation of BODS/BODI scripts
• Performed simple and complex transforms in dataflow to write Conversion Technical Designs and build ETL Conversion tools
• Hands on experience of Recovery Mechanism for unsuccessful batch jobs execution
• Experience on Data Extract from legacy data from source systems (SAP and Non - SAP), Data Profiling, Data Cleansing, Data Enrichment and IDOCs
• Set up DS data stores to variety of data sources such as SAP HANA, SAP R/3, SAP BW, Oracle, MS SQL Server
• Used various transformations like Case, Map Operation, Merge, Query, Row Generation, SQL, Validation, Data Cleanse, Address Cleanse, and Match
• Scheduled, monitored, and fixed the errors of the jobs
• Performance tuned Business Objects Data Services Real Time and Batch jobs, complex transformations in Data Flows to improve efficiency
• Experience in setting up Development, Test, and Production environment by additionally setting up a central repository and migration of reusable of objects
• Performed by creating Jobs, Workflow, Dataflow both by Import and Export directly and Check In/Out in Central Repository
• Performed extensively on Cubes, Dimensions and Slowly Changing Dimensions, various Transformations, and Workflows
• Constructed data cleansing and De-Duplication jobs using SAP Info Steward
• Experience in migrating BO Universe, Reports, Dashboard reports, ETL jobs from one environment to another environment
• Working Experience in designing, development, and deployment of complex Universes
• Experience in user training and extensively involved in taking business and technical requirements and basing on that delivered the required reports to the project
• Handled onshore and offshore team by assigning tasks and review code before delivery to the clients including TUT and FUT documents
• Have daily offshore calls to monitor the progress of the team
• Experience working in all phases of the software development life cycle (SDLC)
• Excellent team player, Communication, Interpersonal, Analytical, and Technical documentation skills

TECHNICAL SKILLS:

Languages & Development Tools: SAP BODS, Information Steward, SAP HANA, SQL, PL/SQL

Reporting Tools: Business Objects XI, CMS, CMC, Crystal Reports, Web Intelligence Rich Client, Publisher, Desktop Intelligence XI, Designer, BO Reporter, Web Intelligence, Dash Board Manager, Infoview, BO Auditor, Crystal Xcelsius

ETL Tools: BO Data Services, Data Integrator, Data Quality, Data Insight

Scripting Languages: JavaScript, VB Script, XML

OS & System Utilities: Windows XP/2000/98, Windows NT 4.0, UNIX

Networking Systems: Internet Information Services Server, Apache, Soap UI, FILEZILLA, WINSCP & Web Sphere

DB Systems: Oracle, MS SQL Server, DB2, MS Access, SQL Developer, TOAD

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT, and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.5/4.0

PROFESSIONAL EXPERIENCE:

Confidential, PA

Responsibilities:

• Lead onshore and offshore developers on Technical specifications, Technical Unit Testing (TUT) and Functional Unit Testing
• Created Mapping and Extraction documents for the development to work on extraction and transformation logics
• Worked with client’s team in creating ETL architecture, ETL design, analysis, and development, writing technical specifications
• Write SQL, PL/SQL queries to verify the extraction and transformation job in Oracle and MS SQL Server
• Worked on End-To-End implementation from Extraction data from Legacy database to transformation and loading the files using EMIGAL structure
• Implemented data migration using SAP BPDM Best Practices for Data Migration on Utilities
• Working on different migration objects like Move in, Security Deposit Request, Security Deposit payments, Budget billing planning, Interaction Records, Contract Accounts, and Business Partners
• Implemented extraction and transformation with control loads and with and without validations
• Data analysis on error records and defects in HPQC to analyzed and implement the solution to regenerate the corrected load files
• Executed technical leadership on the use of the technology platform and tools mentoring the offshore for optimal use of BODS in a SQL Server, SAP utilities, and HANA environment
• Established the best modeling and recommended strategies for BODS environment and architecture for SAP HANA4
• Created R/3 dataflow using ABAP and Data Transport
• Pushed ABAP to production with built in Generate ABAP code in directory
• Created Transformations, Update Rules and Transfer Rules using ABAP routines in start routines and end routines
• Populate fields that was not provided by the Source Systems and modified existing data to meet Business Requirements using ABAP
• Provided the cleansed data to load data into SAP CRM to ABAP resources using EMIGAL
• Setup the ABAP data flow for data extracts and setup the shared directories for data loads and ABAP programs for SAP CRM and IDOC interface usingData Services
• Set up RFC server connections in both BODS and BW sides and open Hub in BW side
• Managed onshore and offshore development team and review their project assignments by checking the jobs from Central Repository and executing the jobs manually
• Co-ordinated with offshore and assigned tasks to team and make sure to review the code before check-in central repository
• Review the TUT and FUT documents from offshore to make sure all the code standards are maintained
• Participated in requirement gathering sessions and developed Business Objects Data Services jobs specifications on excel sheets based on information acquired from analysis of source data, user requirements, Business rules and Enterprise standards
• Used Business Objects Data Services for ETL extraction, transformation and loading data from heterogeneous source systems for all migration related activities
• Used various transformations like Case, Map Operation, Merge, Query, Row Generation, SQL, Validation, Data Cleanse, Address Cleanse, and Match
• Used Business Objects Data Services Cleansing transformations extensively for de-duplication, Standardization and Address Parsing Information Steward and BODS (Data Services)
• Extensively involved in Data cleansing and Address Standardizing using USA and Geo Code Latitude & Longitude transforms in Business Objects Data Services Data Quality
• Used Business Objects Data Services interactive debugger to test the jobs and fixed the bugs
• Experience in debugging execution errors using Data Integrator logs (trace, statistics, and error) and by examining the target data
• Verified the extraction jobs to make sure the extraction criteria meet the requirements in BODS by running the workflows and the individual dataflows
• Verified the validation based the EMIGAL structure to validate lookups, mandatory columns, and validate format with check tables from EMIGAL structure
• Verify the enriched structure to make sure it meets the EMIGAL standard to load the file into SAP Utilities
• Verified the generation of ISMW file structure to load the file into EMIGAL
• Verified the enriched tables to validate the requirements
• Worked on SAP tables, doing data conversion, moving data from source to loading table and then to staging table and then target database
• Defined separate data store for each database to allow Business Objects Data Services to connect to the source or target database
• Used Metadata management module in Information steward to discover metadata in universe, reports, dashboard, and SAP BW systems
• Used Impact analysis to view the objects that are affected by data within an object
• Perform Unit testing and Document the results of Unit testing and ETL process as per requirements
• Administering and maintaining BO Data Services management console and Repository management
• Developed various Workflows and Data flows where the data is extracted from the sources like Oracle, SQL Server, and SAP ECC then loaded into staging tables from staging tables data loaded into relational tables and from Relational tables

Environment: BODS, Business Objects Data Services (Data Integrator), ECC, BW, EMIGALL, Information Steward, SAP Power Designer, SQL Server 2008, Oracle 10g, PL/SQL, TOAD, Oracle SQL Developer, UNIX, Window XP/2000/2003 Server, HANA S/4, ABAP/4