SUMMARY

• Twelve years of experience in the design and development of high quality business applications using client/server, legacy, internet and 3-tier technologies.
• Over ten years of intensive experience in data warehousing related technologies including SAP BI / BW, SAP BusinessObjects business intelligence solutions and ETL. Specialized in BI solutions with multiple full life cycle implementations, portal and SAP Business Objects 4.0 toolset.
• Extensive implementation experience for over ten years in SAP BW/BOBJ. Specialized in Business Intelligence solutions for a variety of industries using SAP NetWeaver BI 7.X, Business Objects, SAP NetWeaver'04, SAP BW 3.5/3.1C, SAP IS-U, SAP ECC, SAP CRM, SAP R/3 4.6C, 4.7. Also familiar with HANA, BPC and related technologies.
• Over five years of SAP BW/BI Architect experience in SAP BI tools, ETL process, data model and flow, BW Reporting - BEx Analyzer, Query designer, EP, Visual Composer, BOBJ tools etc.
• Experienced in architecting custom software development, product development, product customizations and data conversions. Proven ability to perform Gap Analysis, efficiently gather and interpret customer needs and translate them into functional and technical solutions.
• Proven ability to provide solutions for client requirements using SAP industry best practices specialized in implementing and integrating cross BI applications cross functional .
• Great team and individual contributor with significant leadership skills, good communication and interpersonal skills with highest ethics and positive attitude towards work.

SKILLS

• ERP SAP ECC 5.0/6.0, SAP R/3 4.7, IS-Media 4.72, IS-Utilities, SAP BW 7.3, 7.1/3.X, SAP BPC 10.0
• Reporting Tools BEx Analyzer, Query Designer, Web Application Designer, Business Objects.
• Languages ABAP, SQL, MySQL
• Operating Systems Windows 2000, Windows NT, Windows 7 and LINUX
• Databases HANA, Oracle

EXPERIENCE

Confidential

SAP BW/BI Architect

• Served as a SAP BW techno-functional SME for Short Term Reporting project.
• Involved is gathering requirements for the business deliverables for the SCM and Customer Service Reporting.
• Works closely with all business users and source system counter parts with regards to the Alere International and Alere US entities reporting requirements.
• Created, managed and executed the BW Project Plan through follow-up, status tracking of tasks/activities for realization, testing, cutover and post go-live support.
• Developed - DSO, Cubes, Transformations, DTP's, Process Chains, MultiProvider, Semantic Partitioning and BW queries for the Reporting Solution.
• Developed Purchasing reporting solution with KPIs and exception reporting.
• Served as an SME for SCM and Customer Sales Reporting Enhancements.
• Leveraged the new BW 7.3 functionality for process chains, Infoproviders etc.

Environment: SAP BW 7.4, SAP ECC, SAP BI 4.1, BEx Analyzer, and Windows 8.

Confidential

SAP BW Architect

• Served as a SAP BW techno-functional SME.
• Involved is gathering requirements for the business deliverables for the HCP/Sunshine Phase II implementation as part of the Affordable Care Act.
• Works closely with all business users and source system counter parts with regards to the HCP reporting requirements.
• Build the RICEF object list for the new Sunshine Phase II implementation.
• Created, managed and executed the BW Project Plan through follow-up, status tracking of tasks/activities for realization, testing, cutover and post go-live support.
• Developed - DSO, Cubes, HybridProvider, Transformations, DTP's, Process Chains, MultiProvider, APDs, OpenHub and BW queries for the HCP/Sunshine Reporting Solution.
• Developed custom master data reporting solution with KPIs and exception reporting.
• Served as an SME for HCP/Sunshine Reporting Enhancements.
• Responsible to completion of 20 new BEx reports and 2 flat files across custom HCP/Sunshine Reporting Solution.
• Lead team of 4 with onshore/offshore model.
• Extensively involved in Integration Testing, UAT and regression testing of all back-end and front-end objects of HCP/Sunshine Reporting Solution.
• Leveraged the new BW 7.3 functionality for process chains, Infoproviders etc.
• Followed all the GSM processes in place

Environment: SAP BW 7.3, SAP R/3, BEx Analyzer, Spend Hub, CTMS, Concur and Windows 7.

Confidential

Sr. SAP BW Architect

• As a SAP BW architect, mentored and trained WE Energies resources with the best practices of BW and Business Objects.
• Is responsible for delivering end to end reporting solution from backend perspective to frontend in BW 7.01 and BI 4.0 environment with ECC 6.0 as the primary source.
• Responsible for the development of the conceptual model, logical model and physical model for the cost of Goods Sold, the Vendor Spend Analytics, Plant Maintenance Backlog, FERC Reporting and Power Distribution Reporting.
• Responsible for holding and scheduling workshops for requirement gathering for Vendor Spend, Work Management, Cost of Goods Sold, FERC and Power Distribution reporting.
• Served as a SME for integrating SAP data ERP and Non-SAP data Customer in the BW/BI environment.
• Works closely with system setup teams and provides critical/best practice guidelines related to environment/landscape Infrastructure standpoints.
• Creates and executes project plan through follow-up, status tracking of tasks/activities.
• Prepares technical speciation documents, architecture design documents ARB and IRB documentation as required.
• Successfully completed POC for Vendor Spend/Work Management reporting using BW/BOBJ Custom solution.

