Vba,MS-Access,VB6.0,SQL Server,T-SQL

Shubhangi Kale

Email:**********@******.*** : +1-716-***-****(M)

Experience Summary

Overall 10+ Years of Experience in the IT Industry.

Strong experience in requirement understanding and driving it through execution to deliver projects on time with quality

Strong Development and Automation Testing skills and Production Support experience

Excellent Communication Skills, Customer focused, ability to manage high volume of work

Languages: - Visual Basic 6.0, VBA, VB.Net

Tools used in Projects: - UFT, Selenium, SQL Developer, Sonar, JIRA, SVN, Confluence, Git and Teamcity

Databases: - MS Access, SQL Server 2012, DB2, Oracle and MySQL

Server:- Tomcat

Architecture Known: - MVC

Estimation techniques: - Top down/Bottom up, Agile Estimations

Operating Systems: - UNIX, Windows

Ability to handle projects independently and lead teams

Handled Team of 7 people and met project deadlines according to business and management needs

Hands on and in-depth experience in Visual Basic 6.0, VBA (macros), VB.Net, Unix, SQL Server

Strong Banking, Telecom and Health care domain knowledge.

Education

Graduation/Post Graduation

Specialization

Month/Year Of Passing

College Name

University Name

Final %age / Grade Obtained

MCA

Master In Computer Application

March 2006

HVPM

Amravati

1st Grade

BCS

Computer Science

March 2003

Gurunanak College Of Science

Nagpur

61%

Project Experience

Cognizant Ltd. Pune Feb 2012 – March 2017

Project Name

Customer

Name

Designation/Role

Technologies/Skills Used

Magics

(Trading Application)

Barclays (Investment Banking)

Senior Associate

VB6.0,VBA,C++,Autosys, Sql server Database, Selenium, UFT,JIRA,SVN, Confluence and Wiki and Teamcity, Sonar

Overview &

Responsibilities

Project Description:

Magics application used for Trading in New York, Hong Kong, Singapore, London, Mumbai and other locations.

Responsibilities:

Analyze Business requirements and prepare Technical specifications

Development and Unit Testing

Defect fixing

Application testing

Deployment and Release activities

Production L3 support

Cognizant Ltd. Pune March 2011 – Jan 2012

Project Name

Customer

Name

Designation/Role

Technologies/Skills Used

WSS Prodiance BAU and Support

JPMorgan

Associate

VBA,Ms-Access

Overview &

Responsibilities

Project Description:

Prodiance is a third party tool which monitors and tracks changes to all WSS MS Excel and MS Access critical and highly critical UDTs. To reduce risk around UDTs. Prodiance is being rolled out for all WSS UDT users and it is mandatory that all critical and highly critical MS Excel and MS Access UDTs are monitored by Prodiance.

Responsibilities:

On-boarding UDT’s for prodiance monitoring. Remediate UDT’s to comply with prodiance policy check.

Providing technical solutions. Release coordinator.

Production L3 support

Infosys June 2007 – March 2011

Project Name

Customer

Name

Designation/Role

Technologies/Skills Used

VBA Automation

BT/P&G

Developer

VBA, VB 6.0, VB.net, MS Access, SSI reporting, Sql server

Overview &

Responsibilities

Responsibilities:

Completed multiple high level automation projects for different engagements thereby saving 15 FTE’s

Worked on different types of projects such as web-based automation, mainframe automation, FSO, OCR, Excel/Access reporting

Part of the development team for one of the high end client reporting project

Providing advanced macro trainings to new joiners

Single point of contact for any technical queries for new joiners

Understanding Ops Processes and identifying automation opportunities to save manual efforts.

Tracking and maintaining documentation, case-studies of all the projects completed by the team

Part of the testing team for testing web based applications designed by the team

Infosys June 2007 – March 2011

Project Name

Customer

Name

Designation/Role

Technologies/Skills Used

11 Days Check Automation

P&G

Developer

VBA and Web-Automation

Overview &

Responsibilities

Automated the process of downloading documents from 98 different websites as per the logic. Tool has been designed in a way that it navigates all 98 websites one by one and downloads around 2000 PDF and Word documents on daily basis and store into appropriate folders with proper naming convention.

Benefit: - 4 FTE’s Saving

Achievement: - Second runner up in PACE Competition out of 312 shortlisted projects across Infosys Level

Infosys Mar 2007 – March 2011

Project Name

Customer

Name

Designation/Role

Technologies/Skills Used

Job Allocation Tool

BT

Developer

Visual Basic, VBA, FSO, VB.Net and SQL Server

Overview &

Responsibilities

This is one of the complex projects which were designed to allocate jobs to individuals.

Designed the system which gives alters whenever documents is stored into any of 500 folders on client network (Documents are stored by automated system). We receives alert this documents were pushed by multiple standalone scripts to Infosys network and stored into SQL Database. Once document is stored, using assignment logic this used to get allocated to individual so that we do not miss SLA.

Benefit: - 2 FTE’s

Infosys Mar 2007 – March 2011

Project Name

Customer

Name

Designation/Role

Technologies/Skills Used

OCV Audit Tool

Internal Quality Team

Developer

VBA and Mainframe automation

Overview &

Responsibilities

Process of auditing was automated for one of the process. Tool used to automate mainframe steps and provide audit results of particular jobs into Excel sheet.

Designed the report template from scratch by understanding the requirement directly from client and then automating the Daily and Monthly reports using SQL Data sources.

M-tech Innovation, Pune Aug 2006 – Feb 2007

Project Name

Customer

Name

Designation/Role

Technologies/Skills Used

M-Tech Internal

Healthcare

Developer

VBA, VB 6.0, VB.net, MS Access, Sql server

Overview &

Responsibilities

Responsibilities:

Main responsibilities design and development as per client requirement.

Accountable for the design, building and maintenance of applications ordered by clients.

Responsible for all projects lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.

Determined required data by analyzing MS SQL Server databases.

Maintain Server Database backup.

Ensure projects are completed before dead line.

Achievements:-

Client Appreciation for completing one of the critical project

Second runners up award at PACE (Transformation/Automation competition at Infosys level) in November 2010

Second runners up award at PACE (Transformation/Automation competition at Infosys level) in November 2009

STAR Performer, SPOT Award

Individual Extra Miler Award 2010-11

Personal Details

Gender Female

Date of Birth 02-Nov-1981

Nationality Indian

Passport No P3580596

Mailing Address 235, Palmdale Dr 1, Williamsville, NY -14221

Personal e-mail ID **********@*****.***

Contact No. Mob +1-716-***-****

EAD Card No. EAC1790104091

Valid Date 05/18/17 To 05/17/19

I hereby declare that the information that I have furnished is authentic, and true to the best of my knowledge.

Shubhangi Kale

Contact this candidate