Dw - Bi Technical Lead Resume
Kingston Rhode, IslanD
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
DW - BI Technical LeadResponsibilities:
- 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