ORACLE DATA WAREHOUSE CONSULTANT

• Business Performance Management Decision Support Systems Strategic IT Asset Management
• Led high performance business intelligence, data warehousing, data management and data analyst teams with over 20 years of extensive, diverse experience in big data environments working in organization that are leaders in their specific domain. In depth knowledge of Financial Service/Market, Digital, e-commerce, Telecom, Consumer Product, Target Marketing, Health Care and Travel. Deep understanding of emerging information management technology used to analyze and support large volumes of structured and unstructured data as demonstrated by recent leadership rolls, providing architectural direction and development guidance in schema designs Star, Snowflake, etc. , dimension hierarchies, pre-computed aggregations and cubing. Consistently focus on IT Governance as the driving force to assure that the investments in IT assets delivered business value enabling organizations to achieve and maintain a strong competitive advantage. Deep ability to understand business requirements, articulate a vision, evaluate risks and define roadmaps to build and strengthen IT capabilities, processes, and infrastructure/system investments. Quickly and effectively develop key relationships with a range of project participants including executives, vendors, client stakeholders, and developers. Guided and mentored system administrators, data architects and database professionals. Monitored/analyzed multi-million dollar annual operating and program budgets and designed systems which managed over a petabyte of structured, unstructured and semi-structured data. Core Competencies include:
• Oracle SQL Performance Turning Oracle Data Warehouse Advanced Oracle SQL
• Business Intelligence Data Visualization Data Analysis
• ParAccel Analytic Database Tableau Digital Analytics

PROFESSIONAL EXPERIENCE

Confidential

Founder / Principal Oracle SQL Data Warehouse Consultant

Oracle SQL developer with significant Oracle data warehouse, Oracle data mart and business intelligence experience. Established the vision and led the development of a multidimensional data warehousing system which processed and stored over a petabyte of data. Used Oracle SQL to build custom ETL processes, generate advanced analytics, improve query response time and increase data security. Adept at using Oracle SQL to produce statistical analysis, data mining algorithms and descriptive, diagnostic, predictive and prescriptive analytics. Major clients and accomplishments follow.

Confidential

Lead Business Data Analyst

• Lead three teams. Produce and maintain applications to meet key government reporting requirements. Manage data analysis, business analysis, data warehouse analysis, unit testing to ensure that development teams meet business requirement to minimizing rework. Work with DBAs to recommend and implement data warehouse enhancement. Research and present data warehouse best practices and innovations. Participate on government programs data warehouse change control board. Review and alter all problem SQL statements ensuring that correct results are produce, time to execute is effective / efficient, and system resources are optimized. Represent government programs in external corporate meetings, architect evaluate impact and raise concerns when required and prepare brief for directors. Coordinate data warehouse migrations.
• Provided leadership as the SME maintaining and sharing expertise in the areas of Oracle data warehousing, industry trends, strategies, and products. Orchestrated the change in strategic direction by researching the use of, analyzing potential benefits, and tabulating results of a study demonstrating the benefits of applying Oracle partitioning local index strategy. Study demonstrated a potential expected performance boost of over sixty thousand percent 60,000 when compared to benchmarked queries. Strategy was quickly adopted by organization and was responsible for leading the performance optimization implementation effort.
• Led assessments of business processes/requirements providing clear insight to cross functional teams resulting in an increase in overall performance. Coordinated testing strategy and benchmarked results against expected performance metrics and business requirements. Spearheaded the preparation of traceability matrices and the presentation of preventative and corrective measures to senior management for consideration. Designed predictive models to estimate on-going maintenance cost, system utilization patterns, and change management efforts.
• Accentuated strategic objectives in the design and writing of approach documents gaining acceptance from executive sponsors and business unit process owners. Provided senior management direction in required government regulatory reporting, reengineering the manual intensive reporting process into an automated process generated from an Operational Data Store ODS by leading the development of gap analysis, data warehouse architectural design documents, business and data requirements documents, mapping documents, and quality assurance test plans. Reengineering effort resulted in the elimination of 100's of hours of monthly labor hours and reduced costly rework resulting from errors due the manual process.
• Screened and evaluated resumes of potential project managers, business and data analyst, and developers. Interviewed candidates, made hiring recommendations and contributed to the growth of the number of team members threefold. Motivated team members by effectively employing a participatory management style which encouraged accountability, teamwork, and continuous individual and process improvements. Maintained over 90 percent rate of retention for consulting resources and zero percent turnover rate for full-time staff.
• Coached and mentored inter-departmental teams on Oracle's physical and logical performance tuning best practices. Ensured data integrity and efficient SQL CPU utilization and execution time by evaluating and optimizing queries before production deployment. Achieved a performance boost of over one thousand percent 1,000 for most queries submitted, often going from multiple hours to execute to milliseconds, seconds, or minutes.

Confidential

Lead Data Architect Oracle Data Warehouse Advisor

