Frank Cromer Email & Phone Number

San Antonio, Texas Area

Provide guidance and assistance to developer and business analyst team membersManage workflow and bandwidth of team members developing reports and analytics from Trucare Medical Management Application Database.Work closely between development teams and customers to maintain reporting standards.SSRS Development.SQL Reporting from Trucare Utilization Management.Performance Improvements for existing applications.

San Antonio, Texas

Creation, implementation and management of the data warehouse and applications that process business data that enables data driven decision making.BI and data analysis, Dashboard development. Development in T-SQL, SSRS and Tableau. Reporting and extracting data from the back of NextGen EMR/EHR.Design, implement, test, and debug database stored procedures and complex queries to extract, calculate or manipulate information.SQL development to include stored procedures and code to implement extract, transform, and load methodologies.Design, implement, and test the structure and schemas of the data warehouse

Remote From San Antonio, Texas

SQL Reporting from TriZetto Facets from both raw tables and datamart aggregates for mandatory CMS (Center for Medicare and Medicaid Services) reports. Utilize extensive T-SQL experience in Microsoft SQL Server 2008 to research and analyze data to determine compliance for necessary CMS regulations. Maintain SSRS reporting for provider information. Main attributes in this role are healthcare data familiarity, SQL programming, ETL and limited SSRS/SSIS.

Manage the Amisys development team responsible for all reporting and data processing.Resolve development issues in SQL Server and .Net applications.Direct resources and insure deadlines are met.Hire and train staff for all aspects of reporting and systems development.Developed SQL Server ad-hoc queries from Amisys data and supported programming staff on report quality and accuracy.

As the sole presence in the San Antonio office for the reporting and outcomes department I support enrollment and marketing efforts by research and analysis of lead and prospect data as well as current membership and applications.Create reports using SQL Server 2005 and Geocoding and Microsoft Office 2007 products.Substantiate design efforts in the initiative to convert the current Data Mart to a Data Warehouse.

Created and researched reports for the marketing department in Teradata using ANSI SQL in order to support business decision making and analytics for the marketing department.Provided data to support reconciliation of the different regional databases for data mining.Research and report demographic data for marketing campaigns.

As a Senior Developer at CFHP I successfully created and maintained 2 of the 3 major financial reporting packages required by the state of Texas for a Medicare/CHIP HMO. The aforementioned includes the check register reports from which emanated the IBNR (Incurred But Not Reported) and FSR (Financial Statistical Report). My other primary responsibility was the data extraction portion of the Medical EDI (837) Data filing which I created and maintained. I was also responsible for maintenance and changes to the 3rd major financial report, the CSR (Claims Statistical Report). Created DTS and SSIS package extracts for data submission and provided detailed databases in Access and text file extracts for auditing purposes. For these extracts I investigated data accuracy and insured quality control and data integrity. Amisys data stored in the datawarehouse was the main information source.Queried and analyzed data in Oracle 10 RDBMS to perform quality control checks of the data warehouse.

Coordinated projects throughout the life-cycle development phases, including gathering information, researching requirements, developing software, installing, and performing standard maintenance.Provided software solutions to clients to include the development of database applications in MS Access and Visual Basic 6.0. Created Web reports via ASP development from Oracle 8.Supported Visual Cactus 3.0 provider credentialing software.

Developed production software, using Visual Basic 6.0 that communicated with production machinery; and Windows software, using Visual Basic 6.0 and 5.0, ADO, and SQL Server 6.5.Maintained and updated a Human Resources VB6.0 application that was a front end for an Oracle 8.0 database.Created software applications in Baan (an ERP package), Crystal Reports, and provided user support.

A member of the Smartapp team that developed and distributed a laptop-based, point-of-sale computer system written in FPL (a proprietary scripting language), Visual Basic 5.0, and Access for agents to write new business. Our team was awarded the 1999 Computerworld Smithsonian Awards (see http://www.prnewswire.com/news-releases/aflacs-smartapp-recognized-by-the-smithsonian-74182162.html).Analyzed requirements for client/server and mainframe systems.Implemented new software packages, tested new software platforms for field force applications, and coordinated software releases.