SUMMARY:

• Over 12+ years of IT experience in design, development, testing, implementation, enhancements and support of business applications, which includes 9 years of experience in Data Warehousing
• Worked as Sr. Data warehouse and ETL Informatica Developer
• Informatica Certified Developer
• Experience in the concept of building Fact tables, Dimesnional tables and handling slowly changing dimensions
• Worked on ETL methodology for supporting Data Extraction, Transformation and Loading processing using Informatica and BO reporting.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet & Mapping designer
• Experience in Migrating Informatica objects to different environment
• Exposure to Informatica Administration
• Experience in Informatica tool set: Informatica B2B DT, IDQ
• Experience in creating SSIS packages and DTS packages
• Experience in creating SSRS reports
• Having good exposure in Data warehousing Architecture and Technologies
• Having good experience in PL/SQL programming- Database Triggers, Packages,Stored Procedures and Functuions
• Involved in Business Analyst testing
• Strong experience in developing TEST palns in Mercury QC
• Highly motivated, energetic individual and a team player with good communication and interpersonal skills.
• Ability to learn and adapt to new tools.
• Well versed with CMM and ISO 2000 quality standards.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows XP/NT,UNIX,LINUX

DATAWARE HOUSING TOOLS: Informatica 9.1/ 8.x/7.x/6.x5.x, Informatica B2B Data Transformations, Data Exchange, Informatica Data Quality(IDQ), Power Exchange (CDC), SSIS,DTS

DATA MODELLING TOOLS: Erwin 5.0

REPORTING TOOLS: Business Objects XI R2, SSRS, Viador

DATABASES: Oracle 8i/9i/10g/11g, SQL server 2000/2005/2008 , Teradata 13.1

DATABASE UTILITIES: TOAD, PL SQL developer, Management Studio, Benthic

SCHEDULING TOOLS: TIDAL, Control-M, Cron tabs

VERSION CONTROL TOOLS: PVCS, Synergy

LANGUAGES: C,C++,JAVA,COBOL

SCRIPTING LANGUAGES: UNIX, VB, PERL

PROFESSIONAL EXPERIENCE:

Confidential, Virginia Beach, VA

Sr. ETL Developer

Responsibilities:

• Develop Informatica maps to extract data from different source systems into Teradata targets and flat files
• Experience in loading unstructured data using Informatica B2B Data Transformation.
• Created Informatica Custom and Automatic profiles to profile source data
• Created rules in IDQ
• Created Informatic Change Data Capture maps
• Experience in utilizing teradata load utilities(Fast Laod, Mload)
• Experience in writing BTEQ scripts
• Worked with DBAs in Informatica deployment
• Involved in query performance tuning and Informatica performance tuning
• Created terdata PL SQL procedures
• Experience in creating SSIS packages and SSRS reports
• Created Business Requirement Documents and ETL mapping documents
• Created Test plans in Mercury QC
• Involved in Staging and Integration QA testing as part of Business Analyst Testing
• Experience in mentoring Jr. Developers

Environment: Informatica 9/1/8.6.1, IDQ,PowerExchange,Oracle 10G, Teradata,SQL Server 2008, Oracle 10 g,SSIS,SSRS, Mercury QC,Subversion

Confidential, Richmond, VA

Sr. ETL Developer

Responsibilities:

• Involved in Data archival project
• Developed mappings to archive data
• Providing results to Query Requests
• Application Enhancement
• Developing test plans in Mercury Quality Center
• Involved in data migration project and developed Informatica maps
• Developed DTS and SSIS packages
• Involved in Data validation project
• Involved in SQL Server 2008 Upgrade
• Supporting the NCDW application

Environment: Informatica 8.6.1, Oracle 10G, SQL Server 2000/2005/2008 , DTS,SSIS,Viador Reporting, Mercury QC,Synergy

Confidential, Boston, MA

Sr. ETL Developer

Responsibilities:

• Involved in getting the requirements
• Prepared Business Requirement Documents
• Designed and developed the Informatica mappings based on the requirements
• Worked with sources like XML, flat files and relational
• Extensively used Joiner, Lookup, Aggregator, Update Strategy Transformations
• Created Reusable Transformations and mapplets and used them in mappings
• Created UNIX Scripts to automate the Workflows
• Involved in the code migration process
• Designed Test Plans to test Informatuica mappings

Environment: Informatica 8.1.1, Oracle 9i, SQL Server 2005 SQL/PLSQL UNIX, TOAD, PVCS

Confidential, Boston, MA

Sr. ETL Developer

Responsibilities:

• Understand the existing systems.
• Creating Dependency Documents
• Convert Informatica Scheduling process to ESP scheduling process
• Create Batch Control Information for applications
• Create Load Statistics for mappings
• Create Email tasks to notify Load Success to Business Users
• Perform the Unit Testing of mappings

Environment: Informatica 8.1.1, SQL Server 2005, Windows 2003 Server, UNIX, PVCS

Confidential, Boston, MA

Sr. ETL Developer

Responsibilities:

