WGL is a diversified energy business that provides natural gas, electricity, green power, carbon reduction and energy services and natural gas exploration, production, and storage though its subsidiaries, including Washington Gas, Washington Energy Services, WGL Midstream, and Hampshire Gas..

Responsibilities:

·         Data Modelling and Designing the around 100 reports in BW 7.4 using Composite Provider.

·         Understanding the Functional Requirement Specification given by user and developing & designing Modelling related to the respective area

·         Installation of Business Content

·         Handling the Team and guiding them for using right SAP recommend modelling procedure ,

BW objects Naming Conventions , Technical Specification , Unit Testing documents

Modelling  on Planning Application  - Integrated planning / BPC

Planning Applications

·         Worked on  BW-IP and PAK ,Setting up planning structures with the ABAP Planning Modeler

·         Modelling, setting up and Testing planning functions via Planning Sequences,Configuring input ready queries with the BEx Query Designer

·         Worked on  planning queries, Locking of Transaction Data

Creating an Analysis Office Workbook for Planning

·         Creating  Design Studio Web Application for Planning

·         Working with Characteristic Relationship concepts

·         Using Aggregation and Disaggregation in Planning Scenarios

·         Setting up Advanced Planning Functions like FOX, ABAP and SQL- Script

·         Introducing Inverse Formulas

Business Planning & Consolidation

·         Excel Interface of the EPM add-in ,Implementing Consolidation Projects,Using the IFRS Starter Kit,Setting up the Environment and Master Data,Creating Models for Consolidation,

Creating Consolidation Logic

·         Importing Flat File and InfoCube Data ,Configuring Balance Carry forward ,Reclassifying Data

Using Consolidation Central,Setting up Journals,Translating Local Currency,

·         Reviewing Ownership Terms and Concepts ,Using the Ownership Manager,Eliminating Ownership - Purchase Method

·         Equity and Proportional Methods,Matching Intercompany,Eliminating Intercompany AP AR,Setting up Intercompany (US) Elimination,Using the Controls Monitor and Validating Data

·         Creating Consolidation Business Process Flows

Dr Pepper Snapple Group Inc. (formerly Cadbury Schweppes Americas Beverages) is an American soft drink company, based in Plano, Texas.

Responsibilities:

·         Process Chains  , Dataload Monitoring  and Issue resolutions.

·         Working on Tickets and Work orders  , New Enhancement on existing reports .

·         Estimating the new development requirements in SAP BW/BI implementation by analyzing Functional specification / BRD documents and working closely with Onsite team members for future developments in SAP BW/BI.

·         Writing ABAP routines like Lookup ,start routines,End routine ,Expert Routine, Transformation infoobject level routine , DTP Filter routines,  Customer Exit Variable coding,  and customizing data sources etc in the BI system

Performance Tuning    

·         Responsible for performance and Tuning – Dataload performance and Report running performance

·         Remodelling the design for improvement of dataload and report performance

·         Managing the performance (related activities like aggregation, compression, indexing-BI accelerator,) and data load monitoring activities

·         Resolved highly critical and sensitive bugs ( Work orders ) in application raised by users in production environment .Tested it on QA system and delivered in production system on time

·         Delivered enhancements, tickets as per the customer requirements and completed the development within defined time frame with high quality deliverable and running performance. To ensure the deliverables those are assigned to me are within the scope and deployed defect free and also ensure zero customer complaints.

HANA Implementation

·         Interacted with Senior executive of client companies to define functional & technical specifications

·         Worked on  Migration of SAP BW and/or SAP Business Suite Component on HANA

·         Developed Attribute View, Analytic View, and Calculation View as per the requirement of Reports. SAP HANA programming including SQL, SQL Script, Procedures and CE Script.
SAP HANA Security including User Management, Roles, and Privileges

·         Worked on join of the tables and have extensive understanding of differences between Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Text Join and referential Join when connecting tables

·         Created Variables and applied them as filters and also worked on various input parameters
Ability to work on currency conversion in analytical views.
Worked on SAP HANA Modelling, managing schemas, data model objects, import/export content and Data provisioning using SLT Replication server.

Responsibilities:

·         Estimating the new development requirements in SAP BW/BI implementation by analyzing Functional specification / High Level design documents and working closely with Onsite team members for future developments in SAP BW/BI.

