PROFESSIONAL SUMMARY:

• Senior SAP BI/EDW/ETL - HANA/SLT/SDI/SDA/BODS/BW4HANA/S4HANA Architect/Consultant with more than 16+ years of superior experience in EDW/ETL/BI solutions architecture, design and implementation in SAP Landscape environment with a total of 21+ years of IT experience
• Possesses expert skills and proven experience in SAP SLT/HANA, SAP HANA SDI/SDA and SAP Data Services ETL Data Acquisition methods to source data from SAP (SAP ECC, SAP BW) and non-SAP source systems (Microsoft SQL Server, Oracle, IBM DB2 iSeries, structured and unstructured source files (XML, .XLS, .txt, CSV etc) and Hadoop extraction)
• Possess superior and commanding experience in SAP BI solutions architecture, design and implementation based on BW/4HANA, S/4HANA and Native HANA development platform with standard SAP BI content (Data Sources, Transformations, ADSOs, Info Objects, Composite Providers and Data Flows)
• Possesses strong experience in solution architecture, design and development in SAP ERP applications i.e. SD(OTC), MM(PTP), FI(RTR) for various reports including attainment, inventory management, financial reporting and integration reporting with CRM, EWM, PP and QC
• As an SAP Technical Architect/Technical Consultant has worked on 5 SAP HANA implementation projects in manufacturing, retail/distribution, CPG, and Finance domain clients for BW on HANA, Native HANA, BW/4HANA, S4HANA Analytics, HANA Live (with SLT/HANA Sidecar ) projects in SAP Landscape
• Possess strong experience in creating conceptual, logical and physical data models using ER and MDM techniques for Transactional and Data warehousing solutions in SAP and non-SAP target data systems, identifying Business Processes and Business Objects to determine subjects (master data) and business transactions (transaction data) in BTE scenarios
• Worked on Master Data Governance ( MDG ), BW/4HANA Transformation and Transactional Data migration/integration projects as SAP HANA/BI Architect/consultant
• Possesses strong experience in modelling and creation of HANA Information Models, BW Info Providers, Business Objects Universes for specific to business requirements for analytical solutions
• Possess strong technical skills and experience in SQL Queries design and Development for Data Archival/Deletion, Extraction/Integration and building models using various HANA models and development of HANA CDS Views, ABAP CDS Views and HANA/BI reporting on analytical and relational data models
• Experience in BI reports design and development using SAP BOBJ Tools ( Desktop/Web Intelligence), SAP Lumira, Tableau, BEx Analyzer and Excel reporting on MDX provider
• Possesses strong techno-functional experience and knowledge in building SAP ERP BI applications SAP SD(OTC), MM(PTP), FI(RTR), CO and various integration points including HR, PP, BPC data (forecasting, budget, accounts and time) and various reports including attainment, inventory management, financial reporting and integration reporting with CRM, EWM
• Developed Strategy, Blueprints, Roadmaps for Data Migration/Integration/EDH solutions aligning organization requirements, documented approach, methodologies, architectural designs, developed standards, proof of concepts (POC), prototyping and performed solution options evaluation and recommendation
• Well acquainted and experienced with SDLC activities including business requirements gathering, analysis of requirements/gap-analysis, designing, development, testing, deployment and production support
• Involved in all phases of various delivery models such as SAP ASAP Methodology, Agile/Scrum, Waterfall as a BI Architect / Consultant / Developer and involved in SAP support projects and lead the activities in Run SAP and ITIL framework to ensure the business continuity and support with in defined SLAs
• As a Technical Lead, provided technical guidance to development team, coordinated with teams to resolve the issues, implemented effective strategies to optimize the resource utilization, elevate efficiency, improve quality of deliverables within project timelines
• Possesses very good interpersonal skills, a very good team player, can work as consultant with individual responsibilities within project team, comfortable interacting with technical and non-technical audiences, possess exceptional analytical & problem-solving skills, excellent communicator to project stake holders

TECHNICAL SKILLS:

