Decision Support Specialist
Hamilton Health Science
Total years of experience :19 years, 6 Months
Generating and distributing scheduled reports, modifying existing SSRS reports and SQL queries to comply with changing analysis and reporting requirements. Uploading verified reports to designated SharePoint Server location. Responding to Ad-hoc data requests by writing SQL queries, formatting and distributing reports as per user requirement.
Successfully develop report development and data analysis databases. Built queries in MS Access to perform daily data update from SQL Server tables into local MS Access tables. Scripted VBA code in MS Excel workbooks to extract data from Access tables into Excel worksheets. Designed Forms to perform data update operations. Drafted user manual and technical documentation.
Successfully develop report development and data analysis databases. Built queries in MS Access to perform daily data update from SQL Server tables into local MS Access tables. Scripted VBA code in MS Excel to extract data from Access tables into Excel worksheets. Designed Forms to build user friendly interface to perform data update operations. Drafted user manual and technical documentation.
Developed MS Access databases designed and developed Tables, data input Forms, Queries and Reports, designed ETL protocols to import MS Excel data in Access Tables. Optimized existing databases by modifying table structure, changed field types and sizes, re-designed Forms and Reports, wrote VBA Code to add required functionalities, removed redundant Queries and Reports.
Exclusively work on Human Resource data to develop automated report generation and data analysis tools in MS Excel. Helped Business Transformation project management team in analyze human resource supply and demand at various work locations. Developed automated variance report of head count demand and supply.
Developed project management and monitoring tools for PMO members in MS Excel. Enhanced existing tool to comply with changed requirements by modifying reports, SQL statements and VBA code. Successfully developed and implemented time management database in MS Access to control work hours of contract employees.
Successfully generated and distributed time critical scheduled daily and weekly reports. Developed and maintained Sales and Claims activity and progress reports. Developed various data analysis and reporting tools in MS Excel, automated iterating and complex report generation processes by scripting VBA code and writing complex functions. Actively participated in requirement gathering and change management assignments, developed new tools, modified or enhanced existing solutions as required.
Extracted raw data from various data sources, applied Excel functions to transform raw data into required business information for reporting and data analysis purposes. Prepared various statistical data analysis reports for corporate clients, provided ad-hoc updates and modified report templates as required. Designed data input forms and scripted VBA code to validate and store data, this helped corporate managers to save client meeting activity information in automated way
Created complex formulas and conditions to convert raw data into required business information, applied v-lookup to merge or filter information from various data set for reporting and statistics gathering purposes. Efficiently used Pivot Tables and Lists to summaries required statistics, helped decision makers to review progress and develop future plans. Scripted VBA code for Automation purpose, resulted in fast and accurate execution of routine operational tasks
Developed database in Access to fulfill reports creation and statistics generation requirements of the group. Prepared and distributed various scheduled and ad-hoc reports. Applied complex Excel functions, conditional statements and v-lookup to convert raw data in useful business information. Scripted VBA code to keep Master Quotes list updated with the changing business requirements, modified data input forms and designed document templates
Ensured timely generation of various daily reports to help Managers to verify sales, booking and dispatch details. Gathered data from competitors and generated daily Industry Sales Comparison statement and created graphs as required. Created PowerPoint presentations to help managers in explaining their ideas on various national and international forums. Collected data from all regional sales office to generate consolidated day closing booking and dispatch plan
Project Management Certificate (in progress)
RDBMS, MIS, SAD, Object Oriented Programming,
Skills learned: MS Excel, MS Access, Visual Basic, RDBMS, SQL, SQL Server