SUMMARY:

• SAP techno - functional consultant wif 11+ years of IT experience dat includes 9+ years of SAP-BI/BW 7.4/7.3/7.0/3.5, 3.1C, 3.0B, 2+ Years of SAP HANA modeling. Proficient in Modeling of HANA Objects, Big data developments, BW developments & BO Reporting.
• Languages: ABAP/4, SQL, PL/SQL, C, C++, Java
• Hadoop: HDFS, Map Reduce, Hive, Pig, HBase, Sqoop, Oozie, Flume, Pentaho, YARN, impala, Zookeeper and Cloudera Manager, MongoDB
• SAP modules: ERP(SD, MM, PP, FI-AP,AR,GL,CO-PA, HR), BI/BW, SRM, CRM, AFS, SCM, APO
• Reporting tools: Business objects XI 3.5/4.1, Crystal reports, Business Explorer, BEx report designer, Web application designer (WAD), Tableau
• SAP versions: HANA1.0 SP 05/06/07, BI 7.4/7.3/7.0/3.5, ECC 6.0, R/3 4.7/4.6 C, BODS 4.0/3.2, Net weaver 2004/2004s/ CE 7.1/CE 7.2, Portal.
• Cross applications: Interactive reports, ALV, ALE, LSMW, SAP script, Smart forms, EDI, module pool- programming, user exits, RFC, IDOC, BDC, BADI and BAPI
• Databases: SAP HANA1.0 SP 05/06/07, Oracle 8i, SQL server 7.0, MYSQL, MS-Access, HDFS
• Web tools: Adobe flex builder, Photo shop, HTML, Java script
• Packages: Microsoft office, Project
• Production support tools: Remedy, HP quality center
• One full life cycle implementation as SAP HANA consultant - SAP HANA Data Modeling, Data Provisioning, Hana Administration and Reports development.
• Involved in HANA modelling. Created Analytical privileges, multiple schemas and table definitions, created Attribute views, Analytical views and calculation views as per the use cases.
• Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Data provisioning landscaping methods such as SAP Landscape Transformation (SLT), SAP Data Services, for replication/ extraction of data from SAP/ non-SAP source systems and on HANA integration tools.
• Experienced in loading data from tables in HANA Database to BW data marts.
• Strong experience in the modelling of Composite Provider, Advanced DSO (ADSO) and Open ODS view using BW Modelling Tool in HANA Studio.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Good Knowledge and Experienced in User Management and security in HANA.
• Good noledge in Hana Architecture and Design.
• Good noledge of SAP Project cost and Revenue planning (CPM)
• In depth understanding/noledge of Hadoop Architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node, and MapReduce concepts and experience in working wif MapReduce programs using Apache Hadoop for working wif Big Data to analyse large data sets efficiently.
• Experience in importing and exporting terra bytes of data using Sqoop from HDFS to Relational Database Systems and vice-versa.
• Tracing the users, SAP objects and custom reporting authorization objects to debug an authorization error, resolving the issue by giving required authorizations(RSRTRACE)
• Configured roles and authorization objects to secure reporting users.
• Experienced wif Authorization Variables, Authorization Objects, and Security on infocubes, Creation of Roles and Users.
• Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
• Having 1+ years of experience on Tableau Business Intelligence/Business Analytics software and Analysis, Design, Coding, Testing, Migration, Production support.
• Extracted the data from ECC 6.0, loaded into BW 7.0 using Data Services XI 3.2 SP1 as an ETL tool for Data Quality.
• Modelling Planning Applications using SAP BI Integrated Planning (IP). Created Web Planning Layouts in BI-IP using Input Ready Query and Web Application Designer.
• Established theSRMreporting environment usingSRMand SCM BI interfaces
• Multiple full life cycle implementations as SAP BOBJ/BI consultant - requirement gathering, GAP & OLAP analysis, business blue print, design & development, testing, reporting, getting client approvals, go-live & production support.
• In-depth insight into BW data modelling - design & creation of infoproviders (infocubes, ods/dso, multiproviders, infoobjects) & associated data flow structures (infosources, datasources, transfer routine, start routine & end routine), infopackage monitoring & scheduling process chains.
• Expertise in report generation - BEx analyzer, query designer, WAD, ad-hoc queries, info set queries, jump analysis using RRI; creation of custom queries using conditions, exceptions, variables, structures, restricted & calculated key figures, and aggregates for frequently used queries; configuration of SAP enterprise portal for report distribution; create iviews, pages, folders, etc. to manage the entry points on the portal as per requirements.
• Strong BW data extraction - data upload from different source systems, LO cockpit configuration in R/3, generic extraction & user exits.
• Knowledgeable in data modelling using entity relationship(ER), multi-dimensional/star schema and extended star schema models. Strong noledge of SAP BI architecture and SAP BI data model.
• Responsible for displaying BEx query data from SAP BI 3.5/7.0 using adobe flex 2.0/3.0.
• Experienced in reporting agent and web reporting/publishing using SAP business objects - web intelligence, desktop intelligence, and xcelsius 2008/2011.
• Data Modeling experience from Entity Relationship Model (ERM) to Multi Dimensional Modeling (MDM) star schema-Extended star schema (InfoCube/ODS).
• Expertise in ABAP & portal; techno-functional player in integration of SAP BW wif SD, MM, SRM, CRM, PP, FI, CO.
• Extensive experience in previous SAP Business Objects products like Business Objects Designer/Reports/Supervisor/ CMC/CCM/Web Intelligence/Import Wizard/LCM/BO Explorer/Broadcast Agent/Info View/Xcelsius/Live Office/QAAWS/ BO Auditor/Application Foundation/Crystal Reports X&XI and Business Objects XI R1/R2/R3/R4 and V3 Environments.
• Universe designing & development using DB2, Oracle, SQL Server, Sybase, SAP BW queries & info cubes.
• Involved in Full life cycle (analysis, design, networking, design, development and deployment) of Business Objects reporting Applications wif Web Intelligence (WebI) and Broadcast Agent.
• Migrated WAD templates using the standard ABAP report RSZW ITEM MIGRATION 3X TO 70
• Involvement in testing, support & end-user in SAP solutions.
• Solid leadership, relationship & communication skills; configuration & project management skills.
• Established technical credibility wif global IT community & senior business users.

