SUMMARY

• An accomplished Data Architect & ETL developer, 10 plus years of experience in the field of Data Warehousing, Application Development & Pre - sales activities.
• Extensively worked in Erwin & Infomatica Power Center to create and manage complex Data model & ETL mappings.
• Worked with top-notch clients & organizations at onshore and offshore, in challenging environments and across domains.
• Implemented end-to-end solutions using industry-leading technologies, Designed & implemented innovative solutions to improve process, accelerate development, reduce costs and increase revenue.
• Enabling & helping companies to achieve their highest potential through data
• Broad IT experience, with specialization and expertise in Data Warehousing and Business Intelligence
• Expertise in handling Slowly Changing Dimensions (Type 2 with effective date and active flag)
• Expertise in working with multi-environment like Pre Staging, Staging, Operational Data Store (ODS) & Core Data Warehouse
• Extensively worked in XML Parser transformation to extract XML source into relational database tables
• AccomplishedData Warehouse Architect, Data Modeler and Designer (Relational, Dimensional, Star and Snowflake Schema)
• Self-starter, able to prioritize effectively, rapid learner with exceptional skills in programming, analysis, and problem solving
• Strong ETL/Informatica experience along with installation, configuration and administration of Data Warehouses using tools such as Informatica Power center
• Large enterprise IT experience in various technical and project management roles using key methodologies, frameworks, data modeling & process reengineering, cross-group collaboration, etc.
• Experienced in full software development lifecycle, from analysis to implementation
• Excellent interpersonal skills with all organizational levels
• Effective translator of complex technical information into comprehensible terms
• Proven effective at taking concepts and turning them into logical and physical solutions using CA Erwin
• Automated Informatica Repository and Integration service backup using UNIX shell script

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5.1, SSIS

Database: Oracle 11g, Microsoft SQL Server 2008 R2, Knowledge in Netezza, Sybase Adaptive Server Anywhere/Enterprise

Version Control: Visual Source Safe, PVCS, Perforce

Case Tools: Erwin data modeler 9.5, MS Visio

Other Tools: Shell scripting, SSRS, Qlikview, JIRA (Project Management and Issue tracking), RTC, Control-M, Crystal Reports, SAP GUI Logon, Power Builder 9.0/11.5, Adobe Photoshop, Clear Quest, SharePoint

PROFESSIONAL EXPERIENCE

Senior ETL Developer

Confidential, Smithfield - RI

Environment: Informatica PowerCenter 9.1.0, Unix, Oracle 11g, Neteeza, RTC, Control-M

Responsibilities:

• ETL design and implementation - define and maintain environments, coding standards and migrations, data movement strategies from source through the MDM and RDM, data delivery methods to downstream systems like MyWorkspace, testing strategies
• Develop Unix wrapper shell scripts to execute Informatica workflow, parameter and config files
• Schedule and Monitor the Informatica jobs through Control-M
• Communicate estimates to project management on the effort required to plan and execute tasks to achieve project goals
• Take proactive approaches to problem solving and relay necessary information as appropriate
• Hold regular meetings with offshore and onshore developers in a group setting and one-one to ensure tasks are on track, to assign tasks, to resolve issues, perform code reviews, share design and coding techniques, and to communicate project information
• Translate business requirements into technical design specifications and source-to-target mapping documents

ETL Architect

Confidential, Montvale - NJ

Environment: Informatica PowerCenter 9.1.0, Erwin, Oracle 11g, SAP

Responsibilities:

• Responsible for overall ETL design and implementation - define and maintain environments, coding standards and migrations, data movement strategies from source through the data warehouse, Informatica folder structure and content, process flow, data delivery methods to downstream systems, testing strategies
• Handled 5 member team for SAP-EDW integration project and 3 member team for Price Catalog project
• Worked on performance optimization to reduce the time taken for loading 20M weekly records from SAP Extractor to EDW
• Communicate estimates to project management on the effort required to plan and execute tasks to achieve project goals
• Take proactive approaches to problem solving and relay necessary information as appropriate
• Hold regular meetings with offshore and onshore developers in a group setting and one-one to ensure tasks are on track, to assign tasks, to resolve issues, perform code reviews, share design and coding techniques, and to communicate project information
• Translate business requirements into technical design specifications and source-to-target mapping documents

Data Architect/Senior ETL Developer

Confidential, San Diego - CA

Environment: Informatica PowerCenter 9.5, Erwin, Oracle 10g, XML, XSD

Responsibilities:

