Summary

• Experienced solutions-oriented IT professional with proven ability in designing, implementing, analyzing, and building high-performance technical solutions to meet challenging business needs.
• Experienced in collecting and analyzing business requirements and developing system specifications to increase efficiency and capability throughout organizations
• Organized, take-charge professional with exceptional follow-through abilities and detail orientation, able to plan and oversee multiple projects from conception to successful conclusions
• Analytical problem solver strength in analyzing, organizing and reporting data to identify trends, and detect and respond immediately to new opportunities or issues
• Outstanding liaison and communication skills proven by effective interaction with customers, management and team members

Skills

• Applications: Pentaho, OBIEE 10.1.3.2 and OBIEE 11.1.1.6.0 Platforms, Oracle Warehouse Builder, Oracle 10g MS Office, Outlook, Visio, , SQL Server, MS Access, Saleforce.com, ReQlogic
• Operations: business intelligence, data analysis, unit testing, integration testing, system monitoring and production support
• Operating Environments: Windows 3.1/95/98/2000/XP/2003/Vista/7
• Languages: SQL, PL/SQL, HTML

Employment

Confidential

Business Analyst/BI Developer

BI Developer Generalist, with experience in Oracle pre-packaged analytics, as well as Oracle custom ETL development. Responsible for the OBIEE Lab, installation of all OBIEE components and maintenance.

Select projects include

• Worked as a BI Developer Generalist at a leading financial services / retirement services provider. Project supporting sales reporting for the Asset Management Division of a large retirement services provider universities, and hospitals. Developed data definitions for data elements utilized in sales reporting. Documented data lineage via source to target mappings along with data flows for sales data from source systems to data warehouses and onto individual reports and dashboards. Enabling client to trace data from individuals reports to source systems to increase accuracy of sales reports.
• Worked as a BI Developer Generalist at a Dialysis Medical Provider.
• Created a Data Warehouse glossary, by Metadata collection and analysis collect and analyze all relevant documentation, schedule and conduct interviews.

Confidential

BI Developer/Architect

• Worked as a BI Developer at City and County of Denver
• Created and developed OBIEE reports and dashboards using OBIEE 10g and 11g.
• Environment: Oracle Business Intelligence 10.1.3.4.1 11.1.1.0 Oracle Data Integrator 11g 11.1.1 SQL Developer 3.2.10.09
• Developed reports and dashboards as per the business requirements
• Troubleshoot/resolve issues and maintain the development
• Created and maintained ODI processes
• Preform RPD changes per business requirements
• Documented Development and Production Environments

Confidential

Oracle BI Developer

• BI developer generalist, with experience in Oracle pre-packaged analytics, as well as Oracle custom ETL development.
• Select projects include:
• Confidential
• Environment: Oracle 10g, Oracle Warehouse Builder 11.2.0.3 SQL Developer 3.0.04
• Designed and Modeled 31 staging tables Developed and created 31 staging tables, 10 Dimension tables and 2 Fact tables per the business requirements
• Documented ETL process

BI Developer Consultant

Confidential

• Environment: Oracle BI Enterprise Edition OBIEE 10.1.3.4
• Developed reports and dashboards per the business requirements
• Dashboards: AP Common, Financials Account Payable, Financials Account Receivable, Financials General Ledger, Procurement and Spend APL, Project Cost - APL
• Reports: Receipt Details/ Shipping Activity/ Reference PO Shipments/ Active Subcontractors by Buyer/ Blanket Contract Details/ Small Business Subcontracting/ PO List/ Pos with Expiring Projects/ Procurement Audit/ On Time Delivery/ Receipt Search/ Discrepancy Report/ Invoice Period of Performance/ Receiving Activity/ Staff Productivity/ Open Invoice Details/ GL Close Analysis Period and /Project
• Troubleshoot/resolve issues and maintain the development
• Trained and mentored JHU-APL developers
• Lead overall documentation effort
• Documented reporting specs
• Created dashboard and report test scripts
• Facilitated report reviews and end user training

Confidential

Business Intelligence ETL Developer

Environment: Oracle BI Enterprise Editions 10.1.3.2

• Source code control using Subversion
• Oracle Business Intelligence OBIEE
• Business analysis and requirements
• Responsible for full lifecycle development of Business Intelligence solutions including requirements gathering, and gap analysis, source system identification, data profiling, ETL development and solution testing. The solution sourced data from SaleForce.com, Great Plains and internal data, leveraged Pentaho for the ETL, and OBIEE for the presentation layer. In addition to data architecture, worked with OBIEE team, to ensure solutions were unit, and integrated tested maintaining the accuracy of information. Provided end-user training. Responsible for data and application migration into testing and production environments.
• Pentaho Data Integrator design and development
• Data analysis using TOAD

Confidential

Team Lead /System Consultant

• Systems Consultant at EnCana Oil and Gas. Provided application support, documentation and resolving issues using available resources. Supported department specific solutions.
• Omnivex
• ProphetX
• PI Dwights
• Caminus Altrapipe, GMS
• Contract Management System Allegro
• Planned CLP's Career Life Plan sessions for team members

Confidential

Technical Support Specialist

• Epic health care software support
• PC Roll out

Confidential

IT Application Systems Analyst

• Member of Billing system conversion team
• Developed and maintained SQL queries
• Built, integrated and maintained Client Table and Master Files into new CBP platform
• System support