SUMMARY

• 12+ years of Information technology experience in data integration, data management, Business intelligence reporting, data modeling, data mapping, data quality, data analysis and deployment of multi tier data warehouse and business intelligence applications.
• Over ten years of experience in ETL strategy and framework design, development using Informatica power exchange and power center tools.
• Experience in working with large volume Clinical and health care data integration projects.
• Experience in designing/developing ETL best practices for several large scale data integration/ data warehouse projects.
• Experience as a data Warehouse analyst/developer gathering functional/technical requirements, analyzing technical details, designing data flow diagrams/models, writing technical documents, effectively communicating between users and developers in project meetings, giving presentations, assisting in project management by providing estimates.
• Excellent analytical, co - ordination and interaction skills, and have track record of immense leadership potential. Detail oriented and able to manage multiple projects simultaneously.
• Experience in Agile and waterfall project life cycle methodologies.
• Expertise in normalized and star/snowflake logical and physical data modeling using CA Erwin and Sybase Power Designer case tools.
• Experience in working on large multi-tier projects for health-care, pharmacy, insurance, finance, energy, travel, education and other business domains.
• Experience in designing, developing business intelligence reporting solutions for OLAP, BPM and forecasting applications using Oracle Hyperion platform, OBIEE+ and Cognos technologies.
• Expertise in Oracle, DB2 and SQL Server and Teradata database design, development, SQL/PLSQL/TSQL query optimization and tuning.
• Experience in helping clients to adopt best practices for Database and ETL design and development for their enterprise project development life cycle.
• Experience in training and mentoring client staff for business intelligence reporting and data warehousing technologies.
• Experience in architecting/developing data quality and data profiling solutions using informatica IDQ and other tools.
• Self starter, able to work independently and manage time on multiple projects simultaneously.

TECHNICAL SKILLS

Operating Systems: Unix (AIX/SunOS-Solaris/HP/SCO/DIGITAL), Linux, Windows 2000/NT/XP

Databases: Oracle 11g/10g/9i, DB2 UDB 8.x, SQL Server 6.5/2000/2005 , Teradata 10.x

Data Warehousing Tools: Informatica Power-Center 9.x/8.6/7.x/6.x/5.x, Power exchange 8.x, Power-Connect for SAP R/3, Power connect for DB2, Striva, Power Mart 5.x, Oracle Data warehouse builder, Oracle Discoverer 3.x

Data Modeling/ Case Tools: Rational Rose Entreprise suite, Erwin 4.x, Power Designer, Oracle Designer 6.0, Visio, XML Spy

Reporting Tools: Oracle Business Intelligence 101.5, Answers, BI Publisher, Dashboard, Hypérion 8.x, Cognos power play, Impromptu, Report Net, Oracle Reports 2.5/6.x, Actuate Reports, Business Object, Crystal Reports

Programming Languages: PL/SQL, SQL, T-SQL, UNIX Shell Scripting, PERL, Pro*C

Application Servers: IBM Web sphere, Bea Web Logic server, Netscape enterprise server, IIS, OAS, Citrix Meta frame Server (1.8), Citrix ICA web clients

Development Tools: SQL Navigator, TOAD, Oracle Forms 4.x/6.x, Sybase database tools, LDAP, Enterprise Manager, SQL Loader

PROFESSIONAL EXPERIENCE

Confidential, Cambridge MA

Data Integration Consultant

Responsibilities:

• Design and develop processes for managing master data entities throughout the lifecycle including data quality, metadata and workflow process.
• Designed and developed closed loop data integration process (nightly batch cycle) using Informatica power center tool to synchronize customer master data between MDM hub and SalesForce.com system.
• Design and implement mappings for brining data into MDM hub from multiple source systems.
• Configure Informatica MDM hub match/merge rules and batch jobs.
• Developed PL/SQL user exists to customize out of the box Informatica MDM functionality.
• Worked on data governance processes for data steward group.

Environment: Informatica MDM 9.01(Siperian), Informatica Power Exchange 9.x, Oracle 10.2.0.1, UNIX, Sales Force.com, Cognos, Tidal Scheduler.

