SUMMARY

• Over 7+ years of IT experience and worked with whole spectrum of software development cycle in Agile environment, including requirement gathering, Data Analysis, Data Modeling, Development, Enhancement, Deployment, Maintenance and Support.
• Have strong Data Warehousing ETL experience of using SSIS, Dataflow, Control flow, Error Handling.
• Vast experience in Designing and developing complex mappings in SSIS using varied Control flow tasks like Execute Package Task, File System Task, FTP Task, Script Task, Execute SQL Task, Send Mail Task and Dataflow transformations like Lookup, Conditional Split, Data Conversion, Derived Column, Multicast, Sort, Union All, Merge, Script Task, OLE DB Command, Row Count.
• Also used various transformations in Informatica like Source Analyzer, Warehouse Designer, Mapping Designer - data transformation and mapping issues, Mapplets, Transformations, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, and Update Strategy.
• Created C#.Net Script for Data Flow task to fetch data and load it into database through Script component.
• Expertise in working with relational Databases i.e. SQL Server 2005/2008, Oracle 11g/10g/9i, DB2 UDB 9.6/9.7
• Strong knowledge of Data warehousing concepts like Bill Inmon Methodology, Ralph Kimball Methodology, Star Schema, Snow Flake Schema, Dimensional and Relational Modeling, Normalization, Reverse and Forward Engineering. Experience working with ERWIN in creating Conceptual, Physical and Logical Models, Dimensions and Fact Tables.
• Experience with development for terabyte size databases.
• Experience in creating multidimensional cubes using SSAS (SQL Server Analytical Services) and OLAP (Creating Cubes) including interfaces with BIDS.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file using SSIS utility.
• Experience in creating SSIS packages with Error Handling.Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server using SSIS Deployment Utility.
• Involved in all phases of Software Development Life Cycle (SDLC) of Data warehousing in various projects, including requirement gathering from business users, analysis, design creation of mapping documents, development, testing, deployment, enhancement, maintenance and support.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large Data Management sets.
• Worked extensively on Data Analysis, Data Validation, Data Cleansing, and Data migration.
• Extensive experience in Developing Slowly Changing Dimension Mappings of type I, type II.
• Proficient in implementing Stored Procedures, Functions, Triggers, Views using MS SQL Server, PL/SQL.
• Worked on writing scripts for data extraction from text files, remote databases using UNIX shell scripting and wrappers in UNIX, Linux and Windows NT/2000.
• Expertise in tuning the performance of the mappings and sessions in Informatica by determining the bottlenecks.
• Monitored and Tuned MS SQL Server databases using SQL Profiler.
• Strong exposure to working on scheduling tools like SQL Server Agent, AutoSys and Control-M.
• Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and total commitment to the organization goals.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

ETL Tools: SQL Server Integration Services(SSIS) Informatica PowerCenter 9.6.1/9.1/8. x, Informatica PowerExchange8.6.1/8.1

OLAP Tools: SQL Server Analysis Services(SSAS)

Database: Oracle 11g/10g/9i, MS SQL Server 2005/2008,DB2, Teradata

Programming Languages: PL/SQL, SQL, UNIX shell scripting, C#

Job Scheduling: Informatica Scheduler, Autosys and Control M, SQL Server Job Scheduler Agent

Database utilities/Other Tools: MS Office, SQL Developer, Microsoft Team Foundation Server(TFS),Star Team Versioning, Subversion source control (TortoiseSVN), Microsoft Excel, Power point, Rational clear quest, Toad 9.1, SQL*Loader, Erwin 4.0, Microsoft Visio, Microsoft Visual SourceSafe, JIRA

Operating Systems: Windows XP, 2003/2000/XP, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Chicago

ETL Informatica Developer

Responsibilities:

