SUMMARY
Bright, energetic professional with a unique blend of skills seeking a
challenging position that offers the opportunity to learn and continue my
professional growth. Goal oriented, dependable and trustworthy individual
who is extremely accurate with strong technical and analytical abilities
and thrives in a fast paced environment.
SKILLS
Skilled database development and querying languages including Microsoft
Access, Macros, and HTML. Some experience with VBA and SQL.
Advanced skills utilizing both Microsoft Excel and Project Management
Software to develop reports, schedules, and to analyze data with
extensive understanding of the pivot tables, formulas and graphing
functions.
Proficient in MS office applications including extensive knowledge in
Excel, Word, PowerPoint, Visio and Outlook. Technology inventory also
includes Remedy, Altiris, Clarizen, PlanView, AtTask, CAD Key 19,
AutoCAD, Google SketchUp, Open Office, SAP, Oracle, Peachtree, MAS 90,
SharePoint, SnagIt, OneNote, Archer, Frictionless and many Desktop
Publishing applications.
. High level office management and administrative skills ranging from
maintaining executive schedules to bookkeeping and overall business
management.
PROFESSIONAL EXPERIENCE SUMMARY
Randstad, United Healthcare, Hartford, CT - Project Coordinator (EPMO) -
July 2012 to June 28, 2013
. Supported the Program Managers and Project Managers on a $134M program.
. Created and maintained a complex spreadsheet for the change control
management process for ~700 requests and the change request SharePoint
site.
. Recorded meeting minutes for the weekly change control (IDR) meetings
and was responsible for tracking each change request throughout the
process.
. Created project plans and allocated hours to resources as well as
updating estimates and information in PlanView.
. Created and maintained release management reports and dashboards.
TEKsystems, Inc., Lincoln Financial, Hartford, CT - Project Coord./System
Analyst - September 2011 to March 2012
. Created extensive excel spreadsheets and reports with advanced formulas
and functions.
. Evaluated PMO/BTO's out-dated MS Access database and processes and
proposed changes and new system configurations.
. Documented all processes within PMO/BTO Group.
. Gathered project and resource information for 25 projects and 200
resources across 10 excel spreadsheets/reports into one consolidated
excel sheet and imported into an MS Access database.
. Researched and proposed software solutions for automated
Resource/Demand Management and Project Portfolio Management SaaS .net
software (Clarizen) to top level corporate executives.
. Created deployment plan and training plan for approved Clarizen
software as well as initialized all configurations and settings.
. Entered all project and resource information into Clarizen and created
custom reports and dashboards for PMO/BTO's users.
. Created and implemented a SharePoint site with 5 sub sites to house all
of PMO/BTO's documents, calendar information and other general
documentation.
. Create Triage intake InfoPath form and MS Access Database for reporting
and synchronizing with SharePoint.
TEKsystems, Inc., ESPN, Bristol, CT - Project Coordinator, Windows Vista &
7 Migrations - October 2009 to May 2011
. Created Windows Vista migration schedule for 7000+ ESPN employees and
machines across 24 locations and 8 states and again for Windows 7
migration project.
. Created, maintained and utilized complex Microsoft Access database to
store all employee, machine and migration information.
. Created, managed and implemented Windows Vista and Windows 7 migration
process, both technical and analytical aspects.
. Worked with points of contact for each Business Unit to collect
information about their employees/machines and any special requirements
and review their migration deployment plan.
. Created mass communication material specifically for each Business Unit
and worked with their Executives and Administrative Assistants to send
out communications to their staff.
. Collected, processed and tracked down employee forms and machine
information to meet deadlines.
. Answered all pre migration questions from the end users and worked with
each users schedules to ensure a successful transition.
. Ordered all hardware, software, RAM and peripherals needed for each
migration and preformed asset inventory
. Analyzed software requirements and stayed within software license
compliance policy.
. Created user migration profile packets for the technician's users for
each migration, which consisted of user/machine profile information
forms, software lists, floor plans and migration checklists.
. Learned to migrate and deploy machines independently and helped
technicians with next day support after migrations.
TEKsystems, Inc., CIGNA Corporation, Bloomfield, CT - Business Analyst -
July 2009 to September 2009
. Manually extracted large amounts of data from the CIP Archer database
and imported to excel for extensive data analysis.
. Created project plan, Archer issues log, and created various reports,
macros and pivot tables.
. Conducted extensive research for approximately 1,400 vendors, performed
quality control reviews of the data to ensure consistency and
completeness, and corrected all issues identified.
CIGNA Corporation, Bloomfield, CT - Business Analysis Specialist -
September 2008 to May 2009
. Developed and maintained detailed organizational charts for a large
scale IT operation consisting of more than 4,000 people across 7
departments.
. Researched and proposed software solutions for automated Headcount
Management, Facility Space Planning, and Strategic Work Force Planning
to top level corporate executives.
. Helped to create and implement a new "IT Sourcing Approvals Process"
for the IT Organization and was selected to manage the process on an
ongoing basis.
. Coordinated and maintained HR requisition process for hiring employees,
consultants, and off-shore resources across the IT organization and
ensured all employee requests were properly forecasted and signed off.
Robert Half, CIGNA Corporation, Bloomfield, CT - Strategic Sourcing
Coordinator - April 2008 to September 2008
. Supported a team of 12 in all aspects of administrative support and
contract management. Responsibilities included general administrative
duties, filing, faxing, copying, scanning, ordering supplies, shipping
and receiving.
. Created legal documents and uploaded fully executed documents into
Frictionless, a SAP software.
Robert Half, TRC Environmental, Bloomfield, CT - Accounts Payable
Specialist - February 2008 to March 2008
New England Typographic, Bloomfield, CT - Project Coordinator/Executive
Admin. Asst., January 2004 to July 2007
. Created tables, queries, reports, and forms using MS Access database
utilized for daily research & analysis of data.
. Organized and collated historical accounting data and migrated to the
new MAS 90 accounting software.
. Developed and executed training and shadowing programs for new
administrative and production personnel.
. Assumed ill supervisor's responsibilities for 5 months, managed 4
large scale projects and a 15 member team.
. Assisted 9+ Project Managers with all aspects of long and short term
projects for high-end textbook production.
. Created, updated and managed extensive schedules for projects.
. Shipping and Receiving; Ordered Supplies for all departments.
. Performed data entry tasks with flawless accuracy using MAS90, MS
Excel, and MS Access.
. Responsible for A/P, A/R, Payroll, HR, and general administrative
duties.
. Created invoices and other administrative duties for the President and
Vice President of the company.
EDUCATION & CERTIFICATIONS
. IT University Online, Comp TIA IT Certification, Present
- A+, Network+ and Security +
. Franklin Covey, 2013
- Leadership, Business Skills and Time Management Training
. Manchester Community College, 2010 to Present
. Simsbury High School, Diploma with High Honors, June 2006
. Bristol Technical Institute, CAD Certificate, June 2005
- Invited to compete in Skills USA based on test scores
. Completed advanced coursework in Microsoft Office applications including
MS Excel and MS Access
. First Aid, CPR and AED Certified, 2013