SUMMARY

• 9.5+ plus years of Professional experience in Information Technology with extensive experience in Oracle SQL, PL/SQL, Unix and 5+ years of experience in ETL(Informatica) with Development Life Cycle like Analysis, Design, Development, Testing, Implementation, and Support of Data Base Development, Data warehousing and Data integration solutions.
• Expertise in Data Warehousing experience using Informatica Power Center as Workflow Manager, Mapping Designer, Workflow Monitor and Repository Manager.
• 5+ Years of experience to lead the team with provided necessary guidance and training.
• Strong experience in writing PL/SQL stored procedures, functions, packages and triggers.
• Involved in Performance Tuning in Data Warehouse applications including the creation of materialized views, bitmapped indexes and partitions.
• Extensive experience in Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT,
• Strong experience of leading multiple ETL projectsof team members between 3 - 7
• Expertise in Extraction Transformation Loading (ETL) process, Dimensional Data Modeling experience using Data modeling, Star schema/ Snowflake modeling, Fact and Dimensions tables, Dimensional, Multidimensional modeling and De-normalization techniques
• Expertise in design and implementation of various types Slowly Changing Dimensions (SCD) types.
• Worked on various types of transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router, Normalizer, Sorter, External Procedure, Sequence Generator, and Source qualifier and SCD Type-2 etc.
• Expertise monitoring workflows, pipeline partitioning, configuring email.
• Expertise in Business Model development withDimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in implementing Power center Mappings, Mapplets and Workflows for the different stages of ETL.
• Experienced inUNIX shell scriptsto run Informatica workflows and controlling the ETL flow.
• Creating the job for file processing, file validation, error mechanism, parallel processing by using UNIX shell scripting.
• Expertise in Query Analyzing and Performance tuning.
• Experienced in Requirement gathering, designing (Technical Design) ETL interfaces, reviewing mapping design by team members as well as leading the team in coding, testing, performance tuning in developing Informatica mappings and workflows, production migration and providing stabilization support.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Metadata Manger), Power Exchange, and Power Connect as ETL tool on Oracle Databases.
• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Experienced in working with tools like TOAD, Teradata SQL assistance and SQL plus for development and customization.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures and granting privileges on OLTP server.
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Worked with AUTONOMOUS TRANSACTIONS in Triggers and Functions in order to include logging.
• Experienced in ETL development and Data Migration using native tools of Oracle (SQL LOADER, Oracle External tables and PL/SQL).

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.x, 9.x, Informatica ADMIN

Tools: Toad, SQL Developer, MS Visio Power Designer.

Databases: Oracle 8i/9i /10g/ 11g, DBA

Operating Systems: UNIX, Windows XP, Windows 2000 Server, Windows 7 & 8.

Methodologies: Data Warehousing Design, Data Modeling, Logical and Physical Database Design.

CM Tools: Star Team, VSS

Job Scheduler: CronTab 7, Maestro jobs, Autosys R11.0

PROFESSIONAL EXPERIENCE

Confidential, Shrewsbury, MA

Lead Informatica Developer

Responsibilities:

• Configuring a session to send email when it fails or succeeds. Also can create separate email tasks for success and failure email.
• Effectively using the Secure Shell, or SSH, is a cryptographic (encrypted) network protocol for initiating text-based shell sessions on remote machines in a secure way and This allows a user to run commands on a remote machine's command prompt.
• Using Cygwin is an emulation layer that allows programs written for UNIX, GNU, or Linux systems (POSIX environment) to run on MS Windows platforms.
• Creating the RulePoint complex event processing software provides proactive monitoring and operational intelligence by delivering real-time alerts and insight into pertinent information, enabling to operate smarter, faster, more efficiently, and more competitively. Its real-time alerts are based on sets of conditions defined by business users.
• Achieved the complicated business logic by using Informatica’s Stored Procedure transformation.
• Established the connection and refresh the data from one DB to another DB by using the Oracle Materialized View
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Prepared the required application design documents based on functionality required
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target.
• Wrote the Algorithm for ETL (Extract, Transform and Load) team for Data Validation.
• Performed various transformation logics by utilizing the Source Qualifier, expression, filter, joiner, lookup, router, Update Strategy and rank
• Mostly worked on Dimensional Data Modeling using Data modeling Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions types.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Migrated repository objects, services and scriptsfrom development environment to QA environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Wrote Queries, Procedures and functions that are used as part of different application modules
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.

Environment: Windows XP/NT, Informatica Powercenter 9.6.1, UNIX, Oracle 11g, SQL, PL/SQL,SQL Developer, MS VISIO, Unix Shell, CronTab 7.

Confidential, Dallas, TX

Lead Informatica Developer

Responsibilities:

• Team lead, responsible for the assignment of tasks for the team members, creation of Metrics reports, weekly status reports, preparation of project plan and quality related documents & migration documents etc. Used share point to maintain documents and tracking.
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Prepared the required application design documents based on functionality required
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Teradata Warehouse database.
• Wrote the Algorithm for ETL (Extract, Transform and Load) team for Data Validation.
• Built the BTEQ scripts to validate the Edge Model and to generate Surrogate Key.
• Performed various transformation logics by utilizing the Source Qualifier, expression, filter, joiner, lookup, router, Update Strategy and rank
• Mostly worked on Dimensional Data Modeling using Data Modeling Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Implemented effective method of Change Data Capture (CDC) to capture the changes from source and implemented the same in target.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions types.
• Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command.
• Created and managed different Power exchange directories like condense files directory, check point directory etc.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Implementeddaily and weekly audit processfor theeachsubject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
• Migrated repository objects, services and scriptsfrom development environment to QA environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Interacting different type of source and target like Oracle, Teradata, DB2, Flatfile, XML files, EBCDIC files.
• Wrote Queries, Procedures and functions that are used as part of different application modules
• Optimized Teradata SQL queries for better performance.
• Extract and Load data using different tools in Teradata like Multiload, FastExport, Fastload, OLE Load, BTEQ.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.

Environment: Windows XP/NT, Informatica Powercenter 9.1/8.6, UNIX, DB2, Oracle 11g, SQL, PL/SQL, Toad, MS VISIO, Unix Shell, Quality Center 10.,Power Exchange 8.6.1Star Team, Maestro job

Confidential

Lead Consultant /Sr. Informatica Developer

Responsibilities:

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Involved in analyzing the source data coming from different Data sources such as XML, flat files and identifying data anomalies in operational data.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, Stored procedure and XML transformations.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer and Transformation Developer.
• Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• I was given Informatica Lead role by the client, which includes, involving in Business requirement discussion, understanding the requirements from Business team, pass on the requirements to offshore dev team and lead the project from Design, Dev, Unit testing and Deployment.
• Handled all XML data integration challenges, including integration complexity, visibility into hierarchical data, high-performance requirements, and maintenance related to frequent changes
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Developed automated scripts using Unix Shell for performing runstats, reorg, rebind, backup, load, export and other related to database activities.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Used Mapping variables for Incremental Extraction of operational data.
• Wrote Unix Shell scripts to automate workflows.
• Used Workflow Manager for creating workflows, worklets, email and command tasks.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables.
• Used FTP services to transfer Flat Files to the external targets.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Worked on Migration Strategies between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.

Environment: Informatica Power Center 8.6.1, Oracle 9i, SQL*Plus, SQL Loader, SQL Developer, Flat files, UNIX, Windows 2000,.0.

Confidential

Senior DataBase Developer

Responsibilities:

• Extensive work experience in SQL and PL/SQL by writing Stored Procedures, Functions, Packages and Triggers.
• Experienced in ETL development and Data Migration using native tools of Oracle (SQL LOADER, Oracle External tables and PL/SQL)
• Exporting data using expdb and Importing data using impdb
• Familiarity with Oracle Data Warehousing features such materialized views, bitmap indexes, Index Organized Tables, external tables etc.
• Experienced in UNIX shell programming
• Experienced in Database Optimization by making use of various Performance Tuning techniques.
• Proficient in database and SQL tuning using HINTS and EXPLAIN PLAN.
• Very good knowledge and experience in using Oracle in-built packages like UTL FILE, DBMS SQL etc.
• Very good working knowledge in TOAD.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Worked with AUTONOMOUS TRANSACTIONS in Triggers and Functions in order to include logging.
• Modified Packages, Procedures, Functions and Triggers for designing user interface.
• Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer.
• Trouble shouted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger
• Involved in creating Functional and Program Specification documents.
• Lead in the design, develop, and implementation of applications, interfaces, and other creations written in PL/SQL and UNIX.
• Stage tables/packages to load history files using SQLLDR and external tables
• Exporting data using expdb and Importing data using impdb
• Involved in the creation of Partitioned Tables and Indexes
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures and granting privileges on OLTP server.
• Used FTP to transfer the files into different servers as needed by the business users.
• Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, and nested queries, views for the business application development.
• Worked with Bulk Collections for bulk load processing.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.

Environment: Oracle 9i, SQL, PL/SQL, UNIX, Windows, TOAD, Oracle Forms and Reports, Serena Dimensions (PVCS).

Confidential

T-SQL Developer

Responsibilities:

• Writing SQL, T-SQL procedures According to the business needs.
• Transferring data from source to destination by using DTS or SSIS Package.
• Created DTS or SSIS packages with integration of stored procedures, functions.
• Effectively used the SSIS controls like FTP upload/download and mailing.
• Involved in Analysis, Design and Development and also responsible for preparing LLD document, UML Modeling, RTM, Check Lists and UTC documents.
• Reviewing the Low level design documents.
• Coordinating with onsite team and client frequently to get better understanding of requirement.
• Expertise in writingT-SQL Queries, Dynamic-queries, sub-queries and complex joins for generatingComplex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
• Created SSIS Packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional,Drill-down,Top N, Summary, Form,OLAP and Sub reports, and formatting them.
• Experience inimporting/exportingdata between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.

Environment: DOT NET, MS SQL Server 2000 and 2005, SSIS SSRS, SSAS, VSS.