PROFESSIONAL SUMMARY:

• BI/BW/HANA/BOBJ/BODS/TABLEAU/ANALYTICS Consultant.
• Multi - faceted Business Intelligence & Analytics/ETL professional with a track record of successful projects, and proven expertise in designing, developing BI Solutions. I bring both technical and functional expertise with strong leadership & teamwork skills.
• Overall 12+ years of Data-warehouse/Database/Reporting Writing/ Lotus Notes (Domino) and Java experience with 8+ years of extensive experience of working in all phases of large complex enterprise BI projects as Lead/Consultant.
• Senior-level Business Intelligence - Analytics Consultant with extensive experience in design, development and implementation of cost-effective, high-performance technology solutions to meet challenging business needs.
• Excellent knowledge of relational data modeling and data warehousing models.
• Passionate about BI/BW & Analytics/ETL and driven to recommend and deliver real value and innovative work applying Technology, functional knowledge and best practices.
• Innovative and practical Business Intelligence consultant with extensive project delivery experience who engages with all levels within the business.
• Worked as Onsite coordinator for projects based out onsite/offshore model.
• Delivered high-quality BI/Data solutions in complex and multi-disciplinary business organizations to budget, scope and plan.
• Experienced in developing strategy roadmaps and proposal discussions.
• Highly analytical in problem solving with the ability to apply original and innovative thinking.
• Excellent stakeholder management skills with the ability to support various stakeholder groups.
• A strong communicator, with the ability to lead and mentor project teams, provides guidance to senior management with a high level of customer focus.
• Experienced in working on high-profile, cross-department transformational projects and have the experience to start contributing from day one.
• Experienced in conducting end-user training for business users, developing Business Process documentation and technical design documents.
• Worked on setting up processes for various testing cycles like scenario testing, integration testing, regression testing, and customer acceptance testing using tools like HP ALM
• Hands on experience on Agile Methodology.
• Conducted workshops and presentations to validate business requirements and solutions with the end user community. Developed business process documentation.
• Ability to involve in complex development and integration efforts and mentor peers, users and staff.

EXPERTISE INCLUDES:

• Team Management
• Requirements (business rules) gathering and analysis
• Expert in Business improvement implementations.
• Presentations-Workshops, Educating End users; End users Training.
• Good Analytical and Problem solving skills.
• Source To Target mapping.
• Report Writing
• Data Analytics

TECHNICAL SKILLS:

SAP BW,BW on HANA, BW/4HANA SAP CRM,APO, HR, BPC, FI, MM,CO, etc., SAP NATIVE HANA, HANA LIVE;SAC SAP SLT Replication process SAP Business Objects Data Services (BODS) SAP BEx Query Designer; SAP Business Objects(SAP BOBJ): BO Explorer;Analysis for Office, Design Studio, SAP Lumira, Web Intelligence, Universe (IDT), Crystal Reports, Dashboards. SAP BEx, Query Designer, Web Application Designer (WAD) Tableau 10.X Webfocus ERP Packages: S/4HANA/ECC 6.0/ SAP R3-4.7/4.6C, 3.1C. Databases: Oracle, MS-Access, HANA SAP Functional Areas: Finance, Logistics, Manufacturing, HR, CRM, Utilities, APO, Integrated Planning, BPC. Domain Knowledge: Automotive, Manufacturing, Finance, EHS, Medical Devices (Health Care) and Public Sector.

PROFESSIONAL EXPERIENCE:

Sr. SAP-BI/BW HANA/ANALYTICS CONSULTANT

Confidential, WI

Responsibilities:

• Identifying business requirements and analytical needs.
• Working on End-End implementations projects in FI Area which includes COPA, CCA, WBS, CAPEX, Product Costing, etc.,
• Creating advance data models and Data flows and proficient in designing Composite Provider, ADSOs (Advanced Data Store Object); Open ODS views; Operational Data Provisioning (ODP).
• ABAP development which includes writing transformation routines, Exits, Datasource enhancements.
• Working on Standard and custom defined LO Extractors. Installed relevant SAP Business Content as per the requirements.
• Worked Inventory datasources 2LIS 02 BX ; 2LIS 02 UM ; 2LIS 02 BF. Init Stock; Filling setup tables of Material Movements & Revaluations.
• Creating and mapping all required fields with field based and info objects in the BW system.
• Working on ODP Extractors.
• Migrating 3.x; 7.x applications to BW 7.5 on HANA for further enabled by the availability of new technology BW4HANA.
• Migrating 3.x; 7.x APD for HANA for further enabled by the availability of new technology BW4HANA.
• Replicating the required data from SAP and Non-SAP to BW
• Modelling on BW Hana Optimized objects on Eclipse environment.
• Involved with SAP BW HANA modeling and optimization scenarios including Hybrid scenarios with HANA views.
• Production Support for the mixed scenarios which were designed and developed on HANA calculation views.
• Involved in implementing security for the models created.
• Creating process chains for the developed projects.
• Query designing on HANA studio.
• Managed on time delivery of various monthly and weekly KPI reports/Dashboard reports.
• Created firm-wide dashboards and automated reporting.
• Contributing to release/change management process.
• Participating in full project lifecycle modeling.
• Providing estimates for assigned tasks and work efforts.
• Providing project and task updates on a timely basis.
• Supporting UAT activities.
• Providing post Go Live support.
• Knowledge sharing between Business and IT Teams.
• Work within the PMO to and other stakeholder to in corporate best practices.

Environment: SAP BW 7.5 on HANA; HANA Studio, BOA; SAP Native HANA, ; Share Point, SVNService Now; Azure, BODS, SAC(Cloud Reporting).

Sr. SAP-BI/BW HANA/ANALYTICS CONSULTANT

Confidential, NORTH HAVEN,CT

Responsibilities:

• Responsible for leading a group of PMV Data Analysts in developing statistically based adhoc reports utilizing data generated by the Client's complaint system to assist in the evaluation of safety triggers by PMV Analysts.
• Served as the key subject matter expert on analytics/business intelligence.
• Identified business requirements and analytical needs.
• Provided leadership in the administration of the Client's Complaint Tracking System (CTS) across the various Surgical Solutions Group sites.
• Involved in enhancements, upgradation, migration activities related to system.
• Created advance data models and Data flows using the Wizards and proficient in designing Composite Provider, ADSOs (Advanced Data Store Object); Open ODS views; Operational Data Provisioning (ODP).
• Involved in creating BW Remote Cubes, Multi-Providers, DSO Objects, Info Cubes and complex transformations.
• Involved in ABAP development which includes writing transformation routines, Exits, Datasource enhancements.
• Worked on Standard and custom defined LO Extractors. Installed relevant SAP Business Content as per the requirements.
• Involved in end-to-end implementation projects of combination of Non SAP +SAP+ S4 HANA (ECC)
• Created and mapped all required fields with field based and info objects in the BW system.
• Replicating the required data from SAP and Non-SAP to BW
• Modelling on BW Hana Optimized objects on Eclipise enviroment.
• Involved with SAP BW HANA modeling and optimization scenarios including Hybrid scenarios with HANA views.
• Created HANA models which includes attribute views, analytical views, calculation views.
• Customized HANA Live Data Models as per business requirements.
• Involved in implementing security for the models created.
• Created SQL queries.
• Involved in production support issues which includes creating and montioring process chains (automated data loads); reporting issues fixes; data load fixes; Montioring webi report schedules; Scheduling/Bursting reports in excel/csv/pdf formats.
• Designed front end reports using Query designer and in Analysis Office (AO).
• Designed, created and validate adhoc reports on SAP Business Objects (BOBJ/Webi Queries) on various aspects of complaint activities to a multitude of different departments located in different locations.
• Managing Webi Folders, Documents, Reports within BOBJ.
• Managed on time delivery of various monthly and weekly KPI reports/Dashboard reports.
• Created firm-wide dashboards and automated reporting.
• Created Metric/Dashboard reports for Senior Directors, Senior Managers for better decision making.
• Created data visualization reports using BOBJ and Excel for further data processing and create charts/graphs.
• Created Aging Investigations reports; P50/P90 day reports.
• Created MDR/MDVs; Complaint Investigations; Regulatory Inquiry’s metric reports.
• Created rolling 12 Months MDR/MDVs Dashboard reports; rolling 6 weeks closed complaints metric reports.
• Created Summarized Closed/Voided Complaint dashboard reports.
• Mapping the fields between legacy and current system.
• Developing Weekly/Monthly analytics reports on complaint handling metrics.
• Designing and writing Webi queries. Designed and Created Excel As a data source queries.
• Performing weekly/month-end reporting closure activities.
• End users training on BOBJ(Webi) and reports writing trainings.
• Coached team members on BOBJ and gave technical support as and when required.
• Involving in reconciliation; Validating the data.
• Contributing to release/change management process.
• Participating in full project lifecycle modeling.
• Providing estimates for assigned tasks and work efforts.
• Providing project and task updates on a timely basis.
• Supporting UAT activities.
• Providing post Go Live support.
• Knowledge sharing between Business and IT Teams.
• Work within the PMO to and other stakeholder to in corporate best practices.

