SUMMARY

• 8 years of experience in Analysis, Design and Development of various Data Warehousing projects usingSAP Business ObjectsData Services 4.0/XI3.2/3.1, Data Integrator XIR2/11.7/11.5, Business Objects XI 3.1/XIR2/6.5/6.0/5.1.
• Strong understanding of OLAP Data warehouse concepts, Dimensional Data Model, Star Schema, Snowflake Schema.
• Strong SDLC knowledge including entire life cycle of analysis, design, build, test and deployment.
• Strong business knowledge in
• Food Industry, Finance and Insurance
• Expert in documenting business requirements, functional, technical specifications and test cases.
• Capable of understanding the business environment and translate business requirements into technical solutions.
• Capable of working as a Team Member or individually with minimum supervision. Flexible to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Good Communication and Interpersonal skills with the ability to interact with end-users, managers and technical personnel.

• Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator.
• Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.
• Strong experience in using BODS as an external system for ETL between ECC and BI.
• Created complex Jobs, Work Flows, Data Flows, and Scripts usingvarious Transforms(Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Strong experience in cleansing the data using Data Quality transforms.
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Data modeling (Dimensional & Relational) concepts including Star-schema modeling, Snowflakes modeling, fact and dimension tables.
• Installed and Configured Business Objects Enterprise Suite, Business Objects Data Services/Data Integrator/Data Quality & Data Insight with proper IQ and OQ documentation.

TECHINCAL SKILL SET

Reporting Tools: SSRS, Tableau Desktop, Clik view.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling.

Databases: DB2, MS Access, MS SQL Server 2008 R2/2005

Languages: SQL, PL/SQL, Java, C, C++

Operating System: UNIX, Linux, AIX, Solaris, MS-Dos, Windows NT 4.0/2000/ 2003/2008r2/XP/Vista/7

CLIENT:Confidential,TX Jan 2009 - Till Date
Role: Sr. SAP Business Objects Data Services Consultant

Responsibilities:

• Worked with ERP TFC\'s closely to understand the business process, coordinate with business analyst and TFC\'s on specific business rules.
• Worked on SAP IS Utilities to help facilitate data migration.
• Participate in Data Mapping workshops and follow-up meetings with the client business, DML\'s, DMC\'s and TFC\'s.
• Created custom templates and custom lookups and shell jobs and used them in various business needs.
• Expertise in fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP.
• Installed & configured BODS XI 4.0 SP1 in Development & Production Server.
• Created Local, Central andProfiler repositories in SQL Server 2008 R2 and configured Local and Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3, BI and CRM.
• Developed workflows to load data into Customer Master Sales data (KNVV) and Partner roles (KNVP) from legacy systems.
• Developed jobs to load the legacy system data into COND_A04 IDOC (KOMG, KONH, KONP segments) by referencing SAP AIO SD pricing job.
• Used Open Hub Services to push data out of SAP BI using BODS.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Used Data Integrator and Platform Transforms extensively.
• Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.
• Worked on the vendor master, customer master and material master IDOCS: CREMAS, DEBMAS and MATMAS.
• Interacted with both Legacy and Functional teams to designthe mapping to load data into Customer Master IDOC (DEBMAS06).
• Moved the projects from DEV to ST, ST to UAT and UAT to Production.
• Scheduled the jobs, managed users and repositories in Management Console.
• Drill down the Analytics to the detail level data.
• Participated in detailed report design and created design specifications documents at report level.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation and Generation of Load ready data files in LSMW format.
• Ability to interpret, configure and implement data mapping / transformation business rules into Data Services
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool

CLIENT: Confidential,Houston, TXSep 2006 - Dec 2008
Role: BODI Consultant

• Initiated DBA interactions for resource requirements and modifications.
• Created new mappings and updated old mappings according to changes in Business logic.
• Installed & configured Data Services XI 3.0 in Development & Production Server.
• Developed jobs to load the data from 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.
• By referencing AIO_CUSTOMER_MASTER_JOB, created the job to load into customer master segments.
• Used the query transform and English North American data cleansing, USA noncertified address cleansing, Match transform(to cleanse the Firm data) and Associate transform to generate Customer Master basic data.
• Used the case, validation, merge transforms and lookup function to validate the Customer Master basic data.
• Applied row level and object level securities for different groups and restricted data to the end users.
• Mentored end users in working with the Business Objects user module and provided technical expertise.
• Configured repositories for ERP,CRM and HCM.
• Configured repositories for profiler and job servers.
• Performed data cleansing and noise reduction in data.
• Worked on client specific business requirements to enrich and validate data and load them into the SAP system.

CLIENT: Confidential,Houston, TX May 2004 - Aug 2006
Role: SQL Developer

Responsibilities:

• Initiated DBA interactions for resource requirements and modifications.
• Created new mappings and updated old mappings according to changes in Business logic.
• Worked with various business groups while developing their applications, assisting in Database model design and SSIS (SQL server Integration Services)
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for the clients depending upon business requirement.
• Transformed data from different heterogeneous data sources like Oracle, Teradata and ERP legacy data to SQL Server 2005 using OLE DB connection providers by creating various SSIS packages.
• Tested, Cleaned and Standardized Data by meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Used multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Server.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Performed all DBA tasks like scheduling, index re-org, batch jobs and user creation.
• Created report models for ad hoc reports when the end user wants to see the reports on fly.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Worked on UNIX(AIX) environment.
• Performed server builds, installation on AIX(IBM) servers.
• Troubleshooting and support on IBM p-series hardware.
• Based on the requirements, extracted the data from IBM Main frames by creating data stores using ODBC connection.
• Created Web Intelligence documents and published them to corporate documents to share the resources between the user communities.
• Moved the jobs into QA and Production.
• Strong Programming experience in MS SQL SERVER using T-SQL, SSIS (SQL server Integration Services) and SSRS (SQL Server Reporting Services).
• Hands on experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server and SSIS (SQL server Integration Services) and SSRS (SQL Server Reporting Services)