Project Manager Sql Server

Kirk M. McLeod ● *** Beverly Road ● Mount Kisco, New York 10549 ● Mobile: 914-***-**** ● Email: ********@*****.***

PROFILE/OBJECTIVE

Seasoned professional with (over 10+ years) extensive experience as an IT special project resource developing prototypes and tactical solutions for the following business functions: Anti-Money Laundering, Compliance, Change Management, PMO, and Trade Desk.

PROFESSIONAL SKILLS & ACHIEVEMENTS

• Technology achievements, expertise, and project featured in Microsoft’s TechNet Magazine.

• Successfully deployed customized software solutions for Fortune 500 applying SDLC or Agile methodologies.

• Advanced solution provider using QlikView, MS SQL Server, Sharepoint, MS Access, VBA, SQL, and T-SQL

• IT visionary who leverages existing technology infrastructure with business function initiatives for tangible results.

PROFESSIONAL EXPERIENCE

RevealationNow.net Senior Project Manager/Developer October 2011 to Present

• Controlled and managed budget for human resources and capital expenditures

• Managed a development staff of three developers and coordinated offshore development team

• Design data architecture, backup and restoration strategies

• Developed customized templates and integrated with third party vendors

• Provided monthly project reports to stakeholders

TECHNOLOGIES USED: HTML, PHP, JAVA, MYSQL, DREAMWEAVER AND FIREWORKS

Royal Bank of Scotland Reporting Solutions Architect July 2010 to August 2011

• Responsible for delivering PMO tactical and strategic solutions for senior management reporting based on governance initiatives for North America

• Prepare and maintains weekly and monthly program/project status reports for senior and executive management

• Special advisor for global Actimize implementation and deployment for North America

• Transitioned the PMO user community from spreadsheets to integrated database solutions to streamline reporting

• Provided program/project financial accounting reports for approved budgets, forecast, actuals, spend YTD, comments, risks, issues, milestones, milestone dependencies, resource allocation and status

• Trained Front-to-Back owners on technologies to improve the tracking and monitoring of deliverables based on risk mitigation and exception reports

• Created resource allocation pooling system to allocate resources to under staffed projects and projects in the ramp up phase

• Generate, update and improve project strategies and methodologies for regulatory reporting guidelines

• Assist Project Managers and Program Managers with request for ad-hoc reporting demands

• Expert with Microsoft technologies including design, development and architecture

TECHNOLOGIES USED: ACTIMIZE, MS EXCEL, MS ACCESS, MS POWERPOINT, MS SHARE POINT, MS SQL SERVER, VBA, SQL,T-SQL,QLIK VIEW, AND QUICK BASE

Credit Suisse Project Portfolio Management Developer June 2009 to July 2010

• Supported the PMO with automated solutions for program and project management financial accounting

• Designed program portfolio database to capture project initiatives and successfully submitted $740 million dollar budget

• Assisted program managers with MS Excel VBA programming support and reporting solutions

• Configured SQL Server as a program/project repository to create canned reports

• Created documentation for the PMO budget submission process and regulatory reports

• Reduced a 4 business day budget submission process to 1 business day

TECHNOLOGIES USED: MS EXCEL, MS ACCESS, MS POWERPOINT, MS SHARE POINT, MS SQL SERVER, VBA, SQL,T-SQL,XML

UBS AML Solutions Architect August 2005 to June 2009

• Supported the Compliance Department with regulatory reporting based on the Patriot Act and Bank Secrecy Laws

• Created/Designed/Developed client on boarding system for EDD capture from Broker/Dealers

• Coordinated global information technology efforts for project management deliverables

• Database provided Federal compliance for risk analysis and document research/review while opening over 20,000

accounts for the bank and six-billion in estimated assets

• Worked closely with Directors, Chief Operating Officer and Chief Compliance Officer to implement new initiatives and regulatory solutions, including ad-hoc reporting

• Directed projects and initiatives with broad scope and high impact to the business such as beneficial owner remediation and foreign bank certifications

TECHNOLOGIES USED: FORTENT, HUMMINGBIRD, MS EXCEL, MS ACCESS, MS POWERPOINT, MS SHARE POINT, MS SQL SERVER, ORACLE, VBA, SQL,T-SQL, CITRIX

Property Nexus Project Manager/Sales Engineer November 2004 to August 2005

• Created budget for approved spend, resources, and capital expenditures to kick-off new software products

• Interviewed property managers and captured requirements for software design, architecture, and development

• Designed and developed handheld application for property managers to inspect properties based on Home Owner Association CCRs using SDLC

• Designed website to synchronize handheld data and streamline the reporting process and regulatory guidelines

• Attended conferences and supported the sales team with any technical questions

TECHNOLOGIES USED: CLIENT/SERVER/HANDHELD/WEB – APPFORGE CROSSFIRE, MICROSOFT SQL SERVER, SQL, MACROMEDIA MX TOOL SUITE, XML, HTML, JAVA, WINDOWS NT/2000/XP, MS OFFICE SUITE, VBA

Bungee North America Trade Desk Developer April 2004 to October 2004

• Created function to import all P&L spreadsheet financials into MS Access database for general ledger reporting

• Produced all functional, technical and business requirement documentation

• Worked closely with traders to capture global trading commodities process and match with technology solutions

• Supported users who needed advanced spreadsheet programming and reporting requirements

• Provided PMO with project updates, risks and issues

• Documented transition strategy for systems when trading desk relocated to Switzerland

TECHNOLOGIES USED: CLIENT/SERVER/WEB – MICROSOFT SQL SERVER, SQL, MACROMEDIA MX TOOL SUITE, XML, HTML, WINDOWS NT/2000/XP, MS ACCESS, MS EXCEL, MS WORD,VBA

CUNY Lehman College Project Manager/Senior Developer January 2000 – March 2004

• Project Manager for the delivery of a student retention system and student behavioral survey

• Responsible for project plan, project scope, budget, resources and capital expenditures

• Integrated student support service offices using MS Access and Oracle technologies

• Trained support service personnel as well as faculty on software operations

• Represented college at education conferences and demo software to Department of Education representatives

TECHNOLOGIES USED: CLIENT/SERVER/HANDHELD/WEB – ORACLE 8-9I, PL-SQL, MICROSOFT SQL SERVER, SQL, WINDOWS NT/2000/XP, MS ACCESS, MS EXCEL, MS WORD, VBA

Consultant Project Manager/Solutions Architect January 1993 – December 1999

Functioned as a W2 consultant providing project management and development solutions in Change Management, Finance, Accounting, Engineering and Training throughout the Washington DC Metro area for the following corporations:

• Boeing

• Lockheed Martin

• Verizon

• The Pentagon's Joint Chief of Staff Office

• LAM Associates

TECHNOLOGIES USED: ORACLE 8-9I, PL-SQL, MICROSOFT SQL SERVER, SQL, WINDOWS NT/2000/XP, MS ACCESS, MS EXCEL, MS WORD, VBA

PROFESSIONAL AFFILIATIONS

New York Software Industry Association

Association for Competitive Technology

Microsoft Developers Network

National Eagle Scout Association

SPECIALIZED TRAINING

US Army Reserve Officer Training Corps, 1986 - 1990

Graduate of Army Basic Training, Fort Knox, Kentucky 1988

EDUCATION

Bachelor of Science, Marketing, Hampton University, 1990

EXTRACURRICULAR ACTIVITIES

Webelos Den Leader - Westchester/Putnam Council 2011, Video Production, Music Production, Reading, Archeology, and Cycling

Contact this candidate