BI Architect Resume Profile Groton, Connecticut - Hire IT People

OBJECTIVE

To work in a challenging environment, use my technical expertise to contribute towards the growth of the company as well as personal growth and gain excellence and experience.

SUMMARY OF EXPERIENCE

6.5 years of experience in Life Sciences Industry.
2.5 years Project Lead at Accenture Services Pvt Ltd May 2012 Present
4 years Senior Applications Engineer at Oracle India Pvt Ltd July 2008 May 2012
6 months as an Intern at National Aerospace Laboratories NAL , Bangalore, India
Oracle Certified Oracle Life Sciences Data Hub Implementation Specialist
Joint holder of a Patent for Data De-Duplication in Data Warehouse - US8799235

TECHNICAL SKILLS

Applications/ Tools: Informatica Power Center 8.x, 9.0.1, OBIEE 10g, 11g, BI Publisher 11g, Oracle Clinical Development Analytics OCDA 1.x,2.x,3.x , Life Science Data Hub LSH 2.1.x, 2.2.x , Oracle Data Integrator ODI , Datawarehouse Administration Console DAC 10.1.3.4.1, Oracle Healthcare Master Person Index 1.1, 1.2 OHMPI , Weblogic, Siebel CTMS, Oracle Clinical OC

Programming languages: C, C , Java, SQL, PL/SQL.

Operating Systems: MS-DOS, Windows 98, Windows XP and Linux

WORK EXPERIENCE

Confidential

BI Architect

Roles and Responsibilities:

Lead a team of 20 members on the BI project.
Working at the client site and Responsible for gathering the requirements from the clients and convert these into functional and technical design documents.
Responsible for designing the end to end solution with ETL incremental Load, mastering of data originating from multiple data sources and also the business model for reporting.
User management with design for Object level security and data level security.
Provide Subject Matter Expert SME support to ETL and Reporting teams on CDA, OBIEE, BIPublisher, Informatica.

Confidential

BI Architect Team Lead

Roles and Responsibilities:

Lead a team of 7 members on the BI project.
Built the base ODW data model Facts Dims which would be synchronized with existing OCDA model.
Built 85 metrics in the RPD, 24 Reports, 3Dashboards which included Trending metrics, Maps, Scorecards.
Provide Subject Matter Expert SME support to ETL and Reporting teams on CDA, OBIEE,Informatica,LSH.

Confidential

Architect Team Lead

Roles and Responsibilities:

Worked at the Oracle Headquarters in Redwood City, California, with the Product Managers on discussing the scope, gathering and analyzing the requirements for the release.
Designed the complete ETL Architecture end to end solution for Multi Source Integration as well as an overall solution to handle the De-Duplication of denormalized attributes in the warehouse tables.
Developed 4dimensions, 3fact and 3 Aggregate fact ETL Mappings supporting de-duplication of records from source system.
Implemented Japanese Language support in CDA reports and Dashboards.
Lead a team of 8 members on the project.
Upgraded the existing 10g RPD, Reports and Dashboards to 11g and developed additional reports and dashboards using OBIEE 11g.
Trained the customers on the usage of CDA.
Worked closely with one of the key customers in installing CDA in their environment and helped them go live in a short span of time.

Confidential

Roles and Responsibilities: Architect Team Lead

Designed the complete ETL architecture as LSH was replaced with DAC for ETL Administration.
Lead a team of 6 members on the project.
Designed and developed ETL mappings using Informatica based on the requirements provided.
Provided documentation for User Guide and Installation Guide.
Built the final package for release and handle all release activities.

Confidential

Roles and Responsibilities: Developer

Worked as part of the Architecture team and modified the basic ETL Architecture of Ver 1.0 to include the additional source system.
Designed and developed ETL mappings 2 Dimensions 3 Facts which included a SCD Type 2 fact.
Designed the RPD, reports and few dashboards using OBIEE.

Instrumental in building the final package and handling all the release activities.

Confidential

Roles and Responsibilities: Developer

Worked on the conversion of Informatica xml code into ODI.
Worked as part of the Architecture team for designing the basic ELT Architecture.

Confidential

Roles and Responsibilities: Developer

Designed and developed ETL mappings 2 dimensions, 1 Fact that were a hybrid of SCD Type2 and Type3.
Designed the RPD, dashboards and pre-built reports using OBIEE.
Prepared Test cases and Test data for unit testing the code using UTPL/SQL
Instrumental in setting up the development and Unit testing environments.

We provide IT Staff Augmentation Services!

Bi Architect Resume Profile

Groton, ConnecticuT

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship