SUMMARY

• Over 6 years of professional experience in the IT Industry using advanced SQL coding, over varied platforms like Teradata, Oracle and SQL server for data mining and report generation.
• Extensively used Informatica and Teradata utilities to maintain and move data between platforms.
• Well versed with the process of data/table archival on mainframe platforms.
• Provided production support to existing reports and involved in various enhancement to reports.
• Excellent in data analysis and identifying issues while report creation from several and complex data sources.
• Developing SQL queries for data extraction.
• Meeting the end users on one to one basis and making them understand the technology and understanding the Business Objects universe model and administration.
• Good knowledge of defect development process, test plan, test criteria, test case, and various test types such as GUI Test, Integration Test, and Beta Test.
• Experienced in cooperating with BA to create business requirement document, functional and non - functional requirement document and use case.
• Experience in business requirement gathering that would best suit the needs of technical architectural development process.
• Identify, analyze, and interpret trends or patters in complex datasets and present complex information in an understandable and compelling manner.
• Created numerous stored procedures and macros to implement functions not available on certain platforms.
• Excellent in query performance tuning and finding issues with resource intensive queries.l mbn
• Able to communicate effectively with multifunctional teams, programmers and technical staff at all levels. Strong customer service orientation. Experienced in consulting with users, resolving problem and meeting specific technical and business needs.
• Participated in requirements analysis reviews and Design sessions to understand the requirements and designing Reporting Solutions.
• Committed team player, with excellent communication skills and self-starter, capable of working independently. Good problem solving skills, attention to detail, better initiative and judgment. Good business understanding and effective at working across multiple teams within an organization.

TECHNICAL SKILLS

Operating System: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix

Databases: Oracle 9i, 10g, 11g, MS SQL Server 2005/2008/2012, Teradata 12/13, My SQL 5.2

ETL/Other Tools: Abinitio, SAS 9, Informatica Power Center 8.6.1/9

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

Scripting: SQL, PL/SQL, Java, UNIX Shell Script

Querying Tools: SQL Server Management Studio 2008/2012, Teradata SQL Assistant, SQL Developer, Teradata-BTEQ, Teradata FastLoad, Terdata multiload, Teradata TPUMP, Quest TOAD 9.1.

Others: Access, Excel, and Power point

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. ETL / Data Warehouse Tester

Responsibilities:

• Conducted and attended story review meetings with Business team to gather requirements and prepare test cases.
• Prepared Test Plans, Test Strategies, and Test Scenarios for ETL and Reports testing.
• CreatedTest cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• PerformedSmoke Testing, GUITesting, FunctionalTesting, Backend Testing, System Integration Testing, Sanity Testing,andUser Acceptance Testing (UAT)
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Used Informatica workflow manager to run the workflows and workflow monitor to check the status of workflows.
• Developed test plan with testing scenarios from theend user perspective for User AcceptanceTesting (UAT).
• Extensively used Informatica Workflow Manager to run the workflows.
• Tested the ETL Informatica mappings and other ETL processes.
• Scheduled batch jobs through AutoSys.
• Monitored the autologs and session logs through Informatica Workflow Monitor.
• Loaded the source data (flat files, XMLs, etc.) to the staging tables in the form of ad-hoc loads through SQL Loader and Informatica.
• Worked with mainframe source file systems for various interfaces.
• Tested whether the ETL code was able to load data into the interface-specific tables and wrote test cases for the same.
• Opened incident tickets and change request tickets using BMC Remedy.
• Worked on data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Validated the web services using Soap UI.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Used Rational Clear Quest and HP Quality Center as defect tracking tools.
• Before the load is accepted to test, have performed smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 11g, Informatica Power Center 9.1, Informatica Data Validation Option (DVO), Clear Case, Clear Quest, Cognos 10, SQL, PL/SQL, UNIX, Putty, TFS, Flat files, XML, XSD, XSLT, Quality Center, Web Services, Soap UI, Agile, SQL Server 2008, DB2, Rapid SQL

Confidential, Hartford, CA

QA Tester / Data Analyst

Responsibilities:

• Maintained data consistency, database integrity and reported instances of data corruption.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for reports.
• Implemented business rules on data using Stored Procedures, Functions and Packages.
• Worked extensively on SQL Server 2005/2008
• Solid program development and business process knowledge - utilized effective communication skills
• Performed data quality checking.
• Used Teradata OLAP functions like random, qualifies, top n, c sum, sample and random. Teradata SQL performance tuning.
• Data migration between different environments and Third Party Databases.
• Using Oracle SQL, SAS procedures, packages, functions, database triggers to developing and execute MDM reports for performance and response purposes
• Converted various SAS DATASETS into Teradata tables and vice versa after doing the necessary Data Cleaning/Scrubbing and Data Validation.
• Extensively used SAS functions such as Proc Report, Proc Tabulate, Proc Summary, Proc Print and Data Null Reports.
• Experience in using SAS to import data into and export data from Teradata tables.
• Created drill down analysis reports using SQL Server Reporting Services.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERwin 4.0/3.5.2/3. x, ER Studio.
• Extracted data from Teradata and Oracle and created pivot tables in Excel.
• Created Transformations and Mappings by using Informatica Designer
• Processing tasks using Workflow Manager in order to move data from multiple sources into targets.
• Examines existing data and makes recommendations for improvement/efficiency. Resolved requirements and design issues.
• Involved in meetings with director of analytics, project manager and other stakeholders to identify the cost associated, values delivered and break even time
• Worked on analysis of the Facets claims processing application in order to gather requirements to comply with HIPAA 5010 requirements.
• Analyzed HIPAA 4010 and 5010 standards for 837P EDI X12 transactions, related to providers, payers, subscribers and other related entities.
• Identifying the requirements for accommodating HIPAA 4010 and 5010 standards for EDI X12 transactions and capture these requirements for mapping purposes.
• Mapped the standard 4010 and 5010 elements to the associated Java classes for rules processing
• Mapped the Bloodhound tool (clinical editing tool) related data elements to the internal XML elements.
• Created the data dictionary for the clinical aberrancy rules
• Participated in the testing process, ensuring testing verifies the user requirements.
• Works to continually improve the quality and efficiency of business systems
• Aided in management and documentation of all project deliverables as well as training knowledge based articles.

