SUMMARY:

• Over twelve plus years experience in information technology. Throughout his carrier he has lead efforts in the technical design and development primarily within the areas of Business Intelligence and Data Warehousing.
• His experience includes star/snowflake modeling, ETL architecture design as well as ETL development using Informatica, SQL, PL/SQL and UNIX/Windows scripting.
• His extensive work within Date warehousing has helped him to gain experience with multiple databases like Oracle, Exadata, SQL Server, Informix, Teradata and DB2. He has also been responsible working with business users for decision support with Business intelligence reporting tools such as Business objects.
• Experienced in Enterprise Architecture, Dimensional Modeling, Data Analysis, Data Integration, Data cleansing/quality and implementation of Data Warehouse and Database Applications systems.
• Experienced in Financial, Banking, Healthcare, Manufacturing, CRM, Security, Insurance, Telecommunication, and Mortgage domains to reflect business requirements into Business Intelligence.
• Experienced in Audits/Controls, Error management, ETL design, QA, EDW standards and CMMI level process guidelines.
• Experienced in creating Functional specifications, Technical design specifications including process and dataflow documents.
• Good experience in onsite/ offshore models execution.
• Skilled in developing Type1, Type2, Type3 and Hybrid SCD mappings.
• Experienced in Performance Tuning of Source, Targets, mappings, sessions and Transformation.
• Strong understanding of logical and physical designs used in developing Database schemas like Star schema and Snowflake schema used in dimensional modeling.
• Excellent working knowledge in writing SQL, PL/SQL code, Cursors, Stored Procedures, Packages and solving performance related issues.
• Experienced in using parameter files, Exp mapping parameters, mapping variables in mappings.
• Experienced in UNIX shell scripting to support and automate the ETL process
• Expertise in Unit testing, User documentation and Application/Product Demos
• Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently and as part of a team
• Experienced in Data Integration with different CRM (Salesforce.com, CVent) and ERP systems using PowerExchange for Salesforce/SAP and Web services.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9.1.x/8.6.1/8.x/7.1/6.2/, Data Integrator XI

OLAP: Cognos Report Net 1.1/1.02,Business Objects6.1x, Qlikview

Databases: Oracle 11/10g/9i/8i, Exadata, DB2, SQL Server2000, MS Access, Teradata V2R5

Operating System: IBM AIX 5L, Sun Solaris10/9/8/7, HP, Linux, Windows 7/XP/2000/NT/98/95

Languages: UNIX Shell Scripting, Perl, SQL, PL/SQL, HTML, XML, C, C++, and Java.

Methodologies: Star Schema, Snow Flake Schema, Fact and Dimension Tables

Data Modeling: Erwin 4.0/3.5

Scripting Tools: C Shell, Korn Shell, Born Shell, Bash Shell, Perl

Data warehouse Tools: SQL Developer, SQL*Loader, SQL Navigator, Toad, RAPID SQL, BTEQ, Fast Load, Multi Load, Tpump, Fast Export

Contact Management: ACT V5.04, ACT V6.0.3, ACT 2006/8.0.2, Goldmine5.0/6.0

WORK EXPERIENCE:

Confidential, Denver, Colorado

Lead Informatica Developer

Responsibilities:

• Combined company data warehouse
• Location conformed dimension mart
• Consumer VOIP ( Customer Link association)
• Service Location Dimension and fallout
• Call Center Application data mart (IVR application migration)
• Integrated sales compensation data to Salesforce.com
• Broadband HSI installation - integrate QuickConnect application
• Door to Door reporting
• Participated in requirement gathering sessions with the stakeholder, IT and Business and finalization of requirements
• Lead multiple concurrent projects and successfully installed on time and budget within tight deadlines.
• Involved in architecture, data modeling, designing, development, deployment and support integration
• Lead design and development efforts of a team (on-shore/off-shore) to develop the integrations of the HM data to Salesforce.com also used informatica cloud for on premise for end users.
• Developed STTM, HLD, LLD, custom coding standards, technical specification and test specification
• Developed documentation to adhere the quality frames works standard of CMMi 3
• Developed mappings that incorporated logic for CDC, type1, type 2, type 3 and Hybrid SCD mapping using Hash key MD5.
• Extensively worked with SQL, PL/SQL (cursors, procedures and packages) and Query performance tuning, Created database objects like Tables, Indexes and materialized views.
• Extensively worked on performance tuning on long running job to reduce the run time and efficiency
• Extensively used connected/unconnected Lookups, Filter, Router, Aggregator, Joiner, Expression, Update strategy, Normalizer, union and Rank Transformation
• Developed configurable logic, were in we can turn on or off the process with no code change, configured through expression parameter variable
• Used Informatica PowerExchange for Salesforce and web service to connect Salesforce.com
• Created shell scripts and SFTP/FTP scripts in Linux, and scheduled the workflows using Control-M scheduler
• Worked with Data quality team in cleansing, standardization, matching and consolidation of data for the circuit and WTN using Trillium.
• Used Informatica deployment groups and dimensions for migrating code from dev to test.
• Facilitated and Supported unit test, system test, UAT cycles 1,2 and 3

