Summary

• Over 8+ years of experience in experience in the field of Information Technology with emphasis on Data Integrator and Data Quality, Business Intelligence concepts, Database management systems, development and complete Project Life Cycle in Data Warehousing and Client/Server technologies.
• Experience in Data Warehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading using Data Integrator/SAP Data Services with Oracle, SQL Server.
• Created Jobs, Workflows, Transformations and Data Flows according to requirement to integrate source data in to Target data ware house.
• Data Modeling: Experienced with creating, modifying and activating Info Areas, Info-sets, Info-Objects, DSOs, Info-Cubes and Multi-Cubes according to the reporting requirements.
• Sound knowledge in Business Objects XI3.1/ XI 3.0/ XIR2/6.x/5.x (Universe Designer, Desktop Intelligence, Web Intelligence and Business Objects Enterprise Java Info Views, Central Management Server).
• Expertise in installing Desktop and Enterprise Server products of Business Objects in single and distributed Environments on Windows platform.
• Extensive Experience in extracting data from various sources like SAP ABAP.
• Strong experience in Performance Tuning and query optimization, optimizing universe through Linked Universes, Aliases and Contexts.
• Designing and developing prototype for reports and gaining approval from client for further development. Created Parameterized Crystal Reports with conditional formatting and used sub reports.
• Worked on Actuate to Crystal Report 2008 migration project. Prepared the technical and functional specifications for the Crystal Reports Layout. Involved in converting Actuate Reports to Crystal Reports.
• Designed & Developed Executive level Dashboards using Xcelsius 2008.
• Efficiently involved in interacting with Business Analysts, Department Managers and Business Users.
• Good problem solving, reporting and statistical skills with excellent communication and inter-personal skills.
• Demonstrated ability to work both in independent and team-oriented environments.

Technical Expertise

Operating systems: MS-DOS, WINDOWS 95/98/ME/XP/NT/Vista, UNIX

C, C++,C#, Java script, .Net, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, SQL Scripting

DBMS:

Oracle 11g/10g/9i, DB2, Sybase, Teradata V2 R5/ R6 UDB , Microsoft SQL Server 2008/2005, MySQL 5.1, and Microsoft Access

Reporting Tools:

Crystal Reports , Xcelsius, Web Intelligence And SQL Server reporting Services

ETL Tools:

Business Objects Data Integrator, Informatica

Data Modeling Tools:

Visio 2000, Erwin4.0, Toad

Experience

Confidential, NE Feb 2012 – Present
Data Services Consultant

It is one of the country’s largest food service and food manufacturing suppliers, offering them convenience foods and ingredients.

Responsibilities

• Interacted with users to gather the business, technical requirements and making enhancements during implementation.
• Used various transformations like Map Operation, Table Comparison, Row-Generation, Query History Generation, Key Generation, Pivot, Reverse Pivot, Hierachy flattening and functions like decode, lookup_ext, index, search_replace for transforming data.
• Created Scripts like starting script and ending script for each job, sending the job notification to users using scripts and declaring the variables local and Global Variables.
• Extensively used decode, lookup_ext, search_replace, index, aggregate, ifthenelse, math, match_pattern, gen_row_num, word and date functions as part of transformation.
• Used ABAP dataflows , worked on scripts, pre-load and post-load commands.
• Created Scripts like starting script and ending script for each job, sending the job notification to users using scripts and declaring the variables local and Global Variables.
• Extracting data from databases like SAP R/3, Oracle and loading them into MS SQL database.
• Created Webi reports as per the requirement for the Mills customer data.

Environment: Data Services XI 3.2, SAP R/3, Business Objects XI 3.1, DB2, SAP ECC, Oracle 9i, Microsoft SQL server 2005/2008, Windows 2003 server.

Confidential, MN Aug 2011- Jan 2012
Business Objects Consultant

Responsibilities

• Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin console.
• Involved in BODI ETL development - Analysis, Design, Coding And Testing. Extracted data from different sources using SAP Data Services XI 3.2.
• Translated business requirements into data warehouse design.
• Created Transformation like Query, Case, Merge, Pivot, Reverse Pivot, Map Operation, Table Comparison, Effective Date, History Preserving, Row Generation, Key Generation Etc.
• Have good knowledge on all kinds of lookups
• Created Custom functions and calling in scripts.
• Created reusable components like Workflow, Jobs.
• Called Database functions in Scripts
• Extensively used Try/Catch to handle exceptions.
• Involved in administrative tasks like Repository Configuration, Job Server configuration, Central Repo configuration, Job Scheduling, Monitoring. Worked on Building Universes from Oracle for the Oracle and MS SQL server and following the best practices of universe design
• Created and designed universes In Business Objects with Custom LOVs, Prompts Conditions, Dimensions, measures and details.
• Created derived tables at the Universe level to satisfy the reporting needs.
• Set up groups and users for Business Objects deployment using the Central Management Console and assigned the access rights based on their profile.
• Created WebI and Desktop Intelligence reports using the features like Alerts, @prompts, Drill
• Used Crystal Xcelsius 2008 to design and develop executive level summary view dashboards, connecting to BusinessObjects Web Intelligence with LiveOffice as connectivity layer.

Environment: Data Services XI 3.2, Business Objects XI R2, SAP ECC, Microsoft SQL Server, Oracle, Toad ,Windows 2003 Server.

Confidential, CA June 2011- July 2011
Data Services Consultant

Responsibilities

• Involved in Development, Testing, Maintenance and resolved problems during implementation.
• Extracted data from SAP ECC, did the transformations and loaded data into BI using SAP Data Services XI 3.2.
• Configuring datastores to connect to SAP ECC, SAP BW, Microsoft SQL Server.
• Created jobs, workflows, dataflows, ABAP dataflows as per the requirements.
• Used different transformations like Query, Validation, Sql, Merge, Row generation transformations.
• Used different type of functions like search_replace, look_up, gen_row_num, ifthenelse and decode. Also developed custom functions.
• Wrote scripts, used conditionals, while loops and configured mail server. When the jobs were successful or failed, they were informed by the email.
• Scheduled the jobs using the Data Services Management Console.
• Ran the jobs in different types of environment sandbox, quality and production. Debugged and validated the data.
• Created error files for analyzing the errors and also developed recovery mechanism.

Environment: Data Services XI 3.2, Business Objects XI R2, SAP ECC, Microsoft SQL Server, Oracle, Toad ,Windows 2003 Server.

Confidential, NE Feb 2011 – May 2011
Data Services Consultant

Responsibilities

• Involved in Requirement gathering, Analysis, Development, Testing, Maintenance and resolved problems during implementation.
• Created mapping rules for migration of data, upon the requirements.
• Extensively worked on Data Services XI 3.2 for migrating data.
• Installed Dataservices XI 3.2 on windows server and was responsible for setting up Sandbox, Development and Production Environment and also migrating reusable objects (Jobs, Workflow, Dataflow) from central repository to test environment.
• Worked on Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, Reverse Pivot, Validation, Key generation, Row generation transforms in Data Services for transforming and migrating data from legacy to target systems.
• Extracing data from datasources like CRM system, Oracle, SQL server and transformed, dynamically joined with non-SAP data to build data warehouse solutions.
• Extracting Data from different Sources like excel, IDOCS and flat files and loading them into requested target tables in Data Warehouse.
• Extensively used decode, lookup_ext, search_replace, index, aggregate, ifthenelse, math, match_pattern, gen_row_num, word and date functions as part of transformation.
• Used ABAP dataflows , worked on scripts, pre-load and post-load commands.
• Involved in Performance Tuning of BODI extraction programs and reduced execution time of expensive jobs significantly.
• Worked with different Data Quality Transform such as Global Address Cleanse, Data Cleanse and Match Transform.
• Used Data Quality in data cleansing, standardization, consolidation and enrichment of data.
• Responsible for scheduling batch and real time Jobs using Data Services Management Console and third party tools such as control-M. Also responsible for Debugging and testing of ETL Jobs using Business Object Data Services.

Environment: Data Services XI 3.2, SAP R/3, DB2, SAP ECC, Oracle 9i, Microsoft SQL server 2005/2008, Windows 2003 server.

Confidential, IL Aug 2010- Jan 2011
Data Migration Consultant

Responsibilities

