Anup Upadhyay | Projects
128
page-template-default,page,page-id-128,ajax_fade,page_not_loaded,,qode-title-hidden,qode-theme-ver-16.7,qode-theme-bridge,disabled_footer_top,wpb-js-composer js-comp-ver-5.5.2,vc_responsive
RPA Projects

May’18 – July’18, EY as ‘RPA Architect’ ( End Client – QualComm, RPA tool : Automation Anywhere )

EY provides global services to help you retain the confidence of investors, manage your risk, strengthen your controls and achieve your potential.

Responsibilities:

  • Design and implementation oversight of the process automation.
  • Provide local technical support for the Robotics teams and stakeholders
  • Develop overall technology architectural direction for the automation opportunity
  • Evaluate RPA tools and provide recommendations
  • Anticipate, identify, track and resolve technical issues and risks affecting delivery
  • Assist development team in resolving technical problems
  • Coordinate and participate in structured peer reviews and walkthroughs
  • Assess automation opportunity from technical perspective and perform due diligence to arrive at an optimal solution.
  • Define the technical framework considering all relevant artifacts including, Security Method of access (internal client network, internet, local access) User Authentication (SSO, central LDAP, individual log in)
  • IT Security and/or Audit Policies which impact the robot deployment
  • User Authorization Processes, it’s lead times & request process
  • Technical impacts of applications using OCR or Adobe Flash
  • Technical impacts of applications accessed behind Citrix.
  • Hosting Locations and Hosting provider (Internal / 3rd party)
  • Availability of test system by application
  • Availability of “production like” test data within test applications
  • Consistency of test data between applications
  • Performance of key applications in the process that could limit the average handling time of the automation System availability & timings

Nov’17 – April, 18: Electrolux,Malaysia as ‘RPA Head/ IT Architect’

Swedish multinational home appliance manufacturer company – 99 years old

RPA:

  • Participate in pre-sales client workshops, provide solution architect /technical architect support to the teams in RFI/RFP process
  • Analyze client processes, identify automation opportunities, define RPA value proposition, reengineer process to improve automation potential  and recommend RPA approach/strategy
  • Develop Detail As Is Process Description – PDD (Process Description Document), Detail To Be Automated Process Description – SDD (Solution Design Document)
  • Conduct RPA High Level Assessments
  • Develop RPA client architecture and solution proposal focusing on scalability and extensibility
  • Work with the Project Managers and Business Analysts to develop high level project plans for implementation projects
  • Have exposure to wide variety of technology problems and their solutions and use that to drive the adoption of best practices around coding, design, quality, and performance in the team
  • Provides continuous advice to RPA developers and Project Manager during project delivery

IT:

  • Developing and overseeing SMART metrics for hardware, software, and storage
  • Ensuring strategic capacity planning
  • Managing all or part of the IT department, including directly supervising some employees, hiring certain members, and handling employee concerns and performance
  • Communicating with the technology team and other departments as collaboration requires
  • Determining business requirements for IT systems
  • Coordinating IT activities to ensure data availability and network services with as little downtime as necessary
  • Overseeing departmental finances, including budgeting and forecasting
  • Implementing policies that are chosen by executives and reporting back to the C-suite level
  • Identifying security vulnerabilities and eliminating them with strategic solutions that increase data security
  • Directing and supporting the implementation of new software and hardware
  • Identifying and recommending new technology solutions
  • Managing the organization’s help desk (internal, external, or both)

Vendor Mgmt.:

  • Manage and mange external vendor relations within Operations Department.
  • Perform as functional bridge amongst external vendors as well as internal stakeholders.
  • Coordinate all vendor management tasks inclusive of working with external vendors and internal employees.
  • Ensure enterprise-wide needs for due diligence, risk assessment and continuing vendor monitoring are being accomplished.
  • Help and coordinate vendor processes and methods to approve vendors.
  • Ensure to track, measure, report and evaluate vendor performance.
  • Troubleshoot all vendor problems and present to management as required.
  • Identify improvement areas internally as well as perform closely with all internal stakeholders to prepare solutions.
  • Identify and implement continuously enhance efficiencies associated with vendor management plus produce fulfillment.
  • Participate to formulate workflow processes, methods and policies for applying vendors.
  • Ensure to collaborate with IT areas to assure vendor partners effectively manage plus contracts are completely leveraged.
  • Prepare processes for as well as manage analysis, selection and transition.
  • Monitor contractual agreements for all IT function’s vendors.
  • Stimulate steady process enhancement to present increasing operational efficiency in entire business partner processes.
  • Support to explore expansion across new business lines.

