Venkateswara Reddy Chandra

Email: adk75t@r.postjobfree.com

Ph. No: 91-903******* Advanced certified

Professional Summary:

Having 7 years of IT experience which includes application Documentation, Implementation, Testing and supporting.

Having 3 years of experience in RPA (Robotic Process Automation) platform with Automation Anywhere (AA) tool.

Extensively Worked with Web Application and Window application in process automation.

Designed reusable automation framework with MetaBots and reusable libraries for data externalization for SAP application.

Designed bots for Citrix, Mainframe and SAP process automation.

Involved in all phases of Bot Development Life Cycle including design, development and creating test cases.

Having knowledge in SAP IRPA tool which includes Desktop studio, Desktop agent and Cloud factory.

Expertise knowledge in all commands of Automation Anywhere client and Automation Anywhere server component (Control Room).

Designed automated process solutions in accordance with standard design principles and conventions.

Supporting existing processes and implementing change requirements as part of a structured change control process.

Strong knowledge on various commands like String Operation, Excel, Error Handling, Send Email command, Delay and Wait commands, Object Cloning, Loop Command, If command and Schedule tasks.

Extensive experience in extraction, transformation and loading of data from heterogeneous source systems like text files, tables, web-based application etc.

Configured automated process and objects using core workflow principles that are efficient, well structured, maintainable and easy to understand.

Expertise knowledge on SQL language and UNIX Commands.

Have domain knowledge in Retail, Manufacturing and Banking.

Have quickly acquired the additional application skills to meet business requirements.

Good knowledge on Datawarehouse concepts and their design.

Designed and implemented SCD type 1 and type 2 job sequences in manufacturing domain for their business reports

Worked on various quality assurance methodologies such as Agile and Waterfall methodologies and a solid understanding of the SDLC (Software Development Life cycle)

Technical Skills:

RPA tools

Automation Anywhere A2019,11.3.1,10.7,10.3,10.5, SAP IRPA

RDBMS

Oracle, SQL Server, JDA

Query Tool

Toad, SQL Developer

ETL Tools

IBM Infosphere DataStage

Scheduler

Tidal, Autosys

SDLC Model

Agile and Waterfall

Reporting Tool

SAP BO

Languages

SQL, EXCEL Macros, VBS, java script

Ticketing Tools

Remedy, CIQ, service now

Operating Systems

Unix, windows

Other Technologies

Hadoop basics, Cloud computing basics

Academic Qualification:

BTECH from Jawaharlal Nehru Technological University in 2012, Anantapur, AP.

Work Experience:

Working as Senior software in HCL Technologies.

Worked as IT Analyst in Quess Corp Pvt Ltd.

Worked as Associate in Talentain Technologies Ltd.

Certifications:

AA Certified master RPA Professional (Version 11)

Cloud computing basics from Udemy.

SAP Intelligent Robotic Process Automation.

PROJECT # 1

Project Name

GNFR Debit Balances

Client

Primark

Project Objective:

GNFR Debit Balances is part of oracle finance process, every month based on period date the debit balance report will be generated form finance application excel4apps. Report need to be split based on entity and aging, need to drill down the report line by line based on parameters and update the status to timing, intercompany, investigate and paid. A summary report and aging report also need to be generate with sum amount and number of vendors.

Responsibilities:

Developed the bots using A2019 version according to client requirements successfully.

Responsible for Design and Estimation of the solution

Worked across all phases of the project

Involved in the preparation of documentation for the project

Assigned tasks to team members, interacting with onsite/offshore teams

Worked as individual contributor in delivering the User stories and also mentored the team members

Took care of bot deployment and Increment releases

PROJECT # 2

Project Name

Vendor process creation

Client

Radial

Project Objective:

Vendor creation is part of the Vendor Master Control process within its Source-to-Pay Operations group. It involves creating, changing or extending vendor/supplier information in SAP, it will focus on the creation step, which takes about most of the time for the whole process, and vendor data received from the US and Canada, which accounts for about 80 percent of all requests.

Responsibilities:

Interact with business analyst to gather and analyze the requirements.

Developed the bots according to client requirements successfully.

Worked closely with IT to ensure that application support continuous improvements around quality, cycle time and operating efficiency.

Contributed to the service improvement efforts to the team and implement changes.

Created and documented test procedures and scenarios for the pre UAT phases and supported operational team during UAT and rollout phase

Participated in technical discussions and solutions and helped the team in taking decisions.

Providing daily status and progress of the project/assignments to lead.

PROJECT # 3

Project Name

Buffer stock enhancement

Client

Radial

Project Objective:

Buffer stock is defined as a supply of inputs held as a reserve in case there are future demand and supply fluctuations. It is the excess inventory or safety stock, which retains buffer to protect in case of uncertain future.

It may be found at all stages of the supply chain and is intended to reduce the occurrence or severity of stock-out situations and thus provide better line continuity and customer service. Buffer stock is used in production or other inventory situations to ensure that exceptional or unpredictable shortages or demands can be met with some degree of certainty. It is generally held when there is uncertainty in the demand level or lead time for the products.

Responsibilities:

Involved in all phases of Software Development Life Cycle including design, development and creating test cases.

Performed unit testing and created various test cases for the bots in all lower environments.

Involved in Code Review and Application support to testing teams.

Created database connections to fetch the data and automated the process to arrange data with Automation Anywhere.

Worked on using Excel and CSV commands with Automation Anywhere.

Worked on Activities using Object Cloning and Manage Web Controls.

Performed Image comparison using Image recognition command.

Automated tasks using web recorder and Scheduled tasks to repeat as per requirements using Automation Anywhere.