PROFESSIONAL EXPERIENCE:

Confidential - MEMPHIS, TN

Sr. SAP BI/BO Architect - Big data Engineer

Environment: SAP BI 7.4 & ECC, BO, Hadoop, MapReduce, Kafka, Pig, Hive, HBase, Sqoop, HDFS, Impala, MapR, SQL, Tableau

Responsibilities:

• Responsible for gathering business requirements, understand the current ECC environment, perform GAP analysis, design, and development and perform testing in the areas Purchasing, Billing Financials and controlling, SAP content objects FI, SD, and HR.
• Gathering business requirements, understand the current ECC environment, perform GAP analysis, design, development and perform testing in the areas Purchasing, Billing Financials and controlling, SAP content objects FI-GL, CO-PA,SD, MM and VMS Generic Data sources.
• Designed and modelled ODS objects, Info-Cubes and Multi Providers wif multiple combination of Purchasing to FI-GL and Billing to FI-GL. To provide Purchase Variance Reports (for Three Ways Tie), Reconciliation Reports, Sales Overview and Price Condition.
• Maintained Logistic Cockpit for Data-Sources purchasing 2LIS 02 ITM and billing (2LIS 13 VDHDR and 2LIS 13 VDITM). Activated and maintained Billing Conditions 2LIS 13 VDKON Data Source.
• Managing multiple projects and support the business team for any issues.
• Involved wif various database administrators to map the requirements and to propose new solutions.
• Built new reports and made changes to the existing reports based on user requirements using BO Webi and Crystal reports
• Extracted data from ECC system using 0HR PA 0, 0HR PA 1, 0HR PA PA 1 and 0HR PA OS 1 Data source and migrated 3.x flow to BI7.4 version.
• Worked in developing, modelling and implementing HR payroll, posting documents info providers.
• Worked extensively in developing, modelling, and customizing the Financial & HR data providers, Financial & HR Info cubes, DSOs, and multi providers according to business needs in SAP BI.
• Developed a transport program in BI system to validate all transport consistency check ZBW TRANS.
• Developed custom HR reports for the end users- such as Annual and Quarterly overview of Wage Types, Quarterly posting documents as per the user requirements.
• Extracted Cost Center hierarchy & Cost Element hierarchy into BW using respective data sources 0COSTCENTER 0101 HIER & 0COSTELMNT 0102 HIER.
• Made changes to the existing Ad-hoc Universe using IDT. Added new tables, created new objects, resolved loops and traps by creating contexts and aliases, renamed existing objects, created prompts according to the user requirements.
• Wrote multiple complex Teradata queries using Teradata SQL Assistant to use in the reports.
• Involved in the discussions for new project based on implement reporting, Sales Alignment, and invoice research in accordance to the adoption of a compliant Hierarchy for Revenue Operations processes
• Developed automated scripts for ingesting the data from Teradata around 200TB bi-weekly refreshment of data.
• Extensively worked on importing and exporting data from different databases like Oracle, Teradata into HDFS and Hive using Sqoop for visualization and to generate reports for the BI team.
• Developed UDFs using JAVA as and when necessary to use in PIG and HIVE queries to pre-process the data for analysis.
• Extensively used Pig for data cleansing and developed Pig Latin scripts to extract data from the web server output files to load into HDFS.
• Design, develop, test and deploy Tableau solutions; dashboards, scorecards, and scheduled reports using Tableau.
• Leverage advanced Tableau functionality (parameters, quick and action filters, calculations, and data blending) to create and publish analytical dashboards.
• Administer users, groups, sites, projects, permissions, publishing and security levels; include Tableau Online.
• Developed the new universe in IDT. As a part of Universe development, created connection, classes, different kinds of objects, cardinalities, strategies, resolved loops using aliases and contexts
• Developed multiple reports on the new universe and implemented the report bursting feature using CMC
• Performed admin role like security management by creating/maintaining user groups, roles, access levels etc
• Participated in migrating reports from BO 3.1 to BO 4.1 using the UMT
• Used the Information Design Tool to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius), Live Office Reports, Design Studio and Lumira
• Built dashboards using Design Studio 1.3 .Created visualizations for analysis purposes.
• Created BIWS connections to provide inputs to Xcelsius dashboards from webi reports
• Involved in performance tuning of existing Dashboards and Dashboard Design alternatives
• Supported an existing universe built on multiple data sources by troubleshooting existing problems
• Converted existing .unv universes to .unx
• Created complex webi reports using the multiple data providers and synchronize the data providers by merging objects to create a report
• Recommended standards of good practices of report development and maintenance of universes
• Performed administration tasks like moving universes and reports between PROD, QA and DEV environments using Promotion Management in 4.1
• The project involved development of reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs. Trained and supported the users to use Business Objects and resolved Trouble Tickets/Cases reported by user
• Design and development of DataServices (BODS) jobs.

