SUMMARY:

• Seek a position of Senior BI Lead Consultant/Developer in your organization where my relevant skills and experience can be used for my professional career as well as company’s growth.
• Highly analytical and a productive professional with over 14+ years of experience in IT.
• 12 years of experience in SAP BI/BO (4.1), and ABAP in relation to BI (7.4/7.5), HANA with SEM BPS/IP. SAPTechno/FunctionalNetWeaver(v. 2004, 2004s, EP6.0, ECC 6.0), BODS consulting experience.
• Worked with Webi, Crystal Reports based Business Objects reporting.
• Excellent in developing an engagement plan that identifies the gaps between the baseline and the target goals, and taking specific action required to achieve the project objectives.
• Was involved in the migration process from BI 7.3.
• Involved in workshops, Data Modeling, Customizations, Business Content and Blueprint Documentation.
• Support Projects in SAP BI 7.5, BPS, BPC, PLM, Integrated Planning and BOXI 3.0/4.2

PROFESSIONAL EXPERIENCE:

Confidential, Trumbull, CT

Environment: SAP BI 7.5, BO (4.2), HANA, HANA S/4, BODS, ECC 6.0, BPC, Oracle, FICO, PP,MM, SD, Logistics (Extraction) modules,Sql Server, BEx Query Designer, WAD and BEx Analyzer.

SAP BI Architect

Responsibilities:

• Thorough understanding of the Functional specifications and outstanding issues related to specifications.
• Frequent meeting with the functional team to resolve the outstanding issues and regular updating of functional specifications.
• Experienced in modeling, extracting, transforming, and loading (ETL) data into data targets for reporting.
• Found the gap between SAP Business Content and business requirement.
• Enhanced SAP Business Content to meet business requirement.
• Developed Transfer Rule, Update Rule and User Exit with ABAP language.
• Designed, developed and tested queries based on infoProvider with Bex.
• Generated and analyzed sales reports and financial reports.
• Verified sales data and financial data through SQL.
• Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script and CESQL scripting. Also trained on XSJS, OData, web services.
• HANA SQL SCRIPTS & CDS CORE DATA SERVICES - Strong experience on Creating SQL, Stored Procedures with SQL Script and also with Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like - Tracing, Using the SQL Script Debugger.
• Developed data flows and work flows using BODS.
• Worked on Integrate SAP S/4HANA platform with guidance on how to set up the integration and pre-built content delivered with SAP environment.
• Expertise in Converting front end business warehouse components like BEX Query into HANA View and Web Application Designer report into WEBI.

Confidential, New York, NY

Environment: SAP BI 7.3, BO (4.1), HANA, HANA S/4, BODS, ECC 6.0, BPC, PLM, Oracle, FICO, PP,MM, SD, Logistics (Extraction) modules, Fox Formulas, Sql Server, BEx Query Designer, WAD and BEx Analyzer

Responsibilities:

• Creating Jobs, Workflows, Dataflows, Data stores, ABAP DF, Template Tables, Flatfiles
• Configured Central Repository, Profiler Repository and added User roles
• Implemented SCD Type 2 Concept for Large Volume Data
• Configured SAP Application Data Stores and SAP Source Data stores
• Worked on Management Console for Job Scheduling, Tracing, Monitoring, Editing Repositories, Job Servers
• Performed Elementary Job analysis from Operational Dashboards and generate documents from Auto Documentation in Management Console
• Good knowledge on Transforms & Custom function.
• Worked on Data quality(data cleansing, standardization, duplicate entries) with larger Data volume
• Universe Designer: Creating Classes, Objects Inserting Tables, Joins, and Cardinality.
• Good understanding of Resolving join-problems loops, Chasm traps, Fan traps with
• Webi: Creating Reports from Universes using Formulas, Variables, Prompts, Drilling. BICS connectivity BEx and BO: Worked with Webi for creating complicated reports including sub-reports, graphical reports, formula based, well-formatted reports, drilling reports, along with LOVs and data reports.
• Xcelsius: Creating Dashboards, Importing data through Live Office connection.
• Worked on Crystal Reports.
• Creating and managing the Info Areas, Info Object catalogs, InfoObjects, Info Cubes, ODS objects, Info sets, Multi providers, Application components, data sources, DSO Objects, Transformations, Info package, Transformations, Migration, Re-Modeling, Object Transportation, DTPs, Open Hub Services, Process chains and managing PSA.
• LO Cockpit Extraction, CO-PA, Flat File Extraction, Activating and transporting Data sources, Deleting contents of setup tables, Customizing and Enhancement of Extract structure and Master Data extractions from R3 to BI.
• Created PLM project roadmaps according to data migration plans.
• Formulated PLM requirements and conducted training sessions to business and end users.
• Createdsetup tablesfor the LO-Cockpit extraction, performingV3 updateusing lbwe to get the data from the outbound queue of the ECC system to the delta queue of the BI system.
• Configured Plant-to-Plant stock transfers using stock transport orders and the following functionality of SAP are configured in Inventory Management (Goods receipt, Good issues, Transfer postings and stock transfers, Reservations, Reporting in IM)
• Developed various aspects of HANA modeling including creating schemas and importing source system metadata, creating attributes, measures, hierarchies and developing Information Models with Attribute Views, Analytical and Calculation Views.
• Development of an overall design, development and implementation of SQL scripts, stored procedures, cursors and triggers.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Build HANA S/4 Design/Simple Finance System.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Involved in tickets logging regarding extractions, Performance Issues and also load failures.