Confidential, Boston, MA

Data Warehouse/ Business Intelligence Consultant

Responsibilities:

• Analysis, design and development of DW consisting of reservation, promotion data from complex DB2 mainframe legacy system.
• Interacting with business executives to gather reporting requirements and design, development of ODS/DW reports using Oracle Hyperion reporting toolset.
• Developed SSIS routines to migrate data in Analytical DM.
• Designed data mining routines to help marketing division to target key customers.
• Designed and developed reusable ETL framework that can be used across different development groups for data load process.
• Worked on optimizing nightly batch cycle and improve performance of ETL workflows using various techniques.

Environment: Oracle 10.2.0.1,Informatica Power Exchange 8.6, Informatica Power center 8.6.x, Unix AIX 5.3, Oracle Hyperion Reporting suite 9.3.3, Microsoft SQL Server, Oracle Data Mining suite, Microsoft SQL Server 2005

Confidential, Worcester, MA

Data Modeling/ Data Integration Consultant

Responsibilities:

• Created logical and physical database design modeled to support dynamically driven front-end application.
• Developed SQL Server SSIS solution to automate nightly batch cycle jobs.
• Developed mapping of data sources, interfaces with the goal of ensuring data quality.
• Created data architecture documents to maintain a current and accurate view of the larger data picture.

Environment: UNIX, Windows, SQLServer 2000, Erwin, XML spy, Flex, Dialogue, IBM process modeler, Web services

Confidential, Boston, MA

Data Integration/ Business Intelligence Architect

Responsibilities:

• Requirement analysis and creation of system design and technical design documents.
• Detailed ETL code assessment for phase 1-warehouse modules.
• Design and development of ETL processes for station and turbine generation fact. Design and development of logical and physical data model (dimensional) for warehouse phase 1.
• Developed test plans and test cases to validate data from source to target database. Developed detailed documentation using informatica velocity methodology standards.

Environment: Windows 2000, Informatica Power Exchange 8.x, Oracle 10g, PI ODBC database. Erwin 7.x, Business object 3.1

Confidential, Boston, MA

Technical Architect/ Data Analyst/BI Developer

Responsibilities:

• Worked with business users and development team to translate business needs into technical requirements and prepared technical system design.
• Served as the subject matter expert for OBIEE by providing expertise in BI server, Answers, Interactive Dashboards, Deliver and BI Publisher.
• Designed and developed data quality standards to solve common name and address data problems, setup rules for address cleaning and name matching.
• Setting up standards and procedures for ETL design and development on project.
• Designed and developed ETL processes by extracting and loading data from COBOL mainframe fixed width files (using copy books) and relational sources.
• Design/developed and optimized the physical, logical and presentation layers within OBIEE.
• Developed UNIX shell script to automate nightly cycle tasks.
• Designed and developed data masking algorithms to mask secure payroll/HR data.
• Mentored offshore and onsite team members.

Environment: AIX-UNIX, Solaris, Windows, SQL Server 2000/2005,Oracle 11g/10g, Informatica Power Center 8.6.1, Mainframe VSAM files, Oracle business Intelligence reporting suite 10.1.5, Power designer, Control M job scheduling tool

Confidential, Boston, MA

Technical Architect/ Data Analyst/Data Modeler/Informatica Admin

Responsibilities:

• Gathered requirements by interviewing users, prepared technical specification docs and applied those requirements (using ACCORD standards) in designing star schema dimensions and fact.
• Policy and Claims subject area discovery and data analysis using data explorer and DQ tools.
• Lead ETL efforts in designing, developing, testing and implementation of enterprise property and casualty insurance data warehouse.
• Gap analysis and mapping from legacy billing data mart to enterprise data warehouse.
• Designed and developed ETL processes by extracting and loading data from different relational (SQL server/DB2 UDB etc.) and flat file/XML sources.
• Install, configure, maintain and upgrade the informatica repositories and servers.
• Act as a point of contact for all the communication with various development teams and Informatica Corporation for ETL troubleshooting and environment comp ability issues.

