PROFESSIONAL EXPERIENCE

• 6+ years of experience in the IT domain
• Good experience with Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
• Familiarity with multiple development and testing methodologies like Waterfall, Agile etc.
• Very good experience with developing test plan, test cases and RTM ( Requirement traceability Matrix)
• Experience with preparing test data by executing SQL queries and joins.
• Good Experience in writing SQL queries using TOAD and other tools based on the need.
• Practical experience with Quality Center / HP ALM to develop Test plan, test cases, executing test cases in Test lab, and creating and tracking defects in Defects module.
• Experience with preparing reports to track the execution of Test cases and defects.
• Good experience with UNIX / Linux commands, FTP Tools like WinSCP, File zilla etc.
• Experience with WebServices, SOapUI tool, XML, Validating request and response XML, SOAP and RESTFUL WebService calls.
• Experience with QTP / HP UFT to develop automation scripts in VB Script
• Experience with QTP - Object repository, Checkpoints, Actions, Functions, regular expressions, parameterization, transactions, Object spy, function library,
• Experience with different testing methodologies.
• Experience with Regression testing, User acceptance testing,(UAT), Functional testing, blackbox testing techniques, System testing, Unit testing, Smoke testing, sanity testing, performance testing, load testing, stress testing, Exploratory testing, browser compatibility testing, integration testing, cross browser testing,
• Experience with data driven testing,
• Experience with HP Loadrunner - VUGen, Controller and Analysis tools for performance testing ( Non-Functional Testing)
• Experience with ETL Testing - Extract - Transfer - Load, Data warehousing concepts, Familiarity with Mapping documents, OLAP, OLTP, database schemas, Star schema, snow flake schema, data marts, dimension tables, galaxy, fact table.
• Experience in informatica Power Center
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Using InformaticaPowerCenter created mappings and mapplets to transform the data according to the business rulesMS BI( SSIS,SSRS,SSAS)
• Knows how to Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS)
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Designing SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• knows how to Extract Transform Load(ETL) development Using SQL server 2012, SQL 2012 Integration Services(SSIS)
• knows how to generate several drill down and drill through reports using SSRS.
• Familiar in creating Parameterized reports and Linked reports.
• Knows how to generate several drill down and drill through reports using SSRS.
• Good Technical and problem solving skills
• Solution oriented, willing to learn new things, quick and enthusiastic learner
• Team Spirited, proactive, independent and responsible
• Proven organizational and management skills
• Works well under pressure and consistently meets deadlines and targets while delivering high quality work
• Extensive exposure of working with multi - cultural teams.

TECHNICAL SKILLS

QA Testing: SQL, Quality Center / ALM, QTP / UFT, LOadRunner, WebServices,MySQL, Linux

Data Warehousing: Informatica Power Center

MS BI: SSIS,SSRS,SSAS ETL Testing

Erp Software: Agresso Business World

PROFESSIONAL EXPERIENCE

Project Engineer

Confidential,  Atlanta,GA

Responsibilities:

• Used Informatica as an ETL Tool for Developing the Data Warehouse
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Using InformaticaPowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.

Confidential

Developer

Environment: Application: Informatica Power Center

Responsibilities:

• Worked as a developer to develop certain mappings and workflows using Informatica tools
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Mana

Confidential

Tester

Responsibilities:

• Writing Scripts to pull the pre and post masked data from different databases i.e Teradata,Oracle, DB2 etc.
• Working on Validation between the pre and post masked data
• Discussing the defects with the clients

Confidential

Senior Implementation Consultant

Responsibilities:

• Provide necessary Implementation Consultancy, Technical (customization) and training Services On AgressoBusinesWorld
• Debugging and troubleshooting the by Giant Savings Extension">application.
• Performing knowledge transfer with client personnel by developing appropriate documentation
• Agresso Business World (ERP) Installation at Various Clients
• Provide Support at office and Various Clients on all technical issues related to Microsoft, Oracle,Agresso Business World Software .
• Working on different kinds of reports according to the clients requirement using the agresso reporting too