• Responsible for overall ETL architecture - define and maintain environments, coding standards and migrations, data movement strategies from source through the data warehouse, Informatica folder structure and content, process flow, data delivery methods to downstream systems, testing strategies
• Enhance and drive existing development practices and processes towards best practices
• Communicate estimates to project management on the effort required to plan and execute tasks to achieve project goals
• Take proactive approaches to problem solving and relay necessary information as appropriate
• Hold regular meetings with offshore and onshore developers in a group setting and one-one to ensure tasks are on track, to assign tasks, to resolve issues, perform code reviews, share design and coding techniques, and to communicate project information
• Translate business requirements into technical design specifications and source-to-target mapping documents
• Design, develop, and implement data integration processes to extract, transform and load (ETL) source data into the required target schemas for the data warehouse or analytic data mart
• Extensively worked in extracting the table structure and data from XML using XML Parser transformation
• Provided Production Support and issue resolution
• Provided after hours on-call support for data warehouse ETL issues

Data Architect/ Senior Developer

Confidential, San Diego - CA

Environment: Informatica PowerCenter 9.5, Erwin, Oracle 10g

Responsibilities:

• Lead the design of the overall ETL data warehouse architecture: ETL strategy, staging database, and data quality
• Steered the team to build Informatica mapping for creating Audit Strategy reports
• Used Informatica repository tables for fetching the audit data (Status of Session, Workflow and error logs/messages)
• Designed Staging tables to load the records fetched from Informatica repository tables
• Produced detailed ETL design documents and specifications, and communicated business requirements into detailed ETL data mappings

Senior ETL Developer

Confidential, San Diego - CA

Environment: Informatica PowerCenter 9.1, Erwin, Oracle 10g

Responsibilities:

• Perform technical analysis, design, build, and implementation of data integration processes throughout the data warehouse product lifecycle
• Perform data analysis of extraction source systems and provide architecture guidance for data models
• Work closely with business analysts on new and existing data warehouse products by engaging in the requirements gathering, analysis, and design
• Define, refine, and apply architectural standards, processes, and best practices to the build and maintenance of data warehouse extract, transform, and load (ETL) mappings
• Consolidated the requirements and worked to create the Enterprise Data Model along with the Logical Data Model for the system using ERwin case tool. Created Entities, attributes, relationships and re-usable domains for the system.
• Creating Load-sheets for promoting the DDLs to QA, CAE and Production environments
• Implemented Slowly Changing Dimensions (SCD) - Type 2 using Informatica Mapping wizard
• The SCD type 2 mapping has been created to handle 45 million history data and 4 million daily data
• Create Informatica Deployment group and prepare Unix Shell script for promotion from one environment to other environment
• Provided Production Support and issue resolution
• Provided after hours on-call support for data warehouse ETL issues

ETL Developer / Software Engineer

Confidential, San Diego - CA

Environment: Informatica PowerCenter 8.1, Erwin, Oracle 10g, XML, XSD

Responsibilities:

• Develop and support Informatica ETL jobs for the data warehouse
• Design and tune ETL for a large data warehouse to include error handling techniques to allow for graceful restart after errors, and strategies for minimizing data load times
• Gather and document requirements for ETL and reporting implementation
• Create Informatica Deployment group and prepare Unix Shell script for promotion from one environment to other environment
• Work closely with business analysts on new and existing data warehouse products by engaging in the requirements gathering, analysis, and design
• Support the quality assurance/testing team on integration and system testing activities

ETL Developer / Software Engineer

Confidential, Birmingham - AL

Environment: Informatica PowerCenter 8.1, Microsoft SQL Server 2005, Qlikview

Responsibilities:

• Conversion of various versions of SBSF to an enterprise system
• Design & coding for ETL mapping
• Integration testing of the SBSF System
• Co-ordination between development team and client
• Prepare estimation and project schedule based on the requirements provided by the client
• Allocation of work to team over the project schedule and tracking the schedule

ETL Developer / Software Engineer

Confidential, Birmingham - AL

Environment: Informatica PowerCenter 8.1, SQL Server 2005, SSRS

Responsibilities:

• Visited Birmingham, AL to get knowledge transition for Plant Management System
• Implemented and involved in providing production support to clients
• Involved in Building ETL for multiple Modules
• Creating deployment groups using repository manager and promote to othe environments
• Create tables, Stored Procedures, Triggers, indexes and other DB objects

Technical Consultant

Confidential

Environment: Powerbuilder 9.5, SQL Server 2000, Crystal Reports

Responsibilities:

• Experienced in building different pharmaceutical modules like Inter/Intra-Company transfer, Robotic Medicine Dispensing and Restricted Notes
• Create tables, Stored Procedures, Triggers, indexes and other DB objects
• Highly skilled in interacting with Business Development team and prepare Functional Design Specification
• Involved in preparing Technical Design Specification based on FDS

Technical Consultant

Confidential

Environment: Powerbuilder 9.5, Sybase ASE and ASA

Responsibilities:

• Daily interaction with onsite coordinator to collect the requirement and deliver tasks
• Creation of power builder objects after reviewing the data flow developed using SQL
• Performance tuning using Powerbuilder be replacing the db cursors to powerbuilder datastore
• Loading data from Sybase Adaptive server anywhere to Adaptive server enterprise using infomatica mapping