Confidential, New York, NY

Environment: SAP BI 7.3, BO (4.1), HANA, ECC 6.0, SRM, SEM (IP), Oracle, FICO, PUR, SD, MM, Project Systems, T&E (Travel and Expenses), Logistics (Extraction) modules, Fox Formulas, Sql Server, Analysis for office, BEx Query Designer, WAD and BEx Analyzer

Responsibilities:

• Worked as BI/BO and gathered business requirements and deliverables for report requirements along with functional end users in the business areas. And analyzed to identify business content data sources for Enterprise Data warehouse.
• Experience in SAP PLM Functional & trouble shooting and strong knowledge in product design processes according to the best practices.
• Extensively worked on FI-GL, LO Cockpit, CO-PA, Generic Data Source, DB Connect customization and extraction.
• Involved in review for various objects and created test case and test plans in different environments.
• Data Provisioning and replicating data from source system toHANA Database using SLT and Business Objects Data Services.
• Replication of the selected tables of SD from ECC toSAPHANA. Performed transformations during the replication process.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Monitoring the replication process usingSAPHANAstudio andSAPLT replication serverfor transactional integrity.
• Performed Master data and Transaction data extractions (SAP, Non-SAP) and automated the data loads using Process Chains.
• Analyzed PSA table growth and scheduled weekly PSA and Change Log deletion jobs.
• Developed various aspects of HANA modeling including creating schemas and importing source system metadata, creating attributes, measures, hierarchies and developing Information Models with Attribute Views, Analytical and Calculation Views.
• Development of an overall design, development and implementation of SQL scripts, stored procedures, cursors and triggers.
• Experience utilizing SAP Landscape Transformation (SLT) for real-time (and non-real time) data replication from SAP ERP or non-SAP systems
• Analyzing the all the releases of SAP HANA in-Memory Platform core technology, including architecture, landscape design, installation, upgrades, performance tuning, and system integration.
• Developed real time Infocubes for IP Planning such as Sales Planning, Cost Center through BPS functions using flat files.
• BICS connectivity BEx and BO: Worked with Web I for creating complicated reports including sub-reports, graphical reports, formula based, well-formatted reports, drilling reports, along with LOVs and data reports.
• Web Intelligence: Created Advance multiple Reports, Ad hoc query, tables, charts, Complex Filters customized formulas and highly formatted page layouts, Connecting BOBJ using SAP and Oracle for reporting, and involved in Webi connectivity with BICS connection.
• Load balance and fail over configuration, advanced analysis / analysis for office install and upgrade
• Assisted SAP Basis team in installing HANA 1.0 and solely integrated it with Business Objects 4.0 and BODS4.0.
• Established the best modeling and recommended strategies for BOBJ environment and architecture forSAP HANA.
• InstalledBOBJ 4.1andBODS 4.0and configured SAP and Windows AD authentication for Business objects enterprise.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.Created Technical specifications and standard modeling documents for HANA.
• Involved in SAP BI security.
• Xcelsius: Creating chart with visualizing data range, Series, interactive model, map with graphics, Query as a Web Service.
• Crystal Reports: Planned, created formatted reports, multiple groups, Integration with SAP Data Source, manipulation formulas, applying conditions and exporting reports to Excel and Word.
• Deployed BO Reports/Dashboards in SAP Enterprise Portal.
• Extensively worked in INFOVIEW to create Web Intelligence, Desk Intelligence Reports over the Universe Created.
• Implanted Advanced Analysis reports on OLAP connections using OLAP Advanced Analysis

Confidential, Woodcliff Lake, NJ

Environment: SAP BI 7.2, ECC 6.0, Oracle, HR/FICO/SD, PP, MM modules

Responsibilities:

• Understanding the As-Is business process (based on the business case and role plays)
• Preparation of Business Process Master List, To-Be documents.
• Experience with Gap analysis, development, customizations and implementation of SAP HR application with complete life cycle implementation for 1.5 versions.
• Analyze and understand HR - BI related business requirements, perform impact assessments & write functional specifications
• Monitor the SAP HCM, SAP BI roadmap, and industry trends to enhance HR/Payroll capabilities.
• Recommend SAP HCM global application solution architecture, providing options, costs and pro/cons.
• Develop the HR reporting and analytics architecture.
• Co-ordination with technical team for objects development and worked on HR workflows with workflow consultant.
• Support configuration of Infocubes, Multicubes, and DSO for Personnel Administration, CATT, Time Management, Payroll, Travel Management, Benefits and Staff Performance.
• Authorization design and coordinating with Security team for role build.
• Working in HR Master Data like Employee, Person Enhancements. Worked on Employee Performance Managements, Employee Headcount and Actions, Concurrent Payroll and Compensation modules, Benefits.
• Data Migration and Master Data upload in Cut Over phase through CRM and ECC systems.
• Functional testing of all web reports and closing all issued tickets.
• Backend Support for end-user clients in France.

Confidential, New York, NY

SAP BI Architect

Environment: SAP BI 7.2, ECC 6.0, Oracle, SQL, BPM, Metastorm, Aggregate Spend modules,, PP, SD, MM, FICO.

Responsibilities:

• Gathered Business Requirements and Conducted Gap Analysis to install Business Content.
• Met with global procurement leads (business).
• Lead the process of requirements/data gathering.
• Help build the dashboards and drill down reports.
• Analyze each of 30-50 spend categories and identify the methodology to determine how much is spent in each category/region/sector.
• Created Process Flow, Data Flow diagrams.
• Involved in creating Project Plan, Project Charter.

Confidential, Lebanon, NJ

SAP BI Consultant

Environment: SAP BI 7.2, ECC 6.0, BPC, Oracle, Essbase, FICO/MM/SD modules

Responsibilities:

• Gathered Business Requirements and Conducted Gap Analysis to install Business Content.
• Gather the requirements for blue print, build, the consolidation, Planning, Budgeting and Forecasting functionalities.
• Prepare process Definition Document (PDD), Report definition Document(RDD)for the finalized consolidation, planning, budgeting and forecast processes.
• Expertise in creation of Basic cube, Remote cube, Transaction cubes and DSO.
• Designed & developed custom DataSource, InfoSource, Extractor, InfoCube and DSO to fulfill user requirements.
• Developed Transfer rules, Update rules and Start routines using ABAP to in corporate Business logic and perform data manipulation.
• Utilized the Analysis Process Designer (APD) to populate summary cubes from BPC data.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Prepare Planning consolidation design documents, process flows
• Prepare functional, technical specification for Planning, consolidation reports.
• Extensively worked on Query Designer and Web application designer to create Queries to forecast sales, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Used reporting agent to create batch jobs for Report printing and Exception reporting.
• Involved in documentation and end - user training.

Confidential, Bhasking Ridge, NJ

Sr. SAP BI Functional Lead

Environment: SAP BI 7.2, ECC 6.0, Oracle, Essbase, FICO/MM/SD, PP modules

Responsibilities:

• Interacting with end users to understand their reporting requirements and creating document of understanding
• Involved in data design, data modeling, data extraction, data loading, reporting and production support.
• Extensively worked on extracting the data from Flat Files to SAP BI.
• Experience in usingwebservices Data source for RDA functionality.
• Loaded these objects with Master data and Transactional data from flatfilesusing full/delta loads by creating Info Packages /DTP s.
• Responsible for the design and development of the data acquisition process, data mapping, DSO, InfoCubes, InfoObjects, etc. in an SAP BI Netweaver 7.2 environment.
• Developed Transfer rules, Update rules and Start routines using ABAP to in corporate Business logic and perform data manipulation.
• Created process chains for parallel data loads, and scheduled them at off - peak hours to reduce the systemload.
• Designed and developed reports using the query designer, BEx analyzer, and WAD portal reports.
• Created reports with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
• Created Aggregates on InfoCubes in order to generate reports and improve query performance.
• Worked onWebApplication Designer and Published reports onweb.
• Involved in performance tuning for InfoCubes- functionalities included partitioning, compression, statistics and maintenance of aggregates.

Confidential, New York, NY

Sr. SAP Functional Lead

Environment: SAP BI 7.0, Business Objects, ECC 6.0, FICO/MM/SD/PP modules

Responsibilities:

• Working on ASAP methodology. Interact with business representatives to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BI Reporting and applications.
• Responsible for the accurate design of modules FICO, SD and PP in order to properly match the company’s business process needs.
• Worked in a full life-cycle SAP project including: Business Blueprint, Business Process Procedures approvals, unit testing, integration testing, data migration, training and Go-live support.
• Extracted data using flat files for raw materials in order to track inventory.
• DevelopedConsolidatedP&L, Balance Sheet trend reports, monthly, yearly and Year to date showing with Actual vs Budget, Actual vs. Forecast data and integrated them into several financial reporting workbooks.
• Initial data load and implementation of daily update process chains
• Design & development of analysis authorizations for the end-users.
• Developing Portal Java iViews inSAPNetWeaverDeveloper Studio.
• Supports the design and delivery of KPI (Key Performance Indicator) reports, management dashboards, and visual analytics for distribution to analysts as well as executive management.
• Created universes, classes and objects by retrieving the data from Bex queries and defining the necessary connections.
• Used Business Objects Developer Suite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to every component.
• Creating standard full client reports and WebI reports.
• Delivered WebIntelligence training to end users.

Confidential, Greenwich, CT

Environment: SAP BI 7.0, ECC 6.0, BPC, Teradata, Oracle, FICO/MM/SD, P2P modules

Sr. SAP BI Architect

Responsibilities:

• Interact with business representatives to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BI Reporting and applications.
• Blue printing, design, developing, testing and supporting the Business, planning, and consolidation requirements.
• Create, maintain consolidation application such as Legal consolidation, rate, ownership.
• Creation of planning application such as revenue planning, inventory planning, cost planning, HR planning, etc.
• Input schedule sales quantity, stocks, adjustments, rounding, entering planned amount for sales, inventory planning, HR planning. .
• Work directly with the business and other IT counterparts to prioritize, design, plan, manage, and deliver reporting and analytics solutions.
• Understand SAP standard content to satisfy Business requirements, but also possess the capability to enhance/customize where necessary.
• Responsible for extracting data from Teradata source using UDC and stored data into Remote cubes.
• Responsible for the design and development of the data acquisition process, data mapping, SAP extractors, DSO, InfoCubes, InfoObjects, etc. in an SAP BI Netweaver 7.0 environment and will estimate, schedule, design and execute the various reporting projects.
• Extracted cost and account based data using CO-PA for analyzing data from various sources.
• Create data models and data flows (extended star schema, ODS, data marts & external data).
• Involved in security analysis by checking profiles for end users and reporting users.
• Prepare project related documentation (object designs, business rules, technical information etc) during the different stages of the project.
• Involved in providing Authorizations by creating Roles and Profiles.

Confidential, NY

Environment: SAP 3.5, BI 7.0, BPS, FI/CO, PP, SD, MM, IP, Oracle 9.2, and ECC 5.0.

Sr. SAP BI Consultant

Responsibilities:

• Involved in complete Product Development of SAP Netweaver 2004S
• Performed migration of emulated data source.
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5.
• Used Write-Optimized DSO (DataStore Object) to load data into BI system.
• Enhanced Infocube with remodeling concept to make changes, without having to reload data.
• Used the lock concept to lock tables, characteristics and manage these locks.
• Developed backend work by creating InfoCubes, DSO, InfoObjects as InfoProviders, InfoSets, Open Hub destination, Multiproviders and Process Chains.
• Created complex Start routine in Transformations of DSO and mapped with 3 tables in Data Dictionary and populated data dynamically into the data target.
• Created Hierarchies for all Master Data InfoObjects.
• Designed Custom FI-GL, PCA cubes to bring the FI and PCA data in BI using custom standard DSO Objects delivered in the BI Content
• Used transfer routines for key figure calculations, update routines in the update rules.
• Actively involved in the Front end development using WAD (2004s), BEx Analyzer.
• Developed Workbooks and Web Templates for Web Application Designer (WAD) and posted them in portals as Iview.
• Plan, implement, configure, and upgrade SAP NetWeaver products and supporting technologies, including Web Application Server (WebAS) and Business Information (BI) Warehouse.

Confidential, Houston, TX

Environment: SAP BI, SAP R/3 4.7, SD, MM, FI/CO,PP and Oracle.

SAP BI Consultant

Responsibilities:

• Worked with several users and interacted with them to gather requirements and transformed them into a data model with the concept of Extended Star Schema.
• Customized InfoObjects to match reporting requirement by creating variables in BEx.
• Created InfoCubes based on the data content. Created MultipleCubes such as Demand cube, Supply Cube and Inventory cube.