Previous Organization: Synechron, Pune

Role: Associate Specialist – RPA                                                                           April 2017 to Oct, 17

Responsibilities:

  • Defining, documenting and updating the process for identifying and implementing RPA opportunities.
  • Defining the RPA delivery methodology and decision making milestones.
  • Defines RPA process tools and templates.
  • Defines support & governance model.
  • Drives Finance SSO RPA capability creation and its continuous development.
  • Builds an Internal Center of Excellence consisting of all RPA professionals and key stakeholders.
  • Stakeholder & Community management.
  • Ensures communication within the Community and ensuring trough the community common process, methodology, tools, and other RPA principles.
  • Communication and change management to ensure that defined processes and RPA practices are implemented successfully in a consistent manner.
  • Plans and implements the training curriculum for all the RPA stakeholders (e.g. technology, process, train-the-trainer, online-solutions).
  • Promotes RPA concept and approach within the organization. Experience in capability development technical, process and technology.
  • Provides technical direction for the development, design, and systems integration for client engagement, from definition phase through to implementation.
  • Applies significant knowledge of product and developments to improve service for our RPA factory.
  • Easily recognizes system deficiencies and implements effective solutions.
  • Understands complex database concepts and effectively employs different database design techniques.
  • Reviews the status reports of team members and addresses technical issues as appropriate Complies with and helps to enforce standard policies and procedures.
  • Ensuring RPA processes are being triggered as intended.
  • Reviewing analytics and providing process improvement information to the Process Designer.

Project:  Sytor.io

Client: Markal, USA

Team Size: 10

Role: RPA Architect

Description: Developing the RPA in-house solution for Testing CoE, the Sytor.io is coming  with the cloud based RPA solution which provides Distributed Software Robots, Automatic Deployment, encrypting the stored data as well as securing the communication between various resources, visual process designers, execution controlling from cloud,  OCR handwritten problem solution provided, machine learning capability etc.

Roles & Responsibilities:

  • RPA High Level Assessment
  • RPA Solution Design:
    • Detail As Is Process Description PDD (Process Description Document)
    • Process Analysis and Process Improvement
    • Detail To Be Automated Process Description SDD (Solution Design Document)
  • Define a quantifiable Business Case
    • Partner with the Robot Developer to create an implementation plan for the RPA Solution Designed (SDD)
  • Define a quantifiable Business Case
  • Identify processes that are feasible for automation with recommendations for benefits savings
  • Define complexity of the process in terms of RPA Delivery
  • Prioritize Process Automation according potential savings.
  • Create a Business View RPA Solution Design

Solution Architect/ Project Manager, Birlasoft, Noida NCR March 2015 to March 2017

Implementing/executing various Dev/QA activities for different accounts.

  • Implementing/introducing RPA solutions to different accounts.
  • Defining processes and designing various testing template for Testing Service Line.
  • Building Delivery Handbook for the organization, setting process standards and architecture.
  • High level planning of software SDLC activities (by gathering detailed functional requirement from the client and plan the strategy for automation.)
  • Excelled in guiding the work of technical teams. Articulated project goals and scope, translated business needs into technical terms, prepared detailed work breakdown structures (WBS) and instilled shared accountability for achieving project milestones.
  • Excelled in project estimation, calculating ROI, resource loading, scheduling.
  • Expert in PoC/Pilot for RPA projects.
  • Resolving numerous project issues including technical, non – technical: staffing shortages, tactical matters, scope creep and divergent business and user needs.
  • Keeping all the stakeholders updated on the project status by regular updates