Environment: SAP BW 7.5/BEx/AO; SAP Native HANA, HANA Live ; SAP BO/BOBJ/Webi 4.2; S4 HANA; MS-Access ; MS-Visual Studio ; SQL / T-SQL,Cognos, Salesforce, Share Point, SVN, Service Now; Informatica.

TABLEAU CONSULTANT

Confidential, MI

Responsibilities:

• Worked on self directed project two mini projects: Super Store ; Track bugs(Issues) that were filed by department and which includes the below technical.
• Hands-on experience in building Analytic Dashboards using Tableau Visualization tool.
• In-depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Created complex formulas and calculations with in tableau.
• Used Navigation and drill down features in Tableau dashboards.
• Designed analytical reports by blending data on a single worksheet on Tableau Desktop.
• Experience with, ER Modeling, Dimensional Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Experience with ETL tools and Relational Database Management Systems (RDBMS) - Oracle, SQL server.
• Ability to develop, designs, estimate, test and deploy ETL packages.
• Expertise in writing TSQL, SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Knowledge on Optimized connections, Data extracts, and schedules for background task and Data refreshes for corporate Tableau server for better performance of the workbook reports.

Environment: Tableau 10.X, Excel, SQL, Oracle

Sr. SAP-BI/BW/BODS. CONSULTANT

Confidential, MILWAUKEE, WI

Responsibilities:

• Identification of Business Needs and Constraints.
• Compiling and translating user requirements into technical design and implementation plan.
• Designing and implementing data integration processes, including data quality and testing.
• Understanding and Addressing Customer Requirements, Areas of concerns and Issues.
• Establishing guidelines, communication with client managers & end-users.
• Preparing Solution/Application Design, Development and go-live execution.
• Worked on integration of BODS with SAP modules and Non-SAP data sources.
• Worked on external system for ETL between ECC and BI.
• Created Jobs, Work Flows, Data Flows, and Scripts, Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Extracted Data from Relational Databases which includes oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
• Created and documenting logical data integration (ETL) strategies for data flows between disparate systems and / or the enterprise data warehouse.
• Perform other duties as assigned by manager to assist in the deployment and scheduling of solutions.
• Providing estimates for assigned tasks and work efforts.
• Providing project and task updates on a timely basis.
• Monitoring production job schedule and correct job failures in a timely manner.
• Creating projects, repositories, data sources in BODS.
• Creating data stores for source and target applications.
• Extracting data from flat files.
• Cleansing of data.
• Gathering further reporting requirements
• Supporting UAT activities
• Providing post Go Live support
• Identification of Business Needs and Constraints.
• Compiling and translating user requirements into technical design and implementation plan.
• Designing and implementing data integration processes, including data quality and testing.
• Understanding and Addressing Customer Requirements, Areas of concerns and Issues.
• Establishing guidelines, communication with client managers & end-users.
• Preparing Solution/Application Design, Development and go-live execution.
• Preparing Technical Specifications to carry out the reporting development.
• Migrated reports from PeopleSoft to SAP BEx.
• Writing BEx queries for infoproviders (YGIGL M01/General Ledger, YCOOM M05/Cost & Allocations, YCOOM M01/Cost & Allocations-Actuals, YMM M01/Procurement), for multiple business units (like IS, Energy, WaterMuni, Corporate, etc.,)
• Creating workbooks to support user reporting
• Updating and create key figure structures
• Creating row structure hierarchies in Bex queries.
• Performing month-end reporting closure activities.
• Developing report hierarchies and structures as per PeopleSoft Reports.
• Involving in group discussions with COE France Team.
• Developing Security/Authorization for reporting
• Formatting reports in workbooks.
• End users training in different business units (like Boston, Canada, Houston, Milwaukee, etc,).
• Involving in reconciliation.
• Creating Analyzer/Broadcaster variants.
• Monitoring the broadcaster process chain.
• Publishing reports to BEx broadcasters.
• Creating formatted queries in BEx for webfocus.
• Executing BI workbooks and creating lookup files for webfocus reporting.
• Providing support for webfocus.
• Providing estimates for assigned tasks and work efforts.
• Providing project and task updates on a timely basis.
• Presenting reports to users
• Gathering further reporting requirements
• Supporting UAT activities
• Providing post Go Live support