Confidential

Sr. SAP BI/BO Architect - Big data Engineer

Environment: SAP BI 7.4 & ECC, BO, Hadoop, MapReduce, Kafka, Pig, Hive, HBase, Sqoop, HDFS, Impala, MapR, SQL,Tableau

Responsibilities:

• Gather all required information more effectively related to BW systems for Overgoods reporting and answer customer queries.
• Closely worked wif business in setting up the level of expectation and providing ideas to create best decision making reports in Joint Venture Accounting, PRA and Finance subject areas.
• Completely responsible for the end to end implementation of JVA module from gathering requirements to reporting including Business Objects, Web Intelligence Reports and created Generic Data sources to get the Joint Venture Accounting Data from ECC custom Tables.
• Performed LO-Cockpit extraction to pull data from R3 SD modules into BW system extracting Header and Line item data purchase data 2LIS 06 VAHDR/VAITM, Purchase orders 2LIS 02 HDR/ITM/SCL/SGR and Billing 2LIS 17 I3OPER.
• Worked on various data sources for AR, AP and GL modules in SAP FI.
• Written BW side complex transformation routines using end and start routines.
• Redesigned the Info cubes wif bad dim/fact ratios mathematically to employ the lowest dim/fact ratios possible. In most cases, wif use of line item and common characteristic groupings, the redesigned cubes went from high ratios of 20 - 50% to between 1-4%.
• Created Generic Data Sources based on views and function modules for Joint Venture Accounting.
• Technical and Functional design issue identified in Supply application area and were fixed to ensure 100% data quality. Also developed reconciliation tool to automate the Supply data reconciliation process for data quality check.
• Keep track on all BW Operations team tasks like - Overall system monitoring, Housekeeping, Reconciliation, Broadcasting, Webpage/Customer updates etc.
• Developed UDFs using JAVA as and when necessary to use in PIG and HIVE queries to pre-process the data for analysis.
• Connected Hive and Impala to Tableau reporting tool and generated graphical reports
• Administered BOBJ Security settings and setting up user, user groups and application security
• Interacted wif Business community to gather and analyze the Business Requirements in developing and modifying Universes and building the reports.
• Created Single & Multi Source Universes based on Relational and OLAP connections from scratch using Information Design Tool (IDT) and also modified existing Universes based on reporting requirements.
• Created 8 SAP BW BEx queries using BEx Designer for Sales and Distribution and Materials management modules especially for procurement process. Also created SAP WEBI reports using BOBJ 4.0 using BICS connection for all the BEx queries.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Generated tableau dashboards for sales wif forecast and lines.
• Worked on complex WEBI reports using cross tab reports.
• Well versed in utilizing formulas, sections, bookmarks, breaks and filters for WEBI report development.
• Experience using both BEx Queries and Universes (unx) as a data source.
• Improved the performance and reduced the coding wif the use of @functions like @Prompt(for user defined queries), @Where (for creating conditional filters), and @Select to create duplicate objects in the process of building the Universes(UDT & IDT).
• Provided recommendations in Analyzing, Design, Implementation and administration of security models wif row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC).
• Design and Developed various ad-hoc and canned reports using BI Launchpad 4.1 and Webi Rich Client on Market and Regions for marketing team to do trend Analysis, using new features as well such as Element Linking, Stacked Bar/Column Chart, Heat Map, Tree Map, Bubble Chart etc.
• Developed Overgoods Dashboard for detailed analysis in Dashboard (Xcelsius) using BIWS for Higher level Management to Monitor Volume by Location and Volume by OpCo.
• Developed overgoods demo reports using scorecards, data visualizations and drill down in SAP Lumira, Dashboards for the prospective clients
• Wrote multiple complex Teradata queries using Teradata SQL Assistant to use in the reports.
• Developed the new universe based on Teradata in IDT. As a part of Universe development, created connection, classes, different kinds of objects, cardinalities, strategies, resolved loops using aliases and contexts.
• Migrated the Crystal Reports, Universes, Webi Reports, Users and User Groups from BO XI to BO 3.1 using Import Wizard and from BO 3.1 to BO 4.1 using Upgrade Management Tool.
• Extensively used Central Management Console (CMC) in setting up security in BO 4.1 and also manages security configuration for various reports and universes in development, test and production environment.
• Developed Operation Dashboards for detailed analysis in Dashboard (Xcelsius) using QaaWS for Higher level Management to Monitor Project/Budget allocation.
• Assisted Business Objects user community wif day to day Business Objects guidance/issues.
• Involved in integration of Webi reports wif asp.Net application using Open Document SDK.
• Involved in the Windows AD and Single Sign On (SSO) for SAP BI/Business Objects 4.1.

