Alan Monroe Email & Phone Number

US

Ashburn, Virginia, US

• Updated and refactored several legacy Python scripts, Vertica SQL scripts, and shell scripts on very tight deadlines for their quarterly report generation process; scripts were primarily centered around collecting data.

Dublin, OH, US

• Wrote a series of one-off C# command-line, WinForms and WPF apps to automate mundane day-to-day tasks such as formatting text, doing bulk lookups of street addresses in MelissaData, drilling down into group membership.
• Prototyped a Python application to automate bulk uploads of pipe-delimited text files to SQL Server
• Created a basic SQL Server data warehouse for monthly reporting on customer shipping volume and spend; created all database tables, indexes, etc. and wrote all ETL stored procedures and SSIS packages to pull records.
• Together with team created numerous SSRS reports from this data warehouse, such as a monthly scorecard email to customers that graphed their freight savings and spending trends; created data-driven subscriptions in.
• Bulk imported medical provider records from government and other third party sources allowing team to research medical procedure counts and other statistical data
• Eliminated manual spreadsheet conversion by writing C# utility for peers to bulk convert.xls files to pipe-delimited text files

Perrysburg, OH, US

• Refactored a series of older in-house utility apps in up-to-date and more maintainable C#; these apps would perform file cleanup based on an XML configuration file, perform unattended software installs, log drive-thru.
• Rapidly created a series of VBScript files to search server drives for potential malware based on regexes of filenames

Basking Ridge, NJ, US

• Eliminated primitive apportioning of work via spreadsheets; replaced them with a Web Forms site where end users could enter field names and data types; server would automatically create a back-end table and matching.
• Created numerous ASP.NET/VB.NET Web Forms apps over Oracle back-end, quickly incorporating new requirements as they arose; analysts used these to quickly review and update their audit items each day
• Created a series of VB.NET classes and SQL scripts within in-house Loader Shell tool for scheduled daily sampling and data collection, extracting and importing attachments from emails, calculating summary data for.
• Refactored and streamlined legacy code in ASP.NET dashboard application, moving hard-coded queries into the back-end database for ease of maintenance, refactored legacy code to perform bulk copies from Teradata to Oracle

Columbus, OH, US

• Rapidly converted 70+ existing Unix shell scripts to VBScript to facilitate a changeover from Unix to Windows servers; wrote a common VBScript utility library for logging, email notifications, executing child.
• Added additional function calls to existing VS2008 C# web service used for launching and monitoring weekend batch updates; added new columns to back-end tables, added queries to project’s data sources to incorporate.
• Overhauled and streamlined existing VS2010 C# multi-threaded Windows Forms app that used the above web service; improved app to send mid-point email notifications and more frequent and verbose and progress updates back.

• Made a series of minor corrections and additions to their in-house VB6 request tool: Updated SQL Server stored procedures to avoid pulling attachment field, changed library used to send email notifications, filtered.
• Automated logging to request tool above by writing VB.NET console application to be run in Subversion server’s post-commit hook; during each SVN commit it would scrape request numbers from commit comments and update.
• Added new forms to their existing large-scale VB.NET Windows Forms application to allow users to enter/edit compliance records that were formerly tracked manually using spreadsheets; wrote the necessary stored.
• Automated a spreadsheet report that was formerly created by hand each month; wrote VB.NET class library that programmatically created specifically-formatted Excel spreadsheets using data pulled from SQL Server; this.

New York, NY, US

• Wrote a series of new labor-saving VBScripts, and updated or re-wrote existing VBScripts; these scripts would automatically enter data into, and screen-scrape data from the bank’s mortgage solution via browser-based.
• Replaced aging browser-based repository for the above scripts with a custom Windows Forms GUI written in VB.NET; this GUI intelligently prevented users from running scripts when they had two simultaneous 3270 sessions.
• Re-wrote the scheduled jobs, Access queries, and ASP.NET pages that gathered script usage metrics for the above to correct bugs in IIS log parsing code
• Created Access database to house screen/field audit data for above scripts, allowing quick queries to see which scripts affected which fields

Columbus, Ohio, US

• Streamlined and automated a user's monthly mutual fund reporting process using Access & VBA, taking it from a two-week ordeal of manual spreadsheet copy-and-paste down to under an hour of simple GUI operation; created.
• Rebuilt an Access account tracking database from the ground up, converting from the existing flat structure to hierarchical tables that more accurately reflected their true business process, displayed with custom.
• Built an Access mail response tracking database, populating it with custom VBA that parsed the original mailing user, address and survey data from a mixed-format text file
• Wrote labor-saving VB script to create a year/month folder hierarchy for logs, eliminating need for manual folder creation
• Wrote labor-saving VB script to strip the header rows from a mainframe-generated text file, eliminating need for manually editing file in text editor

• Continually provided on-demand statistics, metrics and data dumps from Remedy backend database using custom Access queries, reports and Excel spreadsheet exports; documented infrastructure using Visio
• Handled all Remedy user account and group creation and maintenance
• Performed Remedy server moves to new hardware, and Remedy configuration changes during database server moves
• Eliminated duplicate data entry by automating ticket transfers from our local Remedy system to an off-site Remedy system
• Wrote a labor-saving Outlook VBA macro to automate bulk saving of several thousand attachments, eliminating need to manually save each attachment
• Wrote VBScript to perform bulk imports of barcode scanner records by driving the Remedy client COM object, eliminating need to hand-input each record

Merrillville, IN, US

• Sole Remedy developer/administrator for NiSourceo Built a custom Remedy integration with NiSource's Tivoli Netcool, rescuing this integration after the vendor-provided Remedy interface failed due to incompatibility.
• Continually provided on-demand statistics, metrics and data dumps from Remedy backend database using custom Access queries, reports and Excel spreadsheet exports
• Outside of NiSource, I assisted team members with customizations and break-fix work in Nissan's 6.3 Remedy environment, such as cleanups and corrections to their custom notification system
• Outside of NiSource, I assisted team members with customizations and break-fix work in Visteon's 7.x/ITSM Remedy environment, such as workflow to restrict data entry based on certain field values
• Sole Remedy and AssetCenter developer/administrator for NiSourceo Created automatic nightly export of NiSource's Remedy data to IBM's internal reporting toolo Customized Remedy to track outage dates/times on a.

Merrillville, IN, US

• Remedy Developer/Administration
• P-Synch Implementer/Administration