Environment: SAP-BW 7.4, ECC 6.0, PeopleSoft, BODS, Webfocus, SQL, Oracle, HANA, HPQCService Now.

SAP Native HANA Modeller/Analytics, INTERN

Confidential

Responsibilities:

• Worked on self directed project.
• Good hands on experience on HANA Studio modeler.
• Created and Organized Schemas.
• Created Datastores;Data flows in BODS to load data from various sources like SAP & Non-SAP to SAP HANA.
• Designed Packages; Attribute ; Analytic & Calculation views.
• Designed Input Parameters/Variables for user entry in Analytic/Calculation views.
• Good hands on experience on SQL Scripting.
• Designed HANA Security which includes User Creations; User Management Roles & Privileges.
• Hands on experience in data replication from various SAP & non SAP sources leveraging SLT (Real time replication Server).
• Hands on experience on DXC (Direct Extractor Connection) - ERP -Embedded BW Architecture & HANA.
• Data Load via SAP BW extractors DXC to HANA from Legacy BW.
• Designed various dataflows in BODS to load data to HANA which includes SQL to HANA ; ECC to HANA ; BW to HANA ; CSV/Excel files to HANA.
• Build reports using reporting tools which includes: Lumira; BO Analysis For Office; Dashboards; BOBJ; Crystal Reports ; Excel Bases Reporting (Source as SAP HANA)
• Hands on experience on Transport Management - BODS ; HANA.

Environment: SAP-BW 7.X ECC 6.0; BO 4.0; HANA; BODS; Lumira;BO Analysis; SAP Crystal Reports

TECHNICAL LEAD - SAP BI/BW

Confidential

Responsibilities:

• Taking part in RFPs (Request for Proposals) for various customers
• Helped Customers in Creating Business Cases for their BI/BW/BOBJ/HANA needs.
• Helped Customers to Upgrade SAP BW (from 3.x to 7.x including 7.3).
• Experience in Upgrade activities which includes requirement gathering; Full systems testing for development/quality/production boxes; Pre-requisites for before and post for upgradation; Alerting users; bux fixes; raised SAP OSS notes for critical issues.
• Understanding and Addressing Customer Requirements, Areas of concerns and Issues.
• Preparing Solution/Application Design, Development and go-live execution.
• Establishing guidelines, communication with client managers & end-users.
• Preparing Technical Specifications to carry out the development.
• Delivery of the tasks as per schedule with the required documentation.
• Involved in supporting and maintaining SAP BW landscapes including enhancements to existing scenarios for FI & SD, Process Chain Creation to automate data load, Data Load Monitoring, fixing issues related to loading etc.
• Involved in organizing the entire Reporting solution across the client's organization.
• Involved in implementing new business scenarios in BW for FI-AP, AR, GL and customized solutions like Extraction of Parked Documents,, Schedule Line, Global Cost Roll, Service Cost Roll etc.
• Involved in creating Reports & Web Dashboards for Top Management Reporting.
• Involved in creating roles and authorization objects for implementing various access rights and security in BW
• Optimized the efficiency of the BW systems and addressed performance issues.
• Involved in end-to-end implementation projects of combination of Non-SAP+ ECC.
• Involved in gathering business requirements from users for sizing and critical area of the business and the system.
• Analysis of data requirements and translation of these requirements into dimensional data models using extended star schema data modeling techniques, with an emphasis on actual implementation in BI.
• Worked extensively on standard and custom defined LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit Configuration, Customization and enhancing Extract Structures transaction data, master data.
• Involved in production support for BPC data loading for monthly sales forecast.
• Mapping all the required fields with the info objects in the BI system.
• Replicating the required data sources from ECC system to the BI system.
• Applying the transformations as per the business requirements in the infosources.
• Exporting the data sources and creating the data mart set up to meet the business functionality.
• Aggregates and the index creation for improving the query performance.
• Data Source enhancements, generic extractors, User Exits and customized delta built up for the data sources, V3 Updates..
• Created Transformations and applying routines for restricting and transforming data.
• Experience in ABAP/4 which includes, Update/Transfer Routines/Start Routines, End Routines and Expert Routines for Complex data transformation Requirements. Experience in creating DTP Filter Routines and Info package Routines User Exits.
• Involved with PSA in monitoring data transfer from source system into BW.
• Created data models and Data flows using the Wizards in BW 7.3 and proficient in designing hybrid Providers and Semantically Partitioned Objects.
• Experience in Open Hub Service
• Involved in performing unit testing in development server and transporting to Quality server.
• Involved in support work which includes Daily process chain monitoring, Background jobs, Support calls which needs to be fixed on priority basis.
• Maintaining Best Practices and Document Repository
• Demonstrated good/effective presentations on SAP HANA to SAP team members across all locations/branch offices in India.

Environment: SAP-BW 7.X ECC 6.0; ABAP/4;HANA; CRM, APO,HPQC.

SUBJECT MATTER EXPERT (SME)

Confidential, PHEONIX, AZ

Responsibilities:

• Worked as SME/Technical lead (onsite co-ordinator) at AMEX.
• Understanding and Addressing Customer Requirements, Areas of concerns and Issues.
• Preparing Solution/Application Design, Development and go-live execution.
• Establishing guidelines, communication with client managers & end-users.
• Preparing Technical Specifications to carry out the development.
• Optimized the efficiency of the BW systems and addressed performance issues.
• Involved in supporting and maintaining SAP BW landscapes including enhancements to existing scenarios for FI & SD.
• Extensive experience in implementing reporting solutions for FI-GL, FI-AP, SD, MM, CRM, Warehouse Management,
• Involved in implementing new business scenarios in BW for FI-AP, AR, GL and customized solutions.
• Creation of Info objects, Info cubes, DSO’s, ADSO’s,MultiProviders and Data Marts.
• Involved in Modeling, Extraction and Reporting.
• Worked extensively on standard and custom defined LO extractors. Installed relevant SAP business content. Logistics Cockpit Configuration, Customization and enhancing Extract Structures transaction data, master data.
• Worked on Routines in Transformations, Enhancement of Data sources.
• Designing and monitoring of Process chains for interdependent processes with tasks like Data loading, aggregate rollups, Cube Compression, Index maintenance, Master data & DSO activation in achieving the best possible performance & data integrity for various data flows.
• Created Analysis Process Designer.
• Design of Queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics, Exceptions, Conditions.
• Created BEx queries for reporting on InfoCubes, DSOs and MultiProviders.
• Created Calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.
• Used ABAP to create Start, End routines in transformations to facilitate various reporting requirements.
• Involved in resolving the Tickets (Incident & change request).
• Maintained Reconciliation's to verify the data in SAP R3 and SAP BW.
• Prepared Unit test scripts documents.
• Involved in performing unit testing in development server and transporting to Quality server.

Environment: SAP-BI/7.x; ABAP/4;ECC 6.0; HPQC