SUMMARY:

• Technology lead and a Certified RPA consultant with over 8 years of IT experience including 2 years of RPA process implementation using UI PATH Studio, BLUE PRISM along with SAP BW, BPC & HANA expertise.
• Worked in Development and support and implementing Automation Architecture in SAP HANA/BPC/BW and certified in UIPATH - Studio RPA automation.
• Worked in Automating the projects using UI Path, Blue prism & Autosys.
• Working on Business process diagrams and process flow charts/sequences with RPA tools.
• Prepared Product Design Document(PDD), Solution Design Document(SDD) Implementing Plan & Release documents by working closely with SME’s
• Working on BPD’s & Process flow charts with RPA tools and automated PDF/Excel operations.
• Worked as a POC for RPA initiatives and acted as a bridge between developing and testing Teams.
• Worked on building the BOT deployment architecture using orchestrator.
• Understanding of Windows/Web/Java app/Thin client integration with RPA Tools
• Created end to end automation solutions for clients as per requirement which involves feasibility study, designing architecture, development, testing and deployment of automation.
• Knowledge in testing SOA frameworks like REST & SOAP based API's, Web services and UI testing.
• Experience in developing software test approach, test plan, test case design, and test scripts based on user requirements/ specifications and system requirements documents.
• Involved in the centralized infrastructure for maintaining several robots across the organization.
• Exhaustive analysis of business content at the Project Blueprint level, Requirement gathering to perform GAP analysis and implement using ASAP, Waterfall and SDLC methodologies.
• Worked on AGILE/SCRUM, facilitated sprint planning, backlog grooming, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings.
• Handling change request for enhancing as well as maintaining the current API System.
• ETL Extraction from SAP ECC into BW using Standard & Generic Extractors along with flat file extractions of Data from application server and carried out transports to Quality and production environments.
• Expertise in all phases of BW/BPC Implementation-Data Analysis, Data Modeling, Data Extraction/Uploading and Reporting.
• Worked on AUTOSYS and automated the BW PC’s by deploying the code in IXP and PUTTY.
• Good experience in extracting data from SAP & non-SAP systems.
• Lead the Teams Both On-shore and Off-shore Teams to ensure the deliverables are smoothly achieved on time.
• Expert in Unit, System and UAT and Performed Data Validation for all the reports and dashboards generated from various database sources.

AREAS OF EXPERTISE:

UI PATH:

• Flow charts and sequences in UI PATH studio.
• Excel, Data table along with pdf, csv & mails.
• Recordings, Screen scraping, Data scraping.
• OCR, Variables, Arguments & Selectors.
• Code debug, breakpoint, Invoke methods, Arguments.
• Orchestrator- Assets, version management, Job scheduling.
• Preparation of high level TRD’s based on the Business requirements.

BLUE PRISM:

• Process, Objects, Stages, SAP integration.
• Loops, Collections, Decisions, Data items, Application modeler, Spy modes
• Code debug, breakpoint, Exception handling.
• Automation Dashboard, Queue Management, BOT cloning & Manage window controls.
• Control and Release Management, version management, Job scheduling.
• Preparation of high level PDD, SDD & TRD’s based on the Business requirements.

AUTOSYS:

• Scheduling BW/BPC Pc’s through Autosys.
• Preparation of high level ART’s based on the Business requirement.
• Involved in development, review & Testing of Autosys JILs using IXP.
• Expertise in UNIX commands and Shell Scripting in PUTTY.
• Worked on Flat files pulled from the Legacy Database into SAP Application server through Autosys.
• Creating Business day calendar scenarios, syndication of files from SAP to multiple systems.

SAP HANA:

• HANA Modeling: Attribute Views, Analytic Views, Calculation Views,
• Decision Tables, Procedures, SQL Scripts.
• DXC Configuration for Data Replication using existing Extractors in ECC.
• SPS09 support multiple HANA DB’s on single HANA systems.
• SPS10 will allow 1 to N Asynchronous table replications
• SLT Configuration for ECC table replication into HANA, BODS, DXC and NLS services.
• Replicating data from HANA Views to Composite Providers, Open ODS Views for BEX reporting.

SAP BW:

• Working knowledge ECC & SAP BW 7.4 & 7.5
• Working knowledge in LO, FIGL Extractions, Data Modeling, Query Designer in SAP BI.
• Working knowledge in BI debugging.
• Working knowledge on data load monitoring.
• Performance tuning techniques such as Indexing, aggregates, Partitions & compression techniques.
• Good knowledge on Delta Management.
• Good knowledge on BW Transports management.
• Reporting based on BW Info-providers using tools like BEX analyzer, Query Designer.

TECHNICAL SKILLS:

RPA Tools: RPA-UI path, Blue prism, AUTOSYS, IXP, PUTTY (Unix scripting)

