SUMMARY

Over 8 years development experience I am a multi - talented people person with drive for data centered projects leading to insight and action. I am seeking challenges to work on complex coding and development projects needing an experienced VBA, VBScript, VB6, Microsoft SQL Server or automation professional

TECHNICAL SKILLS

Languages Proficient: VBA, Visual Basic, VBScript, Microsoft SQL Server and stored procedures

Adept: ASP, Active Directory, MySQL, HTML5, CSS, XML, .Net, Python, Git, API’s and Linux

Software Database: Microsoft SQL Server, Microsoft Access, Teradata and MySQL

Platforms: Windows 10, Windows XP, Mac Sierra and Ubuntu

PROFESSIONAL EXPERIENCE

Stored Procdure SQL Development

Confidential

Responsibilities:

• Developed ETL solutions for large hospitals using SSIS and T-SQL focusing on capturing and compiling employee time records, Pyxis medication distribution data, and Epic patient data
• Optimized stored procedures reducing fifteen-hour loading times down to two hours
• Focused on SSMS environment indexing and building a strong relational database
• Increased ease of data retrievable audits and run time queries
• Responsible for ground level data sets of millions of records using SSIS that ultimately feed a Tableau series of visualizations that are hosted on WordPress websites
• Evaluated drug diversion patterns in hospitals and helped streamline employee records by creating CostPoint logins with relational login IDs assigned in the clients virtual directory

Microsoft Excel and SQL Development

Confidential

Responsibilities:

• Developed and Automated an employee utilization report using VBA and Stored Procedures
• Maintained and optimized stored procedures and Database design to free up server usage allowing multiple cube processes to be ran through SSIS packages without interfering with application users
• Designed data updates to be ran through VBA or transcribed to VBScript through various code techniques including late binding when necessary, fully qualified path names and utilization of named arguments if needed
• Integrated tabular and multidimensional cubes from different Microsoft server instances during a corporate acquisition
• Developed and implemented customized strategies to work data together for Business Insight (BI) modeling tools
• Result application allows project managers to perform data insights and not limited to insights designated for one specific corporate environment during an acquisition
• Designed and developed necessary SQL scripts with dynamic parameters to be triggered in VBA and retrieve complex record set queries from Microsoft SQL Server quickly and efficiently
• Managed and implemented a secure process to query private data housed outside of cube databases into the model straight from Microsoft SQL Server ensuring data privacy
• The implemented strategy was beyond the scope of SSAS and a solution via VBA through early binding to multiple libraries and running simultaneous processes
• Ensured sensitive data is not comprisable in an application by developing risk mitigation techniques in MSSQL by creating a common application user and setting permissions
• Utilized Dax and MDX measurement calculations to work with a single Data Model which was rooted in different data multiples and built with conflicting SSAS backend databases
• Implemented server interactions and complex module and class macros to work efficiently across multiple devices in VBA and SQL by the creation of custom XML ribbon tools

VBA Developer

Confidential

Responsibilities:

• Primary duty was a complete code rewrite for an Excel Add-In to work with a Microsoft Dynamix program called Navision
• Lead VBA developer and project design architect of a complex custom add-in rewrite including the implementation of installing the add-in across the accounting department
• Implemented and enhanced query constraint techniques to run large reports through stored procedures that ensured data integrity before staging into Microsoft Dynamics
• Developed a custom ribbon toolbar for Add-In rebuild using XML to trigger VBA procedures
• Identified primary issues of database interaction crashes and loss of functionality from other Add-Ins running at the same time and implemented a fix with the new roll out
• Managed any database connection and interaction with the application to methods currently supported by Microsoft without limiting backward compatibility for users of earlier versions of Excel

Warehouse Programmer

Confidential

Responsibilities:

• Automated custom label maker for warehouse medical supply orders reducing errors and increasing efficiency as well as optimizing warehouse square footage organization
• Developed data collection applications including a future order item picker and database logger
• An application reducing order fulfillment times and automated usage data that helps maximize open square footage for pallets of medical supplies
• Created and implemented access database logging techniques, which allows processors to save client orders into folders that are scheduled by delivery management Orders automatically
• Created an application to print files for orders to specified printers on the network utilizing VBScript and VBA filled daily and delivered the following morning

Programmer Analyst

Confidential

Responsibilities:

• VBA and SQL Report Automation developer focusing on back end server data pulls to provide to clients, vendors and staff
• Created and updated various dashboards in Excel utilizing multiple data sources
• Microsoft SQL Server stored procedure pulls to implement SharePoint reports for various departments
• Launched automation reports on a regular basis through task scheduler using VBScript
• Automating scheduler tasks using VB.NET to send emails, updates and critical warnings
• Managed the VBScript for automating intensive resource utilization applications to run FTP processes in IIS7 and Windows Time Scheduler as well as managed the VB behind Active Directory code work for the firm across 7 States
• Worked on Microsoft Server SQL scripts and stored procedures for SharePoint Reports that increased opportunities for the firm to set a record of over four hundred thousand lawsuits in a month
• Assisted in database relocation and created auditing applications to monitor data integrity across three servers used by the entire firm
• Prepared test plans and data, and user documentation for customer billing system.
• Problem-solved hardware issues with fault-tolerant hard drives.

Customer Experience Expert/ Subject Matter Expert

Confidential

Responsibilities:

• Utilized Visual Basic to build automated applications to support team Supervisors to ensure accuracy in time logging and customer interactions for each representative in the Minnetonka, MN office
• Resulting in an average time savings of 3 hours per week per supervisor as well as a standardized method policy for representative’s schedule adherence
• Interaction with large data sets in geographically segmented markets to develop trend forecasting and marketing campaigns
• Utilized SQL (Teradata) database and tableau to present monthly and quarterly updates to senior directors and developed leadership models for representatives to follow in order to maintain corporate initiatives and goals
• Implemented corporate brand enhancement tracker form in Visual Basic to identify correlated variables in positive and negative customer interactions, which resulted in an increase in customer satisfaction surveys for entire office and higher NPR score for the department
• Utilized SQL database to work closely with the Philadelphia office on identifying innovation opportunities through the evaluation of product churn by market location
• Worked with team on Xfinity Home app response loading times and logging Xfinity home data to the server in preparation for the X2 release
• Gathered and clean up data using multiple databases such as Teradata to identify consumer seasonality trends and collaborate findings across departments resulting in an increase in advertising revenue for specific locations and optimal promotional roll out times
• Utilized Xfinity Wi-Fi and Xfinity Connect for low income families as an expense minimizing alternative to cell phone plans
• Programmed detailed call back procedures for unresolved issues and customer requests and documented results on a shared workbook with the representative’s supervisor This greatly impacted corporate training procedures and had lowered the amount of follow up calls needed
• Developed and implemented a model to visualize statistical progress to improve personal and team performance Achieved by developing an excel account tracker user form and VBA macros in order to self-monitor daily progress quickly and efficiently