SUMMARY

• 7+ years of experience in all phases of software development lifecycle such as Requirement Analysis, Functional Analysis, Design, Development, implementation, Testing, Debugging, Production Support, and Maintenance of various end to end Data warehousing Applications.
• Extensive domain knowledge in Financial / banking / and Health Care.
• Extensive knowledge and implementation of Datawarehouse and ETL concepts.
• Extensively worked on ETL tools Informatica 9.x/8.x/7.x, Pervasive 9.2
• Experience in Informatica Power Center Client and Server (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Data Quality, Power Exchange.
• Expertise in implementing complex business rules using various Informatica Transformations, Mappings and Mapplets.
• Experience in using the Informatica Utilities like Pushdown optimization and Partitioning.
• Implemented Slowly Changing dimensions Type 1 and Type 2 methodology.
• Expertise in working with Star and Snow Flake Schema using Data modeling tools like Erwin Microsoft Visio.
• Experience in Integration of various flat files like Fixed Width and Delimited Flat Files, DB2 & XML Files.
• Experience working with database such as Oracle, SQL Server, DB2, Teradata.
• Expertise in Oracle Stored Procedures, Triggers, Index, Table Partitions.
• Experience in working with Oracle using SQL, PL/SQL.
• Write and execute test cases for Unit and Integration testing.
• Experience in working on waterfall and agile methodologies.
• Proficient in the implementation of Data Cleanup procedures, Stored Procedures, Scripts and execution of Test plans for loading the data successfully into the various types Targets (Relational and flat file).
• Experience in Debugging sessions and mappings.
• Experience in Autosys to automate running Informatica workflows and commands. Used features called file watcher jobs and box jobs etc. the scheduling needs to be done in special Autosys language called JIL (Job Information Language).
• Experienced in White Box and Black Box Testing of Database and Web applications
• Extensive experience in the ETL testing, manual testing and Business Intelligence Applications.
• Highlymotivated team player, manage and work in all environments to meet deadlines.Quick Learnerwith strongproblem solving skillsand excellent in presentation and interpersonal skills.

TECHNICAL SKILLS

Languages: C#, SQL, PL/SQL, XML, RIFL, HTML, JAVA, J2EE

Databases: Oracle 10g/11g, MS SQL Server 2000/2005/2008 , MYSQL, DB2, Netezza, Teradata

Web Servers: IIS, Web Application Server 7.0/8.0, Apache Tomcat 7.0/8.0

System Development: System Development Life Cycle, Agile Development, RUP, UML

Tools: Informatica 9.x/8.x/7.x, Pervasive 9.2,TOAD, DB Visualizer, Microsoft Visual Studio 2008,ERwin 3.x,Autosys, Business Objects X1 R2/6.5

Testing Tools: Rational Enterprise Suite, Test Director, Clearcase, HP Quality Center

Reporting Tools: Web Intelligence, Crystal Reports, Oracle EPM Hyperion Interactive Reporting 11.1.1.3

Operating Systems: WINDOWS 9X/2000/XP/VISTA, UNIX

Version Control System: MKS, SVN

PROFESSIONAL EXPERIENCE

Confidential, Maryland

Programmer Analyst

Responsibilities:

• Worked on Informatica Power Center 9.1/8.6 tools - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Involved in Analysis, Requirements gathering, and documenting Functional and Technical specifications.
• Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Extracted data from DB2, EXCEL files and Relational databases and loaded into Oracle database and into XML files using Informatica.
• Used FTPservices to retrieve Flat Files from the external sources.
• Created Power Exchange Data maps to Capture Changed data (CDC) from Legacy Systems.
• Used Informatica B2B data transformation to read unstructured and semi structured data and load them to the target.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Used IDQ to complete initial data profiling and matching/removing duplicate data.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Implemented slowly changing dimensions methodology to keep track of historical data.
• Worked with various transformations like connected & unconnected lookups, Router, Expressions, Update Strategy, source qualifier, aggregators, filters, sequence Generator, Joiner etc.
• Wrote UNIX shell scripts to archive the source files.
• Informatica Workflows are run through a script through PMCMD command.
• Designed and Developed Oracle PL/SQL stored procedures.
• Migrated Mappings, Sessions, and Workflows from Development to Test and then to Production environment.
• Involved in Unit, System, Performance, Concurrent and QA testing.

Environment: Informatica Power Center 9.1/8.6, (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow monitor, Worklets), Informatica Power Exchange 8.6, Informatica Data Quality (IDQ 8.6), Oracle 11g, SQL Server, DB2 Visualizer, flat files, SQL, PL/SQL, Unix shell scripts, and Windows xp, Remedy

Confidential, Virginia

Informatica Developer

Responsibilities:

• Team member of the Data Warehousing module. Involved in designing, developing and documenting the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds using Informatica.
• Worked on Informatica Power Center 8.6 tools - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Created shared folders, local and global shortcuts.
• Used Informatica Power Center 8.6 to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files.
• Created reusable Mapplets/transformations embedding business logic.
• Extensively used Joiner, lookup, aggregator, update and router transformations.
• Used Informatica B2B data transformation to read unstructured and semi structured data and load them to the target.
• Developed Fast Load and Multiload Scripts in Teradata.
• Scheduled various workflows, worklets, and tasks using Informatica Workflow Manager.
• Worked on session, command, and email tasks.
• Configured session properties and target options for better performance.
• Involved with Scheduling team in creating and scheduling jobs in Autosys.
• Performance Tuning of sources, targets, mappings and SQL queries in transformations.
• Involved in generating test scripts for Unit testing, system testing and integration testing.
• Involved in migrating mappings, workflows, sessions, sources and Targets to different environments from development to QA and to Production.
• Interacted with Designers and DBA’s to get required information for reports.

Environment: Informatica 8.6, Oracle10g, SQL Server 2008, Netezza 4.x, SQL, PL/SQL, Teradata (Multiload, fastload, tpump), Erwin, and Toad 8.0, Autosys

Confidential, Pennsylvania

Informatica Developer

Responsibilities:

• Participated in business analysis, ETL requirements gathering, physical and logical data modeling and documentation.
• Developed the documentation on the complete ETL process.
• Developed ETL design, change data capture, creating SQL views.
• Designed and developing Informatica mappings, sessions, worklets and workflows.
• Loaded data from Flat Files into the Staging area and into the datamart using Informatica PowerCenter.
• Extensively used Router, Lookup, Aggregator, Expression, Normalizer and Update Strategy Transformations.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created, launched & scheduled tasks/sessions. Configured email notification. Setting up tasks to schedule the loads.
• Debugger to monitor and ensure correct flow of data through mapping.
• Scheduled and monitored automated daily and weekly jobs.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
• Involved in creating test cases.
• Sending the updated status report to the client/vertical manager on weekly basis.

Environment: Informatica PowerCenter 7.1.2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 10g, MS SQL Server 2005, Teradata V2R5, SQL, PL/SQL, ERWIN 4.0, Windows xp.

Confidential

Data warehouse/Informatica Developer

Responsibilities:

• Extensively used ETL processes to load data from Relational and Flat File sources into the target.
• Developed mappings by implementing complex business rules using Router, Lookup, Expression, Sequence Generator, Rank, Joiner, and Update Strategy etc. to manipulate the data flow from source to target with versioning concepts included.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data.
• Created reusable Mapplets/transformations embedding business logic.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Used Workflow Manager to create various tasks and used the Workflow Monitor to monitor the workflows.
• Expertise in creating canned /Ad Hoc Reports using Business Objects.
• Designed Report Template Design Documents.
• Implemented Crystal Reports using the Business Objects universes.
• Created reports for various product lines using the universe as the main data provider.
• Reports are made user friendly by implementing filters, conditions, calculations, cascading prompts.
• Used Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Functions and Master Detail etc.
• Documented Design and Unit Test plan for Informatica mappings, design and validation rules.

Environment: Informatica PowerCenter 7.1, Oracle 9i, SQL, PL/SQL, Windows XP Professional, UNIX, Toad, ERwin 4.0, Business Objects 6.5/XI R2.

Confidential

ETL Developer

Responsibilities:

• Arranged and conducted meetings with the Business for the Requirement Gathering, Doubt Clearing and Q/A Sessions.
• Created of the Functional and Technical Specification Documents
• Created Data Model using Erwin Model for different releases
• Design strategies to handle complex transformational logic.
• Informatica Development - Mappings, Mapplets, Sessions, Command Tasks, Event Wait-Raise Tasks, etc.
• Created of Source XML Custom Views using XSD obtained from source systems
• Created and Managed of Informatica Shared Folder, Shortcuts and reusable transformations
• Developed of stored procedures, functions to perform ETL and packages for reporting module.
• Handled different events using even wait and even raise tasks, and command tasks to run Shell Scripts from Informatica
• Developed of Autosys jobs and JIL files and Creation of Shell Script to schedule Informatica Workflows.
• Created of Unit Test Cases.
• Performed Tuning or Informatica and SQL queries.
• Created of Project Input Template to create XML Files

Environment: Informatica PowerCenter 6.x, ORACLE 9i, SQL, PL/SQL, TOAD, Visual Studio 2005