Summary

• More than 7 years of experience in Information Technology as an ETL developer, with experience in SAP HANA, SAP BODS, Pentaho and SQL Server Integration Services (SSIS).
• Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, Analytical view and calculated views. Experience in applying privileges.
• Experience in extracting the data from ECC 6.0 and loading into SAP HANA using Data Services 4.2 SP7 as an ETL tool for Data quality.
• Experience in SAP HANA data provisioning using SAP land scape Transformation (SLT) Replication Server.
• Worked extensively with Data Services in designing, creation and implementation of work flows, data flows and scripts and performing simple and complex transforms in dataflow using different data integrator, platform and data quality transforms.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment, and change data capture.
• Worked extensively on integration of BODS with SAP and non - SAP data sources
• Experience in creating, using and maintaining different repositories.
• Experience in creating, and configuring job and access servers.
• Experience in creating different data sources (SAP ERP, SAP HANA, oracle, MS-SQL, DB2).
• Experienced in developing Data Warehouse architecture, ETL framework and BI Integration using Pentaho Reports and Pentaho Dashboards.
• Created PDI Jobs and Transformations in enterprise repositories according to requirement to integrate source data in to Target data warehouse.
• Experienced in executing PDI jobs and transformations on command prompt.
• Experienced in loading data in Data warehouse by using Slowly Changing Dimension (SCD - Type 1, 2, 3)
• Excellent Knowledge in RDBMS Concepts and Data Modeling using SQL power architect, Star and Snowflake Schemas.
• Hands on experience on the whole ETL (Extract Transformation & Load) process.
• Skilled extracting data from heterogeneous sources (Excel, CSV, Oracle, MySQL, MS SQL server, PostgreSQL, flat file, Text Format Data) using Pentaho data integration and SAP business objects data services.
• Experience in designing Database Models using Microsoft Visio and creating class diagrams, activity diagrams, use cases diagrams, sequence diagrams and flow charts using UML.
• Worked on Notification services in setting up the Scheduled jobs and alerts.
• Hands-on experience on Data warehouse Star Schema Modeling, Snow-Flake Modeling, FACT & Dimension Tables, Physical and Logical Data Modeling.
• Experience in Installations, Up-gradations, Configuring and Maintenance of Microsoft SQL Server 2005/2008, Microsoft Visual Studio 2005/2008.
• Extremely motivated, diligent, conceptually strong team player with ability to take new roles and adapt quickly to new technology.
• Detail-oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS

Database: SQL Server 2008/2005/2000 , MySQL, SAP HANA.

ETL Tools: SAP Business objects data services, Pentaho data integration.

Reporting Tools: Tableau, and Pentaho BA Server

Data Modeling Tools: SQL power architect.

Operating System: Windows 2000/ 2003 Server/ Win XP/Vista/7/8.

Professional Experience

Confidential, Moline, IL

SAP HANA/BODS consultant

Responsibilities:

• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Created HANA Modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Involved working with content models, attributes and measures, hierarchies.
• Developed ETL jobs in SAP Business objects data services to load the data from DB2 database to SAP HANA.
• Involved in data provisioning and replicating data from source system to HANA database using SAP land scape transformation (SLT).
• Implemented full loads and Delta loads into SAP HANA from DB2 using Source and Target CDC
• Worked on replicating and loading data using SAP landscape transformation to HANA from SAP and non-SAP systems.
• Modeled and Created Attribute views to support the dimensional master data needed for the project. Utilized joins to achieve data harmonization needed to harmonize product codes across multiple data streams.
• Used Formats and Transforms including Flat File formats, Query, Table Comparison, History Preserving, Hierarchy Flattening, Match Transform, Validation Transform, Key Generation and Map Operation.
• Created Repositories, Projects, Workflows, Dataflow, Scripts, and various data stores including BW Source and Destination, SAP ECC Application, SAP HANA.
• Implementation of 3 full life cycles for different modules in SAP BI/BW which involves Development, Testing, Documentation, Requirement analysis, and End user documentation, Data Extraction, Data modeling, Data loading, Reporting and Production Support. Involved in building reports using SAP BO 4.0, 4.1 and integrating BO with BI and HANA.
• Active team player with excellent interactive and interpersonal skills to communicate with team members, developers, clients and end users at all levels.
• Efficiently managed teams of various sizes and worked with the team to achieve company and client’s goals.
• Involved in scheduling and monitoring of Jobs using Management console.

Environment: SAP Business object data services, MS SQL Server 2008, DB2, SAP HANA studio, Data services management console.

Confidential, Owings mills, MD

SAP ETL Consultant

Responsibilities:

• Created jobs, workflows, data flows, custom functions according to the business rules and implemented the business logic using SAP data services..
• Implemented SCD type 2 for the customer selected dimensions using table comparison, history preserving and key generation.
• Monitored jobs with Data Services web administrator and using data integrator logs (Trace, Monitor, and error)
• Created complex SAP Data Integrator mappings to load the data warehouse, the mappings involved extensive usage of simple and complex transformations like Key Generator, Case, Validation, Merge, Map Operator, lookup etc.
• Created and maintained custom Job error logs in SQL Server at Project level as specific to job.
• Involved in scheduling and monitoring of Jobs using Management console.
• Implemented ETL Data Flows with DATA TRANFER transform to improve the performance.
• Implemented Multi-User access management and Version Management by using the Secured central repository.
• Used BODS Data Services Transforms PIVOT and REVERSE PIVOT to apply the row level and column level transformation according to reporting requirements.
• Created Global Variables and Local variables at Job level.
• Common SQL joins are engaged in fine tuning of complex SQL statements in order to overcome the performance relate issues and duplicate data.
• Implemented system configuration for various data stores to load the data into specified destinations.
• Handled Delta loads into Oracle from SAP using Source and Target CDC.
• Extensively used Information Steward for Data Quality Management and performed extensive data profiling.
• Analyzing Source and Target tables referred with data mapping document.
• Requirement analysis from functional specifications and coordinate with business on specific business logic.
• Applied suitable Data Services transforms to expect valid data and replicating data into target to provide data for real-time reporting.
• Importing and exporting reusable objects via flat files and customizing these from/to Data Services environment.
• Prepared technical & Data flow documents as a part of project deliverables.
• Handled different exceptions using try/ catch mechanisms.
• Applied and analyzed business validation rules and loaded the data into targets using custom functions.

Environment: SAP ECC, BODS 4.0, MS SQL Server 2008, Information Steward 4.0, Oracle.

Confidential, FL

ETL Developer

Responsibilities:

• Requirements analysis from functional specifications and coordinate with business on specific business logics
• Interacted with business process team to collect the requirements and further add-ons
• Played role in designing scalable, reusable, and low maintenance ETL templates
• Developed complex mappings using various transformations and built-in functions in BODI to load data from source to target tables with data validation and integration logics
• Designed data model, created intermediate and target tables, modified Dimension and Fact tables for new requirements.
• Ensured better performance of ETL process at database level
• Created BODI jobs with Dataflow, Workflow, Conditionals, Exception and Error handling methods to run daily, weekly and monthly jobs
• Effectively worked on performance tuning of BODI jobs and PL/SQL procedures
• Implemented SCD types to load the current and historic data
• Applied Performance tuning techniques where helped to minimize the job time from 30 minutes to 5 minutes at DS level
• Handled different exceptions used try/catch mechanism
• Created deployment packages with SQL scripts for database objects and ATL files for BODI jobs, delivered the package with steps to run for QA and Production migration
• Documented design standards, ETL procedures and best practices

Environment: Oracle, BODI 11, SQL Server 2008 R2

Confidential, Chicago, IL

Pentaho/ETL Developer

Responsibilities:

• Actively participated in requirement gathering for BI Project which included Physical and Logical of Data warehouse designing.
• Participated in design of Staging Databases and Data Warehouse database
• Implemented ETL to Extract and Transform data from text files, SQL Server 2005 instances and to load into Staging Database. The main purpose to load into staging database was to change all string values to integer and load to Data Warehouse for further Data Analysis by using multiple transformations provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package on run time.
• Implemented Logic with lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Use Pentaho Import Export utility to Migrate Pentaho Transformations and Job from one environment to others (DEV/QA/PREPROD/PROD).
• Created Transformations/Jobs to take daily back up Enterprise repository for DEV/QA/PREPROD/PROD. Used Pentaho Scheduler to schedule daily/weekly/Monthly ETL jobs.
• Used transformation like Merge Join, Pivot, lookup, Fuzzy lookup and slowly changing Dimension.
• Used event handling to send E-mail on event like on error.
• Created different user level groups, and assigned appropriate permission level to the database using Credentials tool. This made sure that only the right person with enough authorizations would be able to see their corresponding Information.
• Deployed and Scheduled the Reports in Report Manager.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent

Environment: SQL Server 2005/2008, Pentaho BI Suite (Data Integration Designer, Report Designer), SQL Management Studio 2008.

Confidential

MS SQL Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Filtered bad data from legacy systems using T-SQL statements, and implemented various constraint and triggers for data consistency.
• Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the database using SQL power architect
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.

Environment: s: SQL Server 2000/2005, SQL Server Integration Services, MS Excel 2003, MS Access 2003,Enterprise Manager, Management Studio, SQL Profiler, and SSRS.