Confidential - ST. LOUIS, MO

Sr. SAP BI/BO Architect-HANA Modeler

Environment: BI 7.4, ECC 6.0, SCM, SRM, BO 4.1 (SP3), SAP HANA 1.0 SP5, BODS 4.0, Windows 2008 R2, SQL Server.

Responsibilities:

• Assess and cultivate long-term strategic goals for data warehousing in conjunction wif data users, department managers, clients, and other key stakeholders
• Managing multiple projects and support the business team for any issues.
• Translated the business KPIs into HANA and defined the reporting Layouts. Designed and developed SAP HANA data modeling architecture.
• Created Analytical privileges, calculated attributes, calculated measures, constant columns, parameters and variables.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Identified the Purchasing HANA live content related VDMs for Purchasing reports and installed VDMs(Virtual Data Models) related HANA views (PurchaseOrderHeader, PurchaseOrderItem, Purchase Document Schedule line) in the HANA and customized these views as per business requirement and latter BOBJ reports are developed on these views.
• Included creation of Logistics (SD, SRM) and Project system HANA models from SAP ECC wif real time data provisioning via SLT.
• Strong experience in consuming BW data models into SAP HANA & vice-versa and hands on exposure SAP BW 7.4 new objects (Advanced DSO, Composite Provider, Virtual provider, Open ODS views).
• Created the information spaces using SAP BO Explorer tool on top of the SAP HANA Information models as per the business cases.
• Created many complex and customized reports for specific business requirements and also involved in new features of SAP BI security like Analysis authorization.
• As per business requirements developed various Calculated Columns, Restricted Columns, Filters, Hierarchy, variables and input parameters.
• SAP Lumira Dashboard development wif HANA Data - Specialize in Data Modeling for SAP AFS and Retail Vertical Industries.
• Develop dashboards, universes, and analytics using the SAP Design Studio for an enterprise Business Intelligence (BI) portal.
• Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication.
• Design and development of DataServices (BODS) jobs.

