SUMMARY:

• SAP BI BW Business Objects HANA Techno - Functional-Reporting Professional with 16 years of extensive experience in IT Industry with clients, such as, Department of State, Confidential, Confidential, Confidential, and Pharmaceutical companies. Experience includes new, implementation up gradation and utilization of SAP with 12 years BI / BW, 8 years of Business Objects, 5 years ABAP and 5 years of HANA. Designs and implements efficient and effective solutions, providing value to Clients. Combines an excellent knowledge of the business with extensive and detailed SAP expertise. Uses Business Process, Configuration and Programming to provide solutions.
• Experienced in using Agile Methodology.
• Analytical, methodical, communicative team player and leader / architect. Very successful in the integration of SAP within a business and in the integration of the SAP modules with each other.
• Implemented many BW and HANA Full life cycle projects along with various modules of SAP HANA FI/CO, SCM, SD, PS, MM Logistics, PP, FM, PM, OF, Procurement. Worked on post implementation and production support projects. Possesses excellent technical, written and verbal communication skills.
• Worked as SAP BI / BW Business Objects Lead / Architect /S.M E (Subject Matter Expert ) / Developer.
• Served as Architect for HANA implementations in real time reporting. Responsible for requirement gathering, translating Functional Specifications into Technical Specifications and Business KPIs into HANA Models (Attribute, Analytic, Calculation views, SQL scripts) & Define the Reports/Dashboards .
• Designed and developed complex reports in SAP BI Business Objects using WEBI, BEx analyzer, BO universes (IDT and UDT), Qwaas, and Xcelsius, Dashboards, Crystal Report 2011, Crystal Enterprise. Worked with BEX queries (free characteristics, formulas, selections, reusable objects like calculated/restricted keys, structures, conditions, exceptions and variables, query views, query elements, Web templates, Report, RRI, (BEx) Query Designer, BEx Analyzer and Workbook design, formatted reports, Information Broadcasting, Portal iviews, Publishing and Dash Boarding.
• Developed complex ABAP drill down reports, interfaces, conversions, function modules, (RICEFW). Created very complex ABAP BW extract programs, functions modules, BEX user exits, BW user exits, transfer routines, start / end / smart expert routines.

SKILL SET:

SAP: SAP ECC (7.0), HANA, BW / BI (7.4), Business Objects (BOBJ), 4.1 & 4.2, BW on HANA, Native HANA, HANA Studio, Toad, and SQL 2008 SD, MM, PS, PM,FM, OF, SCM, SRM, CRM, HR, FI/CO (AP, AR, GL, SL, AM, PCA, CCA), APO, HCM, ABAP, SQL, LSMW, ALV, BAPI, ALE/EDI, RICEF Workflow RFC, and Rev TRAC

Reporting: BI / BW BEx, BODS 4.1 Webi, Crystal Reports 2011, Crystal Enterprise Universe Design Tool (UDT), Information Design Tool (IDT), Design Studio, XCelsius, Dashboards and BI Explorer, and Analysis for Office

Languages: Spanish, English, Hindi and Telugu

PROFESSIONAL EXPERIENCE:

SAP HANA BI Business Objects Lead Developer

Confidential, Arlington, VA

Env: (Native HANA, HANA Studio, SQL 2008, Toad, IDT, and BOBJ 4.1 & 4.2 WEBI)

Responsibilities:

• Worked ad SAP HANA modeler to design using Attribute Views, Analytic Views, & Calculation Views. Developed SAP HANA programming including SQL Script, and CE-Script, write store procedures as needed. Create, delete, insert, modify and manipulate in HANA tables by using the Store procedures
• Business Objects reporting including handling of complex scenarios using joins,Universes from SQL Database and from Hana views. Created LOV tables and Universe Filters
• Responsible for managing the design & architecture across HANA BI / BO 4.0 systems, day to day maintenance, support, development, and assist in the design for the implementation including making of technical decisions which will have an impact on the business future implementations.
• Analyzed the reporting needs & Using Business Objects , created reports aligned in accordance with user specifications, by understanding the system improved the retrieving performance of the reports. Developed Universes. Self-Drag and Drop functionally universes Using Business objects 4.1 and 4.2 and solved the issues and updated existing Universes as per on going requirements.
• Requirement gathering for the Design Studio Layout screens. Design and development for the Crystal Reports and Business Objects WEBI reports which work as a feed for the Dashboard .
• Creating mapping for the data from SQL to all the way to Reports and Dashboards.
• Designing Dashboard / Xcelsius Screens using the build in components like Pie charts, Tabs, Panels, Filters and so on. Displaying the components using the Dynamic Visibility logic. Developed Multiple Tab complex dynamic variable containing WEBI reports
• Provided links on the dashboard to go directly to the WEBI reports for a particular metric.
• Created Dashboards to view Post Management visa approval, BI Fee Accounting (Visa fee collection Confidential system), Non-Immigrant, Immigrant visas by post by country and applicant related attributes. Administer, monitor, troubleshoot, analyze and resolve technical problems.
• Created on Technical, functional specifications, and High-Level Designs Documents.
• Designed HANA models for NIV workload HANA with 200 KPI to keep trach the of the NIV visas Issued, Rejected and Spoiled based on the based on the various Dimension like Post, Region, Date etc. Created reporting universes/User Self Drag and Drop reporting purpose universes from HANA views and SQL tables. Developed multi tab Webi reports in Business Objects WEBI to print the complete history of the Applicant Transactional history including the applicant complete bio data, visa history and pictures. Called sub reports from main report by using the Applicant URL System key.
• Confidential is the underlying ‘Point of Sale’ system used at various overseas posts for Visas. Fee accounting is project to keep track of the all collections and refunds by cashier, by post, by region and the world. Developed Complex views based on Oracle Database, IDT Report universes, IDT User Drag and Drop universes and multi tab complex WEBI reports. Reports included Daily Activity Detail, Daily Fraud Alerts, Daily Discrepancy Alerts/Refunds/ User actions/ Totals/Audit reports and Summary reports for all Details report.
• Created Near real time replication of Consolidated tables of HANA to improve the performance. Work with Infrastructure team on SAP HANA Security including User Management, Roles and migrations.
• Resolved Ongoing Production issues tickets. Conducted demos on the applications development.
• Designed comprehensive BI solutions, translating complex requirements into optimal BI design.
• Conducted quality assurance activities such as testing, peer reviews and check lists.
• Developed HANA /IDT/ WEBI best practices and standards to maintain stable BI environment.
• Build Business Objects dashboards and reports using BO Dashboards and Web Intelligence .
• Developed various Info spaces using BI Explorer based on HANA views and Universes.

Confidential, Alexandria,VA

Env: (BI 7.4 BO 4.1, ECC 7.0, BW on HANA and FI, AP, AR, GL, COED, MM, and FM)

Responsibilities:

• Responsible for design of highly complex business intelligence solutions with SAP Business Objects BI Suite, SAP BW, SAP BW HANA, all aspects of project delivery including estimation, planning, design, development, configuration, testing, deployment and support.
• Develop and enhance SAP BI BW data contents and architecture strategies and BW reports using Business Objects and other interfaces. Oversee and approve BW components from development following standards and a formal release management process. Implement report development standards, ensure that adequate documentation is generated and maintained.
• Definition, design and implementation of SAP SLT replication schemas in SAP HANA.
• Responsible for usage of front-end reporting tools, ETL tools, and technical infrastructure. Delivery of all the Technical Deliverables on the project and ensure overall system performance of BW are in line with Industry benchmark standards.
• Design, configure, implement SAP's Business Warehouse solutions, which include the complex extraction, transformation and loading operational setups, create and maintain ODS's and Info cube, establish and monitor process chains. Manage all technical development for BW system which includes the Staging Area and Data Extraction Services
• Understand current Army BI reports; identify solutions to best answer the business questions. Reconciled ECC source data with BI. Worked with end-users to capture business needs, coordinate with functiona l and/or technical representatives to resolve BI help Remedy desk tickets. Define test scenarios/models. Verify results to ensure BI reporting enhancements are meeting functional requirements. Review and approve development to be promoted, work with SAP development tools such as ABAP, BEX, Business Objects and WEBI.
• Responsible for all the objects related to below mentioned reports (Data sources, user exits(ABAP), BADis, Master data, Transactional data, Enhancements, Complex start routines, end routines, broadcasting, data loads, process chains, DSOs, Cubes, Multiproviders, BEx reports, BUSINESS OBJECTS WEBI reports, and placing the reports in the portal.
• Worked on complex BEX reports, which includes most of them related to Sales, Employee, FI (Status of Funds, Cost by, FCA with COED (Commitments, Obligations, Expenses and Disbursements). Developed TDs, FDs, test scripts/Job Aids for Government review and approval. whole BW/BO/ABAP Team. Data Modeling, Business Objects: Worked on SAP/BW/BO Building universes, Webi Reports. Create complex Process Chains for master data and transactional data and support them. On call support 24/7 pager for nightly loads.

SAP HANA BI BW Business Objects Lead Developer

Confidential, VT

Env: (BI 7.4 BO 4.1, ECC 7.0, BW on HANA, MM, SCM, FI, FTP, PTP and MRP)

Responsibilities:

• Deliver Projects to the BI Manager and partners with the BI Solution Architect, and Customer Engagement team to develop an enterprise class data warehouse that utilizes SAP Business Objects, BW, and HANA technologies.
• Provides technical direction in the analysis, design, development, documenting, testing, deployment, maintenance, and enhancement of standard content and custom complex solutions within the SAP BW, Business Objects and HANA within the Keurig International BI environment.
• Analysis of complex issues, evaluation and selection of existing and new SAP technologies, and leadership of cross-functional teams to meet or exceed users’ requirements.
• Own overall responsibility for the BW backend data architecture. Translate business requirements, high level design and master data requirements into detailed BW Business Objects
• Coordinate testing, cutover, rollout, and transition to production support.
• Develop Business Object Reports models and dashboard reporting solutions.
• Work with the broader BI team identify BW process, data model, and technical design improvements to advance BI reporting and usage across business functions.
• Plan and execute release, support packages implementation, and version upgrades.
• Work with hosting and basis teams for infrastructure maintenance, operating system patch and upgrades, and planning server refresh efforts. Define level of effort and coordinate resources from the BI team to support these infrastructure efforts.
• Deep experience in BW data modelling and preferably data profiling, entity-relationship modelling and dimensional modelling.
• M anage multiple projects or initiatives concurrently. Strong quantitative, analytical, problem solving, and organizational skills. Resource management, interview processing and task assignment. Responsible for translating Business KPIs into HANA Models & Define the Reports/dashboard Layouts. Performed SLT configuration and monitoring, ABAP transformations where ever business logic applied.

SAP BI BW Business Objects Senior Developer

Confidential, Alexandria, VA

Env: (BI 7.4 BO 4.1, ECC 7.0, MM, Logistics, FI, SCM, SD, Business Objects, WEbi, and Crystal)

Responsibilities:

• Techno Functional responsibilities included requirement gathering for HANA implementation & convert them into business analysis, technical design, development, testing, and implementation
• Extensive Functional experience in building HANA data models across functional areas (sales, inventory, Logistics, Finance areas. Worked Functional Specifications into Technical Specifications and Business KPIs into HANA & Define the Reports/dashboard Layouts. Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning. Served as data modeler to identify the core ECC tables and relationship and replication / transformations. Defined the Metadata Import process. Developed Stored Procedures
• Performed SLT configuration and monitoring, ABAP transformations where ever business logic applied. Worked on various scripts to configure authentications.
• Performed HANA data modelling and developed Packages, Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA.
• Developed the security model, Naming conventions, folder structure for HANA and BUSINESS OBJECTS 4.1 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources. Created Universes (IDT) on top of HANA views and developed the Webi reports and dashboards.
• Built and enhanced ( BI BW Frontend & Backend) objects such as Infoobjects, Infocubes, DSO, ABAP Extract programs, Master Data & Transactions datas0ources, Transformations, Update Rules, ODS, Process Chains, and User Exits.
• Developed complex reports in Business Objects WEBI Reports using complex formulas.
• Worked in Crystal Reports for creating complicated BOM level reports including sub-reports. Cleansed Legacy data and loaded in BW to use it in the BOM History reports.
• Created Dashboards with drill in WEBI reports to see BOM changes over view and details of Deleted, New and changed BOMs during the fiscal year, Fiscal Month and Fiscal Quarter. Worked on Cut over plan and Knowledge transfer with Sustainment team,
• Worked on converting BOM related Legacy reports into SAP BW using Business Objects IDT/WEBI Reports: User workload, BOM Request status, Effective date, Hand Receipts, CL Summary, CL Master, and CL Master reports and History reports.
• Strong Analytics/Data warehouse and integration of BODS with SAP modules and Non-SAP data sources. Strong experience in using BODS as an external system for ETL between ECC and BI. Created Dashboards with drill in WEBI reports to see Sales KPI and BOM changes over view and details of Deleted, New and changed BOMs by Fiscal periods.

SAP BI BW Business Objects Archtect

Confidential, Pica, NJ

Env: (SAP ECC 6.0 BO 4.0 ECC 7.0, WEbi, Crystal 2011, Dashboard, FI, SD, COPA, PS, HR & OF)

Responsibilities:

• Designed and Developed data models (Infocubes Info Objects, Info Providers, MultiCubes and process chains.) and BEx objects using BEx Query Designer and BEx Analyzer .
• Design and development of SAP Business Objects (BO 4.0) reporting solutions, to include Business Objects universe design, and report design using web intelligence and Crystal reports 2011. Design, develop and debug Business Objects universes needed for reports in 3.1 and 4.0 using Information Design Tool (IDT) and Universe Design Tool (UTD) on top of SAP BW Bex(OLAP) and relational databases. Designed and Developed detail and summary reports using SAP BI BEX, Business Objects 4.0, Web Intelligence (WEBI) and Crystal report 2011. Prepare cutover plan /Transports for front-end objects using CMC to collect LCM BIAR files

SAP BI BW BO Architect S.M.E

Confidential, Swift water, PA

Env: (BI 7.0, BO ECC. 6.0, FI/CO, HR, SD, MM, CRM, SCM, HCM, and R&D)

Responsibilities:

• In charge of Support & Maintenance of Confidential North America BI systems.
• Responsible for international technical architecture being France as base , as developments are completed in France rolled-out in North America.
• Meet project deadlines, accept responsibilities, and report progress, ensure that all project goals are accomplished according to specifications and reporting requirements.
• Created and maintained Business Objects Universe
• Designed and exported super queries from Bex to BO.

SAP Senior Consultant

Confidential, Malvern, PA

Responsibilities:

• Maintained, governed and developed the application Global BI, to meet changing business and technology environments, and adheres to the enterprise architecture.
• Enhances to many Extractors using ABAP, complex reporting using (BEx, WAD), Migration of Datasources to 7.0 (DTP), applying the required SAP OSS notes, production support and process chains. Maintain and monitor security policies and procedures with IT Security Policies and procedures.

SAP BW Consultant

Confidential, Moorestown, NJ

Responsibilities:

• Modified the application-specific and generic data extractors in CO/PA, FI-SL, LO-cockpit and cross-application generic extractors.
• Assessment of SEM BPS Budget Formulation Bottom up planning, extensively worked with SEM Planning environment, with area, level, package, function, and manual.
• Workflow scenarios, Business Workflow, work item analysis, customizing, logs, BPS Planning Applications, balance sheet, profit, Sales, inventory and liquidity.
• Designed, developed, BW Reports with non-SAP and SAP data BW.