United States
I am a flexible, pragmatic and detail orientated ETL programmer and data analyst seeking to innovate in an enterprise environment by creating software and reporting that interacts with data by means of a clean, robust, and solid design. My skills are honed for reporting and are specialized in SQL for several database platfroms, streaming ETL toolkits, API consumption, and an emphasis on scripting and automation of OS and Microsoft Office suite.
Provide part-time contracting services for Oath to assist with migrating off legacy systems. • Converted 10 year old PHP application to aws docker. Updated to PHP7.2, updated support libraries to recent versions, reconfigured database connections to read in from environment • Use EMR Hive to replace business logic from legacy process unable to scale • Write custom python code to extract report data from Salesforce avoiding limitations • Build stop-gap python program to handle ftps transfers for a LMS solution
• Build report using new ASP.NET Core framework to replace webform. Created caching mechanism and separate out BLL into services. • Develop and enhance custom UI web interface using Telerik KendoUI and jQuery UI and for reports in ASP.NET webforms with C# backend. • Restructured a sync process from Encompass API using C# SDK to SQL Server database cutting runtime from 6+ hours to minutes. Designed for transparency in structure and output logging. • SQL Server stored procedure optimizations, often reducing length by hundred of lines and improving run-time from minutes to seconds. • Persistent and incremental improvements to underlying ERP solution database structure and data through • Participate in Agile workflow and interact with partners throughout sprints to meet deliverables • Create process documents to direct team actions towards a consistent methodology that can apply to daily tasks
• Inspected SQL Server database backend for custom ERP solution, identified data integrity issues, worked with stakeholders, and produced implementation plans for correction. • Optimize stored procedures powering reports. Up to 93% runtime improvement. • Compose SQL to extract data and produce output for business areas. Saving manual effort and improving overall quality. • Developed menu based powershell script aiding implementation plan creation, testing, and production install. • Create SSIS solution for data management problem as a contingency effort.
- Designed a self service web based reporting portal used from business leaders and analysts through call center personnel to query business metrics allowing dynamic levels of dimensional aggregation. Including extensive documentation in Visio and collaborated across multiple teams for implementation. Created a functional prototype to aid in debugging and feature requests. - Interface with numerous 3rd party vendors via their API or otherwise to collect revenue data and other metrics to support finance organization. Perform extensive summarization and rollups of Adobe Omniture traffic with failsafe recovery to drive Tableau dashboards supporting mobile product line. - Supported reporting team datamart used for holding transactional detail from numerous source systems. Created most ETL routines in Ab Initio and Autosys automation for generic use while preserving referential integrity. - Performed in place redesign of existing systems. Reworked an existing feed provided by Epsilon from raw source files resulting in $960k/yr savings and eliminated data anomalies. Replaced in-house legacy customer survey system with new integration that fit within reporting infrastructure.
Responsible for processes and documentation for supporting enterprise incentive plans for employees ranging from call center agents through management. ~$250 million paid to 8,000+ distinct employees with 99.6% accuracy. Interfaced with business leaders for creating and changing incentive processes and advised based on the current state of data points available to support the plan. Flexible and modular design practices allowed process changes to keep pace with last minute business needs to drive behavior modification.
Expanded use of automation within reporting processes and developed new reports. Recurring abuse reports identified coaching opportunities for agents and data quality checks for source systems. Monitored/troubleshot overnight data pulls and dependent report processes to ensure timely distribution. Handled calls from employees and updated TCS staffing system & maintained process documentation. Wrote scripts in Excel to increase speed and accuracy of manual overnight reports.