Amy Lynn Patterson

• Building software products and transforming existing systems with scalable solutions to next level
• Subject matter expert in software automation (Power Automate, Zappier, Selenium, VBA), design patterns (React, Angular, Vue), and modernizing legacy websites
• Developing, testing, implementing, and maintaining web-based application systems using Visual Studio 2019, CSS3, C#, ASP.NET Framework 4.5, ASP.NET Core MVC 5.0 Design, HTML, CSS3, Bootstrap 3.0, JQuery, Kentico CMSv11 + (ASPX + Portal) and jQuery plugins
• Implementing and maintaining database objects, stored procedures, tables, and views
• Troubleshooting system issues and looking for ways to improve application
• Proficiencies in coding software applications that support complex and proprietary business models
• Contributing to twice-weekly Agile Scrum standup focused on current improvement goals
• Advocate for content peer review strategies that align design philosophies with business end goals.

• Layoff due to Covid-19), Scaffold projects with popular JavaScript frameworks using Visual Studio 2019, Angular, React, C#, ASP .NET Framework 4.5, and ASP.NET MVC 5.0 Design, HTML, CSS3, Bootstrap 3.0, Jquery and Jquery plugins
• Designed, developed, tested, and deployed application components following agile environment
• Wrote Page-level code using C#, ASP.NET MVC, Bootstrap, CSS3, JavaScript, XML VXML with Angular.JS framework along with JQuery and other JavaScript libraries
• Worked extensively in SQL Server backend database development by creating complex queries, views, functions, and stored procedures
• Designed, developed, tested, and deployed application components following agile environment
• Worked with development team upgrading SharePoint 2013 to SharePoint 2016, configuring farm environments, copying content, reconfiguring SSRS data sources upgrading individual site collections
• Modernized SharePoint 2016 adding bootstrap framework libraries, bootstrap 4 components, jQuery, HTML, CSS3, and JavaScript within company brand
• Developed, implemented, and deployed companywide Twitter Feed to SharePoint for improving communication sharing across departments through social media using SharePoint 2016, Fetch RSS feed generator, jQuery, XML, Rest API, SSIS HTML inserted into home page on page load
• Wrote ASP.NET Web Service to make use of RESTful Web services to return resource scheduling options e.g., Meeting/conference rooms post additional events into SharePoint 2016 online calendar list utilizing REST API, JQuery, Ajax, metadata overall bridging gap between two separate applications
• Wrote RESTful Web Services to return items from SharePoint 2016 list using CAML query syntax to fetch and inject DOM based Javascript to alter elements on custom pages and page layouts
• Built Web API RESTful web services using ADO.Net Entity Framework as data access layer to SQL Server
• Documented all development efforts in various locations, including Teamwork
• Lead requirements gathering among key stakeholders to fuel collaboration and cleanse project requirements
• Drove decision-making consultations to transform design solutions into successful production deployments.

• Architected, designed, and programmed applications using C#, HTML, ASP.NET MVC, ADO.NET, Entity Framework, Bootstrap, JavaScript, CSS3, SharePoint, SQL Server Script Building, Web Methods, ajax callback functions, TFS
• Developed REST web services API's supporting both XML and JSON
• Used LINQ to SQL, LINQ to Store Procedures and C# for save and retrieve data in database
• Implemented class libraries using ASP .NET, C# and SqlBulkCopy utility to copy large amount of data into SQL server database
• Read and parsed XML document to save data into SQL Server databases using C#
• Designed, developed, and deployed live updating, responsive human resource management system using Visual Studio, Git, Entity Framework, Bootstrap 3, HTML5, CSS3, C#, SQL Server, web services, Ajax, JQuery, Rest Api, TFS
• Designed, developed, and deployed streamline invoice workflow to validate invoices electronically
• Created multiple client-side scripts that send Ajax calls to remote web services.

• Developed AR Valuation MS Access Database adding functionality with VBA Modules to Import/Export financial asset data and simplify reporting for budgeting, analysis, compliance, risk management and other accounting principles
• Developed DRG MS Access Database adding functionality with VBA modules to categorize patients with respect to diagnosis, treatment and length of hospital stay
• Developed Case Mix Index MS Access Database adding functionality with VBA modules to maximize billings for each procedure and ensure each case is documented accurately for every procedure and severity level
• Developed CDI MS Access Database to document notes from patient charts to question physicians' regulatory requirements and increase focus on essential information needed for decision making and billing
• Ran report requests using NGS QPORT ACCESS through ODBC connections
• Scheduled and automated daily tasks to run batch file scripts using Advanced Task Scheduler.

• Architected, designed, and build applications using C#, ASP.NET MVC, ADO.NET, Entity Framework, Bootstrap, JavaScript, CSS, SharePoint, SQL Server Script Building, Web Methods, ajax callback functions, TFS
• Developed and enhanced Agent Oversight MS Access database adding functionality with multiple VBA Modules to analyze transactional data of potentially suspicious activity and reporting
• Write and file Suspicious Activity Reports into SQL Server while ensuring appropriate documentation of all research and analysis in accordance with applicable recordkeeping guidelines
• Worked with business to improve/automate business processes and end-users to determine reporting and database needs.

