Devin Mcmahon Email & Phone Number

New York, Ny, Us

Stamford, Connecticut, United States

Greater New York City Area

• Designed, wrote and implemented a financial transaction interface between Great Plains ERP and InforEAM recording Accounts Payable and General Journal transactions using PowerShell and eOne SmartConnect. Programmed complex transformation of InforEAM XML documents to meet client requirements in a tight timeframe, ensuring timely delivery of project and accurate recording of transactions. Actively participated as Project Manager to gather and document user requirements throughout the process. Currently engaged in project with client to migrate their current MOSS 2007 intranet solution to SharePoint 2013. I was the project lead for the original MOSS 2007 implementation, as detailed in my previous experience. Client has returned to engage my services to guide them and perform the actual migration to SharePoint 2013. Charged with gathering functional requirements, identifying sites, content, processes, and workflows that will be migrated to the new SharePoint farm. Designing site topology, security model, site design and overall look and feel of the new site. Will be installing and configuring the SharePoint 2013 farm, including the SQL Server, Reporting Services, as well as the SharePoint WFE, and will continue on as the remote administration manager for the SP 2013 farm following completion of the initial project.Engaged by two separate clients in the previous year to provide Subject Matter Expert guidance on utilizing SQL Server to meet customer needs. Relied upon to perform analysis of current environment, make recommendations, provide training on T-SQL querying, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Data Tools and Management Studio. At one client was solely responsible for directly driving adoption of SQL Server tools, and introducing the SQL Server stack as a key component in meeting the customer’s needs by providing real world examples, and training IT Staff.

Syracuse, New York Area

 Design, implement, and support relational and dimensional data systems.  Design and implement ETL strategies for integrating data from multiple sources into transactional systems and data warehouses.  Perform SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services) development and support.  Provide best practice guidance in all aspects of database design, structure, and usage and work with the development team on implementation.  Understand, adhere to, and help shape database development standards.  Analyze and maintain corporate data integrity, reliability, and security.  Participate in software quality assurance activities, including code reviews, and unit, system, integration, regression, and performance testing.  Participate in the application/infrastructure change control process.  Maintain the general health of all database systems (backups, tuning, and maintenance).  Identify appropriate corrective action to resolve production data issues.  Effectively communicate project issues with relevant parties and perform well within a team oriented environment.  Support IT/Business Systems vision, missions, goals and strategies.  Learn user functions, business processes, and organizational roles as required.  Guide development to understand advice and meet changing client and technology needs.  Maintain up-to-date knowledge with current and emerging database technologies.

Responsible for all business applications for this regional power generating company that owns 5,000 Megawatts of generating capacity, with 350 employees.Successfully led the upgrade of all PI systems at the Astoria Generating plant in Queens. Performed installation and / or managed the installation of all PI Historian servers. Upgrade included moving to modern VM Ware high availability platform. Coordinated down time with Plant Operators to minimize impact on operations while significantly improving the stability and scalability of this mission-critical set of interfaces to the plant control systems. Participated in the selection process for an Energy Market Data Warehouse initiative to simplify and centralize the storage of critical market and proprietary data. Wrote specifications, participated in data requirements gathering across multiple functional areas (Risk, Settlements, Commercial Operations and Finance), and managed all technical aspects of the implementation.Responsible for day-to-day stability and performance of all PI Historian servers, interface nodes, Commercial Operations dashboards and GADS reporting.Completed training for NYISO Market Orientation one week course in fall of 2009.Completed training for PI Server Administration, PI Process Book, and PI Asset Framework in 2009 / 2010.Responsible for all business and plant applications directly and through management of Application Support personnel at two locationso End user supporto Performance monitoring and upgrades / patcheso Requirements gathering and design for all modificationsWrote or participated in writing procedures for change management, user account creation, and other processes in preparation for Sarbanes-Oxley compliance.

 Sole IT specialist selected to remain on board upon acquisition of Select Energy by Hess Corporation Selected to lead the integration of data and systems related to the purchase of energy retailer  Successfully migrated over 20,000 customers  Successfully managed the integration of acquired pricing systems to the Hess environment Performed key project management functions, data and systems integrity, selection of contractors, work assignments, status reporting  Managed the work of two developers in two different geographic locations Selected as IT Team Leader for future Mergers and Acquisitions Reported directly to Program Manager

Responsible for delivering applications to support retail energy billing for more than 25,000 commercial accounts throughout the NortheastSupervised six developers, including assignment and review of work, quality assurance, and performance reviewsDesigned and implemented modifications to Microsoft Navision based billing and accounting system over a 2 year period to transform the application into an automated energy billing system supporting myriad billing types, calculations, invoice formats, and integration with Electronic Data Interchange (EDI) Drastically reduced incorrect billing of customers due to manual data entry and allowed the business to bill more customers more rapidly without adding staff.Performed and managed administration of all Windows Servers and SQL Servers including specification and recommendation of hardware and operating system requirements, disaster recovery, database backups and web (IIS) administrationManaged all operational, analytical and financial reporting requirementsAccounting experience was frequently called upon to assist in report definitions, data analysis, and assistance with reconciliation of accountsRoutinely performed business process analysis, identifying and documenting key processesDesigned and recommended business process improvements through thoughtful and careful application technological solutions

Navision Programming Lead for Retail Energy Billing Initiative

Responsible for maintenance, analysis, backups, updates for SQL Server database supporting company-wide CRM application.

Responsible for day-to-day accounting operations supervising staff of 3. Responsible for monthly financial statements, assignment of work and performance reviews

Responsible for day-to-day accounting and finance operations for this privately held professional services firm. Prepared financial statements, bookkeeping, and financial direction.