SUMMARY:

• Over 10 Years of IT experience in Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications which includes strong experience in Data Warehousing (ETL & OLAP) environment.
• Experience in working Agile/Scrum and Waterfall methodologies (SDLC).
• Expertise in Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements.
• Proficiency in utilizing ETL tool Informatica PowerCenter 9.x/8.x/7.x/6.x for developing the Data warehouse loads as per client requirement.
• Knowledge on data profiling and analysis making use of Informatica Data Explorer (IDE), Informatica Data Quality (IDQ) and Informatica Developer (ID).
• Expertise in designing confirmed and traditional ETL Architecture involving Source databases Main Frame systems (COBOL files), Oracle, Flat Files ( fixed width, delimited ),DB2, SQL server, XML and Target databases Oracle, SQL server, XML and Flat Files ( fixed width, delimited )
• Extensive experience in designing and developing complex mappings applying various transformations such as Lookup, Source Qualifier, Update Strategy, Router, Sequence Generator, Aggregator, Rank, SQL, Stored Procedure, Filter, Joiner, Sorter transformations, Mapplets.
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Proficient in delivering the high data quality by designing, developing and automation of audit process and implementation the reconcile process accordingly.
• Excellent knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions by implementing various techniques like partitioning techniques and pushdown optimization
• Experience with database languages such as SQL and PL/SQL which includes writing triggers, Stored Procedures, Functions, Views and Cursors.
• Profound knowledge about the architecture of the Teradata database. Developed Teradata Loading and Unloading utilities like Fast Export, Fast Load, and Multiload (Mload).
• Extensive knowledge with Teradata SQL Assistant. Developed BTEQ scripts to Load data from Teradata Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements. Tuned the existing BTEQ script to enhance performance.
• Experience in Shell scripting, FTP and file management in various UNIX environments.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Expertise in version control tools like SVN and VSS.
• Excellent team player, multi - taking and self-starter with good ability to work independently and possess good analytical, problem solving and logical skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.x/8.x/7.x/6.x, Informatica Power Exchange 7.x/8.xInformatica (IDQ, IDE, ID and IA), Datastage, SSIS.

OS: Sun Solaris 2.x/7/8, HP-UX, IBM AIX, Unix, Linux, Ms-DOS, Windows

Databases: Oracle(8i/9i/10g/11g), SQL Server, DB2, Teradata, Sybase, MS-Access, XML

Programming Skills: C++, Shell Scripting, PL/SQL, HTML, JAVA Script, J2EE, CSS

Db Tools: SQL*PLUS, SQL*LOADER, Quest TOAD, SQL Navigator, SQL developer, Oracle Enterprise Manager, Oracle

DM Tools: Erwin, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Fairfax, VA

Sr. Informatica/ ETL Consultant

Responsibilities:

• Worked with Business analysts, Data Architects, Data Modelers and ETL leads to translate business requirements into technical requirements.
• Prepared data mapping documents by analyzing the data from Source system and ODS.
• Performed code reviews on the programs developed by team members.
• Worked extensively with Agile Project methodology with daily stand-ups and weekly meetings.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Extracted data from Oracle source system and loaded into Oracle ODS/Data mart (Dimension and Fact tables) and flat files.
• Designed and developed ETL mappings in Power center making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Expression, Router, Filter, Normalizer, Aggregator, SQL and Sequence Generator.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables, Session Parameters and Parameter Files.
• Extensively tuned the SQL queries which are being used as a part of different transformations such as look ups, source qualifiers and SQL transformations.
• Extensively optimized all the Informatica sources, targets, mappings and sessions by finding the bottlenecks in different areas and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Adapted existing UNIX Shell scripts for automation of different processes.
• Co-ordinated with Quality Assurance team in QA and UAT testing.
• Used JIRA ticketing systems to open CMR’s and SR’s.

Environment: Informatica Power Center 9.6.1, Agile, Oracle Exadata, SQL, Flat Files, SVN, UNIX, Putty, Winscp, SQL Developer, JIRA.

Confidential, Buffalo, NY

Sr. Application Developer

Responsibilities:

• Worked with product and business owners and business analysts, for requirement gathering, business analysis, and translated the business requirements into technical specifications.
• Worked closely with Enterprise Architects, Solution Architects and Information Data Analyst for data field analysis, design and developments of Informatica programs and Tidal flow.
• Prepared data mapping documents by analyzing the data from Source systems and Warehouse.
• Prepared technical design documents for the development of Informatica (ETL) process to load data into various target tables.
• Performed code reviews on the programs developed by other teams.
• Worked extensively with Agile Project methodology with daily stand-ups and weekly grooming sessions.
• Worked with Scrum Masters on daily basis to clear barriers for the development.
• Worked with team of developers to design, develop, and implemented the solutions.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Extracted data from various source systems like DB2, SQL Server, Oracle and flat files and loaded to a relational data warehouse and flat files.
• Designed and developed complex ETL mappings in Power center making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Expression, Router, Filter, Normalizer, Aggregator, SQL, Sequence Generator and XML transformations.
• Designed and developed Mapplets, shortcuts for faster development, standardization and reusability purposes.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Developed full and incremental loads of data into the target databases.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables, Session Parameters and Parameter Files.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Extensively tuned the SQL queries which are being used as a part of different transformations such as look ups, source qualifiers and SQL transformations.
• Extensively optimized all the Informatica sources, targets, mappings and sessions by finding the bottlenecks in different areas and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Used pre-session and post-session scripts for dropping and recreating indexes before and after loading data into target table to optimize performance.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.
• Created and adapted existing UNIX Shell scripts for automation of different processes.
• Scheduled Informatica workflows, Unix Scripts, database jobs by creating job groups, jobs, Email Events, File Events, Variables etc. using TIDAL scheduling tool.
• Created Kalido Categories through Kalido GUI tool.
• Created Undraleu Reports for Informatica mappings, sessions and workflows.
• Created various reports based on the client requirements using Crystal Reports.
• Designed and created target database tables/indexes/views in Staging area, personal schema and project folders.
• Used the feature EXPLAIN PLAN to find out the bottlenecks in a given Query, thus improving the performance of the job.
• Worked on SQL tools like TOAD for oracle and Surveyor for DB2 to run SQL queries and validate the data.
• Performed Unit Testing for ETL Mappings and created Test cases Documents.
• Prepared Application workbooks providing guidelines to trouble shoot the errors occurred during the run time and instructions on how to restart the loads for Production Support team.
• Co-ordinate with Quality Assurance and worked with business for UAT.
• Interface with DBA staff, Systems Operations Staff and EDI team to define and get agreement with support and service level agreements.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Actively supported in production support for early life failures and warranty periods.
• Used Service Desk and Altiris ticketing systems to open CMR’s and SR’s.