Automation Tool: UI-Path studio and Blue prism, Autosys

Automated Technology: Windows OS, Citrix, Web, Mainframe and Oracle & Sap Applications

SAP: SAP BW 7.3, 7.4,7.5 Native HANA, BW on HANA (SP09, SP10) SAP BPC 10.0 and 10.1

Database: Oracle, My SQL, HANA, MySQL, MS SQL

Methodologies: ASAP, Agile, Waterfall and SDLC

Microsoft Technologies: VB, .NET, Windows, Internet Explorer, SQL Server, Web Framework 4.0/3.0/2.0/1.1/1.0, Windows Service, SQL.

Languages: Services, ABAP, Unix, SQL, PowerShell, bash, VBS, etc.

WORK EXPERIENCE:

Confidential

RPA Lead

Responsibilities:

• Skilled in automating business processes using RPA technologies.
• Expert in Robotic process automation solutions such as UI path Studio.
• Experienced in using UI Path Studio, Orchestrator, Screen, Data & Web scraping techniques.
• Developed and implemented end to end processes including automation of Web Portal, MS-Excel Operation, MS-Out Look.
• Troubleshoot and debug with RPA tools and bug fix.
• Implemented various logics in the Bot using IF, While, Do while and For Each loop.
• Experienced in controlling the BOT’s using RPA administrative/Orchestrator.
• Identified underlying Data flow and objects to Automate the process.
• Created PDD and TRD’s to ensure compliancy across all platforms.
• Worked with the SAP Analysts in identifying and defining the requirements.
• Gathered requirements and provided solution for designing, coding, testing & debugging.
• Participated in online meetings to demonstrate the capabilities of RPA for on-going projects and potential clients.
• Extensively worked on screen scraping and Data scraping, Full text, Native text and OCR.
• Assisted and provided training to end users and supported them users during UAT.
• Built Bots & provided Demos to Users by collaborative unit Testing.
• Co-ordinated with teams during User acceptance testing and Automation of BW data flows using UI Path.
• Prepared a Road Map for delivering Task bots into production pipeline.
• Provided advisory services to key stakeholders on the potential benefits of automation and organization readiness required to accept the automation transformation.
• Provided guidance on the right automation platform for process automation based on the Process - considering process type, complexity, platform capabilities etc.
• Solid design, coding, testing and maintaining the RPA's (Robot's).
• Analyze the feasibility of existing process suitable for automation.
• Lead the Teams Both On-shore and Off-shore Teams to ensure the deliverables are smoothly achieved on time.
• Supported business and technical teams during robotic projects and mitigate/Resolve risks and issues that may impact project schedule, cost, scope, quality etc.
• Provide knowledge transfer/support/Assistance to the Applications development and Support team.

Confidential

UI Path developer

Responsibilities:

• Working on Robotic Process Automation using UI Path studio.
• Identified the opportunities to automate manual tasks using Robotics Process Automation (RPA) technology & Established Commercial-wide RPA program to deliver the first software bot in production.
• Implemented new reporting techniques like excel operations and Mail Automation and facilitated the presentations to the clients.
• Automated navigation through SAP UI screens using the Screen scraping, Data scraping used required activities to create flowcharts and sequence. worked on google and Microsoft OCR, Selectors, Excel and data tables.
• Reviewed & fixed Business Process Production issues using UI Path.
• Designing UI Path process solutions in accordance with standard UI Path design principles and conventions.
• Used Try Catch for the Error handling.
• Worked on Basic, Desktop, Web and Citrix automations using UI Path studio.
• Updated the day to day progress and made generic enhancements to the Bots designed.
• Implemented the end to end execution for different processes using Attended and Non-Attnded Bots.
• Created the high-level design towards meeting functional & non-functional requirements in the Use case document.
• Triaged business requests for automation using standard proprietary criteria and identifies “RPA fit” candidate processes.
• Completed all standard templates including high-level design documents to ensure all business scenarios in scope to be configured into RPA.
• Guided and Participated in the project planning of RPA initiatives.
• Coordinated with the Off shore and perineal teams for better execution of BOT Architecture.
• Provide knowledge transfer/support/Assistance to the Applications development and Support team.
• Engaged end users in UAT sessions by providing the User guidance to handle the BOTS.
• Actively involved and participated in the planning and execution of code deployment by executing the work breakdown structure to ensure a smooth and successful Go-live.

Confidential, VA

Automation Lead Analyst

Responsibilities:

