SUMMARY:

• IT Consultant who has 8 years of experience in Leading the large team and dealing with complex assignment, meeting strict deadlines and delivering the perfect solution using tools like SAP - BW/BO, Crystal Reports, HANA, Informatica etc.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Senior Solution Specialist - Team Lead

Confidential

Responsibilities:

• Designing the Replica universe, which was the replication of whole database in universe giving access to 3,000 + tables. Not a wise option but was part of requirement.
• Responsible for Creating the LCMBIAR’s file to Migrate to UAT/PROD Environment.
• Successfully created complex Webi reports including input controls, complex filters, threshold, conditions etc.
• Responsible for designing the Fact table, Aggregates, Dimension table and reference Tables using Informatica Power center 9.5.1
• Responsible for understanding the data setup in base table from various other track and use the logic to populate the reporting tables for required information.
• Used Informatica transformations like lookups, Update Strategy, Filter, Router, Expression, Aggregator, and Joiner etc. for data conversion, data validations, data manipulation and data cleansing.
• Developing 160 + reports using Crystal XI.
• Designing the load for Crystal monthly tables and doing the performance tuning of load to make sure they finish well with in batch window.
• Expert in writing the complex SQL is using Oracle SQL developer as crystal reports are basically designed via Source queries written in SQL.
• Expert in Performance tuning of SQLs Code. Bringing the execution time down from hours to few minutes.
• Extensive knowledge in writing formulas using crystal /Basic syntax.
• Passed the sub report values to the main reports Using Shared Variables in Crystal Reports XI.
• Expert in Using Jira, writing Jira queries, creating dashboard in JIRA and other functionality.
• Experience in Handling the SIT Phase, UAT Phase, GO-Live and Maintenance Phase of the project.
• Responsible for Assigning Defects to developer, updating the Due date, RT Date, UAT Dates, production release etc.
• Responsible for the team to meet the weekly target.
• Tracking the defects and prioritizing the High priority defects leading the standup meeting daily and deciding the daily task for developer.
• Deciding the ETA for any new enhancement, new reports or any defect.
• Educate Client about the defects decide if defects should be classify as cancelled, or helping in setting up the data for testing of the scenario etc.
• Responsible for Educate Client on Business Object gave regular training session to Client.
• Work as Councilor for Solution Developer/Solution Engineer, responsible for representing them in Peers Meeting for Year End rating.
• Responsible for Bi-Weekly Feedback for Confidential Employee in my team.
• Expert in recruitment for Confidential and Contractors for Reporting Team.
• Part of team to organize events for IL - IES Project.

Hana- BW Developer

Confidential

Responsibilities:

• Worked on HANA Studio Rev 51.0
• Required to convert the BW Copa report for Kraft into standalone HANA.
• ECC tables includes COPA ECC and Master data tables are replicated in HANA via BODS, which refreshed with every transaction recorded.
• Analytical view, which act as Cube and Combined View, which act as Multiprovider, was created in Hana. Views act as replica of info provider in SAP - BW
• All formulas at BEx query designers were replicated to HAND at view level or at Webi at BO Level
• Modelling was carried out in HANA, which fetch the data from ECC via BODS, Business Object universe was created on top of HANA View using IDT and Webi reports were created on top of universe.

L3/L2/COE/SAP - BW/BOBJ Developer/Onsite Coordinator

Confidential

Responsibilities:

• This is the Implementation project responsible for creating the BEx Reports, Webi reports on top of SAP - BW.
• Experience in writing the ABAP Program created the many global program, which is published after testing and is used across all landscape.
• Reports like Order Fill Rate, National Daily Sales, Fill Rate Primary Distribution, Transport Load efficiency, GTMs reports were created based upon Flow like Sales Overview, Shipment, Purchasing, Open Order Copa, and GTM etc.
• Analyzed the needs of the business and developed the BICS connections, Webi report based on it.
• Handling Admin activities for the client like CMC management, creating and managing security roles, migrating objects from dev. to quality to production, Webi reports after migrations.
• Worked on preparing test cases for testing team during UAT.
• Rule Groups and Condition formatting was done to show the KPI with down Arrow in Red in case the KPI is less that target or UP Arrow in Green if KPI is more than the target.
• Hiding the table according to input control e.g. if input control for product line is selected then the report having table related to zone, profit center will be hidden. This was done with the help of formula in table properties.
• Functional Spec document was created with help of continuous requirement gathering session with client.
• Responsible for supporting the Go-Live activities.
• Measured were taken to improve the performance of reports in Unit testing and UAT by creating the aggregates, changing the BEx properties,RSRT Properties to make the report run fast in Webi. Enabling the Query stripping etc.
• Numbers of Enhancement in Existing Logistics data sources were carried out as part of deliverables in ECC. Coding for filling the enhance fields were done in ECC in best performance manner.
• Exception aggregation was carried out in Webi and the exceptions like #Syntax, #Div0 error was handled in Webi.
• Interactive Charts, Graph and tables were created which change/act according to the value of input control selected by user.
• Spanish translation was carried out for all reports via use of formulas.
• Have work on hyperlinks on moving from one report to another report in Webi via passing prompts.
• Witten Customer exits code for Query Execution.
• New Process chains were created as part of new implementation.Work as L2 for supporting the client in EU & Ireland clients.
• Provided the support for handling the issues related to SAP - BW Production system.
• Handle tickets related to ABAP, expertise in ABAP code writing.
• Responsible to assign the ticket among team and working closely with team to get the ticket close at the earliest.
• Work on various change/Enhancement requests which includes the creation of new reports and backend development.
• Interacting with Business user to gather the business requirements for change request.
• Involve in creation of Change request form and technical form, which is required by L3 personnel to work.
• Housekeeping activities: It includes Report SAP INFOCUBE DESIGN, PSA deletion, Change log deletion, DTP Temporary storage, RSRV checks, Archiving/Deletion of IDOC tables, Application log tables etc.
• Extensively worked upon customer exit and routines.
• Created complete flow includes BEx Queries, Info Provider, and Data Sources etc.
• Supporting day-to- day data load monitoring activity and correct the error if at all occur in data loading.
• Experience in Aggregates, Compression and partition to improve performance in BW
• Good understanding of Open Hub Destination and APD.
• SPOC for any issue in the geography that I am catering to in BI system support.
• Continue RCA and proposed solution if any error occurs in process chain.
• Got appreciations from Business user and Client for managing the completely BI system efficiently.
• Introduce the Broadcast monitoring tool, which will send the mail to recipients whenever the error occurs in broadcasting.
• Involved in creation of Info Area, Info Objects, and Info Object catalogue, DSO, Info Cube and Multi Provider and created the required transformation and DTP to load the data into object.
• Involved in enhancement of data source using Function module.
• Appended the fields to extractor in its enhancement and written code to fill the appended fields.