Environment: AIX-UNIX, Windows, Power Designer, DB2 UDB 8.x, SQL server 2000/2005, Informatica Power Center 7.3/8.x, Control M scheduling tool, XML SPY, Hyperion reporting suite.

Confidential, Boston, MA

Sr. ETL consultant/ Report developer

Responsibilities:

• Provide strategic directions, recommendation and implementation of data services technologies.
• Participant health care information requirement analysis and discovery of legacy data sources.
• Design and development of FHS logical and physical data model.
• Design and development of data load batch programs to automate laboratory manual tasks.
• Worked with external vendors to troubleshoot software/hardware and performance issues.
• Installation and configuration of SQL LIMS software on all the laboratory desktops.

Environment: SQLLIMS, Oracle, UNIX sun Solaris, Toad, and Windows 2000

Confidential, Boston, MA

Data Analyst/Data Modeler/ETL Architect

Responsibilities:

• Requirement gathering and preparation of system design diagrams/documents.
• Data analysis and data modeling for provider and product domains.
• Data profiling for Mainframe VSAM files and preparing metrics on DQ.
• Design and development of ETL architecture for warehouse dimensional schema.
• Installation and configuration of Power Center server environment on HP-Unix.
• Designed Mainframe data maps using Striva power connect tool to stage data in staging area.
• Design and development of cognos cube using power play.
• Developing impromptu reports and catalog using cognos tools.

Environment: HP-Unix, Windows 2000, Oracle9i (release 2), Informatica Power Center 6.2, COBOL, Striva (Power Connect for Mainframe), Cognos Power Play, Report Net, Erwin Data Modeler, CVS

Confidential, Concord, MA

ETL Architect/System Analyst

Responsibilities:

• Analyzing data requirement of system and translation of these requirements into dimensional data models.
• Designing data load mapping and workflow/worklet processing technical specifications.
• Analyzed copybook data layouts for COBOL data feeds used to process data.
• Designing SAP BW data retrieval methodology using Informatica power connects.
• Designed and developed ETL processes using Informatica power center tool set.
• Designing aggregated summary table architecture using oracle materialized view concept.

Environment: Unix Sun Solaris 5.7, Windows 2000, Oracle9i (release 2)/8i(8.1.7.2), Informatica Power Center 6.x/ 5.1, Mainframe COBOL systems, Power Connect for SAP R/3, Business Object tools, EMC Storage, Citrix Meta frame application server

Confidential, Bedford, MA

Technical Architect/Data Modeler/Data Analyst

Responsibilities:

• Designing logical and physical data model using Erwin case tool.
• Developed ETL standards for incentive database Data loading procedures.
• Installation and configuration of Informatica power center server and client tools. Schedule data load batches for optimal data loads.
• Design, Development and testing of PL/SQL scripts using advance features of Oracle8i.
• Administrating informatica repository in development and production environment.
• Development of UNIX shell scripts to create automated reject data reloading mechanism.
• Writing T-SQL routines to customize software integration with SQL Server 2000.
• Mentoring client staff for informatica power center skills.

Environment: Sun Solaris 8, Windows 2000 Terminal server, Oracle 8.1.7, SQL Server 2000, Teradata database 10.x, Informatica Power Center 5.1, Erwin 4.x, Brio Reporting tools

Confidential, Dallas, TX

Data Modeler/ ETL Architect

Responsibilities:

• Developed an informal conceptual model to capture business requirements.
• Maintained logical and physical data model and scripts using Erwin 4.x.
• Designing the process for getting data from legacy and other data sources.
• Designed data load cycle strategy using Informtica Power center.
• Created data mappings using various transformations in informatica designer.
• Design and development of PL/SQL stored procedures and packages.
• Design of content management schema in oracle database using Oracle inter-Media and Oracle Text technologies.

Environment: Sun Solaris 2.6, DB2 UDB, Oracle 8i (version 8.1.5), Oracle Discoverer 4.x, Oracle Application Server 4.0.8.1, Informatica Power Center 1.7, Erwin 4.x, PL/SQL