@ Birlasoft:

  • Alticor – Amway (PoC for five major application using UFT, Selenium, Test Complete)
  • GE PW -RACES project – (Automation Framework architecture support) using UFT
  • Schlumberger – (Mobility development & testing PoC with iOS, Android and on Cloud Devices using AWS)
  • SAP RPA PoC (Internal) 🙁 PoC with Blue Prism)
  • GEHC QPM Testing Engagement – Support for pre sales activities
  • Script less Automation –GE 🙁 PoC with script less automation tools – Test Complete & Test Magic)
  • Xerox- RPA Pilot Solution for different processes using Blue Prism
  • Sirva–PoC with Selenium with C# and UFT
  • NBCU – Overall Automation testing responsibilities.
Automation Testing

Solution Architect/ Project Manager, Birlasoft, Noida NCR

Implementing/executing various QA activities for different accounts.

  • High level planning of software testing activities (by gathering detailed functional requirement from the client and plan the strategy for automation.)
  • Excelled in guiding the work of technical teams. Articulated project goals and scope, translated business needs into technical terms, prepared detailed work breakdown structures (WBS) and instilled shared accountability for achieving project milestones.
  • Excelled in software testing estimation, calculating ROI, resource loading, scheduling.
  • Expert in PoC for automation testing projects.
  • Resolving numerous project issues including technical, non – technical: staffing shortages, tactical matters, scope creep and divergent business and user needs.
  • Keeping all the stakeholders updated on the project status by regular updates

@ Birlasoft:

  1. Alticor – Amway (have done the PoC for five major application with three major automation tools) using UFT 12
  2. GE PW -RACES project – (Automation Framework architecture support) using UFT
  3. Schlumberger – (Mobility Testing PoC with iOS, Android and on Cloud Devices using AWS)
  4. SAP Testing PoC (Internal):( PoC with TestComplete and Testing Anywhere ) using UFT/TestComplete
  5. GEHC QPM Testing Engagement – Support for pre sales activities
  6. Script less Automation –GE:( PoC with script less automation tools – Test Complete & Test Magic)
  7. Xerox- PoC with ZapTest and UFT for three major applications using UFT/Zaptest
  8. Sirva–PoC with Selenium with C# and UFT
  9. NBCU – Overall Automation testing responsibilities.
  • Project Manager for “GE Aviation” client
    • Leading the automation team for ongoing automation activities, resolving any open technical/ non- technical issue.
    • Mobility testing with physical/cloud devices (android/iOS)
    • Helping team to create new function/modules in automation framework.
    • Handling team of 10 resources.
  • Project Manager for “NBCUniversal” client
    • Leading the automation team for ongoing automation activities, resolving any open technical/ non- technical issue.
    • Helping team to create new function/modules in automation framework.
  • Project Manager for “Alticor – Amway” client
    • Completed detailed PoC for different application at onsite, and executing the next level of PoC demand form the client.
    • Created detailed business proposal and estimation for the project.
    • Calculated ROI for the project.
    • Handling team of 4 resources at the initial level.
  • Project Manager for “NEO Post” client
    • Planning strategy for initial PoC – automation for major applications.
    • Handling team of 3 resources.
  • Project Manager for SAP automation, Birlasoft Internal Project
    • Planning strategy for initial PoC – automation for major applications.
    • Handling team of 5 resources.
VBA

Project :Test Plan / Test Lab extractor

Client: British Telecom

Company : Accenture

Project Description:These are the tools which will fetch all the Test cases with all the predefined required fields from the specific path of Test Plan / Test Lab to the Excel sheet with predefined condition using Macro.

Roles &Responsibilities:

Developed the entire tool individually

Project :Mainframe Application Macro

Client: British Telecom

Company : Accenture

Project Description:Created the Macro base small project of automation for the mainframe application (CSS), this Macro will insert the data into the CSS application using macro, and also check the validation points accordingly. The macro has various function / procedures which will take care of all the other functionality of the application.

Roles &Responsibilities:

Developed the entire tool individually

Project :Oneworld

Client: RBSInternal

Company :RBS

