SUMMARY:

• Over 5 years of IT experience in SDLC & STLC life cycle.
• Involved in analysis, design and Quality Assurance of Web, Client - server (J2EE & .NET) applications for Telecommunication, Healthcare, Media and Finance sectors.
• Extensively used on Informatica Designer components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Expert in Waterfall Lifecycle, AGILE, Scrum project SDLC methodologies
• Excellent experience in RDBMS technologies like Oracle, DB2, MS SQL Server 2008/2005/2000/7.0/6.5 , Dbase, Excel and MYSQL. SQL Developer, TOAD, Quest Central for DB2.
• Expertise using Business intelligence reporting tools: Cognos Series 8.x/7.0/6.0, Power play, Transformer, Business Objects XI R3/R 2/6.5/6.0/5.0 , BO Developer Suite 6.0/5.0 (Designer, Web Intelligence, Broadcast agent, Supervisor, Module), Microstrategy.
• 5+ Years of experience in relational modeling and dimensional modeling (star schema and snowflake schema with FACT & Dimensions tables using Kimball and Inmon methodologies)
• Extensively used SQL, PL/SQL to create complex queries, SQL override, Stored Procedures, Triggers.
• Sound working knowledge on UNIX in writing UNIX shell scripts, File management, Running Large Volume Data loads & batch jobs and Installation of builds on Test machines
• Expert in setting up Test environments which includes Configuration, data, builds and batch job installation & execution
• Expert in Designing & Developing of Test Plans, Test Scenarios & Test Cases and Execution of Test cases
• Expert in System Testing, Regression Testing, Reliability Testing, GUI Testing, Performance Testing, Load Testing, Stress Testing, Smoke Testing, Functional Testing, End to End Testing, Compatibility Testing and Backend Testing.
• Expertise in presenting and conducting UAT’s with Business team
• Four (4) years of experience in utilizing testing tools like Quick Test Pro and Quality Center/Test Director.
• Participation of PMO meetings & CCB item calls with Business & IT team
• Strong trouble shooting, learning and problem solving skills with ability to work independently and as a team member.

TECHNICAL SKILLS:

Operating System: Windows NT/98/2000, Windows XP, UNIX (Sun, AIX, HP), and MS DOS

Servers: BEA Web Logic Server 8.1, Java Web Server

Languages: HTML, XML, Visual Basic, SQL and PL/SQL

Database: Oracle9i, Oracle10g, SQL Server 2000, IBM DB2, Sybase, Teradata and MS-Access

Internet: JDK1.3, Servlets1.4, Java Beans, Applets, JFC/Swing, HTML, Java Script1.2, CSS

Other Software: Web connector, PEGA, FACETS and TCP/IP

Internet Tech: HTML, XML, Java Script, VBScript, ASP, MQ-Series, FTP, TCP/IP, J2EE

Testing Tools: Quick Test Pro and Quality Center/ALM.

Utilities: Toad, Oracle SQL Developer, Putty, VPN, Net meeting and CuteFtp.

Configuration Management: VSS, Win CVS.

Packages: MS-Office, MS - Visio and MS-Project.

ETL: Datastage 8, Informatica 8.5, Ab Initio

Health Care: EPIC Suite, HL-7, FACETS 4.5.

Reporting Tools: Business Objects Xi R2, Cognos 8, Microstrategy for Recon Reports.

Scheduling: Autosys, Cron.

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

SQL QA Tester

Responsibilities:

• Reviewing the business requirements and working with business and requirements team for gaps found during the review.
• Writing the test scenarios based on business requirements and Business use cases.
• Developed a detailed Test Plan & Assisted in Test strategy based on Business requirements specifications.
• Involved in using complex SQL/Joins to query the Customers Database.
• Responsible for Backend testing with TOAD by comparing the Changes in the frontend application.
• Unit Tested and Validated ETL Workflows for Parameter.
• Designed and created various Test Plans, Test Cases and Test Scripts based on the application requirements.
• Analyze business requirements (e.g., business logic, Process specs, process flows). Developed test plans and test cases based on the business requirements.
• Used various SQL queries to validate the test case results for back-end test cases. Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Tested various jobs and performed data loads and transformations using different stages of Informatica and pre-built routines, functions and macros.
• Tested Informatica jobs to allow portability and flexibility during runtime.
• Tested Informatica Hashed files for extracting and write data to an intermediate file in a job.
• Analysis, Project planning, Status reporting, document review and defect entry verification.
• Written & execution of Test Cases for each functionality based on interfaces that interacting with workflow application.

Environment: Informatica 8.5, Windows XP, Oracle11G, Sybase, TOAD for oracle, UNIX, Reflections, ALM (Application lifecycle management), MS Project.

Confidential, Herndon, VA

QA ETL Test Engineer

Responsibilities:

• Reviewed business requirements for AUT Data Warehouse ETL process and working with business and requirements team for gaps found during requirements walk through.
• Reviewed Solution Specification document with the whole team.
• Created test cases and linked test cases to the functional requirements in Requirements Traceability Matrix.
• Reviewed and did the walkthroughs for test cases with the team.
• Used TOAD for Oracle for data validation using SQL queries and back-end testing.
• Used Beyond Compare tool to validate source to target files.
• Compared the data between two databases to check counts using Microsoft Access Script.
• Performed and ran ETL jobs from back-end Unix box.
• Validated business transformation logic in Databases.
• Loaded data in temporary tables for validations in SIT.
• Performed DDL, DML operations in test databases.
• Validated source to target mappings.
• Used Putty for Unix commands to view files, copy files, move files, edit files using VI Editor.
• Involved in creating change request ticket using BMC REMEDY.
• Used HP Quality Center 10.0 to state requirements, writing test cases, test runs for every iterations, logging defects.
• Executed end-to-end script for AUT DW Regression Suite from back-end XML value compared to value in database.
• Tested front-end applications with complete workflows.
• Conducted knowledge transfer sessions with new team members.
• Worked with offshore team in Michigan and Dallas.

Environment: Ab Initio, Windows XP, Oracle10G, TOAD for oracle, UNIX, Remedy, Beyond Comapare, QTP, Quality Center, ClearQuest, MS Project.