SUMMARY

• Experience including building, architecting solutions and implementation, support, role emphasizing configuration, testing, and project management to develop an integrated system that delivers a strategic business advantage to the client.
• Having extensive experience in the areas of SAP R/3, SAP BW/BI, BO (Webi, Crystal, Lumira, Design Studio Etc), Informatica and Data Visualizations tools (Tableau/Qlikview), BODS, SEM - BPS, HANA, Delivery, Consulting, Managing, and executing multiple projects for Fortune 500 Companies.
• Helped companies to align strategies with people, processes and technology with holistic approach that transforms visionary ideas into successful working realities with excellent techno-functional understanding of what is required to achieve business objectives through implementation of business system using enabling technologies.
• Responsible for Architecting, Designing, Deploying & Managing the SAP BW-HANA environment.
• Prepared strategy, scoped, collected business requirements, analyzed the process to be modeled, performed the business content checks, Conducted workshop for defining Report requirement using prototype.
• Worked on SAP Native HANA and SAP BW on HANA Hybrid Senarios.
• Having extensive knowledge on BW/4 HANA and on S/4 HANA Analytics.
• Experience in HANA Modelling with HANA Studio (Eclipse Environment), Analyzing performance bottlenecks with (SQL Plan / Visualize Plan) and provide optimization techniques. Creating Store Procedures, Functions, Windows functions, Input Parameters, Stored Procedures using SQL Scripts and Graphical views (Attribute View, Analytic View, Calculation View)
• Have extensive experience in SAP GTS.
• Strong Data Warehousing ETL experience of using Informatica 9.1, PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools, Informatica Server, Repository Server manager.
• Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in using the BW on HANA objects like composite providers, Advanced DSO’s and BW modeling techniques in eclipse using BW Modeling tools
• Expertise in using extraction of data using SLT, SDA,SDI,DXC and BODS and deploying RDS solutions in HANA.
• Used SAP HANA Hot and Cold views to persist and Archive data into NLS system.
• Excellent Technical/functional skills in BI, BO and HANA.
• Experienced in Full life cycle implementations of Data warehouse (BI) projects
• Worked as Business Analyst and directly interacted with the Business for Requirements gathering, GAP analysis, Business Requirement documentation & Business Blueprints etc.
• Also worked as Lead and coordinating with the team members in different Geographical locations in delivering the Project on time.
• Ensure that project meets it’s deliverables in the agreed schedule, as per the scope, within stipulated budget and as per the quality standards.
• Quick study who rapidly assimilates into organization and employs new ideas, concepts, methods and technologies to support business objectives. Ability to absorb complex business scenarios and Thrive in both independent and collaborative environments.
• Energetic and self-motivated team player. At ease in high stress and fast-paced environments requiring the ability to effectively handle senior level responsibilities.

TECHNICAL SKILLS

Languages: ABAP/4, Oracle SQL and PL/ SQL, T-SQL, Unix Shell scripting

Database: Oracle RDBMS (7.x, 8.0, 8i, 9i), SQL Server 2000, MS Access 2002

Software: Crystal Reports, SQL*Plus (8.0.6), OLTP

PROFESSIONAL EXPERIENCE

Confidential, Hiram Ohio.

Sr. Solution Architect

Responsibilities:

