Built & optimized 50+ Tableau and Crystal Reports – new builds, upgrades, performance fixes. Developed data sources by writing complex SQL queries for Tableau and Crystal Reports. Optimized Tableau extracts and reports with query rewrites and parameter sniffing fixes. Run-time cut by a minimum of 85%. Wrote production-ready queries across Oracle (PL-SQL), BigQuery (SQL), MSSQL (T-SQL) - powered 100+ dashboards and reports and created scheduling in Boxi and Tableau. Partnered with labs as internal stakeholders to deliver accurate BI reporting for patient care. Trained colleagues in Tableau development for Wilson Project.

Built over 300 SSRS Reports and made them with recursive, crosstab, drill-down, drill-through, cascading parameters. Wrote stored procedures, complex joins, functions and dynamic SQL for data sources. Optimized queries – CTEs, temp tables with indexes; significantly reducing run-time. Migrated Crystal + Business Objects reports → SQL Server & paginated Business Intelligence. Translated business needs into actionable KPIs and cascading dashboards. Decommissioned 3 to 9 Crystal/ VB reports daily into T-SQL + Power BI paginated.

Built SSRS reporting for Finance and Accounting—daily stored procs in T-SQL for Finance, Accounting and Marketing and Human Resources. Translated C-suite requirements → dynamic KPIs & reports (5-10 new per week). Decommissioned legacy reports; rebuilt with minimal-click ETL (zero maintenance hand-off). Fixed 100+ ServiceNow / Kanban bugs; most resolved same-day. Google Cloud power-user: trained 8 developers on BigQuery, Looker and Data Studio. On-call DBA 1-2× / wk—quickly cleared ETL jams, cut downtime 80%. Developed data solutions for Workday HR integration decommissioning Ulti legacy. Proactively identified and resolved ETL issues impacting reporting.

Decommissioned 15–30 VB reports per week → SSRS & PowerBI paginated for Accounting, Finance, Human Resource and Marketing. Daily T-SQL – stored procedures, dynamic queries. Pushed code thru Azure, AWS, GitHub — no blockers. Ran daily stand-ups, Kanban, advised developers on report-friendly T-SQL. Advised BAs on automation upgrades.

Built SSIS ETL for 12+ data sources (PeopleSoft, Oracle, Verizon) — zero ETL failures for 22 months. Delivered SSRS paginated reports and SQL Agent schedules — no missed Finance deadlines. Cut 12-hour ETL jobs to 48 minutes with optimized queries & indexed temp tables. Wrote T-SQL, PowerShell, SSIS, batch scripts; auto-fixed anomalies before they reach reports. Took over 50-job, SSIS project with inherited failure points (incoming data: PeopleSoft, Oracle, Verizon Connect, other SQL Server applications) – fixed everything; every single load started succeeding. Designed and built proactive measures to triage data anomalies and send them in automated emails to data owners for fixes, to run on data triggers. Customized SSRS portal with HTML + JavaScript – clean, branded, easy.

Built dynamic dashboard for successful Proof of Concept that became proprietary software. Gathered requirements, drew data models, and wrote Data Dictionary. Wrote SSMS t-SQL – pulls, tables, fixes – zero anomalies post-launch. Identified and remedied database issues and made related recommendations. Developed new KPIs for specialized industry within automotive.

Developed BI reporting solutions (SSRS, Visual Studio, SSMS, Tableau) Provided analysis of requirements, advised in report development automation. Identified and remedied database issues and made related recommendations. Wrote SQL (CTEs, complex joins, parameters) on SSMS for ETL, table creation and alteration. Identified and addressed data anomalies and developed in SSIS. Data modeling and technical writing (e.g.: Data Dictionary). Gathering business requirements for product improvements.

Engineer C-level reporting insights for major automotive client. Rebuilt 6-½ year broken data pipeline and data structure in under 2 months. Managed stage, development and production data platforms and migration. Optimized ETL jobs over 90% on average; one job from 7.5 hours nightly to 3 minutes. Led technical projects and team of developers and analysts. Wrote daily complex T-SQL stored procedures. Trained team members in T-SQL data optimization and data investigation techniques.

Developed complex SSRS (SQL Server Reporting Services) reports with BIDS/ Visual Studio. Wrote complex stored procedures and queries for reporting. Gathered cross-department specs and built/adjusted complex, paginated SSRS reports. Resolved ad-hoc subscription and code glitches on the spot. Executed query plans and state – faster, cleaner T-SQL queries and stored procedures. Proof of Concept combining internal customer data and external marketing data from web traffic and market research data, to pivot the existing business model to an online business.

Potsdam, NY

Rochester, NY

Overland Park, KS *(*included: T-SQL, SQL Server Administrator, SQL Server Developer, Oracle 10g Administrator, Oracle 10g Developer, Crystal Reports Advanced)