William Herman Email & Phone Number

Cincinnati, Ohio, Us

• Responsible for automating the load, conversion, transformation, and exception handling required for data migration from the current application and multiple external interfaces into a new leading-edge medical management enterprise system• Design, develop, implement and test new Extract, Transform, Load (ETL) programs using SQL Server 2008 R2+, and SQL Server Integration Services (SSIS)• Analyze source data and create a mapping and transformation plan for data migration• Develop and deploy efficient and optimized SSIS packages to complete data mapping and migration• Interact with the business analysts and development team to establish file formats, required data elements, setup transmission, and delivery of files• Create mapping documentation detailing fields and transformations from source and target systems• Drive and uphold high engineering standards, bringing consistency to the codebases encountered and ensuring software is adequately reviewed, tested, and integrated• Write high-quality code, designed to be easily understood by others and maintained in the future• Work collaboratively with design & development teams daily

Tallahassee, Florida, Us

• Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities• Gather requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users• Maintain and improve existing ETL processes• Ensure that the data architecture is scalable and maintainable• Work with the business in designing and delivering correct, high quality data• Extract, Transform and Load data from ther Centers for Medicare and Medicaid into Alpha II's proprietary Medical Billing databases.• Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions• Perform Database Administrator functions of backup and restore of databases, creating tables, modifying tables, creating indexes and triggers, etc.• Prepare documentation for further reference

Bangor, Michigan, Us

• Building reporting environments (Cognos and SSRS) to pull data from Electronic Health Records for government and regulatory reports.• Installing, configuring and monitoring MS SQL Database Servers.• Migrating databases from older versions of MS SQL Server to newer versions.• Creating and fine tuning SQL Server Integration Services (SSIS) packages for ETL and data migration.• Developing SQL stored procedures and queries to perform data extraction and cleansing.• Working closely with the client, examining existing business models and flows of data, discussing findings with the client, and designing appropriate improved IT (database and reporting) solutions. • Participating in Lean activities to find and reduce waste throughout the organization

• Installing, configuring and monitoring MS SQL Database Servers.• Migrating databases from older versions of MS SQL Server to newer versions.• Working with end users of applications to identify needs and communicating those needs to the technical team.• Installing updates/fixes to applications.• Develop SQL stored procedures and queries to perform data extraction.• Develop and maintain reports using SQL Server Reporting Services (SSRS).• Create and fine tune SQL Server Integration Services (SSIS) packages for ETL and data migration.• Provide technical support to other members of the team.

• Installing, configuring and monitoring MS SQL Database Servers.• Migrating databases from older versions of MS SQL Server to newer versions.• Working with end users of applications to identify needs and communicating those needs to the technical team.• Installing updates/fixes to applications.• Develop SQL stored procedures and queries to perform data extraction.• Develop and maintain reports using SQL Server Reporting Services (SSRS).• Create and fine tune SQL Server Integration Services (SSIS) packages for ETL and data migration.• Provide technical support to other members of the team.• Analyze data in preparation for upload of data to FDA GUDID database.• Develop SQL stored procedures and queries to perform data cleansing.• Develop and maintain reports using MS Access.• Provide technical support to other members of the team.• Save weeks of work by training less experienced members of the team on how to use MS Access to compare MS Excel files and perform queries and joins.• Develop SQL stored procedures.• Develop and maintain reports using SQL Server Reporting Services.• Develop jobs in SQL Server Integration Services.• Work closely with client, examine existing business models and flows of data, discuss findings with the client, and design appropriate improved IT (database and reporting) solutions. • Act as liaison between client and developers.• Create training materials; train and support software application users.• Provide support for troubleshooting information systems.

Raynham, Ma, Us

• Analyze data in preparation for upload of data to FDA GUDID database.• Develop SQL stored procedures and queries to perform data cleansing.• Develop and maintain reports using MS Access.• Provide technical support to other members of the team.• Save months of work by training less experienced members of the team on how to use MS Access to compare MS Excel files and perform queries and joins.

Oak Brook, Il, Us

• Develop SQL stored procedures.• Develop and maintain reports using SQL Server Reporting Services.• Develop jobs in SQL Server Integration Services.• Work closely with client, examine existing business models and flows of data, discuss findings with the client, and design appropriate improved IT (database and reporting) solutions. • Act as liaison between client and developers.• Create training materials; train and support software application users.• Provide support for troubleshooting information systems.

Notre Dame, In, Us