SAP Environment: SAP HANA 1.x,2.x, SAP SLT (DMIS 2011 1 731 SP12), SAP ECC 6.0, S/4HANA, SAP BW/BI 7.x, BW/4HANA, HANA Studio 2, Web IDE (SDI and SDA), SAP Data Services 4.x, SAP BOBJ 4.x, SAP Lumira 1.18, Design Studio 1.8, SAP Solution Manager 7.x, SCTS HTA, LSA, LSA++, Tableau Reporting

ERP Functional: SAP R/3 - SD, MM, FI (AR, AP, GL), SAP CRM, SAP S/4HANA (Simple Finance)

Databases: SAP HANA, MS SQL Server, Oracle, IBM DB2 and other structured and unstructured data

DB Tools/Languages: SQL Developer, TOAD, SQL, SQL Script and PL/SQL, Stored Procedure

HANA: SAP Cloud Platform (SCP), SAP HANA Enterprise Cloud(HEC), HANA Live (Sidecar) and VDMs, HANA Studio, HANA CDS, ABAP CDS, Eclipse, Fiori Apps, OData Services

NonSAP Tools: MSBI (SSIS, SSAS, SSRS)

Modeling Tools and Concepts: ER, MD Modeling, MS Visio, MySQL Workbench, OOAD, UML, EIA (Web Services)

Delivery Methodologies: SAP ASAP/Activate Methodology, Agile/Scrum/Waterfall, Run SAP, ITIL, SDLC

Project Management & Other Tools: MS Project, MS Visio and MS Office Tool, MS Share Point (CMS), Confidential ALM, Confidential QC, BMC Remedy, Confidential Service Center, Service Now

PROFESSIONAL EXPERIENCE:

Confidential, Palo Alto, CA

SAP Technical Architect

Environment: SAP HANA 2.x, SAP BW 7.57, S/4HANA 1705, SAP SLT, SAP HANA SDA and BO 4.2, AWS

Responsibilities:

• Define and Develop the solution strategy for architecture and solution development for new BW/4HANA and S/4 HANA Analytics BI implementation as part of Simplify BI program
• Develop BI strategy, Standards and Guidelines for Simplify BI MVP go-live using BW/4HANA, S/4HANA standard SAP delivered BI content
• Analyze the applications and create application portfolio for S4/HANA data migration and integration with new Operational Data Wearhouse (ODW) build on BW/4HANA with SAP Cloud Platform (SCP for SDI) and SAP HEC
• Analyze the applications and create application portfolio for data migration and integration with new BW/4HANA deployment and BI solution design and development
• Design and Develop solution by staging the S4/HANA Data Sources (replication), design and development of Advanced Data Store Object (ADSO)s, Open ODS Views, Composite Providers, Transformations and Data Transfer Process (DTPs) and data flows design
• Partitioning & Performance Tuning of Advanced Data Store Object (ADSO) persistent tables to improve the BW/4HANA Queries response time
• Implement the Open Hub Destination (OHD) as a data distribution service to deliver the semantically enriched, business purposed data from BW/4HANA Operational Data Warehouse (ODW) into file, database table and third-party tool for integration
• Identifying the specific Simple Finance (FI), SD and MM data sources and tables for specific business requirements for reporting to design the model for custom development
• Design and Develop the ABAP CDS Views for SQL views creation and develop the Custom Data Sources based on Vies for replication into BW/4HANA
• Enhance the existing ODP extractors for existing fields and addition of new fields for reports and analyze the real-time report requirements and identify the data subjects, data tables for Master and Transaction, Hierarchical data and replicate the tables and Identify virtual data requirements for fast track development to adapt to the market changes and prepare virtual data requirements tracking
• Create Remote Source for S4/HANA and Native HANA and create virtual tables in Native HANA schema for specified business required Business Intelligence Reports
• Design Data Flow diagrams for all the identified reports with respect to data sources, source systems and applicable conditions such as filters, joins, unions
• Design and Develop the SAP HANA Calculation Views, Analytical Views and Attribute Views for Data Mart and Reporting layers with intermittent propagation/transformation layers
• Establish the RFC and Database connection for between ODT and S4/HANA for data provisioning through SAP SLT for real-time reporting. Create SLT configurations and replicate the data base tables and build HANA Views and integrate the model and perform the testing

Confidential, San Jose, CA

SAP Technical Architect

Environment: SAP HANA 1.x, SAP BW 7.4 and Bank Analyzer on HANA, SAP ECC 6.0 and SAP HANA SDI/SDA

Responsibilities:

• Data Integration/Migration from Confidential Site collection centers to BW on HANA through various Data Layers and loading into Bank Analyzer (DLL) and pushing into SAP HANA through SDI (Flow graphs)/HANA Procedures in SAP Cloud Platform ( SCP) using Smart Data Integration and Smart Data Access ( for Hadoop)
• Design and development of S4HANA Analytics (ABAP CDS) objects i.e. Procedures, DDLs for tables and views, creation of flowgraphs and integration with SAP ABAP/BW to run the procedures by creating process chains
• Data Sources include SAP ERP/ECC, BW and Bank Analyzer on HANA and non-SAP Data (Flat Files loading for testing) and complete Data Provisioning using SAP SDI(WebIDE) and SAP HANA SDA (for virtual tables creation and integration with HANA DB calculation views
• Development and validation of ADSOs and validation of data loads, delta records and correction of errors
• Design and development of HANA Stored Procedures for Data Archival/Deletion and Integration with Hadoop

Confidential, Chicago, IL

SAP Technical Architect

Environment: SAP BODS 4.2, SAP HANA 1.x, SAP SLT, SAP BW 7.4, SAP ECC 6.0, MS SQL Server 2012, Oracle 9i,11g, IBM DB2 iSeries, Confidential QC/ALM, SharePoint

Responsibilities:

• Business requirements discussion for technical integration, analysis and preparation of technical specifications (Designs), modeling of logical and physical data models for data targets and modeling of transformations
• Technical Integration of various data sources from different source systems including Oracle, SQL Server and DB2 using SLT and SAP Data Services
• The technical integration of Enterprise Data Hub (EDH) with the ConAgra Foods and integration of various source systems from ConAgra Foods with SAP HANA of Confidential
• EDH Integration of Purchasing and Sales applications Master and Transaction Data, Designing and development of Purchase Spend Analysis reports on HANA Views using SAP BI/BO BI tools (template/PoC)
• Real-time Data integration using SAP SLT and HANA Data Provisioning from THS ERP and non-ERP source systems, preparation of data mapping, creation of RFC and DB connections and SLT configurations
• Non-SAP data virtualization using SAP HANA SDA and integration with HANA models for data that was frequently changed and used by multiple downstream systems
• Data Integration using SAP HANA SDI/SDQ using Web IDE for supported non-SAP database drivers for faster/seamless integration (creation of Flowgraphs Task and Procedure based)
• Integration of SLT unsupported data (non-primary keys) with EDH through SAP (BODS) ETL and applied complex transformations where multiple sources needed to be combined to form a single target

Confidential, Chicago, IL

SAP BI/ETL Architect/Consultant

Environment: SAP BODS 4.2, SAP BW 7.0, SAP ECC 6.0, MS SQL Server 2012, Tableau 9.2

Responsibilities:

• Business requirements understanding, technical specifications validation and analysis, preparation of technical designs, naming conventions and standards for development, creation of conceptual and logical models
• Analyze the data points for POS (Point of Sales), Trade Promotion, Kellogg Inventory and identify the related data source systems, data sources and perform feasibility analysis for integration
• Identify and analyze the source tables in ECC related to customer, customer hierarchy, sales and OHD and BEx Queries in SAP BW for data extraction into MS SQL Server and prepare the process flow diagrams
• Perform the technical architecture for ETL process and prepare the architectural diagrams, technical specifications and data mappings
• Design and develop the ETL solution for integration of Business Process and Consolidation ( budget, planned, actual and time) for all the four regions and their accounts and products
• Design and develop the ETL processes including all the Data Services repository objects such as Jobs, Workflows, Data Flows, ETL objects (sources, transformations and targets) and document the same
• Design and develop the data cleansing process and perform the data profiling and cleansing procedure
• Work closely with SQL and BI reporting development team and provide the technical assistance in developing the Stored Procedures, BI (Tableau) dashboard/visualization reports
• Coordinate and setup cut-over activities meeting and lead the activities, setup the Go-Live meeting and initiate go-live activities for release and deployment of BODS and BO content in SAP landscape and coordinate for post deployment support activities under Run SAP and ITIL framework

Confidential, Houston, TX

SAP SLT/BODS/HANA Architect/Consultant

Environment: SAP HANA 1.0 SP09/SP10, SAP HANA SLT, BODS 4.2, BOBI 4.2, MS SQL Server 2012

Responsibilities:

• Understanding business requirements, Identifying KPIs, modeling of logical and physical data models, setup business rules for data migration/transformations, formulate the calculations for business measures(KPIs)
• Define and prepare the data migration strategy and provide solution options and recommendations for SAP(ECC) and non-SAP data migration into SAP HANA, identify sources for batch job loads/real-time data, setup the SAP HANA SLT (for ECC) and BODS ETL configurations (for SQL server)
• Design and implement the Data Provisioning using HANA SLT for SD tables (VBAK, VBAP) and customer (KNA1), setup HANA SDA (for remote source) for SQL source system into SAP HANA and create HANA Schema and database tables
• Create RFC and DB Connections using SM59 and DBACOCKPIT and Configure SLT in SLT server using LTR/LTRC/LTRS for data replication from ERP system into HANA database and configure data replication
• Check and monitor the status in SLT server using IUUC SYNC MON and MWBMON for relevant tables and transfer status and setup the transformation and filtering conditions in SLT server using IUUC REPL CONTENT and perform advanced performance optimization settings in LTRS
• Define and develop the Data Services designer objects, reusability components, jobs, workflows, data flows, create Data Stores and File Formats with in Data Services for particular business requirements to load the flat file collection data into HANA, apply required transforms based on business requirements and perform the data profiling for content, pattern and referential integrity checks for identification of data quality issues
• Design and create HANA Information Views (Attribute Views, Analytical Views, Calculation Views) for identified sales performance, customer analysis reports and apply data security with Analytic Privileges, create stored procedures, complex calculation views using SQL Script, calculated columns, input parameters and create decision tables for what if analysis for trend forecasting of sales
• Design and develop the BO Universes on HANA information models in BO IDT and publish them in CMS repository and setup security (creation of data security profiles and apply them to users) for BI reporting
• Business Objects reporting
• Develop BO reports using BO Design Studio, Dashboard, Web Intelligence, SAP Lumira and Tableau based on business requirements for ad-hoc, tabular, graphical and visualization reports
• Performed HANA administration, performance tuning, implementation of data security (authorization and roles, user and analytic privileges) backup and recovery and tuning activities
• Apply performance techniques i.e. table partition, create explain plan and visualize plan to analyze the SQL queries for performance bottlenecks and rewrite the query to improve the performance
• Coordinate and setup the Go-Live meeting, initiate cut-over activities and go-live activities for release and deployment of developed HANA, BODS and BO content in SAP landscape and coordinate for post deployment support activities under Run SAP and ITIL framework

Confidential, Schaumberg, IL

SAP BWBI/HANA/BODS Architect

Environment: BW on HANA, SAP BW 7.3/7.4, SAP BOBI 4.1, SAP HANA 1.0 SP7, MS SQL Server 2012, SAP BODS 4.1, Design Studio 1.5, Analysis for OLAP

Responsibilities:

• Involved in business requirements gathering, requirements analysis for identified BI reports in SCM for Purchasing and Inventory Management (MM) and sales & distribution (SD)) areas for identified KPIs i.e. Inbound Days of Supply (iDOS), Risk Report, Simulation Report, Shortages Report and Global OPS Finished Goods Inventory (GOPS) and Stock reports
• Prepared technical specifications with architecture, design/modeling and implementation details and documented blueprint for implementation with all technical details including development and deployment
• Analyzed the existing source systems, data sources, legacy data and connection points for data integration/migration to SAP HANA, data security implementation for information Views with respect to business users and data restrictions
• Defined and evaluated various SAP BI/BW/HANA solutions i.e. 1) BW Info Providers acts as source for reporting, 2) HANA views acts as source for reporting 3) only BW managed schema possible (HANA acts as database only) for reporting 4) only HANA database and no BW usage for reporting and recommend the best suitable SAP BI/HANA solution
• Configured SAP BO Data Services for data loading into SAP HANA for Purchasing and Inventory, Sales and Distribution data into SAP HANA for Inventory Transparency Management Reporting
• Identified related data sources in SAP ECC (2LIS 11 VAHDR, 2LIS 11 VA ITM, 2LIS 02 ITM, 2LIS 02 HDR, 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM) and activated data sources, replicated in SAP BW and configured
• Setup the HANA SLT for replication of TCURR table creation in HANA to apply the currency conversions in analytical views for stock values in local currencies
• Create Schema/Tables in HANA for HANA Modeling, create templates (CSV/tab delimited files) for Transaction Data (Inventory and Demand) and Master Data (Material, Plant and Buyer) for EMS (Flat Files) and AP3(SQL)
• Design and develop HANA Information Models (Attribute Views, Analytical Views, Calculation Views) based on BI reporting requirements and create Decision Tables for Simulation report and discounts calculations based on aging of products (Build model for Ageing KPIs)
• Implement Buyer and Product Hierarchies in Attribute Views for drill down reporting and implement Currency Conversion in HANA using Analytical Views for local currency for Material Inventory visibility for global purchasing group
• Create Analytic Privileges for Data Security based on users and data restrictions conditions as per business requirements and develop complex Calculation Views using SQLScript and Stored Procedures
• Create calculated columns, restricted columns, input parameters and variables depending on the business requirement and created Analytic views to be integrated with BW Info Provider to create Virtual provider to be combined with Composite Provider to create BEx Query to be used in BEx Analyzer
• Implement HANA Side Car with SAP Fiori for BI reports performance evaluation based on direct reporting on HANA Virtual Models/HANA XS implementation Vs HANA BI reporting based on HANA Information Views and HANA Live VDMs and SAP Lumira visualization
• Provide technical guidance and support to project team in building the SAP BW Info Providers, data sources replication in SAP BW, BEx queries development and technical guidance and troubleshooting support to Business Objects technical team for BO reports development using Web/Desktop intelligence tools i.e. Dashboards, Design Studio, SAP Lumira and Webi
• As BI HANA Lead Architect lead the HANA integration/development of approved business requirements, implement, monitor and deliver the project in SAP ASAP methodology with UAT Cut-Over and Go-Live activities and conduct training