• Analyzing the business requirements and converting them into Functional design and Technical design documents
• Delivered comprehensive solutions within the SAP BI, HANA & Business Objects environment.
• Served as the technical and functional expert.
• Architected solutions to support the business needs, defined templates, and proposed new technologies that can provide value added solutions to the business.
• Created data models from different source systems and modeled the as a composite provider in SAP BW basing on SAP HANA.
• Created Open ODS view, Cubes, reports and changes in existing data flows to sophisticate with BW on HANA
• Created HANA views, Composite providers and Used ODP source to fetch the data.
• Worked on SDA (Smart data Access) for accessing data virtually.
• Worked on SLT (SAP Landscape transformations).
• Worked on writing in transformation translation to HANA Calc Views etc.
• Developed mapping parameters and variables to support SQL override in Informatica.
• Involved in Develop, design and maintain reporting and analytic solutions from the data warehouse, providing subject matter expertise.
• Published Dashboards, Reports into Enterprise Portal and BI Launch Pad for end user access.
• Provided thorough documentation around technical structures, best practices for reporting, implementation steps and standards.
• Created Dashboard for Supply chain and Inventory executive dashboards using Design Studio
• Worked on End to End development of LO(SD,MM,PP,QM,PM), FI/CO,CRM,SEM, Flat File and Generic Extraction which includes, R/3 enhancements, Creating DSO's, Update rules/Transformations, Creating info cubes, creating the queries and reports
• Worked with FI (GL,AP&AR),CO-PA, CCA & PCA Data sources, DSO's, Cubes and Reports.
• Created Data models using Multi providers, Info cubes, DSO's
• Worked with Info sets to meet typical reporting requirements
• Participated in development of strategy and roadmaps for the client's BW practice, including use of Business Objects and HANA
• Existing data flow change from 7.1 objects to SAP BW 7.4 by using SAP HANA-Optimized InfoCube, Semantic Partitioned Object, Composite Provider and Virtual Provider
• Created ABAP routines for Start, End, Expert and Field for implementing business rules. Created Function Modules, programs, DTP customer filters using ABAP routines.
• Created process chains for daily/weekly/monthly data load monitoring using Info Packages, DTP, Index and Rollup
• Designed and Defined the Architecture for Sales overview using SAP Hana Live and SAP HANA External view from the composite provider
• Developed Business Object Data Services BODS4.1 jobs to pull external data from Flat files and Oracle DB into HANA
• Created a Composite Providers to map all the SAP COPA sales and SD Sales Orders, Billing data
• Created Technical specifications to outline the details for HANA modeling
• Interacted with Business stake holders to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains
• Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data
• Created Analytical views to support multi-dimensional reporting by joining Fact table data foundation to modeled dimensions attribute views, selected attributes and measures
• Created Calculation views using data base tables, attribute views and analytic views, in order to address complex business requirements created SQL Script based Calculation views
• Created SQL scripts for procedures, functions and business rules.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA STUDIO
• Used Information Design Tool IDT to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to Repository
• Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA, BOBJ Dashboard Design, BOBJ Web Intelligence Webi, BO Analysis.

Environment: ECC EHP 8.0, SAP BW 7.3/7.5, HANA 1.0 (SP12), SAP BOBJ 4.2

Confidential, New York, NY.

Sr. Solution Architect

Responsibilities:

