SUMMARY

• Over 8 years of IT experience, related to various aspects involving analysis, design, development, testing and Data Modeling of Data ware house applications using Informatica, Oracle and Teradata
• Proficient in ITIL concepts and managed services model.
• Comprehensive domain grasp across all functional areas with knowledge in Software Development Life Cycle (SDLC) and defining project scope, assessing and managing project risks, managing requirement gathering process and User Acceptance Testing.
• Proven expertise in as a Lead of a team of team players and as a senior resource in guiding and suggesting immediate solutions and bring issues to closure and keeping a positive attitude towards team.
• Domain knowledge/experience on Retail, PBM & Health care, Banking & Finance back office.
• Worked on Waterfall and Agile kind of methodologies in projects.
• Experience with several data sources like Oracle, DB2, Teradata, SQL server and MS access with UNIX and from non - relational sources like XML Files, flat files.
• Extensively worked on developing, debugging and testing Informatica mappings, sessions and workflows. Proficient on Black box, White box, System testing, Integration testing, Functionality and UAT.
• Experience on backend testing with oracle, Teradata, SQL Server, DB2 databases
• Good grasp on Application development and Maintenance with enhancements & performance tuning using ORACLE 10g/9i/8i/8.0/7.3, SQL Server, Teradata 13.x, Teradata SQL Assistant 14.0, PL/SQL, Informatica Power Center 8.6, 9.5, TWS Maestro, Unix Scripting, Data Mapping, Transformations, Physical database design, Logical database design, Data Modeling.
• Experience in creating Reusable Transformations, Mapplets, Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer, Union, XML parser, Source Qualifier transformation, Rank Transformations using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extended use of Teradata Parallel Transport, Fast Load, mload, BTEQ and migrating legacy systems into Teradata.
• Expertise with UNIX commands and in designing and maintaining shell scripts.
• Proven experience as an effective team player in Enhancements, Development & Production Support, Testing and performance tuning and Onsite client Management.
• Experience in working with business analysts to identify, review and understand requirements and translate them into ETL code.
• Experience in Creating ETL Design Documents, mapping documents, SMTDs, process manuals, test plan maintaining and user training for small and large projects
• Excellent in analytical concepts and communication with inter personnel skills.
• Dedicated and reliable individual, ability to work well infast paced and dynamicteam environment, adaptable to both as in team environments and individual assignments.

TECHNICAL SKILLS

Project Areas & ETL: Datawarehousing (ETL), Oracle/PlSql/Unix Prod.Support, Informatica PowerCenter 9.0/8.6, Power Exchange, ALM.

DBMS: Microsoft SQL Server 2008 R2, Oracle 10g/9i/8i/8.x/7.x, Teradata 13.x, Teradata SQL Assistant 14.0, DB2, Cisco Information Server Studio, Db Visualizer Pro 9.2.7, MYSQL, MS SQL Server, PL/SQL, SQL, Data Exports & Imports, User & Security Management, Query Optimization, Inbound/Outbound Interfaces

OS/ Environment: MS DOS 6.22, Windows Server 2003/2008, Windows 98/NT/2000/XP, Unix Solaris and AIX, Linux

Testing Tools: HP Application Lifecycle Management software (HP ALM Explorer 11), HP Quality Center, HP service manager, Quick Test Pro 10.0/9.x

Tools: Unix Putty, Connection manager, SQL Navigator, Toad for Oracle, Toad for DB2, Teradata Informatica Power Center, SSRS, Cognos, Microstrategy, Citrix, Tivoli Maestro Job monitor

Scripting and Software language: SQL, PL/SQL, Unix Shell Scripts, HTML, Perl, SQL*Loader, SQL*Plus, VB Script, XML, and troubleshooting experience with JavaScript

Other Applications: Microsoft Visual studio, 2005/2008, Microsoft Office, Microsoft Visio, Microsoft Projects, macromedia Flash, Dreamweaver, Maestro

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

Senior Quality Analyst / QA Lead

Responsibilities:

