We provide IT Staff Augmentation Services!

Senior Sap Hana Consultant Resume

CT

PROFESSIONAL SUMMARY

  • 14 years of IT experience in SAP BI,BW, BO, HANA, Project lead, SAP BI Architect, Development of Enterprise Application as well as Client/Server and Web Services applications including 11 years of experience in SAP BI/BW/BOBJ implementations and 2 years of SAP HANA experience and 1 year of SAP BODS experience
  • Expertise in SAP HANA data modeling using Attribute View, Analytic View, and Calculation Views and SAP HANA Data provisioning technology including SAP LT Replication Server, Data Services.
  • Expertise in SAP HANA Security design and implementation of the security roles, assignment of roles to users, creation of analytic previleges, assignment of analytic previleges to roles directly as well as to users directly
  • Technically involved with Architecture Design, Develop/Build, Optimize Solutions/Applications on SAP HANA. Also participated in BW on SAP HANA, BI Analytics and Report Integration on SAP HANA.
  • Knolwedge of SAP HANA Live and worked on RDS for COPA.
  • Involved in implementing SAP HANA Live models for business areas
  • Worked on SAP HANA Security including User Management, Roles, and Privileges. Experience with SAP HANA Data Administration including managing schemas, data model objects, import/export content.
  • Experienced in SAP BW 2.0B,SAP BW 3.X, SAP BW 7.X versions with all the BW development,design, modelling and administration activities along with SAP BW, Reporting and OLTP Extraction from SAP R/3 Using LO Cockpit, CO-PA, FI, CO and Generic Extractions.
  • Expertise in requirement gathering workshops/ end user trainings/ integration testing / cutover management / helpdesk setup & post go-live support.
  • Good knowledge of SAP key processes and functional areas with expertise to handle supply chain, sales & marketing, finance and logistics business solutions.
  • Specialize in gathering, implementing Business Intelligence and analytics solutions focusing on KPI’s for organization performance.
  • Excellent Knowledge of SAP BI 7 components like Info Cubes, Data Store Objects, Multiproviders, Infosets, Data Sources, Transformations and Data Transfer Process.
  • Expertise in various data design models - Entity Relationship (ER), Multi Dimensional/Star Schema and Extended Star Schema models
  • Experienced with LO-Extractors, generic data extractors, customer exits, variable exits and SAP Enhancements
  • Intensively worked with performance tuning to improve data loading and query performance.
  • Experience in Monitoring data request and correcting the errors occurred during data extraction.
  • Knowledge of Open Hub (InfoSpoke) to transfer data from InfoProvider to Flat Files and External Systems.
  • Expert knowledge in Design and development of Queries, Workbooks and InfoSet Queries from both InfoCubes, ODS. Used BEX Analyzer, Bex Query Designer, Query monitor, BEX Brodcasting.
  • Involved in Installing Business Objects, Creating Repository, Creating Users and User Groups using CMC and Supervisor.
  • Expert in planning, designing, developing, modifying, updating, maintaining and distributing Universes and Reports.
  • Expertise in designing Universe and creating reports on 6.5 and XI R2, XI R3, XI 3.1, BI 4.0.
  • Expertise in Designing Universes on different relational databases such as Oracle, SQL Server, Sybase, Teradata.
  • Experience in building efficient and user oriented universes using Designer and creating adhoc and canned reports using Desktop Intelligence, WebIntelligence and WebIntelligence Rich Client.
  • Experience in building Desktop Intelligence reports using Universes, Personal Data files and Free Hand SQL Methods.
  • Knowledge in creating and managing Information Spaces using Business Objects Explorer for Guided Adhoc reporting solutions
  • Specialized in BI Upgrades(BW 7.3, BI 7.0, BW 3.5, BW 3.1, BW 3.0B)
  • Introduced and Implemented the new interactivity available in XI R3 to business like Offline Ad hoc reporting, Data Tracking of Medicare members, Hyperlinked reports and Stored Procedures implemented at the Universe level.
  • Implemented Live Office, Created performance Dashboards (Xcelsius and Dashboard manager) and score cards across multiple domains in XI R2 and R3.1. The Domains include Healthcare (Claims and Products), Manufacturing, and Government, Sales force dot com, Supply Chain management and Finance.
  • Used Oracle 10g, SQL, SAP BW as the data sources.
  • Loaded data from Legacy systems using DB Connect.
  • Worked extensively on APD (Analysis Process Designer).
  • Good knowledge and Experience in using Oracle 11g/10g/9i/8i, DB2 UDB 8.x/7.x, MS SQL Server 2000/2005, Enterprise manager, Query analyzer.
  • Involved in developing and designing ETL mappings, workflows, data loads and schedule the workflows using various scheduling tools.
  • Good experience in Software Development Life Cycle of Business Intelligence and Data warehousing projects.
  • Ability to quickly adapt to different project environments and an excellent team member.
  • Excellent interpersonal and communication and presentation skills along with Time management.

