Frank Rowan Email & Phone Number

Atlanta

Together, Amerigroup and WellPoint serve approximately 4.5 million beneficiaries of state sponsored health plans in 20 states, making us the nation’s leading provider of health care solutions for these programs.Provide Quality Measures analysis to internal clients in the form of multiple Excel-based pivot tables; determine appropriate sourcing from various Oracle and/or SQL-Server based databases and CSV text files; formulate SQL to Extract, Transform, Load (ETL) into front-end business intelligence tools using multiple Excel pivots, SharePoint sites, MS-Access applications & reports and/or geo-based mapping tools.SharePoint designer and administrator; implemented e-calender, request ticket tracking lists, employee suggestion list tracking, member outreach tracking for prenatal, new moms, EPSDT (Early and Periodic Screening, Diagnostic, and Treatment) Services requirements to help meet state quality measurement goals.

Greater Atlanta Area

• Six plus years of Crystal Report analysis, development and support of perioperative based clinical reports using Oracle databases at major hospitals; 4+ years Crystal Report work with manufacturing based cost accounting business systems using Progress database.• Worked with dispersed internal and client based project teams for report design, specifications, and estimates; coordinated development with overseas developers; deployment to client production environments.• Developed Crystal Report and Database class curriculum and materials; conducted multi-day classes in-house, at yearly client user group conventions; within virtual classroom environments as well as remote one-on-one client sessions.• Usage of PL/SQL Developer on Oracle DB to analyze, develop, modify DB tables, views, functions, to ensure optimal performance of Crystal Reports, etc.• Considered the team’s “go to” person to optimize report performance issues and implement enhancements. Developed and executed test cases to verify integrity of report results. Troubleshooting and documenting of processing errors and data integrity issues.

Quebecor World, Atlanta, Georgia (1985-2004) Solid, long term employee working for the same MIS group from 1985-2004. Company changed names due to buyouts and mergers; (formerly World Color, formerly Dittler Brothers)Sr. Programmer/Analyst – • Performed reporting needs analysis, designed, developed, tested, and deployed reports to fulfill the reporting requirements of business units. Used third-party products to perform mass changes.• Authored a Crystal Report Development Procedures and Style Guide later adopted and followed by developers to meet style standards, naming conventions, etc.• Developed several company intranet web areas providing technical support to MIS department and ERP support to corporate end-users. Results: Greater MIS team effectiveness, focal point for departmental and team project notes, calendars, guidelines, manuals, etc. Streamlined delivery of end-user guidelines, manuals and multimedia training materials.