OBJECTIVE

• To obtain a challenging and high performance oriented role in the field of Data Analysis and implement the expertise gained in this field to develop complex work with efficiency and quality.

SUMMARY

• Extracting and massaging data from relational databases using SQL statements (DDL,DML,TCL,DQL) in Microsoft SQL Server 2012
• Created data model diagrams, process flow diagrams in MS Visio along with documentation
• Perform iOS Automation testing using Instruments tool
• Solid understanding of Conceptual, Logical and Physical Data Models
• Analyze methodologies and framework for data analytics, report generation, database management and querying
• Performed routine maintains on SQL Server databases
• Create and maintain reports to aide decision making using tools like Crystal Reports, Microsoft Reporting Services, Excel, MS Access, Dev Express Report Designer
• Extensively worked on Normalization and De - Normalization techniques for both Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Experienced in creating tables, indexes, constraints (Primary Key, Foreign Key, and Unique) and writing complex T-SQL queries and complex joins.
• Experienced in programming T-SQL Stored Procedures, Views, Triggers, and Functions.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled SQL jobs to call the packages to execute the stored procedures.
• Excellent verbal and written communication skills with interpersonal and analytical skills.

TECHNICAL SKILLS

• HP Testing Suite
• Quality Center 9.0/9.2/10.0
• Quick Test Professional
• Rational Performance Tester
• Load Runner
• Clear Quest
• HTML (with CSS)
• VB script Crystal Reports 9
• MS Access
• MS Excel
• Vlookup
• Pivot table
• MS Word
• Power Point
• MS Visio
• Virtual Source Safe
• Questionnaire Developer 3.15.4.0
• Bloomberg Terminal
• Quodd equity
• Mat lab
• Net X 360
• Air watch

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, New York

Responsibilities:

• Extracting and massaging data from relational databases using SQL statements (DDL,DML,TCL,DQL) in Microsoft SQL Server 2012
• Create and maintain SSIS package
• Created data model diagrams, process flow diagrams in MS Visio along with documentation
• Performed iOS Automation testing using Instruments tool
• Solid understanding of Conceptual, Logical and Physical Data Models
• Analyze methodologies and framework for data analytics, report generation, database management and querying
• Performed routine maintains on SQL Server databases
• Create and maintain reports to aide decision making using tools like Crystal Reports, Microsoft Reporting Services, Dev Express Report Designer, Excel, MS Access

Environment: HTML (with CSS), Crystal Reports 9,DevExpress Report Designer, MS Access, Virtual Source Safe, Questionnaire Developer 3.15.4.0, Air watch, iOS Instrument in XCode, SQL Server Management Studio

Equity Research Intern

Confidential, New York, NY

Responsibilities:

• Analysis of company Financial data and stocks
• Research on upcoming developments for investment opportunities
• Evaluate new business opportunities and make meaningful recommendations to management
• Provide timely reporting and analysis as it relates to the monthly business review
• Manage client portfolio using NetX360 application

Environment: Bloomberg Terminal, Quodd equity, Mat lab, Net X 360

Senior Quality Assurance Engineer

Confidential

Responsibilities:

• Involved in test scheduling, formulated test plan and execution strategy for system testing.
• Involved in review testing artefacts (Test Cases and Defects)
• Involved in defect logging and co-ordination with the development team to get the defects to closure
• Involved in Perform System Test Execution Kick Off, Test execution, report weekly test results
• Develop and update Test Scenarios, and Test Cases based on the System requirements document.
• Performed various types of testing, such as functional, regression, user acceptance
• Worked with development teams investigating and correcting software bugs and deficiencies based on the testing results
• Coordinate Inter-System Testing and User Acceptance Testing

Environment: HP Testing Suite (Quality Center 9.0/9.2/10.0 , Quick Test Professional), Rational Performance Tester, Load Runner, Clear Quest

QA - Performance Tester

Confidential

Responsibilities:

• Formulated test execution strategy for Load and stress testing
• Creation of test plans, questionnaires, performance reports and signoff presentations for the client
• Create automated performance test scripts using IBM's Rational Performance Tester, Monitor test execution and report weekly test results.
• Document recommendations or risks from application performance standpoint by identifying performance bottlenecks
• Create and manage Internal quality management documents, SPCA charts and RCA statistics for the team and participate in Project Management Review (PMR) meetings
• Conducted internal audits and facilitated external audits and Project management Review (PMR) meetings

Environment: Rational Performance Tester, Load Runner, Application Lifecycle Management (Quality Center), Amdocs Billing Application

Quality Assurance Analyst

Confidential

Responsibilities:

• Created test scenarios/test cases for Change requests for Client
• Maintain Traceability Matrix -through test scenarios with Business SMEs, test cases with Test Analyst and development team
• Involved in Document application, business knowledge and Business Domain Training for new team members
• Analyzed and reviewed the software requirements, functional specifications and design documents for Plan Enrollment and Management Interface
• Interacted with the SME and stakeholders to get a better understanding of client business processes
• Involved in creating test plans and developing test cases from Business Requirements
• Created SQL queries to verify data in the DB and consistency with system reports
• Analyzed, documented and maintained Test Results and Test Logs
• Initiated project quality audit for compliance; identified and implemented opportunities for improvement

Environment: HP Testing Suite (Quality Center 9.0/9.2/10.0 , Quick Test Professional), UNIX, My SQL, 4G Ingress Database