We provide IT Staff Augmentation Services!

Data Analyst Resume

Glen Allen, VA

TECHNICAL SKILLS

  • Experience with Ariba Analysis module reporting

  • Experience capturing and documenting end - user requirements
  • Experience supporting Tier 2 technicians and end-users
  • Experience creating functional and technical design documentation

EMPLOYMENT HISTORY:

Confidential, Glen Allen, VA

Data Analyst

Confidential is a state-of-the-art enterprise-wide loan origination system that provides functionality for every facet of the origination process, including consumer, retail and wholesale point-of-sale channels; FHA, VA and conventional product support; funding and auditing; product and pricing; electronic document management and imaging; and industry-standard interfaces.

Responsibilities:

  • Analyzed data quality requirements of a project

  • Extensive experience in data transformation, sourcing, mapping, conversion and loading
  • Install and configure Ariba application for copernic countries
  • Performed Functional testing, User interface testing, System testing, Browser compatibility testing, Regression testing, Smoke testing, Manual testing, Automation Testing.
  • Capturing and documenting end-user requirements
  • Worked closely with vendors like Wolters Kluwers Financial Service/Black Knight Financial services, RealEC and different appraisal Management Companies like Equifax, Experian, All State, Proteck, Kirchmeyer.
  • Gained extensive experience in Mortgage Appraisal process and various loan package generations, document generation.
  • Worked and supporting Tier 2 technicians and end-users
  • Received appreciation from clients specifically for my work in module Wolters Kluwers and ReacEC.
  • Represented testing team in defect review meetings.
  • Creating functional and technical design documentation
  • Worked throughout STLC which includes Developed Test Strategy, Test scripts, Test scenarios, Test Plan, Requirement traceability Matrix, Test execution.

Environment: HP Application Lifecycle Management, Ariba,, QTP, SQL Server, SAS, Quality Center, MS Office, XML

Confidential, Cranston, RI

Data Analyst

Project Description: Confidential is a core banking application to facilitate bank adjustments, Customer adjustments and Settlement process. This application deals with adjustment for customers, interbank settlement items, Teller difference, Cash in/Cash out difference, Check fraud, check collection, Research services.

Responsibilities:

  • Performed Functional testing, User interface testing, System testing, Browser compatibility testing, Regression testing, Smoke testing, Manual testing, Automation testing

  • Was part of Automation team.
  • Payment warehouse was data ware housing project, which was part of this project.
  • Conducting defect review meetings daily.
  • Capturing and documenting end-user requirements
  • Worked and supporting Tier 2 technicians and end-users
  • Involved in migrating legacy IIR data to Ariba ACM
  • Worked throughout STLC which includes Developed Test Strategy, Test scripts, Test scenarios, Test Plan, Requirement traceability Matrix, Test execution.
  • Creating functional and technical design documentation
  • Conducted Knowledge management and review process several times.
  • Handled offshore team of about 10 people from onsite, I was considered critical resource.
  • Interacting and conducting meetings with clients on daily basis.

Environment: Informatica, SQL Oracle 11g, Quality Center, QTP, Application Lifecycle Management, MS Office

Confidential, NY

Data Analyst

Project Description: Financial Advisor application provides blended financial services to individuals, businesses, and governments. This can involve investment advice, which may include pension planning, and/or advice on life insurance and other insurances such as income protection insurance, critical illness insurance etc., and/or advice on mortgages.

Responsibilities:

  • Analyzed and coded several stored procedures to resolve multiple tickets in production support

  • Designed and developed SQL queries for extracting information, trends, insights and metrics from data stored in the database in IBM DB2 and using Eclipse tool
  • Capturing and documenting end-user requirements
  • Implementing changes specific to the ANZ countries in ariba master application
  • Creating functional and technical design documentation
  • Monitored and maintained the quality of data collected in a database system
  • Worked and supporting Tier 2 technicians and end-users
  • Provided 24/7 production technical support for Financial Adviser Tools Application and Portfolio Management Application
  • Analyzed data quality requirements of a project

Environment: Mainframe, IBM DB2, Eclipse, MS Office

Confidential, Hartford, CT

Data Analyst

Project Description: Confidential is an organization that provides managed care for health insurance contracts in the United States as a liaison with health care providers. Confidential covers only care rendered by those doctors and other professionals who have agreed to treat patients in accordance with the Confidential 's guidelines and restrictions in exchange for a steady stream of customers.

Responsibilities:

  • Worked throughout Software development life cycle right from Analysis, design, coding, testing for various requirements in Life and Healthcare Insurance system related to Claims Processing, Claims Xten (QNXT), Copay, Coinsurance, Deductible, Explanation Of Benefits, Co-ordination Of Benefits, Interest penalty, Duplicate claims, Anesthesia crosswalk, Referral system, Claims Authorization, Medicare Claims, Remits, Pend codes, ICD9 codes, Modifiers, Diagnosis codes etc.

  • Estimated and reviewed service requests and projects on several parts of Claims Adjudication system in Life and Health Insurance system.
  • Guided ERP/Procurement teams to organize their data setup for Ariba
  • Worked throughout Software Development Life Cycle stage for several stored procedures in e-Publishing application, which included analysis, design, coding, testing for stored procedures.
  • Written and executed SQL queries in IBM DB2.
  • Conducted defect prevention meetings several times.
  • Analyzed number of Pend codes associated with Claims adjudication system. Based on that, calculated auto adjudication rate for pended claims. And suggested dollar savings up to $480K, by suggesting auto adjudication method for pended claims.
  • Interacted with the client on a daily basis for requirements gathering and issue resolution and supervised production support team.
  • Provided 24/7 production support for batch job runs for Claims Adjudication system.

Environment: IBM DB2, SQL Server, Mainframe, MS Office, ODS

Confidential

Automation Engineer

Responsibilities:

  • Worked as an Automation engineer to automate heating furnace for ISPAT Steel industry India, Lloyd Steel Industry India.

  • Handled complete PLC Integration in SCADA System during commissioning for heating furnaces for Lloyd Steel Industries (India).
  • Worked on software like SCADA (Supervisory Control and Data Acquisition and PLC (Programmable Logic Controller) of ABB, Siemens Company.

Hire Now