Responsible for scheduling Task scheduler to exchange data.

Used log file to handle the errors.

Developed the project using Agile methodologies.

Worked with database Oracle 10g.

PROJECT # 4

Project Name

Net acumen Reports

Client

Hibbett

Project Objective:

Hibbett Sports, Inc. is a publicly traded holding company for Hibbett Sporting Goods, a full line sporting goods retailer headquartered in Birmingham, Alabama. Hibbett Sports, Inc. operates sporting goods stores in small to mid-sized markets, in the Southeast, Southwest and lower Midwest regions of the United States. States with the most stores are Georgia (97), Texas (97), and Alabama (90). Its stores offer a range of athletic equipment, footwear and apparel. The company's primary store format is the Hibbett Sports store, an approximately 5,000 square foot store located primarily in strip centers which are frequently influenced by a Wal-Mart store.

Responsibilities:

Involved in Requirement gathering, effort estimation, analysis and designing, development, unit testing, bug fixing and deployment of client web application

Involved in Code deployment, daily updates on tickets.

Involved in Daily Scrum call as a team member.

Worked on Activities using Object Cloning and Manage Web Controls.

Automated tasks using web recorder and Scheduled tasks to repeat as per requirements.

String operation commands are used for data manipulation and error handling is used for debugging task.

Prepared post deployment documents for migrations of task to higher environment.

PROJECT # 5

Project Name

BI Reports

Client

AEROPOSTALE

Project Objective:

Aeropostale (occasionally known as AERO)is an American shopping mall-based specialty retailer of casual apparel and accessories, Aeropostale maintains control over its proprietary brands by designing, sourcing, marketing and selling all of its own merchandise. The company operates Aeropostale stores in the United States and Puerto Rico and the e-commerce site aeropostale.com. Aeropostale's licensees operate Aeropostale and P.S. from Aeropostale locations in the Middle East, Asia, Europe, and Latin America. The first Aeropostale stores were opened in 1987 by R H Macy & Co. in Thousand Oaks, California; and Short Hills, New Jersey

.Responsibilities:

Involved in all phases of Software Development Life Cycle including design, development and creating test cases.

Performed unit testing and created various test cases for the bots in all lower environments.

Involved in Code Review and Application support to testing teams.

Created database connections to fetch the data and automated the process to arrange data with Automation Anywhere.

Worked on using Excel and CSV commands with Automation Anywhere.

Worked on Activities using Object Cloning and Manage Web Controls.

Performed Image comparison using Image recognition command.

Automated tasks using web recorder and Scheduled tasks to repeat as per requirements using Automation Anywhere.

Responsible for scheduling Task scheduler to exchange data.

Used log file to handle the errors.

Developed the project using Agile methodologies and Test-Driven Development.

Worked with database Oracle 10g.

PROJECT # 6

Project Name

Migration 11.5

Client

CATERPILLAR

Project Objective:

The primary objective of this project is to migrate all data stage 8.5 job to DataStage 11.5 version for all the applications which are using in Caterpillar.

Responsibilities:

All Jobs are imported from 8.5 productions to 11.5Dev lower environments in each project which need to migrate.

Jobs are compiled in Dev to check any violation will occur in new environment

Worked with infra team to establish connection for source and target systems which are used in jobs

Creating new tidal scheduler jobs as per the production schedule calendar.

Involving customers in UAT to validate the output data or to provide source files for testing.

Performed end to end testing and data validation in all environments.

Providing dsx files for admin team to move the jobs to prod environment once approved by customer in UAT Phase.

Monitoring the jobs in 11.5productions for initial runs successfully.

Attended the meetings on daily basis and discuss on the work status and challenges.

PROJECT # 7

Project Name

APEX

Client

CATERPILLAR

Project Objective:

The primary objective of this project is to develop and execute middleware jobs for processing caterpillar Machines, Parts, and modules data to the target system. PPSS system will provide the data for customer to give complete caterpillar accessories information in order to make sales. Most of the cases we have mainframe files, db2 as source system which will provide data either push or pull mechanism.

Responsibilities:

Developing the ETL code based on business requirement.

Extensively used stages like Join, Funnel, Remove Duplicates, Merge, Lookup, Transformer, etc.

Migrating the developed code to higher environments.

Developing Data Stage sequences to run multiple jobs.

Perform the unit testing, data validation and performance testing in higher environments with customers.

Direct interaction with business partners and discusses about the challenges on code and/or data issues.

PROJECT # 8

Project Name

Enterprise Data warehouse Setup

Client

VODAFONE

Project Objective:

Vodafone India Limited has implemented a data warehouse to better plan and manage revenue realization, customer retention and acquisition and also to establish a data warehouse of usage, billing and provisioning information for the 3G,RCDR,and MCDR Business Units .The whole project is now retransformed with data stage as ETL tool and Tivoli as scheduling tool .Files are pushed into ETL server by mediation team continuously and processing is required in fixed time interval and needs to be loaded into the target database .There after post aggregation of data, it again needs to be loaded into oracle.

Responsibilities:

Developed Data Stage jobs based on mapping requirement.

Prepared Testing Documents and deliver the code to the Integrated Unit Testing team.

Extensively used stages like Join, Funnel, Remove Duplicates, Merge, Lookup, Transformer, etc.

Extensively used Reject Link, Job Parameters, and Stage Variables in developing jobs.

Used the local and shared containers for simplifying the complex designing of jobs.

Performed end to end testing and data validation in all environments.

Attended the meetings on daily basis and discuss on the work status and challenges.

Personal Details:

Gender : Male

Nationality : India

Marital Status : single

Location : Bangalore

Contact this candidate