Profile
7+ years of experience in Software Development and Automation Tool Creation Methodologies in Telecom/Finance domain.
Professional Summary
7+ years of experience in the areas of Automation and Software Development in telecom/finance domain.
Working in Capgemini at client location as Automation Consultant for HSBC UK.
Worked in Tech Mahindra in United Kingdom as OnShore Technical Coordinator for British Telecom.
Designed Automation Strategy for many Telecom/Finance Projects.
Conducted multiple sessions for UFT/QTP/VB Script in (Customer Services System) CSS and Capital Market projects for changing manual testing techniques to automation and preparing its architecture for future developments.
Worked in Migration team for migrating account from CSS Legacy stack to strategic stack.
Worked as Development Lead for many Telecom/Finance Projects.
Good understanding of Capital Markets and Telecom Billing.
Good understanding on QC/ALM with QTP. and (QC-OTA)Open Test Architecture knowledge
Good understanding of automation of processes and tools needed for quicker work resolution.
Expertise in creation of Tools using Visual Basic, MS Excel, vb scripts with Oracle/MS Access/Excel database in backend and customer interaction.
Excellent communication and interpersonal skills with proven abilities in resolving various complex issues.
Well versed in billing concepts and Development.
Certified in NSE Financial Markets ( NCFM )
Certified in SeeTest
Worked on Various proof-of-concept demonstrations and solution.
Experience Details
Capgemini India Pvt Ltd. Consultant Jan 2014 till date 18 months
Tech Mahindra Ltd. Sr. Business Analyst Nov 2009 till Jan 2014 50 months
Acme Digitek Solution Pvt Limited Software Developer July 2008 till Oct 2009 16 months
Academic Profile
B Tech 2008 Amity University First Division HSC (12th )
2004 La Martiniere College , Lucknow First Division
SSC(10th ) 2002 La Martiniere College , Lucknow First Division
Achievements/Certifications
Received BLUE RIBBION award from British Telecom UK for Automation.
Received CUSTOMER DELIGHT award for work in Automation in HSBC FIAR Project.
Acknowledged and Appreciation by Management and Internal Automation Team for contribution in Automation in Delphi and OSS using QTP & Other scripting techniques.
Received Cookies award for work in Automation in O2 Project.
Received PAT ON BACK award for work in Automation in UKBM Project.
Appreciation by client for providing quick resolutions and Automation work in FIAR Project.
Appreciation by client for developing Query tool in FIAR Project.
Successfully completed the course of Corporate Communication from Amity Institute of Corporate Communication. Certificates
Successfully completed the course Behavioral Science Course from Amity Institute of Psychology And Allied Sciences.
Successfully completed the course Of Foreign Language Course in French from Amity Institute of Foreign Languages.
Successfully completed certification in NSE Financial Markets ( NCFM ).
Successfully completed certification in SeeTest by Experitest .
Skills Set
Technical
Testing Tools : Quick Test Professional 11.5, Selenium, Cucumber , Seetest (mobile)
Trading Tools : Bloomberg, Martini
Operating Systems : Windows 7/ XP. Mainframe
Database : IBM 3390, Oracle 10g, IDMS, Access
Languages : VBA, Excel Scripting, SQL, COBOL,JCL, Core Java
GUI : Mainframe CICS, TSO
Functional
Automation:
Designing of Automation Planning for all types of systems.
Designing of Automation Strategy for all types of systems.
Designing of Automation Framework from scratch for all types of systems.
Use of QTP/VB to automate Batch jobs / Delphi Application / Oracle Application Forms / Web Applications.
Use of Microsoft Excel, Visual Basic, Mainframe TE addin, Delphi addin, Oracle addin etc. for increasing the speed of work assigned.
Analysis of work methodology to understand where automation can be implemented and useful for future.
Creation of tool using Visual Basic in front end and Oracle server as backend. With help of mainframe experience and billing, extracting data from Mainframe using batch jobs and loading them onto oracle tables to help e2e test team speed up migration process.
Creation of Excel macros with GUI to work on Mainframe sessions.
Use of different languages depending upon the complexity e.g. macros for small/less frequent work and GUI applications with Oracle or Access database for huge/repetitive tasks.
Software Development and Testing:
Analyze customer requirements for feasibility & capture requirements in totality considering all explicit and implicit requirements to Automate Applications.
Code and develop artifacts in mainframe application.
Carried out System Testing, Regression Testing, E2E Testing and Integration Testing.
Preparing & executing test cases and tracking defects.
Responsible for Test Planning, writing and execution of Test Cases.
Creation of automation script for faster data builds.
Attended Post Implementation call, User Confidence Testing progress call with Delivery & Deployment Team and provide support to external teams.
Analyze the queries rose by external teams and customers and provide the solution for the same.
Maintained effective communication with internal stakeholders like CSS End to End Design, Development, Allied, Delivery & Deployment teams.
Project Management:
Delegating & assigning work to team members to ensure operational efficiency and delivery on time.
Review of code and Documents for each development unit in a release.
Discussion with design and development teams in case of any blockages for Development & testing.
Defect Prevention meeting within team to ensure similar bugs do not occur in the code.
Conducting presentation for customer after each release.
Project Experience
1) Project Name GBM FIAR
Project Type Investment Banking Company/Client Capgemini / HSBC UK
Domain FS Business Investment Banking
Duration Jan 2014 – Till Date Role Automation Consultant / Lead
Project Abstract RIMS is one of the SunGard Product which is used by HSBC for performing many validation, calculations and verifications on daily trades that are booked. It manages all aspects of Trade flow after it has been created.
Some functions performed are like validation, Verification, Reconciliation and enrichment of Trade data and sending and receiving acknowledgement files from other systems.
Responsibility
Responsible for Development/Test Planning of Automation regression pack from scratch, review of system test plan and system test specification documents.
Responsible for designing Automation Strategy.
Responsible for designing Automation Framework from scratch.
Responsible to capture customer Requirement for enhancement.
To automate Process for Data to be submitted using QTP or VB Scripts.
Review of results and check if 100% automation can be achieved using QTP/VBA.
Automate and Review of test cases and test plan document to ensure that all scenarios are covered as per the design document.
Identify test cases which are useful in daily run and combine them in regression test pack which are scheduled at regular intervals using QTP.
Analyze different Data issues and provide solutions and reports to customer.
Identifying testing issues through automated/semi-automated process.
Reduce errors due to manual interventions & also improve the speed.
Responsible for trade booking via Bloomberg.
2) Project Name UK Business Migration
Project Type Billing/Migration Company/Client Tech Mahindra / BT
Domain Telecom Business Billing
Duration Jan 2012 – Jan 2014 Role Development Lead
Project Abstract The transition from BT Retail to WLR3 is required as part of the transition program. As per the OFCOM regulations, Equivalence Management Platform (EMP) will be used by BT Retail, for raising Fulfillment and Assurance requests.
The current BT Retail lines, also referred to as BT Retail Classic lines, need to be migrated to the Open reach WLR3 stack. Once the STOP order is raised on CSS and the account have been migrated to WLR3 stack, all the billing data needs to be transferred to BAL so that it can be billed on Geneva (strategic stack).
A lot of Standalone data is transferred from IRS extraction process directly but the transition data needs to be extracted from CSS and send it to Business Access Layer (BAL)/Geneva.
Migration Controller (MC) first selects the candidate billing accounts for migration. If all the rules are met, the account is allowed to migrate..
Responsibility
Responsible to capture customer Requirement for Migration and to come out with a suitable solution.
Responsible for Development/Test Planning, review of system test plan and system test specification documents.
To automate Process for Data to be migrated using QTP or VB Scripts.
Review of results and check if 100% automation can be achieved using QTP/VBA for the data to be migrated.
Automate and Review of test cases and test plan document to ensure that all scenarios are covered as per the design document.
Identify test cases which are useful in daily run and combine them in regression test pack which are scheduled at regular intervals using QTP.
Development of GUI tools using other languages like SQL or excel with GUI to find accounts easily which are eligible for migration. These accounts are sent later for migration.
Analyze different Data issues and provide solutions and reports to customer.
Identifying testing issues through automated/semi-automated process.
Reduce errors due to manual interventions & also improve the speed of data cleanse on source data.
Reduce the no. of billing accounts blocked from migration by Data Quality issues from 50% to <20%.
3) Project Name CSS (British Telecom Billing)
Project Type Mainframe Development Company/Client Tech Mahindra / BT
Domain Telecom Business Billing
Duration Nov 2009 – Oct 2010 &
Feb 2011 – Jan 2012 Role Development Lead
Project Abstract Customer Services System (CSS) is BT’s largest computing system. It manages all aspects of Customer service from order entry through issue and fault handling to work management and billing. Following is a brief outline of CSS functionality:
Service and Resource Management functionality like Order Handling, Customer record Management, Complaint Handling, Products and Stores, Marketing feeds, Work Manager Interface, Time and Job Recording.
Network and Repair Management functionality like Exchange systems, Access systems, Customer Information, Address Repository, OM interface, Repair Handling, Line Testing, Directories
Billing functionality like In-feeds, Call Itemization, Main Billing, Allied Billing, Bill Production and Formatting, Receipting, Follow-up and Debt management.
Responsibility
Member of Development & Testing Team.
Carried out Development, System Testing, Regression Testing, E2E Testing and Integration Testing.
Analyze customer requirements for feasibility & capture requirements in totality considering all explicit and implicit requirements.
Prepare and review Low level design documents. Ensure that design and assumptions are clearly mentioned in design documents
Code and develop artifacts in mainframe application.
Ensure that all artifacts adhere to agreed standards and follow standard development methodologies.
Have automated test scripts using QTP and VB Scripts to increase automation in testing.
Preparation and review of all sign off documents, code deliverables, and checklists.
Interaction with customers & giving DU presentation to notify the customer of the changes.
Attended Post Implementation call, UCT (User Confidence Testing) progress call with Delivery & Deployment Team and provide support to external teams.
Analyze the queries rose by external teams and customers and provide the solution for the same.
Handled issues raised by deployment and ASG when working in shifts.
Analysis of live data from on-site co-ordinates for better understanding of live scenarios during testing enrolled in the release.
Have good knowledge of Basic Telecom, CIT maturity model, BT processes.
Maintained effective communication with internal stakeholders like CSS E2E Design, Development, Allied, Delivery & Deployment teams.
4) Project Name OSS- System, Telefónica O2 UK Limited.
Project Type IPD Automation Company/Client Tech Mahindra / O2
Domain Telecom Business OSS
Duration Oct 2010 – Feb 2011 Role Development Lead
Project Abstract O2 is a leading provider of mobile and broadband services to consumers and businesses in the UK. The company is the leader in non-voice services, including text, media messaging, games, music and video, as well as data connections.
IPD is integrated planning and data build tool used in OSS domain of O2. This tool is used for Transmission and Radio planning & for Data builds output.
Responsibility
Member of Development & Testing Team.
Carried out Development, System Testing, Regression Testing, E2E Testing and Integration Testing.
Analyze customer requirements for feasibility & capture requirements in totality considering all explicit and implicit requirements.
Prepare and review HLD and LLD documents. Ensure that design and assumptions are clearly mentioned in design documents
Code and develop artifacts in QTP & VB.
Automate IPD application using QTP & VB.
Ensure that all artifacts adhere to agreed standards and follow standard development methodologies.
Preparation and review of all sign off documents, code deliverables, and checklists.
Analyze the queries rose by external teams and customers and provide the solution for the same.
5) Project Name Pulse Monitoring System
Project Type Web Development Company Acme Digitek Solution Pvt Limited
Domain ERP Business Billing
Duration July 2008 – Oct 2009 Role Software Developer
Project Abstract The project deals with the design and development of a various Monitoring Application (e.g. Sales, Purchase, Purchase Order, AMC, Complaints, Dak Monitoring, Lab Monitoring) developed under JSP.
It is a MIS system developed for monitoring various activities in organization. The project has a menu system which is user interactive and capable of holding large amount of database with the help of MY SQL.
Since it is web based a customer who has bought items from that company can register their complaints if there is any problem with their product.
A customer can also see whether the product that he/she has taken under AMC has been regularly checked or not and what will the dates on which the service person will come to see product.
Responsibility
Member of Development Team .
Analyze customer requirements for feasibility & capture requirements in totality considering all explicit and implicit requirements.
Code and develop artifacts in Web Based application.
Ensure that all artifacts adhere to agreed standards and follow standard development methodologies.
Preparation and review of all sign off documents, code deliverables, and checklists.
Analyze the queries rose by external teams and customers and provide the solution for the same.
Continuous customization according to the customer’s requirement for the desired system
Automation Tools
Project HSBC – MIS Infrastructure Duration Sep 2015 – Sep 2015
Language Visual Basic 6 Client HSBC
Details Front end using VB6. Define source DB and Target DB. Auto-Generate SQL query. Compare DB data and Schema. Increased work speed up to 1000% compared to manual method on a daily basis and reduced Manual Efforts from around 10 PDs to 1 per release. Human errors caused during system and regression testing is reduced by 100%.
Project HSBC VISA Simulator Duration October 2014 – Jan 2015
Language Visual Basic 6 & QTP Client HSBC
Details Front end using VB6. Input data for migration is from XLS file All necessary data is taken as input from XLS file, processed and then entered in VISA Simulator which was then validate on Mainframe. HTML Reporting functionality, tracking features included. Increased work speed up to 666.66% compared to manual method on a daily basis and reduced Manual Efforts from around 20 PDs to 3 per release. Human errors caused during system and regression testing is reduced by 100%.
Project UK Business Migration Duration May 2012 – June 2012
Language Visual Basic Client BT
Details Front end using VB6. Input data for migration is from XML file and Oracle Database. All necessary data is taken as input from XML file, processed and then displayed in a tree view per account. With this one can check and cleanse for any data discrepancy in the account that is sent for Migration. One can also check for any format change in XML if any. Had feature to compare two XML’s for data and structure difference.
Project UK Business Migration Duration Feb 2012 – May 2012
Language Visual Basic Client BT
Details Automated UKB data quality team work to speed up cleansing work. Data is received from business which is to be analyzed and then solutions is proposed using data from different systems. Auto analysis engine included for proposing solutions which occur frequently. Reporting functionality, tracking features included. Increased work speed up to 300% compared to manual method on a daily basis.
Project IPD Automation Duration Oct 2010 – Jan 2011
Language QTP & Visual Basic Client O2
Details Automated IPD application to speed up testing work. Application contained Transmission and Radio planning data which was needed to be tested regularly, hence application was automated and scheduled to check for data. Auto reporting engine included for reporting error in application build which occur frequently. HTML Reporting functionality, tracking features included. Increased work speed up to 400% compared to manual method on a daily basis and reduced Manual Efforts from around 10 PDs to 2 per release thereby saving in a year 32 PDs in case of quarterly releases of the IPD application Human errors caused during system and regression testing is reduced by 100% The data built by the application contains many XLS’s that needs to be compared with that of the previous build. This comparing was done manually before which sometimes caused human errors. Now the whole XLS’s are compared automatically which reduced the defects by 100%. This XLS comparing feature is built in such a way that it can used to compare any XLS’s of any application.
Personal Information
Name : Anurag Agarwal
Father’s Name : Sri Rajiv Kumar Agarwal
Date of Birth : 25th May 1986.
Languages Known : English and Hindi
Interests : Travelling, Networking, Cricket, Swimming
