John Dowd Email & Phone Number

Austin, Texas, United States

Austin, Texas, United States

Austin, Texas

• Responsible for leading a team of report developers and analysts to interpret business objectives and implement enterprise data driven solutions.• Successfully lead initiative to migrate old Crystal reports to SSRS 2014 platform.• Responsible for architecture and administration of Information Builders BI application and web environments including creating application based schema objects, corporate and department level dashboards and application security model.• Successfully lead companywide BI implementation and adoption of new Business Intelligence solution.• Currently there about 100 concurrent users including 25 mobile based users.• Oversaw development and deployment of over 15 corporate level dashboards and reports including an inpatient utilization dashboard that helped reduce the hospital admissions by 15% in the first 12 months across all lines of business.• Oversaw development and deployment of self-service reporting solution across five departments.• This has significantly reduced the number of service tickets which has resulted in increased productivity.• Meet regularly with business users of all levels to discuss data and reporting needs and requirements to ensure timely and efficient development of reporting solutions that are in alignment with corporate objectives and initiatives.• Responsible for developing and implementing best practice documentation for BI design and maintenance.• Established report development lifecycle to streamline and standardize report development tasks.• Chosen by Information Builders to present a case study at their annual convention outlining how FirstCare Health Plans successfully implemented their BI solution in 90 days.

Mission Hills, Ca

• Successfully lead companywide BI initiative to design new data warehouse model, develop and deploy ETL process to load data warehouse via complex SSIS packages, and implement new Microstrategy BI application.• Responsible for designing, developing, and administering Microstrategy BI application and web environments including creating schema objects and maintain user security.• Developed and deploy corporate level dashboards and reports via Microstrategy BI application.• Develop, test, and deployed advanced T-SQL logic including Stored Procedures, Views, Triggers, and Functions in SQL Server 2005 and 2008 platforms that are used in nightly data warehouse ETL process.• Responsible for developing and implementing best practice documentation for database design, maintenance, SQL scripting, and source control via Microsoft Visual Source Safe.• Introduced several T-SQL techniques to department members that helped solve unanswered business questions and improve efficiency of existing SQL scripts.• Monitored nightly SQL Server Agent jobs to ensure all production imported and data warehouse tables are populated successfully in Reporting environment.

Encino, Ca

• Primary responsibilities included developing, testing, and deploying advanced T-SQL logic including Stored Procedures, Views, Triggers, and Functions for Business Intelligence and Reporting department.• Utilized SQL Server Integration Services (SSIS) features such as Data Flow and File System extensively to automate the creation of daily, weekly, and monthly data feed reports to our internal and external end users.• Played key role in developing and deploying the company's automated Commission Tracking System via SQL Stored Procedures and SQL Server Integration Services to ensure timely and accurate commission payments to our key partners.• Automated the creation and distribution of the Sales Center Quality Measurement report.• This report allows the Executive Team and Sales Managers to monitor how the sales agents are performing.• The automation of this report has reduced the man hours from two (2) to 10 minutes.• Performed daily, weekly, and monthly maintenance to our reporting infrastructure to ensure data integrity and accuracy.• Monitored nightly SQL Server Integration Services (SSIS) jobs to ensure all production tables are imported successfully into Reporting environment.• Facilitated weekly Lead Meeting that includes Executive Team to discuss and analyze Sales Center performance.• This meeting allows team members to analyze accuracy of reporting data.• Developed corporate and department level reports utilizing advanced Microsoft Excel applications including pivot tables, parameterized queries, and Microsoft Query.• Helped transition eBusiness department from SQL Server 7 to SQL Server 2005 by ensuring all old DTS packages successfully ran using SQL Server Integration Services (SSIS).