PROFESSIONAL EXPERIENCE

Confidential, CT

Role: Senior SAP HANA Consultant.

Confidential is a global biopharmaceutical company focused on developing and delivering highly innovative and life-transforming therapies for patients with severe and life-threatening diseases. Patients with these diseases often have no effective treatment options and live with little hope. At Alexion, the patients we serve are at the heart of everything we do. We developed Soliris® (eculizumab), the world’s first and only approved terminal complement inhibitor, from the laboratory through regulatory approval and commercialization. Soliris was the first treatment specifically developed and approved for the treatment of patients with paroxysmal nocturnal hemoglobinuria (PNH) and atypical hemolytic uremic syndrome (aHUS), two devastating and life-threatening ultra-rare diseases.

Responsibilities

  • Involved in constant requirements gathering and business needs with executives and business managers for Dashboard design and development.
  • Worked on analysis of security for SAP HANA and provided documentation of the security profiles required for SAP HANA
  • Worked on creating analytic previleges, roles, assignment of analytic previleges to roles and creation of different users and assignment of roles to users based on the business requirements.
  • Worked on creating dashboards, webi reports, bex queries, BW data models, end to end implementation of BI Reporting using business objects and SAP BW.
  • Implemented reporting for HR, Commercial, Financials, Supply chain areas and also worked with business users to identify the enhancements and identified the datasources and extracted the data
  • Converted Reporting business requirements in to Functional design and Technical design documents for Developers and used datasources like 0HR PA 0, 0HR PA 1 for extracting Personnel Administration and Organizational Management data into BW and provide BO Reports
  • Working along with DBA/s, BA’s and Data modelers for data design and report design.
  • Involved and designed the Enterprise level data security, report security level set up folder structure and User group access.

Confidential , NC

Role, SAP HANA Consultant.

Confidential is one of the world’s leading producers of industrial polyester fibers and fabrics and the only manufacturer with operations in North America, Europe and Asia. Our size and global reach give our customers a competitive advantage through a large supply of products, fast delivery, multi-plant sourcing, and both regional and global customer service and technical support.

Responsiblities

  • Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.
  • Analyzed SAP BW Security and implemented SAP HANA security similar to SAP BW Security Roles and created separate roles, analytic previleges for non sap data and implemented security for non-sap data.
  • Created direct logon Business users, data modelling users and database admin users by assigning appropriate standard roles MODELLING, MONITORING and CONTENT ADMIN to the users
  • Replication of the selected tables of SD from ECC to SAP HANA. 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 using SAP HANA studio and SAP LT replication server for transactional integrity.
  • Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.
  • Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Migrating standard Infocubes to In memory optimized Infocubes using migration Tool.
  • Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool.
  • Importing the BW Models in to HANA using HANA Studio.
  • Consuming the HANA Models in BW by creating the Transient Providers.
  • Oversee the build out of new and enhancement of existing cubes and reports within newly deployed SAP BW / BI Financial Data Warehouse to meet business needs.
  • Involved in designing and creating the respective DSO, Infocube and MultiProviders to best meet the user requirements in a much more flexible way to meet any future change requests.
  • Created various queries and extensively worked on Query Builder objects viz. filters, Structures, Exceptions, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Offsets and Query Variants.

Client, Confidential, San Antonio, TX

Role, SAP BI/HANA Lead Consultant