·         Responsible for new developments like creating / modifying BW 7.0/ BI 7.3 objects like InfoCubes / ODS / InfoSource / Info Objects / Data Sources / InfoSets / Queries / Bex Reports / Web Templates / Process chains etc.

·         Designing and Migration of Dataflow from BI 7.0 to BI 7.3   .

·         Writing ABAP routines like Lookup ,start routines,End routine ,Expert Routine, Transformation infoobject level routine , DTP Filter routines,  Customer Exit Variable coding,  and customizing data sources etc in the BI system

Performance Tuning    

·         Responsible for performance and Tuning – Dataload performance and Report running performance

·         Remodelling the design for improvement of dataload and report performance

·         Managing the performance (related activities like aggregation, compression, indexing-BI accelerator,) and data load monitoring activities

Design & Datamodelling  -

Extensive worked on developing the design of bi data modelling   as per the requirement of reports   .

Customer exit modularization – Analysis the  system risk management  and maintaining the proper  transport reliability , worked on splitting the customer exit variable Z*  to  separate Classes and  Function Modules , this activity make the system risk  free .

KPI Report - Involve in development, design and delivery of KPI Report, Individual Employee Performance, monthly Issue receive and Issue resolved  the report is used for AXA Management to check the individual contribution to project  through various team .

Business Object   -

·         Extensive work on designing the schema as the requirement  , Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops,fan traps, chasm traps in Universes using Table aliases and contexts with OLAP and OLTP connection.

·         Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.

·         Performed unit testing, system integration testing, and user acceptance testing of Web Intelligence/Desktop Intelligence Reports at various levels.

·         Extensive experience in creating reports with Charts (bar chart, Pie chart…etc),Slice and Dice, drill down, drill by, drill through, cross tab and Master-Detail and Sub reports

Reports : ISH- Health Care

·         Developed Generic Delta extractor more than 130 .

·         Data Modeling and Architecture design of Healthcare project

·         Dev of BI reporting in  Patient management ,Clinical Services area Registration and Admission , Finance , Nursing , Emergency Medical Services , Scheduling.

·         Process Chain and Daily Dataload check in support.

Leading the development, configuration and support of reporting solutions, primarily using the SAP Business Information Warehouse (BI/BW) Application.
Working from functional/business requirements to design and develop data sources (installing standard data sources to enhance existing data sources and create custom data sources).

Development of Generic delta extractors

Working from functional/business requirements to design and develop BW objects (installation of standard objects, enhance existing objects and create custom objects) like info objects, business content, info sources, data targets, transfer rules, update rules, etc.
Documenting testing plans and complete Unit Testing of developed objects and reports.
Working with Quality Assurance business resources to complete System and Integration Testing.
Analyzing and communicate report development issues, including problems with data integrity, data design, and functional and technical software issues.
Delivering work within tight deadlines and consulting on business issues to offer lasting value to clients as part of ongoing engagements.

Bussiness Object

·         Worked extensively in leading, developing and implementing report solutions on Business Objects XI Release II, Crystal Reports Server XI, Crystal Enterprise 10/9/8.5, Web Intelligence XI, Desktop Intelligence, Business Objects Universe Designer, Crystal Reports Explorer.

·         Worked on designing dashboards against different data sources using XCelsius 2008

·         Integrated XCelsius into Crystal reports 2008 using XML, Excel and flash variables.

·         Expertise in designing Universe from scratch, migrating to different environments, designing WebI documents and maintaining them on Business Objects XI R2 SP3.

·         Installed and configured Business Objects XI Rel II on Win 2003 Server, Red Hat Linux.

·         Evaluated usage of Crystal XCelcius, Live Office for adhoc reporting.

·         Designed multi server architecture for Business Objects XI R2 Enterprise for more than 10000 concurrent users.

·         Involved in all phases of migration from Crystal Enterprise 10 to XI R2.

·         Involved in designing Universe and migrating existing adhoc ‘Crystal Reports Explorer 11’ to WebI

·         Involved in creating the SRS/BRS for ‘Master Reports Suite’ which included enhancements to existing adhoc product.

·         Currently leading team on multiple projects like Migration of Crystal 10 to Business Objects XI Release 2, Million Dollar Tracking System,  Performance Shares ( Equity related project ).