Confidential

SAP BWBI/HANA/BODS Lead Architect

Environment: BW on HANA, SAP BW 7.2/7.3, SAP BOBI 4.0, SAP HANA 1.0 SP5/SP7, SAP Lumira v1.16, Design Studio 1.5

Responsibilities:

• Requirements analysis and preparation of Blueprint for HANA Migration, HANA BI development, HANA Support strategy for iPower SAP HANA migration / Implementation for CRM Distribution project for Confidential ’s Toyota-Belgium business division
• Prepared technical architecture, design/modeling including data migration and implementation strategy
• Identified SAP and non-SAP source systems for (data sources/extractors) for customers data, Confidential ’s partners data, vehicles data, sales and after sales data for identified KPIs (EVHC, Customers, Working Capital, Financial Summary, Branch Profitability, Bonuses and incentives, claims from manufactures, after sales survey and performance
• Configured SAP BO Data Services for data migration and regular uploads (with scheduled jobs) for Confidential retailing and partners data into SAP HANA, configured import server in SAP HANA Studio
• Configure Import server for SAP tables exaction into HANA and SAP business objects using IDocs for identified business objects (Customer) with in CRM and SD functional area
• Created Jobs, workflows, data flows and applied transforms to load the data into SAP HANA for EVHC and Service Bookings (RTC), Stock Management, Working Capital, Parts & Service - ADP, Monthly Finance Data - Actuals and Budget data (Motamacs), Financial summary and Branch Profitability (MPC), Region, Country, Brand and Unit (Advantage)
• Activation and replication of standard data sources for General Ledger, Accounts Receivable and Account Payable for creation of Working Capital and Financial Summary reports with standard data sources extraction using 0FI AP 4, 0FI AR 4, 0FI GL 14 and enabling of corresponding BI content (Info Cubes in SAP BW)
• Established the HANA SLT connections to ERP system for SLT configuration to extract the currency conversion data for real-time analysis for BI Sales and After Sales reports for global user’s visibility in local currency
• Designed and implemented HANA Information Views, Analytic Privileges for data security, Decision Tables for promotions and what if analysis for sales projections
• Created Calculation Views utilizing the SQLScript and Stored Procedures for complex business scenarios and performed performance tuning on base tables and HANA models using table partition, Explain Plan, Visualization plan and redefine the queries if necessary to improve the response time
• Designed and validated BO reports on HANA Analytical Views, Calculation Views, and relational connection on HANA tables, BICS connection for BW Cubes, BEx Queries
• Setup and lead the development and implementation activities such as code migration, cut-over activities, release and deployments, Go-Live and Support activities
• Implemented the project in SAP ASAP Methodology, coordinate and conduct meetings with client business and technical teams and project teams for status updates and planning the activities and coordinate with SAP OSS teams for issues resolution

Confidential, Oldsmar, FL

SAP BODS/BOBJ Architect

Environment: SAP BOBI 4.x (Dashboards, Design Studio, Web Intelligence), BODS 4.1, Oracle 10g, MS SQL Server

Responsibilities:

• Gather the business requirements for identified BI Reporting (KPIs and business rules), identify the source systems and data maps, document the data quality requirements for iPad HLS Validator project
• Analyze the requirements and translate them into technical specifications and create solution architecture, design and technical implementation artifacts for data integration and BI/BO reporting for identified reports
• Prepare data integration/conversion strategy, define ETL process for data acquisition from source systems into centralized target database (MS SQL Server) for BI reporting and create logical and physical data models using ER, MDM techniques, create database schema and tables using for BI solution for viewership ratings captured through iPad and TV monitoring devices
• Design and implement ETL process (BODS DI/DQ) for data acquisition from collection centers (Flat File s, MS SQL Servers) to into central database (Oracle), perform data profiling for basic validation, pattern validations and relational integrity checks and cleansing of the data, create jobs, workflows, data flows, transforms, Data Stores, file formats, target tables
• Create relational OLAP connection to centralized database, create data foundation, business layer and publish the universe, design and develop the BI reports based on the mockup screens provided by business team, identify report labels, data fields and required charts for interactive reports (Dashboards) in SAP BOBJ tools,
• Configure /fine tune the performance parameters of BO universe by implementing, aliases, contexts and query optimization and resolve loops to improve the performance of query execution
• Coordinate with BI Platform team and perform BODS ETL admin activities including profile user’s creation, repository setup and configuration, data services connections in BO CMS, job server configurations, Object Promotion (export/import) and security setup and configuration
• Coordinate with SAP BO Admin team and support code deployments and migrated content between environments, report jobs schedules for viewership rating reports and manage objects, reports, universes and database connections within BO and ensure to resolve the issues related to single sign and data security
• Coordinate and create, maintain enterprise folder structure, custom access levels for business users and groups and export universe, reports and other contents to repository making it available to end users
• Setup new universe connections, access restrictions, checked integrity, cardinalities, optimized query processing time by using key features of Business Objects like aggregate awareness, indexing within designer and audit the application usage of reports and security through the repository or auditing features
• Create interactive graphical charts/reports for identified KPIs in Design Studio by using various components charts such as Pie, Line and Column charts with interaction and ad-hoc reports in Desktop/Web Intelligence
• Integrate the iPad HLS validator system with Nielsen Helpdesk support system using ITIL framework to address the support issues coming in post-production

Confidential, Schaumburg, IL

SAP BW/BI/BOBJ Consultant

Environment: SAP ERP, SAP NetWeaver BW 7.1, BOBI 4.0

Responsibilities:

• Requirements gathering and analyzing for OMAR (Order Management and Accounts Receivable - Customer Analysis) and Pony Tail data migration and BI porting using SAP BW/BI tools
• Translate the functional requirement into technical design and specifications with details containing required standard data sources, customization requirements, standard BI content, extractors, ETL process and data flow diagrams
• As a Lead SAP BI Architect, design the EDW architecture for SAP BW/BI Reporting for Sales and Finance (Account Receivable) reports, define the ETL process, data modeling and BI reporting
• Identify the SAP R/3 data sources / tables from source system for enhancement and replication into SAP BW EDW and enable the required standard SAP BI content and model the new additional info providers for data targets for reporting
• Design and model info provider objects based on business requirements to model the InfoObjects, DataStore Objects, InfoCubes, Transformations and create Info Packages and DTPs
• Installation and enabling of standard data sources of SD module (2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL) in SAP R/3 system using LO Cockpit Extraction (LBWE) and replicate into SAP BW data warehouse for BI reporting
• Installation and enabling of standard data sources FI modules (0FI AR 4, 0FI AP 4, 0FI GL 4) in SAP ERP system and replicating in SAP BW system to enable the data replication from ECC to BW for reporting
• Enable standard BI content for SD and FI module in SAP BW, customize and create required Info Providers (InfoObjects, DataStore Objects, InfoCubes), Transformations, create Info Package for data load into PSA, DTPs transfer the data into data targets ( Info Providers) and create and schedule Process Chains
• Monitor Lo-Cockpit activities for procedures like setting up of Update Mode, deleting set up tables, filling up of set up tables and to load data from ECC to BW system for SAP R/3 Logistics (LO) Sales and Distribution data
• Perform SAP BW Info Providers tuning by implementing various performance tuning methods such as aggregation, compression, rollup and creation of SPOs
• Design and create reporting layouts based on the mockup screens and develop queries in BEx Query Designer and generate reports in BEx Analyzer and graphical reports using SAP Design Studio for Orders Management Account Receivables (OMAR)
• Involve in all phases of deliverables in SAP ASAP Methodology across all the phases of project and coordinate with the SAP support teams, project support teams to migrate the transports from DEV, QA and to PROD
• Coordinate and communicate with Customer IT and Business leads to update the ongoing status, work and resolve the risks and issues associated with project releases and resolve the issues

Confidential, Tampa, FL

AMS Support Lead / BI Architect Lead

Environment: SAP R/3 (HCM), SAP BI 4.0, BODS 4.0, MS SQL Server 2008, Oracle 10g

Responsibilities:

• Review the new application proposals for development/enhancements and support projects, understand business requirement, project goals and business objectives, schedule workshops to gather requirements
• Prepare ASAP Methodology roadmap for BI solution delivery, prepare ITIL framework’s Support model for development and support projects under AMS contract, identify BI reporting metrics and KPIs
• Prepare data capture templates, project templates, design and develop BI solution architecture for data extraction, data loading and BI reporting and integrating with SAP and non-SAP sources systems
• Prepare conceptual, logical and physical data models for identified KPIs and analytical reporting for
• HR Onboarding Process, Assurance & Advisory reports and performance measuring on support process
• Develop ETL process, creation of jobs, workflow, dataflow, apply transforms, target tables creation, perform data profiling using basic (content) profiling, pattern profiling and integrity profiling and Cleansing in Data Services Designer for loading into target schema in MS SQL Server database
• Perform HR onboarding process extraction for identified HR metrics and KPIs for BI reporting using SAP standard data sources i.e. 0PA C01, 0OM C01, 0PT C01, 0PABN C01, 0HR PT 2, 0EMPLOYEE, 0HRPOSITION
• Coordinate with third party vendors involved in the project to get the data files for loading into MS SQL Server
• Coordinate with support teams, download the support tickets data in excel format and load the data into MS SQL Server database using BODS flat file loading and create models to measure the support performance
• Coordinate with BO admin team and participate in LCM and CMC/CMS repository activities related to code promotion, security setup for reports (authentication, authorization, access levels, rights, folders creation) based on the user groups and user roles assigned to access the reports
• Review AMS contract for agreed SLAs, periodically conduct review meetings with customer and support teams to measure the application support performance aligning with ITIL framework, provide technical leadership and continuing support and manage the incident tickets, problem tickets, initiate and manage PTN calls to bring the issues to closure
• Identify gaps/weakness in support areas and prepared support service improvement plans, reviewed with customer and implemented the best practices to improve the tickets resolution performance

Confidential, Washington D.C

BODS ETL/BOBJ Consultant

Environment: SAP BOXI 3.1, MS SQL Server 2005, Oracle 10g

Responsibilities:

• Interact with business users, ICS coordinators, Freelancers, Confidential internal IT teams, document technical specifications, understand the as-is architecture, business processes and determine and finalize the scope for BI reporting requirements (KPIs and metrics) for ICS statistics on proposal submissions, responses,
• Confidential financial lending for developing countries and balances
• Design and create the data models for targets for data loading, BI reporting KPIs, setup the business rules, report layouts, field mappings and develop logical and physical data models
• Design and develop the ETL process using BO Data Integrator and Data Quality tools for data acquisition, transformation and loading into target database MS SQL Server from flat files, oracle database
• Create jobs, workflows, data flows, transformations, perform data quality checks by data profiling and correct the data before loading
• Create Relational and OLAP connections to database in BO Universe Design Tool pointing to MS SQL Server and create the data foundation, business layer and publish the universe for identified BI reports
• Create Desktop and Web Intelligence reports using Xcelsius Dashboard, Designer studio and web intelligence rich client for identified KPIs (ICS Correspondent Performance Report), Proposals submission and response, Confidential financial leaning
• Work with BI/BO platform team for admin related activities such as BO reports deployment using LCM, CMS activities, configure authentication, access levels, rights, folders creation for reports based on the user groups and assign the rights to relevant reports and resolve the report performance issues by analyzing the queries and introducing aliases and contents, short cut joins in universes design and security implementation

Confidential, Charlotte, NC

BI/Integration Consultant

Environment: BOXI 3.0, MSBI (SSIS, SSAS, SSRS), MS SQL Server 2005, Oracle 10g, Teradata 8.2, Siebel CRM, MS Share Point Services

Responsibilities:

• Requirements/Fit-Gap analysis for identified KPIs, BI reports for Client Connections (CRM) project in GWIM, prepare technical designs, identify source systems and data sources data integration/migration
• Identify the data maps in CRM area for Leads, Opportunities, Activities, Notes, Customers,
• Accounts and Book of Business functions for dashboard reports and graphical reporting using MSBI tools
• Prepare technical specifications including data models (using ER and Dimensional Modeling), design ETL process to migrate/integrate the date from Oracle into SQL Server and create data marts
• Create and review the data extracts created in flat files from Siebel CRM database (Oracle) and perform quality checks, migrate/integrate with MS SQL Server using MS SSIS
• Create relational database connections in BO UDT pointing to MS SQL Server database (Info Cubes), create data foundation, business layer and publish the universe to be exposed in BO reporting tools (Desktop/Web Intelligence) using Xcelsius Dashboard, Designer studio and web intelligence rich client tools
• Resolve the report performance issues by introducing the aliases, contents, short cut joins in universe design for Book of Business, Accounts, Clients, Leads, Opportunities and Activities universes
• Enrich the reports based on calculated contexts, graphical charts to be accessed by Market Managers (MM), Financial Advisers (FA), Market Directors (MD) and Client Managers (CM) and group by Region, Customer
• Integrate and deployment of BO and SSRS reports in Microsoft Share Point Portal with respect to CRM activities related to GWIM banking operations, client connections and mutual funds analysis for global users
• Design test strategy, create test cases, perform testing and validation, coordinate with BO admins for deployment and production support, manage the deployment and releases

Confidential

BI Consultant / Sr. Developer

Environment: BO XIR2 (DI & DQ), MS SQL Server 2005, Crystal Reports 6

Responsibilities:

• Design and develop the ETL/BI solution using BO XIR2 (UDT, DI & DQ) tools for Oil & Gas pipeline analysis
• Design and develop the data models using ER modeling techniques and create the physical database and analyze the requirements, perform data mappings and develop the ETL process for extraction and loading
• Prepare file formats and templates to collect the to collect the pipeline data from pipeline field officers hand held devices and client partners third party applications
• Integrate the data from flat files (collected at field level and placed in central location) into MS SQL Server using Data Integrator (DI) and perform Data Quality (DQ) operations using Match, Base DataCleanse transforms, identify and cleanup the data before loading into target database
• Create Relational connections to MS SQL Server using UDT, create data foundation, business layer and publish the universes to be exposed and used in BO tools for creation of tabular and graphical chart reports for Gas Pipeline Risk Report, Corrosion Report, Monitored Inline Inspection Report, Defect repair Date report
• Design and develop the BI reports using XCelsius Dashboards and Design Studio with interactive graphs and charts to find out anomalies in the reports and measure the metrics performance metrics