The Confidential is a Texas-based Fortune 500 diversified financial services group of companies including a Texas Department of Insurance regulated reciprocal inter-insurance exchange and subsidiaries offering banking, investing, and insurance to people and families that serve, or served, in the United States military. At the end of 2013, there were 10.1 million members. I am currently working in Member Debt Solutions Project where EDW is converted from SQL Server into Enterprise Data Warehouse for the Bank Collections process and provide reporting for business.

Responsibilities

  • Collect, analyze and document business requirements and translate user requirements into technical solutions.
  • Involved and designed the Enterprise level data security, report security level set up folder structure and User group access.
  • Worked on schemas on HANA environment, developing calculation views, attribute views, analytical views based on the requirements and migrated them to production schema.
  • Took daily back up of HANA dev, qa and prod schemas
  • Performed performance tuning on the BO Reports by enabling the expensive sql trace on slow bo reports
  • Replicated selected tables of FI from ECC to SAP HANA and performed transformations during the replication process
  • Involved in constant Requirements gathering and business needs with executives and traders for Dashboard design and development.
  • Developed an ETL strategy to implement data extraction and reporting from various datasources.
  • Involved in constant Requirements gathering and business needs with executives and traders for Dashboard design and development.
  • Worked on onsite offshore model and coordinated the work to be done.
  • Developed an ETL strategy to implement data extraction and reporting from various datasources.
  • Converted Reporting business requirements in to Functional design and Technical design documents for Developers and testers.
  • Working along with DBA/s, BA’s and Data modelers for data design and report design.
  • Worked on new data acquisition capabilities (new Data Source concept, enhanced remote-access capabilities).
  • Maintained Layout settings for Characteristics and key Figures.

Client: Confidential, UT

Role: SAP HANA Consultant

Project Description: Confidential is using SAP HANA to analyze a large volume of complex data to gain business insights into software piracy, and to develop preventive strategies and explore significant revenue recovery opportunities.

  • Collect, analyze and document business requirements and translate user requirements into technical solutions.
  • Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
  • 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)
  • Worked on HANA SLT replication to do real-time extraction of Finance data from SAP ECC system and monitored the scheduled jobs
  • Created Attribute Views, Analytic Views, Calculation Views in SAP HANA Modeler for sap as well as non-sap data
  • Involved working with content models, attributes and measures, hierarchies.
  • Monitoring and troubleshooting data loads.
  • Build and enhanced BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.
  • Involved in implementataion of SAP HANA Live and rapid deployment solutions(RDS) discussions
  • Enhanced CO-PA and FI cubes with additional necessary missing fields.
  • Involved in constant Requirements gathering and business needs with executives and traders for Dashboard design and development.
  • Converted Reporting business requirements in to Functional design and Technical design documents for Developers and testers.
  • Working along with DBA/s, BA’s and Data modelers for data design and report design.
  • Involved and designed the Enterprise level data security, report security level set up folder structure and User group access.
  • Standardized BI development by creating Design document, BI checklist, SQL checklist for developers and CBT’s for new users.
  • Involved in System testing, unit testing and UAT for deployed reports and dashboards.

Client: Confidential, Lewisville, TX

Role: SAP HANA Consultant

  • Created Schemas (Universes), Imported Tables and Loaded data to tables and also copied standard content from SAP to local repository using SAP HANA
  • Used Hana Studio to Create Attribute Views, Analytical views and calculated views
  • Participated in Blueprint and design sessions, review options and provide recommendations while communicating the benefits, risks, and constraints to both the business and IT stakeholders
  • Implemented Best practices for modeling.
  • Administration and operation including monitoring, backup and restore, security and user management
  • Real time replication using SLT.
  • Experience with Information modeling, Table design, Data provisioning
  • Created Multiple analytical, and attributes views based on requirements.
  • Good understanding of Performance consideration while designing HANA views and blue printing.
  • Data provision using SAP DS and, Smart Data Access from various data sources
  • Developed existing reports in HANA.
  • Closely interacted with business team and completed the QA testing, Conducted workshops (Trained Business Users how to use Reporting)
  • Design & Development of universes with calculated measures and custom filters.
  • Design, install, and configure system for new implementations, upgrades, and maintenance.
  • Manage incidents, including complex troubleshooting across technologies.
  • Coordinate configuration, change, release, capacity and availability capabilities.
  • Ensure transactional integrity and address authorization issues.
  • Creating user groups for reporting and set email bursting with user specific data.
  • Extensively involved in training users in Web intelligence, Crystal Reports, and Xcelsius Through training led scenarios.
  • Interacted with Business Users to know their Business needs to effectively develop and modify Universes and Reports.
  • Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports. Involved in migration 3.1 to 4.0.
  • Designed/Modified the Universes as per the requirements adding new classes and objects as required.
  • Used derived tables to create the universe for best performance, and use context and alias tables to solve the loops and traps in the Universe.
  • Created various LOVs for ease of Ad-hoc reporting in the process of building the Universes.
  • Created reports in WEB Intelligence module and implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.