• Responsible for Extract, Transform and Loading the data from various source systems into Enterprise Data Warehouse which supports the reporting needs of the business.
• Involved in requirements gathering, business analysis, testing, and project coordination.
• Worked with Informatica Power Center 9.6.1/9.1 tools i.e. Designer, Workflow Manager, Repository Manager, Source Analyzer, Warehouse designer, Mapping & Mapplet designer and Transformation Developer.
• Designed complex mappings using Source Qualifier, Joiners, Lookups (Connected & Unconnected), Expression, Filters, Router, Aggregator, Sorter, Update Strategy, Stored procedure and Normalizer transformations.
• Also worked with SSIS ETL packages to pull data from different sources, using different transformations like FTP Task, Script Task, Lookup, Derived Column, Data Conversion, Conditional Split, Row Number, Union All, Multicast, OLE DB Command.
• Also responsible to deploy the developed packages in the Development and Production Environment using the SSIS Deployment utilities.
• Worked with Relational Databases, DB2 UDB 9.6/9.7, Oracle 10g/11g, SQL Server 2005/2008. Also worked with external Files.
• Assisted in making the changes to the existing data models to accommodate the new requirements.
• Implemented Informatica loading techniques like Incremental Loading (Change Data capture) and slowly Changing Dimensions SCD TYPE I and SCD TYPE II.
• Designed ETL for loading portfolio snapshot tables.
• Worked with mapping variables, mapping parameters, session parameters, parameter files.
• Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, TO CHAR, Decode, Substr, Instr, MD5, ReplaceStr and IIF functions in Expression Transformation.
• Worked with Informatica Power Exchange to extract the data from SAP.
• Extensively used Informatica Debugger functionality for debugging the mappings
• Worked with Informatica Deployment Groups in migrating the ETL code across environments.
• Responsible for fine tuning the ETL code and sessions which include fine tuning lookup overrides and SQL override queries, implementing the Delta logic (Change data Capture) to speed up the session runs etc.
• Written and fixed various Oracle Stored procedures.
• Responsible for Unit Testing and Integration testing of ETL code.
• Responsible for scheduling the jobs using CA ESP and Informatica scheduler
• Worked with Business System Analysts in understanding the requirements and with Reporting team in fixing the data issues related to the reports.

Environment: Informatica Power Center 9.6.1/9.1(Repository Manger, Designer, Workflow Manager, Workflow Monitor), Power Exchange, SSIS 2005, SSIS 2008, AIX 7.1, DB2 UDB 9.7, Oracle11g, SQL Server 2005, 2008, Flat files, SQL/PLSQL, T-SQL, Windows XP, AQT, Toad, SQL Developer, CA ESP, BMC Remedy, Rational Clear Quest, Tears.

Confidential, Chicago

ETL Developer

Responsibilities:

• Responsible for requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.
• Responsible for extracting the data from legacy systems and transforming it according to the business rules and loading into Oracle 10g database.
• Worked with Informatica power center 8.6.1 tools, Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer.
• Used source qualifier, joiner, Lookups, expression, filter, router, and aggregator, sorter, and update strategy and normalizer transformations for various data transformation activities.
• Worked with SQL override, Lookup override, Lookup caches, and Index and Data caches while designing the mappings.
• Extensively worked with lookup caches like Static cache, Persistent cache, and Dynamic cache.
• Designed reusable transformations and mapplets.
• Worked with mapping parameters and variables, session parameters, pmcmd commands, email tasks.
• Used debugger wizard to troubleshoot data and error conditions.
• Fine-tuned the mapping and sessions for better performance.
• Fine-tuned SQL queries using explain plan and tk prof.
• Responsible for error handling, worked with session logs and workflow logs.
• Handled Informatica administration work like migrating the code using export/import utilities, creation of users, working with shared folders, etc.
• Responsible for Unit testing of workflows.
• Responsible for reconciliation of the loaded data to see whether it is according to the business needs
• Responsible for on call production support and meetings with the various teams.
• Responsible for creating and running the batch jobs (korn shell) in UNIX.
• Used SQL*Loader to load the data from external files to RDBMS tables

Environment: Informatica Power Center 8.6(Repository Manger, Designer, Workflow Manager, Workflow Monitor), Business Objects XI R2, Oracle10g, Flat files, SQL/PLSQL, Windows, UNIX shell scripting, Windows XP, TOAD, SQL Developer, Serena Change Manager (PVCS), Erwin Data Modeler, Mercury Quality Center (for issue tracking), Autosys.