• Involved in full life cycle and special projects like Migrating all the mainframe systems to SAP systems and merging two SAP systems of different companies, Implementing BOBJ, Upgrading BI version to 7.x, Server migrations, archiving SAP data project.
• Participated in gathering the requirements and architectural design and scope of the project.
• Analyzed Business process and participated in discussions/workshops with users for mapping requirements in BI system.
• As a functional consultant I have evaluates the demands in talking with the customer's representatives, transforms the essence into an abstract and algorithmic model. Hence, I have identifies the use cases and transforms them into logical and technical views.
• After go live I have guarantees that the procedures remain usable and consistent in real live situation and propose enhancements.
• The main duty of a consultant is to transfer external know-how to the client. It is not manpower that counts but intelligence, understanding of processes, a feeling for defects and general a common sense.
• Interaction with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Designed the dataflow diagrams and defined the reporting flavor depending on client’s
• Requirements after Business Blue Print.
• Identified the gaps between Business Content and Requirements.
• Migrated BW 3.x Objects (Data Sources, transfer/update rule, Queries etc.) to BI 7.X objects.
• Created Multiprovider to split Query process on various data targets, and Info Sets on ODS to integrate data logically for optimal query performance.
• Involved in transporting the BW objects from development system to QA for unit testing and integration testing.
• Evaluated BW Statistics on Info Cubes and Aggregates to perform optimization for reporting.
• Extracted data from ECC and Legacy systems like URPT, SRDB, ECOM and DB2 by using the DB and UD Connect.
• Understand on demand requirements and Designing the enhancements and developing Reports.
• Was responsible for the change management process and moving the objects to production.
• I was involved in the Proof of concept implementing the various tools and co-relating them to Business use cases.
• Involved in installation and configuration of BO Enterprise XI 4.0 components, BI Launch Pad, Dashboard Designer, Crystal Reports for Enterprise, Live Office, Webi, Advanced Analysis for Microsoft office and OLAP.
• Interacting with users for customized and standard reports, gap analysis and associated solutions. Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP BI/BW, PCM and HANA as per the system landscape.
• Interacted with Project manager and end-users in architecting reporting solutions by understanding the requirements and writing universe, report and Dashboard specifications.
• Created OLAP Universes on SAP data (Info cubes / BEx queries) using the Information design Tool
• Designed and Developed BEx queries against the cubes and multi providers from GL, AR, AP, HR, Payroll and budget areas
• Created detailed Crystal Reports using Formulae, Parameters and Grouping functionality using the New BICS Protocol
• Scheduled and Broadcasted reports (Crystal and Webi) to individual recipients using BI Launch pad scheduling functionality.
• Installed and configured the BI BOBJ 4.0 client tools for use by developers and business users
• Trained the in-house developers to work with all the SAP BI BOBJ toolset.
• Worked on CMC to create User-groups and worked on security rights.
• Worked with Admin Team to integrate Dashboards, Reports into Enterprise Portal and BI Launch Pad for end user access.
• Created OLAP Universes on SAP data (Info cubes / BEx queries) and Relational Universes on Non-SAP data using the Universe designer Tool
• Created detailed reports with Drill-down capability using Interactive Analysis, worked on Ad hoc Query, Reporting, and Analysis
• Broadcasted and scheduled reports (Crystal and Interactive Analysis) to individual recipients using BI Launch pad scheduling functionality.
• Worked on CMC to create User-groups and worked on security rights.
• Worked with Admin Team to integrate Dashboards, Reports into Enterprise Portal and BI Launch Pad for end user access.
• Set-up, presented and created reports on SAP Mobile platform using the SBO Explorer and Webi application on the Apple I Pad and I phone.
• ENVIRONMENT: SAP HANA 1.0, SAP BI Net weaver 7.3, SAP PCM, SAP BOBJ Enterprise BI 4.0, Business Explorer (BEx), Crystal Reports Enterprise, Information Design Tool, Webi, Dashboard Designer, Advanced Analysis for OLAP and Microsoft Office, BI Launch Pad, QAAWS, Live Office

Environment: ECC 5.0, BI 7.0, SEM-BPS BO XI3.X, BO 4.0 etc

Confidential, Scottsdale, AZ

Sr. SAP BI/BPS Architect

Responsibilities:

• Identified the necessary Business Content using content browser and content analyzer, mapped the business process requirements with the available Business content. Installed and activated the relevant Business content for master data and transactional data.
• Implemented SD, MM, HR and FI-CO.
• Implemented the data extraction process on BI 7.0 that includes installation of the Business content, creating data transfer processes (DTP) using the new BI 7.0 features.
• Implemented standard Business Content FI-GL and FI-AP cubes for transaction figures reports.
• Worked on Routines, User exits & Customer exits.
• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.
• Designed and implemented a custom extractor to extract FI tables from R/3 into BW.
• Using BEx Query Designer (new layout, Exception Aggregation) to define complex queries, defining Exceptions, Conditions which are later deployed in variety of scenarios like Excel workbooks and web applications.
• Expertise with BI reporting for Data Analysis with BEx Analyzer, Web Application Designer and implementing BEx Queries, Variables and Workbooks.
• Using Report Designer to change the formatting of components of the report. Designing the layout of the report using headers, footers, defining the static and dynamic sections, row pattern concept and executing or saving the report on the web or as a PDF file.
• Using the Command Wizard to include complex web commands in web reports and using the new web chart functionality to create sophisticated report graphics.
• Using navigational panel to improve navigational capabilities of the workbook with drag and drop features.
• Worked extensively on modifying the web templates in WAD using HTML, XHTML, and other web technologies.
• Worked on dashboards using SAP Enterprise Portal.
• Developed a CREST interface and submitted to the BCS.
• Involved to an extent with concepts of Aggregation Levels, Filters, BEx Query, Workbooks, BI variables, WAD and Characteristic Relationships
• Provided input, recommendations, and resolutions for technical issues.
• Transport Organizer - maintained transport throughout BI landscape.
• Worked extensively in creating Transactional Info cubes for BPS Layouts.
• Worked extensively in developing BPS Layouts includes creation of Planning Profile, Planning Area Planning Level, Planning packages and Planning Layouts.