Confidential

Sr. SAP BI/BO Architect-HANA Lead

Environment: BI 7.3, ECC 6.0, SRM, SCM, BO 4.1 (SP3), SAP HANA 1.0 SP5, BODS 4.0, Windows 2008 R2, SQL Server.

Responsibilities:

• Migration of Legacy SAP BW/BI to BW on HANA wif SAP best practices
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Side car implementation utilizing both native HANA and BW powered by HANA solution features.
• Installation of BW statistics solution and analysis of performance on BW powered by HANA. Data replication using SLT.
• STL transformations were used to pre populate the tables wif additional fields.
• Did conversion from reporting authorization to Analysis Authorization in Sandbox.
• Made theBI Security Rolesas granular and optimum so dat the Info Objects can be utilized as much as possible wifout creating too manyAnalysis Authorizations.
• Created roles usingPFCGand Analysis Auth usingRSECADMIN.
• Used SAP best practices like setting the following InfoObjects as “authorization-relevant” and using them in Analysis Authorizations0TCAACTVT, 0TCAIPROV, 0TCAVALID.
• Responsible for Designing and Developing Security (Composite roles, single Roles, Authorization Objects, Authorization files etc) for different work streams such as CRM, FI, SD, SRM, SCM to allow access to 2000 users based on Company code, Region level Authorization.
• Involved working wif content models, attributes and measures, hierarchies
• Good Knowledge on COPA and BW Applications on Top of HANA DB.
• Good Knowledge on HANA Administration activities, Architecture and Sizing Requirements.

Confidential

Sr. SAP BI/BO Lead Consultant

Environment: BI 7.3, ECC 6.0, SRM, SCM, BO 3.5, BPC 7.5/10.0, Windows 2008 R2, SQL Server.

Responsibilities:

• Provided hands on leadership, direction and guidance to design and develop a sustainable Enterprise wide Business Intelligence reporting framework and solutions
• Extensively working on Performance Tuning using BW Statistics, Aggregates, Compression, Partitioning and Database Statistics.
• Enhance built-in analytical capabilities forSAP NetWeaverBW Accelerator & BWA-based reporting on DSO(BWA7.2)
• Smarter data flow modeling wif remarkably reduced manual effort.
• Enhance monitoring capabilities wif new content for SAP NetWeaver BW Administration Cockpit and integration in SAP Solution Manager.
• Involved in HANA pre & post HANA activities such as maintaining the issue log report, Info Cube’s conversion, identified & implemented SAP Notes etc.
• Involved in supporting the administration team for upgrading SAP BI to BW 7.3.
• Familiar in creating the planning applications using BI Integrated Planning in creating the Planning models, Aggregation levels, Variables, Data Slices, Characteristic Relationships, Planning functions and Planning Sequences and Input enabled Queries.
• Created Aggregation Levels, Planning Filters, Planning Functions, Planning Sequences, Data Slices, and Characteristic Relationships using Integrated Planning.
• Created Multi Planning Area and Modeling of Planning Structures using Planning Area, Planning levels, Planning functions, Planning packages, Parameter groups and planning sequences using SEM-BPS.
• Configured and involved in troubleshooting custom IP applications using the BEx toolset including BEx Query Designer, BEx Analyzer, and BEx Web Application Designer.
• Used the input-ready queries to create applications for manual planning and complex planning scenarios.
• Developed Planning Functions using Fox programming to process plan/Actual data based on the requirements.
• Extract and enhance data sources from various SAP modules - 2LIS 11 VAHDR/VASCL/V SCL, 2LIS 12 VCSCL, 2LIS 13 VDITM/VDKON, 2LIS 02 SCL/SCN and 2LIS 03 BX/BF/UM.
• Strongly used SRM add-on data sources - 0SRM TD PO, 0SRM TD CF, 0SRM TD IV, 0SRM TD PO ACC
• Modified the function modules to implement the clients new logic in the SRM data sources.
• Extensively working on 0FI GL 10/14, 0FI AR 4, Payroll - Bonus report, COPA - forecast & budget.
• Designed and developed major reports like Master schedule and PPV on top of inventory, Super sheet and On-time fulfillment on top of sales, Warehouse Flash on top of sales, deliveries and purchasing, Bonus report on top of HR.
• Design and development of consolidated high level aggregated reporting data models using advanced data mining techniques, Analysis Process Design.
• Created relational universes on top of SAP BW Multi cubes and combined wif existing SQL Server & Oracle databases for multiple sources.
• Worked extensively wif the Information Design Tool in designing several Universes based on the dimensions, detail and measures to get inventory plan data from legacy system.
• Developed more than 30 complex reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports 2011 and implemented report bursting for those.
• Monthly drilldown Dashboards wif separate views for different levels of management and other relevant information seekers using Xcelsius 2011.
• Publish high-level reports and giving to end users.

Confidential - OAKLAND,CA

Sr. SAP BI/BO - TEAM LEAD

Environment: BI 7.3, ECC 6.0, BO XI 3.5

Responsibilities:

• Managed and supported the business information team; carry out the IT projects in SAP BI/BO environments.
• Lead the planning, data modeling, detailed requirements analysis and deployment of a project engagement for Inventory Management, Procure-To-Pay (P2P) & Revenue
• Assigning and managing work activities, meeting deadlines and developing project management reporting
• Engaged wif business partners & other IT teams to formulate and structure technical projects; involved in the designing and implementations of business intelligence solutions.
• Worked on integration of SAP business objects (XI 3.1) to SAP BW and SAP R/3 environments.
• Ensure dat business requirements and technical design of the solutions meet business needs.
• Extract and enhance data sources from various SAP modules - OTC, RTR, STP, FTS, ME, FI/CO data sources: 2LIS 11 VAHDR/VAITM/VASCL/VASCH, 2LIS 12 VCHDR/VCITM, 2LIS 13 VDHDR/VDITM, 2LIS 02 HDR/ITM, 2LIS 03 BX/BF/UM, 0FI GL 14, 0FI AP 4, 0FI AR 4, COPA and several master data sources like initialize the delta (RSA7) process by running the setup of application components to synchronize the daily loads.
• The project involved the integration between Sales Order Item (2LIS 11 VAITM), Order Item Status (2LIS 11 VASTI) and the Delivery Item (2LIS 12 VCITM) extractors. Proposed the redesigned architecture for the Sales Order and Delivery flows wif the inclusion of the EDW layer for flexibility and utilized the new Semantically Partitioned Objects (SPO’s) introduced wif the 7.3 version.
• Expertise utilizing webi, crystal reports, xcelsius, business explorer.
• Create web reports wif complex calculations to get alerts for xcelsius dashboards.
• Efficient analytical tool to quickly generate Web Intelligence ad-hoc reporting and plan verses actual comparison, allowing users to slice & dice the various KPIs, measures and metrics by all possible dimensions.
• Developed Xcelsius 2008 dashboard for Asset Analysis based on asset performance, using Live Office interface.
• Use HP quality center for defects, reporting & tracking post go-live activities, incidents and tasks.

