SUMMARY:

• Over 11 + Years of experience in designing,Developing,implementing testing and delivering full life cycle of datawarehousing project.
• Over 5 years’ experience in data extraction, transformation and loading data using Informatica PowerCenter 7.1.4,8.1.1, 9.0.1, 9.6 (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Informatica.
• Worked on Performance Tuning in Informatica at various levels. Targets, Sources, mappings and sessions.Employed Session Partitioning and Pushdown Optimization.
• Expert knowledge of Data warehouse and DataMart’s methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Well versed with Kimball’s methodology - Dimensional modeling, star schema in implementing Decision Support Systems
• Excellent understanding of database concepts SQL and performance tuning of queries.
• Advanced experience with extract, transform, and load (ETL) skills, including Informatica and the Data Warehouse Administration console (DAC), as well as several expert SQL skills.
• Experienced in integration of various data sources like Oracle 11g/10g/9i/8i, IBM DB2, MS SQL Server 2005/2000, XML files into staging area
• Worked on non-relational sources like Flat files and used secure FTP, SSH, Hummingbird
• Worked on Oracle PL/SQL programming, Stored procedures, creating triggers, sequence generator on the target table
• Experienced in UNIX work environment, file transfers, job scheduling and error handling
• Two years of solid experience in Analysis, Design, Development, Migration, Testing, Documentation and Implementation of Confidential application tools( Confidential 10.2/10.1,Cognos8.x, Confidential ReportNet1.1 with Framework Manager, Report Studio, Query Studio and Confidential Connection Portal)
• 5+ years of IT work experience through the entire Software Development Life Cycle, Analysis, Design, Development, Application Testing and Implementation.
• Analyze, Business and Technical specifications.Creating Test Plans, Test Cases, Test Conditions for all requirements.
• Performed Build Verification, Functional, Integration, Regression and End to End testing types
• Well versed with White Box and Black Box testing techniques
• Excellent problem solving, debugging & programming skills. Excellent logical and analytical abilities and self-learning attitude.

TECHNICAL SKILLS:

ETL Tools: SQL Server Integration Service (SSIS), Informatica Power Center 9.6, Informatica Power Exchange

OLAP/Reporting Tools: Confidential 10.2/10.1/8.3/8.4 (Report Studio, Query Studio, Analysis Studio, Metric Studio, Confidential Connection), Confidential Report Net 1.1, Transformer,PowerPlay, Access Manager

Testing Tools: Win Runner 7.5, Load Runner 6.0, Test Director 7.6, SQA Suite 6, SQA Robot, and QTP

Languages: Visual Basic, PL/SQL, Java, C, C++, C#, VB.NET, VC++, Perl,

DBMS/RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server, MS-Access, DB2,Teradata

Database Tools: TOAD 8.6, SQL plus, ERwin 4.0, Query Analyzer, SQL Assistant

Operating Systems: UNIX, Windows NT 4.0/2000 Server and Windows 98/95

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

ETL Developer

Responsibilities:

• Gathering business requirements and understanding data mart requirements.
• Coordination with data modeler to design the various schemas.
• Extensively worked on data extraction, transformation and loading data from various source and target RDBMS Data stores SQL Server, DB2, Oracle, Postgres, flat files etc.
• Created mappings and Mapplets to load data from source systems into data warehouse.
• Created and Run the Linux/Unix Shell Scripts for all Pre Post session ETL jobs.
• Extensively worked on debugger to identifying the bottlenecks and fine-tuned the mappings, Workflows and Sessions.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV/QA/PRD environment.
• Providing support to the developed jobs and providing solutions to the open tickets like incident tickets and problem tickets solving business partner problems on the data which we have loaded using ETL process and closing the tickets with proper solution.
• Part of the team researching on data integration on Amazon Redshift
• Part of the project involved in bringing the Salesforce data to in house target data ware housing using Informatica salesforce connector.
• Using Hadoop connector extracted Bank data from the source and loaded into Hadoop HDFS Data Lake.

Environment: Informatics 9.6 Power Center Client (Repository Manager, Designer, Workflow Manager, Workflow Monitor), SQL Server 2005 & 2008, DB2, Postgrsql(pgadmin), Lotus Notes, Oracle10g&11g, Unix scripting, HP Service Manager, Splunk, Hadoop Connector, Amazon Redshift, Salesforce Connector, Teradata

Confidential

Responsibilities:

• Interaction with business users to gather business requirements and designed functional and technical requirements documentation.
• Worked on framework manager to import metadata from multiple data sources and to create
• subject matter models, create and publish packages to Confidential 10 server.
• Extensively used Confidential Framework Manager to build models with query subjects, query items and namespaces
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Developed Projects using Physical, Logical and Business Layers in Framework Manager. Proficient in design and development of Joins, filters, calculations, prompts and conditional
• variables in Packages in Framework Manager.
• Used Framework Manager to externalize query subjects in order to generate IQD data sources for Powerplay cube creation in Powerplay Transformer .
• Built and Published the Packages to Confidential 8 and Confidential 10 Server according to user requirements
• Authored list, crosstab and chart reports using some unique functionalities of report studio.
• Designed summary and detail reports which involves the key functionalities of the report studio like conditional blocks, conditional layouts. Designed reports which involve drill down, drill up and drill through functionalities in report studio. functionalities in the report studio.

Environment: Confidential 10.2 (Framework Manager, Confidential Connection, Query Studio, Report Studio, Analysis Studio, Metric Studio, Event Studio, Access Manager) Transformer, SQL Server 2008(SQL Server Management Studio 10.0), HP Service Manager, Teradata, .

Confidential, CA

QA Analyst

Responsibilities:

• Created business process test plans and test cases based upon use cases using Mercury Quality Center
• Performed functionality testing of the application on AIX and LINUX
• Log, track, and verify resolution of software and specification defects along with documenting all phases of QA process using Quality Center 9.2
• Performed functional, Integration and regression testing for the application
• Tracked defects in JIRA and reported them to developers for fixes
• Interacted with the team members and participated in review meeting with Developers and Business Analyst’s for understanding the requirements which are not clear.
• Tracked defects on the Requirements if they are not clear in JIRA.
• Performed the System and Acceptance testing of the application according to the Customer Environment.
• Worked closely with the developers and team members on the issues found in the application
• Generating the Daily Test reports about Test status and Defects summary
• Attended technical walk- through sessions
• Participated in weekly assessment meetings with business analysts and developers
• Performed the cross platform testing on AIX and LINUX

Environment: Oracle, Mainframe, QA Process, JIRA, LINUX, SQL, MQC, AIX, C++, Java, XML, MS Office Suite, Clear Quest,Putty

Confidential, Mountain View, CA

Senior QA Analyst

Responsibilities:

• Attended Business review meeting and Functional walkthroughs.
• Reviewed the Functional specifications document to determine the functionality of the application.
• Involved in test case preparation based on the Functional Specification Document and evaluation through peer reviews.
• Involved in code review of store procedures, triggers, functions, views etc.
• Involved in writing and testing complex SQL queries involving more than three table joins and getting explained to verify the SQL performance.
• Performed Manual Testing by executing test cases and logged the bug on different modules of the application.
• Performed Manual Testing on different modules of the application.
• Involved in integration testing, regression testing and System testing.
• Involved in tracking the Defects using the Defect Tracking Tool and reported the bugs in the Mercury Quality Center

Environment: Java/J2EE, HTML, JavaScript, Windows NT/2000/XP, Sun Solaris, Oracle RDBMS, QTP, UNIX Shell scripting, Team Tracker

Confidential, CA

QA Analyst

Responsibilities:

• Created business process test plans and test cases based upon use cases using Mercury Quality Center
• Performed functionality testing of the application on AIX and LINUX
• Log, track, and verify resolution of software and specification defects along with documenting all phases of QA process using Quality Center 9.2
• Performed functional, Integration and regression testing for the application
• Tracked defects in JIRA and reported them to developers for fixes
• Interacted with the team members and participated in review meeting with Developers and Business Analyst’s for understanding the requirements which are not clear.
• Tracked defects on the Requirements if they are not clear in JIRA.
• Performed the System and Acceptance testing of the application according to the Customer Environment.
• Worked closely with the developers and team members on the issues found in the application
• Generating the Daily Test reports about Test status and Defects summary
• Attended technical walk- through sessions
• Participated in weekly assessment meetings with business analysts and developers

Environment: Oracle, Mainframe, QA Process, JIRA, LINUX, SQL, MQC, AIX, C++, Java, XML, MS Office Suite, Clear Quest.Putty

Confidential, Corvallis, OR

Senior QA Analyst

Responsibilities:

• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
• Performed Smoke Testing of the application as an entrance criteria for development builds
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases using Rational Test Manager
• Identified the Test Cases to be automated and lead the effort for automating the product using Rational Robot
• Generated XML test files using XML schema.
• Tested the functional objectives of the modules in extracting and reporting the data.
• Wrote SQL & PL/SQL queries for data validation.
• Requirements management using Test Manager and Use-Cases in Visio
• Checked the broken links in the application and conducted cross browser testing
• Worked extensively with Unix Shell Scripts
• 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

Environment: Java Script, HTML, XML, JDK, Oracle9i, PL/SQL, Unix Shell scripts, TOAD 1.09a, RPG, AS400Terminal MS SQL QueryAnalyzer/Enterprise Manager 2000, MS Access 2000, Rational Suite 2002.05.20 , RUP, PVCS, Visio, Web logic, Windows NT/2000.

Confidential, Hillsboro, OR

QA Analyst

Responsibilities:

• Involved in designing and documenting Test Plans, Test Cases, Test Scenarios and Test Strategies based on User stories.
• Prepared Requirements Traceability Matrix (RTM).
• Involved in Testing the User Stories and developing the Test Scripts for every Iteration in Preview environment.
• Generated test scripts for both manual execution and also using Win Runner for automated testing.
• Performed Regression testing for every modification in the application & new builds using Win Runner.
• Conducted the Functional, System and Integration testing of the Web application.
• Performed Black Box and manual testing of the application to test the system for both the functional and user requirements for positive and negative scenarios.
• Used SQL queries to test the populated back end data.
• Conducted walkthroughs and reviews of the documentation
• Involved in daily standup meetings for all iterations.
• Involved in the QA Weekly meetings.
• Documented and reported the progress to the management on an ongoing basis and updated the requirement and defect status as per the current status of the testing project in Test Director.

Environment: Windows XP/Professional, HTML, C, C++, Java, J2EE, Web sphere, XML, Mercury InteractiveTools (Test Director, Win Runner), Microsoft Outlook, Microsoft Word, Microsoft Excel, SQL Server.