Client: Confidential

Role: SAP BI Architect/Lead

Confidential is based in Herndon, Virginia, is a leading enterprise software company that provides software solutions and services to the public sector including state, county and local governments. Confidential automates the justice and records management ecosystem that includes courts, jails, prosecutors, probation, and county clerks and recorders offices. Public sector offices require comprehensive, integrated information management and Confidential ’s innovative suite of products and services including its integrated justice platform, a platform for government records solutions, document management services, and various data access technologies allow government offices to operate with enhanced efficiency and effectiveness.

  • Collect, analyze and document business requirements and translate user requirements into technical solutions.
  • Worked on migrating all the SAP BW development from SAP BW 3.5 instance to SAP BW 7.3 version and worked on the enhancements in Procurement, SD, FI and CO modules
  • Worked with Transformations, Data Transfer Process (DTP) and Error Data Transfer Process.
  • Created BeX Queries for Business Objects reports and created solution layer in BW so the Business objects reports can access data from SAP BW.
  • Worked SAP BW/Business Objects Integration and worked on developing new multiproviders, infocubes and datasources for logistics and finance areas.
  • Worked on extracting data from other datasources like 2LIS 11 VAITM, 2LIS 13 VDHDR, Sales Order Item data (2LIS 11 VAITM) and Billing Document Item data (2LIS 13 VDITM) for the SD module
  • Extracted data from APO-DP using DataMart Architecture.
  • Created a Multiprovider to integrate the Process Order Cube, Inventory Cube and APO-DP Cube.
  • Created InfoSpokes to extract Purchase Order data to External Systems.
  • Worked with Process chains in order to automate the processes.
  • Developed and maintained ABAP routines in Transformation, User Exits and variable exits.
  • Interacted with key users to identify requirements and develop technical specifications.
  • Worked on Business Objects reporting on various data sources like MS SQL, Netezza, Henschen, and Foxpro databases.
  • Implemented both Accounts Payable Line Item and Accounts Receivable line item by enhancing business content.
  • 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.
  • Performed Unit and Regression testing.

Confidential, PA

Role, Sr BI Architect

Confidential is one of the world’s leading specialty biopharmaceutical companies.It has emerged as a company fully focused on a single purpose: to enable people with life-altering conditions to lead better lives.Shire is a global company with offices in the major pharmaceutical markets. Its UK offices are in Basingstoke and its US offices are in Wayne, Pennsylvania.This project involves in the Business objects Migration on Solaris machines from XI R2 to XI 3.1 which involves in the Business Objects Installation, Configuration, Migration and Administration of Business objects Suite like Webi, Designer, Xcelsius, and Dashboard Manager.

