PROFESSIONAL SUMMARY:

• 20+ years of IT experience,
• 20+ years of development experience in Data Warehousing, Data Analysis, BI, ETL, Data Modeling,
• 10+ years of experience on OBIEE in designing Dashboards, Answers, Repository, Catalog and Administration.
• 10+ years of experience in developing and automating Essbase cubes.
• Expertise in providing end - to-end business intelligence solutions from requirements gathering to production support.
• Expertise in data modeling using dimensional modeling techniques.

TECHNICAL SKILLS:

Big Data: Hadoop, Hive, NiFi

BI Tools: OBIEE, Alphablox, Crystal Reports, Smart View, Tableau, Hyperion (FR, Workspace)

OLAP Tools: Essbase, Essbase Studio, Hyperion Planning, Hyperion Shared Services

ETL Tools:: Informatica, ODI, DataStage (Training Only), Prism Warehouse Manager

RDBMS:: Teradata, Oracle, Informix, Microsoft SQL Server, DB2, Microsoft Access

Languages:: SQL, Visual Basic, ASP, C, JavaScript, VBScript, Java, JSP, C

OS:: Oracle Enterprise Linux, HP-UX, Windows Server, MVS, VMS

Misc Tools:: Erwin, SQL Developer/Data Modeler, Autosys, IIS, Control-M, Planview, MS Project, Siebel, Peoplesoft

WORK EXPERIENCE:

Confidential

Sr. Business Intelligence Lead Developer

Responsibilities:

• Responsible for gathering and refining requirements and providing development estimates.
• Responsible for designing the logical and physical data models along with reviewing with business to ensure accuracy.
• Responsible for designing the source to target mappings for the ETL developers again reviewing each with the business.
• Lead 5 ETL developers through the development, system integration, user acceptance testing and implementation.
• Designed the OBIEE security, repository and reports that were consumed by the UI team via web services.
• Automated the nightly batch process using Autosys scheduling package
• Coordinated all technical aspects of the project.
• Gathering and refining requirements and providing development estimates.
• Designing the logical and physical data models.
• Designing the source to target mappings for the ETL developers.
• Developing the ETL mappings for developers
• Designed the OBIEE repository and reports.
• Automated the nightly batch process using Autosys scheduling package
• Liaison with the EDW Team to ensure they understand and capture the Siebel data appropriately.

Confidential

Responsibilities:

• Analysis of the current OBIA out of the box and custom mappings for understanding of the current as is solution.
• Work with the business to design the new OBIA to be solution
• Worked with DBAs to design a migration plan utilizing Oracle’s Golden Gate application to allow for a smooth and uninterrupted transition of the call center operations from outsourcer to internal application.
• Upgrade OBIA version from 7.8.2 to 7.9.6.4 retaining Informatica to support existing custom ETLs.
• Converted Database from IBM DB2 to Oracle.
• Lead a team of 4 ETL developers to repair broken custom ETLs from the conversion from DB2 to Oracle.
• Automated the batch cycles using Autosys scheduling package.

Technologies: OBIA, Oracle, Informatica, ODI, DataStage, Siebel, Golden Gate

Confidential

Sr. Business Intelligence Lead Developer

Responsibilities:

• BI Lead responsible for guiding the OBIEE 10g to 11g upgrade and migration.
• BI Lead responsible for the development and maintenance of multiple Subjects Areas. Responsibilities included the design/development of the repository (physical, business model & presentation layers), Security, Catalog, Answers, Dashboards, Delivers and BI Publisher.
• Responsible for development/maintenance of BI Publisher reports. Responsibilities included template development, bursting logic, MDX for Essbase, SQL for SQL Server and scheduling.
• Performed end user training of OBIEE capabilities and best practices.
• Lead OBIEE Administrator responsible for installations, upgrades, security and migrations.
• Responsible for the Hyperion System 9 to 11g migration. The Hyperion environment included Essbase, Planning, Workspace, Shared Services and Financial Reporting.
• Responsible for day to day administration and support of the Hyperion Environment.
• Developed advanced reporting allowing the finance team to identify discrepancies between the financial system(s) of record, data warehouse, financial interface and financial consolidation system. Solution included federated queries, conforming dimensions, write back calling stored procedures and javascript.

Technologies: OBIEE, Essbase, Hyperion Planning, Financial Reporting, SQL Server, JavaScript, SQL, MDX

Sr. Business Intelligence Best Practices Lead

Confidential

Responsibilities:

• Lead BI Architect responsible for guiding the OBIEE 10g to 11g upgrade and migration to high available environment.
• Responsible for ensuring BI Best Practices are utilized throughout the Solution Teams in regards to OBIEE development. This promotes consistency, maintainability and reuse throughout the organization.
• Lead BI Architect responsible for performing initial project assessments, gathering ETL/BI requirements, developing ETL/BI specifications, designing relational and OLAP structures, managing resources and performing quality assurance of developed ETL/BI applications.
• Lead OBIEE resource responsible for the administration, development and maintenance of multiple Subjects Areas with OBIEE. Responsibilities included the design/development of the repository (physical, business model & presentation layers), Catalog, Answers, and Dashboards.
• Member of BI Roadmap team developing the BI Strategy for the organization. This consisted of understanding current BI capabilities, mapping BI demand and evaluating the OBIA collection of applications for fit/priority for the organization.
• Lead Essbase resource responsible for the development and maintenance of multiple cubes to aid users in the analysis of data. Supported roughly 25-30 cubes and automated processes.

Technologies : OBIEE, Essbase, Teradata, Oracle, Informix, SQL Server, Alphablox, ASP, JSP, Unix, Linux, SQL

Confidential

Team Leader, Business Intelligence

Responsibilities:

• As Business Intelligence Team Leader, I was responsible for the estimation, planning, staffing and scheduling all BICC/EDW Projects for the fiscal year. This also includes project oversight, communicating project status to business owners and key stakeholders, and managing project budgets.
• Responsibilities include setting the BICC Direction/Strategy and communicating with other teams across the enterprise.
• The team consists of both employees and consultants (US based and Offshore). For the employees, I am responsible for conducting mid-year and year-end performance reviews along with mentoring with career goals.
• Lead the project to install/configure OBIEE as our corporate BI solution. Responsible for establishing the development, test and production environments.
• Lead BI Architect responsible for performing initial project assessments, gathering ETL/BI requirements, developing ETL/BI specifications, designing relational and OLAP structures, managing offshore resources and performing quality assurance of developed ETL/BI applications.
• Lead OBIEE resource responsible for the administration, development and maintenance of multiple Subjects Areas with OBIEE. Responsibilities included the design/development of the repository, Catalog, Answers, and Dashboards.
• Lead Essbase resource responsible for the development and maintenance of multiple cubes to aid user groups in the analysis of data. Supported roughly 25-30 cubes and automated processes.

Technologies : OBIEE, Essbase, Alphablox, Oracle, ASP, JSP, Unix, Linux, SQL

EDW Architect

Confidential

Responsibilities:

• Lead EDW Architect responsible for performing initial project assessments, gathering ETL/BI requirements, developing ETL/BI specifications, designing relational and OLAP structures, managing offshore resources and performing quality assurance of developed ETL/BI applications.
• Developed an analytic application based on Microsoft Project Server data that allowed for the analysis of hours worked and costs by projects, tasks and resources. This project led to the reduction of the monthly billing cycle.
• Developed an analytic application based on Warranty Claims data that helped reduce time to detect issues and assisted in the prioritization of issues.
• Lead Essbase resource responsible for the development and maintenance of multiple cubes.

Technologies : Erwin, Essbase, Alphablox, Oracle, Informix, SQL Server, ASP, JSP, Unix, SQL, Crystal Reports

ETL/Business Intelligence Technical Lead

Confidential

Responsibilities:

• Lead BI Specialist for an Enterprise Data Warehousing group utilizing ASP, Essbase, Alphablox, and Crystal Reports to deliver world class enterprise solutions.
• Business Intelligence application developed include key business indicators project delivered via a home grown portal, banded reporting, managed queries, OLAP and ad-hoc queries.
• Responsible for developing a common Analytic Framework to deliver rapid Analytic capabilities to the business with enhanced time to market at significantly lower costs. This framework allows for the analysis of summary data using Alphablox and Essbase and then drill-through to detail level data using ASP and relational databases.
• Developed a common reporting architecture that manages the creation, storage, usage and delivery of all EDW reports and metadata using ASP, Crystal Reports, Visual Basic, SQL Server and COM.
• Lead Essbase resource responsible for the development and maintenance of multiple cubes.
• Lead ETL Specialist for an Enterprise Data Warehousing group utilizing C and Prism Warehouse Manager to populate Informix Databases in an HP-UX environment. I was primarily responsible for the development and maintenance of a 3 tier Confidential (Primitive, Standard Collection, and Direct Access).
• Establishing the Development and Production Environments on the Unix Platform which included the development of common directory structures, source code management, development standards, and common processes.
• Responsible for training other developers in UNIX, Prism, RCS, and development standards.

Technologies : Erwin, Essbase, Alphablox, Oracle, Informix, SQL Server, ASP, JSP, Unix, SQL, Crystal Reports