Environment: Informatica Power Center 9.1.1/ 8.1.1, Kalido, DB2 AS/400, Agile/waterfall, Visio, Undraleu, Crystal Reports, Sql Server, Oracle 11g/10g, Exadata, SQL, Flat Files, XML Files, Visual Source Safe, SVN, Reflection, Unix, TOAD, SQL Developer, Surveyor, DST PowerMHS, Health Rules/Health Edge, Tidal, Altiris, Service Desk, EDI, AIX.

Confidential, Lewisville, TX

ETL Informatica Developer

Responsibilities:

• Assisted gathering business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.
• Extracted data from different source databases such as Oracle, Teradata, and Flat files using Informatica Power Center and finally loaded into a single Data Warehouse.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, Stored Procedure, and Update Strategy transformations for data control, cleansing, and data movement.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager
• Developed and modified BTEQ scripts to load data from Teradata Staging area to Data warehouse, Data warehouse to data marts for specific reporting requirements. Tuned the existing BTEQ script to enhance performance.
• Created Teradata External Loader connections such as MLoad Upsert, MLoad Update, FastLoad and Tpump in the Informatica Workflow Manager while loading data into the target tables in Teradata Database.
• Worked Extensively on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Involved in pre and post session migration planning for optimizing data load performance.
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.
• Worked on SQL tuning using various techniques like hints, creating temporary tables.
• Wrote UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.

Environment: Informatica Power Center 9.1/8.6.1, Oracle 10g, Teradata, Teradata Utilities, SQL Server, SQL, PL/SQL, ERWIN, UNIX Shell Scripts, TOAD, Teradata SQL Assistant, Windows XP.

Confidential, Dallas, TX

ETL Application Developer

Responsibilities:

• Involved in full life cycle design and development of Data warehouse.
• Interacted with business analysts, Source data architects and Source application developer to develop a data model.
• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN.
• Prepared technical specifications for the development of Informatica (ETL) process to load data into various target tables.
• Extracted data from various source systems like Oracle, DB2, and flat files and loaded to a relational data warehouse and flat files.
• Developed ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time. .
• Used pre-session and post-session scripts for dropping and recreating indexes before and after loading data into target table to optimize performance.
• Extensively tuned the SQL queries which are being used as a part of different transformations such as look ups and source qualifiers.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Migrated mappings, sessions, and workflows from Development to Testing and then to Production environments.
• Extensively worked with the QA team to get the system and Integration testing done successfully and involved in ETL testing.
• Worked with Developers to troubleshoot and resolve mapping / workflow / session logic, as well as performance issues in Development, Test and Production repositories.

Environment: Informatica Power Center 7.1.1/8.1.1, Oracle 9i, SQL Server, SQL, PL/SQL, Flat Files, UNIX Shell scripting, TOAD, Maestro, AIX.

Confidential, Worcester, MA

Software Programmer

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Extracted data from different source databases such as Oracle, and Flat files using Informatica Power Center and finally loaded into a single Data Warehouse.
• Developed reusable Transformations and used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, Stored Procedure, and Update Strategy transformations for data control, cleansing, and data movement.
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.
• Wrote UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.
• Performed SQL query optimization using hints, Indexes and Explain plan.

Environment: Informatica Power Center 7.1.1, Oracle 9i, DB2, SQL, PL/SQL, UNIX Shell Scripts, TOAD, Erwin, Windows XP, 2000.

Confidential

SQL Developer

Responsibilities:

• Created, monitored and maintained Oracle databases.
• Created Table spaces for Data and Indexes.
• Created Tables, Indexes, Sequences, Clusters, Triggers, Procedures, Functions and Packages.
• Writing database scripts for user management and roles.
• Formulating optimization strategies based on performance cost and rules.
• Performing SQL query optimization using hints, Indexes and Explain plan.
• Wrote PL/SQL Scripts for DDL operations such as to create alter and drop database objects likes tables, views, sequences, procedures and functions.
• Written stored procedures and functions to retrieve the data from database using PL/SQL.

Environment: Visual Basic 6.0, Oracle 8x, SQL Developer, PL/SQL, Crystal Report 6, Erwin, Windows NT.