Worked as Senior QA/Data analyst Resume COLORADO - Hire IT People

SUMMARY:

Experience in entire software development lifecycle of software design, analysis, development, testing, Implementation, Maintenance and Technical Support
Excellent Analytical, Organizational, Problem solving, Interpersonal Communication and Managerial
Skills including decision making, team building, project management & client handling.
Extensive experience in Software Data Analysis/Data Modelling/Data Reporting/Data Extraction/Data Mining.
Experience in Database Design
Did Data Governance/Data Management/Data Cleansing/Ensuring Data Quality/Tracing Data Lineage
Adept in Data Validation/Data Cleansing/
Expert in Data Collection/Data Optimization/Data Tuning of SQL queries/Data Mapping in ETL
Identifying Data Trends and Data Patterns using Data Visualization tools
Experience in writing/tuning complex SQL in DB2, Oracle and SQL Server
Design and create Management Reports, both ad - hoc and scheduled.
Self-motivated and able to work without supervision.
Time oriented/Result oriented/Detail Oriented/Accuracy Oriented. Flexible and a team player
Assisted in Root cause Analysis in debugging production issues.
Advanced experience with Microsoft Office Suite including Visio.
Ability to work concurrently on multiple projects.
Experience training Junior Staff.
Did Regression, Unit, System, Performance, Black box, white box and UAT testing
Developed test plans, test cases, test scripts & test strategies

TECHNICAL SKILLS:

Programming Languages: Cobol, VBA, PL/SQL, XML, T-SQL, SAS

Databases: DB2, ORACLE, MSAccess, VSAM, SQL serverTERADATA, PL/SQL

ETL tools used: IBM Datastage,Informatica,SSIS

BI tools: TABLEAU, POWER BI

PROFESSIONAL EXPERIENCE:

Confidential, COLORADO

Worked as Senior QA/Data analyst

Responsibilities:

Design, Create and Analyse ad hoc queries/reports on Oracle, DB2, SQL Server and MS Access to team and other departments.
Expert in writing/optimizing complex SQL queries in T-SQL,PL/SQL and stored procedures.
Did Management reporting for Director/VP using Microsoft Powerpoint used to identify trends and patterns in Membership and Claims.
Developed Tableau visualizations/dashboards and workbooks using Data Blending.
Develop, manage and present TABLEAU/Power BI/COGNOS graphs, charts and dashboards.
Supported in-house VBA applications.
Acted as a technical resource for teh team. Assisted teh team in root cause analysis when prod issues arose. Proficient in SSMS, SSIS, SSRS & SAS
Identified data anomalies and resolved them.
As a Data Analyst, developed E-R diagrams, Data Flow diagrams and UML diagrams

Confidential, COLORADO

Senior QA/Data analyst for Visa

Responsibilities:

Doing QA on Financial Systems applications like prepaid cards, credit cards and debit cards
Participate in Design and requirements ambiguity reviews.
Worked in Agile work environment.
Mentored Junior QA testers
Work with Developers and Business Analysts in understanding requirements
Build use cases and provide testing estimates.

Confidentia, COLORADO

Senior ETL QA/Data analyst

Responsibilities:

Did QA on Health care ETL applications
Wrote Test Plans, Functional Specification Documents (FSD)11
QA done for ETL datawarehousing applications using Informatica and UNIX
Worked in Agile work environment
Work with Developers and Business Analysts in understanding requirements
Worked as QA/Systems/Data analyst in Business and mortgage Banking Applications. These include mainframe,client server,web based,windows & data warehouse applications
Did QA on Business and mortgage banking applications(loan origination and closing) on teh web and intranet
Gather project requirements.Assist in converting business requirements into
Technical requirements. Worked as Systems Analyst and Data Analyst
Used Oracle/Sqlldr/SQL Server 2008,Teradata,SAS
Change Control using Rational Clearcase, Remedy(PAC2000)
Writing simple UNIX shell scripts, Oracle PL/SQL stored Procedures
Used tools like Putty, Datastage,Winscp,Informatica
QA done for Mortgage applications supporting mortgage underwriters,loan officers,applicants
Familiar with RUP & Agile methodologies

DISH NETWORK

Confidential, COLORADO

Responsibilities:

Worked as a QA Analyst with a team of 8 offshore team members
Did QA on web-based billing and CRM applications
Wrote Test Plans, Test Scripts in Mercury Quality Center from Business Requirements
Document (BRD) and Functional Specifications Documents (FSD)
Identify, evaluate, and resolve highly complex test problems
Set up test data & test environment
Mentor less experienced staff members
Served as a coordinator for all test activities
Provide Status Reports and Test Metrics to Management
Experience with Project Management