• Understand Business Requirements and developing business specifications.
• Defining the new Data warehouse Standards and techniques
• Extensively involved in designing Data Extraction and Loading (ETL) process from source to target using Informatica Power Center. the current data warehouse team how to design and implement their data warehouse based on their own unique necessities.
• Tuning the corporate data warehouse including database tuning, query tuning, ETL tuning and re-modeling.
• Extensively used transformations like Lookups, Update strategy, joiner, Router and Stored Procedure during mapping development.
• Created Reusable transformations and mapplets.
• Developed complex queries to override default SQL queries.
• Performed extensive debugging.
• Created control files for data validation
• Created UNIX scripts to run mappings.
• Created FTP scripts.
• Supported ETL and Business Objects applications,
• Defined the dimensions and the fact tables for the current reports data elements.
• Developed new enhancements and reports based on user’s requirement.
• Trouble shooting Informatica mappings and Business Objects Reports.

Environment: Informatica 8.1.1, Business Objects XI, Oracle 9i,SQL/PLSQL,UNIX, Rapid SQL

Confidential, Chicago, IL

Sr. ETL Developer

Responsibilities:

• Understand Business Requirements and developing business specifications.
• Extensively involved in designing Data Extraction and Loading (ETL) process from source to target using Informatica Power Center.
• Extensively used transformations like Lookups, Update strategy, joiner, Router and Stored Procedure during mapping development.
• Created Reusable transformations and mapplets.
• Developed External PL/SQL Procedures.
• Implemented Exceptions handling through mappings.
• Developed complex queries to override default SQL queries.
• Performed extensive debugging.
• Performed performance tuning.
• Extensively worked on Repository object.
• Scheduled jobs using Workflow manager.
• Supported ETL and Business Objects applications,
• Developed new enhancements and reports based on user’s requirement.
• Worked closely with testing team to test the business logic,
• Trouble shooting Informatica mappings and Business Objects Reports.

Environment: Informatica 7.0, Business Objects 5.1.8, Oracle 9i, Unix

Confidential

Developer

Responsibilities:

• Worked on data analysis for various source systems.
• Involved in the analysis Dimensions and Facts.
• Created design documents based on the Business Requirements.
• Creating mappings, applets and stored procedures
• Implemented change requests
• Developed Sessions and Batches for mappings.
• Creating test cases and testing the Informatica mappings.
• Implemented slowly changing dimensions.
• Used SQL loader to load some of the files to Data warehouse tables.
• Involved in UAT
• Developed UNIX shell scripts to automate the jobs with restart ability.

Environment: Informatica 6.2, Oracle 9i, Unix

Confidential

Developer

Responsibilities:

• Involved in creation of Universe
• Production Support like resolving some reporting tickets, Universe enhancement tickets, and user creation tickets.
• Developed reports according to user’s requirement.
• Fine tuning the reports.
• Informatica load monitoring and mapping enhancements.
• Informatica and Business Objects Trouble shooting.

Environment: Informatica6.2, Business Objects 5.1.8, Oracle 9i, Windows NT

Confidential, FL

Developer

Responsibilities:

• Worked with Informatica tools like Source Analyzer, warehouse Designer, Transformation Developer, Mapping and Mapplet designers.
• Involved in Designing and Development of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds using Informatica.
• Involved in the Development of different Informatica mappings and tuned them for better performance.
• Supported the Applications in Production Environment.

Environment: Informatica 6.2, Business Objects 5.1.8, Oracle 9i

Confidential, CA

Developer

Responsibilities:

• Involved in the development of Informatica mappings and also tuned them for better performance.
• Created different transformations like Joiner, Router, Update Strategy, Lookup, Expression and Aggregator.
• Created stored procedure transformation to call database stored procedures from informatica mappings.
• Scheduled and monitored transformation processes using Informatica Server Manager.
• Involved in designing and maintaining Business Objects Universe using Business objects Designer.
• Involved in production support, Manual Test, Supported in User Acceptance Test.

Environment: Informatica6.0, Business Objects 5.1.8, Oracle 9i

Confidential

Team Member

Responsibilities:

• Created repository and security domains with user groups.
• Create the Universe using Business Objects-Designer.
• Handled loops while designing.
• Developed the reports using Business Objects.
• Creation of reports like, Reports by Customer, Reports by Period, Demographic reports and Comparative reports Using Business Objects. Working with database connections, SQL joins, cardinalities, loops, aliases, aggregate conditions, parsing of objects and hierarchies.
• WebI reports were created and deployed through Info View.

Environment: Oracle Warehouse Builder, Business Objects 5.1, ERwin 3.5.2, Oracle 8i

Confidential

Developer

Responsibilities:

• This module generates purchase orders for goods that fall below a pre-defined re-order quantity and periodically updates the Master Inventory Management module. Created completely menu driven GUI screens for the company's customer service (non-technical) department.
• Involved in the development of an integrated Sales/Inventory Management System.
• Worked with customers to find and implement optimal front-line software solutions for a range of applications.
• Played a key role in the development of the Inventory transactions control module, which keeps track of orders from customers (retail outlets), purchase orders, total stock on hand as well as the stock at individual warehouses, shipment and feedback information from retailers and overseas vendors.

Environment: Windows NT, Oracle 7.3, Java2.0

Confidential

Developer

Responsibilities:

• An internal project carried out for Sagarsoft (India) Limited covering Hr and Administration business processes like Leave Approval, Payroll, Loans and Advances, Library Management System.
• Involved in database programming.
• Implemented complex database updates as requirements to automate business processes through stored procedures.
• Involved in developing servlets.
• Database administration activities such as backup, recovery, scheduling the activation and triggering of stored procedures, etc.