SUMMARY:

• Have 16years of IT Industry experience and 13 plus years in Data Warehouse Architect, Solutions, Delivery, Consulting, Managing, and executing multiple projects.
• Analyzed business requirement and Directed, ManagedProjects and provided development solutions from beginning to end.
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders
• Evaluated BI (DW&BW) landscape and integrated BI Platform for Centrica, Schneider and Consumers Enegeryprojects inDW, SAP BW, BIG Data (HADOOP) and HANA
• Develop full scale project plans and associated communication documents
• Analyze business analytics and reporting requirements, implementation, testing and developing ETL solutions for leading clients.
• Interfacing with clients for business requirement gathering, conducting system analysis and finalizing technical / functional specifications.
• Designing, developing, testing, troubleshooting and debugging of the applications.
• ETL experience in using SAP BODS, Cognos Data Manager, Informatica, andSSIS.
• Expertise in using SAP Business Objects Data Services(BODS) 4.1/4.0 (Designer, Repository Manager, Server Manager, Configuring / Controlling Job Server and Web Admin)
• Extensively used stored procedures for Data Cleansing and Data Profiling.
• Have good hands on experience in ETL and Data Cleansing applications using Informatica Power Center, Data services, and PL/SQL.
• Cooperating & communicating with other team members for efficient project work.
• Effective in communicating complex technical information to both top - level management and end-users. Flexible and resourceful, applying strong organizational, time-management and planning skills to deliver projects on time/budget, in pressure and aggressive timelines.
• Excellent Project Management skills.
• Strong communication and interpersonal skills. Experienced effective team leader as well as team player.

TECHNICAL SKILLS:

ETL Tools: SAP Business Objects Data Services, 4.1/4.0/3.2, Cognos Data Manager 10.2/10/8.4.1 , Informatica 8.1, SSIS

OLAP/BI: BO Web i, Xcelsius, Lumira, Cognos Report Studio 10.2/10/8.4.1 .

Data warehouse: SAP BW 3.0C, 3.1C, 3.5, SAP BI 7.0, 7.3& 7.4

Data Modeling: SAP Sybase Power Designer, ERwin

Databases: HANA IM DB, Oracle 11g/10g/9i/8i/8.0/7.x, SQL Server 2012/2008/2005 , DB2

Languages: SQL, PL/SQL.

Operating Systems: UNIX, Windows, MS-DOS.

PROFESSIONAL EXPERIENCE:

Confidential, Montvale, NJ

SAP BI Developer

Responsibilities:

• SAP BW-HANA blend scenario solutions for specific requirements where high volume of detailed data reporting is required.
• ETL Based replication to provision the data from Legacy systems to BW to BPC on HANA system.
• Providing solutions to the complex requirements using BW 7.4 SP11 Info providers with BW 7.5 Business Content SP 8 (Created Info Objects, Master Data Info Objects, Advance DSOs and Composite Providers) for Business Models.
• SAP HANA Studio is used to create Advance DSO, Open ODS and Composite Providers for Business Models.
• Extracted data from COPA, GL, Sales and Material Management data into BW info cubes to do Plan in BPC.
• Identifying the area to improve the performance by utilization of BW HANA.
• Created flat file extraction in development environment to validate and reconcile data for Business Reporting format.
• Written/Programed code to get Hierarchy structure data into table columnar format, which will help in break down reporting in SAP BO Web I.

Environment: Infinium, BODS, SAP ECC 6.0, SAP BPC, SAP HANA and SAP BW 7.4 with SP15.

Confidential, Auburn Hills, MI

SAP BIConsultant

Responsibilities:

• Gathering Requirement and Analysis on the requirement.
• EDW Data flow design and Solutions from end to end.
• SDA (Smart Data Access) to extract structured extraction from Oracle
• Created data modeling for sales integrated with warehouse and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views using SAP HANA SQL Script and CE functions.
• HANA database from external end user report portal using real time jobs in data services 4.0 designers
• Created Flat File Formats in SAP BODS & Extracting data from Flat Files and Loading in to Staging Environment and Preparing SAP BODS Custom Functions for handling deferent derivate calculations for business Steps to Integrate SAP ECC and Data Services, Transformation, loading and execution into HANA DB
• Process involved in the data extraction between SAP ECC and BODS
• Created Analytical views for the transactional data, Attribute views for the master data
• Used CE Functions in SQL Scripts to get MAP (Moving Average Price for Materials)
• Created Stored procedure to extract data for specific material group to get discount calculation based on the MFG dates
• Created users and role management, Analytic privileges, Application privileges, Repository privileges
• User administration and role design and assignment, administrators can use either the graphical user
• Interfaces in the SAP HANA studio, the SAP HANA Web-Based Development Workbench (Web IDE), or use direct SQL commands.
• SAP HANA security patches are published according to the general SAP security patch strategy in SAP security
• Worked on various joins like Text, Inner, Left outer joins.
• Export and Import used to transport developed objects.
• Filtered data flow with Returned orders raised by the Dealers
• Involved in initiation of Parallel data loads for large Tables and Clustered tables extraction from ECC
• Created calculation view of type SQL script in procedures
• Input Parameters and Variables created to various modules to select the data dynamical by filtering
• Created Analytic Privilege and assign restriction
• Assign the Analytic Privilege to User to restrict the data on HANA Views