·         Headed the team of Crystal Reports Developers, developed the reports as well as got them done by team on time for the releases.

·         Designed and documented the multi server architecture of Crystal Enterprise 9/10.

·         Configured and Standardized the APS Cluster environment in Crystal Enterprise.

Executing the entire operations on AWB (RSA1).
Thoroughly analyzing the MDM & Extended Star Schema and configuring.
Creating standards Info Source for master data and transaction data for SD application and Activated: Taking the entire data from SAP R/3 and flat file into the SAP BW.
Extracting the transaction data from Locockpit, R/3 to BW, maintaining the extract structures sources & replicating the data Sources into BW.
Entrusted with the responsibility of customizing and activating the business content objects and loading the data into ODS Object and Info Cubes.
Using BW Scheduler to load data into Info Cube, and ODS to Monitor the status of the data loads: creating ODS update rules and info package to load data & installed Business Content.
Determining Aggregates to Improve system query performance
Handling the tickets of various complaints as per the priority.

SAP CIN Patches Implementation for upgrading the system .

Whole Technical Developments Reports , Smartforms , Sap scripts , BDC ,LSMW .

I was involve in designing and development of following HR activies :

Development  Reporting, Sap script, Smart Forms ,Module pools programmig

Invoice printing   - Commercial  Invoice   & Excise Invoice

Developed :  General  Excise Invoice ,

Are1 Invoice  ,

Are3  Invoice ,

                           Trading Invoice for different plant  

FI Check printing- Development Check printing program for  payment to vendor .

Uses Logical database 'PNP'(entered in program attributes) to retrieve various personnel data and download it to an excel / tab delimited file.

HR Report to list all logged changes in infotype data for an employee. Uses the PCL4 Audit Cluster.

Permanent Loan Register Application

Excise Register  including zj1id/zj1iex

This application used in store department for issuing tool ,and other material and getting back       from them  this application maintain data for issueing and deposit of goods

Planning Dashboard – This screen has been developed to display and allocate & de allocate the coils, Club & De club the Production order and display chemistry & History reports. Also  updating  various Tables through Transaction using BDC.  Output screen contains two ALV container.

Production Confirmation – This screen has been developed for the confirmation of production orders, goods     movement and entering the process parameters. This screen contains various process like Jointing ,Annealing ,Rolling ,Skin Pass ,Grinding ,Slitting ,Cut to Length , Voss Leveler. Also  updating  various Tables through Transaction using BDC.  Output screen contains two ALV container.

Tool Management – This screen has been developed  to maintain the status and history of the Punches and Die Plates that are used in Coil Blanking Line. Here we maintain the Punches and Die plates and their Grinding status and time.

BDC:    BDC program to upload customer master data from legacy system to R/3 System.

BDC program to upload Purchase Order details from legacy system to R/3 System.

Scripts:

Made use of SAP Standard Report Program RSTXLDMC to upload TIFF (For logo) and display as Standard text.

Making Sap script for Material Discrepancy report using table MKPF , MSEG .

Making Sap script Vendor Payment Advice of FI module using table BKPF BSAD BSEG .

Sap script for Sale tax certificate of contractor –FORM-XIA  using table RBKP .

LSMW :  

Vendor Master Data updating from tcode FK02 –withtax holding Account

Updating   the field of with tax type, withtaxcd, Restyle.  Writing ABAP Code.

Customer Master updating from Tcode -XD02 updating customer

Sales organization, distribution channel ,division , delivery priority, Shipping condition ,delivery plant .

Enhancement:-

User-Exit ME23N  making assignment type P-project for plant company code -JSLO

Customer enhancement (CONFPP05)we can update our own data once we   have saved the confirmation(Function Exit  EXIT_SAPLCORF_105).

Customer enhancement (MBCF0002) includes a function module that is called up when

we enter a goods movement for each item(Function Exit  EXIT_SAPMM07M_001).

system  and taking their output at their own center, therefore EDI providing excellent  movement of data between two partner.

The main objective of the project was to have a common IT system that supports an efficient purchasing process. The project was initiated due to inflexible legacy systems with more custom interfaces, non integrated processes and also due to proprietary data warehousing software that complicated data analytics with more custom built reports