SUMMARY

• 7+ years of experience on Data warehouse & Business intelligence technologies, ETL development and designing, data modelling, reporting and Business/Data Analysis.
• Excellent working experience & sound knowledge on Informatica ETL tool. Expertise in reusability, parameterization, workflow design, designing and developing ETL mappings and scripts.
• Extensive Knowledge of RDBMS concepts, PL/SQL, Stored Procedure and Normal Forms.
• 6+ years of experience in Data Migration, Data Integration, Data Conversion.
• 6+ years of good exposure on optimizing the SQL and performance tuning.
• 6+ years of experience in Global Data Conversion with various databases.
• Solid understanding of both technical and functional data quality concepts.
• Excellent experience on Oracle 8i/9i/10g, SQL server 2005.
• Demonstrated technical expertise on popular business intelligence tools such as Informatica, Cognos and QlikView
• Experience in developing analytics, dashboards, adhoc reports, published reports, static reports through Cognos and Qlikview.
• Expertise in Cognos BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio).
• Developed and Published Packages using Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Experience on developing and maintaining Qlikview QVDs and QVWs and generating automated reports from Qlikview application (QVW).
• Expertise in UNIX shells scripting.
• Expertise in setting up load strategy, dynamically passing the parameters to mappings and workflows in Informatica.
• Experience in developing end to end business solution by providing design solutions on technologies to be used.
• Well experienced in functional and technical systems analysis & design, systems architectural design, presentation, process interfaces design, process data flow design, and system impact analysis and design documentation and presentation.
• Experience with dimensional modelling with both star and snow flake schema using Ralf Kimball methodology with experience in manufacturing & logistics projects. Well versed with extract and loads of large data volumes.
• Experience in extracting data through Relational databases, flat files, excels XML files.
• Proven experience in project and team leading with zero defect delivery. Equally comfortable working independently as well as in a team environment
• Excellent experience on implementing slowly changing dimensions - Type I, II & III
• Excellent experience in handling and leading team of 10 people which involve onsite and offshore model.
• Excellent knowledge of planning, estimation, project coordination and leadership in managing large scale projects.
• Good interpersonal communicator who effectively interacts with clients and customers
• Decisive, energetic and focused team lead/player takes ownership and responsibility for requirements and contributes positively to the team.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post-implementation review.
• Competent technical knowledge with 6+ years of hands on experience. Strong problem solver who can design & develop solutions and assist developers with issues.

TECHNICAL SKILLS

Programming Languages: SQL,T-SQL, PL/SQL

DBMS: Oracle 8i/9i/10g,Greenplum, SQL-Server 2005/2008,MS Access

Reporting Tools: Cognos, Qlikview

ETL Tools: Informatica 7.1, 8.1 & 8.6, 9x

Design/CASE Tools: MS Project, Visio

Operating Systems: Win 2003/XP/2000/NT, MS DOS, UNIX

Miscellaneous: ERWIN, TOAD 7.x

Scheduling Tools: Opswise, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. BI Developer

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Architecture and Development with high volume transaction systems.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, XML Transformation and Aggregator Transformation.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Solid Expertise in using both Connected and Un connected Lookup transformations
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling.
• Involved in defining the overall strategy for design and standards by creating many checklists for smooth deployments.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Data Integration, Data conversion and Migrating the data from Source to Target
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Usage of reusability in Informatica, parameterization, workflow design and mapping design.
• Performance tuning of Informatica mappings.
• Scheduling the jobs of Informatica, Cognos and qlikview using OPSWISE
• Writing PL/SQL stored procedures, functions, nested tables. Extensive hands on experience in PL/SQL.
• Developed various Complex report types ranging from simple Lists, Cross-tabs through complex dashboards, drill-through, Master-detail & conditional formatting reports.
• Designed and Developed the Framework Manager models and Published into the Cognos Connection.
• Developing various types of charts, containers, dash boards and building QVDs and QVWs in Qlikview.
• Involved in estimation, design and architectural discussion with architecture team for data warehouse.

Environment: Informatica 9.1 on UNIX, Greenplum, MS SQL 2008, Cognos 10.1, Qlikview, Opswise.

Confidential, Detroit, MI

Lead Informatica Developer

Responsibilities:

• Designed and developed Informatica Power Center mappings to Extract, Transform and Load (ETL) data from source to target.
• Tuned Performance of complex Informatica jobs involving huge Data files by adjusting Block Size, Data Cache Size and Target based commit interval.
• Fine-tuned existing ETL mappings for performance increase measures.
• Resolved bugs/issues that occurred due to incorrect understanding/analysis of business rules.
• Involved in identifying the source tables and defining the extraction criteria.
• Complex SQL queries were written as per specifications and extensively wrote Fast Export scripts for data extraction from Teradata.
• Extracted order transaction data using power connect from salesforce.com systems to load to Oracle target tables.
• Loaded and joined Salesforce.com data to the database using Update strategy to appropriate tables per business rules.
• Data Integration, Data conversion and Migrating the data from Source to Target
• Developed Informatica mappings to load data from various sources into different targets.
• Used various ETL Transformations such as Look-Up, Joiner, Aggregate, Filter and Update Strategy.
• Used the Debugger to validate the transformations by creating Break Points and analyzing the Debug Monitor.
• Involved in writing SQL Stored Procedures to access data from Oracle Database.
• Fine-Tuned Existing Mappings for better performance. Documented Mappings and Transformations.
• Simplified the data flow by using a Router transformation to check multiple conditions at the same time.
• Created customizable mapping by passing parameters at session level.
• Responsible for development and testing of conversion programs for importing data into Oracle data warehouse utilizing PL/SQL and Unix Shell Scripts.
• Also responsible for development of interface programs utilizing Unix Scripts