Environment: Oracle, BODS, SAP ECC 6.0, SAP HANA 1.0 and SAP BW 7.4 with SP10.

Confidential, Jackson, MI

SAP BIConsultant

Responsibilities:

• Gathering Requirement and Analysis on the requirement.
• Provide Recommendation on Hardware Sizing and Architecture.
• Involved in migration project from SAP BW 7.3 to BW 7.4 on HANA DB.
• SDA (Smart Data Access) to extract structured/unstructured data from HADOOP HDFS system and SCOOP is used for structured extraction.
• SAP HANA Data provisioning technology using SAP LT
• Worked with team to manage and maintain SAP HANA application
• Created Calculation views using SQL and Graphical
• Created Stored procedure, SQL Script and called in calculation views
• Created Data flow for Sales, Billing and other customized areas
• In data flow used Projection, Aggregates, Joins and Unions
• Join types like left outer, right outer, inner join, text join are used in data flow.
• Involved in Open Source HADOOP connection with HANA system
• Created source to target mapping documents, job dependency charts.
• Defined mapping rules for ETL.
• Defined Technical Design document.
• Involved in legacy historical data conversion from existing ODS & DW tables to new ODS & DW tables.
• Liaise with Business users and Business Analysts regarding requirements.
• Involved in System integration testing along with other team members using various source data scenarios.

Environment: SAP HANA 1.0 and SAP BW 7.4 with SP8, HADOOP, SAP BODS, BO Web I, SAP ECC 6.0,.

Confidential, Chicago

SAP BIConsultant

Responsibilities:

• Working on a complex application that address client/business requirement.
• Cost Cutting edge and performance is equals to HANA but column level storage is super faster than the existing BW existing database.
• Mission-critical and complex applications that address unique business requirements and bring individualized process innovation to market
• Identified standard Data Targets and changed the existing structure to Store Data in Column level.
• Worked on HANA SLT and Analytical, understood the business challenges and translated them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Converted the Functional Specifications to Technical Specification on BO DS, BO Web I, Bex
• Developed the Reports that includes Shopping Cart Analysis, Procurement Detailed Report, Price variance
• User and role management, Analytic privileges, Application privileges, Repository privileges
• User administration and role design and assignment, administrators can use either the graphical user interfaces in the SAP HANA studio, the SAP HANA Web-Based Development Workbench (Web IDE), or use direct SQL commands.
• SAP HANA security patches are published according to the general SAP security patch strategy in SAP security
• Monitoring, Supplier Receiving Analysis, AP Ageing Report and Goods Received vs Invoiced

Environment: SAP R/3 All Modules, BW/BI, HANA, BO and SQL Server

Confidential

BW Sr.Consultant

Responsibilities:

• Gathering Requirement and Analysis on the requirement.
• Provide Recommendation on Hardware Sizing and Architecture.
• Interacting with Client, Managers, SME's, BA and Database team.
• Extensively in meetings and interviewing Business and Power users, to determine the sources, data Layout, Business needs, and naming conventions of the column and table names.
• Performed complex troubleshooting, root cause analysis, solution development and implement reporting systems to address the issue.
• Worked on Ralph Kimball methodology for Star and Snowflake Schemas, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Coordinate with other teams to ensure availability of Source Data.
• Enterprise wide Data Quality Dashboard
• Worked with various teams to setup user access levels, and server sizing.
• Guiding the development team right from requirement to deployment.
• Involved in ETL end to end implementation.
• Utilize standard functionality Business Content of the systems
• Build a global platform enabled through SAP BI functionality
• Legacy system database source and fields identify with SAP Data Source
• Lead the Project and Guiding to the Tech & Functional consultant to freeze the requirement.
• Initially we started with few Financial Modules from SAP and EDW view and integrated/consolidated the data SAP BI.
• Identified standard Data Targets and changed the existing structure to Store Data in Column level.
• Developed the Reports that includes Shopping Cart Analysis, Procurement Detailed Report, Price variance Monitoring, Supplier Receiving Analysis, AP Ageing Report and Goods Received vs Invoiced
• Created InfoCubes for CO-PA for Costing Based.
• Created InfoCube for Gift Eligibility and MultiCube with Gift Eligibility and FI-GL for the Gift Eligibility accounting report.
• Business Objects Data Service (BODS)
• Designed ETL framework& jobs.
• Created source to target mapping documents, job dependency charts.
• Defined Technical Design document.
• Created Custom ABAP programs to pull CLOB data from ECC.
• ETL Design & use of Complex ETL routines to extract data from ODS (converting business functional specifications into mappings/workflows).
• Liaise with Business users and Business Analysts regarding requirements.
• ETL Design (converting business functional specifications into mappings/workflows)and testing
• Tuned performance for large data files byincreasing block size, cache size and implemented performance tuning logic on sources, workflows, and data flows.
• Performance tuning using Recovery mechanisms
• Implemented Server groups to use advance performance tuning feature such as parallel data flow.
• Involved in writingDS scriptsand also used some built-in functions like Search, Replace, Lookup ext and Custom Functions for ETL audit process.
• Created Data Services mappings to load the data warehouse,the mappings involved extensive use of simple and complex transformations like SQL Query Transform, Table Comparison, Query, etc. in Data flows.
• Involved in System integration testing along with other team members using various source data scenarios.
• Experienced in scheduling and monitoring of jobs using SAP Redwood (CPS) during pre-production phases.
• Involved in code enhancement, testing based on change request (CR) from end users.
• Experience in debugging execution errors usingData Services logs (trace, statistics and error) and by examining the target data.

Environment: SAP BW, HANA,IBM Cognos 8.4 Data manager 10.2/10.1.1/10.0/8.4 , MS SQL server 2008, Oracle 10g, TOAD, Cognos Framework Manager and Cognos Report Studio.

Confidential

DW & SAP BI Manager

Responsibilities:

• Proposal, Project Plan and Time Estimation.
• New Source system to Sand box connectivity.
• Setup table for LO modules and Initialization in BI.
• Gap analysis between existing and future versions
• Client visit and demonstrated SAP BI functionalities, advantages of SAP-BI Product and capabilities of Birlasoft BI consultants.
• Prepaid Business Case study by taking inputs on their daily business.
• Supporting Project Proposal Signoff.
• Design Process Chains for daily extraction of data and maintenance for day-to-day schedule.
• Involved in master data loading and transaction loading.
• Design and develop master data for further analysis
• Mapping data from source to target, create transformation,PSA and DTP
• Map loads and integration with SAP ERP data.
• BI error analysis and skills to debug.
• Daily monitoring on Supporting Team
• Checking on the requirements changes on reports and Data loads
• Involved in System integration testing along with other team members using various source data scenarios.
• Experienced in scheduling and monitoring of jobs using Control - M during pre-production phases.

Confidential

BI Consultant

Responsibilities:

• Actively participated in Project Preparation, Business Blueprint Requirements Discussion and Realization.
• Activated required standard reports and did customized reports.
• Transferred the Application Component.
• Process chains.
• Performed Business data modeling and analysis and have thorough understanding of relational data structures, Extended Star Schema and OLAP concepts.
• Benchmarking report from Inventory, Purchase,Sales and Pricing Cube. Created a new cube for Pricing
• Daily Process Chains and Info Package Group Load monitoring.
• Defining Sources(i) Database as a source(ii) Flat Files sources, Defining Targets(i) Importing from database(ii) Creating a new target(iii) Creating target database objectsInformatica Designer, Mapping Introduction, Source Qualifier, Ports, Mapping - Table to Table, Mapping flat file to Table, Connected / Unconnected Transformations, Active and Passive Transformations, Source Qualifier Transformation, SQL override in Source Qualifier Transformation, Mapping Source Qualifier as Filter, Source Qualifier to join data, Filter Transformation, Expression Transformation, Sequence Generator Transformation, Rank Transformation, Router Transformation, Aggregator Transformation, Joiner Transformation, Stored Procedure Transformation, Connected and unconnected Transformation, Union Transformation, XML Transformation, Mapping Wizards, Implementing Type-I, Type-II and Type-III mappingsInformatica Workflow Manager, Workflow Introduction, Tasks, Workflow Tools, Connections, Defining Tasks.
• Reporting from Other Data Sources, Introducing Web Intelligence, Accessing corporate information with Web Intelligence,
• Understanding how universes allow you to query databases using everydaybusiness terms.
• Managing documents in InfoView, Viewing a Web Intelligence document in InfoView, Customizing InfoView, Setting InfoView Ps, Creating Web Intelligence Documents with Queries.

Confidential

Consultant

Responsibilities:

• Oracle Cursors, Procedure, Triggers and VB application forms
• Created Tables, Synonyms, View and Cluster Tables
• Joined referential Integrity
• Creating Reports in the Benefits module