SUMMARY

• Confidential is a Sr. Lead Consultant/Sr. Data Analyst/Data Architect with a strong Informatica skills and Data warehouse/Data Architecture/Data Modeling /CRM skills. He has about 14 + years of experience in IT industry.
• 10 + years of experience in the ETL(Informatica) Architecture, Analysis, Design, Development, Data Modeling, Testing and Implementation of business application systems for Financial, Health care, Pharmaceutical, Telecom and Public Sectors.
• Extensive experience in relational and dimensionaldatamodelingfor creating logical and physical design of the database and ER diagrams usingdatamodelingtools like ERWIN.
• 10 + years as Oracle database experience. Extensive experience in Client/Server technology area with Oracle Database, SQL Server, DB2 and of experience in using SQL, PL/SQL, Stored procedures/functions, triggers and packages, complex joins, correlated sub - queries, aggregate functions analytic functions, materialized views, indexing, partitioning and performance tuning.
• Experience in Informatica Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with Administrator functions of Repository Manager. Experienced with Autosys tool
• Experience in writing UNIX Korn shell scripting. Experience in Data Quality Analysis, Data Profiling, Data cleansing and Master data management. Effective experience in Complete Software development Life cycle (Iterative, Waterfall methodology, Agile, RUP) .Experienced in Production Support for batch loads.
• Extensive experience in Data Warehouse, Data Mart and Business Intelligence using OLAP/DSS tools. Implemented the RALPH KIMBELL design strategies on metadata.
• Hands on experience on Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin. Hands on experience on Dimensional Data modeling and Relational Data modeling.
• Hands on experience on Integrating Informatica with Salesforce data. Hands on experience to load data into Siebel Interface Tables using Informatica. Worked with Onsite and Offshore model and lead the team. Extensive experience in data analysis to improve overall efficiency to support decision making. Effective problem-solver. Organized. Team player
• Have Good understanding of ETL/Informatica standards and best practices, Confirmed Dimensions, Slowly Changing Dimensions (SCD1,SCD2,SCD3)
• Solid understanding of Oracle Business Intelligence Enterprise Edition (OBIEE 11g/10g), its architecture, components (OBI Server, Oracle BI Presentation Services, Web cat file, config files and other tools & utilities), Siebel Analytics 7.x

TECHNICAL SKILLS

ETL Tools: Informatica 5.x, 7.x/8.x/8.6/9.x,AbInitio

Data Modeling: Erwin(7.x/8.x/9.x), Visio

Databases: Oracle 9i/8.x,10 G.11G, SQL Server (7.0 & 2000,2005),DB2,Teradata

DB Utilities: SQL*Loader, Export & Imports, Forms 4.5/3.0, Reports 4.5/2.5

CRM: Siebel ePharma 6.3/7.7x/8.x, Siebel eFinance 7.0.4, 7.5 7.7/8.0,Siebel Call Center 5/6.3/7.0/7.x, Siebel base and Verticals

Salesforce Languages: PL/SQL, SQL, Java, Cobol, Visual Basic,.Net, eScript, XML

Other Tools: MS-Project, Cognos, Siebel Tools 5/6/6.x/7/7.x/8.x, Web Analytics tools

Operating Systems: Windows, UNIX

Cleansing Tools: Trillium 7 (data converter, parser, geocoder, matcher), Firstlogic

Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE

Confidential, NYC

Team Lead/Sr. Developer

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document
• Experienced in relational and dimensionaldatamodelingfor creating logical and physical design of the database and ER diagrams usingdatamodelingtools like ERWIN.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Conducted the design reviews and validated the developed models by interacting with database administrators, business analysts.
• Reverse engineered the reports and identified thedataelements, dimensions, facts and measures required for new enhancements of the reports.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents
• Extracted data from excel files, high volume of data sets from data files, Oracle, Siebel using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area
• Created re-usable transformations/mapplets and used across various mappings
• Wrote complex PLSQL scripts /functions/procedures/packages
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Data loads are scheduled through DAC
• Wrote Unit Test cases and executed unit test scripts successfully
• Involved in performance tuning of Informatica code using standard informatica tuning steps. Involved in the performance tuning of SQL/PLSQL scripts based on explain plan. Supported during QA/UAT/PROD deployments and bug fixes
• Wrote UNIX Korn shell scripts for file transfer/archiving./Email notifications
• Business analysis and data model design for new tables related to ETL.
• Designed Fact and Dimension Tables
• Created workflows for full load and incremental loads to be used by DAC
• Migrated data from one environment to Other Environment using Informatica
• Loaded data from Source tables into Staging and Staging Tables into DW tables
• Added tables into DAC and scheduled Full Time/Incremental Jobs

Environment: OBIEE 11g, Informatica 9.0.1,OBIA,Siebel Public Sector, Oracle 11g, SQL, PL/SQL, DAC 10.1.3.4, TOAD, Unix, Windows XP/Windows 7,ERWIN

Confidential, NJ

Team Lead/Sr. Consultant

Responsibilities:

• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA. Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules. Created Workflows for all entities.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Reverse engineered the reports and identified thedataelements, dimensions, facts and measures required for new enhancements of the reports.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet. Tuned the Informatica mappings for optimal load performance.
• Maintained /Supported current Wealth management daily batch jobs(Informatica, Siebel, Siebel Analytics, Data mart and Salesforce.com) Design, documented and developed the data process for new requirements for the following entities: Bank, Brokerage, Customer, ML Rewards and Profiles
• Experienced with Oracle/SQL Server, SQL query optimization and Stored procedures
• Developed CRM Automation for the following entities: Opportunities, Prospects, Activities and Campaigns using Autosys.
• Architected, Designed, Developed, and Implemented Batch data-load process for new entities
• Loaded data from Source tables into Staging and Staging Tables into DW tables
• Added tables into DAC and scheduled Full load/Incremental Loads

Environment: Siebel Analytics(DW), Siebel (eFinance, ETL (Informatica 8/8.6)SQL Server, Sales force, Data mart, DAC,ERWIN

Confidential, Simi Valley CA

Team Lead / On-shore coordinator

Responsibilities:

• Design, development and documented the Siebel batch data process
• Informatica mappings, workflows are created and loaded data from source systems to Stage and Stage to Siebel Interface tables.
• Data loaded from Siebel Interface to Siebel Base tables using Siebel EIM
• Validated and analyzed loaded data.

Environment: Siebel Financial v8, ETL (Informatica 8.6), Oracle 10 G,ERWIN

Confidential

Team Lead / On-shore coordinator

Responsibilities:

• Analysed the requirements and framed the business logic for the ETL process.
• Experienced in relational and dimensionaldatamodelingfor creating logical and physical design of the database and ER diagrams usingdatamodelingtools like ERWIN.
• Involved in the ETL design and its documentation.Architected, Designed, Developed, and Implemented Batch data load process.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using Erwin.
• Followed Star Schema to design dimension and fact tables.
• Experienced in handling slowly changing dimensions.
• Conducted the design reviews and validated the developed models by interacting with database administrators, business analysts
• Reverse engineered the reports and identified thedataelements, dimensions, facts and measures required for new enhancements of the reports.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse. Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
• Data loaded from Siebel to Other Systems using Informatica
• Configured DAC and created containers, subject areas and tasks.
• Jobs are scheduled using autosys
• Experienced with Oracle/SQL Server/DB2,Sql query optimization and Stored procedures
• Experienced in Data Quality and Profiling
• Loaded data from Source tables into Staging and Staging Tables into DW tables using Informatica
• Added tables into DAC and scheduled Full Load/Incremental Loads

Confidential

Sr Consultant

Responsibilities:

• Design, development, documented the Siebel data process and involved in Data Modeling
• Abinito/Informatica used to load data from source systems to Siebel Interface Tables
• Data loaded from Siebel Interface to Siebel Base tables using Siebel EIM
• Experience with Oracle/SQL Server/DB2,Sql query optimization and Stored procedures
• Involved in the ETL technical design discussions and prepared ETL high level technical design document
• Created complex Informatica mappings
• Created re-usable transformations/mapplets and used across various mappings
• Wrote complex PLSQL scripts /functions/procedures/packages
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Involved in performance tuning of Informatica code using standard informatica tuning steps
• Involved in the performance tuning of SQL/PLSQL scripts based on explain plan
• Validated and analyzed loaded data. Prepared test scenarios for all entities to validate loaded data
• Jobs are scheduled using Autosys