Associate Consultant Designer
Resume:
Ayushi Chitlangia
SAP BW/BI
******.**********@*****.***
PROFESSIONAL EXPERIENCE:
Having 9 years of industry experience in analysis, design, development, documentation, production support and implementation of software applications in Configuration & implementation of SAP BW/BI.
Extensive expertise in analyzing, developing, and delivering high-visibility projects in manufacturing, supply chain management (SCM), banking sector etc.
Worked on various releases of SAP BW/BI.
Experience in creating queries and generating Reports Using BEX Analyzer, Web Application Designing (W.A.D), BEX Broadcaster.
Strong experience in End-to-End BW Configurations and Customizations, which includes Extraction, Transformation, loading (ETL), Staging, Maintenance, Transports, and Reporting.
Expertise in OLTP extractions from SAP R/3 using LO Cockpit, CO-PA, FI GL, AR, AP, Generic Extractions, and extracted data from the flat files
Experience in extracting data from Logistics (SD, MM), FI/CO, HR, Generic Data Sources and Flat File.
Design and develop Datasources (generic, enhanced and custom) for extracting and staging data from SAP and non-SAP source systems.
Proficient in Creating, Loading, Scheduling and Monitoring of InfoCubes, Operational Data Store (ODS) / DSO, PSA, InfoObjects.
Resolved critical Load errors at Persistant Storing Area (PSA) and ODS staging areas.
Designed and implementing variables and workbooks.
Web Reporting - Developed web reports, customized web templates using web application designer (WAD) and query designer
Activation & Installation of Business Content Objects for FI/CO, MM, SD modules.
Proficiency in developing Process Chains, User Exits and Enhancements.
Well acquainted with System Analysis, Design, documenting, Programming, Testing and support, all phases of Software Development Life Cycle (SDLC) also closely involved with Coordination, Implementation, System testing, Acceptance and Integration testing
Strong interpersonal, communication, leadership skills and aptitude towards learning new technologies
Ability to contribute and be a productive team member and motivated to take independent responsibility.
SKILLS:
SAP Business Intelligence Tools: SAP BI/BW (7.4,7.3, 7.0, 3.5, 3.1C), BEx Query Designer, BEx Analyzer, BEx Web Application Designer, Bex Broadcaster, Web Intelligence.
Functional Modules: SD, General Ledger Accounting, Account Payable and Accounts Receivable, MM, HR.
Prog Languages: ABAP.
Databases: Oracle, DB2, MS Access.
Reporting Tools: BEx Analyzer, Web Reporting, MS Excel, Business Objects.
Application Servers: WebSphere, WebLogic Server.
Operating Systems: Windows 95, 98, 2000, XP,10,11.
TECHNICAL CERTIFICATIONS AND TRAINING:
SAP BW 7.5 Powered by HANA
SAP CERTIFIED Application Associate – Introduction to SAP BI/BW.
IBM CERTIFIED Rational Software.
IBM CERTIFIED TIVOLI Program.
FRENCH Delf A1 CERTIFIED from Alliance de Francies
EDUCATIONAL QUALIFICATION:
B.E in Information Technology Engineering from S.V.I.T.S Rajiv Gandhi University, Indore, India with FIRST class.
AWARDS/ACHIEVEMENTS:
“STAR PERFORMER AWARD” BY IBM INDIA.
“FEATHER IN MY CAP AWARD” BY WIPRO TECH. INDIA.
REPRESENTED CAPGEMINI IN “CMMI LEVEL 5” CERTIFICATION.
EXPERIENCE:
SAP BW 7.5 Powered by HANA- 2022 Certification May’22
IBM INDIA PVT. LTD - India May’13 to April’16
Project Name- Close Brothers Group (Banking)
Senior SAP BI Consultant (Team lead- Awarded as STAR PERFORMER)
Period- April 2014 to April 2016.
Description: Close Brothers Group plc is a British Merchant bank, with revenues at 309 million pounds. It operates through three divisions, Banking, Securities and Asset Management, and its clients include small and medium sized companies, individuals and financial institutions. Close Brothers was established in 1878, is listed on the London Stock Exchange and is a constituent of the FTSE 250.
Responsibilities:
Conducted extensive requirement gathering workshops with the users in the Finance areas particularly for Banking Sector.
Conducted gap analysis processes to understand client requirements and best practices.
Expertise in implementing Complete Life-Cycle Implementation of SAP BW/BI which dealt with Blue Print, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up-loads), Scheduling, Monitoring, support packs implementation, BEx Analyzer, Query Designer, Web Applications Designer, Testing, Go Live & Production support, End user documentation.
Extensively worked on FI-GL, LO Cockpit, Generic Data Source, DB Connect customization and extraction.
Solid experience in construction of customized Info Objects, Basis Info Cubes, Multi Providers, Info sets, ODS/DSO objects, and Advanced DSO.
Expertise in Transformations, DTPs, Update rules. Transfer Rules, Hierarchies, Routines, and Process Chains.
Expertise in BW performance tuning by maintaining aggregates, compression, partition, process chains, indexing of info cubes and use of statistics for the same. Extensively used variety of techniques to boost the performance of BEx query.
Expertise in creating designs of custom extractors for modules like SD, MM, HR, PM and FICO using ABAP.
Coordinated extensively on all aspects of user administration, client copy functionality, R/3 installation/kernel upgrade, performance analysis.
Involved in SAP R/3 and BW release maintenance, system refreshes, client-copies & upgrades.
Advanced Knowledge and experience working with Microsoft Excel and PowerPoint.
Expertise in ETL techniques and proficient in loading techniques such as Full load, Delta load and also in data modeling.
Expertise in BEx Analyzer, Web Application Designer, Info-Set queries. Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures. Expertise in publishing queries to web portals through Web Analyzer.
Suggested processes for improvement of current data structures and custom data sources.
Creation of all necessary BW objects and complex queries to obtain the data from other Legacy systems into BI.
Analyzed production Reports and improved performance.
Had strong experience in creating reports using WebI over BEx queries.
Experience on process chain automation and daily data load.
Designed process chains for scheduled loads and enabled batch processing for various administration activities in BW system.
High interaction with SMEs and users all through life cycle implementation.
Actively involved in different phases of the project life cycle includes requirements
gathering from individual sessions and during workshops.
Worked as a Functional Analyst as per the user demand and met the business needs as and when required and actively involved in gathering requirements from legacy system and writing functional specification documents and Unit test plan and test cases.
Fully configured all Supply configurations including any necessary BW configuration.
Developed technical specifications to enable custom code to support necessary customer requirements gaps.
Experience with BW performance tuning/optimization and understanding of IT Service Management framework.
Developed the functional and technical design documents for all the modules.
Design, code, debug, test and support ABAP applications that are key components of Army.
Experience in Start/End Routine ABAP developments for calculating different KPI’s.
Performed ABAP debugging & coding for complicated ABAP programs.
Worked independently and resolved many complicated issues during the unit testing and production issues.
Involved in Monitoring the Process Chains like daily, weekly and monthly loads.
Monitoring of Process Chains and analyzing the reasons for frequent failures of Process Chains.
Helped the co-workers to resolve the BI Configuration issues, Process chains and ABAP related issues.
Providing recommendation to user community and other developers on creating better and faster Adhoc and standard reports.
Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report in Finance, PM and Supply Modules.
Project Name- Krafts Foods
Senior SAP BI Consultant
Period- Jun 2013 to April 2014.
Description: KRAFT FOODS is one of the biggest Consumer Products companies in the World manufacturing leading Brands of Biscuits, Confectionaries, Coffee and other Food Products. IBM is the sole Service Provider in the SAP area. IBM provides 24x7 SAP Support for Kraft Foods in Europe and Middle East. Support provided for the following SAP modules via Customer Support and Logistics, Finance, Procurement, Production & Quality. Support done in 100 % Stringent SLA Mode with Penalty Clause. Hence Deliverables are extremely important. This proves the KRAFT'S reliability on the IBM and IBM's reliability on the support team.
Responsibilities:
Conducted gap analysis processes to understand client requirements and best practices.
Expertise in implementing Complete Life-Cycle Implementation of SAP BW/BI which dealt with Blueprint, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up-loads), Scheduling, Monitoring, support packs implementation, BEx Analyzer, Query Designer, Web Applications Designer, Testing, Go Live & Production support, End user documentation.
Solid experience in construction of customized Info Objects, Info Cubes, Multi Providers, Info sets, ODS/DSO objects.
Expertise in Transformations, DTPs, Update rules. Transfer Rules, Hierarchies, Routines, and Process Chains.
Expertise in BW performance tuning by maintaining aggregates, compression, partition, process chains, indexing of info cubes and use of statistics for the same. Extensively used variety of techniques to boost the performance of BEx query.
Coordinated extensively on all aspects of user administration, client copy functionality, R/3 installation/kernel upgrade, performance analysis.
Expertise in ETL techniques and proficient in loading techniques such as Full load, Delta load and in data modeling.
Expertise in BEx Analyzer, Web Application Designer, Info-Set queries. Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures. Expertise in publishing queries to web portals through Web Analyzer.
Suggested processes for improvement of current data structures and custom data sources.
Had strong experience in creating reports using WebI over BEx queries.
Experience on process chain automation and daily data load.
Designed process chains for scheduled loads and enabled batch processing for various administration activities in BW system.
High interaction with SMEs and users all through life cycle implementation.
Actively involved in different phases of the project life cycle includes requirements
gathering from individual sessions and during workshops.
Worked as a Functional Analyst as per the user demand and met the business needs as and when required and actively involved in gathering requirements from legacy system and writing functional specification documents and Unit test plan and test cases.
Fully configured all Supply configurations including any necessary BW configuration.
Developed technical specifications to enable custom code to support necessary customer requirements gaps.
Experience with BW performance tuning/optimization and understanding of IT Service Management framework.
Developed the functional and technical design documents for all the modules.
Experience in Start/End Routine ABAP developments for calculating different KPI’s.
Performed ABAP debugging & coding for complicated ABAP programs.
Worked independently and resolved many complicated issues during the unit testing and production issues.
Involved in Monitoring the Process Chains like daily, weekly, and monthly loads.
Monitoring of Process Chains and analyzing the reasons for frequent failures of Process Chains.
Helped the co-workers to resolve the BI Configuration issues, Process chains and ABAP related issues.
Providing recommendations to user community and other developers on creating better and faster Adhoc and standard reports.
Created complex reports using multiple data providers and synchronized the data providers by linking the common objects to create the common report in Finance, PM and Supply Modules.
Wipro Technologies, India June’09 – April’13
SAP BI Consultant
Project Name- Thames Water
Period- Dec-2012 to April2013.
Description: Thames Water is UK’s largest water and waste water services provider with operation and maintenance of 100 water treatment work, 30 raw water reservoirs, 288 pumping stations, and 235 clean water service reservoirs.
Responsibilities:
Conducted extensive requirement gathering workshops with the users.
Part of the WAMI BI Team, responsible for Resolving tickets (SR/Incidents) and developing CR’S.
Handling the tickets of priority 1, 2, 3 and 4 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
Involved in developing Change Requests with major developments in FI module.
Maintaining G/L account reconciliations to verify the data in R/3 and SAP BI are same or not after the data loads.
Involved in month end activities like Information Broadcasting of 32 reports, Scheduling of month end data loads and its reconciliation.
Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
Involved in BO health checks.
Actively involved in different phases of the project life cycle.
Automated data load processes, maintained BW statistics, did roll up of BW aggregates using process chain.
Involved in managing of InfoCubes, Info Object maintenance, ODS Objects, PSA, Info Source, Data source, Communication Structure, Transfer Structure, Update rules, Transfer rules, Info Packages
Experience in Start/End Routine ABAP developments for calculating different KPI’s.
Experience with (BEx) Analyzer using portal integration.
Developed scheduling mechanism by creating Process Chains for Initialization and delta runs and for Master Data loads for master data objects.
Project Name- Southern Water
Period- Jan-2010 to Oct 2011
Description: This UK-based utility provides water supply and wastewater treatment services across Kent, East and West Sussex, Hampshire and the Isle of Wight. Southern Water is responsible for delivering clean, fresh water to around one million households in the South East of England. Southern Water also treats and recycles dirty water from nearly two million households.
Responsibilities:
Part of the BAS BI Team, responsible for Resolving tickets (SR/Incidents) and developing CR’S.
Conducted extensive training for Southern Water folks in BEx Analyzer so as to make complete understanding of playing with various reports.
Involved in Knowledge Transfer on Offshore to understand the data flow from ECC/ SRM / Ellipse to BI server and helped the new joiners understand the flow.
Actively involved in different phases of the project life cycle.
Designed loading strategies for master data, initial load of transactional data and delta loading of both master data and transactional data.
Involved in managing of InfoCubes, Info Object maintenance, ODS Objects, PSA, Info Source, Data source, Communication Structure, Transfer Structure, Update rules, Transfer rules, Info Packages
Handled the tickets of priority 1, 2, 3 and 4 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
Involved in developing Change Requests with major developments in FI module.
Maintaining Reconciliation’s to verify the data in R/3 and SAP BI are same or not after the data loads
Created queries such as Sales by Hierarchy, Orders by country and region
Implemented Business content for Inventory Management (IM) Cubes and enhanced with customer requirements such as Product hierarchy using Logistics (LO) cockpit
Developed Logistics data models, delivered Key Performance Indicators (KPIs), BEx reports and Information Broadcasting of reports, completed User Acceptance Testing and detailed production cutover plan.
Experience with (BEx) Analyzer using portal integration.
Developed scheduling mechanism by creating Process Chains for Initialization and delta runs and for Master Data loads for master data objects.
Created workbooks for both cubes and Transported to Production System.
Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition.
Created indexes for info Cubes and also for aggregates.
Generated and Maintained Aggregates. Performed delta update (ROLLUP) in Aggregates
Provided production support for day to day data load monitoring, reporting and maintained documentation.
Configure MultiProviders to combine physical or virtual info providers to make data accessible for reports and analysis.
Defined Calculated Key Figures (CKFs), Restricted Key Figures (RKFs) and Formula Variables for custom reports using Query Designer.
Extensively used the R/3 extraction user exits to populate the values for the master & transaction data.
Designed and developed web reports using Web Application Designer (WAD) and exported Business Explorer (BEx) reports to web pages.
Created test scenarios and created test documents for unit testing, system testing and integration testing.
Project Name- National Grid
Period- July 2009 to Dec 2009
Description- National Grid is international electricity and Gas Company and one of the largest investor-owned energy companies in the world. NG plays a vital role in providing energy to millions of customers across Great Britain and the Northeast US in an efficient, reliable and safe manner. National Grid is committed to working responsibly in the communities where it operates and playing its role in safeguarding the global environment for the future. These are long-term responsibilities that must be fulfilled in conjunction with our duty to create value for our shareholders. Delivering sustainable value depends on the trust and confidence of all of our stakeholders, and this can only be earned by conducting our business responsibly.
Responsibilities:
Part of SAP BI Team and responsible for implementing Data Modelling.
Implementing Data Loading.
Generating Reports for the Supply chain Management modules.
Transportation of BI-Objects.
Receiving Signoffs.
Involved in Unit testing, System testing and debugging.
Created communication structure, transfer rules and update rules.
Performed extraction from multiple source systems including ECC and flat files.
Worked in ABAP routines in data mapping, start routine and individual calculations.
Created queries, filters, exceptions, conditions, restricted key figures and structures.
Developed complex reports with BEX analyzer.
Worked extensively on BEX query designer, developed flexible queries using filters, navigational attributes, Virtual Key Figures in BEX analyzer to facilitate data analysis in a drill down or summarized way to give details levels of information.
Worked on HR Reports like, Salary Distribution, Employee related reports.
CAPGEMINI, India July’07 to April’09
Project Name- Alcatel-Lucent (Maintenance and Support)
SAP BI Associate Consultant
Period- July 2008 to April 2009.
Description- Alcatel provides communications solutions to telecommunication carriers, Internet service providers and enterprises for delivery of voice, data and video applications to their customers or employees. Alcatel brings its leading position in fixed and mobile broadband networks, applications and services, to help its partners and customers build a user centric broadband world. With sales of EURO 13.1 billion and 58,000 employees in 2005, Alcatel operates in more than 130 countries.
Responsibilities:
Part of the Marketing and Sales Team, responsible for Resolving tickets (SR/DR) and also developing ER’S.
Handled the tickets of priority 1, 2 and 3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
Supported the client by providing long-term solutions to the tickets by doing Root Cause Analysis.
Involved in Knowledge Transfer on Offshore to understand the data flow from Siebel to BW server and helped the new joiners understand the flow.
Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
Monitoring of job stream in both preproduction and production environments
Maintaining Reconciliation’s to verify the data in Oracle and SAP BW are same or not after the data loads.
Communicating with the key users for validation of tickets Involved in training new people in BW/BI so as to serve the project as a full-time billable resource.
Involved in developing Enhancement Requests with major developments.
Project Name- Tom-Tom
SAP BI Associate Consultant (Represented in CMMI level5 Certification)
Period- Nov 2007 to May 2008.
Description- TomTom NV is a Dutch manufacturer of automotive navigation systems, including both stand-alone units and software for personal digital assistants and mobile telephones. It is the leading manufacturer of navigation systems in Europe with worldwide offices in Amsterdam, London, Massachusetts, and Taiwan. The global slogan for TomTom is "the smart choice in personal navigation". In the United States and Canada, they currently use "Go confidently".
Responsibilities:
Part of the team responsible for developing and implementing the technical design, Unit Test Plans, Unit Test Reviews, and Analyzing & Resolving Issues in the FD’s received from Onshore and was responsible for receiving Signoffs and Played an important role in Client Interfacing. As a Developer of the offshore technical team, she was responsible for the Implementation of:
Implementing Data Modelling
Implementing Data Loading
Implementing ABAP Coding for User-Exits, Enhancements & Update Routines
Transportation of BI-Objects
Receiving Signoffs.
Client Interfacing
Generating Web Templates in WAD
Contact this candidate