USHA PADGHANE

Data Analyst

Email: ac4dcs@r.postjobfree.com:ac4dcs@r.postjobfree.com Contact: +1-469-***-****

Location: Dallas TX.

SUMMARY

* ***** ** ********** ** Data Analyst & Developer.

5 years of experience in Data Analyst using SQL, SAS, Oracle, Tableau.

Completed course in Data Analytics from Virginia Commonwealth University(VCU) in 2014

Experience in Banking and Financial domain as well as successfully executed, designed, developed commercial lending products

Knowledge on the Data bases like Oracle and SQL Server and have good troubleshooting and debugging skills. Working experience in writing SQL for validating complex business rules.

Promoted as Deputy Manager – Information Technology to manage team, with other responsibilities such as task delegation, providing technical support, task assessment & ensuring on-time delivery.

Worked on development of agile software including Scrum and extensively worked in all phases of software development lifecycle.

Adapt in learning new technologies and quickly adapting to new environment.

Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications.

A proactive team player with superb communication & presentation skills who demonstrates the highest levels of integrity in both personal & professional spheres of endeavor to build successful and strategic relationships.

TECHNICAL EXPERTISE

Operating Systems: Windows 2003 Server / 98 / XP / Windows 10

ETL Tools Working knowledge of Informatica, Jasper ETL,

Programming Languages SAS / C / C++ / Working knowledge of Python

RDBMS: MS-SQL Server, Oracle SQL & PLSQL, Sybase, MYSQL

Banking Domain Product: Finnone, Finware, LOS(Loan Originating System)

Office Automation: MS Excel, Word, PowerPoint, MS Access

BI Tool Tableau, SOAP UI

EDUCATION

Bachelor of Technology in Information Technology, Mumbai, INDIA-(2007)

PROJECT EXPERIENCE

Data Analyst HANSA CEQUITY SOLUTIONS – Mumbai Axis Bank (Dec 2011-May2013) PROJECT: Gold Mohur Campaign, Valentine Day Campaign, Car Loan, Preparing of Dashboard

RESPONSIBILITY

Implemented Dashboard for Birla Sun Life Insurance for tracking the profit and growth of the company on monthly basis.

Improved Development productivity by 20% because of implementing reusable codes.

Improved the business by 10% because of applying Analytical skills to various campaign.

Conducted pre-sales activity like preparing a demo for the clients, based on their requirements to showcase the product features.

Independently worked on adhocs request and effectively delivered to the client on high priority

Handled the responsibility of Senior Business Analyst in his absence by preparing and giving presentation on the project status to the client on weekly basis.

Perform periodic update on the Project status and the risks involved and approaches on it.

Prioritizes and tracks activities effectively to meet commitments and schedules.

Environment: SAS 9.2, Teradata, SQL, Oracle 10g, Tableau 7/8, MS Excel, MS Office

HDFC BANK LTD. - Mumbai

Deputy Manager (Data Analyst)-Business Solution Group – IT (Jan 2008 – Dec 2011)

PROJECT: Debit Score Card for Cross selling Campaigns, Life Cycle Analysis of Credit Card, CTG(Commercial Transport Group) Scorecard, Loan Eligibility based on CIBIL Score

RESPONSIBILITY

Implemented multiple scorecard like Debit Scorecard, Commercial Transport Group Scorecard for bringing more and more customers to the bank.

Responsible for gathering requirements from the client business team and technical team about various business scenarios and providing solution for meeting business needs.

Key person of contact (SME) for any questions and concerns about the application for the assigned project

Involved in the initial discovery/analysis phase for various projects to get understanding during the project initiation phase.

Responsible for coordinating with the Risk team and reviewing the plan for various project to be executed.

Increase the business by 20% because of Debit Scorecard, CTG Scorecard and Cibil Score.

Independently developed the Data Dictionary of the banking system this was a great help to the new joiner in understanding of database.

By single-mindedness, worked on significant, analytical and crucial data of searching and documenting the fields, Coordinated and taken follow ups from various team for the purpose of getting clarifications of various different table names and fieldnames available in database which required extra hard work.

Converted most of the monthly activity in Jasper ETL tool thereby increasing productivity by 30%.

Created a utility which had led to save time of executor as they don't have to manually do the work.

Maintaining a base in Risk database since these cases are not available in database. This was the huge requirement of the team which helped most of us to avoid the bad circumstances caused by non availability of data. These helped my team members to carry out their activities successfully which reduce their time required to execute the request. Received good amount of suggestions from rest of the team which was well implemented, this required effective conversation and careful audit of the data. Month on month updation of this base carried whenever EOM is up.

Environment: Oracle 12c/11g, SQL, MS Excel, MS Office

Contact this candidate