Confidential - SANTA ANA, CA

Sr. SAP BI/BO - PROJECT LEAD

Environment: BI 7.0, ECC 6.0, SCM, SRM, BO XI 3.1/3.5, BODS 3.2, SQL Server

Responsibilities:

• Led the activities of the global implementations for cross-country client’s business processes & reporting needs.
• Involved in the end to end implementation of the Business Warehouse Accelerator project across the SAP BW landscape.
• Responsible for requirements gathering, design, development & implementation of data warehouse using SAP BI for ETL wif custom R/3 extractors and business objects for front-end reporting.
• Created, executed and documented initial acceptance, performance, regression, non-functional and data reconciliation tests.
• Created the BI application for the SD module using the sales overview (0SD C03), loaded sales (2lis 11 VAITM/VAHDR), deliveries (2lis 12 VCITM/VCHDR) and billings (2lis 13 VDITM/VDHDRR) for Reliability (Deliveries on time) and Availability (Delivery dates confirmation at time sales order) reports
• Implemented the new AR (Accounts Receivable) functionality by using the extractor 0FI AR 30.
• Enhanced the AR extractor wif Credit management and dispute management fields.
• Experience on extracting data in Vistex Module. Worked on the Claims Request and Sales Incentive extractors.
• Created an AR aging report to suit the client’s requirement.
• Designed and developed Top customer/product sales reports out of COPA data source.
• Developed complex Supply Chain (SCM) reports critical for Business Users.
• Established theSRMreporting environment usingSRMand SCM BI interfaces
• Developed custom extractors to pull MRP related information from ECC. The extractor was a function module based one which pulls data from tables MDKP and MDTB.
• Extracted the data from ECC 6.0, loaded into BW 7.0 using Data Services XI 3.2 SP1 as an ETL tool for Data Quality.
• Migrated WAD templates using the standard ABAP report RSZW ITEM MIGRATION 3X TO 70
• Developed infrastructure to send Sales & Shipments info from BW to APO system for Demand Planning (DP) analysis.
• Actively participated in BOBJ 3.2 tool evaluation as standard reporting tool.
• Created and demonstrated many Webi reports and Crystal reports for pilot project and tool evaluation purposes.
• Built xcelsius dashboards mainly using drilldown functionality and several other components.
• Supported a successful go-live and hypercare.
• Used HP quality center for defects, reporting & tracking; and BMC remedy service management tool for supporting post go-live activities, incidents and any other tasks.

Confidential - CINCINNATI,OH

SAP BW/BO LEAD

Environment: SAP BI 7.0, BO 3.5, ECC 6.0, SAP web dynpro abap

Responsibilities:

• Team lead for the project (full life cycle implementation) dat includes gap analysis, requirements gathering, blue print, development, testing, reporting, and go-live & post go-live support.
• Monitored the team action items & procedures; developed weekly status reports for the project manager.
• Responsible for the deliverables of data source developments & enhancements, end to end BI solutions, process chains, and reports.
• Developed Global info cubes, Multi cubes, Transactional Info cubes, DSO objects and extracted Master data and Transaction Based Data in QM, CRM, and FI Info areas
• Used DB connect and UD connect to communicate to 3rd party servers.
• Developed an ABAP program to run in the background on daily basis as part of the process chain.
• Extracted & validated the data of the cubes & dsos by using generic data sources, and developed universes & BO reports on top of them; delivered defect free objects to the client after reviewing them.

