Engineer Software

Mark Lang

* **** **** * Wayland, MA ***** * 508-***-**** * ****.******@*****.***

PROFILE

Database engineer with application programming, DBA, and project leadership experience who also has excellent communication skills.

Expert in SQL and database design. Proficient with MS SQL Server and Access databases. Created hundreds of tables, views, stored procedures, and user functions.

Multiple years of experience as application software engineer using C# and VBA.

Microsoft Certified Professional – ASP.Net 3.5, C# (2011).

Successfully managed multi-million dollar projects for a large state agency and administered the whole technical operation of a small medical document storage company.

COMPUTER SOFTWARE SKILLS

LANGUAGES: Transact/SQL(T-SQL), C#, VBA, HTML, Javascript, CSS, VBScript

SERVER PAGES: ASP.Net, Classic ASP

DATABASES: MS SQL Server 2005 - 2016, Access, Sybase ASE 11.5, Sybase ASAnywhere 6

MISCELLANEOUS: SSRS, DTS, SSIS, Powershell, Crystal Reports, Jira, Great Plains, PowerFAIDS, Millennium, EasyLobby, CAMS, Moodlerooms, AsureID, PrintLimit Pro, Self-Service Reset Password Manager (SSRPM), ServiceDesk, SugarCRM, PeopleSoft HR 7.5

EXPERIENCE

2019(Oct.) – 2020 (Dec.) Synectic Software Solutions, Inc. Software Engineer

Supports an inventory application for vending companies coded in C# on an ASP.Net – MS SQL database platform.

Created and modified reports using T-SQL and SSRS.

Imported price, product, and inventory updates from Excel sheets sent by customers.

Coded procedure to update tax rates.

Debugged forms and reports and Improved efficiency of some stored procedures that were timing out.

2019 (April – Sept.) Vision Government Solutions, Inc. Data Conversion Specialist

Converted existing customers’ Oracle databases (Oracle 10 or 11) to MS SQL Server 2012 for upgrades to Vision’s latest version of their CAMA (Computer Aided Mass Appraisal) application for real estate assessments.

Helped team of 7 increase production from 2 CAMA upgrades per month to 15 per month. Personally did approximately 40 – 50% of those despite significant delays in receiving pdfs required to finish the upgrades.

Coded scripts for data exports from the CAMA application to other vendor’s systems. Set up these data exports with various table entries to incorporate them into the Vision application so that they could be run by the customer.

Coded scripts to fix incorrect data due to conversion errors, user entry, or application bugs.

2014 (Aug.) – 2019 (March) Veterans Administration (via LinTech Global) SQL Engineer

Created an application in MS Access for the Quality Management Office of the whole New England region (8 major health centers) to track findings and related corrective actions by regulatory bodies such as the Joint Commission and the Office of Inspector General. Converted backend to SQL Server 2012. Coded more than 25 SSRS reports.

Coded dozens of SSRS reports for the whole New England region (8 major health centers), including reports on wait times, opioid dispensations, drug tests, antibiotic dispensations, and patient reminder lists for mammography and pap smear tests.

Coded all the reports for MyHealthE Vet program in SSRS.

Created dozens of database tables, views and stored procedures in SQL Server 2012.

EXPERIENCE – continued

Coded Excel sheet-based functions in VBA for bed counts and call center tracking.

2011 (April) – 2014 (June) Pine Manor College Application Eng. & DBA

Administered and maintained all the software packages, applications and SQL Server databases for the college.

Coded many stored procedures, user functions, and scripts in T-SQL.

Coded SSRS and Crystal reports for multiple departments.

Coded T-SQL scripts to create Powershell commands to add Active Directory accounts, MS Exchange mailboxes.

Created ETL scripts in T-SQL to provision/de-provision users in CAMS (Student Information System), AsureID, Moodlerooms, and EasyLobby systems from various inputs (including Active Directory).

Performed network admin and desktop support tasks (Active Directory updates, software installs) as needed.

Participated in a team using the Agile methodology.

2010 (June – Oct.) Emerge Software Engineer

Revised Access application tables, forms, reports and queries for non-profit dealing with domestic abuse.

2007 (July) - 2009 (Jan.) Tri Wire Engineering Solutions Software Engineer (contractor)

Created new forms, data object and collection classes using C# for a .Net application.

Helped design and develop company's intranet. Coded ASP.Net web pages with C#.

Coded major revisions to firm's Inventory and Purchasing systems.

Created new reports using MS SSRS and Crystal Reports 2008.

Coded numerous MS SQL Server stored procedures using T-SQL.

Added new database tables for new functionality (recording fleet vehicle accident info, payroll deductions).

Helped convert the main application to .Net 2.0 and ClickOnce deployment.

2007 (Jan. - May) Citizens Bank (Warwick, RI) Software Engineer (contractor)

Modified 35 ASP.Net and ASP pages of Charter One Bank's website for home loan applications using C#, Javascript, VBscript, XML.

Created and modified MS SQL Server stored procedures using T-SQL.

2006 (Sept. - Oct.) Citizens Bank (Cranston, RI) Software Engineer (contractor)

Installed upgrade of Moody’s RiskAnalyst software application, changed IIS configuration.

Coded and ran SQL scripts on MS SQL Server 2000.

Created DTS packages to load database tables.

Created DOS .bat files which did the production system upgrade.

2005 – 2006 CertaPro Painters (non-IT work) Franchise Business Owner-Operator

2000 - 2004 Medifile, Inc. Chief Software Engineer

Managed all technical matters for small, electronic medical records company.

Programmed all of company’s application requirements in Powerbuilder 7 and VBA.

Enhanced firm’s website to give clients access to standard forms (pdf’s).

Researched and made all hardware and software purchases.

Performed ETL tasks with customer data for both the Sybase ASA and Access 2000 databases.

Used PowerDesigner to update data models and generate DDL scripts.

Administered the Sybase ASA and Access 2000 databases.

Managed the LAN on a Windows NT server.

Installed and supported desktop PCs, laptops, printers, scanners, and modems.

EDUCATION

M.S. Management Engineering Rensselaer Polytechnic Institute, Troy, NY

(concentration in Healthcare Systems)

B.S. Management Rensselaer Polytechnic Institute, Troy, NY

Certificate in Web Technologies Worcester Polytechnic Institute, Worcester, MA

Contact this candidate