Simon Gallagher Email & Phone Number

Indianapolis, US

Looking at all things data related for an established Fintech company providing account opening services

San Francisco, California, US

San Francisco, California, US

San Francisco, California, US

Menlo Park, CA, US

• Responsible for the day-to-day operation of enterprise systems that encompass: database servers, Linux based Hadoop cluster, web servers, portals using SharePoint 2010, vBulletin and Confluence, Integration and ETL.
• F5 LTM administrator. The load balancer fronted not just our web and SharePoint servers, but was also used during database migrations as well. I have completed the Administering BIG-IP v11 course, and am comfortable.
• Responsible for standardizing security, maintenance, and migrations for the corporate SQL Servers. Consolidated SQL 2000, 2008, 2008R2 servers into SQL 2014 and 2016 availability group clusters; for development, test.
• MS Dynamics AX system administration, installation, and performance analysis and tuning.
• Implemented the Corporate level AWS account, and installed GitLab to a Linux based server.
• Part of a pilot looking to move and re-implement our on-prem data lake to AWS using S3, EMR and Redshift.

Indianapolis, Indiana, US

• Supported a team of 8 developers in the complete rewriting of a legacy VB4 and Access Retail Inventory Control System (RICS) system to an Enterprise level.Net architecture using SQL Server 2008. I was responsible for.
• Wrote the data feed for the WPF/WCF desktop application that runs as the Point-of-Sale (POS) and which can operate for up to two weeks in an offline mode before resynchronizing.
• Wrote a C# WinForm Data Migrator to take legacy data from Access and transform and load to the new schema.
• Wrote a C# command line Data Extractor that is controlled via XML options, and can extract data from the Enterprise database or a FileStream based file store into a number of formats, and transmit files via sFTP, FTPS.
• Responsible for over 18 large (500GB+) database servers spread across multiple data centers, including backup and disaster recovery procedures.
• On-going performance tuning of all database activities. Including rewriting import and batch processing using Service Broker Queues.

Indianapolis, IN, US

• Provided database design and coding for taking an AS400 based credit card processing system to a.NET (C#) and SQL Server platform. The system handled over 7½ million authorizations in 2013, for $417 million worth of.
• Audit Support for PCI and SAS70 compliance.
• Worked with Client Support with Fraud investigation and analysis, which led to the development of an authorization filtering system that could be controlled via the web based Back Office.
• Wrote an Automation subsystem and C# WinForm based GUI manager to handle the various daily, weekly, and monthly batch processes and reporting requirements. Using the Crystal Reports API reports are run in parallel with.
• Using Google maps I added to the OneBridge back office web site, the ability to map a card holder’s activity and home address onto a geographical map to aid in fraud investigation.

• Liaison between Operations group and Development group. Implemented policies and procedures for SQL development.
• I was available 24/7 on call as part of the system administration team and was an integral part of the data center move from Allisonville Pointe to Park 100. Total system downtime was less than 4 hours.
• I was responsible for the database side of production code releases, patching and maintenance of the database servers.
• Created and taught introduction to SQL classes to all departments at VIFI. This provided the support group with the ability to perform basic data investigation before involving development or myself.

• Working from a home office I continued support and additional development work for a Fortune 500 company's applications. I transitioned responsibility of these to corporate developers via one to one training and.
• For International Medical Group (IMG) I worked on an existing PowerBuilder and SQL Server 7.0 application, and was responsible for the conversion to SQL Server 2000.
• For Wheaton World Wide Moving I provided SQL Server administration support, performance tuning of an in house system, and helped to recover a crashed SQL Server hosting line of business data over an extended 48 hour.

• For a Fortune 500 company I was the lead consultant for a team of 4 developers that used PowerBuilder and SQL Server to create a number of Enterprise level applications to support corporate and factory floor.
• I passed my MCSE NT4.0 and Train the Trainer certifications to become the NewMedia SQL Server trainer and go to SQL troubleshooter. I taught a number of Database Implementation, System Administration, Accelerated.
• I worked at a variety of clients (USA Gymnastics, Lilly, Rolls Royce, etc.) with SQL Server troubleshooting, performance tuning, and administration recommendations.
• As Technical Manager I provided support for the staff of developers, providing technical information and contacts, analysis and design of systems, and continuing education through the use of internal speakers and.

• For Brown & Williamson was part of a small team that prototyped a proof of concept Customer Support system using SQL Server 4.2 and Gupta SQL Windows.
• For GTE I was the lead developer on a Property Tax Reporting System using PowerBuilder and Informix 6.2 running on an HP mini running BSD Unix.
• Provided in-house support for the office and development SQL Servers. Also led analysis and prototyping of in-house systems for marketing, technical services, and management groups to streamline workflows.