• This project deals with constant communication with Business, Technical team and Developer and leading the QA team to work towards the project.
• Define best practices and act as the lead for QA Center of excellence.
• Responsible for talent acquisition and resource management on the QA team
• Primary tasks in the project were to predominantly work towards the monthly releases, quarterly enhancement implementations and any new adhoc requests for quick turnaround.
• Setup Testing Suite for the project and Create Test Plan and Test Strategy documents for the project.
• Create and socialized various artifacts to help the other teams on the project.
• Create and maintain folder structure in ALM
• Responsible for training the project team and Users on required tools.
• Work with the Subject Matter Experts to understand and analyze impacts of various data acquisitions.
• Responsible for reviewing Use cases with the Business and align the test scenarios accordingly
• There are daily standup calls as Scrum methodology and per project needs to do defect triage and track the status on open issues and also to discuss on proceedings of new task assignments.
• Responsible for reviewing Test Cases prepared by the QA team.
• Create the reporting module in ALM to reflect test progress, defect tracking etc.
• Create Traceability Matrix for the test cases and requirements as defined.
• Review test scripts along with SQL scripts and assist the team on test script tuning and performance
• Whenever the Business needs more technical understanding on underlying data, would query the SQL Server and Teradata and analyze to provide explanation as and when needed.
• Analyze on the SSIS packages for the ETL data loads on various tables and ETL transformations used to transform data as per requirement .
• Validate the ETL transformations and ETL loads, validate the flow of data using SQL Server procedures and packages, functions to understand the root of issue .
• Discuss with Business and developer to get to know all of the requirements for the project as a part of requirement gathering be considered as a part of outcome and make sure all of it is documented and uploaded into HP ALM.
• Multiple test cases framed to cover the suggested requirements and documented in Excel and reviewed
• The test cases are then exported into HP ALM using excel add-ins and mapped to the requirements under the Test Plan.
• SQL queries are built in SQL Server and Teradata based on the requirements and using the filter conditions from technical specifications to make sure all scenarios are covered and the data is validated in all possible aspects
• The base tables which are refreshed/loaded as one time or month-over-month using source flat files or excel data are validated on database to check the right data is loaded in the expected format
• In case of a report, the data is validated accordingly based on derived values from excel as suggested by the technical specs.
• Defects are tracked in the HP ALM for each of the issue identified and assigned to a specific developer or a Business analyst responsible to resolve and is monitored until the defect is closed in ALM.
• Conduct Defect Triage calls to review and track down defects for each release.
• Work with the project teams on process improvements.
• Responsible for reporting status of various testing activities to the Management.
• Any issues identified are tracked as defects and are worked for same release based on priority or scheduled for quarterly enhancements and worked towards them.
• Responsible for leading efforts on UAT and to coordinate between the Users and the Design / Development teams on issues during UAT.
• Responsible for creating and maintaining the QA SharePoint for the project.
• Facilitate QA meetings with the business and source owners to mitigate risks and resolve issues.
• Organize daily triage calls with the testing team and the development teams to facilitate progress review, defect discussion and issue resolutions.
• Facilitated UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.
• Provided Testing sign off documents for various deployments on the project on an as needed basis.

Environment: Microsoft SQL Server 2008 R2, Teradata14.0, Teradata SQL Assistant, Flat files, HP Application Lifecycle Management software (HP ALM Explorer 11), QTP, Cisco Information Server Studio, Db Visualizer Pro 9.2.7, SSRS, SSIS ETL data loads, ETL transformations, SQL Server Procedures and Packages, Microsoft Visio, Text Pad, Cognos 10, Flat Files, Microsoft Office Suite 2010, Windows 7, MS Outlook

Confidential, Richardson, TX

ETL Test Lead

Responsibilities:

• Leading a team with diversified technical groups from ETL, database, UNIX and production support resources.
• Managing them on their daily tasks and proceedings and communicating with the Business on progress and making sure on being in-line with deadlines.
• Being a part of techno-functional discussions and guiding team out with resolutions and bringing closure to open-ended issues.
• Study business application to understand the clients existing systems and gather requirements accordingly.
• Analyzing business requirement and translating them into Technical details required for development of the project
• Involved in analysis, design and development of ELDM and ABC (Audit Balance Control) model.
• Develop Informatica mappings, sessions, workflows on Informatica power center 9.0 that include multiple transformations
• Used pushdown optimization techniques for better performance.
• Develop and maintain BTEQ scripts.
• Develop and maintain Shell scripts in UNIX to setup environmental variables and run the Informatica jobs
• Utilized ODBC connectivity to Teradata via MS Excel to retrieve automatically from Teradata Database.
• Unix Shell Scripting used for automating logs, for user created table backups and for checking daily log.
• Created pivot tables in Excel by getting data from Teradata.
• Developed numerous Teradata SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins, Using Date Function, String Function and Advanced techniques like RANK and ROW NUMBER functions.
• Used the pre and post session commands to call BTEQs
• Worked on the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables
• Used Teradata loaders (fast load, mload, tpump) to load Teradata tables
• Used Teradata sql assistant to run sql
• Monitoring of applications and scheduled jobs on Maestro scheduling tool
• Resolution of service requests reported by application users den
• Provided enhancements to existing functionalities
• Analyze the current data movement process and procedures
• Used the debugger to analyze dataflow and fix complex mappings.
• Interact with technical and business analyst, operation analyst to resolve data issues
• Creation of BTEQ, Fast export, Multiload, TPump, Fast load scripts for extracting data from various production systems
• Worked on high performance semantic / presentation layer for reporting and analytics
• Involved in the release management process to push the code from dev to production environment.
• Used Serena dimensions as the tool for release management and version control.
• Interaction with business users for requirement clarification and resolution of problems reported.

Environment: Informatica Power Center 9.5/8.6.1,Teradata13x, Flat files, XML, UNIX, IBM Tivoli Maestro Scheduler, SQL Assistant, Serena Dimensions, HP Service manager, UNIX, HEAT, shell scripting, QTP, UNIX, Microsoft Office Suite 2010,Microstrategy, Windows 7, MS Outlook, Quality center, Text pad, Notepad++, Microsoft Visio, Microsoft Excel Pivots

Confidential

Responsibilities:

• Study business application to understand the clients existing systems and gather requirements accordingly.
• Analyzing business requirement and translating them into Technical details required for development of the project
• Develop informatica mappings, sessions, workflows on Informatica power center 8.6/9.0
• Develop and maintain oracle packages, PL/SQL procedures, Teradata Bteq scripts.
• Develop and maintain Shell scripts in unix to run the informatica jobs with restartability features
• Used DBSync to perform CDC from oracle to Teradata legacy.
• Used Teradata loaders (fast load, mload, tpump) to load Teradata tables
• Used DB2 load utilities to load DB2 tables
• Batch job monitoring of Job cycle to be normal and stable, do necessary rescheduling/adjustments
• Used pre command and post command sessions to call unix scripts
• Proactively automated UNIX scripts, automated mails for reports and failures using Oracle and Unix Scripting.
• Monitoring of applications and scheduled jobs on Maestro scheduling tool
• Provide resolution to the incidents and job failures with in a defined SLA
• Resolution of service requests reported by application users providing enhancements to existing functionalities
• Interaction with business users for requirement clarification and resolution of problems reported
• Design for minor enhancements on already existing functionality.
• Attend Technical reviews & code walkthrough meetings and suggest design changes

Environment: Informatica Power Center 9.0/8.6.1, Power exchange 8.1, Oracle 11g/10g/9i, TOAD, PL/SQL, Flat files, DB2, Teradata13x, IBM Tivoli Maestro Scheduler, Putty, Mainframes, DBSync, UNIX, Toad, Korn shell scripting, Serena dimensions, PVCS

Confidential, NJ

Senior Programmer Analyst

Responsibilities:

• Make sure the live production system is stable and under control with job monitoring
• Responsible for fixing any UNIX shell script, job abends by immediate workarounds.
• Accountable for Invoicing and Pricing section ( heart of any business and to customers)
• Take up adhoc requests based on tickets - Oracle/plSql/Unix
• Interacted with business analyst for data analysis and to define Business rules and Functionality Specifications
• Proactively automate UNIX scripts generating automated mails using Oracle/Unix for daily reports
• Recreate Production issue scenario in test environment (database and UNIX) analyze root cause of the issue.
• Analyzed business requirements and module-specific functionalities to identify requirements and formulate an effective plan.
• Coding on quarterly release code fixes, Creating Unit Test Cases, Data flow Diagram, Testing and Peer Reviews
• Worked on functional specification and prepared high level Design document
• Performed the role as module lead in guiding the team members both in technical and functional aspects of the couple of modules after gaining the complete module knowledge.
• Involved in multiple automation process and customer initiatives
• Interact with all developers and consolidate for implementation, Take care of PVCS check in and support on post implementation issues.
• Attended Tech spec review & code walk thru meetings and suggested design changes.
• Created the SMTD documents for future reference.
• Participated in weekly status meetings, conducted walkthroughs, documented proceedings, and mentored new team members in documentation and process execution
• Provided the management with weekly documents like metrics, reports, and schedules.
• Contributions being Requirement gathering, System analysis, Code fixing, Testing, Resolution Plan, Debugging
• System on adhoc tickets, weekly and Monthly Status Report Generation, Job Monitoring, Implementation supportPost implementation support and maintenance, documenting recurring issue solutions

Environment: Oracle 9i, Toad, SQL Navigator, Pl/SQL Developer, SQL*Plus, HP UX, Unix Shell scripting, Power builder 12.0, Sybase, Crystal Reports, JAVA SERVLETS, JAVASCRIPT

Confidential

QA Analyst

Responsibilities:

• Involved in analysis, requirements gathering, function/technical specifications and development, deploying and testing.
• Performed database testing
• Validated the table structures, primary key foreign key relationships.
• Prepared test data to cover all the requirements for both positive and negative test scenarios
• Developed SQL queries to validate the data
• Tested the PL SQL blocks, stored procedures, triggers, cursors
• Conducted load tests, performance tests on the PL SQL blocks, stored procedures
• Created test plan and lead the review of test plan and test procedures with the users, developers for signoff.
• Mentored the team members with test procedures
• Coordinated with and mentored the offshore team for test execution
• Lead the sessions with the team members to create and review the high level test scenarios and test cases to ensure complete coverage of the requirements
• Validated the table structures to ensure all the required constraints and columns are defined properly.
• Developed SQL queries in TOAD and ran the queries against the Oracle to validate the data loads
• Created and executed test cases in QC
• Identified and prioritized the test cases based on the criticality of the requirements
• Prepared regression test plan and identified test cases for regression testing.
• Tracked the execution status of the team and provided daily, weekly status, reports to the management
• Tracked the defects in QC
• Coordinated with the development team to fix the defects and closing them by retesting the scenarios.
• Deployed the code changes in the test environment.
• Used VI to edit shell scripts to change the parameters and run the scripts for specific environments.
• Involved in UAT
• Represented the SIT team in user meetings to provide inputs

Environment: Quality Center10/ 9.0, Oracle 9i/10g, TOAD, VBScript, SQL Navigator, Pl/SQL Developer, SQL*Plus, 12.0, Sybase, Windows XP, XML, UNIX, Java, JSP, Java Script, Weblogic