SUMMARY

• Over 10 years of experience in Analysis, Design and Development of various Data Warehousing projects using SAP Business Objects Data Services 4.1/4.0,3.2/3.1, Data Integrator XIR2/11.7, Business Objects 4.0/3.1/XIR2/6.5/6.0, Crystal Reports, Xcelsius and Live Office.
• Involved in identification of Facts, Measures, Dimensions and hierarchies for OLAP models.
• Strong SDLC knowledge including entire life cycle of analysis, design, build, test and deployment
• 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.
• Experience in building projects in Data Insight, Metadata Management, Cleansing and Metapedia modules of Information Steward.
• Installed and Configured Business Objects Enterprise Suite, Business Objects Data Services/Data Integrator/Data Quality & Data Insight with proper IQ and OQ documentation.
• Working experience on transforming data from various data sources to a Data warehouse using various ETL tool like Data Integrator and interacting with the Business Analysts in identifying the needs and the requirements of the system.
• Experience in designing and developing mappings to extract data from diverse sources such as SQL Server/Oracle/SAP ECC databases, flat files, Excel, .CSV files and legacy systems.
• Experience doing extracts from SAP Source systems using ABAP data flows and loading into SAP BW/SQL Server/DB2.
• Written DI Scripts for implementation of Recovery Mechanism for unsuccessful batch jobs execution.
• Experience in using Data modeling tools like ERWIN/VISIO, Knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems.
• Experience in FACT & Dimensions tables, Physical & logical data modeling.
• Strong database experience in using Oracle, MS SQL Server, MS Access, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer.
• Hands on Working knowledge in Writing the Stored Procedures, Packages, Functions and Triggers.
• Strong Knowledge of FACT & Dimension tables, Physical & logical data modeling.
• Experience in tuning performance with Data Flows and SQL Stored Procedures.
• Expertise in implementing various performance optimization techniques such as push down memory intensive operations to database server, parallel execution, partition and indexing, caching and degree of parallelism.

TECHNICAL SKILLS

OLAP Tools: SAP Business Objects XI R2/ 3.x/4.x, Universe Designer/IDT, Crystal Reports 2008/2011, Xcelsius/Dashboards 4.0, Design Studio, SAP BEx Analyzer & Query Designer, SAP Information Steward 4.x

Data Warehouse: Teradata V13, SAP BI 7.x

ETL Tools: SAP Data Services XI 3.x/4.x, Business objects Data Integrator 12.2/11.7.2

Database: Oracle 11g/10g/9i, DB2 9.X/10.X, Sybase12.0, Teradata V2 R5/ R6 UDB, Microsoft SQL Server 2008/2005, My SQL 5.1, Microsoft Access

Languages: SQL, PL/SQL, XML

Data Modeling Tools: Visio 2000, Erwin, Toad

Operating Systems: UNIX, Windows NT/2000/XP

PROFESSIONAL EXPERIENCE

Confidential - Princeton, NJ

Lead Business Objects Data Services/Information Steward Consultant

Responsibilities:

• Coordinate and lead the design review of all ETL packages (programs) and BO reports. This will include high-level design of the overall solution and detailed design of all components of the solution.
• Establish and ensure appropriate data quality and ETL metrics are defined, monitored and managed in support of and alignment with stakeholder business requirements.
• Responsible to load the data successfully from the staging Oracle database/Siebel to the target DWH (SQL Server/ Oracle) and then from DWH to the data mart using SAP BODS 4.1/4.0/3.2.
• Responsible for the ETL development, Unit testing and deployment.
• Provide guidance and leadership on technical methodologies for projects, such as technical requirements, design topics, code reviews and testing procedures.
• Responsible for gathering requirements from client and coordinate with the offshore team.
• Responsible for tracking the development progress and making sure any delays do not affect the project milestones.
• Responsible to drive the weekly status meetings with offshore as well as the onsite team.
• Responsible to address any queries, concerns or issues reported by the team and help them move forward with the development.
• Responsible for making sure the ETL code is in accordance with the Source to Target mapping documents.
• Responsible for exporting the Jobs/Dataflows to ATL files with proper export options and deploying these ATL files to other repositories.
• Assist infrastructure teams as needed with technical details of all technologies in use for projects such as new version upgrades, migration of hardware, production issues, etc.
• Develop strategy for implementing data profiling, data quality, data cleansing, and ETL metadata management.
• Responsible for tuning the jobs and Dataflows by using appropriate performance tuning techniques and also by analyzing the AWR reports to load the data into the target database within the runtime window.
• Proactively worked with the System Test and Performance Test teams to identify any ETL bugs or performance issues.
• Traced the data lineage from a report to sources using Metadata Management Module in Information Steward.
• Responsible for bug tracking through IBM Rational ClearQuest and fixing the bugs no later than the assigned target date. Creating Parameters, Global/Local Variables, Scripts, Projects, Jobs, Workflows, Data Flows and Administrating Web management Console.
• Created Scripts and worked with Conditional and While Loop to implement complex logic.
• Extensively used Try/Catch to handle exceptions and writing Scripting to automate the Job Process
• Involved in data profiling like source column data profiling, detail data profiling and used validation and address cleansing transformations by using data quality in Data Services.
• Used to migrate the jobs from one environment to another by creating atl Packages.
• Involved in support activities while deploying the job in different environments.
• Used Data Services Management Console for Scheduling Jobs, viewing log files for batch jobs, managing repositories and Metadata reporting.
• Experience in debugging execution errors using logs (trace, statistics and error) and by examining the target data.
• Tuned performance for large data files by increasing block size, cache size and implemented performance-tuning logic on sources, workflows, data flow’s and target system in order to provide maximum efficiency and performance.
• Documenting in order to keep a track of the changes done to the job.

