Dan Mcginn Email & Phone Number

United States

Greater Philadelphia Area

Primary SQL developer for data suite supporting multiple custom applications used by clients worldwide, including pay data reporting. Designed complex stored procedures, views, functions, triggers on SQL Server. Developed application and database standards/architecture to help ensure the scalability, performance and maintainability of applications. Tier 3 back end support for applications in Production. Involved in daily stand up scrums with developers, QA and Agile project management team to discuss application creation, understand requirements and provide back-end functionality for the applications.Notable accomplishments:* Built complex stored procedures using Dynamic SQL to support web-based, interactive self-service reports that retrieve results based on user-defined parameters* Produced multiple procedures simultaneously for different elements of the application during development sprints, sometimes as short as one week* Re-wrote several core processes using streamlined SQL procedures to enable faster data return to the front end web application

Greater Philadelphia Area

Developed/Modified SQL scripts to migrate data from legacy systems into FileTrail record management software. Performed detailed data quality and integrity analysis across existing datasets. Defined and created stored procedures, functions, SQL queries, and other views to utilize converted client data. Mentored less experienced employees in creating SQL procedures, queries and scripts. Assisted in troubleshooting SQL issues with clients and software partners.Notable achievements:* Learned FileTrail platform quickly, enabling project team to double their pace completing data migrations from customer legacy systems, for two different clients* Brought SQL expertise to project team

Newtown Square, Pa

Created highly customized reporting and financial processing solutions for several U.S. and international clients simultaneously, working under strict project timelines and providing full documentation and end user training. Interfaced with clients’ IT departments to coordinate product rollout into their environments. Developed workflow processes using application integration and data management platform software, allowing end-to-end system integration, supporting upgrades to newer software versions. Provided superior user support to remote clients for both existing and new software functionalities, having flexibility to travel as required. Notable achievements:* Edited client web interfaces on Elite WebView platform, developing new functions with JavaScript and VBScript, enhancing customer visibility to data allowing analysis for increased performance* Built automated data transfer of records from Filemaker system into Elite Enterprise, using custom VBA, 4GL and SQL cutting their manual workload by 50%* Saved client extensive manual work hours by creating process to automatically upload costs from client flat files into Elite Enterprise using SQL, 4GL and KornShells.* Constructed custom electronic payment files for multiple clients in various formats including flat files, and XML files, conforming to NACHA standards

Wilmington, De

Managed team through project lifecycle, coordinating between business sponsors, outsourced experts and own code development, using OpenText Metastorm, and C#.net. Built test plans and ensured user acceptance, with a focus on end user satisfaction. Responsible for complete documentation of software and training cross-functional teams of users, including for Elite Enterprise platform. Provided product support for end users post-rollout, and implemented new functionality as requested, following same lifecycle process.Notable achievements:* Created multiple workflows with Metastorm to streamline client intake processes for firm, saving 50% in labor hours for accounting department* All projects were delivered on time and met business objectives, as verified by user feedback surveys

Newtown Square, Pa

Full lifecycle responsibility for client projects, from scope to code development to documentation, using 4GL, VBA, Crystal Reports, TSQL, and Elite Enterprise. Conducted client interviews for defining functionality requirements. Coordinated software solution release timing with client IT groups. Worked in both onsite and remote client environments, traveling to client sites when needed.Notable achievements:* Chosen by management to travel to customer site to gather project requirements using my ability to explain concepts to and gather information from both technical and less technical employees* Developed proforma templates with 4GL and SQL to provide greater visibility by client of attorney billable hours, working closely with client to provide highly customized solution

Team member in development and implementation for in-house accounting software solution using VB and SQL Server platforms. Completed full software documentation and created training curriculum. Notable achievements:* Trained more than 400 users in multiple locations nationwide across company’s school support division, including many users with limited technical skills.

Microsoft Certified Solutions Developer (Mcsd) Certification

Hs Diploma