SUMMARY

• Accomplished 3 Full Life - cycle implementations from design to go live. Managed and Involved in all the phases of a project life cycle including: analysis, Blue printing, design, configuration, testing, and deployment of solutions, post-production support/maintenance, and documentation (test planning and test materials preparation and end-user training)
• Experience in a SAP Net weaver 2004s(7.3 and 3.x) with Data Flow Modeling in BW with Administrator Workbench Info Objects, Info Cubes, Aggregates, Operational Data Store (ODS), Multi-cubes, Info-sets, Data Sources, Transformations (Rules, Routines, Start routines, End routines and Expert routines), DTP (Data transfer Process), Open Hub destinations, Migrations of 3.x Data sources and creating Process Chains.
• Experienced in Installation, Configuration, Upgrades, Cutover-plans and Migration. Experienced in Analysis, Design, Development, Maintenance, Enhancements and Testing.
• Experience in Business Objects 4.2/4.1/4.0/3.1/ R2/6.5 Including Web Intelligence, IDT, UDT, Office Analysis, Lumira, Crystal Reports, WEBI Rich Client, SAP Mobility, Central Management Console (CMC), Xcelsius, Design Studio, QAAWS, Live Office, Data Integrator, BO SDK, and Life Cycle Manager.
• Experienced in Dashboard Creation using Design Studio, Xcelsius; Used Query Browser, BIWS, BICS, QAAWS and Live Office connection methods.
• Experienced in SAP S4 HANA using SAP HANA Studio; Created Analytical / Calculated / Attribute views. Promoted the view to different environments
• Experienced in Business Objects Administration and SAP Security
• Experienced in SAP S4 HANA using SAP HANA Studio; Created Analytical / Calculated / Attribute views. Promoted the view to different environments
• Experienced in ETL Methodologies using Business Objects Data Services
• Experienced in Report Integration with SAP Portal, Java/. NET using Single Sign-On Method
• Experienced in Developing SQL, PL/SQL programs
• Experienced ECC 6.0 in both application specific extractions like CO-PA and LO Cockpit as well as Generic Extractions. Sound knowledge in identifying and activating the necessary Business Content.
• Excellent ABAP skills in regards to Extractor enhancements, Start routines, End routines, Expert routines User exits required for Data Modeling, ETL and reporting requirements. Experience in
• Extracting Data from various SAP source systems, APO, SCM, SRM, CRM, and SEM-BPS.
• Experience with Performance Tuning measures in creating Aggregates, using BI Statistics Cubes, Query Monitor (RSRT) and Workload Monitor (ST03). Expert in Reporting using BEx Analyzer, BEx Web, BEx Query Designer, BEx Broadcaster, EP Integration, iViews, Visual Composer, and Collaboration Rooms.
• Expertise in creating BW components like Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, RRI, WAD, Web Reports, and CSS style Sheets. Created iviews in visual composer and published in Enterprise portal.
• Used Remedy and Altiris applications for Creating and Managing Help desk Tickets. Proficient in working with MS Office tools, Have good leadership abilities with experience of managing a small team or working as an individual or working with in a team.
• Extensive experience in using Excel skills such as Vlookups, index match, pivot tables, visual composer, formulas and properties.
• Mentored BW/BI/BO team and involved in knowledge transfer sessions.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAP HANA/ BW/BI BOBJ Architect

Environment: Business Objects XI 4.2/4.1, SAP HANA, Web Intelligence, Information Designer Tool, Interactive Analysis Desktop, OLAP Advanced Analysis, Universe Designer, Dashboard Designer, Design Studio 1.3, Xcelsius 2008, QAAWS, Live Office, SAP BI 7.4, ECC, BEX Designer, BEX Analyzer, Tableau, MS word, MS Excel, MS Access, MS Power Point Unix and Windows 7 / XP/ 2008

Responsibilities:

• Worked with Corporate Business teams to understand the requirements
• Provided POC using SAP BOBJ (Web Intelligence, Dashboard Designer, Analysis office and Lumira)
• Created Storyboard documents for FI, SD, MM, FA and HCM
• Developed Analytical solutions using SAP BI 7.4, Business Objects 4.2/4.1 application tool set
• Played Key role in BI reports Development Analytical & Operational using Business Objects
• Used SAP BEX Designer to create BEX queries; Created/Used Calculated KFs and restricted KFSs
• Used HANA Studio; Created Data models for Analytical, Calculated and Attribute views
• Created views based on the business requirements and used filters for data restrictions
• Performed HANA views promotion between different systems using (Export/Import)
• Used simple finance tables (ACDOCA) for all FI reports and V ANLBAZ for Fixed assets.
• Used SQL script to create HANA views and data validation
• Involved in Support and Monitoring activities after go-live.
• Created IDT Universes, used SAP HANA views as data sources using relational connection
• Created Web Intelligence reports on Universes & BICS connection (for BEX sources)
• Created WEBI / Analysis office/Lumira report on S4HANA views using OLAP connection
• Used various WEBI functions to simplify the data presentation.
• Scheduled the WEBI reports on Daily & weekly basis
• Created Design Studio & Lumira Dashboards for QM & HCM
• Published the document into BO enterprise and applied the SAP security model
• Worked on BOBJ upgrade from 4.1 to 4.2, used cutover plan to validate documents
• Worked on Promotion management to migrate the BOE documents
• Handled all BOBJ admin roles (User Security, Migration, Server look up, Upgrade)
• Worked with various business teams for all System Integration tests
• Created Documentation for all HANA models, reports and Dashboards
• Conducted KT and User training sessions; Created User guide document for all Business area reports.