Environment: SAP Business Objects 4.0, SAP Business Objects Data Services 4.1 SP2, IBM Rational ClearQuest, Oracle 10g/11g, SQL Server 2008/2012, Information Steward 4.x, TOAD, SQL Developer, Windows XP/7/ 2008 R2.

Confidential - KANSAS CITY, MO

SR.SAP Business Objects Data Services Consultant

Responsibilities:

• Responsible for gathering information from Process Teams regarding the business requirements.
• Used business objects data services in order to extract data from different sources including excel sheets and generate a flat file.
• Creation of ETL Processes for the new Subject areas, develop data extraction, transformation and loading into target systems using Data Services Designer.
• Used transformations like key generation, map operation, pivot, reverse pivot transformations, and lookup functions in order to transform the data before generating the flat file according to the LSMW output format.
• Used LSMW in order to load the file into sap.
• Used system configurations in order to run the job in different environments.
• Used ABAP Dataflow to generate ABAP code to extract data from tables and Hierarchies of SAP application and SAP business Information Warehouse.
• Created Scripts and worked with Conditional and While Loop to implement complex logic.
• Supporting the data team while loading the file into SAP.
• Usage of Global and Local variables
• Defined separate data store for each database to allow Data Services to connect to the source or database.
• Involved in supporting the data in different mock loads.
• Responsible for Debugging and testing of Data Integrator Jobs.
• Created, validated and executed jobs to transfer data from source to target.
• Responsible for Performance tuning of all the jobs for faster Execution and optimized performance.
• Used Type 1 SCD and Type 2 SCD mappings to update Slowly Changing Dimension Tables, Tuned simple and complex transformations in Data Flows.
• Documented and maintained Detail Design specifications, Source to target mapping documents which have detail steps of transformation rules.
• Used Data Services Management Console for Scheduling Jobs, viewing log files for batch jobs, managing repositories and Metadata reporting.
• Extensively used Data Services inbuilt functions like Aggregate Functions, Database Functions, Date Functions, Lookup Functions, Math Functions, System and Validation Functions.
• Implemented various performance optimization techniques such as Use of Cache, Pushdown memory-intensive operations to the database server, Slicing, Dividing Data in to Sub Dataflow, and Degree of Parallelism (DOP).

Environment: SAP Business Objects Data Services 3.2/4.1, Oracle 11g/10g, LSMW, SAP ECC, Toad

Confidential, Richardson, TX

SAP BODI Developer

Responsibilities:

• Responsible for gathering information from clients regarding business requirements. Collaborated with business technicians to research existing business and system processes.
• Interacted with business analysts and End client to understand technical and functional requirements for creating new Job.
• Used Business Objects Data Integrator XI for ETL extraction, transformation and loading data from heterogeneous source systems such as excel and flat files.
• Developed various Workflows and Data flows where the data is extracted from the sources like Oracle 11g, SQL Server 2008 and then loaded into staging tables from staging tables data loaded into relational tables and from Relational tables data loaded into Hubs, Satellites and Links
• Used Business Objects Data Integrator XI data cleansing transformations for de-duplication, house-holding and address parsing.
• Created complex Data Integrator mappings to load the data warehouse, the mappings involved extensive use of transformations like Key Generation, Sql Query Transform, Table Comparison, Case, Merge, Map Operation, lookup function etc.
• Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin client tools.
• Used Data Services inbuilt functions like Aggregate Functions, Database Functions, Date Functions, Lookup Functions, Math Functions, System Functions and Validation Functions.
• Created Custom functions to make the code reusable.
• Responsible for Debugging and testing of Data Integrator Jobs.
• Optimize data mappings to achieve faster load
• Experience in debugging and performance tuning of sources, targets and mappings
• Creating Parameters, Global/Local Variables, Scripts, Projects, Jobs, Workflows, Data Flows and Administrating Web Management Console.
• Created Scripts and worked with Conditional and While Loop to implement complex logic.
• Extensively used Try/Catch to handle exceptions and writing Scripting to automate the Job Process
• Involved in data profiling like source column data profiling, detail data profiling and used validation and address cleansing transformations by using data quality in Data Services 3.2.
• Experience in migration of Data from Flat file, Teradata, and Oracle.
• Used Business Objects Data Integrator XI interactive debugger to test the jobs and fixed the bugs.
• Worked extensively on modules Supervisor, Designer, Web Intelligence, Business Objects Central Management Console and Xcelsius.
• Tested and Validated BODI ETL Jobs, monitored Daily BODI ETL schedules.
• Performing troubleshooting and providing resolutions to ETL issues.

Environment: SAP Business Objects Data Services XI 3.2, BO Data Integrator XI, BO XI, Oracle 11g /10g, Microsoft SQL Server 2008, T-SQL scripts.

Confidential

Business Object Developer

Responsibilities:

• Defined separate data store for each database to allow Data Integrator XI to connect to the source or target database.
• Participated in Requirement gathering sessions and developed Business Objects Data Integrator XI jobs specifications on Excel sheets based on information acquired from analysis of source data, user requirements and business Rules.
• Created Scripts like starting script and ending script for each job and declaring the variables local and Global Variables.
• Used various transformations like, Map Operation, Table Comparison, Row-Generation, Query and SQL transformation
• Tune the simple and complex transformations in Data Flows.
• Design and developed Data Integrator scripts for data transformation.
• Created, validated and executed jobs to transfer data from source to target.
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data.
• Extensively used Data Services Management Console to Schedule jobs, monitor log file and managing access rights to users
• Used Complex EXCEL formulae v lookup &H LOOKUP to generate complex Dashboards
• Extensively used Data Integrator to cleanse and populate target database.
• Extensively worked with SQL Server applications like SSIS, Stored Procedures, SQL Querying, T-SQL and OLTP.
• Developed Internal control reports to validate the ETL load and scheduled it.
• Responsible for Debugging and testing of ETL Jobs using Business Object Data Services.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.
• Tested and Validated BODI ETL Jobs, monitored Daily BODI ETL schedules.
• Performing troubleshooting and providing resolutions to ETL issues.
• Implemented various performance optimization techniques such as Use of Cache, Slicing, Dividing Data in to Sub Dataflow, and Degree of Parallelism (DOP).
• Implemented various error recovery mechanisms to recover missing rows and values in target database.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill down, Cross Tab Breaks, Custom Sorts, and Master/Detail and Formulas etc.

Environment: Business Objects Data Integrator11.7.2, Oracle 9i, SQL Server 2005, Broadcast Agent 6.1, Web Intelligence 6.5, Windows 2003 Server, UNIX.

Confidential

SQL Developer/DBA

Responsibilities:

• Maintenance of Production and pre-production servers and responsible for day to day activities for smooth running of the production environment.
• Carried out new servers building for Dev, Test, QA and Production environments
• Carried out SQL Server Migrations and Upgrades for SQL Server 2005 and SQL Server 2008 R2.
• Implemented SQL technologies like SQL Cluster (FCI), Mirroring and Replication.
• SQL Server 2005 Reporting Services configuration and troubleshooting.
• Setting up Disaster Recovery Environment for critical applications
• SQL Server performance monitoring and troubleshooting for performance bottleneck issues.
• Worked on SQL Server R2 Backups, restore and recovery as well as created Disaster Recovery plan and tested successfully.
• Configuration and troubleshooting various SQL Server Application issues.
• Created PowerShell Automations for various tasks.
• Password reset of service accounts for SQL Server Security Accounts.
• Automated manual tasks and it saved huge amount of man hours.
• Carried out various application deployments.
• Conducted Root Cause Analysis (RCAs) as well as documented critical solution for future use.
• Conducted various technical trainings for team members.
• Documented different issues for future assistants, and processes.

Environment: SQL Server 2000/2005, Windows 2000/2003 Server, T-SQL, SSIS, VERITAS, LiteSpeed