● DATA ANALYSIS - Analyzed Business Objectives, Report Design Examples and Report Content through Report Development specifications
● DATA ANALYSIS - Worked directly with Business Analysts to understand Report Specification Requirements and unexpected development additions and requests.
● GOVERNANCE - Attend Weekly Governance Report Preparation Meetings.
● SSMS - Attached Restored SQL Server Backup to designated server through SQL Server Management Studio.
● SQL BACKUP & RESTORE - Requested UDS SQL Server Backups through One Site Digital Dashboard. Restored SQL Server Backups through Extraction Utility.
● VISUAL STUDIO 2005 BIDS - Created SQL Server (TSQL) datasets for Visual Studio 2005 Business Intelligence Report Projects. Created SSRS Report Parameters and Set appropriate Report Properties.
● VISUAL STUDIO 2005 BIDS - Utilized and configured Report items in Visual Studio 2005 Toolbox such as Tables, Matrix, Rectangles, Line and more.
● TEAMWORK - Worked Directly under Database Developer III to establish deadlines and development goals.

● MS ACCESS 2010, VBA - Designed and developed MS Access Decision Engine for reporting on comprehensive portfolio bid services agreements.
● MS ACCESS 2010, VBA - Designed and developed MS Access Decision Engine to reduce expenses in four key areas, clinical and financial, HR and labor management, IT and telecom and operational support.

• Developed, implemented and optimized stored procedures and functions using T-SQL.
• Designed and implemented TSQL queries for reporting and complex solution development.
• Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
• Improved application performance by determining root cause of issues and resolving.
• Created comprehensive test plans, test scripts and use cases to support testing objectives.
• Reviewed, evaluated and identified requirements for testability.
• Reviewed test plans and procedures for adequate coverage of system requirements.

• Conducted interviews with key business users to collect information on business processes and user requirements.
• Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
• Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
• Improved business direction by prioritizing customers and implementing changes based on collected feedback.

● SQL SERVER, TSQL -Developed T-SQL stored procedures and scripts based on business requirements. Used Red Gate suite of tools to synchronize and compare database schemas.
● VISUAL STUDIO 2008 BIDS - Created interactive reports with SSRS, using report parameters, query parameters, Filters and Expressions.
● VISUAL STUDIO 2008 BIDS - Created Parameterized reports in SSRS 2008.
● SQL SERVER, TSQL -Create scripts, save to vault for development team to move database changes to Production environment.
● SCRUM - Worked in an environment incorporating agile methodology (Scrum).

● MS ACCESS 2010 - Analyzed and Enhanced existing Microsoft Access 2007 application programmed to track the status of each invoice until mailed.
● MS ACCESS 2010, Batch SCRIPTS - Improved the performance of the current Microsoft Access application creating batch file scripts to copy the current Microsoft Access build to each user's desktop.
● UNIX - Moving, renaming, and copying files
● UNIX - Call Shell Commands
● UNIX - Direct the output of one command to the input of another (Pipe, Tab, comma).
● SQL SERVER 2008 R2, TSQL,MS ACCESS 2010, VBA - Designed, implemented, and delivered well-presented reports from SQL databases to upper management and customers.
● SQL SERVER MAINTENANCE - Assisted Senior Developer performing SQL Server Database Backup, Restore and Disaster Recovery procedures.
● SQL SERVER AGENT - Scheduled Full, Differential and Transactional log backups for the user defined and system databases using the Database Maintenance Plan Wizard, by running backup and restore commands.
● SQL SERVER ADMINISTRATION -Maintained Database Authentication modes, Creation of user, Configuring permissions and assigning roles to users.
● SQL Server Agent - Scheduled SQL Alerts and Jobs.
● SSIS - Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
● CRYSTAL REPORTS - Revised Various Crystal Reports of Formatting, Inserting Objects, Formula's, Conditional Formula's, Filtering, Database Changes, Modifying Templates, Field Layout and Design.
● HELP DESK - Handled all help desk tickets and ensured resolution of problems and documentation.

● MS ACCESS 2007 - Analyzed and Enhanced existing Microsoft Access 2007 application programmed to track the status of each invoice until mailed.
● UNIX - Moving, renaming, and copying files
● UNIX - Call Shell Commands
● TECHNICAL SUPPORT - Perform Face to Face technical support regarding upgraded Microsoft Access Database applications in surgical units.
● SOFTWARE IMPLEMENTATION - Assisted in the software implementation and rollout of Windows 7 and Office 2010 throughout the hospital.
● MS ACCESS 2007 - Review Microsoft Access databases.
● MS ACCESS 2007 - Validate 2010 compatibility.

● SITE HANDLER - Developed Forms for wireless companies to Track and report date changes into Site Handler.
● TEAMWORK - Attend project meetings and calls.

● MS ACCESS 2010, VBA - Created, VBA programmed, managed and maintained multiple Microsoft Access Tracking databases. Created VBA modules to clean data in excel workbooks exported from various applications.
● MS ACCESS 2010, VBA, ORACLE - Created ODBC connections in order to link tables from an Oracle environment into Microsoft Access.
● MS ACCESS 2010, VBA,MS EXCEL - Exported Excel Objects with real time data from Microsoft Access into several designated shared folders.
● MS ACCESS 2010, VBA,MS EXCEL -Created Ad Hoc Reports for upper management in Pilot Freight Services.
● COMMUNICATION - Proactively communicate with Vendors, freight carriers, DC staff, and corporate personnel to ensure merchandise was shipped on specified shipping dates.
● LOGISTICS - Communicated with designated transportation companies to preclude delays in transit.
● COMMUNICATION - Identified and escalated problems to the appropriate vendor and buyer for resolution prior to event receiving deadlines.