Confidential, Fort Lauderdale, FL

SAP BI/BOBJ Architect

Environment: Business Objects XI 4.1, SAP HANA, Web Intelligence, Information Designer Tool, Interactive Analysis Desktop, OLAP Advanced Analysis, Universe Designer, Dashboard Designer, Qlikview, Design Studio 1.3, Xcelsius 2008, QAAWS, Live Office, SAP BI 7.3, ECC, BEX Designer, BEX Analyzer, SCRUM methodology, MS word, MS Excel, MS Access, MS Power Point Unix and Windows 7 / XP/ 2008

Responsibilities:

• Worked with OTC and TPM functional teams to understand requirements
• Provided Business Intelligence solutions using SAP BI 7.3, Business Objects 4.1 and Design Studio
• Played Key role in BI reports Development and Migration using Business Objects 4.1
• Worked on Management Geo & Profit center Hierarchies
• Used Information Designer Tool to create OLAP connections on SAP BW system
• Created various WEBI reports & OLAP Advanced Analysis reports on BICS connections
• Created Cross tab reports and represented data in graphical charts
• Used Publication for reports distribution to dynamic recipients
• Scheduled publications with event based trigger
• Established Qlikview for TPM sales forecast and customer account plan
• Created KPIs and presented Data in different graphical visuals
• Responsible for BOBJ Transports using Promotion Management
• Assigned Folder Level security to the user groups
• Managed all BOBJ severs; Created server groups for Scheduling and Publication.
• Responsible in monitoring daily schedules for all DSR reports and Executive Briefing book
• Worked with Business Analysts for all System Integration Tests
• Created User guide documentation and performed Technical KT session with end user
• Agile system, used SCRUM methodology.s

Confidential

SAP BI Systems Analyst

Environment: SAP Net weaver 2004s(7.x and 3.x), ECC 6.0, BEx Query Designer/analyzer 7.x, BEx Query Designer/analyzer 3.x, Web Application Designer 7.x, Remedy 7.5, Solman, MM, FI, SD, BPC, BI 4.0.

Responsibilities:

• Extensively worked in production support, which involved work in ECC, Data modeling and Business Explorer (Bex).
• Monitored daily, weekly and monthly Process Chains and fixed them when failed which involved data load failures, invalid character issues, system locks, DB2 space getting full.
• Extensive work in validation and trouble shooting of transaction data and master data, change management, transport management, roles and security, system checks, performance tuning and process chain.
• Played a key role in sending out the accrual report to the business on weekly and monthly basis. Worked on Process Chains to load the flat files that come in to BW every day from Mfgpro and to extract the data from ECC for three different regions (North America, South America and Europe).
• Worked on the queries to compare the ECC and Mfg data and was involved in fixing all the issues that were occurring with discrepancies of data between these two systems for any plant for all regions.
• Process chain monitoring and loading data manually to fix the failures.
• Involved in discussions directly with the business in understanding and solving their issues with their plant.
• Handled all the issues related to loading these files manually if needed and also all the issues the accrual comparisons between SAP and Mfgpro systems using the BW reports. These issues involved analyzing the DSO’s, Cubes, Extractors and comparing back to source systems and fixing the issues.
• Worked on planning reports, which involved working with BPC data models.
• Worked in Agile environment. SCRUM master methodology and used Jira to manage the defects and monitoring tickets based on priority.
• Involved in the designing and Building of Universes, Classes and objects.
• Created reports using Business Objects functionalities like Multiple Data Providers (Merging), Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail Created Complex Queries in Desktop Intelligence and Web Intelligence including Complex Conditions (wildcard characters, In List, Different From), Sub queries, and Grouping Conditions.
• Created Xcelsius components like charts, menus and containers Mining data and performing statistical analysis using Predictive Workbench.
• Troubleshooting the issues in reports and universes.
• Resolved loops using Contexts, and Aliases
• Created reports for various Portfolios using the Universes as the main data Providers.
• Tuned Universe by creating Joins, Contexts, and Aliases for resolving Loops and checked the Integrity of the Universes
• Lead a team of off shore and on site members.

Confidential, West Palm Beach, FL

Sr. SAP BI Lead Analyst

Environment: SAP Net weaver 2004s(7.x and 3.x), ECC 6.0, BEx Query Designer/analyzer 7.x, BEx Query Designer/analyzer 3.x, Web Application Designer 7.x, Visual Composer 7.1,7.2 and 7.0,Remedy 7.5,Mercury, FI, PM, AM, GL, HR, PM, PBF, IS-U, and PS.

Responsibilities:

