Andrew A. Geiger

Fort Lauderdale, FL

ad200z@r.postjobfree.com

www.linkedin.com/in/andygei

Business Intelligence / SQL Developer

Hands-on experience developing meaningful and insightful business intelligence solutions and data analyses across multiple industries, including group insurance, healthcare analytics, and education. Skilled at partnering with business stakeholders to assess business needs and move projects forward by leveraging strong communication and interpersonal skills. Expert at all stages of development from planning, requirements, and design to implementation, validation testing, and technical documentation.

Technical Skills

SQL Server (SSMS, SSIS, SSRS) t-SQL PL-SQL Visual Studio Team Foundation Server (TFS)

Crystal Reports v.14 MS Office Suite (Access, Excel, Word, Outlook, Teams + VBA programming)

Power BI Power Query DAX Agile & Waterfall development Root Cause Analysis Technical Writing

Professional Experience

CONDUENT, INC., Florham Park, NJ 05 / 2022 – 07 / 2023

Senior Transformation Analyst / t-SQL Developer

Designed, developed, and maintained t-SQL code, including stored procedures and data cleanup scripts to meet predetermined deadlines.

Troubleshot and performed updates to XSLT transforms and stylesheets to meet predetermined deadlines.

THE HARTFORD FINANCIAL SERVICES GROUP, INC., Plantation, FL 01 / 2018 – 12 / 2021

AETNA INC., Plantation, FL 05 / 2017 – 12 / 2017

Associate Business Intelligence / t-SQL Developer / Crystal Report Developer

Designed, developed, and maintained reports using t-SQL and Crystal Reports in an Agile development environment to provide operational metrics on disability claims and leaves as well as billing and payments.

Designed and developed ad hoc reports using MS Excel, including pivot tables and graphic visualizations in support of customer relationship managers for multiple clients.

Conducted performance tuning of long-running reports or scripts to ensure runtimes were not more than 3 minutes.

Collaborated with business stakeholders to derive effective and efficient reporting solutions.

Troubleshot and researched report data anomalies and recommended corrective action.

PRECISION FOR MEDICINE (formerly Core Access Group), Indianapolis, IN 02 / 2014 – 05 / 2017

Healthcare Data Analyst / t-SQL Developer

Oversaw development, testing, performance, maintenance, and modification of ETL processes loading 50 Gigabytes of flat files for production of monthly client deliverables.

Provided database design, extraction, and integration, using SSMS, SSIS, Visual Studio 2012, and SQL Server 2012 & 2014 to support drug formulary, as well as payer analytics and targeting reports.

Identified and documented reporting requirements in collaboration with process stakeholders.

Provided database linking, uploading, and presentation using Excel 2013 with advanced VBA & ADO programming to import monthly client files for processing and analysis.

KAPLAN INC., Fort Lauderdale, FL 05 / 2011 – 09 / 2013

Systems Analyst / t-SQL Developer / Crystal Report Developer

Teamed with business stakeholders to document new development requirements.

Developed dtsx packages using SQL Server Integration Services (SSIS) and Visual Studio (VS 2010) to support reporting team data integration.

Developed SQL jobs, stored procedures, functions, and views as needed to meet reporting and automation requirements using SQL Server Management Studio (SSMS 2008).

Conducted regression testing of new software releases and upgrades of CampusVue student information management system.

Wrote new reports using t-SQL and Crystal Reports to provide metrics on the student information management system.

Provided performance tuning of long-running reports and scripts to minimize server resource requirements.

COMSYS IT SERVICES, Fort Lauderdale, FL 9 / 2010 – 11 / 2010

Data Analyst / Programmer for Bank of America (contract)

Collaborated with business stakeholders and users to define key performance indicators and critical data elements needed to drive managerial as well as departmental-level decision-making.

Designed, developed, and implemented Access 2007 database solution with custom-built extract, transform, and load (ETL) utility to aggregate 10 managers' production files and provide department-level reporting based on multi-field query parameters.

TEKPARTNERS, INC., Fort Lauderdale, FL 02 / 2010 – 07 / 2010

SQL Analyst for Citrix Systems, Inc. (contract)

Synthesized large sets of data (>500K records) between multiple formats - importing and exporting from and to .csv and .txt and between MS Access, Excel, and SQL Server 2008 (SSMS).

Performed t-SQL scripting in SQL Server 2008 for master data analysis, conversion, and validation.

Wrote macros (Excel 2007 VBA) for automation of data analysis and conversion processes.

Produced technical documentation describing step-by-step instructions for system configuration used in pre-conversion training of system users.

Additional Related Experience

ACADEMY DESIGN AND TECHNICAL SERVICES, INC., Fort Lauderdale, FL

IT Strategist for the City of Fort Lauderdale, Parking Services (contract)

TEKPARTNERS, INC., Fort Lauderdale, FL

Reporting Associate for Citrix Systems, Inc. (contract)

Education

Bachelor of Arts (BA), Biological / Physical Sciences

Indiana University, Kokomo, IN

Contact this candidate