Professional Summary:
V Over Nine years of diverse IT experience with 4 years of leadership
experience in Quality Assurance, Testing, Data Analyst, Development
and Maintenance of various software applications in Data warehouse
environment.
V Extensively wrote SQL for Back end testing ETL related complex
business processes on UNIX batch applications and interfaces.
V Worked as Informatica Admin and Migrated the code in different
environments using Informatica Repository
V Experienced in creating source to target mapping document for ETL
development and ETL testing
V Expert in ETL tool Informatica which includes components like
PowerCenter, Designer, Workflow Manager, Workflow Monitor, Repository
Manager, Repository Server, Administration Console, PowerMart,
PowerConnect
V Highly Proficient in developing Complex Transformations, Mappings,
Mapplets, Workflow, Worklets and Scheduling Informatica Jobs
V Worked extensively with Complex Mapping using different Transformation
like SQ, Expression, Filters, Joiners, Routers, Unconnected/Connected
Lookups, Functions, Aggregators, Stored Procedures, Transaction
Control, Update Strategy
V Strong experience in designing SCD 1, SCD 2 mappings
V Highly proficient in Debugging and Performance Tuning of the ETL
process which includes tuning of Informatica mappings, session, source
and Targets
V Experienced in Extracting data from various sources like Oracle,
Teradata, SQL Server, DB2, Flat Files into the staging area
V Extensive Database Experience using Oracle 10g/9i, DB2, PL/SQL, SQL
*Plus
V Expertise in Ab initio graphs and Informatica work flow execution and
validation.
V Experience in Data Modeling by creating Logical and Physical Models
using ER-win
V Excellent understanding of the SDLC, its constituent Activities &
steps, Models & the supporting Disciplines.
V Extensive experience in all steps of STLC; performed Requirements
Analysis, Test Preparation, Test Execution, UAT, Defect Management and
Reporting.
V Thorough hands on experience with all levels of testing namely Smoke,
Sanity, Integration, Interface, Functional, Integration, End to End,
Regression, Backend and Front end testing, Load, Performance, Volume
and Compatibility testing.
V Actively participated in the user requirement gathering & JAD Sessions
that involved the Project Sponsors, Managers, BAs, development team &
test team.
V Prepared and maintained RTMs, FRMs and PR reports to ensure
comprehensive test coverage of requirements.
V Expertise in Path Analysis & Data Flow Analysis and writing test cases
from the basic, alternate, and exceptional flows of the Use cases.
V Extensive experience in both Manual and Automated testing using QTP,
WinRunner, LoadRunner, Quality Center/Test Director and Clear Quest.
V Experienced as Quality Centre/Test Director Administrator for
adding/Deleting users and projects.
V Extensive experience in tracking bugs using Bug tracking tools such
as Test Director/ Quality Centre, Remedy and Clear Quest.
V Coordinated and prioritized outstanding defects and enhancement based
on business requirements, allowing sufficient time frame to ensure
accuracy.
V Expertise in generating & analyzing management reports.
V Performed Gap Analysis through interactions with both the client and
the technical team to ensure key financial and business data is
managed and delivered in line with the business requirements.
V Scrum Alliance Certified Professional Scrum Master
V Lead testing efforts in several projects by implementing Agile
Methodology by using Scrum and Extreme Programming.
V Awarded with Certificate of Appreciation for my work from Advance Auto
Parts
V Good knowledge of Finance, Insurance, Ecommerce, Mortgage, Auto Parts,
Travelling and Media Industry and processes.
V Ability to multitask, flexible in adjusting to people, hard working
with a realistic attitude, good interpersonal skills and a team
player.
EDUCATION:
Master of Business Administration (MBA) in Finance, George Mason University
Bachelors B.S in Computer Science
Certifications:
Certified Scrum Master from Scrum Alliance, Member id: 000086754
[pic]
TECHNICAL SKILLS:
ETL TOOLS: Informatica Power center 8.6/8.1/7.1/6.2, DataStage.7.5/7.1,
SQL*Loader, Bulk Loader
Reporting Tools: Cognos, Business Objects XI, MS SQL Server Reporting
services 2005, Developer 2000(Forms
5.0, Reports 6i), Crystal Reports 10, Crystal Reports 2008.
DATA Modeling: Erwin 4.0/4.1
Operating Systems :Windows (9x, 2000NT, 2000, XP, 2003), AIX, HP UX
9000, Linux, UNIX
Languages : TSL, C/C++, Visual Basic 6, SQL, PL/SQL, Bourne Shell,
Java,
J2EE, HTML
Testing Tools : Win Runner, QTP, Load Runner
Tracking & Version : Test Director, Quality Center, Clear Quest, Remedy,
VSS, Doors, Clearcase
Databases and tools : Oracle 11G, MS SQL Server, Sybase, DB2, My SQL,
Toad
Web Tech. :HTML/DHTML, VB Script, J2EE, XML, Java Script, WML, CSS,
XSLT, ASP, JSP
Web/Appl. Server : SAP Web AS, Web Logic Application Server, Tomcat 5.0 Web
Server, Apache Web Server, Microsoft IIS Web Server
Projects Undertaken:
Allegis Group, Hanover, MD
NOV 2011 - Current
Informatica Developer / Data Analyst
Project: BI Framework
Allegis Group is the parent organization of TEK systems, Aerotek, Stephen
James, Allegis Group Services, Market Source, and Major, Lindsey & Africa
among others. Each operating company specializes in a different contract
services and solutions industry. Allegis group being a very large
organization with multiple application system across different companies
wants to capture information across the enterprise in a central database
and make better business decisions using the business intelligence from
central Enterprise Data Warehouse.
Responsibilities:
V Extensively worked in full Software development life cycle.
V Worked closely with business users on gathering the requirements and
prepared Technical Design and Mapping documents.
V Created Folders and deployment groups using Repository manager.
V Extensively worked with Designer tools like Source Analyzer, Target
designer, Mapping designer, Mapplet designer, Transformation
Developer.
V Created source and Target Definations, Reusable transformations,
mapplets and worklets.
V Created Mappings and extensively used transformations like Source
Qualifier, Filter, Update Strategy, Lookup, Expression, Router,
Joiner, Normalizer, Aggregator and Sequence Generator, Web services
Consumer.
V Developed Source to Staging and Staging to Dimension mappings.
V Developed Source to Staging and Staging to Fact mappings
V Used Workflow Manager to create sessions, worklets workflows.
V Extensively involved in tuning the mappings, sessions and the Source
Qualifier query.
V Identified performance issues in existing sources, targets and
mappings by analyzing the data flow, evaluating transformations and
tuned accordingly for better performance.
V Manage all technical aspects of the ETL mapping process with other
Sprint team members.
V Involved in Unit and Integrating testing of Informatica Sessions,
Batches and the Target Data
V Created mappings to load Slowly Changing Dimension tables based on the
amount of historical dimension data wanted to keep
V Worked with Oracle On Demand to load the data to the cloud and query
from OOD using Informatica.
V Extensively worked on WSDL requests and responses.
V Modified the WSDLs as per the Business rules.
V Involved in migration of mappings and sessions from development
repository to test and production repository.
V Designed and developed UNIX shell scripts as part of the ETL process,
automate the process of loading, pulling the data..
V Involved in production support and done knowledge transfer to team
members
V Actively involved in Daily check in meetings to discuss on the
production issues and resolved.
V Graphically represented the data flow and process flow by creating
Dataflow diagrams and Process flow diagrams
V Analyzed functional requirement and created the logical model using ER-
win.
V Converted the logical model into the physical model by identifying the
tables and columns on a granulated level using ER-win.
V Created the data flow and conceptual diagram for the business for
better understanding and identifying the stages of data.
V Filtered tables in a source system to obtain the most relevant
data/ tables in accordance with the business requirements for decision
making by upper management.
V Created source to target mapping document for the ETL development and
ETL testing team.
V Set-up functionality walk-through workshops with business analysts and
developers.
V Reviewed the mapping documents for STAR Schemas and Conformed
Dimensions to create complex Informatica ETLs, SQL Views, Procedures,
Tables and Synonyms for the test framework
V Thoroughly conducted data analysis and gap analysis between source
systems for EDW model.
V Designed and developed the Test Suite in the HP Quality Center
V Worked as Informatica Admin and added new users and provide them
different rights as per there role needs.
V Created deployment groups in Informatica Repository and copied
objects.
V Migrated Informatica code using Informatica Repository from DEV to
TEST and from TEST to PROD.
V Created new sessions and events using Informatica Workflow Manager.
V Co-ordinate with Oracle and SQL server DBA's to create DB links to
test the data coming from different source databases.
Environment:
Oracle 11G, SQL Server 2008, DB2, Unix, ER-win, Mercury Quality center
10.0, Door, BO Info View, Pl/SQL, Toad 10.6, SQL server management
studio, Informatica 8.6.1, Informatica 9.0, Business Object Informatica
Power Center 8.6.1, Oracle 10g/11g,DB2, Sybase, Rapid Sql server, Erwin,
Windows XP, UNIX.
Amtrak, Washington, DC
NOV 2010 - NOV 2011
Informatica Developer
Project: EDW & CSPMI
Amtrak being a very large organization with multiple application system
wants to capture information across the enterprise in a central database
and make better business decisions using the business intelligence from
central Enterprise Data Warehouse.
Responsibilities:
V Extensively used Informatica Power Center 8.6.1 to create and
manipulate source definitions, target definitions, mappings, Mapplets,
transformations, re-usable transformations, etc.
V Involved in design and development of complex ETL mappings and stored
procedures in an optimized manner.
V Implemented partitioning and bulk loads for loading large volume of
data.
V Involved in loading the data from Source Tables to ODS (Operational
Data Store) Tables using Transformation and Cleansing Logic using
Informatica.
V Based on the requirements, used various transformation like Source
Qualifier, Normalizer, Expression, Filter, Router, Update strategy,
Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations
in the mapping.
V Developed Informatica SCD Type-I, Type-II mappings.
V Created Stored Procedures in PL/SQL with Oracle in order to create,
update several tables like Order processing Information table and
train scheduling tables.
V Used the Debugger to run Debug sessions setting Breakpoints across
instances to verify the accuracy of data.
V Used PMCMD command to start, stop and ping server from UNIX and
created UNIX SHELL scripts to automate the process.
V Created UNIX Shell scripts and called as pre session and post session
commands.
V Developed workflow tasks like reusable Email, Event wait, Timer,
Command, Decision.
V Creating Test cases and detailed documentation for Unit Test, System,
Integration Test to check the data quality.
V Executed workflows in Informatica to migrate the data from source to
target
V Monitored workflows in Informatica and send out success/failure email
notification to entire team for daily, weekly and monthly loads for
different subject areas.
V Updated schedules and added business users for various reports in
production using BO info view.
V Monitored BI reports in production every morning and sent out
success/failure email notification to business.
V Worked with developers in De-bugging the issues for workflows
failures by analyzing the data and logs.
V Performed smoke testing, functional testing, Back end Testing, Front
end Testing, Integration testing, End to End testing, regression
testing, positive and negative testing
V Worked with Business Intelligence team to coordinate integration
between BO universe and EDW
Environment:
Informatica PowerCenter 8.6.1/8.1.1, Oracle 11g, TOAD for Oracle 9.7,
SQL server 2008, Flat Files, PL/SQL, ERwin, Windows 2000, UNIX
Advance Auto Parts, Roanoke, VA
Feb 2009 - Nov 2010
System Test Lead/Data Analyst
Project: APAL Point Of Sale/Second Source/Web Applications
Advance Auto Parts, Inc. is the second largest auto parts; Roanoke,
Virginia-based Company operates more than 3,400 stores located in 38
states, Puerto Rico, and the Virgin Islands. Further, it is a partner in
PartsAmerica.com, an online auto parts retailing venture. The project
involved enhancement in Point of sale application, web projects in
Implementation factory and second source project in APAL team.
Responsibilities:
V Managed and lead team of 6 test members.
V Created and presented the overall Test Strategy and Test Process for
POS, Second Source and web project to the team and higher management.
V Held daily status meetings with team and provided metrics to senior
management
V Analyzed system requirements, Business Requirements and generated
Requirements Traceability Matrices, test plans, test scripts
accordingly.
V Provided LOE for test planning and execution
V Organized requirements review sessions with business users and
requirements analysts to bring new members up to speed for Systems
Testing and Held business knowledge transfer from system analysts to
system test team.
V Assigned work among the team members
V Worked very closely with business analysts and developers in the
projects.
V Designed system test plans for client server based applications and
web based applications
V Organized and supervised formal reviews of technical specifications,
design documents and test plans
V Wrote and executed system test cases for web and client server
applications under test using Quality Center.
V Wrote intuitive test cases and scenarios for functional, usability,
browser compatibility, data, and regression testing in Quality Center
V Experienced as customizing HP Quality Center tool and creating report
V Provided Quality Center training to users as needed
V Worked as an administrator for adding/deleting users and project in
Quality Center tool
V Performed smoke testing, functional testing, Back end Testing, Front
end Testing, Integration testing, End to End testing, regression
testing, positive and negative testing
V Completed data analysis on the Oracle sever to fetch data for testing
V Wrote complex SQL statements to retrieve data for data scenarios
V Validated the complex business process ETL for external partner client
interfaces by writing SQL query for extracted data.
V Executed Informatica work flow from UNIX.
V Executed UNIX batch job and verified success by checking various
application logs.
V Written SQL queries for checking the Data Transactions and Database
Integrity in Oracle and SQL Server. Also developed SQL scripts to run
complex data integrity test cases and to extract data from the tables.
V Worked with developers in De-bugging the failure issues by analyzing
the data and logs
V Performed functional, GUI, and Security testing using the different
checkpoints in the automated WinRunner
V Worked on multiple projects and lead the testing efforts of those
projects at the same time
V Participated in UAT testing with business users
V Executed multiple builds for UAT users as communicated the results
V Developed test cases and test scripts using Winrunner for
Functionality, Security and Regression Testing. Configured, developed,
tested and supported the networks.
V Carried out extensive testing with the WinRunner, testing tool with
different test cases, which reflects the various real time business
situations.
V Communicated with the developers and business users for test issues
and escalated when required
V Tested report generated from Cognos BI Layer
V Used SQL Server Management and Rapid SQL to query database
V Involved in Extensive testing of various situations along with the
implementation team, resolved the issues and problems.
V Participated in daily defect review meetings and provided testing
progress status.
V Retested all new and existing defects and communicated the results
with the users
V Used Quality Center as defect tracking tool
Environment:
Clarion, Oracle 10G, SQL Server 2005, DB2, Unix, Dot Net 2.0, Csharp, VB
Dotnet, Java, J2EE, Mercury Quality center 10.0, Door, Clear case, Win
runner, Pl/Sql, Sql server management studio, rapid SQL, Informatica,
Business Objects
Carlson Wagonlit Travels, Plymouth, MN
Sept 2008 - Feb 2009
QA Test Lead
Project: CWT Document Bank
Carlson Wagonlit Travels is United States second biggest traveling company
which is dedicated to helping companies of all sizes, as well as government
institutions and non-governmental organizations, optimize their travel
program and provide best-in-class service and assistance to travelers. The
project involved enhancing the web based application called CWT Document
Bank in different sprints and converting the entire data of CWT Document
Bank from one database to other database which has information of all
unused documents.
Responsibilities:
V Managed and led Team of 5 test members
V Assigned task among the team members
V Used Agile Methodology method for testing like scrum and Extreme
Programming
V Prepared and presented plan for need of requirement based System
Testing based on project complexity and also since current testing
suite was just integration testing.
V Created over all System Test Strategy detailing Test Methodology for
CWT Document Bank
V Tested Data Conversion and complex ETL from SQL server to Oracle
database by creating comprehensive SQL statements
V Executed conversion and ETL shell scripts from UNIX
V Reviewed business Requirement, detail and high level development
design documents
V Attended Requirement review meeting with product owner, scrum master
and business users
V Attended Daily Morning scrum meetings with Scrum master and Product
Owner to discuss testing efforts, accomplishments and obstacles
V Designed metrics reporting template to track progress of teams and
reported weekly status to higher management and Scrum master
V Used Rally to burn task hours for each and every sprint
V Created Test plan for each and every sprint
V Used Quality Center to write Test Cases, Test Scenarios and enter
Defects
V Wrote automation test scripts and executed them in Mercury QTP
V Automated the test scripts for Regression testing and performed
backend testing by creating database check points using QTP
V Enhanced the test scripts through Check Points and Parameterization.
V Converted entire data of two tables from SQL server database to Oracle
database
V Completed data analysis on the Oracle sever to fetch data for testing
V Wrote complex SQL statements to retrieve data for data scenarios
V Worked with data team to manufacture complex data conditions that does
not exist in production.
V Used Toad and Rapid SQL to query data from database
V Held daily status meetings with my team and provided metrics to senior
management.
V Participated in daily defect review meetings and provided testing
progress status.
V Managed daily issues of test execution and functional defects with
respect to requirements or code deployment
Environment:
Java, J2EE (AJAX, DOJO, STRUTS, EJb, JDBC and XML), Sql Server, PL/SQL,
XML SPY, Rapid SQL, Unix, Linux, Oracle 9i,10G and Toad, Quality Center
10.0, QTP, Rally
Discovery Communications, Silver Spring, MD
Nov 2007 - Sept 2008
Sr. QA Analyst
Project: AMS
Discovery Communications is the number-one nonfiction media company
reaching more than 1.5 billion cumulative subscribers in over 170
countries. The project involved conversion of data from the HD Simulcast
Data Grid to the new data structures in AMS. After the conversion, all HD
data will be tracked in Core and Specials area of AMS and the HD Data Grid
will be made read-only.
Responsibilities:
V Managed and lead team of 10 test members.
V Held daily status meetings with team and provided metrics to senior
management.
V Participated in daily defect review meetings and provided testing
progress status.
V Managed daily issues with test planning regarding requirements or code
deployment
V Provided LOE for test planning and execution
V Assigned work among the team members
V Coordinated with CM to get latest builds and deployments
V Analyzed and reviewed business requirements
V Organized meetings to discuss requirement issues with manager and
business counter parts.
V Drafted test cases, test scenarios for 54 requirements on an
aggressive hard deadline.
V Reviewed test artifacts with business users and production manager.
V Reviewed conversion reports that identify the fallout of bad data
after conversion.
V Wrote complex SQL in TOAD to verify the converted data from HD
Simulcast to AMS.
V Lead the execution effort of the conversion batch processing in UNIX
V Wrote shell scripts to analyze logs.
V Performed smoke testing, functional testing, Back end Testing, Front
end Testing regression testing, Integration testing, End to End
testing, positive and negative testing
V Coordinated with developers during on and off hours during conversion
failures.
V Worked with developers in De-bugging the failure issues by analyzing
the data and logs
V Opened defects in Remedy bug tracking tool.
V Coordinated and communicated with developers to provide all necessary
info in the defect.
V Setup emergency meetings with all parties during build failures and
escalated the issue to higher management
V Manually cleaned the data by updating the bad attributes data in the
database using SQL.
V Identified the bad data by de-bugging the failures causing the
conversion to fail by querying the database using SQL in TOAD.
V Documented all data issues and communicating to users to clean the
production data.
V Executed reports to get list of data warnings that will convert but
won't cause conversion failure.
V Validated the error reports by executing expected result queries.
V Performed Backend Testing for data Integrity
V Verified the converted data to AMS by querying all tables for updated
decoders for all networks, HD Subs and billing system affiliates.
V Participated in UAT conversion testing with business users
V Executed weekly builds for UAT conversion in UNIX
V Provided reports and data to UAT team for review
V Sent weekly reports on progress of data cleanup during conversion
V Absorbed new requirement changes from UAT after every execution cycle.
V Created RTMs to map use cases with test cases and made sure that test
cases were written for all functional requirements
V Updated and maintained RTM to make sure that all requirements changes
were captured
V Posted documents on IBM Lotus Quick Place, a work space designed for
team collaboration
Environment:
J2EE (AJAX, DOJO, STRUTS, EJB, JSP, JSTL, JDBC and XML), Oracle PL/SQL,
XML SPY, Remedy, JavaScript,Unix, Linux, Oracle 9i,10G and Toad, IBM
Lotus Notes, IBM Quickplace
Chevy Chase Bank, Gaithersburg, MD
Nov 2005 - Oct 2007 Sr. QA Tester
Project: Advanced Billing System
Responsibilities:
Involved in all stages of Software Development Life Cycle from
requirements gathering to post-production.
V Participated in weekly assessment meetings with BAs, SMEs, and
developers and coordinated between business analysts, development
team, and testing team.
V Analyzed system requirements, Business Requirements and generated
Traceability Matrices, test plans, test scripts accordingly.
V Performed path analysis, and developed and executed test cases, and
test scenarios.
V Performed Sanity Testing and Smoke Testing before a full fledge
testing is implemented for the application.
V Involved with UAT batch execution and analyzed UAT results to support
their schedule
V Reviewed UAT defects and traced back to functional test scenarios.
V Provided daily status on the UAT progress to all the stake holders
V Developed automation test scripts for functional & regression testing
using QTP.
V Analyzed and reviewed system/business requirements and test cases in
Doors.
V Enhanced the QTP scripts by implementing VBScript functions and
inserted Checkpoints to check for Text, table, XML, and images, and
Synchronization points to capture upload time.
V Handled known exceptions in the test scripts using QTP Recovery
Scenario Manager.
V Used Smart Identification to distinguish Objects that are difficult to
identify by using default identification mechanism.
V Performed Data-Driven testing, Text Output values by using Global and
Local spreadsheets in QTP for testing multiple data.
V Used Load Runner for conducting Performance, Stress and Load tests.
Generated the test scripts, and parameterized and correlated the
scripts to run for multiple users.
V Executed baseline tests to verify the scripts and pinpoint the
bottlenecks at various application layers.
V Monitored the system resources of all the servers while executing the
tests.
V Written SQL queries for checking the Data Transactions and Database
Integrity in Oracle. Also developed SQL scripts to run complex data
integrity test cases and to extract data from the tables.
V Logged defects using Mercury Quality Center, Remedy, Clear Quest.
V Actively participated in DRB meetings to resolve the defects in
efficient and timely manner.
Environment:
QTP, Load Runner, Quality Center, Remedy, Java, J2EE, JavaScript, Oracle
9i, MS Office, VB Script, Windows XP, Unix., SQL, Ms-Access, Windows 2000
Client: WELLS FARGO, Mc Lean, VA Aug 2003 - Oct 2005
Sr. QA Analyst
Project: Wells Fargo Deal Decision Project
Responsibilities:
V Reviewed User requirements specifications and prepared detailed Test
Plan and Test Cases.
V Tested application on Windows2000 and UNIX environments.
V Wrote test script for manual test and then transferred it for
automated test.
V Performed manual testing for the entire application and reported the
defects to the developer.
V Responsible for the set up, support and coordination during IST, PRE-
UAT, and UAT phase
V Coordinated with project team members to gather, define, and document
UAT test scripts, scenarios and conditions
V Wrote shell scripts.
V Performed Backend Testing for Data Integrity
V Performed Functional testing and System testing using WinRunner.
V Wrote test scripts for Positive testing, Negative Testing, Boundary
Testing and Security Testing.
V Utilized Load Runner for performance, volume and load testing of the
application.
V Conducted regression testing on each new build.
V Developed the schema for bug tracking and reporting using Test
Director and Remedy.
V Participated in weekly meeting and reviewed the bugs.
V Coordinated with the users and development team.
Environment:
Windows2000, Test Director, Remedy, C++, UNIX, Java (jdk 1.2.2), Websphere,
WinRunner 7.6, Rational Administrator, LoadRunner 8.0