Environment: SAP 4.7, BI 7.0, SEM-BPS/BCS

Confidential, Bellevue, Washington State.

SAP BI/BPS Lead Consultant

Responsibilities:

• Analyzed the Client/End user reporting requirements in Net weaver and OLAP, and identified the Standard Business Content for business Scenario and lead the team proficiently.
• Involved in the Design & Construction Phase and Build & Test Phases, Fit-Gap Analysis, Process Design Documentation.
• Analyzed and reported the clients’ business requirements and processes and developed Blue Print.
• Created Transactional Info Cubes and Planning Areas in Planning Workbench
• Created Planning Layouts for manual entry of Sales Forecast data.
• Involved in development of Queries using Filters, Conditions, Exceptions, Restrictions, Calculations in BEx Query Designer and BEx Web Application Designer.
• Worked on the design and development of Budget Planning, Personnel Expenses Planning, Revenue Planning in SEM BPS.
• Worked extensively on Integrated Planning.
• Involved in end-user training and Documentation.
• Involved in the Upgrade Apps, Pre-checks, Tech. Upgrade, Prepare, Post Activities, Migration to New Weaver 7.0, Web Objects to Net Weaver 7.0, Plug-in release.
• Tested the new features of BI 7.0 which includes new data flow, re-modeling, integrated Planning, Real-time Data Acquisition, enhanced features of Process Chains etc.
• Testing has been done by taking the scenarios existing in the current BW 3.1 implementation and creating the same in BI 7.0 system
• Data flow analysis Queries/Workbooks in BW 3.1 System, Technical Upgrade BW 3.1 Dev to BI 7.0 Dev, Post Upgrade Analysis (DEV environment).
• Involved in Unit Testing, Data Loading, Execute Workbooks, Integration Testing, User Acceptance Test.
• Knowledge in SAP Net Weaver BI 7.0 upgrade with sap service market place.
• Involved in Basis related issues coming in BI 7.0n and fixed the issues.
• Worked on new data acquisition capabilities (new Data Source concept, enhanced remote-access capabilities).
• Extracted data using LO Cockpit, CO-PA data sources from SAP R/3,CRM Source Systems.
• Worked on new data flow capabilities like DTP (Data Transfer process), RDA (Real Time Data Acquisition) and enhanced & graphical transformation capabilities.
• Worked on Real Time Info cube and Real Time Data store object and also new and enhanced administration and monitoring features (BI Administration cockpit).
• Worked on functions of new BEx Query Designer in the state-of-the-art BEx Web Application Designer, excel-based application design with the new BEx Analyzer and New capabilities with Information Broadcasting and Modeling of BI applications using the BI Kit of the Visual Composer.
• Extensively on Material Management modules (Purchasing and Inventory).
• Worked on to establish Central User Administration to BI 7.0.
• Worked on Integrating BI 7.0 with Enterprise Portals 7.0, CRM, and SRM & SCM also for publishing BI Web Templates, Reports from BEx Web Analyzer, Query Designer and Web Application Designer into Enterprise Portals.
• Extensively worked on Extraction of Data using open Hub (Info spokes).
• Monitor and Support & Troubleshooting of Existing Data loads by using Process Chains.
• Getting the Error messages through Pager and responding accordingly.
• Resolving the tickets according to priority based created in the Remedy Tool.
• Participating in the Status meeting with the Client.
• Advising the Client regarding the Performance improvement.
• Checking data consistency and error handling.
• Close Interaction with the Content Owners and Service Line Managers for different lines of Business.

