Project Manager Sales

Patrick Glennon – 508-***-**** – *******.*******@*******.***

TECHNICAL

SUMMARY:

• I am an information technology professional with experience in all areas of the SDLC process across

several industries and disciplines. With a track record of demonstrating vision, initiative, and creativity in

approaching technical challenges

EXPERIENCE:

09/12 – 3-13 Bank of America

Data Analyst – SQL Developer

• Worked with the legacy asset group to provide independent data sourcing for the consumer mortgage

group.

• Lead requirement gathering and functional requirement meetings.

• Created Data Mapping Documents

• Performed Peer review on sql logic

• Wrote extraction logic in sql 2008.

09/11 – 09/12 Brown University

Lead Data Analyst

• I assisted in the design and execution of the data conversion piece of the Workday HCM

implementation.

• Gather Requirements and transferred to data mapping documents.

• Designed, Created and Loaded an sql staging database

• Wrote and tested SSIS packages to be used during the extraction and transformation of legacy data.

• Worked with Workday consultants to successfully load the data in to the application.

05/08 – 09/11 Harvard University

Project Manager - Data Analyst 12/08 – 09/11

• I worked in several roles with the business operations group including project management, both

internal and external relationship management and business analysis.

• Upgraded Reporting databases to SQL2008

• Designed historical data mart allowing for more accurate historical reporting.

• Consolidated EMC storage and Back Up management tools to a single SQL farm

• Implemented reporting philosophy and procedures increasing both consistency and accuracy

• Worked with internal UIS groups in a customer manager role to ensure their server support and network

needs were being met

• Worked with financial partners and product owners to build new or forecast existing services.

• Worked with Vendors to ensure accurate and timely processing of support contracts.

• Worked with the accounting team on automating all billing feeds from NSS to the billing application.

Business Systems Analyst 05/08 – 12/08

• Using the EMC Storage scope tool will need to create automated billing feeds.

• Support any new enhancements or correct any existing bugs in an existing MS Access application.

• Upgrade the MS Access application to a more robust development platform. Facilitate the data cleanup

efforts and develop a more robust reporting environment.

• Write Adhoc and Standard Reporting

• Compile Storage Information Using EMC Storage Scope

• Leading Efforts for Data Integrity and Data Clean up

• Create and Analyze annual Customer Satisfaction Survey

• New development and Bug fixing of existing Access application

• Creation and delivery of monthly billing files

11/07 – 05/08 Bank of America

Systems Analyst – Testing Coordinator

• Managed SIT and UAT testing for the UST re-brand initiative.

• The project spanned three releases and encompassed multiple internal and external applications.

• Worked with the core project team ensuring all project milestones where met.

• Gathered requirements and wrote test plans

• Coordinated access for the testing teams to the different testing environments.

• Coordinated data condition to meet all test scenario’s

PATRICK GLENNON

PAGE 2

• Schedule execution of testing

• Tracked defects from creation to completion

• Reported progress and issues to the Transition Execution team.

07/07 – 11/07 Epsilon

Technical Data Analyst

• Worked as Campaign developer using the Unica Marketing tool supporting the Astra Zeneca

Pharmaceutical client.

• Designed and Implemented Marketing Campaigns

• Developed Campaigns using the Unica Marketing Application

• Gathered Functional Requirements

• Wrote functional Requirements

• Wrote Technical solution Requirements

• Performed Unit Testing

• Wrote UAT Requirements

• Worked with fulfillment vendors to ensure data transfers

11/06 – 06/07 Mercer HR Consulting

Business Systems Analyst

• Technical lead on Siebel campaigns and marketing analytics implementation project.

• Designed data model and data feeds, reviewed modifications to the application to ensure all business

requirements where met.

• Developed an interim solution using MS Access to be used for 1 year.

• Reviewed the current reports written in Business Objects and rewrote using Siebel Analytics.

• Implemented Siebel Campaigns

• Implemented Siebel Marketing Analytics

• Gathered Business Requirements

• Wrote functional Requirements

• Wrote Technical solution Requirements

• Performed Unit Testing

• Worked with DBA to configure analytics data model

• Trained Testing Team and Business Units

07/06 – 09/06 Fidelity Investments

Data Analyst

• Worked on short term contract for Fidelity Investments.

• Gather requirements for Meta Center Application.

• Trained Data Analyst on updating content.

• Trained Business Unit on navigating the application.

• Worked with development team on initial load process.

04/05 – 07/06 John Hancock (Formerly Manulife), Boston, MA

Database Administrator

• Installed and configure MS SQL Server on Windows 2003 Servers.

• Performed database tuning.

• Created advanced queries and customize stored procedures.

• Reviewed database security; Maintained and enhanced as necessary.

• Documented procedures and problem resolutions.

• Automate all maintenance tasks using Alerts, Jobs, and Notifications using SQLMail.

• Implemented and improved backup strategies using log, diff, and full database backups to

accommodate up-to-the-minute recovery.

• Improved backup speeds using stripe sets.

• Replaced existing backup methodologies using “event-driven” approach as opposed to time-driven.

• Implemented intelligent jobs to accommodate shrinking maintenance windows.

PATRICK GLENNON

PAGE 3

• Implemented backups using SQLSafe (Idera Technologies) backup tool.

• Enabled Notifications using SMTP mail for SQL servers that do not have SQL Mail configured.

• Setup jobs to monitor disk space, log space, file groups, and database growth. Resolved them using

“recovery actions” defined within the job.

• Implemented database security by leveraging dbfixedroles along with role-hierarchy.

• Backed up the informatica administrator for code deployments and assisted environment security.

05/00 – 04/05 Manulife Financial, Boston, MA

Senior Business Systems Analyst 05/03 – 04/05

• Consulted with internal clients across Operations and Sales & Marketing on development and

enhancement of systems for Manulife’s annuities business.

• Interpreted client needs into functional requirements, working closely with programming staff to ensure

development aligns with business/functional requirements.

• Developed test cases and test scripts in support of functional requirements.

• Responsible for certification, implementation, and warranty requests.

• Tier 1 analyst for Manulife’s Sales Force Automation suite, Siebel 7.5.

• Developed customer reports using SQL, Cognos, Toad and Brio.

• Provided Tier 2 support to the Actuary, Tax and Compliance Departments.

Business Systems Analyst 03/01 – 05/03

• Primary support for proprietary and vendor application package suite in support of annuities business.

• Troubleshoot production transmission issues in support of overnight cycle; Follow through to issue

resolution.

• Provided analysis of system defects to programming staff; Documented, certified, and tracked through

entire SDLC.

• Worked closely with annuity operation business analysts to ensure solutions aligned with business

requirements.

• Provided adhoc reports using Cognos Impromptu reporting tool, Toad and Brio.

• Created library of SQL queries to improve adhoc reporting response time.

Helpdesk Specialist II 05/00 – 02/01

1997 – 04/00 Norfolk Power Equipment, Wrentham, MA

Sales Associate

• Generated sales orders, maintaining client relations and managing accounts.

• Interacted with clients and forged professional relationships.

• Maintained sales quotas and met sales goals; Oversaw customer financing for all loan request sales.

TRAINING &

SEMINARS:

• Completed Siebel Business Analyst course requirements - Certification Pending

• Database Management - SQL 2000 - Certification Pending

• Impromptu Report Writing - Cognos Center of Excellence

Contact this candidate