We provide IT Staff Augmentation Services!

Data Analyst Resume

2.00/5 (Submit Your Rating)

SUMMARY

  • 5 Years of experience as 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.
  • Worked as Deputy Manager - Information Technology to manage team while providing technical support, task assessment & ensuring on-time delivery.
  • Worked on agile methodology and in all phases of software development lifecycle.
  • Excellent Analytical skills to understand the business processes and to translate business requirements to system requirements.

TECHNICAL SKILLS

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 Java and Python

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

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

BI Tool: Tableau, SOAP UI

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential

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, Tableau 7/8, Teradata, SQL, Oracle, MS Office

Data Analyst

Confidential

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, SQL, MS Office,

We'd love your feedback!