David Underwood Email & Phone Number

Terre Haute, In, Us

United States

Bloomington, Indiana, United States

Bloomington, Indiana

Formerly Cook Pharmica

Bloomington, Indiana

Formerly Cook Pharmica

Indianapolis, Indiana Area

Executed duties as contract Analyst to develop reports and analysis for Phramacy division of Myers & Stauffer. Working with team of developers and data analysts to produce reports using SSRS and Excel for pharmacy claims data. Review SSIS packages along with developing new plans to support division as needed.

Carmel, Indiana

Executed duties as contract Data/Database Analyst to develop and maintain a data masking solution for the financial/insurance group and their testing environments. Served as SME for the vendor supplied (Informatica) ILM TDM masking solution. Job functionality includes working as subject matter expert on data masking, incorporate data analysis on mainframe and open format systems into a masking solution, help lead project team that includes both onshore and offshore resources, develop and maintain mappings within masking solution and performed some technical writing for processes and procedures for new masking solution.

Indianapolis, Indiana

Execute duties as a contract data analyst for a healthcare company servicing over 20 active employers. Help maintain a working relationship with brokers (TPA/PBM) and employers to facilitate file transfers into Activate Healthcare table/database structures. Run reports on demand. Help to implement an infrastructure for a enterprise datawarehouse to be used for reporting, file imports/exports. Use data management skills to manipulate data via T-SQL.

Analyst that will support all aspects of Novious Radiology System, Invisions, PACS and document imaging. Provides education and training to NRS functions, communicates with other hospital departments, compile and maintain department statistics and perform routine data maintenance to maintain data accuracy.

Executed duties as Database Analyst within the database administration department serving over 5 remote locations (New York, New Jersey, Pennsylvania, Indiana and South Carolina). Maintain/develop 30-45 production/development Microsoft SQL Servers 2000/2005 instances. Windows Servers environments included Windows 2000 & 2003 servers in the SAN and Virtual environments. Job functionality includes monitoring and tuning all installations including updating scripts, optimizing queries, daily maintenance review, SQL optimization and custom software database installation support, 24 hour x 7 day a week support of all corporate databases, managing/developing backups and restores, transaction logs, stored procedures, performance tuning, clustering, log shipping, security and profiling/tracing. Knowledge of SSIS for data warehousing, SSRS for reporting, DTS for data extracts, transformations & loads and Management Studio/ Enterprise Manager for managing and administering the components of a MSSQL 2000/2005 installations.

Executed duties as supervisor over departmental librarians with a continued effort to monitor and maintain data administration functionality within the Information Systems department. Directed change management meetings to help determine workflow for the department and reported on potential dead locks/issues. Direct IT contact for job abends, questions on data standards/policies and any issues concerning flowcharting and/or data management. Key Achievements:Reviewed approximately 20 open system repository products to create an enterprise open system repository of which 5 were interviewed to help determine the final choice.Reviewed and amended data standards/conventions to meet growing demand of files, file structures, mainframe programs and jobs for enterprise projects.Successfully cross-trained librarian staff in each departmental duties. Successfully implemented numerous upgrades to the data administration suite of the data dictionary, program librarian and flowcharting products.

Executed duties as part of a group of 4 Data Librarians (DL) performing various data administrative tasks within the Information Systems department. Initial job function entailed working as the DL over data administration to coordinate mail delivery, document remittance and retrieval, timekeeping logs, travel expenditure usage and payroll disbursal for a staff of 100 programmers. Moved to DL over our data manger product that included responsibilities for data structure configuration, maintaining company data conventions, data movement from test into production and standards, general maintenance of the mainframe data dictionary Provided talent and support to the DL's responsible for program change control and change management processes as well as the creation/maintenance of enterprise flowcharts. Key Achievements:Created user-friendly Microsoft Word documents to replace hand written/copied program move requests.Created open file system to store/retrieve program move documentation.Created support documentation for each Data Librarian according to each functional position.Reviewed and updated data dictionary test statuses to clear out unwanted and needless data from mid 1980's to avoid deadlock issues with program compliations.

 Provided service to the Direct Brands, Inc. customer base in the Video, DVD and Music fields, such as adjustments,complaints and sales via the telephone, e-mail and written correspondence.

On-Line Course, Oop Programming

C# Programming, on-line class, 2004 JSP Programming, on-line class, 2005

Bachelors, Accounting

Associates, Computer Technology

Diploma, College Prep/Business