• Provide comprehensive IT computing support to users of the IT system. • Project Manager for software updates and application integration with Enterprise Systems• Interface with customer to understand, define and translate business requirements into functional specifications. • Facilitate brainstorming meetings, interviews and workshops to gather business requirements for application development and software update projects.• Serve as a liaison between the customer and the technical support staff.• Maintain a consultative partnership with customers/business units to analyze application needs and develop reporting and database solutions. • Develop and maintain application interfaces and websites using Oracle PL/SQL, SQL Server Integration Services, etc.• Awarded Notre Dame’s Project Management Certificate

• Provide comprehensive IT computing support to users of the IT system. • Maintain windows servers, Internet servers, mail servers and all desktop PCs at a multi-location operation. • Work closely with all levels of the organization to analyze application needs and develop reporting solutions. • Manage and provide support of web applications. • Develop and maintain websites using ASP.NET, PHP, HTML, and CSS. - www.RVCapitalWholesalers.com - www.GreatLakesRVCenter.com - www.PrecisionMarketingCompany.com - www.WeFindRVDealers.com - www.RVDealFinder.com - www.RVCapitalServiceCenter.com

Chicago, Illinois, Us

Spearheaded several Business Intelligence projects that exposed decision makers to interactive reports, scorecards, and ad hoc queries enabling them to make more intelligent and timely decisions saving the firm considerable expense and improving productivity and profitability of client service personnel. • Gather data from multiple internal sources to report to various departments throughout the accounting firm. • Work closely with all levels of the organization to analyze application needs and develop reporting solutions. • Manage and provide support of Cognos applications. • Act as liaison between end users, management, operations staff and IT departments. • Create training materials and train and support software application users. • Provide technical and analytical assistance to non-technical application users.

• Gather data from multiple internal sources to report to the Department of Education all manner of personnel and student data. • Interact daily with all levels of the organization to analyze needs and develop reporting solutions. • Provide support for troubleshooting information systems, including Cognos and Crystal reporting systems. • Develop Access database applications for use by internal HR and Finance departments. • Train and support computer/software users. • Provide technical and analytical assistance to non-technical application users.

American Fork, Ut, Us

• Project Management. • Analyze and diagram workflows and business systems. • Interface with customer to understand, define and translate business requirements into functional specifications. • Facilitate brainstorming meetings, interviews and workshops to gather business requirements for application development and software update projects.

• Project Management. • Analyze and diagram workflows and business systems. • Design/Develop Database Driven Web Sites. • Create detailed and accurate project descriptions, estimates, functional and technical specifications, schedules, time lines and written status reports throughout the development process. • Create documentation and user’s manuals. • Train and Support Computer/Software Users. • Act as liaison between management, operations staff and IT department. • Write and execute SQL scripts and stored procedures to troubleshoot and test applications. • Create and maintain permanent and ad hoc reports using report writer tools. • Create training materials and train users in classroom setting as well as one on one. • Provide ongoing software support for new applications/systems. • Provide technical and analytical assistance to non-technical application users. • Analyze, identify and troubleshoot problems within systems and interfaces between computer applications. • Systems and Applications Analysis • End User Software Support

South Bend, In, Us

• Analyze and diagram current workflow and business systems of various departments. • Develop new workflow around new system installations. • Act as liaison between management, operations staff and IT departments. • Code programming changes for customized programs and report extracts. • Develop and implement testing plan of new applications/systems. • Create and maintain permanent and ad hoc reports using report writer tools. • Create training materials and train users in classroom setting as well as one on one. • Provide ongoing software support for new applications/systems. • Provide technical and analytical assistance to non-technical application users. • Analyze, identify and troubleshoot problems within systems and interfaces between computer applications.

• Increase commercial and residential mortgage loan volume 300% each month as compared to the previous year. • Provide ongoing software support for new applications. • Provide technical and analytical assistance to non-technical application users.

Us

• Build commercial lending department from the ground up. • Create cost savings of 50 to 75% on varied projects through analytical skills and bottom-line focus. • Analyze, identify and troubleshoot problems within systems and interfaces between computer applications. • Evaluate new lending documentation software applications and make purchase recommendation to directors. • Train users on new computer systems and applications, write users manuals and create ad-hoc reports. • Provide technical and analytical assistance to non-technical application users.

Washington, Dc, Us

Served as a junior officer aboard the USS Seattle (AOE 3)• Outgoing and energetic leader of top-ranked division on the ship (managed 60 sailors and Petty Officers). • Analyze, design and implement new satellite communication system aboard ship. • Write user manual for communication system. • Analyze, identify and troubleshoot problems within systems and interfaces between applications.

Bs, Mis

Education record