Project Description:Oneworld is a trade booking application, which is used for book the trade, verification of Trade, Settlement of trade and finally return the trade. Oneworld can also manage the Collateral. The Application was built in Power Builder and it uses Stored Procedure, with 10g database and Unix is the operating system for OneWorld.

Roles &Responsibilities:

Used Excel/Macro (VBA Programming) for database testing. In this The Excel environment will fetch the data from the relevant tables of a particular operation (Like: Trade details, Verification Detail, Profit & Loss etc.)And there are Macro is written into Excel, which will calculate the necessary operations. The Output is the same as it is displaying in the GUI environment, but it will automate the overall manual efforts for database testing.

  • Design the whole Framework for Excel/Macro Database Testing.
  • Design the Excel based Query Analyzer adaptor, which will connect Oracle with Excel and perform the transactions.
  • Writing the complete Macro suite for all the require functionality for database testing.
  • Creating the Log file after the Macro Execution with all the Pass/Fail Test Result.

Create all the necessary VB Function, Procedure

Some other projects:

Send Mail Utility: This is an automatic mail sending utility, which will automatically send the status updates from various excel sheets to the recipients with the predefined format.

QC Test Set Generator: This tool is developed for creating Test Set in the Test Lab and attach all the required Test Cases automatically with predefined conditions.

The Excel sheet fetched all the list of Test Cases of a particular path from Test Plan using Macro, to the sheet , and selected Test Cases will directly attached into the Test Set with the help of Macro.

QC Test Set Download Attachments: This tool is used to download all the selected attachments from a specific Test Set of Test Lab folder.

First the tool will fetch all the Test Cases from the predefined Test Set to the excel sheet with the help of macro, then all the selected Test Cases with the attachments will download to a specific folder in the local path with the separate name automatically, using Macro.

Sanity Log Tracker( Client / Server ): This tool will log each individual execution total time and other system details for each day, It will logs all the required details and upload it to the specific shared drive location and later it will create the customize report on it.

QC Test Plan update: This tool is used to Add/Modify/Update all the selected Test cases of the specific path of Test Plan with the predefined conditions using Macro.

QC Defects Update/Modify: This tool will fetch all the required Defects details to the Excel sheet with predefined filter criteria/conditions and can send the Excel sheet through mail using Macro.

Sanity Execution Scheduler: This tool will load all the executable Macro files of Sanity from a specific path to the sheet, and then later it will execute all the Macro files and their Macros in order using predefined executable conditions, once the execution will complete, it will also send a confirmation mail with all the details of the Sanity execution.

QC Audit Tool: This tool will fetch various data from different tab from QC (Requirement, Test Plan, Test Tab, and dashboard) as per the predefined set conditions, also it will update the fields into various tab as per the requirement. This tool has various feature for reporting, data representation in various formats as well as it exports the data in separate file and send the report/sheet using automatic mail send facility.

Trace file analyzer: This utility will open all the Trace files ( .CSV ) and based open the criteria it will filter the data from the Trace file and generate the custom report. This utility has saved more than 300 hrs. in a calendar year.

Weekly Status Report: This weekly status report will open all the Tracker files ( .xls ) from different location and filter them and copy into the Excel utility , then it will manipulate over the data based upon the criteria , and generate the Summary Report , Pivot Table , Graphs , and the Details of Weekly status in different sheet based upon the criteria. This utility has saved more than 190 hrs. in a calendar year.

.Net & VB

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur semper est at odio volutpat tristique. In vestibulum rutrum ante sed porttitor. Nulla suscipit vitae massa vel gravida. Sed convallis et nulla id volutpat. Aenean euismod ante a ligula porta, vitae malesuada ante elementum. Duis ac ligula eget justo porttitor varius. Maecenas placerat urna quam, eget interdum orci iaculis sit amet. Morbi auctor volutpat leo a auctor. Mauris eu elit risus. Maecenas id ligula quis nisi malesuada imperdiet. Praesent accumsan odio ac lectus ultrices tincidunt.

Follow Me:
Contact Details:

+91 8209975456 ( India, Direct )

+60172835910 ( Malasia )

+91 9822511786 ( India , WhatsApp)

+91-294-2527582 (India, Lanmdline)