Environment: SAP 4.6c, ECC 6.0, BW 3.5, BI 7.0, SEM-BPS, BI-IP

Confidential, NJ.

SAP BW Lead

Responsibilities:

• Extensively worked on End to End implementation on BPS.
• Worked extensively in creating Transactional Info cubes for BPS Layouts.
• Worked extensively in developing BPS Layouts includes creation of Planning Profile, Planning Area Planning Level, Planning packages and Planning Layouts.
• Worked extensively on Integrated Planning Tool.
• Worked on Data slices maintenance in Planning Areas.
• Worked on variables creation in Planning Areas.
• Maintained Characteristics and Key Figures selection.
• Maintained Layout Category (KF in Data or Lead Column)
• Maintained Layout settings for Characteristics and key Figures.
• Data Captured into the Planning Layouts by using the Planning Area, Planning Levels, and Planning Packages for the 2008 year planning and given the support.
• Involved in the Power user training.
• Extensively worked on BI Integrated Planning.
• Provide Production Support for SAP BPS Core.
• Worked with Executive and Business users to refine the requirements regarding the weaver and OLAP
• Implemented both Accounts Payable Line Item and Accounts Receivable line item by enhancing BI 7.0 business content.
• Extracted data from CRM Data sources.
• Designed a process for HR and MM to work with Employee Census information. Data loads are performed using Flat file source system.
• Designed a process to capture Inventory status from legacy applications. Data loads are performed using DB source system.
• Implemented standard business content for BI Statistics.
• Designed and developed process chains, load schedules for loading Master and Transactional data.
• Developed flexible queries with variables using filters, Navigational attributes, Restricted Key figures, Calculated Key figures, Reusable structures and Currency translation factors in WAD to facilitate further data analysis.
• Front end reports were developed using both BEx analyzer and Web Application Designer.
• Used BI Broadcasting services for the distribution (Print & E mail) of exception reports to key business users.
• Performed Unit and Regression testing.
• Checked for inactive Update & Transfer Rules and activated the same. All inactive and update rules which are not required were deleted.
• Checked for inactive Info cubes and activated which are required and deleted which are not required.
• Ensured that all extractions and loads were completed and no requests are pending.
• Ensured that all delta queues are empty in SAP Source System.
• Tested Integrated Planning by creating a scenario using real-time info cubes multiproviders and input-ready queries.
• Tested the ETL process with new data flow using emulated data sources. Also tested the old dataflow for the data sources which are not emulated and cannot be uploaded using new data flow process i.e. Transformations and DTP (Data Transfer Process).
• Closely worked with testing department for developing and implementing test scripts.
• Performed Unit, Integrity tests and data consistency was verified with ECC 6.0
• Created Info Sets with a temporal join using DSO, Info Cube and Info Objects as info providers.

Environment: SAP 4.6c, ECC 6.0, BW 3.0b, 7.0, BI-IP

Confidential, Kansas City, MO.

SAP BW Consultant

Responsibilities:

• As a BW consultant, interact with Client, carrying out all the development activities as per the requirement, resolving the issues if any and ensuring the deliverables on time
• GE ERC requires to get their Claims data which resides at various source system to Oracle and then from Oracle to SAP BW. By using these reports Top Management will analyze and get Business Critical decision.
• Proposed a data model design to the GE ERC based on the Life Claims business requirements.
• Defined Master data and attributes (Navigational and Display).
• As a part of it, created Info objects required and assigned Oracle views to BW Info sources
• Created 7 ODS’s, out of which 4 are for Staging Layer and 3 for second level layer and a Cube.
• Performance issues raised during the design have been handled effectively.
• Created 23 reports for GE Top Management, which involves developing global structures for few Complex reports.
• Worked on variety of reporting requirements using concepts of variable offsets, Exceptions and Conditions.
• Worked extensively on cell restrictions and creating workbooks depending on the user requirement
• Prepared Technical Specifications and Test Case Documents
• Created the Process Chains to automate the Data Loads according to client requirements.

Environment: SAP 4.7EE, BW 3.5, Module: Financial Reporting

Confidential, Oakland, CA

SAP BW Consultant

Responsibilities:

• Implemented SD, MM and CO-PA.
• Involved in Gathering the user requirements.
• Understanding, Analyzing and Documenting the Performance Indicator (PI) and classifying them as Base PI, Derived PI accordingly.
• Documented the understanding of all the Performance Indicator’s & Business Objects by using Project Measure Glossary.
• Designed the Data-Models by using the Performance Indicator’s & Business Objects, starting with Bubble diagrams and convert them into MDM Data Model ( Extended Star Schema ), Data-Flow diagrams by doing the GAP analysis on the extractors available from the Source System.
• Designed the Document Templates for Modeling Technical Specs, Report Technical Specs, Delivery Check list Document, Data flow diagram Document, MDM Data Models Documents.
• Involved in Installing of Business content objects like Master data objects and different data targets.
• Expertise in Writing Customer Exits variables to meet the reporting requirements.
• Extracted data from SAP R/3 using Function modules with generic data sources.
• Enhanced Business Content data sources according to the user requirement.
• Published the BEx queries in to Enterprise portals using i-Views.
• Involved in the Integration testing in quality of Objects.
• Involved in checking Unit testing results and coordinating with the Functional consultants to fulfill the user requirements.
• Used BADI’s to retrieve data from data targets through Open hub services
• Involved in improving the process by taking initiatives to improve the System performance, which involves Maintaining DB Statistics, Analyzing the Utilization OLAP Statistics and taking the effective decisions to improve the query performance and Analyzing the WHM Statistics and improved Load Performance.

Environment: SAP 4.6c, BW 3.0b, Module: SD, MM and FI

Confidential, Atlanta, GA Role

SAP BW Consultant

Responsibilities:

• Requirement Study, design & development of the application.
• Freeze the scope, framed the project schedule & ensured adherence to the committed schedule.
• Preparation of road map to support project Implementation.
• Involved in Gap analysis for end-user requirements.
• Explored SAP business content components to determine best fit for user requirements.
• Created a new LO & CO-PA data source to meet the reporting requirements.
• Modified, enhanced and created the LO & CO-PA Objects (Info objects, Info source, Info cube, ODS and update rules) for data uploading.
• Created Generic Data Sources using database Views and Function Modules on Tables and Info Set Queries.
• Created new reports as per requirements
• Developed the Enterprise controlling (ECCS) Budget Vs Actual reports.
• Involved in Modifying the Existing BEx Queries according to new Business Logic.
• Validations of the Queries.

Environment: SAP 4.6c, BW 3.0b, Module: SD, MM, FI.

Confidential, NJ.

SAP BW Lead

Responsibilities:

• Basic & Interactive Reports, Reports using ALV,
• BDCs & Interfaces
• Transactions
• SAP Scripts & Smart forms.
• SAP Queries
• Developed BDCs for Initial Stocks (MB1C) & create Transfer Orders (LT03), Condition records (FV11)
• Developed Transactions for Bin to Bin transfer & Pallet Substitution in RF device
• Developed Transaction for creating a sales order from e-portal
• Developed Smart forms for Packing list, Picking list & Rebate Agreement
• Developed SAP Scripts for Miscellaneous Invoice, Miscellaneous Credit Memo & Account Statement
• Developed a Payment Instruction HDFC File Format for Online Payments after the Automatic Payments run through F110 Transaction
• Worked on many SD Pricing Condition Routines Worked on User exits& Customer exits.

Environment: SAP 4.6c, ECC 6.0, BW 3.0b, 7.0, BI-IP

Confidential

ABAP/4 Technical Consultant

Responsibilities:

• Created a report that displays Pricing Conditions for different customers in a sales organization
• Developed a report which displays the ranked list of materials based on price for given materials
• Developed a report that displays the all the late shipments in a particular period by giving the period on the selection-screen.
• Developed a stock overview report that includes opening and closing stock as per the periods.

Environment: ABAP/4, Oracle 8.0, Windows-2000