Responsibilities:

  • Working on Installing and configuring BO XI R3 servers, along with configuring User groups, folder structures for card team.
  • Working on Requirements gathering and raw data analysis for business users and for report development.
  • Working on design and developing business objects WEBI reports against multiple data domains.
  • Created reports against Oracle database for CDW/ SCRA team.
  • Responsible for administering BO CMC servers and implementing various security levels.
  • Created performance analytics dashboards using Xcelsius 2008 against Web I reports using live office.
  • Migrated legacy reports from 6.5 to XI R3.1.
  • Created complex universes, with derived tables and created best practices to leverage more on Universe rather than report for Performance.
  • Standardized BI development by creating Design document, BI checklist, SQL checklist for developers and CBT’s for new users.
  • Followed data governance instructions for NPI and non NPI data.
  • Involved in System testing, unit testing and UAT for deployed reports and dashboards.
  • Created Training manuals for the deployed User reports and conducted Status meetings with developers.
  • Currently, working on Performance dashboards based on revenue, finance charges, Payments due, Balance transfer, Overdraft and Stop payments using Xcelsius for the divisional managers.
  • Worked on Star Schema and Snow Flake Schema in the data modeling phase and Contexts and Aliases for resolving for resolving Loops and context in the Universes
  • Development of multiple Universes & various Reports under Teradata environment.
  • Created breaks, master detail, sorting, drill down, slice and dice, alerts, joins, hierarchies, ranking features to generate Adhoc, automated and complex Web Intelligence and Desktop Intelligence reports.
  • Created custom calendar to schedule the Web Intelligence reports.
  • Utilized Business Objects built-in @functions (@aggregate aware, @select, @prompt, @where) to improve the performance and to overcome intricacies related to data integrity.
  • Create custom Audit Webi and Crystal report to monitor user activity.
  • Designed and Created Business Objects Voyager Workspace reports against OLAP cubes as data source.
  • Designed and Created Dashboard using Xcelsius, Qaaws, Live Office for Proof concept for Xcelsius Products.
  • Responsible for Xcelsius Dashboard System Implementation
  • Implemented Single Sign on for Live Office Add on tools
  • Created Qaaws(Query As Web service), Multi-Layer Dashboard, new components in Xcelsius charts like Line Chart, Pie Chart, Bar Char, Combination Chart, Container like Tab sets, Selectors like Accordion Menu, Check Box, Combo Box, List box, List view, Single value like Gauge, Slider, Alerts Dynamic Selection, Dynamic Visibility.
  • Tested business objects reports for data validation and compared results and query run time in bank-end i.e.,Teradata SQL Assistant and Business Objects.
  • Worked as Backup for Informatica Administrator and NDM Administrator.

Environment: BI 4.0,Business Objects XI 3.1/R1/R2/R3, Designer XI R1/R2/R3, Teradata, Desktop Intelligence, Sun Active Directory, Business Objects Voyager R2/R3, Dashboard Manager, Performance Manager XI R2/R3, Xcelsius 4.5/2008, Live Office R2/R3, Crystal Reports R2, SSL,Tomcat, Oracle 9i/10g, SQL, PL/SQL, Sun Solaris 5.8/5.10., QAAWS (Query as Web Service)

Confidential

Role, Senior BI Consultant

Confidential is the leading independent specialty pharmaceutical company in the United States focusing primarily on the treatment of dermatological and aesthetic conditions. Confidential is dedicated to helping patients attain a healthy and youthful appearance and self-image. Since our inception in 1988, we have introduced more than 30 new products and formulations, making us a prolific source of new products in the specialties we serve. Today, we have leading branded prescription products in a number of dermatological and aesthetic categories. Confidential products have earned wide acceptance by both physicians and patients due to their clinical effectiveness, high quality and cosmetic elegance.

Role and 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
  • Defined Master data and attributes (Navigational and Display).
  • Created Infoobjects required and assigned.
  • Worked on Bex Excel Reports as per the client specifications
  • Worked on implementing the complex logic for Bex Excel Reports using Excel macros
  • 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.
  • 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.

Confidential

Role, Senior BI Consultant

As one of the world’s leading premium spirits companies, Confidential is Crafting the Spirits that Stir the World. Consumers from all corners of the globe call for the company’s brands, including Jim Confidential Bourbon, Maker's Mark Bourbon, Sauza Tequila, Pinnacle Vodka, Canadian Club Whisky, Courvoisier Cognac, Teacher's Scotch Whisky, Skinnygirl Cocktails, Cruzan Rum, Hornitos Tequila, Knob Creek Bourbon, Laphroaig Scotch Whisky, Kilbeggan Irish Whiskey, Larios Gin, Whisky DYC and DeKuyper Cordials. Confidential is focused on delivering superior performance with its unique combination of scale with agility and a strategy of Creating Famous Brands, Building Winning Markets and Fueling Our Growth. Confidential and its 3,400 passionate associates worldwide generated 2012 sales of $2.5 billion (excluding excise taxes), volume of 38 million 9-liter equivalent cases and some of the industry’s fastest growing innovations.

