Confidential

MS Access VBA Application Architect

• Developed AR Valuation Microsoft Access Database
• Created VBA modules to Import scrubbed excel workbooks into Microsoft Access.
• Created Forms to export data into Excel and execute VBA modules to format after Export.
• Created VBA Modules to open and close record sets to display data properly in forms and reports.
• Importing massive data from multiple sources through VBA code.
• Linking Patient info to Medicare tables to export into Excel through VBA

Confidential

MS Access / SQL Server Senior Application Architect

• Provided support to Compliance team activities through Access database development and maintenance, data analytics, data reporting and system activities.
• Developed, maintained department Access databases to support production, operations, quality and reporting needs
• Worked with business to improve/automate business processes and end users to determine reporting and database needs.
• Acted as a data analyst/expert to include researching and analyzing data, preparing recommendations based on data summaries, trend analysis, etc.
• Analyzed system changes to determine and document impact to systems, business processes and associated testing needs.
• Created VBA Modules to open and close record sets in order to display data properly in forms and reports.
• Created SQL Stored Procedures In Development Environment
• Created SQL pass-through queries and set proper ODBC Connection strings.
• Created report control table links from SQL Server in order to execute proper joins and read LANId's from each computer utilizing the application.
• Collaborated with DBA in Minnesota to have all code promoted into production through approved procedures

Confidential

Database Developer II / SSRS Developer

• Created Advanced multi parameterized SSRS Reports using Business Intelligence Tools in Visual Studio 2005.
• Created Advanced SQL Server TSQL datasets for Visual Studio 2005 Business Intelligence Report Projects
• Utilized and configured Report items in Visual Studio 2005 Toolbox such as Tables, Matrix, Rectangles, Line and more.
• Analyzed Business Objectives, Report Design Examples and Report Content through Report Development specifications.
• Worked directly with Business Analysts to understand Report Specification Requirements and unexpected development additions and requests.
• Requested UDS SQL Server Backups through One Site Digital Dashboard.
• Restored SQL Server Backups through Extraction Utility.
• Attach Restored SQL Server Backup to designated server through SQL Server Management Studio.
• Attend Weekly Governance Report Preparation Meetings.
• Worked Directly under Database Developer III to establish deadlines and development goals.

Confidential

Microsoft Access Developer

Development and standardization of VBA programmed applications in Microsoft Access for Reporting and information collection.

Confidential

SQL SERVER DEVELOPER

• Redesigned existing SQL server stored procedures to increase performance.
• Optimized TSQL queries for improved performance and availability.
• Created Scheduled Jobs and Alerts using SQL Server Agent.
• Developed various drill down / drill through reports using SQL Server Reporting Service and implement securities for sensitive reports.
• Collaborate with system architects to understand business or industry requirements.
• Created Test Plan documents to define the strategy used to set the expectation and define the scope clearly.
• Created business requirements document BRD with detailed descriptions in order to clearly define start and end points of the process.

Confidential

Business operations analyst

• Mapped current Microsoft Access processes, identify disconnects and re-engineer process to gain efficiencies.
• Recognize the structures, usage and sources of SQL Server business data as well as the context in which it is utilized throughout the business.
• Meet regularly with business intelligence developers to clearly detail project statuses and expected completion dates.
• Document functional requirements in a clear concise manner that is easily understood by the business community and followed by technical support.
• Assist in coming up with ways to augment and improve current processes relative to analysis and methods within the business unit.

Confidential

SSRS Developer

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

Confidential

Application / Systems Developer

• Analyzed and Enhanced existing Microsoft Access 2007 application programmed to track the status of each invoice until mailed.
• 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.
• Designed, implemented, and delivered well-presented reports from SQL databases to upper management and customers.
• Assisted Senior Developer performing SQL Server Database Backup, Restore and Disaster Recovery procedures.
• 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.
• Maintained Database Authentication modes, Creation of user, Configuring permissions and assigning roles to users.
• Scheduled SQL Alerts and Jobs.
• Extract Transform Load ETL development using SQL Server Integration Services SSIS .
• Revised Various Crystal Reports of Formatting, Inserting Objects, Formula's, Conditional Formula's, Filtering, Database Changes, Modifying Templates, Field Layout and Design.
• Handled all help desk tickets and ensured resolution of problems and documentation.