SUMMARY:

7+ years of IT experience in Data Warehousing and Business Intelligence. Designed and implemented large scale Data Warehouses. Quick learner, who is dynamic and innovative. Can adopt to new environments and technologies with ease.

TECHNICAL SKILLS:

• Data Warehousing and Business Intelligence (Including Largescale Data Warehouses)
• Data Integration(ETL)
• Informatica Powercenter 8x, 9x (Dev and Admin)
• Informatica Cloud
• Oracle Database
• Business Intelligence
• Tableau 9.x, 10.x
• OBIEE 10g, 11g(Administration)
• Unix
• Cloud Apps & Big Data
• AWS S3, EC2, Salesforce, Hive, PIG

CAREER SUMMARY:

Confidential, Kingston, Rhode Island

Responsibilities:

• Have 7+ years of hands-on experience and strong knowledge in Data Warehousing and Business Intelligence
• Designed and Implemented various DWBI projects with complete life cycle of Requirement gathering, System architecture, functional/technical design, development, testing and implementation.
• Have good hands-on experience in Informatica Powercenter 8.x, 9.x and Oracle(SQL) - Design and development
• Have good hands-on experience in data integration for Cloud Applications using Informatica Cloud, AWS S3, EC2
• Have good hands-on experience in Informatica 8x, 9x and OBIEE10g, 11g server administration.
• Have implemented various performance tuning techniques in Informatica, Oracle using indexes and partitions.
• Have implemented enterprise installation of Informatica and OBIEE with security configurations such as SSO and SSL
• Have good communication and interpersonal skills, quick learner and adopts to new environments with ease.
• Have mentored heterogeneous teams spread across the globe.
• Designed and Implemented Data Warehouse with data sources in both cloud and on-premise. Responsibilities include system architecture, functional/technical design, development and testing.

Confidential

DW-BI Technical Lead

Responsibilities:

• HR Analytics Support and Enhancements
• Managed operations of entire DW-BI system for Confidential HR domain.
• Operations include technical support, maintenance and enhancements.

Confidential

DW-BI Administrator

Responsibilities:

• Process Management Data Warehouse
• Coordinated and Improvised DW-BI server administration.
• Activities include server installation, upgrades, maintenance and code migration for Informatica and OBIEE.

Confidential

DW-BI Technical Lead and Administrator

Responsibilities:

• Implemented multiple data integration projects in a large-scale Data Warehouse with roles in system architecture, functional/technical design, development and testing.
• Have headed teams of various size
• Headed and stabilized DW-BI server administration.
• Activities include server installation, upgrade and code migration for Informatica and OBIEE.

Confidential

ETL Developer

Responsibilities:

• Developed Informatica code for various business scenarios and functionalities.

Confidential

ETL Developer

Responsibilities:

• Claimsphere Healthcare Analytics Portal.
• Developed Informatica code for various business scenarios and functionalities.

Confidential

DW-BI Technical Lead

Responsibilities:

• Designed and implemented a Data Warehouse from the scratch with audit functionalities.
• Worked on integration of multiple source systems, performance tuning and system architecture design.
• Liaised with multiple source systems and created data model for DW to consolidate 10+ source systems
• Implemented best practices to ensure high standards
• Implemented audit functionalities

Confidential

DW-BI Technical Lead

Responsibilities:

• Managed availability and accuracy of HR data for BI reports
• Handled communications to business users on data loads, system health and outage of the services
• Created process and best practices for continued improvement
• Liaised with other support teams (DBAs, UNIX, Network, Development etc.) to resolve issues
• Ensured knowledge sharing within the team
• Provided guidance to the team and helped them to solve critical issues

Confidential

DW-BI Server Administrator

Responsibilities:

• Have performed installation/upgrade of Informatica and OBIEE servers
• Managed availability and stability of ETL and reporting servers
• Implemented Secure Socket Layer(SSL) and Single Sign-On(SSO)
• Handled communications to business users on health and outage of the services
• Migrated code across environments for ETL jobs and Reports
• Created process and best practices for continued improvement
• Liaised with other Support teams (DBAs, UNIX, Network, Development etc.) to resolve issues

Confidential

DW-BI Lead Server Administrator

Responsibilities:

• Performed installation/upgrade of Informatica and OBIEE servers to cater growing business needs
• Managed availability and stability of ETL and reporting servers. Automated code migrations.
• Migrated code across environments for ETL jobs and Reports. Automated of the same.
• Liaised with other Support teams (DBAs, UNIX, Network, Development etc…) to resolve issues
• Created process and best practices continued improvement