Data Analyst / Project Manager
Resume:
Resume
Andrew Hudson, MBA, PMP
Project Manager/Analyst
Falmouth, ME
*******.***@*****.***
EXPERIENCE
Cole Haan, Scarborough, ME July 2013 – April 2014
Project Manager / Contract
• Managed multiple projects for retail infrastructure upgrades
• Created extensive database for phone service transition in MS Access
• Provided ongoing reporting for phone service transition
• Provided data modeling for call volumes and phone service cost
• Each project delivered on budget, on schedule
• Project budgets were $257k, $315k, and $1.04M respectively
• Managed multiple vendors and multiple SOWs simultaneously
• Coordinated closely with retail operations, store managers, field technicians, on-shore and off-shore IT support
Maine Public Broadcasting Network, Lewiston ME Jan 2011 – April 2013
Software Specialist/Analyst
• Produced special reports on membership demographics for senior management
• Ongoing analysis of membership trends
• Membership data migrations using SQL Server
• Extract, translate, load of 3rd party data
• Evaluated use of OLAP data cubes for membership
• Managed review and removal of legacy batch processes from membership database
• Major overhaul of membership database data
• Managed data migration for membership contacts
• Managed development of custom budget reporting software
• Managed migration of company email services to cloud-based Zimbra email
• Managed upgrade of finance department’s enterprise resource planning system
• Managed upgrade of company invoice management system
• Managed migration of critical services to TOPDesk workflow system
• Managed acquisition and rollout of new enterprise HRIS package
• Received highest ratings in annual review
Hudson Consulting, Tampa FL Nov 2009 – Dec 2010
Freelance
• Consulting on data-driven process improvement, product analysis,
• Cash flow analysis, product portfolio management
• Extensive data collection, processing and analysis in Excel using pivot tables and charts
• Business analysis, contracts on process and procedure documentation
• Technical consulting on issues such as SMB storage and backup, security, virus protection
Jagged Peak, Tampa FL
Project Manager Sept 2008 – July 2009
• Managed full SDLC for numerous e-commerce, web, and warehouse management projects
• Managed multiple SQL Server upgrades and server migrations
• Provided site reports using Google Analytics
• Prepared weekly status and budget reports to executives and stakeholders
• Provided extensive budget reports using Excel pivot tables
• Provided competitive analysis market research reports
• Managed daily work assignments and scheduling on multiple concurrent projects
• Responsible for pushing content and code through Development, QA, and Production environments
• Managed developers, designers, DBA’s and QA staff on multiple projects in web development environments including UI design & mockups, web services, and database
• Managed web-based client acceptance testing, issue resolution, and deployment to production for numerous client projects
• Worked on warehouse distribution projects including shipping and routing
Wellcare, Tampa FL Oct 2006 – May 2008
Manager of Reporting
• Managed a staff of three analysts to deliver daily, weekly, and monthly reports
• Delivered ad hoc reports using extensive Oracle SQL queries and a 100+ table schema
• Used Excel analytic tools including pivot tables to process reports
• Updated existing reports in Access
• Gathered report requirements from expert users
• Managed the transition of large reports from Excel to Cognos BI
• Phased out older reports, gathered requirements and procedures for new reports
Project Manager
• Managed business analysts on large data medical records reporting
• Managed multiple enterprise projects through SDLC
• Projects included automation of provider contracts, enterprise healthcare management, and federal metrics reporting for clinical treatment
• Worked with vendor to ensure custom requirements were met
• Scheduled multiple weekly inter-department meetings and maintained legal meeting minutes
• Managed network operation center staff and procedures, including server deployments
• Managed requirements analysis for multiple vendors
• Performed project budget and ROI calculations
• Promoted twice
WMNF Radio, Tampa FL July 2001 – Oct 2006
Manager of IT
• Responsible for all IT expenditures, projects, and maintenance. Projects included web-based fund raising software, facilities migration, server migration, and web-based HR management software
• Maintenance and backups for Raisers Edge constituent database
• Prepared project charters, scope of work, work breakdown structure (WBS), activity definition, scheduling, task assignment, cost estimating, resource planning, and requirements documents
• Managed resources between departments, provided network security, database maintenance
• Managed procurement, build-out, deployment of production servers
• Monitored and maintained company network and internet services, performance, upgrades
• Greatly increased all IT reliability by instituting Best Practice policies
Pegasus Imaging, Tampa FL Oct 2003 – Jul 2005
Business Consultant
• Acted as a Product Manager to advise the president on process re-engineering and business effectiveness issues
• Prepared market research reports for existing products to determine potential ROI
• Prepared and presented competitive analysis reports for lagging products
• Performed requirements gathering to bridge vital gap between customer community and developers
• Negotiated with stakeholders for change requests to project
• Introduced project planning to development teams
• Collaborated with VP of Engineering to ensure standards and practices were developed for configuration management and application development.
• Managed multiple software development projects
Mediacentric Group, Clearwater FL Jun 2000 – May 2001
Technical Manager
• Successfully developed unified messaging solution on tight schedule
• Coordinated demanding technical requirements of highly visible project ($900k/month)
• Hired software development team of 6
• Provided daily work assignments
• Directed, guided, coached the team members with new technologies
• Provided weekly progress and cost reports to management
• Worked with UML Use Cases, Activity Diagrams, Sequence Diagrams, and Class Diagrams
• Resolved specification conflicts and ambiguities in the software design
• Coordinated Dev/Production environments
PRIOR EXPERIENCE
Product Manager for all aspects of commercial software products. Responsibilities included feature planning, GUI design, QA, manual writing, packaging, first and second tier tech support, press tours, and international marketing. Multiple products won international awards and sold in 5 languages..
EDUCATION
University of Tampa, 2005
Masters of Science, Technology and Innovation Management (technical MBA)
Rochester Institute of Technology
Bachelor of Science, Computer Science
SKILLS
• Excellent reporting and data analysis skills, market research, technical client consulting, business writing
• Expert technical skills: Excel super user, SQL reporting, MS Office, MS Project, server hardware
Working knowledge: SharePoint, Visio, HTML, Oracle, SQL Server, Visual Basic, Descriptive Statistics/SPSS, C/C++, Perl, Windows, Linux/UNIX
PROFESSIONAL CERTIFICATIONS
Project Management PMP, 2006
Contact this candidate