PROFESSIONAL SUMMARY:

• Having 10+ years of total IT experience with 2 years of experience in Robotic Process Automation (AUTOMATION ANYWHERE) and 8 years of experience in SAP BI/ABAP/HANA.
• Expertise in design and development of software robots using Automation Anywhere tool.
• Experienced in analyzing & Robotics automation development and also be a part of requirement gathering, application design and development, documentation, testing and deployment.
• Expertise in using Commands like Clipboard, Comment, database, delay, Email Automation, Error handling, Files/Folders, If/Else, Image Recognition, Insert keystrokes, Insert Mouse click, Insert Mouse move, Insert Mouse Scroll, Launch Website, Log to File, Loop, Manage Window Controls, Message box, Object Cloning, OCR, PDF Integration, PGP, Prompt, Read from CSV/Text, Rest Web Service, String Operations, XML, Wait, Variable operation, Window Action, Excel, Launch, Web Recorder.
• Expertise in automating Web applications, Citrix applications, window applications.
• Expertise in Automating SAP Finance applications in S/4 Hana, Mainframe.
• Good Understanding on Account Receivables (A/R), Account Payables (A/P).
• Expertise into SAP BI/SAP BW/SAP - HANA Modeler/BW on HANA/ABAP/S4 Hana.
• High Expertise in Designing Info Cubes, ODS, Symantec Portioned objects(SPO Cubes, DSO's) Info objects, Multi providers, info set, Transformations, Info sources, Transfer Structures, Transfer rules, Update Rules, Communication Structures, Info package, DTP, Activating Data sources, deleting and Filling setup tables, business content installation, BI Accelerator.
• Expertise in writing ABAP Code for Start Routine, End Routine, Expert Routine, Field Level Routine, customer Exits, Function Modules, Programs.
• Expertise in designing BW models in HANA eclipse environment.
• Expertise in Creating Transient provider, Composite Provider, Open ODS View, Advanced DSO, Virtual Cube, Virtual Info object and consuming the HANA Models in to BI.
• Expertise in designing APD (Analysis Process and Design), OHD (Open Hub Destination), Data Archiving using NLS (Near Line Storage).
• Expertise in Extraction (Generic Extractions, Flat file, LIS Extraction, LO Cockpit, COPA).
• Worked extensively in Front-end Business Warehouse Components like BeX Analyzer in building Queries by creating calculated key figures, restricted key figures, Variables, structures, Formulas, Exceptions, Conditions.

PROFESSIONAL EXPERIENCE:

Confidential

RPA Technical Lead

Responsibilities:

• Responsible for delivering the quality design solutions by applying the modular techniques which will improve the performance of the design within the time line.
• Involved in Requirement Gathering, Analysis, design and development of software robots using Automation Anywhere tool.
• Develop Detail As Is Process Description - PDD (Process Description Document), Detail To Be Automated Process Description - SDD (Solution Design Document).
• Involved in SDLC, design and development of software robots using Automation Anywhere tool.
• Automated SAP & Mainframes applications.
• Involved in Business Logic implementation / coding as per the design specifications.
• Automated the process of Account creation and automated the process of sending the mails to the customer once finished.
• Based on the input excel sheet provided by the client, created database connection on the excel sheet and connected to it.
• Read the data from the database using select statement and loop it and updated the database with required information.
• Automated using different commands like Image Recognition, Window, Insert keystrokes, object cloning, Variable operations, If/Else, Excel, loop Commands.
• Involved in unit testing and Bug Fixes.
• Involved in Design Task boat based on Business requirements.
• Involved in debugging the task once the development is completed to test whether the task is working correctly.
• Automated the input excel sheet by updating the columns with different status.
• Automated the process by sending the mail to the clients.

Confidential

RPA Technical Lead

Responsibilities:

• Responsible for delivering the quality design solutions by applying the modular techniques which will improve the performance of the design within the time line.
• Involved in Requirement Gathering, Analysis, design and development of software robots using Automation Anywhere tool.
• Develop Detail As Is Process Description - PDD (Process Description Document), Detail To Be Automated Process Description - SDD (Solution Design Document).
• Involved in design and development of software robots using Automation Anywhere tool.
• Automated mainframes applications.
• Involved in Business Logic implementation / coding as per the design specifications.
• Automated the process of Account creation and automated the process of sending the mails to the customer once finished.
• Based on the input excel sheet provided by the client, created database connection on the excel sheet and connected to it.
• Read the data from the database using select statement and loop it and updated the database with required information.
• Automated using different commands like Image Recognition, Window, Insert keystrokes, object cloning, Variable operations, If/Else, Excel, loop Commands.
• Involved in unit testing and Bug Fixes.
• Involved in Design Task boat based on Business requirements.
• Involved in debugging the task once the development is completed to test whether the task is working correctly.
• Automated the input excel sheet by updating the columns with different status.
• Automated the process by sending the mail to the clients.

Confidential

RPA Technical lead

Responsibilities:

• Responsible for delivering the quality design solutions by applying the modular techniques which will improve the performance of the design within the time line.
• Involved in Requirement Gathering, Analysis, design and development of software robots using Automation Anywhere tool.
• Involved in design and development of software robots using Automation Anywhere tool.
• Automated SAP & mainframes applications.
• Involved in Business Logic implementation / coding as per the design specifications.
• Involved in Automated transferring the payments from one consolidated account to multiple utility accounts.
• Automated transferring the payments within the multiple utility accounts when the payment is done wrongly.
• Experience with Robotic Process Automation and Virtual Desktop environments.
• Automated transferring the payments from Mainframe, SAP applications systems.
• Based on the input excel sheet provided by the client, created database connection on the excel sheet and connected to it.
• Read the data from the database using select statement and loop it and updated the database with required information.
• Automated using different commands like Image Recognition, Window, Insert keystrokes, object cloning, Variable operations, If/Else, Excel, loop Commands.
• Involved in unit testing and Bug Fixes.
• Involved in Design Task boat based on Business requirements.
• Involved in debugging the task once the development is completed to test whether the task is working correctly.
• Automated the input excel sheet by updating the columns with different status.
• Automated the process by sending the mail to the clients.

Confidential

Technical Leader

Responsibilities:

• Created the reports (YTD, MTD) in SAP Frontend (Bex) that meet user requirement.
• Designed Hybrid data models using Transient provider, Composite Provider, Open ODS View, Advanced DSO, Virtual Cube, Virtual Info object for reporting using BEx Analyzer.
• Consumed HANA information models in to BW using Transient provider, Composite Provider, Open ODS View, Advanced DSO, Virtual Cube, Virtual Info object.
• Worked on Ticketing toll HPSM, and OTT (Online Ticket tracker) to track the status of CRT (Change requests).
• Designed NLS (Near Line Storage) dataflow to archive the data in to SAP IQ data base by automating the data loads using process chain, and troubling the data load issue.
• Retracting the data back to BI from NLS in scenarios when the data model is changed or loading the data to BI that is already archived to NLS.
• Designed APD’s to export BI the data to the Application server.
• Worked on Incidents like Currency issue, data mismatch issues, short dump, lock issues; hierarchy issue etc. and trouble shoot the issues.
• Worked extensively in Front-end Business Warehouse Components like BeX Analyzer in building Queries by creating calculated key figures, restricted key figures, Variables, structures, Formulas, Exceptions, Conditions.
• Worked on Change Requests to meet the user requirement and transported the objects across the landscape.
• Worked with BW models in HANA eclipse environment.
• Worked on creating new hierarchies, loading hierarchy data from R/3 to BW for Update Method Full Update, Insert Sub tree, Update Sub tree.
• Worked on ABAP code to fill the data to the objects by look up method using Start routine, end routine, expert routine, field level routine, user exits, ABAP code for BADI.
• Created Generic data sources using function modules and wrote ABAP code to extract full and delta data.
• Worked on creating Bex variables and wrote ABAP User exit to fill the data to variables at Run time.
• Worked on AO (Analysis Office) by creating new work books, executing the Bex reports using AO.
• Worked on data models which include the Modules COPA, FI, SD, and MM.

Environment: SAP BI7.3, SAP BI 7.4, 7.5(BI on HANA), HANA Studio, SAP ECC 6.0, Bex, ECC 6.0, SAP BO 4.1

Confidential

Technical Leader

Responsibilities:

• Installed the new Business Content objects.
• Created BW reports using Bex Analyzer and used calculated/restricted key figures, variables, conditions, exceptions, structures and Involved in estimation and planning for all the reports.
• Monitored the data loads and recovered the failure loads. Monitoring the background jobs & logs (SM37) and data loads by using (RSMO)
• Created Generic data sources using function modules and wrote ABAP code to extract full and delta data.
• Worked on creating Bex variables and wrote ABAP User exit to fill the data to variables at Run time.
• Worked on ABAP code to fill the data to the objects by look up method using Start routine, end routine, expert routine, field level routine, user exits, ABAP code for BADI.
• Checking TRFs by Using T-code SM58, when data load is long running
• Enhanced the data sources with new requirements.
• Worked on data mismatch issue that occurs in reports.
• Created queries that meet the user requirements.
• Created the process chains and triggered the chains on daily, weekly, monthly basis.
• Resolving issues like change Run failed because of Rollup
• Done unit testing for the newly created objects as a part of Change Request
• Migration of data sources from emulated data sources in 3.x to BI.7 environment.

Environment: SAP BI 7, SAP R/3 4.7E

Confidential

BW Consultant

Responsibilities:

• Working on monitoring incidents like Invalidate characteristics, Time limit exceeded, IDOC, TRFC, Duplicated key, SID issues, Short dumps etc.
• Worked on Report issues, where there is mismatch of data from Source System to Target System.
• Working on IM’s and Functional tickets raised by onsite team.
• Implementing outage bundle activities during LO extractor changes, Cleanup of the delta queues and Scheduling the V3 jobs in source system
• Deleting and Filling of Setup tables and running full repair loads
• Activating and scheduling/rescheduling the Process Chains
• Working on performance aspects like initial filling and deactivation aggregates, data package adjustment, parallel processing in DSO activation and ACR etc
• Activating the Transformations, Transfer rules and update rules, when they are in inactive
• Testing the objects in dev & Quality system.
• Monitoring the Data loads by process chains in BW (Daily / Weekly / Monthly)
• Monitoring the background jobs & logs (SM37) and data loads by using (RSMO)
• Checking TRFs by Using T-ode SM58, when data load is long running
• Monitoring (ACR) Attribute change run, which is most important/critical in production box
• Coordinating and communicating with the onsite team during urgency or any critical issue
• Raising the tickets (P2, P3 & P5) and assigning to related resolution group, if the issue is not in our scope.
• Always reached (SLA) Service Level Agreements

Confidential

BW Consultant

Responsibilities:

• Monitor the data loads in BW from various source systems like R/3 using process chains in development segment.
• Created Process chains with Process Type Remote Process Chain, which pass the Trigger to the Destination System and Call the Process Chain in Target System, and get the signal back to the Process Chain in Current System.
• Created a Process Chain which will raise an Event of any given day through a Parent Chain and trigger another dependent Process chain.
• Passed the Trigger to the below process, when trigger is not passed.
• Created a Process Chain to Trigger on specific days (1, 2, 3, 4, 5 ) of a given month.
• Created a Process Chain to trigger on specific day of week in a month (Every 3rd Sunday).
• Created a Process chain which will pass Trigger to other Process chain which will run based on Event Raised.
• Extensively worked on Administrative workbench.
• Involved in Data modeling to design custom Info Providers, ODS based on reporting requirements.
• Modify standard and create custom Info Source/Data Source, ODS, and Info Cubes, transfer structures, transfer rules, update rules for ODS and Info Cube
• Creation of Info packages for scheduling the data load process with Full and Delta update mode.
• Troubleshoot the data load issues wherever is possible.
• Analyze the errors in the data loads and report to the corresponding team if it is not in the scope of administration.
• Mange Master data, Text, Transaction by having the correct and up to the date data.
• Reconstruct the data requests from PSA in case of data load failure.
• Re-initialization of business area in case of inconsistency in data targets of any structural changes in the dataflow.
• Monitor all Administrator Workbench schedules, aggregate loads, realignment runs, ODS loads, batch jobs in BW.
• Liaise with BW Basis, BW Development team to resolve issues that arise during data loads and aggregation activities. This could include analysis of short dumps, IDOC issues, table space issues, etc.
• Resolving issues like Change Run Failed because of Rollup.

Confidential

BW Consultant

Responsibilities:

• Extensively worked on Administrative workbench.
• Extensively worked on scheduling the data loads through CONTOL-M in AB5 &QB5 Servers, and corrected loading problems in both AB5 & Qb5 Servers
• Raising the defects to the specific team in a mercury tool, when we are not to supposed to solve the defect in AB5 & QB5 Servers
• Responsible for the REV Track system in maintaining, creating Rev Tracks for entire GSAP-GB BW project used in the transport worked in layer architecture.
• Responsible for monitoring the process chains in the Control-M tool.
• Modify standard and involved in Data modeling to design custom Info Providers, ODS, Info Objects, custom Info Source/Data Source, ODS, and Info Cubes, transfer structures, transfer rules, update rules for ODS and Info Cube, based on reporting requirements
• Creation of Info packages for scheduling the data load process with Full, init, repair full and Delta update mode.
• Extracted data from SAP R/3 by using LO extraction & Generic extraction and from Non-SAP Source Systems using Flat file extraction
• Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads
• Extensively built Queries on Info Cubes, ODS objects and Multi-Provider using BEx analyzer
• Created Virtual Characteristics in the Queries.
• Created various variables and written USER EXITS based on the report/customer requirement
• Designed and developed process chains (RSPC) for master data loads and Transaction data Loads. And these Process chain are Scheduled for periodic loads
• Created Queries by using BeX Analyzer and Involved in creating calculated key figures, restricted key figures, Variables, structures, Formulas, Exceptions Conditions and web reports.
• As a Quality team member involved in Unit testing and delivered objects
• Involved writing Technical spec preparation and documented in Global Live Link.