• Retained to provide technical leadership, direction, and delivery of an enterprise data strategy and data
• architectural guidance. Once accepted by execute team, was reengaged to evaluate documentation
• outlining the design and architecture of a financial data warehouse drafted by external vendors.
• Led the preparation of the data dictionary and taxonomies. Prepared client briefings in the areas of data governance, reference data, and master data management MDM . Provided expert data warehousing guidance and thought leadership by gathering requirements, researching and documenting best practices, and introducing strategic innovations. Reenergized multi-year, multi-million dollars data warehouse architectural design, development and deployment effort.
• Recommended appropriate data warehouse schemas, designed a logical blueprint for data warehouse design and reviewed SQL for optimization. Proposed comprehensive partitioning, indexing, advance buffer management, and tablespace allocation strategies. Developed proof of concept POC model which was adopted by organization. Commissioned the build and tests of POC and benchmarked POC model for comparative analysis. POC showed a potential improvement from several hours to minutes in ETL execution timing. Estimated performance against expected table size growth rate to ensure continued satisfactory performance.

Confidential

Sr. Business Intelligence Engineer

• Developed strategic roadmaps, delivered a comprehensive data strategy, negotiated system functionality for the financial data warehouse, drafted and communicated architectural design and demonstrated process for continual system improvements allowing finance department to save over 500K in anticipated business intelligence system acquisition cost. Created and maintained the metadata repository, and provided guidance and consultation to multiple business groups to ensure on-going projects were in alignment with the corporate data architecture.
• Managed the entire BI product lifecycle, conceived, designed, and led the development of comprehensive dashboards, analytical reports, and supporting infrastructure including conversion, funnel, cohort, and lifetime value LTV analysis, key performance indicators KPIs , and an aggregation strategy replacing third party software Google Urchin and Kontagent resulting in annual saving of more than 180K per product group.
• Coached junior business intelligence engineers, supervised team of report writers, and partnered with executives, product managers and analysts to ensure data integrity, resolved data discrepancies and trained stakeholders. Simplify processes and slashed time to complete the development of custom reports and analysis and the resolution of tickets by an average of 80 .
• Architected A/B and multivariate testing, led the analysis of results, participated in decision making process contributing to an increase in customer loyalty by 25 measured by repeat site visits.
• Shared best practices to drive continual improvement and served as the subject matter expert for the enterprise Tableau business intelligence system, the ParAccel data warehouse physical and logical design and development , the Oracle ETL process, the evaluation of Oracle Business Intelligence Executive Edition 11g OBIEE , and the optimization of SQL for MySQL, PostgreSQL, ParAccel MPP columnar database and Oracle.

Confidential

Chief Oracle Data Warehouse Architect Director

Retained as Oracle Data Warehouse Architect/Lead Development Consultant. Once data warehouse and business intelligence system developed, hired as full time employee to manage.

• Led the delivery of data warehouse project components through complete life cycle initiation, planning, execution and closure , managed activities of project team members, maintenance and creation of status reports, work breakdown structures WBS , critical path analysis, project schedules and working papers.
• Collaborated with business and technology departments to define deliverables and develop solutions that were reusable across the organization.
• Established the vision for and led the design and development of the dimensional data warehouse and business intelligence system, pioneered the use of Metadata repositories to uncover patterns of system utilization allowing for the identification of opportunities for system improvements and the ability to mitigate system issues leading to over 30 reduction in costly customer service calls.
• Managed, mentored, trained, and guided junior application developers and DBAs, directed activities and reviewed code of offshore and onsite database application developers, and served as senior data warehousing and business intelligence technical advisor to upper management and executives. Designed and built a Microsoft Access tracking system that contributed to the reduction of costly SLA violation penalties by 50 .
• Hands on supervisor of Crystal Reports and Oracle Business Intelligence Executive Edition 10g OBIEE developers and systems. Designed reports and optimized queries, and built dashboards. Trained users, gather requirements, and presented business cases.
• Conceptualized and programmed a custom ETL process utilizing Oracle SQL PL/SQL that extracted, transformed, and loaded more than over 1.5B transaction records per day, resulting in the storage of multi-terabytes of data.
• Enabled securing of multi-million contract with Telcel Mexico's largest wireless carrier by building process that ensured rendering of timely and actionable reporting on key business metrics.

Confidential

Data Database Project Lead, Architect, Analyst, and Developer

For details on each assignment, see attachment

Consulting Roles:

• Oracle Business Intelligence Specialist II at NYC Housing Authority
• Business Analyst at Jewish National Fund
• Database Developer at Travel Impressions, An American Express Company
• Oracle Solution Architect at MBS Insight, Inc.
• Oracle Database Reporting Analyst at Sleepy's, Inc.
• Oracle Database Reporting Associate at TheStreet.Com
• Senior Management Consultant/Data Analyst at MetroPlus Health Plan.
• Senior Oracle Report Writer/Oracle SQL Developer at Jewish Theological Seminary
• Programmer Analyst at Interfaith Medical Center
• Data Analyst at NY Mercantile Exchange