PROFESSIONAL SUMMARY:

• IT Leader with diversified experience of executing transformation programs and solutions in Data Engineering and Data Management, Information Delivery, Business Intelligence, large scale Data Integration, Data Warehousing, and Data - Marts implementations with good Data Governance.
• Accomplished 22 years of IT experience in diversified domains including Finance, Human Resources, Consulting, Healthcare, Insurance, Telecom, and Manufacturing.
• Proven leadership and strategy development skills, with extensive experience in high profile programs execution and delivery; Strong record of assembling efficient teams and execution.
• Excellent process orientation, change management and project management background with strong adaptability of Waterfall or AGILE development life cycle methodologies.
• Known for using the right tools when and where they make sense and creating an intuitive architecture that helps organizations effectively analyse and process structured and unstructured data, Big Data and Confidential (AWS) Cloud Data Engineering solutions.

PROFESSIONAL EXPERIENCE:

Confidential, NC

Lead Development Manager

Responsibilities:

• Provided leadership direction in Data Engineering, Information Delivery and data management transformation programs. Set strategy and priorities for change agenda.
• Established culture of continuous improvement in operations and support activities for BI, ETL, DW and DM programs.
• Managed projects, technology systems/tools, and skilled staff, supporting company’s financials, accounting, actuarial, and human resources information.
• Directed implementation and launch of over ten distinguished BI/DW applications, data visualization efforts, direct to suitable tools selection process, architecture maps, design, overall quality of implementation.
• Directed, managed and guided teams within my areas of responsibilities to support my key functions.
• Full responsibility of all facets of projects and anchoring suitable project methodologies (AGILE or WATERFALL) and Data Governance.
• Acted as “Voice of Customer” inside IT organization to ensure alignment with business and prioritize IT work efforts.
• Maintained strategic network relationship with internal IT partners and business stakeholders.
• Championed business programs/process changes and technology changes to drive year-over-year improvement. Develop and contribute year-by-year roadmap, cost and resource plans, to support growth and improve service.
• Big Data, Hadoop for Data Ingestion and Data Analytics solutions.
• AWS ( Confidential ) cloud data architecture and data integration solutions.
• Good understanding of ODI (Oracle data integrator) and EL- Confidential methodologies.
• Strategic BI Tools selection and adaption: Collaborated with external vendors of Tableau, Qlik-Sense, Microsoft Power Bi, OBIEE, Micro Strategy, internal partners and executed the BI Tool selection program/workshops for our Finance partners.
• Beta contribution: Key participant in Oracle’s Beta program and completed evaluation of next generation OBIEE 12c and Oracle Visual Analyzer tools.
• Early adaption of Tableau: Brought this BI Tool into Finance/Actuarial group, formed efficient team, successfully implemented data visualization projects for Confidential & FA.
• Upgraded Oracle BI Analytics applications onto latest OBIEE platform.
• Transformed BI Analytics warehouses onto EXADATA environment and BI Analytics applications onto EXALYTICS environment to provide speed-of-thought analytics.
• Procurement and Spend Analytics. Implemented Oracle Data mart and OBIEE reporting application and replaced the legacy Access & Excel based solution.
• Replacement of BI Query tool which transformed terabytes sized SQL Server database + BI Query tool set into an Oracle database with OBIEE.
• Financial Management Information Delivery re-platforming effort is a multi-year program. The legacy solution was originally built using Essbase cubes as source. Key deliverables are data engineering, ingestion and transform into relational data models, oracle delivered data models such as OBAW/OFSDF, and deliver information via distinguished visualizations/analytics using Tableau and OBIEE.

Confidential

Responsibilities:

• Technical delivery of projects with efficient team management. Directly responsible for leading and delivering BI Applications, DI/ETL and Data warehouse implementations in Confidential and Finance areas, and converting from legacy systems.
• Data Engineering and Integration Life Cycle, Change management and documentation
• RM Data Warehouse and BI Analytics, Financial Data Warehouse, and BI Analytics,
• Confidential Data Warehouse and Analytics Expansion Project

Sr. Technical Analyst

Confidential

Responsibilities:

• OBI Apps and OBIEE Implementation, Data Architecting, and Data Modelling, Informatica ETL Mappings Development, Business (Data) Analysis, Change control and documentation
• Finance Data-warehouse and Analytics; Confidential Data-warehouse and BI Analytics; converting from legacy systems; Confidential Data Mart Stabilization project and HPLC project;
• Regulatory Oversight ETL and BI Analytics project

Confidential, NC

Lead Data/ETL Architect

Responsibilities:

• Data Modelling and Architecting Human Resource Data mart Confidential
• This data mart was used as system of authority for Confidential Reporting system and acted as data hub provisioning data feeds to more than 50 internal and external key systems.
• Led Informatica ETL Mappings Development
• Business (Data) Analysis on Oracle9i based Lawson Confidential Database (source system of record).

Confidential, TX

Data/ETL Architect

Responsibilities:

• Responsible for the complete data mart and ETL development activities
• Worked closely with project and business teams, Legacy Data Analysis, Schema design and Data modelling; Technical design and build ETL procedures/standards to feed seed legacy data from SQL-Server into Oracle9i database, Security procedures using PL/SQL and automation; Mentored other developers on SQL Optimization and application usage; Reviewed and assisted in developing the security and database standards for the application.
• Built and stood up data mart, ETL, and Data Management solutions to support their web application for Call Center Performance.
• This application was adapted by all Confidential & Confidential cost centre managers and reduced their manual hours by 25% and increased productivity.

Confidential, NH

DBA Manager

Responsibilities:

• Managed team of Database Architects, DBAs, and Developers to support Healthcare Data Management and Governance.
• Architected and developed Enterprise data integration models into Siebel CRM, Healthcare Data warehouse and other Data marts, using Oracle ETL and PL/SQL technology.
• Implemented best practices/standards to provide 24x7 coverage for all enterprise databases Operations and SDLC (Development/Test/Training/Staging/Demo) databases
• Database upgrades from Oracle 8i to Oracle 9i (All non-Siebel environments) and Oracle 9i to Oracle 10g (Warehouse environment).

Confidential, MA,

Software Engineer/Lead Oracle DBA

Responsibilities:

• Managed Oracle DBA functions and ETL development using PL/SQL; Architected ETL processes for the Siebel OLTP, Siebel EIM, Siebel EAI, Data warehouse and Data Marts using SQL, PL/SQL.
• Developed documentation, SOPs on all production databases and data feeding processes.
• Worked closely with system Integrators and provided DBA/Development support for the implementation of Siebel 5.5 Call Centre and upgrade to Siebel 2000 Call Centre, and implementation of Healthware Data Warehouse
• Design & Maintenance of Data Marts for Reporting Team
• Production Support of databases for Confidential Call Manager
• Integrated Call Centre Phone Data, Call Management System (Oracle 9i Rel2, SAS, Win2K)