Provide all analytics support for the organization.Produce monthly affiliate KPI reports utilizing Tableau, Excel and Access.Develop custom reports and analysis for the Salesforce and HealthCloud databases.

Consulted on improving legacy ETL tools to enhance the performance and efficiency of the ETL process for Law Firm case management data.

Developed an Access database using VBA and SQL to automate and manage the generation of budget reports. This tool provides an 80% reduction in the time to generate and distribute budget reports. The tool also provides a data source for Tableau to create interactive dashboards that provide budget managers with intuitive budget analysis capabilities and reporting. Designed, built and managed the DGHI Database (DGHI-DB).DGHI-DB is a web based application developed using PHP, SQL, JavaScript, and HTML. Data distribution features include: Excel reports for data analysis PDF reports for management performance reviews JSON API for publishing content to the public website Data captured in the database includes: Faculty MOUs Grants managed by the Institute Student information Employee HR dataDesigned and built the Bass Connections Database (BCDB); BCDB is a web based application utilized by Bass Connections staff to manage student projects data and as a main source of content for their public website. The database also uses grant and project funding data to create ROI reports for the Bass Connections program.

Programmed repairs and enhancements for applications developed in VB 6 and VBA.Developed an Excel tool for the competitive cost analyst to automate the processing of competitive cost data; reduced data processing time by 100% and increased accuracy by 30%.Developed an Access automation tool for the electronic components cost engineer to map parts records; reduced mapping time by 80% and increased data accuracy by 40%.Published documentation for software tools to be used in continuity planning. Built two web database application servers for the Data Operations and Technical Evaluation Center. Leveraged open source technologies and the local intranet to provide business capabilities at extreme low cost. Server configurations: OS-Ubuntu Linux Server Edition, RDBMS-MySQL, Web Server-Apache, Mail Server-Postfix, Web Application Platform-PHPIntranet based web applications developed:Standard Announcement Metrics Online (SAMo), used to manage data readiness for product announcements and to capture metrics; provides executive level reporting capabilities and managerial insight for process improvement. CTO Errors Database Online (CEDo), used to identify orders with CTO errors before they go to production; delivers a significant cost savings from reduced reworks and manufacturer penalties. Cost Opportunity Database 2.0, used to disseminate cost saving opportunities for the business throughout the organization; replaces a legacy application licensed from IBM resulting in a savings of more than $840,000 per year.POR Automation Robot Online (PARo), used to process csv files to prepare them for automatic data loading using a web browser robot; provides several fold efficiency and data quality gains over manual entry.

Created Excel workbooks using VBA macros to automate data analysis procedures achieving a time savings of more than 80% over the manual processes. Developed SOPs and protocols to be used as guides for validation of deliverable data reports. Trained offshore analysts in data validation procedures. Investigated and resolved data inquiries from field salespeople and corporate business users. Facilitated a bi-weekly retail prescription data users group meeting to review: data defects, legislative impacts on data usage, prescription data changes and new requirements for business users.

Developed tools in Excel and Access enabling managers to improve forecasting, budgeting and cost control. Managed the department’s databases.Created a space auditing tool to report the facility usage of government funded research in the School of Medicine. This tool replaced a manual process and improved the accuracy of the data being reported by 80% and provided additional capabilities for ad-hoc reporting.Projects eSirius: Migration of a paper based medical research protocol management system to an electronic intranet delivered solution. Software used by investigators in comparative medical research to manage their research protocols.Conducted requirements gathering, use case development, systemrequirements translation into technical specifications, pilot user group organizing, prototyping, QA testing, vendor management, system installation, user guide creation, user training and maintenance. An immediate 20 % reduction in processing time with a projected 70% reduction for the renewal cycle, a 60% reduction in communication lag during the review process, new reporting capabilities, enhanced information sharing and governmental regulatory compliance. Electronic Time Clock: Migration from a paper based time attendance system to an electronic system utilizing MS SQL Server. System used by department managers, payroll administrators and hourly employees to collect and manage employee hours.Project Contribution: Conducted user requirements gathering, use case diagramming, pilot user group organization, QA testing, business rules development, custom report programming, vendor selection, vendor management, system installation, user guide creation, user training and maintenance. Business Impact: Eliminated falsification of employee hours, provided real-time attendance information for managers, 80% reduction in weekly payroll processing time, 40% reduction in overtime costs, facilitated attendance pays initiatives and improved employee morale.

Managed a team of fifteen employees for the Office of Information Technology achieving a 99.9% service level for technology support requests. Trained faculty and students in the use of Microsoft operating systems and Office Suite.Provided reliable, secure, and accessible computing to over six hundred computer users advocating the alignment of technology with their business objectives. Performed server administration and maintenance for the school’s servers, which included a Novell file server, a GroupWise email server, and an IIS 5 web server. Projects Teaching with Technology: Retrofitted classrooms to utilize technology resources such as the Internet and PC based educational materials. Conducted requirements gathering, site design, technology research, budget creation, scheduling, vendor management, infrastructure planning and ongoing maintenance. Business Impact: A 65% increase in the use of Internet and PC based teaching materials was achieved. Faculty curriculum plans were enhanced to include the most current and relevant developments in the study of social work.