Environment: Informatica Power Center 9.x/8.6.1, Exadata, Oracle 10/11g RAC, SQL server, Informix, Power Exchange for Salesforce.com, Toad 9.6.1, Linux, Salesforce.com, Informatica Cloud, Apex Data loader, Apex Explore, Caliber, Serena Dimensions, Trillium, Control-M, Windows XP Professional, HP Quality center/ HP Application life cycle management.

Confidential

Data Integration Specialist

Responsibilities:

• Integrate Middle market data to Salesforce.com
• Involved in design, development and support integrating Liberty Mutual Middle market data to Salesforce.com
• Deliver excellent presentation and technical design and architecture documentation
• Work with business representatives, business analysts to quickly understand requirements
• Used dynamic mapping parameter for last extract date and error handling for rejected rows.
• Developed control and Error table for summary and reporting purpose
• Extensively created and used mapplets, worklets and Reusable Transformations to prevent redundancy of transformation usage and maintainability
• Tuned existing mappings, targets, sources, sessions and SQL queries to improve the performance of work units.
• Advised and assisted installation of PowerExchange for Salesforce.com
• Developed UNIX shell scripts for ETL process.
• Involved in bug fixing, Unit testing and Integration Testing and support.
• Used Power Exchange for Salesforce and web services for Integration to the Salesforce.com

Environment: s: Informatica Powercenter 8.6.1, PowerExchange for Salesforce.com, Informatica Web services, XML, Teradata 12.00.0207, Teradata SQL Assistant 12.0, DbVisualizer 5.1.1, ESP, Salesforce.com, Apex sforce Explorer, Apex Data Loader17,windows 2000, AIX 5.3.0.0, Flat Files, MS Visio.

Confidential, NY city, NY

Sr. Informatica Developer

Responsibilities:

• Residential Mortgage Backed securities rating and surveillance data mart
• Involved in designing ETL data load strategy for SCD type1, 2 Dimensions and Fact tables, ETL reject handling.
• Involved in performance tuning SQL and Informatica mappings by implementing Informatica best practices approach.
• Developed and implemented complex business logic (loan to value) using SQL and Informatica.
• Involved in writing UNIX (Solaris) scripts for generating the parameter files dynamically, file watcher, file validation, to schedule/Run Informatica session/workflows, and file archive strategies.
• Created Unit & QA test case templates (standardized formats)
• Interfacing with various Technology and Business groups within Standard and Poor’s.
• Involved in the SIT, UAT and production rollout.

Environment: Informatica Power Center 8.1.1, Oracle 10g, Toad, Sun Solaris v10,SCRUM

Confidential, Monterey, CA

Data Architect/ Data Analyst

Responsibilities:

• Phase II implementation of Salesforce.com
• Clean and De-Dup the existing Salesforce.com data
• Maintain quality consistency for all future and on-going refresh of the data
• Eliminate the paper based communication and deliver the right data to a right target location
• Establish a Data Governance strategy

Confidential, Pennington, NJ

ETL Consultant

Responsibilities:

• Integrate Contact management to Salesforce.com
• Support toolset
• Develop mappings using various transformations including Expression, Lookup, Aggregator, Router, Joiner, Sorter, Normalizer, and Update.
• Created standards for receiving flat file extracts from various vendors to insure consistent and reusable processes for loading inbound data.
• Mentor and manage consultants and client employees in ETL design, development, and implementation.
• Used data loaders, Salesforce explorer, Salesforce excel connect and Salesforce connector for outlook for loading the data to Salesforce
• Loaded data from contact management tool like act, goldmine, outlook data to Salesforce.com
• Used PowerCenter Connect for Salesforce.com integrates PowerCenter with Salesforce.com to extract data from Salesforce sources and write data to Salesforce targets
• Developed widow batch scripts.
• Used mapping parameters, mapping variables, session parameters and parameter files on different mappings and sessions, based on various business requirements
• Created QA Test Plan, Test Cases and Test Scripts for Unit testing, System Integration Testing, User Acceptance Testing
• Involved in production support and supporting toolset (custom built in java) and enhancement of the process.

