SUMMARY

• SDLC: 7 years of IT experience in full life cycle of Software Development (SDLC) including Business Requirements Gathering & Analysis, System Study, Application Design, Development, Testing, Implementation, System Maintenance, Support and Documentation
• ETL: 6+years of Data Warehousing experience using Informatica Power Center 9.5/9.1/8.6.1/ 8.5/ 8.1.1/8.0/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), PowerConnect, Power Exchange 8.6, ControlM 6.4, Autosys 3.4.4, TIDAL, SQL, PL/SQL, Stored Procedures, Triggers, etc.,
• Vast experience working on the various transformations - Aggregator, Expression, Sorter, Joiner, Rank, Filter, Router, Lookup, Update Strategy, etc.
• Data Modeling: 3 years of Dimensional Data Modeling experience using ERwin 7.2/4.5, ER/Studio v7. Sound knowledge on Dimensional Modeling, Ralph Kimball and Bill Inmon Methodologies, Star/Snowflake schemas, Data Marts, Facts & Dimensions, Logical & Physical data modeling.
• Business Intelligence: 3 years of Business Intelligence experience using Cognos 7.0/6.0/5.x, Cognos Impromptu Web Reports (IWR), Cognos Report Net 1.01/1.1(Report Studio & Query Studio, Cognos Frame Work manager, Adhoc, Business Objects XIR2/XI/6.5/6.0/5.1, (Web-Intelligence 2.5, Designer 5.1, BO Developer Suite, Broadcast Agent, Supervisor, Designer, Info View, BO Universe Developer, BO Supervisor, BO Set Analyzer 2.0), Crystal Reports 6.x/5.x/4.x/3.x
• Databases: 6+ years of experience using Oracle 11g/10g/9i/8i, DB 2 8.0/7.0/6.0 , MS SQL Server 2005/2000/7.0 , Teradata V2R6/V2R5, Teradata SQL Assistant, MLoad, Fastload, BTEQ, Fastexport, TPump, Sybase 12.x/11.x, SAP R/3, MS Access 7.0/2000, PL/SQL, SQL*Plus, SQL*Loader and SQL Developer

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.1/8.6.1/8.5/8.1.1/8.0/7.1 (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Admin Console). PowerConnect, ControlM, Autosys, Cobol, Data Mining, Data mart, OLAP, OLTP, SQL* Plus, SQL*Loader, TIDAL

BI Tools: Microstrategy 8.1.2/9.1, Cognos Impromptu Web Reports (IWR), Business Objects XIR2/XI/6.5/6.0/5.1, Crystal reports 10x.

Environment: Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos.

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, TOAD, SQL*Plus, SQL*Loader, MS SQL Server 2005/2000/7.0 /6.0, Teradata V2R6/V2R5/R4.1/R4/R3, Teradata SQL Assistant, MLoad, Fload, BTEQ, Fexport, TPump, Sybase 12.x/11.x, MS Access.

Data Modeling: Dimensional Data Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 7.2/4.5, Oracle Designer, Visio and Sybase Power Designer.

Programming: C, C++, SQL, PL/SQL, sql*plus, T-SQL, ANSI SQL, SQL Scripting, HTML, DHTML, Unix Shell Scripting, Kernel Programming, Mainframes VSAM, PERL Programming.

PROFESSIONAL EXPERIENCE

Confidential - Camden, NJ

Sr. Informatica Developer

Responsibilities:

• Participated in gathering Business Requirements and converted them to technical specifications
• Participated in the Logical and Physical data modeling
• Created simple to complex Informatica mappings using different transformations available in Informatica PowerCenter9.5.1 (Source Qualifier, Expression, Lookups (Connected/Unconnected), Joiner, Aggregator, Union, Normalizer, Update Strategy, Filter, Router, Sequence, etc.,)
• Created mapping parameters, mapping variables, mapplets, worklets and reusable transformations wherever reusability can be implemented.
• Created workflows using Parameter Files, Session Task, Email Task, Command Task, Decision Task, etc.,
• Developed Informatica processes by following Best Practices and Naming Standards
• Coordinated with Data Architect in creating and modifying table scripts using Erwin
• Coordinated with Application DBA in creating DB Partitions and Sub-Partitions of type Range-List on Fact tables to improve the performance.
• Created Indexes on partitioned and non-partitioned tables.
• Created Views, Materialized Views (MV) and Stored Procedures to refresh the MV's as and where needed.
• Created shell scripts to execute Informatica workflows on the command line using pmcmd utility
• Created shell scripts to validate and archive files, and to automate FTP file transfers.
• Created and Scheduled Job Streams and Jobs in Tidal.
• Involved in database, ETL and Tidal Jobs migration to QA and Production environments.
• Supported the application during UAT and Production.

Environment: Informatica Power Center 9.5, Microstrategy, Unix Shell Scripting, Sources ( Flat files & Oracle ), Putty, SQL Developer, Tidal

Confidential - Phoenix, AZ

Sr. Informatica Developer

Responsibilities:

• Interacted with End-users for gathering Business Requirements and Strategizing the Data Warehouse processes
• Coordinated with Business Analysts in the creation of the Technical Specification documents, Source/Target Matrices based on the Business Requirements
• Assisted Informatica Lead in enhancing the Naming Conventions, ETL strategies and Best Practices for DW environment
• Designed and implemented a single day and multi day recovery process for index tables
• Responsible for designing an Error checking process for all the indicators or flags and dimension keys for all the dimensions and facts.
• Extracted data from SAP BW Open hubs using ABAP Integration into Stage tables.
• Extensively worked with Source Qualifier, Expression, Aggregator, Joiner, Lookups(Connected/Un connected), Update Strategy, Union, Normalizer, SQL, Router and Filter Transformations
• Created Mapplets, Reusable Transformations, Reusable Session/Email/Command Tasks to increase the code reusability and maintenance
• Created Shell Scripts to Run Informatica Workflows on the command line
• Involved in designing and implementing Change Data Capture techniques
• Extensively used Update Strategy & Lookup (connected and unconnected) Transformations for slowly changing dimensions.
• Provided 24/7 Post-Implementation and Production Support/Maintenance

Environment: Informatica PowerCenter 9.5, Informatica Data Quality 9.6.1, Informatica Power Exchange for SAP NetWeaver, Oracle 11g, RedHat Linux, PuTTY, Toad 9.0, Autosys

Confidential - San Jose, CA

ETL Developer

Responsibilities:

• Worked closely with ETL Lead in converting Business Requirements into Technical Specifications.
• Created Shell Scripts to Run Informatica Workflows on the command line
• Developed mappings to load Slowly Changing Dimensions Type-1 and Type-2, Fact tables
• Created Mappings to load data to Data Marts, like Incremental loading, Target Load Plan, Pre/Post SQL, Normalization, Denormalization, etc.,
• Used transformations like Expression, Lookup, Filter, Router, SQL, Union, Normalizer, Sequence Generator, Joiner, Aggregator, Sorter, Stored Procedure, Update Strategy
• Created and Used shortcuts for sources, targets, reusable lookups, Mapplets, etc.,
• Experience working in Team based environment (Versioned Informatica Repository)
• Followed Informatica Best Practices and Naming Conventions while developing the mappings, sessions and workflows.
• Unit tested the code and closely worked with testing team members in resolving the defects.
• Extensively used mapping parameters and variables to reuse the code.
• Developed Mapplets and reusable transformations to share the code with the team and reuse business logic.
• Documented and presented the code to the team members

Environment: Informatica PowerCenter 9.1/8.6.1, TeradataV2R5, Teradata SQL Assistant, MLoad, Fload, BTEQ, Fexport, TPump, RedHat Linux, PuTTY, Toad 9.0

Confidential

PL/SQL Developer

Responsibilities:

• Created functions with exception handling for various modules as per the requirement.
• Effectively used Conditional Control Statements in programs.
• Created packages with integration of stored procedures, functions, variables, cursors
• Used advanced PL/SQL techniques like cursors for data retrieval.
• Unit tested the code and closely worked with testing team members in resolving the defects.
• Documented and presented the code to the team members
• Supported the application during UAT and Production.

Environment: Oracle 9i, SQL Navigator, Informatica Power Center