Robbin Bowman, Mcade Email & Phone Number

• Contribute to the success of a premier U.S Healthcare Organization as part of the DBA, Application Health and Operational Support teams of Aetna subsidiary American Health Holding• Implement large-scale SQL Server upgrades and database migrations • Create, maintain, and troubleshoot large-scale SSIS ETL/ELT structures• configure OS for migration; perform I/O stress tests • Implement and maintain database replication and mirroring • Create configure, and maintain SQL Server Agent Jobs, notifications, and automated tasks• Implement Identity and Access Management (IAM)• Create and maintain SQL Linked Servers • Create, maintain, and troubleshoot SSAS solutions as needed• Configure and maintain SQL Server mail agents and profiles• Create and support SSRS reports and automated reporting systems• Create and implement database enhancements (table structures, stored procedures, functions, views)• Provide Operational support for web-based Medical Management applications, File Delivery hubs, and document systems via monitoring, troubleshooting, change management, and quality assurance, etc.• Provide excellent customer service to internal and external customers

• Contributed to the success of a multi-state healthcare Quality Innovation Network-Quality Improvement Organization (QIN-QIO), supporting the Ohio Department of Medicare/Medicaid as a client• Provided ongoing technical support and training for the data warehouse/full BI Stack solution deployed at an HSAG client site in Columbus Ohio• Created, deployed, and maintained databases, stored procedures, SQL jobs and SSIS-based ETL projects • Deployed and maintained dynamic reports/dashboards built on SSRS and SSAS platform• Implemented and maintained SQL Server “Always-On” replicas • Monitored nightly jobs, resolving technical issues, and deploying system-critical fixes as needed• Worked closely with business units to accurately interpret reporting and ad-hoc requirements• Performed tasks in accordance with CMS (Centers for Medicare and Medicaid Services) standards to routinely sync warehouse data with existing data in the organization’s Salesforce cloud• Work closely with management to create Executive-level dashboards for C-level meetings

• Provided operational support to Partners for Kids (PFK) - a Physicians’ network sponsored by Nationwide Children’s Hospital • Created, implemented, and maintained ETL and electronic data transfer processes (sFTP, SSH)• Worked with business partners, external health plans and third-party vendors to define requirements, data sources and software reviews to fulfill business needs• Administered large-volume analytical and reporting databases and claims repositories • Performed quality audits on incoming and outgoing files and reports, including data profiling, cleansing, and validation in accordance with business rules • Provided user support for querying tools and assisted with query performance optimization

• Supported the Motorists Data Warehouse as a Business Intelligence/Data Management professional • Created and maintained SQL databases, SSIS ETL structures, and SSRS report systems • Performed routine SQL Server DBA tasks • Shared responsibility for dimensional modeling of the Enterprise warehouse and mart databases• Deployed and maintained SSAS cubes, SQL Agent jobs and file transfer systems• Shared responsibility for monitoring, troubleshooting and performance optimization• Worked closely with business units to accurately interpret reporting and ad-hoc requirements• Performed production deployments • Worked closely with Motorists Computer Operators to coordinate legacy job scheduling

• Served as a BI Developer responsible for support of the ECOT data warehouse, oversight of daily operations and maintenance, and production support• Created and maintained SQL Server databases for the warehouse• Created, deployed, and maintained warehouse reporting systems built on Microsoft SSRS• Created dimensional data models representative of both educational and business entities functional areas: marketing, student demographics, enrollment/retention, and state testing• Created high-level data flow designs and dictionaries for the warehouse reporting layer as interpreted from business requirements and end user stories• Created, deployed, and maintained SSIS ETL/ELT pipelines and SSAS cubes• Created and maintained nightly SQL Agent jobs and routine DBA tasks• Created and maintained technical specifications for reports and ETL processes• Performed mission-critical fixes• Performed code reviews to identify potential improvements• Performed quality assurance and system testing• Shared 24x7 on-call systems support responsibilities with other team members

Provided IT consulting services to corporations in various locations - from the Midwest to the West Coast. Clients include Accenture, CitiGroup, Cardinal Health and Nationwide Insurance.• SQL Server, Teradata, DB2, MySQL, Netezza database development• Query optimization• SSIS, SSRS, SSAS development• Report Automation• Identity and Access Management (IAM)• SQL Server database administration• Workflow design and documentation• Shared 24x7 on-call systems support responsibilities• Use of Microsoft Powershell, VBA, Access, windows scripting• Quality assurance

Chicago, Illinois, United States

• Developed financial software solutions for a globally renowned Management Consulting firm in the following roles: SQL Server Developer, Junior Database Administrator, Front-End Web Developer, Decision-Support Report Developer• Created, coded, tested, and maintained applications through each SDLC using Microsoft ASP.NET, IIS, ETL, SQL Server, Visual Basic, JavaScript, and HTML• Shared responsibility for collecting sensitive financial data to be reported to the SEC• Collaborated with other developers to deploy front-end application security • Coordinated with Database Administrators, System Administrators and Production Support on database back-up plans, data migrations and application production releases• Created and maintained SQL Server databases, tables, stored procedures, and scripts• Wrote documentation and detailed application designs• Created and executed test plans and scripts

• Successfully provided Financial Application support to a state retirement and investment system, turning an internship into a full-time, permanent career• Supported and maintained applications to meet customer requirements using Pacbase, an early CASE software tool that used pseudo-code to generated COBOL code• Contributed as a business analyst and product liaison • Presented detailed designs and briefings to senior management• Created and maintained project documentation