OBJECTIVE:

To apply my skills, talents, and experience with a focus on driving and maturing an evidence and data - driven culture. Increase the likelihood for data-driven decision making by democratizing data internally, and in turn educate the organization on the utility of proprietary and non-propreitary data.

SUMMARY:

• Over 15 years of data experience in Shared Nothing, SQL, OLAP, ETL, Data Modeling/Mapping environments.
• Recent disciplines include shared nothing architectures, analytical modeling, as well as consciously moving the algorithms to the data using production worthy models.
• Developing strategy and construction of large Enterprise Analytic Data Infrastructure and Warehouse, Analytical Program/Pratice Development and Deployment.
• As well as deploying open source Analytic and BI environments from ETL development to self-service Dashboard environment construction and Production Model Deployment.
• Excellent Analysis and Presentations skills, as well as, Facilitation and Project Management Skills. Ability to work independently.

TECHNICAL ENVIRONMENTS:

BI User Interface Tools: Pentaho BI Suite, MicroStrategy, Crystal Reports, Busniess Objects, Information Advantage Decision Suite OLAP (CA),Tableau

Data Query and Modeling Tools: Hive, Pentaho Schema Workbench, Power Architect, MySQL Workbench, MicroStrategy Architect, ERWin, Oracle SQL Developer, Squirrel, SQL Workbench/J, Tableau, Toad, Weka

ETL Solutions: Sqoop, Pentaho Data Integration, PDI, Kettle, Oracle Data Integrator, Sagent, Hummingbird

CRM Systems: Siebel, Onyx

Databases: Vertica, MySQL, SQL Server, Oracle, Postgresql, CouchDB

Languages: Python, R, Regex, Shell Scripting, SQL, MDX, Java, Java Script

Servers/Operating Systems: Linux - Redhat, Linux - Ubuntu, Tomcat, Jetty, Shiny, Windows, Windows Server

EXPERIENCE:

Confidential

Sr. Analytics Developer / Database Engineer

Source Systems: Oracle, MsSQLSrvr, CouchDB NoSQL, WSO2 and Various Web APIs, Unstructured and semi-sturctured files, .csv, Excel

BI & Warehouse Environement : MsSQLSrvr, Vertica, MySQL, Postgresql, Pentaho PDI, Pentaho Business Analytics, R, Shiny, Python, Tableau

Responsibilities:

• Designed, Modeled, Constructed and Deployed Kimbalistic Data Marts that align advanced analytics with business needs as well as articulate higher order turning points from/to risks and opportunities within the business strategy.
• Led and Drove adoption of methods and techniques for advanced analytics and data-driven decision making . Enabling management by exception and data democratization . Responsible for moving production algorithms to the data.
• Designed and Constructed Integration of R & Python with Vertica Datawarehouse.
• Constructed cell phone analytical models for low income programs, using R, Vertica Machine Learning, and Weka.
• Constructed time series application forecasts, using R, Vertica Machine Learning, and Weka.
• Helped determine and architect function distribution between analytical DB and R in an effort to move the algorithms to the data.
• Developed star schema data models, ETL jobs, MDX schema(cubes) and initial self-service example dashboards, along with tuning throughout the whole system.
• Benchmarked Vertica/Pentaho Business Analytics against MS SQL Srvr/Pentaho Business Analytics. Synthesized research results into actionable strategies and recommendations. Built consensus and worked through others to achieve desired results and objectives.
• Installed and configured Vertica clusters. (multiple installations) Including Tableau connections, server and desktop.
• Constructed DWH logical and physical schemata and optimized projection development and tuning, both manually and using Database Designer.
• Constructed Data Lake containing all available sources, RDBMS, semi-structured, log, unstructured data.
• Resource pool configuration and tuning.
• Performed cluster management, configuring nodes and managing database.
• Query tuning using Explain plans and Database Designer.
• Monitored database and system logs for alerts, errors and warnings Monitor Available/free space on the OS and storage volumes and analyze space usage history and recommend changes as needed.
• Perform database or node recoveries in the case of outages, used shell scripting to monitor and recover if necessary during prime time.
• Utilize vperf series of utilities to ensure hardward capabilities and performance targets.
• Led in reviewing and revising database designs and scripts on an on going basis
• Managed data loads, and security, storage and performance strategies and implementations.

Confidential

Data Warehouse Architect - Lead

Source Systems: Oracle 10g & 11g, SQL Srvr 2005 & 2008, XML, Excel, Access, CSV, JSON, REST, Java and .Net systems

Warehouse Environment: Oracle11g, Oracle Data Integrator 10g & 11g, Vertica 7.1, 6.1, Pentaho Kettle, Tableau, Business Objects, Crystal, Cognos

Responsibilities:

• Installation of the Tableau environement
• Installation of the Vertica architecture
• Conducted monitoring and managed performance tuning, and optimization. techniques such as projections and partitions.
• Experienced in Installation and configuration of Vertica clusters. (multiple installations)
• Constructed DWH logical and physical schemata and optimized projection development and tuning, both manually and using Database Designer.
• Resource pool configuration and tuning.
• Performed cluster management, configuring nodes and managing database from admintools /CLI.
• Query tuning using Explain plans and Database Designer.
• Monitored database and system logs for alerts, errors and warnings
• Monitor Available/free space on the OS and storage volumes and analyze space usage history and recommend changes as needed.
• Perform database or node recoveries in the case of outages, used scripting to monitor and recover if necessary during prime time.
• Utilize vperf series of utilities to ensure performance targets.
• Led in reviewing and revising database designs and scripts on an on going basis.
• Manages data loads, and security, storage and performance strategies and implementations.
• Completed migration of ETL and warehouse data collection to new main source system (Netware based system to Oracle/Linux based platform)
• Re-organized Schemas/Tablespaces,/Tables/Indexes and Slowly Changing Dimensions,
• Re-Engineered/Developed ETL Jobs,
• Helped introduce incremental Change Data Capture using source system logging (Oracle Hot Logging and replicants) to increase load frequency and decrease data latency.
• Designed & Developed Logical and Physical Data Models for 5 new Star Schemas / Business Object Universes for:
• Sales and Marketing - Customer Density Dashboards
• Customer addition of latlong information and scrubbed addresses using Google maps/kettle web-service interfaces. eLearning Ad Hoc Environment with interfaces to EV5 (ADP HRIS) and Ms IIS log files
• Wash Data - Interfaces with XML and JSON data collection and integration requirements from plant floor wash aisle - into Plant ODS and then the EDW
• GE Fleet Data Mart - data integration with Kronos and Route accounting system.
• SFA CRM on Demand star and data interface with EDW.
• Hadoop Pentaho/Flume social media scrape
• Hadoop ETL of archive data over 3 years old

Confidential

BI Developer/Data Warehouse Architect/BI DATA Modeler/Business Intelligence Analyst

Source Systems: MySQL, Java, Oracle, SQL Server, Excel, Access, Log4j, CSV

Warehouse Environment: Pentaho BI Suite, Kettle, Pentaho Data Integration (PDI), BI Server, MySQL, Tomcat, Jetty, Linux, Solaris, SQL, MDX, Java Script

Responsibilities:

• Conducted information discovery for end user requirements as well as all functional and non-functional requirements.
• Using requirements, designed dimensional data model (Star Schema - Logical and Physical Data Models) for the new data warehouse.
• Identified source data for warehouse.
• Installed and configured Pentaho BI Suite including Kettle, PDI Server, BI Server, Pentaho Enterprise Console (PEC) as well as client tools - Schema Workbench, Spoon, PRD (Penthao Report Designer), JSON, REST
• Developed Kettle transformations and jobs to perform ETL processes from source data to loading dimensions and fact tables.
• Designed, built, and configured the BI environment using Pentaho Projects. Including creating cubes, virtual cubes, dimensions and dimensional attributes, facts, measures, calculated measures.
• Constructed complex reports and Analyzer Dashboards.
• Deployed cubes, reports/dashboards, and established ETL schedules.

Confidential

Data Warehouse Architect/BI DATA Modeler/Business Intelligence Analyst

Source Systems: Java, Oracle, SQL Server, Excel, Access

Warehouse Environment: Oracle, SQL Server, MicroStrategy 8 and 9

Responsibilities:

• Built Recovery Act Data Mart from ground up for Secretary of Confidential to present resulting Dashboards/Scorecards/Reports at Confidential Cabinet meetings.
• Conducted information discovery for end user requirements as well as all functional and non-functional requirements.
• Using requirements, designed MicroStrategy and SQL Server snowflake Logical and Physical Data Models for new data mart.
• Designed, built, and configured MicroStrategy Environment. Including install MicroStrategy9, created projects, attributes, facts and developed complex reports ( Constructed MicroStrategy filters, prompts, metric, hierarchies, drill maps, and new reports/dashboards necessary to fulfill requirements); administered and maintained MicroStrategy projects
• Designed and developed ETL process using SQL.
• Designed Data Models for three different Confidential applications

Confidential

Business Intelligence Analyst/DATA Modeler/Data Warehouse Architect

Source Systems: Java, MySQL, Excel

Warehouse environment: MicroStrategy, SQL Server 2005, SQL Server Integration Services

Responsibilities:

• Conducted information discovery for end user requirements as well as all functional and non-functional requirements.
• Using requirements, designed MicroStrategy and SQL Server snowflake Logical and Physical Data Models for new data warehouse.
• Designed, built, and configured MicroStrategy Dev, Test, and Production Projects. Including install MicroStrategy products, created projects, attributes, facts, and developed complex reports ( Constructed MicroStrategy filters, prompts, metric, hierarchies, drill maps, and new reports necessary to fulfill requirements); deployed projects using MicroStrategy Desktop, MicroStrategy Web, and MicroStrategy Narrowcast; administered MicroStrategy projects
• Identified source data for warehouse.
• Designed ETL process and worked with source systems to source data elements.
• Managed ETL package construction