Provide user technical support for probation caseload software (Automon). Customize technical configuration of Automon software on the front end, as well as by using SQL Server on the back end. Fulfill administrator level QA data correction requests - both front end, as well as SQL Server on the back end. Create and revise document templates that pull data from the case management software. Monthly reporting - SQL Server, Excel. Provide user support for department software and hardware. Co host and provide technical support for public meetings using WebEx.

Enhanced and improved performance and profitability of stock trading system that I developed in a previous assignment at Circle Squared. ETL additional sources of data. Wrote SQL code to perform new analytical transformations. Back tested profitability of various indicator combinations using T-SQL to optimize performance and profitability. Automated choice of stock recommendations. SQL Server.

Reduced report refresh and response time from 36 minutes down to 6 minutes or better. Achieved speed using SQL Pivot, Listagg, and Oracle Materialized Views. SQL, Oracle, TOAD, Spotfire visualization tool.Developed workflow management solution to automate document processing and improve efficiency. Microsoft Forms, Microsoft Flow, and Box.com in a MS Office 365 environment.

Conceived, developed, and managed bespoke online business operations systems from scratch for a 24-person company. Revenue and profit increased by 50%. Owner made more profit with less time/effort.Conceived, developed and managed time and materials mobile app for field employees using Google Forms and Google Sheets. Designed, developed and managed systems in Google Sheets to calculate accurate payroll hours, reimbursements, as well as time and materials for client job costing and invoicing. Created client invoices and processed client payments in Quickbooks.Co-conceived and revised employee policies and procedures. Communicated policies and procedures to employees. Counseled employees on performance and discipline. Consulted with owner on employee performance counseling and discipline, compensation analysis/administration. Created and and managed client information database.Managed marketing program. Wrote marketing copy. Analyzed marketing performance and managed adjustments. Made sales calls in person. Managed customer relationships and issues in person, by phone, and email.

Developed and supported data pipelines, merging data from disparate sources into analytical dashboards. This provided actionable insights which enabled Google's Revenue Innovation and Implementation team to improve the product pitch rates and close rates of Google’s Small to Medium Business sales organization. Wrote code using Google’s internal version of SQL, Dremel, and an in-house dashboard tool.

Designed, developed, and implemented end to end technology solution from scratch. Translated startup founder's vision for a revenue-generating stock trading system into functional reality. Sole technology resource for data sourcing; database creation and administration; ETL; design and development of T-SQL code for data transformation, analysis, and scoring. Analyzed data using Microsoft SQL Server T-SQL and Excel. Created, developed, and managed Access, Oracle and SQL Server databases. Developed predictive models using ArrowModel.

Developed two forecast models resulting in average 59% improvement in forecast accuracy. Models developed using KXEN.Developed, documented, and presented nine propensity models resulting in average small business campaign lift of 93%, leading to increased revenue growth.Created reporting, analysis, and campaign lists from multiple data sources, including C2T, BMG. Both production as well as ad hoc reporting.Developed and presented campaign performance analyses using PowerPoint, providing managers with actionable insights.Direct Marketing Campaign Support: collaborated with cross-functional marketing teams; designed, coded in highly complex undocumented, non-integrated Teradata SQL environment; executed, and reported on hundreds of email, direct mail, splash page, and ATM ad hoc campaigns. All direct marketing campaign support accomplished with manual coding in Teradata SQL.Created automated email campaigns. Developed reports in Excel using formulas, pivot tables, Vlookup.

Interviewed four to six retirement and disability claimants per day from diverse socioeconomic, racial and cultural backgrounds. Obtained, clarified, verified, interpreted, and analyzed data. Applied Social Security law and policy to make benefit entitlement decisions.

Managed daily operations of the University Advancement Database (SQL Server). Pioneered new custom reports for alumni and development staff; ensured that the database effectively captured alumni and donor information and generated accurate financial and analytical reports. Database first point of contact for Advancement staff.

Planning, prospecting, marketing, web site development, sales, and customer service. Provided clients with expert explanation, optimization, client needs analysis, risk management, planning, coordination of asset protection, and guidance on risk management programs in the areas of home, auto, life, health, college and retirement planning.

Designed, developed, coded (using Oracle PL/SQL), tested, and documented a 30 table sales/marketing/billing reporting data mart project, an initiative designed to dramatically increase availability, accuracy and efficiency of billing. Assessed business needs, gathered requirements from CFO and business users, wrote specifications, coded and coordinated/proactively managed collaborative efforts between Engineering and Business Systems. Result was an 85% increase in sales, marketing, and billing data availability, reliability, and reporting efficiency. Environment: Oracle 8i; UNIX; PL/SQL, Access, Excel.

Gathered requirements, designed, developed, tested, distributed, and supported standard and ad hoc reports via both manual PL/SQL coding and use of Brio Query. Developed curriculum, training materials and delivered both individual and group training for Brio. Sole training and support resource for 45 business users. Environment: Oracle PL/SQL; Sun UNIX; Crystal Reports.

Developed event-driven windows front-end GUI’s on Oracle and FoxPro relational databases using Oracle Forms 4.5 and FoxPro. Developed reports and managed data using FoxPro, Access, Excel, and SQL.

Managed regulatory project with a staffing level of four FTE. Wrote comprehensive annual work plans detailing technical tasks, schedules, and financial and logistical requirements. Wrote policy analysis and recommendation papers. Conducted regular meetings with external client (US EPA). • Accomplishments: Exceeded work plan performance requirements for client policy development. Increased project operating efficiency by 10% while cutting budget by 15%.