Role and 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
  • Worked on CRM BI solution and implemented BI reporting for CRM Market Planning
  • Interacted with key users to identify requirements and develop technical specifications.
  • Defined Master data and attributes (Navigational and Display).
  • Created a query "Promotion Sales: Category" which shows promotion sales and promotion quantities in the entire market for the retailer and for the competition.
  • Created a query “Category Role: Retailer” which shows the retailer’s sales taken from scanner data, as well as their sales growth for individual categories in comparison with the market as a whole, their market share in the individual merchandise categories, and the growth index, sales and growth of the market as a whole in the individual categories of the data provider, compared with the previous year.
  • Created a query for price analysis purposes, the query "Average Price: Category" contains a comparison of average prices in the market as a whole, at the retailer and among the competition
  • Created a query "Complete Market Coverage" which provides a comparison of the promotion sales of the retailer with those achieved in the market.
  • Created a query "Market Share/Market Growth: Brand" which shows growth registered by the retailer for the individual categories of the data providers, compared with growth in the market as a whole.
  • Created a query "Sales: Category" provides an analysis of the regional sales for the retailer, the entire market and the competition.
  • Created a query which displays the average basket size in the individual Categories from the data provider.
  • Created a query which displays the target consumer's spend for the individual Categories from the data provider.
  • Created a query which displays the annual spend of all consumers in the individual Categories from the data provider.
  • Created a query which displays the loyalty indexed to the target consumers for the individual Categories from the data provider.
  • Created a query which displays the retailer's sales, taken from the scanner data for the individual Categories from the data provider
  • Created Infoobjects required and assigned.
  • Worked on development of Queries using Filters, Conditions, Exceptions, Restrictions, Calculations in BEx Query Designer and BEx Web Application Designer.

Confidential

Role: Senior BI Consultant

As one of the largest companies in the mobile hydraulics industry, Confidential designs, manufactures and sells a complete range of engineered hydraulic and electronic components including Hydrostatic transmissions, Mobile electronics, Orbital motors, Steering components, PVG spool valves

Role and Responsibilities:

  • Worked on ISU-CCS Billing module reporting in BW and created reports for Unbilled Revenue Reporting and overview of billing runs where the report primarily provides the number of invoicing processes and reversals and the rates
  • Installed the business content for ISU-CCS Billing and extracted the data for bills,invoices, reversals and nets and tax amounts
  • Created Sales Statistics Actual Vs Simulated reports from the custom infoproviders.
  • Worked on Sales Statistics Cube 0UCSA C05 cube and used the datasources 0UC SALES SIMU 01,0UC SALES STATS 02,0UC SALES STATS 01
  • Extracted data using LO Cockpit, CO-PA data sources from SAP R/3 Source Systems.
  • Extensively on Material Management modules (Purchasing and Inventory).
  • Worked on upgrades from BW 3.1 to BW 3.5 to BW 7.x
  • Extensively Worked on Data transfer process(DTP), Data warehousing workbench, DSO’s, remodeling toolbox,tree search,generic search,DSO object structure.
  • Created Complex Start, End routines, Transformations, User Exits and Enhancements.
  • Worked in error handling using error stack,Temporary data storage,Process chain,flexible execution path.
  • Worked on BEx Report Designer,BEx Analyzer, BEx Web Application Designer, Information Broadcasting,Integration Planning, Portal Integration, Application Process Designers (APD’s) .
  • Extensively worked on the Performance Tuning of the System.
  • Implemented Sales & Operational Planning, Product Line Consolidation Reporting, Executive Dashboard Reporting
  • Designed, Developed and Implemented SAP FI-GL,AP,AR and CO-Cost Center Accounting, Internal Orders
  • Demonstrated in-depth understanding of data modeling, extractions, data staging, transformations, reports, design & portal development
  • Worked on Dun and Bradstreet requirements & several conversion projects
  • Implemented APO and supported APO along with BI
  • Worked on Procurement, Master data and Upgrade activities of BI
  • Worked on Currency Conversions and Web development Queries
  • Worked on Information Broadcasting and Reporting Agent
  • Worked on enhancing the data sources and user exit codes in source systems