Environment: Informatica 8.6, 9.1 on UNIX, Oracle 10g, PL/SQL, TOAD.

Confidential, New York NY

Sr.Informatica Developer

Responsibilities:

• INFORMATICA - extraction from Oracle DB, transform and load to Oracle DB.
• Excellent knowledge on work flows, sessions, tasks, transformations, mappings, file lists, performance tuning.
• Coordinating with off shore Team for delivering the best solution to the client.
• Usage of reusability in Informatica, parameterization, workflow design and mapping design.
• Scheduling and performance tuning of Informatica mappings.
• Prepared mapping documents and technical specifications
• Writing PL/SQL stored procedures, functions, nested tables. Extensive hands on experience in PL/SQL.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Extensively used ETL to load data from different sources like Oracle, Flat files,XML etc., into the Staging table and load the data into the Target database.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Collaborated with data modellers, ETL developers in the creating the Data Functional Design documents.
• Created the Staging mappings for delta detection using the different Transformations (Expression, Lookup, Joiner, Filter, Router, Stored Procedure etc.)
• Free hand SQL, reports with calculation context and drill down features.
• Universe with aggregate navigation and derived tables.
• Requirements analysis, Design, Code and Design reviews.
• Designed and implemented star and snowflake schemas to handle 1: N and M: N relationships.
• Data Integration, Data conversion and Migrating the data from Source to Target
• Scheduling and broadcasting of reports.
• Knowledge of various DW industry tools, so able to suggest a best solution at the right time.
• Writing PL/SQL functions and procedures, use of cursors, complex queries and ability to guide the team. Excellent communication skills
• Scheduling various ETL and reporting jobs using Control-M

Environment: Informatica 8.6 on UNIX, Business objects, Oracle 10g, PL/SQL, MS SQL 2005, Control-M and TOAD.

Confidential, Portland OR

Informatica Developer

Responsibilities:

• Developed Mappings and Reusable Transformations for ETL using Informatica Power Center.
• Worked extensively on different types of Informatica transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator and joiner.
• Developed and tested all the Informatica Power Center mappings involving User Defined Functions, Variables, Parameters, complex Router, lookups and update strategies.
• Used Informatica’s features to implement Type I, II, and III changes in slowly changing dimension tables.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• Used PMCMD commands in non-windows environments.
• Data Integration, Data conversion and Migrating the data from Source to Target
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Created complex mappings to load data from various sources into Oracle, XML files.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Created the meta data layer using Cognos Framework Manager to simplify the end user presentation of the data
• Created of “Drill Pathways” with the Cognos Meta Data layer
• Authored documents involvingdetailed design document (DDD), unit test case scenarios, and knowledge transfer.
• Analyzed the session, event and error logs for troubleshooting mappings, sessions and workflows.
• Monitored and configured the production ETL processes that run daily, weekly and monthly.
• Created various challenging Cognos reports such as Support Ticket Summary Report, Open Ticket Report, Agency Resource Time Report and Product Detail Report.

Environment: Informatica 8.6.1, Cognos 7x/8x, Oracle 9i, PL/SQL, TOAD, Autosys, Windows NT

Confidential, Hamilton NJ

Software Engineer

Responsibilities:

• Designed and developed Star Schema, Snowflake Schema and created Fact Tables, Dimension Tables, Lookup Tables for the Warehouse, Data Marts and Business Intelligence Applications using Microsoft Visio and Erwin Tools.
• Used the features of Erwin and Informatica to define Tables, Views, Indexes, Primary key, foreign key, Procedures, and Entity Relationship Diagram.
• Extraction, Transformation and Loading of Data from Sources such as SQL Server, MS Access, Excel Spreadsheets, XML, and Text Files using Informatica, SQL Loader, ODBC Connection to target Warehouse Tables.
• Wrote stored procedure to check source data with Warehouse data if it not present written that records to spool table and used spool table as Lookup in Transformation
• Migrated data from COBOL flat files to Oracle database.
• Tuning of SQL Queries, Procedures, Functions, and Triggers.
• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Designed data transformation from Transient to Staging Fact and Dimension Tables to Warehouse.
• Implemented Variables and Parameters in Transformations to calculate billing data in billing Domain.
• Involved in the design of ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profile.
• Written Unix Shell Scripts to load data from different sources.
• Implemented Aggregate, Filter, Join, Expression, Lookup, Rank and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Simplified the data flow by using a Router transformation to check multiple conditions at the same time.
• Created customizable mapping by passing parameters at session level.
• Responsible for development and testing of conversion programs for importing data into Oracle data warehouse utilizing PL/SQL and Unix Shell Scripts.

Environment: Oracle, DB2, SQL Loader, Informatica Power Center 8.1, Power Mart, SQL Server7.0, Erwin 4.0, UNIX Shell Scripts, UNIX

Confidential

Software Engineer

Responsibilities:

• Understanding and Preparation of requirement for CIM application.
• Running the SQL scripts from TOAD and creating Oracle Objects like tables, views, Indexes, sequences and users.
• Writing the commonly used Oracle stores procedures and functions.
• Building the Informatica mappings using Lookup, aggregator, update strategy, filter, normalizer, sorter, and router transformations.
• Preparing the test cases and performing the unit testing CIM application.
• Implementation database and codes at the client location
• Daily and weekly database backups.
• Database monitoring, table space extension, user locks checking on daily basis.
• Creation of users, database schemas, tables, indexes, views and sequences.
• Preparation of requirement and design documents.

Environment: Informatica PowerCenter 7.1, Oracle 8, TOAD, Linux, PL / SQL