Environment: Informatica Power Center 8.1.1, Salesforce.com Connector, Informatica Web Services, XML, Oracle 10g, SQL Server 2005, Windows 2003/xp, Java, Toad, SQL Developer, Salesforce.com: Apex Data Loader 10.0, Apex Explorer 8.0, MS Office Visio, ACT5/6/8, Goldmine5/6, Mainframes, MS Office Excel, MS Office Access.

Confidential, Denver, CO

Informatica Developer

Responsibilities:

• SOIP data mart
• Involved in requirement gathering session and finalize the requirements.
• Interacted with North America, Germany, Slovakia and Sweden technical teams while finalizing the source system data flow process to data mart.
• Extensively used connected/unconnected Lookups, Filter, Router, Aggregator, Joiner, Expression, Update strategy and Rank Transformation
• Tuned existing mappings, targets, sources, sessions and SQL queries to improve the performance.
• Used Exception handling logic to handle the null values or rejected rows
• Used command task, email task and decision tasks based on user requirements.
• Involved in Writing Shell scripts to transfer the flat files from FTP location to source directory and moving to archive folder with timestamp.
• Used Autosys for Scheduling the jobs
• Used SAP R/3 Source system using Informatica Power connects for SAP.
• Created Audit table for the reports (from Metadata) which keep tracks of the process i.e. No. of rows process, rejected rows, last successful ran, failure and log file
• Involved in Unit Testing and tuned for better performance.

Environment: Informatica 8.1.2/7.1, Power connect for SAP, Oracle 10g/9i, SQL Developer 1.1.0.23, HP UNIX B.11i, Flat Files, MS SQL Server 2000/2005, SAP R/3, Microsoft Office, windows 2000/XP professional and MS Visio, Autosys 4.0.

Confidential, New York City, NY

Informatica Developer

Responsibilities:

• Contact management data to Salesforce.com
• Involved in Analysis, requirements gathering, functional/technical specification, development, deploying and testing of data warehouse environment.
• Tuned Sources, Targets, Mappings and Sessions to improve the performance.
• Developed design documents, technical specifications for Mappings and Sessions based on user requirements
• Used data loaders, Salesforce explorer, Salesforce excel connect and Salesforce outlook connector loading the data to Salesforce
• Involved in implementing error handling Process for rejected rows.
• Extensively used mapping variables and mapping parameters in various mappings.
• Implemented Query Optimization for performance enhancements
• Involved in Unit testing and Integration Testing
• Developed shell scripts to automate pre -session and post session- tasks

Environment: Informatica Power Center 7.1.3, Oracle10g, SalesForce, SQL Server, IBM AIX 5L (UNIX), Windows XP.

Confidential, Tampa, FL

ETL Developer

Responsibilities:

• GE-Security data mart
• Involved in requirement gathering, designing, and development of data warehouse environment.
• Responsible for Production support and fixing error if any
• Creating new reports and modifying the existing reports as per specification.
• Was co-facilitator for the group and managed the group
• Tuned existing mappings, targets, sources, sessions and SQL queries to improve the performance of work units.
• Developed Exception programs to maintain and clean up data exceptions.
• Used Java based web interface to scheduling the jobs and monitoring.

Environment: Data Integrator 6.1,Business Objects 6,Oracle, Java, SQL, PL/SQL, SQL Server, Windows NT, TOAD.

Confidential

Systems Manager

Responsibilities:

• Worked as part time in an accounting firm
• Consistently demonstrated talent for quickly learning new tasks and completing assignments ahead of schedule while maintaining high degree of accuracy.
• Responsible for publishing and maintaining technical support.
• Provide Bank Reconciliation and reporting

Confidential

Oracle Developer

Responsibilities:

• Created tables, views, synonyms and sequences.
• Used SQL Loader for data loading.
• SQL tuning on existing reports
• Modified existing forms, reports, and graphs as per the enhancement.
• Tested all the new and modified program units.
• Extensively used Database triggers, PL/SQL procedures, packages and functions while developing the forms and reports.

Environment: Oracle 7.3, Windows NT, Forms 4.5, Reports 2.5