TECHNICAL SKILLS:

Software: Microsoft BI Stack (SSIS, SSRS, SSAS), Pentaho BI Stack

Coding: Python, Javascript, Java

Reporting: Tableau, Pentaho (Analyzer, CTools, Report Designer), Omniture MicroStrategy (Desktop, Web Services), QlikView

Databases: MySQL, DB2, Oracle, SQL Server, MongoDB, Postgresql

Servers: Windows, Linux

Web Development: HTML, CSS, Jquery, bootstrap

Other: Docker, Jenkins, Git, AWS, Google Cloud, SQL

PROFESSIONAL EXPERIENCE:

Confidential, MO

Senior Consultant - Analytics Lead

Environment: Ctools, Javascript, SQL Server, MySQL, Postgresql

Responsibilities:

• Responsible for defining the strategy and long-term vision for executive leadership to make data driven decisions.
• Currently leading the design and implementation of key performance indicators and dashboards to provide analysis and notifications for current operational status.
• Providing subject matter expertise for visualization design. Dashboard Development utilizing Javascript, JQuery, HTML, CSS, and Ctools.
• Create SQL Queries to access data from SQL Server to be used for frontend Dashboard components.
• Works closely with data integration team providing requirements for data model and solutions for performance tuning.
• Provided leadership in regards to security best practices, responsible for the management and configuration for SSL client authentication in an enterprise single sign-on (SSO) environment.
• Successfully utilized docker to expedite the development of proof of concept (POC) systems and applications (CAS SSO, Postgresql).

Confidential, San Francisco, CA

Senior Consultant

Environment: Data Integration, Data Management, Java, Postgresql, Oracle, SQL Server, MySQL

Responsibilities:

• Traveling consultant providing support on multiple projects across different emerging enterprises utilizing open source technologies.
• Client facing experience in several diverse consulting environments.
• Lead strategy discussions with technical and non technical project stakeholders.
• Provided data integration training for multiple clients mentoring staff on best practices.
• Enterprise data migration project with pharmaceutical domain.
• As Senior Consultant provided code review for data migration proceses and technical expertise for development staff.
• Hands on ETL development with Java Unit testing and continuous integration utilizing tools Git, Jenkins, and Docker.
• Data Modeling and Visualization development project with human resources domain.
• Translated functional requirements from Senior Management into actionable technical specifications for Cube and Dimensional model.
• Leading the design and implementation of data visualizations to provide insight and notification for stakeholders to make informed data driven decisions.
• Enterprise data integration project with Government services and accounting domain.
• Evaluated inefficient manual processes and lead the architecture and re-design of automated data integration solutions.
• Contributor of the implementation of continuous testing environment developed with Ruby framework (Rspec).
• Developed ETL solutions for integration tests deployed from Git version control to Jenkins for continuous testing of ETL.

Confidential, Memphis, TN

Senior Consultant - Data Integration Lead

Environment: Kettle, SSIS, Linux, Postgresql, Oracle, SQL Server

Responsibilities:

• Lead administer of Pentaho enterprise environments in a linux environment.
• Troubleshooting server side and performance issues.
• Developed management processes for backup/restore and disaster recovery options (Linux,PostgreSQL Database repository).
• Responsible for maintaining and patching existing server infrastructure.
• Responsible for business intelligence/data analytic processes and technology improvement initiatives.
• Provided leadership assistant to report analysts in planning, analysis and execution of plans.
• Enforced Standards and best practices for ETL processes.
• Controlled Enterprise migration of ETL and reporting components across environments.
• Modified role level report security based on business requirements. Hands on ETL development utilizing Kettle and SSIS.
• Translated functional requirements from Senior Management into actionable technical specifications for report migration solution.
• Managed project working with onshore and offshore development team to provide an automated solution.
• Responsible for the design, development, and implementation of reporting solutions.
• Supported ETL, metadata, dimensional cubes. Data Integration utilizing SSIS and PDI (Kettle).
• Linux server administrator providing support and resolution of application related issues.
• Produced summary and detailed reporting solutions for key performance indicators utilizing data housed in multiple databases/systems.
• Linux server administrator providing support and resolution of application related issues.

Confidential, Chicago, IL

Senior Consultant - Data Integration Lead

Environment: Kettle, Git, Javascript, MySQL

Responsibilities:

• ETL design, development, and optimization of data integration processes that automate the movement of data between business applications and data stores.
• Identification of key data issues coordinating with multiple teams internal and external to determine data requirements and business logic applicable to each client.
• Develop and maintain javascript and Python scripts for data processing within ETL components.
• Analysis of existing processes introducing more efficient data delivery methods utilizing best practices. Provided performance tuning, troubleshooting assistance, and technical expertise.

Confidential, Lemont, IL

System Reports Developer - Analytics Lead

Environment: Kettle, Java, Python, DB2

Responsibilities:

• System Analytics super computing lead identifying business logic from current analytics produced from Python scripts.
• Lead the architecture and development of the report migration, replicating existing graphs and charts utilizing and creating new data driven analysis with design tools from Pentaho's software suite and Tableau.
• Lead development of web-based reporting solution giving the supercomputing community and stakeholders the ability to execute data-driven business intelligence reports.
• Created an automated process for email report delivery, and static data driven reports with Java framework and Jenkins. Responsible for system and report validation identifying issues with source systems, data integration processes and warehouse data.
• Collaborated with the Business Intelligence team to provide solutions.
• Proven ability to work across multiple client teams, both internal and external to develop strategy and meet project objectives.
• Managed offshore development team actively leading technical design discussions and strategies to produce quality solutions.

Confidential, Naperville, IL

ETL Analyst/Developer

Responsibilities:

• Key contributor in technology, strategy, and data mapping discussions to refine and enhance data migration processes.
• Responsible for data migration from disparate sources to structured data warehouse in SQL Server for education domain.
• Developed data integration solutions using SSIS and Pentaho Kettle.
• Lead Engineer for data quality process implementation.
• Designed automated processes for data validation utilizing SQL Server database administration duties such as writing stored procedures, and developing SSIS packages.
• Directly responsible for python framework implementation for data validation.
• Successfully delivered validation results to ensure expedient and corrective actions are taken before data quality issues lead to costly operational impacts.
• Lead the design of Tableau dashboards and visualizations to provide insight, monitoring, and data integrity.

Confidential, Hoffman Estates, IL eCommerce Analyst

Environment: Kettle, SSIS, Omniture, SQL Server

Responsibilities:

• Determined relevant source data providing useful information through analysis.
• Developed technical best practices for data movement, data quality, data cleansing and other ETL-related activities.
• Designed and maintained SSIS packages and Pentaho (Kettle) transformations.
• Collected and compiled online data for Confidential .com and Kmart.com utilizing web analytics tool Omniture.
• Provided dashboards that gauge conversion rates of consumers, and trend analysis for ongoing marketing initiatives.
• Developed ad hoc reports that measure the performance of various initiatives.
• Examined and evaluated purpose and content of business reports to develop new, or improve existing format, use, and control.
• Reviewed reports to determine basic characteristics, such as origin and report flow, format, frequency, distribution and purpose or function of report.

Confidential, Chicago, IL

Consultant

Environment: Microstrategy, Qlikview, SQL Server

Responsibilities:

• Consultant supporting Microstrategy practice.
• Responsible for translating functional requirements from Senior Management into actionable technical specifications, as well as other project planning activities.
• Worked with multiple clients gathering requirements for plan and development of visualizations.
• Lead report migration converting Excel reports to Microstrategy platform for financial domain.
• Responsible for Dashboard data validation.