SUMMARY

• 10+ years of total IT experience in requirement gathering, technical analysis, Estimation, design, development & implementation of business applications for Manufacturing, Utilities, Pharmaceutical, Retail, Finance, Bio medical, Outdoor goods sectors.
• Strong experience in Data Warehousing, Business Intelligence concepts & implementation.
• Extensive experience in developing data models in HANA 1.0 SP9/SPS10
• Strong experience in Business Objects Data services 4.x/3.x/Integrator XI.
• Strong experience in Business Objects 4.x/3.x
• Proficient in Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005/2000/7.0 , (database triggers, materialized views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, SQL Navigator, PL/SQL and oracle DBMS Packages, oracle supplied utilities
• Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
• Expertise in Installation, migration, maintenance, troubleshooting and overall administration of the Business Objects Suite. Involved in conducting strategic evaluation (Proof of Concepts) of the use of Business Objects XI R3.1/R2.
• Experienced in ETL Methodologies using Business Objects Data Integrator/ Services XI 3.1 with Data Quality & Rapid Mart and worked on Metadata Integration (BOMM - Business Objects Metadata Manager) and EPM (Enterprise Performance Management)
• Extensively worked on creating complex workspace and analysis of data using OLAP reporting tool Voyager.
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expert in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test (UAT) and data accuracy test.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Extensively worked in Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, drilling reports, analysis reports, data reports along with Dynamic LOV using Business View Manager.
• Have good hands on experience in ETL and Data Cleansing applications using Informatica Power Center, Oracle Warehouse Builder, Data services/ BODI, and PL/SQL.
• Ability to analyze existing systems, conceptualize and design new ones, and deploying innovative solutions with high standards of quality.
• Self-starter who takes responsibility and accountability.
• Excellent time management skills and documentation skills.

TECHNICAL SKILLS

Databases: SAP HANA 1.x, SPS9,Oracle 7.3/8/8i/9i/10g/11g, SQL Server 2005/2008/2008 R2/2012, Teradata, DB2, MS Access, MySQL

ETL: Business Objects Data Services 3.x/4.x, SAP BI/BW, ECC 6.0/R3, Data Insight XI R2, Information steward 4.x

Reporting: Xcelsius Enterprise 2008, 4.5, Crystal Reports 2008, XI R/2, XI, 10, 9, Business Objects WebI, Universe Designer, Business Objects XI REL2, Crystal Enterprise 9,10, Visual Basic Crystal Reports, Oracle Reports 2.5.

Modeling: ER Studio, Visio,HANA Studio

Languages: SQL, PL/SQL, Java, HTML, XHTML, C++, PERL, Python

OS: Windows 7, Windows 98, XP, 2000/NT, Mac OS X v10.x

PROFESSIONAL EXPERIENCE

Confidential, Issaquah, Washington

SAP HANA Lead Consultant

Responsibilities:

• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Assisted SAP Basis team in installing HANA 1.0 and solely integrated it with Business Objects 4.0 and BODS4.0.
• Established the best modeling and recommended strategies for BOBJ environment and architecture for SAP HANA.
• Installed BOBJ 4.0 and BODS 4.0 and configured SAP and Windows AD authentication for Business objects enterprise.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
• Created Technical specifications and standard modeling documents for HANA.
• Developed testing scripts and performed UAT on SAP net weaver portal using Test ID's for developers, super users, and end users.
• Responsible for streamlining existing BODS jobs developed by multiple developers
• Generated executable shell scripts of BODS jobs using Data Services Management Console in order schedule jobs using UC4 scheduler
• Worked on various Java sdk scripts to configure authentications, SSO, and web servers for HANA, SAP BW7.3, BODS4.0 and BOBJ4.0
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed data models for the operations, PP, Global sustainment, Quality management tables in HANA.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Integrated SAP Net weaver portal to Business objects content using Knowledge management, work sets, portal roles.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Developed Webi reports and dashboards for different operations and finance KPI'S like Project planning, quality management, warehouse management, Material management, Global Sustainment, Value management.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).

Confidential, Milwaukee, Wisconsin

SAP HANA/BODS Consultant

Responsibilities:

• GRiD Solution developed leverages SAP HANA platform to analyze data from vehicles in real time for increasing overall efficiency of fleets & help OEM to improve product development.
• It provides aggregated & detailed information for multiple GRiD stake holders like Shipments, Insurance, Fleet Management, Channel Partners/Dealers and Government & Regulatory Bodies.
• Playing the role of HANA Solution Architect/Team Lead and managing a team of 4 developers.
• Involved in full life cycle implementation concept ideation, requirements gathering, data modeling, mockups creation & development.
• Created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, Loading data into table, developed
• Attribute Views, Analytical Views and Calculation views Graphical and SQL Script - CE Functions based views for report requirements
• Used BODS to Provision data from 12 varied data sources like Fleet Information, driver details, vehicle maintenance, vehicle parts, engine, chassis details, trip/route details etc.

Confidential, Parsippany, New Jersey

SAP HANA/BODS Consultant

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, and Reporting and Testing process.
• Played role of HANA Solution Architect/Team Lead and managed a team of 4 developers. The application developed has been certified by SAP AG.
• Designed the Data Model, Data Provisioning through BODS and Hi Fidelity Wireframe models for UI5 Report and Design Studio Reports.
• Created HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and creation of USERs and ROLES, etc.
• Developed HANA Column based tables and SQL Script Procedures, Loading data into table definitions, suspending data loads, resuming data loads.
• Expert in creation of Attribute Views, Analytical Views and Calculation views Graphical and SQL Script - CE Functions and Stored Procedures.
• Migrated the SMARTANA delivery units & data from SAP COIL to Amazon AWS

Confidential, Parsippany, NJ

SAP HANA/BODS Consultant

Responsibilities:

• The core of this project is to depict the SAP BW process by replicating the entire ECC tables into HANA through SLT and build HANA views
• BO reports, thus eliminating BW from landscape - Extended HANA Live version custom built for Reliance Industries Limited.
• Created SQL Script Calculation Views and Procedures to model complex business logics of SAP Standard Data Sources and Z Data Sources.
• Worked on Scenarios to optimize HANA procedures to provide results at much faster time frames.

Confidential, San Francisco, CA

Sr. SAP BODS Consultant

Responsibilities:

• Re-called back for Go-Live activity after re-launching the project
• Involved in different phases of the project like analyzing requirement, planning, execution and maintenance
• Involved in the process of development, testing and UAT
• Responsible for creating batch job for Bill of Materials (BOM), Specifications on complex business requirement
• Optimized and reduced the job run time for previously developed jobs for Products and Colorway and Material Finish libraries in the 1st phase
• 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
• Responsible for testing the ETL jobs in QA before moving them to Production (3 System Integration testing cycles)
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data
• Worked on various Data Integrator transforms like Table Comparison, Map Operation, History Preserving, Row generation, Key Generation, Pivot, Validation, Query transforms
• Responsible for creating complex validation rules, rule bindings, defining rules task and view results, scorecard setup and managing tasks with Information steward 4.0
• Created views, Performed different kind of profiling like column profiling, address profiling, dependency profiling, redundancy profiling, uniqueness profiling on IS 4.0

Confidential, Milwaukee, WI

Sr. SAP BODS Consultant

Responsibilities:

• Gathered the functional Requirements from the Business users, Business Process Owners to build the functional specifications, ensure the accuracy of the reporting specifications
• Coordinated with the DBA to identify the data needs, extracting the data to the database
• Involved in different phrases of the project like analyzing requirement, planning, execution and maintenance
• Identifying the Business Objects Best practices for different applications
• Participated in project planning sessions with project managers, business users and team members to analyze business requirements and outline the proposed solution
• Involved in Full life cycle implementation of BW that includes Data Modeling, Data Extraction
• Data transformation, Data loading, Scheduling jobs, Monitoring data loads, production support, troubleshooting and reporting
• Created new mappings and updated old mappings according to changes in Business logic
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse
• Configured the Data services to connect to the SAP R/3
• Installed & configured Data Services XI 3.2 SP1 in Development & Production Server
• Developed jobs to load the 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
• Worked on Active Customer Data Cleansing, and loading data back in to Data Warehouse usingData Services
• CreatedData Flowsto load data from flat file with fixed width formats into Data Warehouse
• Created Jobs inDataServicesto load the data from spread sheet in to Data warehouse and also made this job incremental
• Extensively usedlookup, lookup extfunctions in Data Servicesto load data from source to Target using a transform Table
• Responsible for Customer Master data loads using LSMW and IDoc (ADRMAS)
• Created Data Integrator mappings to load the SAP ERP and R/3 tables to Staging area then to SAP Business Warehouse and Rapid Marts
• Worked with all transformations in Data Integrator and created Global variables, Local Variables in DI
• Extract data from multiple sources, SQL Server 2008, MS Access DB 2007 and Integrate the same with Data Services to create master files for LSMW processing in R3
• Major areas of focus: Appended Customer Master Address with missing attributes at the critical moment to make data available for business on Quality (QE1) and Testing environments (TE1)
• Created jobs to profile data as per the business requirements, to enable a successful load of the data into different environments on the Target (SAP R3)

Confidential, San Francisco, CA

Sr. SAP BODS Consultant

Responsibilities:

• Used Data Integrator and Platform Transforms extensively Created jobs, Workflows and Dataflow
• Created Batch-jobs with multiple outputs for various FLEX objects - Vendor/Supplier, Material Finish/Fabric Master library, POM library, Sourcing Configuration and Measurements master library
• Created jobs with an output to deliver the Data Quality reports to indicate the unique errors, Blank cell counts, Referential integrity Checks, Missing Primary key and related key finding as per the dynamic requirements
• Performed Data profiling activity and transformed the input source data as per the loading requirements for the Migration process for the target loading process
• Created scripts at starting and ending for each job, sending the job notification to users using scripts and declaring the Local and Global Variables
• Worked with Business users in developing jobs (modifying and appending structures) as per dynamic and on-the-go desired output
• Successfully implemented sign-off and validation mechanism, at various levels of data transition in between several groups of business
• Responsible for creating complex validation rules, rule bindings, defining rules task and view results, scorecard setup and managing tasks with Information steward 4.0
• Created views, Performed different kind of profiling like column profiling, address profiling, dependency profiling, redundancy profiling, uniqueness profiling on IS 4.0
• Created Data Flows to load data from flat file with fixed width formats into Data Warehouse
• Extensively utilized lookup, lookup ext functions to load data from source to Target using a transform Table
• Scheduled and Monitor jobs using Data Integrator Management console
• 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
• Responsible for testing the ETL jobs in QA before moving them to Production (3 System Integration testing cycles)
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data
• Worked on various Data Integrator transforms like Table Comparison, Map Operation, History Preserving, Row generation, Key Generation, Pivot, Validation, Query transforms

Confidential, Boston, MA

Sr. SAP BODS Consultant

Responsibilities:

• Created DS Jobs to develop reports for Material Usage, Billing, Account and Equipment Information
• Worked on Active Customer Data Cleansing, and loading data back in to Data Warehouse using Data Services
• Created Data Flows to load data from flat file with fixed width formats into Data Warehouse
• Created Jobs in Data Integrator to load the data from spreadsheet and other flat files
• Extensively used lookup, lookup ext functions in Data Integrator to load data from source to Target using a transform Table
• Extracting Data from SAP ECC systems using ABAP data flows; Transform Data and stage them to Data marts
• Created ABAP Data flows and used Shared Directory Data transport method to perform the ETL operation
• Created DS extract jobs to extract data RDBMS tables to SAP BW system and also exported the job execution parameters to SAP BW system
• Worked on performance Tuning of long running jobs used techniques like pushing down operations to database level, Degree of Parallelism, collect statistics to monitor jobs
• Scheduled and Monitor jobs using Data Integrator Management console
• 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
• Responsible for testing the ETL jobs in QA before moving them to Production
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data
• Worked on various Data Integrator transforms like Table Comparison, Map Operation, History Preserving, Row generation, Key Generation, Pivot, Validation, Query transforms

Confidential, El Segundo, CA

Sr. SAP BODS Consultant

Responsibilities:

• Created Data Flows to load data from flat file, CSV files with various formats into Data Warehouse.
• Involved in creating batch jobs for data cleansing and address cleansing
• Involved in creating the batch jobs for de-duplicating the data for different sources
• Worked on making full load jobs in to incremental loads using Map Operation, Table Comparison, and Auto Correct Load
• Extensively used Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, and Validation Transforms in order to load data from source to Target Systems
• Extensively used lookup, lookup ext functions in Data Integrator to load data from source to Target using a transform Table
• Designed & developed error catching procedures in BODI jobs
• Scheduled and Monitor jobs using Data Integrator Management console
• Defined separate data store for each database to allow Data Integrator to connect to the source or target database
• Created Scripts like starting script and ending script for each job, sending the job notification to users using scripts and declaring the Local and Global Variables
• Created and administered Local and Central Repositories for multi user environment
• Migrated and tested jobs in different instances and validated the data by comparing source and target tables
• Automating all error handling, error escalation, and email notification procedures
• Generated several Metadata reports for Data Integrator mapping, and job execution statistics

Confidential, Bay Area CA

SAP BODS/BI/BW Consultant

Responsibilities:

• Analyzed functional requirement documentation and data specifications for ETL Process.
• Used SAP Data Integrator 11.5.2 for migrating data from various OLTP databases to the Data Warehouse
• Created, Tested and Executed data integrator jobs using designer to transfer data from source to target.
• Created Scripts, Jobs, Workflows and Data Flows according to their Business and implemented their business logic using SAP Data Integrator.
• Created Global Variables and Local variables at Job level.
• Implemented Parameters at Data flow level for various jobs.
• Implemented Business Specifications in Data Flow mappings to Load Data Ware House
• Monitored Jobs with Data Integrator Web Administrator and also using Data Integrator logs (Trace, Monitor and Error)
• Implemented system configuration for various data stores to load the data into specified destinations.
• Worked on Partition Management to load data warehouse for a given date range.
• Designed Summary and Aggregation tables according to the functional requirement specifications and loaded data to support reporting.
• Performed Performance tuning of targets, sources, mappings and session
• Executed complex jobs in Debug mode and traced out errors using logs.

Confidential, Kansas City MO

SAP BODS / BI Consultant

Responsibilities:

• Involved in meetings with client and gathered business requirements and developed mapping documents
• Created Data Integrator mappings to load the SAP ERP and R/3 tables to Staging area then to SAP Business Warehouse and Rapid Marts
• Worked with all transformations in Data Integrator and created Global variables, Local Variables in DI
• Used various transformations like lookup, Case, Merge, Date Generation, Query, Sql, Table Comparison on data extracted according to the business rules and technical specifications
• Designed Summary and Aggregation tables according to the functional requirement specifications and loaded data to support reporting
• Configured the mappings to handle the updates to preserve the existing records using History Preserve Transformation (Slowly Changing Dimensions Type-2)
• Used parsing, correction, standardization, duplicate matching for arranging information using Data Quality Management
• Tuned Data Integrator Mappings and Transformations for better performance

Confidential

SAP BI Analyst

Responsibilities:

• Prepared documentation including requirement specifications
• Designed the Data Mart model with Erwin using Star Schema methodology
• Creating Dimensions and Facts in the physical data model
• Documented the metadata to capture from the sources
• Created Sessions and batches to extract the data
• Involved in the creation of jobs using workflow manager to validate schedule run and monitor the jobs
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system
• Used the Power center Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database