Confidential, Chicago

Informatica Developer

Responsibilities:

• Analysis of application requirements in consultant with the business users and other technical team members.
• Design of data flows using Informatica Power Center.
• Developing complex Informatica mappings using different types of transformations like Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for large volumes of Data.
• Unit and Regression testing of the Informatica Mappings.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Worked with session logs, Informatica Debugger and Performance logs for error handling when session fails.
• Defining Mapping / Session parameters to maintain standards and reusability.
• Performance tuning of long running jobs.
• Worked on Autosys to Schedule jobs.

Environment: Informatica PowerCenter 8.1.1, Oracle 10g, SQL Server 2005, TOAD, Flat files, PL/SQL, Autosys, UNIX, Windows XP.

Confidential

Software Developer

Responsibilities:

• Worked with Business Analysts to understand the requirements.
• Analyze different business requirements and provide time estimate for all SDLC phases (Analysis, Design, Coding, Implementation, SIT, UAT and Production Move).
• Perform ETL processes using SSIS tool for SQL Server
• Design/Develop complex queries efficiently as per the given business requirements.
• Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
• Worked on SCD Type 1 and SCD Type 2 Data loading.
• Worked with Business users to understand the Business Logics as per the need.
• Develop views, sub-queries and joins for complex logic involving multiple tables.
• Used various transformation tasks to create ETL packages for data conversion.
• Loaded flat files into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Created Transact-SQL (stored procedures, views, triggers, sub-queries, joins) in SSIS.
• Generated reports using SQL server reporting services (SSRS).
• Scheduled Jobs and Alerting using SQL Server Agent.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Implemented Custom Logging, Auditing and Custom Email Notifications using SSIS 2008.
• Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure the completeness of batch processes, Scripts and processes.
• Documentation of all the processes involved in maintaining the database for future reference.
• Implemented changes in Cubes (SSAS) as per the requirement.
• Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
• Responsible for maintaining and supporting production databases.
• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
• Perform /coordinated end to end Migration process in TEST /PROD ENV.
• Created C#.Net Script for Data Flow task to fetch data from server and load it into database through Script component.
• Deployed and processed SSAS cubes daily/Weekly /to update information using SQL Server Agent.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.

Environment: SSIS/SSRS/SSAS, SQL Server 2008, Windows XP, Team Foundation Server (TFS), .NET Framework.

Confidential

ETL Developer

Responsibilities:

• Created mapping documents as per the design.
• Developed SSIS packages to extract, transform & load data from different sources like files, databases using various Transformations like Lookup, Conditional Split, Data Conversion, Script Task, Derived Column, Multicast, Sort, Union All, Merge, OLE DB Command, Row Count.
• Created and scheduled Jobs combining different packages.
• Created SQL stored procedures, views and functions for complex data transformation in line design specifications.
• Creating temporary tables and indexes for loading and updating data.
• Performed Unit Testing on all the modules developed.
• Implemented error and exception handling.
• Deployed the jobs in the Production Server using SSIS deployment utility.
• Provided support for the Production Jobs.
• Involved in ETL documentation.

Environment: /Applications: Windows XP, MS SQL Server 2005, SSIS, TortoiseSVN, JIRA

Confidential

ETL and SSAS Developer

Responsibilities:

• Created mapping documents as per the design.
• Developed SSIS packages to extract, transform & load data from different sources Using various Transformations like Lookup, Conditional Split, Data Conversion, Script Task, Derived Column, Multicast, Sort, Union All, Merge, OLE DB Command, Row Count.
• Created and scheduled Jobs combining different packages.
• Created SQL stored procedures and functions for complex data transformation in line with design specifications.
• Creating temporary tables and indexes for loading and updating data.
• Performed Unit Testing on all the modules developed.
• Deployed the jobs in the Production Server using SSIS deployment utility.
• Provided support for the Production Jobs.
• Involved in ETL documentation.
• Involved in enhancing the SSAS Cubes.
• Interaction with the customer, on status calls.

Environment: /Applications: Windows XP, VSS, MS SQL Server 2005, SSAS, SSIS, SSRS.