Confidential

ADOBE FLEX CONSULTANT

Environment: Adobe flex (3.0), SAP HR ABAP

Responsibilities:

• Developed an interactive tool for organizational chart wif HCM based on AIR application in flex 3.
• Led the pilot phase to get the hierarchy from the back-end (SAP HR) and displayed it in the front-end.
• Created & filled a vacant position by drag/drop in the organizational chart, and the tree structure.

Confidential - GREENSBORO,NC8

SAP BI/BW ANALYST

Environment: SAP BI 7.0, ECC 6.0.

Responsibilities:

• Gatheird requirements - user meetings, requirement consolidation, draft specifications and blueprint document.
• Proposed & implemented new idea of reporting using real-time data acquisition for forecasting materials.
• Extracted master data using MDM ABAP-APIs and merged wif the transaction data.
• Wrote ABAP routines for the customer exit variables, and for the transfer, start & end - routines.
• Created BEx query to display KPIs - # of materials dat had completed/in-process/rejected the registration process.

Confidential

SAP BW & FLEX CONSULTANT

Environment: SAP BW 3.5, SAP R/3 4.7, SQL server, Adobe flex (2.0 & 3.0)

Responsibilities:

• Performed data modeling & requirement analysis by interacting wif client’s functional consultants.
• Worked on the design & implementation of BEx queries & dashboards using flex, and integration wif BW/BI.
• Executed BI spend analysis - ABAP data model, RFC developments, and flex implementations for rich user experience.
• Created re-usable flex components, and utilized them to reduce development.

Confidential - SAN DIEGO, CA

SAP BI SUPPORT CONSULTANT

Environment: SAP BI 3.5, R/3 4.7, CRM 3.1

Responsibilities:

• Involved in load monitoring of daily/weekly/monthly data loads using process chains, and fixing the failures to complete the loads in the given time.
• Provided support and proposed solutions to solve the business complexities.
• Updating the Marketing attributes from BW to CRM Using APD Interface.
• Worked on Campaigns (Saves and MSF).
• Worked wif SAP on CRM Extractor Delta Issues and suggested the Basis Team to Apply the OSS Notes in the system.
• Populated various data targets like Info objects, ODS and Info cubes, wif Master data and Transactional data from SAP R/3, SAP CRM, legacy systems and file interface via Data Staging area (PSA)
• Handled the tickets by priority (1, 2 & 3) by following standard operating procedures (SOP).
• Modified several existing BEx reports to improve the performance.
• Maintained production system reliability by utilizing the change management process.

Confidential - PHILADELPHIA, PA

SAP TECHNICAL CONSULTANT

Environment: SAP BW 3.5, SAP R/3 4.7

Responsibilities:

• Performed system analysis, identified tables, function modules and BAPI to meet business requirements.
• Modified Save Order BAPI, BADI for field validations and authorizations as per requirement.
• Monitored & tracked daily activities, worked closely wif the team to resolve issues and ensure dat the SLA’s are met.
• Involved in production support activities – perform root-cause analysis, provide corrective measures, and suggest preventive actions throughout the project.
• Solution manager involving the development of new transactions as per the client's requirement.
• Enhanced existing reports and implemented email notifications (wif pdf attachments) to improve business processes.

Confidential

ABAP Developer

Environment: SAP R/3 4.6C, 4.7 Enterprise

Responsibilities:

• Trained on SAP R/3, ABAP data dictionary, BDC, module pool and ALE.
• Overview of SAP functional domains (viz. PP, MM, SD, FI/CO).
• Design, configure & test enhancements for customer returns & pricing procedures.
• Responsible for debugging of ABAP programs, developing interactive reports, BDC and ALV reports.
• Customized user exits, custom development and enhancements wif minimal maintenance & optimal performance.
• Assisted in the functional testing and user acceptance testing; unit/integration/regression testing.
• Case study on sales & distributions (SD), customization & configuration.