SUMMARY

• Around 6 years of professional IT experience in requirement gathering, analysis, development, testing using Informatica, SQL, Unix, Perl.
• Experience in software full lifecycle development and system integration using Agile and Waterfall Methodologies
• Experience in Banking and Financial domains.
• Strong in data model design, data definition language, data modification language and analytical skill.
• Good experience in ETL design, Creating High Level and Low level design documents .
• Extensively used Informatica Designer to create and manipulate Source and Target definitions, Mappings and Transformations.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Center Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Have knowledge in Performance Tuning and different Tuning Techniques.
• Have knowledge in Command line programs like PMCMD, PMREP.
• Have Knowledge in Importing and Exporting of Objects from one Repository to another repository.
• Hands on with Netezza and Teradata for data loading/accessing, for creating views, synonyms, tables.
• Good knowledge and experience in working with Teradata in DML, DDL, SQL tuning, TPT.
• Experience in Perl/Shell to generate equity reports for business users.
• Knowledge in Banking and Finance domain front.
• Significant experience of working with operation units, desk users, Sales Team, Business Units, commission management groups of Confidential to understand their business requirements and provide data reports for data analysis.
• Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.
• Excellent analytical & logical abilities and relationship management skills.

TECHNICAL SKILLS

Operating systems : Windows XP/7, Red Hat Linux (9.0), UNIX

Programming Languages: Perl, Shell, template toolkit

IDE: Teradata SQL assistant, Teradata Studio, Aginity Workbench, MS SQL server management studio, Toad, DB Artisan, RapidSQL

Object migration tools: syts, db2ts, Deployment groups

Software development methodology: Waterfall, Agile

Tools: Autosys, Batchmon, Hummingbird Connectivity 10,WinSCP, Power Center 9.5.1/8.6.1 , Power Exchange

Database: Teradata 14, Netezza, MS SQL Server, IBM DB2 9.7, Oracle, Sybase 12.5 and 15

Configuration Management: Perforce, Harvest, Tortoise SVN

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

Solution Environment: Windows 7, UNIX, Informatica 9.5.1, Teradata 14, Netezza

Tools: Informatica Power Center, Teradata SQL assistant, Aginity Workbench, Version 1 for Agile, Super Putty, Notepad ++, Microsoft Visio, SVN Tortoise, QzDesktop.

Responsibilities:

• Requirement gathering from Product Owner and Business Analyst.
• Agile: Attending daily scrum call, proactive to take stories and create tasks against it, review backlogs with BA/SM, Provide estimates in IDD, attend retrospective and review meetings, work in iterations.
• Create an ETL specific design document and get it reviewed from Product Owner and ETL architect.
• Develop ETL process to support ETL design and follow standards set for Saber 2 architecture.
• Developing Informatica mappings, Sessions, Command, Control tasks and Workflows.
• Preparation of parameter files for Informatica workflows.
• Creation and execution of test cases of Informatica workflows.
• Debugging of mapping while Unit Testing.
• Creation of supporting Netezza and Teradata SQL scripts and Shell scripts.
• Co-ordinate between ETL migration, ETL architect/admin teams and acting as ETL point of contact for securitization
• Raising proper request for Code migration and post deployment verification
• Assisting ad-hoc queries from SIT team and Product Owner/BA.

Confidential, Pittsburgh.

Solution Environment: Windows 7, UNIX, Informatica 9.1, Teradata 14, MS SQL Server, Oracle

Tools: Informatica Power Center, Teradata Studio, MS SQL Server Management Studio, Toad, Putty, Notepad ++, Microsoft Visio, Harvest, ACORN.

Responsibilities:

• Requirement gathering and requirement Analysis.
• Preparation of ETL High level and Low level Design (Visio) documents, Mini Task Document (MTD), Scheduling document.
• Assist in implementation of source to target maps developed by the Data Architect/Modeler and Business Analyst.
• Translate customer requirements into technical specifications and data mappings.
• Creation of mappings, Mapplets, task, workflows.
• Developing Informatica mappings, Sessions and Workflows.
• Preparation of parameter files for Informatica workflows.
• Creation and execution of test cases of Informatica workflows.
• Debugging of mapping while Unit Testing.
• Creation of harvest packages for deployment of Informatica objects.
• Creation of tables, collection statistics, Partitioning of tables.
• Creation BTEQ scripts (Teradata), maintaining history of tables, writing queries, checking query plans.
• Writing shell scripts for housekeeping.
• Involved into source code review, the mappings created by team members and perform debugging and tuning of mapping.
• Reviewing test cases prepared from other team members.
• Raising proper request for Code migration.

Confidential

Solution Environment: Windows 7, UNIX, Informatica 9.1, Teradata 14.

Tools: Informatica Power Center, Teradata SQL AssistantPutty, Notepad ++, Microsoft Visio.

Responsibilities:

• Requirement gathering and requirement Analysis.
• Analysis on business rules provided by BA.
• Preparing Requirement and design documents.
• Creation of flow charts using Microsoft Visio.
• Creation of mappings, Mapplets, task, workflows.
• Developing Informatica mappings, Sessions and Workflows.
• Preparation of parameter files for Informatica workflows.
• Creation and execution of test cases of Informatica workflows.
• Debugging of mapping while Unit Testing.
• Copying of affected components in Deployment groups.
• In Teradata, Creation of tables, collection statistics, Partitioning of tables,
• Creation BTEQ scripts, maintaining history of tables, writing queries, checking query plans.
• Writing shell scripts for housekeeping.
• Reviewing test cases prepared from other team members.
• Carrying out code review.
• Coordinating with SIT and OAT team for next phases.
• Raising proper request for Code migration.

Confidential

Solution Environment: Windows XP, UNIX, Informatica 8.6.1, Sybase, Perl, UDB DB2.

Tools: DBArtisan, Hummingbird Connectivity 10, Rapid SQL, Power CenterPutty, Syts, db2ts, Autosys/Batchmon.

Responsibilities:

• Requirement gathering and requirement Analysis.
• Preparing Requirement and design documents
• Resolving data issues of business users of application.
• Developing Informatica mappings, Sessions and Workflows
• Creation of test cases of Informatica mappings.
• Creating Autosys jobs for scheduling workflows
• Creating and enhancing database objects i.e., Stored Procedures, Views and Tables.
• Enhancing Perl scripts, Informatica ETL objects used in application.
• Reviewing test cases prepared from other team members.