• Worked on Pricing in BW, which involves bringing data sources on all Pricing tables, bringing them to BW, creating DSO’s on top of those, creating APD’s to determine the Price and the discounts. Created APD’s to explode the keys all over the A tables for determining the correct price. Used Direct Update DSO to update data from APD’s, loaded all this data to the cube.
• World Wide Price List: Automated ZWWPL SALSA (Price List) report in BI. This allows the users to know the pricing for a Material based on the Distribution Channel, Sales Org, Discount level and types.
• Migrated the 3.X to 7.0 objects, replaced all old data flow with the transformations followed by DTP’s to load the data.
• Enhanced the Material Classification data source 1CL OMAT006 to add classification fields, extracted the data in BW and created a DSO with all the classification characteristics and built a open hub on top of it which helps the Sales Force to consume this data through data services.
• Extensive BW development in creating Objects, DSO’s, Info Cubes, Multi providers, Open Hubs, APD’s, Process Chains.
• Used Qlikview for to consolidate, visualize and analyze the data.
• Enhanced 0Material to for classification data and also worked on bringing the 0Material long text into BW using a Function Module.
• Worked on Sales Order Report (2LIS 11 VAITM and VAHDR) to get the Sales Orders and Quotes into BW created a Bex query on it. Then created generic Data Sources on Exception Header and Item tables, which have the Questions, Answers and Comments in them. Created a Bex Query on this. This is a jump query for the sales order report. So the users can jump to Questions, Answers and Comments for each Sales Order.
• Worked very closely with the Business users and ECC teams. Waterfall methodology.
• Used performance-tuning measures like building aggregates for better query performance, extensive work in RSRT in maintaining the cache and the query performance.
• Resolution of data load errors and Job failures in SM37.
• Wrote ABAP code to eliminate erroneous characters during data load, merging the data for a field, which is 1000 characters long in ECC into four info objects.
• Created Super Bex Queries for BO Universe creation. Created several Webi reports, Deski reports and Dashboard reports for graphical presentation.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Involved in giving reporting solutions as how the macros, WAD, BO, VC or the portal can be used to make the reports work appropriately.

Confidential

Sr.SAP BI/BO Developer

Environment: SAP Netweaver 2004s(7.x and 3.x), ECC 6.0, BEx Query Designer/analyzer 7.x,Web Application Designer 7.x, SAP Business Objects XI 3.0, 3.1, BCS, BIA(BI Accelerator), PL/SQL, BO Explorer SD(Deliveries and Shipments),FMCO(Profitability Analysis, Product Cost Controlling), PP(Product planning), MM(Purchasing, Inventory Management).

Responsibilities:

• Gathered User Requirements, Created Business Blueprint, Analyzed reporting requirements, Gap Analysis, Evaluated Standard Business Content, Design and Development of Information Catalogs - Data Mapping, Design of Functional and Technical specifications for all the reports given below.
• Conducted the workshops with business users and process owners to identify and document the requirements.
• Identified business content and prepared design documents for technical team.
• Modified standard and created custom DataSources, InfoObjects, DSO and InfoCubes for SD, MM, PP and FI.
• Worked on LO cockpit for Maintenance of extract structures, Maintaining Info Sources, Activating the update.
• Inventory detail Report: Automated MB5L report in BI to pull the inventory volume and dollars fro current and prior months. Automated this report in BI, which shows the Inventory Value and quantity for current month and prior month. Created a workbook, which shows this data. This workbook also had the queries fro top 20 materials based on each material type. Earlier the users to run MB5L 20 times to get this report.
• Cost Estimate Report: Automated S P 99 41000111 report in BI. This allows the users to know the cost for a material based on the Cost Component, Cost component View, Company Code and various other selections. Also used condition to toggle between history and recent cost change based on date.
• Supply Vs Demand spreadsheet: This spreadsheet has the data coming from sales and demand for a product to countries, 3rd parties and plants. Automated ZVG7, COID and MB51 data to get a part of this workbook. Created flat files for the data coming from ARC, MIMI and DFS systems and created an input transaction where the users regions can input their numbers from other sources than SAP.
• Global Forecast Report: Automated KE30 data in BI to get the report with Quantity, Gross sales, Net sales and Standard COGS.
• Extensive work in creating workbooks using the BEx analyser, using macros and the BEx functions and Excel functions.
• Involved in developing and conducting extensive unit testing, Integration testing, Regression Testing, User Acceptance Testing and documenting the tests and results.
• Conducted SAP BI training sessions to Power users and business users to participate in testing.
• Responsible in optimizing the data load process to minimize load time and fix the causes of load failures.
• Used reusable structures, exceptions, variables, filters, restricted and calculated Key figures for reporting and maintained RRI’s
• Designed and created universe based on Infoprovider in BW, designed and created Universe based OLAP Queries in BW,designed and created reports using Web Intelligence in Business Objects, designed and created reports using Desktop Intelligence in Business Objects, worked with Business Objects Administrator to configure Infoview for different roles, formatted reports in Business Objects and published, created calculated value fields in business objects based BI key figures and designed and created dashboards using Xcelcius.