Environment: SAP BW 7.0, SAP BOBJ 4.0, SAP ECC and Windows 7.

Confidential

SAP BW Lead /Technical Architect

• As a SAP BW technical lead/Architect, lead, mentored, trained and manages seven IBM resources
• Is responsible for delivering end to end reporting solution from backend perspective to frontend in BW 7.0 environment SAP ECC CRM as the primary sources.
• Created and drive the BW solution design from requirements, assigned and monitored tasks with BW team members.
• Works closely with system setup teams and provides critical/best practice guidelines related to environment/landscape Infrastructure standpoints.
• Creates and executes project plan through follow-up, status tracking of tasks/activities.
• Prepared Technical Speciation documents, Architecture design documents ARB and IRB documentation as required.
• Performs environment test at different stages from development to QA, QA to system test, system test to production including all BW 7.0 toolset usability standpoint.
• Developed, DSO, CUBE, Transformations, DTP's, Info-packs, MP and BW queries for Billing and Invoicing as source for Rate Case with highest quality and defect free reporting solution.
• Developed backend objects for metrics of IS-U Billing Sales, CS, FICA, FICO, GL, FERC, Device Management, EAM, SLLS Surveys, Master Data Analytics, Work Management and Collections.
• Serves as an SME for all IS-U CR B and ERP BW reporting.
• Responsible to complete 90 IS-U CR B and ERP BEx reports across 10 sub-modules.
• Extensive experience creating OSS messages needed to resolve product errors/issues and works with SAP AGS team and product team on solution to the issues.
• Migrated all development objects from Dev/QA/System test/Prod using LCM Lifecycle management console .
• Extensively involved in Integration Testing, UAT and regression testing of all back-end and front-end objects of BW.
• Successfully implemented very complex ISU CRB/CRM/ERP Reporting solution.
• Successfully worked with SAP AGS team support engineers and ISU product team on issues/errors faced during the development phase and validated solutions/fix's.
• Delivered the BI data in the form of flat files using Open Hub techniques and successfully transferred the production data to QA and Dev environments.

Environment: SAP BW 7.0, SAP BOBJ 3.1, SAP ECC, SAP CRM, SAP IS-U CR B and Windows 7.

Confidential

SAP BW Lead and Technical Architect

• As an Architect / technical lead managed 4 internal BI resources Single handedly provided end to end solution of the BI project implementation and ongoing support. The Business components were IS-U Billing, FI-CA, FERC, FIGL, Device Management, EAM, CRM, Project Systems, Work Management and reconciliation of FICA with FIGL.
• Assigned and monitored the tasks with team members.
• Reviewed and prioritized, BI tickets which were created by end users and followed-up with end users regarding the deliverables.
• Performed on call rotation to support the systems that included BI, ECC and CRM.
• Examined the needs of EHp, SP and Notes. Created security roles for each individual departments.
• Responsible to complete 50 IS-U CR B and ERP BEx/Webi reports across 6 sub-modules.
• Successfully created multiple dashboards for different ISU CR B related KPIs.
• Extensively involved in configuration and design of reporting solution for front office, back office, revenue collections, device management, work management and retail sales departments.
• Enhanced the standard FICA Extractors utilizing the User Exits. Developed and delivered the generic extractors for special collections BP. Created BADI user exit for extractors.
• Successfully completed POC for Financial FERC reporting using BW Custom solution.
• Successfully completed BW custom solution for CRM, EAM, Device Management and Service Orders KPIs.
• Documented all custom development, business processes, weekly status reports, and trained end-user groups.
• Developed and delivered the reporting solution for Rate Case and the Year end Billing Data.
• Delivered the BI data in the form of flat files using Open Hub techniques and successfully transferred the production data to QA and Dev environments.
• Prepared standard documentation procedures for Technical and Process standards. ITIL timelines.
• Provided Data Administration development standards for business requirements analysis and BW enterprise modeling.
• Monitored the Table spaces, the total size, total free space or used and remaining sizing artifacts on the back end
• Educated management about the importance of EHp, Service packs.
• Evaluated tool selection and emerging technologies in the area of Business Intelligence.

Environment: SAP BW 7.0, SAP BOBJ 3.1, SAP ECC, SAP CRM, SAP IS-U CR B and Windows 7.