• Worked on DATA SERVICES XI 3.2 to migrate data from one database to another database. Involved planning, Requirement gathering and Testing Phases of Migration Process.
• Extensively worked on Data Insight for validating data. Created mapping rules for transformation of data upon the requirements.
• Extracting data from databases like DB2, Oracle, Tiger, SAP R/2 using DATA SERVICES and transforming data using different transforms, functions, scripts and finally loading them into the target database.
• Used various transformations like Map Operation, Table Comparison, Row-Generation, Query History Generation, Key Generation, Pivot, Reverse Pivot, Hierachy flattening and functions like decode, lookup_ext, index, search_replace for transforming data.
• Created Scripts like starting script and ending script for each job, sending the job notification to users using scripts and declaring the variables local and Global Variables.
• Extensively tested the migrated and converted reports by validating the data and fixed the issues relating to them.
• Involved in Migration of Repositories from Development, Test and Production environment using import wizard.
• Worked on performance Tuning of long running jobs used techniques like pushing down operations to database level, using cache memory, Degree of Parallelism.

Environment: Business Objects Data Integrator 11.7.2/Data Services XI 3.2, Business Objects XI R2, SAP R/2, DB2, SAP ECC, Oracle 10g/9i, Oracle SQL Developer, Toad ,Windows 2003 Server.

Confidential, MN Feb 2010- July 2010
Senior Business Objects Consultant

Responsibilities

• Interacted with users to gather the business and technical requirements.
• Analyzed various Data Warehouse Models like Slowly Changing models, Conceptual Models, Logical Models.
• Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into oracle staging area.
• Extensively worked in accumulating Data into one BW system from other BW systems.
• Extensively used functions like decode, lookup_ext in Data Services to load data from source to Target using a transform Table.
• Defined separate data store for each database to allow Data Services to connect to the source or target database.
• Used Scripts for declaring the variables and creating the tables and inserting data into them.
• Worked on performance tuning and optimization of different dataflows.
• Scheduled and Monitor jobs using Data Services Management console.
• Installed and Configured Data Insight for Data Profiling.
• Extensively used Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, and Validation Transforms in Data Services in order to load data from source to Target Systems.
• Used Data Quality transforms like address cleansing, global address cleanse, match for cleansing and standardizing the data based on the address dictionaries installed.
• Published and monitored jobs using Data Integrator administrator.
• Responsible for creating & managing the Business Objects repository and coordinating in universe development.
• Created reports connecting to Business Object Repositories from the developed business views and universes.
• Developed new BO documents against existing universe using Web Intelligence.
• Created Dashboard Reports using Xcelsius 2008.

Environment: Business Objects XI Data Services/Data Integrator 11.7, Business Objects XI 3.1, Netweaver 04s (BI 7.0), CRM 4.0, MM, FI /CO modules, Erwin, Oracle 9i, SQL Server, PL/SQL, Windows XP Pro/2003 Server.

Confidential, MN Sep 2008- Nov 2009
BO Consultant, Reporting & Data Warehouse Development

Responsibilities

• Involved in requirement gathering, creation of use cases, usage scenarios and solution architecture.
• Installed and configured Business Objects XI R2 on windows.
• Migrated Business Objects 6.5 reports & crystal reports to BO XI R2.
• Involved in Analysis, Development, Testing, and Maintenance and Resolved problems during implementation.
• Involved in detail design and development of mappings using Business Objects Data Integrator.
• Implemented performance tuning concepts to the whole Business Objects Data Integrator 6.5 ETL process.
• Created various transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Sequence Generator etc
• Design and developed Data Integrator scripts for data transformation.
• Involved in writing Stored Procedures and calling them at Pre_Load command in Data Integrator Designer.
• Involved in scheduling and running Batch jobs on time at Data Integrator Administrator.
• Used Business Objects Designer Tool to Build Universes.
• Created different Categories in the repository and published full client reports corporate documents to their respective categories.
• Created Static and Dynamic Parameter fields for the filtering of the data in Crystal Reports (2008).
• Created, managed and formatted standard reports, master/detail reports and cross tab reports using Report Manager in Crystal Reports.
• Used Microsoft Visio for Creating various diagrams and flowcharts like business process, workflow diagrams, database models.
• Designed Calendar, Metrics, analytics, Dashboard reports and Xcelsius (IMT, Speedometers, Pareto Charts, Alerter, traffic lights etc,) and used Performance Manager.

Environment: Business Objects XI R2/6.5, Data Integrator 11.7, Crystal Reports 2008, Oracle 10g/9i, SQL Server 2005, Web Intelligence , Windows 2003 Server, UNIX.