• Lead teams assigned to Automation projects ensuring adherence to set standards and solution architecture.
• Work closely with the Business Relationship Management, Architecture, and Support teams.
• Identified processes that are feasible and define complexity of the processes in terms of Automation.
• Develop, configure Automations that are efficient, well structured, maintainable and easy to understand.
• Run Automation projects coordinating with business stakeholders and IT leads.
• Analyzed, Observed & Documented multiple processes to understand the process steps and applications used to complete business transactions.
• Designed and developed Process & Technical Design Documents (PDD) & (TDD) and Automation Requirement Documents ARD’s to Automate the Loads processes in the areas of IM, PTP, P2P, TM and OTC as needed for audit purposes.
• Knowledge of Microsoft packages such as MS Excel (VBA scripting), MS Visio, MS Access, & MS Word.
• Worked on pulling Flat Files from Legacy Database into SAP Application Server through CA Autosys.
• Created JIL files to Automate the Batch loads in SAP using Unix scripting and further deployed using PUTTY
• Lead Teams and coordinated with Off-shore Teams to ensure the deliverables are smoothly achieved on time.
• Creating Business day calendar scenarios, syndication of files from SAP, Non-SAP integrating multiple Applications.
• Facilitated training and created User Guide documents for business users to handle BOTS effectively.

Confidential

HANA Developer

Responsibilities:

• Analyzed business needs and participated in the Design and Building of business process to facilitate important functionality to achieve the expected outcome.
• Closely involved in the design, configuration and documentation of various business processes between BW and Native/BW on HANA.
• Worked in relevant DMO activities for migrating BW7.3 on DB6 to BW 7.4 on HANA on SP09.
• Monitored upload processes, Perform technical validation of uploaded data as part of migration project.
• Worked on SAP-HANA Data provisioning using SLT and Flat File Up loader into SAP HANA DB
• Worked on SAP HANA Administration, Hana perspectives and Modeling using Different types of views, SQL.
• Used Projection, Aggregation, Join and Union Process and followed the best practices to implement the Calculation Views.
• Had used HANA modeler designing the data flows.
• Written SQL Script for writing the stored procedures and Filters and used them in calculation views.
• Worked on bringing in data from HANA views into SAP BW using ODS, Composite providers, Virtual providers, Transient providers for reporting purpose.
• Strong knowledge of Bex Query Designer, Calculated & Restricted Key Figures Exceptions, Conditions, Exceptions, Queries on Multi Providers, Bex query performance issue.
• Developed and tested different migration tools to help in having a smooth and efficient Data migration process.
• Actively involved and participated in the planning and execution of a detailed cutover plan for a smooth and successful Go-live.

Confidential

BW Developer

Responsibilities:

• Extensively worked in BW Info cube, DSO, Multi-providers, Info sources, Info objects, Transformations, DTP’s Extractors, info sources, Info packages, Data sources and PC’s.
• Development reviews, FS, TS, TUT reviews.
• Developed load plans for huge volumes using Company Codes, GL Accounts, Fiscal Year, sales order, Trading partner, Audit trial and other BPC dimensions.
• R/3 and ECC logistics data.
• BW configuration, ETL background and Info Cubes design, strong on End-to-End BW Configurations.
• Automated the process of rolling forward the SPO’s as part of WRF and MRF activities.
• Successfully completed TUT, Integration testing and UAT for the development before moving it to higher environments.
• Preparation and reviews of technical specifications, Unit testing documents.
• Worked on Virtual providers, Aggregation, Indexing, Compression, Remodeling Development Activity.
• Creating Report with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
• Worked extensively on transporting and collecting object as per the dependency and move them to the higher environments.
• Preparation and reviews of technical specifications, Unit testing documents.
• Solving Production issues of BW/BPC Developments.
• Closely involved with business to create test cases and test scripts to conduct integration, volume and performance testing on some of the complex business functionalities.

Confidential

Business Analyst

Responsibilities:

• Involved in requirements gathering, involved in creating the modules for payment gateway process, Allocation, Maintaining of Shopper’s Account Codes, and Department Codes using Windows forms.
• Used vb.net in writing scripts for integration services. Converted the classic asp pages to asp.net 2.0 with c#.net as code behind.
• Involved working on database scripts, Stored Procedures, Views, Indexes and Functions in SQL server, used ADO.NET for communication between the web services and Databases.
• Developed ASP pages to communicate with COM+ components as middle tier and MS SQL Server as database tier.
• Database design, preparing entity relation diagrams, UML case diagrams using Visio tool.
• Implemented the Middle tier and Business logic using VB.NET, ODP.NET.
• Created Custom Controls using ASP.NET.
• Worked extensively with CSS in preparing the Master Pages for various Web Applications.
• Developed XSL style sheets for Funds Transfer Module and transformed the XML files to XML and HTML.
• Created the content using ASP.Net with the feature of Dynamic Paging capabilities.
• Involved in creating UML Use Case Diagrams, Sequence Diagrams, and class diagrams using VISIO.