Environment: Oracle, JavaJ2EE, Requisite Pro, Quality Center, Informatica MDM, XML, MSOffice, Visio, Loadrunner

Confidential, Austin, TX

Data Analyst

Responsibilities:

• Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures.
• Prepared the business requirement document (BRD) and system requirement document (SRD).
• Managed all aspects of project management: resource planning, estimate hours, work breakdown structure, implementation planning, testing and communication etc.
• Facilitated Provider Enrollment, Setting up Provider profile & Trading Partner Agreement.
• Set up Provider's Access to the System. (Security Setup).
• Helped creating Provider Reports i.e. Financial, Claims processing.
• Prepared the Business requirement Document for the enhancement of the existing services.
• Wrote FRDs for the defects and enhancements and got approval from business for the developers.
• Worked on Technical design documentation (TDD) of the claims processing system.
• Performed task estimations and documentation of procedures.
• Designed, prepared and implemented test cases for system testing as well as for User Acceptance testing.
• Involved in the testing of web portal of New MMIS system.
• Conducted integration testing and regression testing with developers in development and QA, also conducted user acceptance testing with UAT team. Safety reporting on system-based projects, acted as a liaison, writing documentation and increased project coordination.
• Analyzed and documented system release/deployment issues according to version management, backward compatibility, load balancing of components in production environment.
• Did impact analysis for changing requirements and coordinated with business users for prioritizing the testing/release of the changes.
• Maintained a very close interaction between business users and developers to avoid any gaps in understanding or implementation of requirements.
• Did data analysis, created data mapping and data interface documents and kept the documents updated with changes in requirements and functional specifications.
• Performed Risk Analysis based on defect severity and priority
• Tested User Interface inconsistency and application functionality
• Developed Reports and Graphs to present the Stress Test results to the management
• Wrote VB script for automated testing in QTP
• Stepped in when requirements were not moving forward and mentored analysts on documentation, facilitation and agile processes.
• Created BPR charts for AS IS and TO BE processes of different business functionalities
• Research, Analysis and Recommendations based on Lean and Agile principles to assist Texa Medicaid to improve its internal time-to-market for IT Projects.
• Using Oracle SQL, SAS procedures, packages, functions, database triggers to developing and execute MDM reports for performance and response purposes
• Experience in using SAS to import data into and export data from Teradata tables.

Environment: Oracle, JavaJ2EE, Requisite Pro, Quality Center, XML, MS Office, Visio, Loadrunner

Confidential, Milwaukee, WI

ETL / BI Reports Tester

Responsibilities:

• Worked as an ETL/BI Report Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Developed Test Plan and Acceptance Criteria.
• Involved in Business Functionality Review meetings, JAD Sessions and Use-Case Analysis.
• Followed Agile testing methodology and performed testing in each sprint.
• Experience with executing both functional, usability and deployment testing
• Attended daily Scrum calls for status report
• Extensively participated in Sprint retrospective for improved process
• Performed both Manual and Automation testing
• Conducted SIT, System, Functional, GUI and UAT Tests
• Tested the Patient Management in EPIC
• Tested the Patient scheduling in Cadence (EPIC).
• Tested Lab Orders, Transfer of patients in EPIC.
• Tested the Billing (Professional/Hospital) and claims.
• Validated the claims for Medicare.
• Extensively mapping the requirements to test cases -- Traceability Matrix.
• Involved in Validation of EDI Transactions (834, 837, 835, 270, 271, 276, 277, 997)
• Extensively worked on EDI 837 and 835 for Claims.
• Enhanced the automated Regression Scripts and Conducted Data Driven Testing.
• Tested the ETL (Extraction, Transformation and Loading) process using Informatica.
• Performed Schema validation, inbound and Outbound Data Validation.
• Tested the source, Target databases, mapping and Transformations.
• Worked with data files (Flat Files, XML, SAS) Data files.
• Performed Data Validation and backend testing by writing SQL queries.
• Tested the reports generated using Business Objects.
• Responsible for validation of user credentials and password validation for web portals.
• Supervised the use of Rational ClearQuest for Defect Reporting.
• Responsible for preparation of weekly status report.

Environment: EPIC Suite 2010, Rational ManualTester, Rational Clear Quest, Abinito, Business Objects, ASP.NET, VB.NET, IIS, SQL, SSIS, SQL Server 2005, Mainframes, XML, IDM, Oracle 8i, SQL Navigator, Windows NT, XP, Unix, QTO, Agile