Confidential

Role, Senior BI Consultant

Confidential is the world’s leading provider of injectable drugs and infusion technologies. Through its broad, integrated portfolio, Confidential is uniquely positioned to Advance Wellnes by improving patient and caregiver safety while reducing healthcare costs. The company is headquartered in Lake Forest, Ill., and has approximately 16,000 employees.

Role and Responsibilities:

  • Desgined, Developed and Implemented End to End FI-GL/AP/AR and Cost Center Accounting, Internal Orders modules in SAP BW
  • Extracted data using LO Cockpit, CO-PA data sources from SAP R/3 Source Systems.
  • Worked on APO – BW implementation and enhancements and worked on improving the performance of reports
  • 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.
  • Involved in Preparation of Global calculation Tool Specifications by analyzing the business for BW.
  • Involved in development of Queries using Filters, Conditions, Exceptions, Restrictions, Calculations in BEx Query Designer and BEx Web Application Designer.
  • Involved in end-user training and Documentation.
  • Extensively worked complete life cycle on SD, MM modules.
  • In SD, have delivered the reports related to Orders, Delivery, Billing, Shipment etc.
  • Involved in Unit Testing, Data Loading, Execute Workbooks, Integration Testing, User Acceptance Test.
  • Extracted data using LO Cockpit, CO-PA data sources from SAP R/3 Source Systems.
  • Extensively on Material Management modules (Purchasing and Inventory).
  • Monitor and Support & Troubleshooting of Existing Data loads by using Process Chains.
  • 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.
  • Administration of BW system.
  • Monitored Daily Chains, Weekly Chains, Monthly Chains.
  • Loading Master data, Transaction data and Hierarchal data into the SAP BW on daily basis.
  • Analyze the errors in the data loads.
  • Activated FI- GL/AP/AR business content (infocubes, ODS and infoobjects) and performed data extraction from R/3.
  • Created Info Packages, Info package groups and Infoproviders (cubes with various aggregate levels and ODS objects).
  • Development of Process Chains for Automated Scheduling of all Data Loading Jobs across different systems.
  • Involved in the Remedy Ticket handling for tickets raised by the users.
  • Performance Tuning of Data Loads.
  • Uploaded master and transactional data from files and SAP as the OLTP source. Worked extensively on administration workbench (RSA1). Customized Info Objects, Info Sources and Info Cubes.
  • Used Open Hub Service(InfoSpoke) to transfer data from InfoProvider to Flat Files.
  • Setup Flat file extraction for data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
  • Used BEx to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures.
  • Modifies layout of the reports and workbooks. Wrote VBA (Visual Basic for Applications) macros to switch between Excel Sheets and format query results.
  • Created Process Chains for the daily batch. Provided 24x7 support in the production environment. Part of the team, responsible for managing the process chains and resolving data load issues on a daily basis.

Confidential, IL

Role: SAP BI Consultant

  • Involved in design, development, and testing and go-live phase of the project.
  • Designed and developed BW data model in SEM BCS system and good expertise in developing SAP BW components like Infoproviders, Infosources, update rules and transfer rules according to the business requirements of the client.
  • Involved in the design and development of the interfaces between SEM BCS (BW based) and SAP BW (separate instance) and also between SEM BCS (BW based) and ECCS systems.
  • Data extraction from R/3 and flat files and scheduled and monitored data loads.
  • Designed and implemented Infohub service for BW.
  • Designed and developed SAP BW finance reports like Balance sheet, etc. according to the client requirements.
  • Developed custom remote function modules to retrieve data from the SEM BCS system to the SAP BW system, which is on a separate instance.
  • Worked on Offshore model and coordinated with the offshore team in delivering the high quality deliverables to the client on time
  • Responsible for development, transport and migration of BW objects across the landscape. Responsible for BW security.
  • Created start routines in ABAP for converting SAP R/3 data into Group Accounts by accessing the custom tables in the Update rules and Transfer rules.
  • Developed Custom function modules to access data from the queries and also developed ABAP programs to trigger the process chains.
  • Responsible for development, transport and maintenance of Master Data. Created process chains for the batch upload of master data

Hire Now