PROFESSIONAL SUMMARY

Seeking a long-term opportunity in data analysis and report t development as Project Manager/Sr Business Systems Analyst/Data Analyst creating metrics and dashboards and/or performing QA for same. 10+ years’ experience with SQL, Cognos Tools, MS Excel, Access, PowerPoint, Visio, MS Project. Highly adaptable to a variety of system and technical environments, able to apply analytical skills to each unique situation. Hands on team player with experience in technical roles and project management delivering quality to serve the needs of internal and external customers.

EDUCATION

Bachelors of Science Corporate/Organizational Communications, Northern Illinois University

Professional Training:

oThe Data Warehouse Institute(TDWI) Data Quality

oKimball University Data Modeling, Star Schema Design

oCognos Corp BI Suite, Framework Models, Transformer Cubes, Cognos Connection

oCamp IT Program & Project Management

oLodestar Inc., Business Analyst Training

oAdvanced Computer Training (ACT) PMI Prep, HP Quality Center, HP Quick Test Pro

EMPLOYMENT HISTORY

Astellas (Technical Business Analyst) Jan 2016 to Feb 2016 (Contractor, FastSwitch Inc.)

Validate data mapping quality to trace new data map design to business requirement document. Analyze changes to interface files resulting from Salesforce upgrade of the event management module. Update vendor file layout and data map.

ABBVIE (Infrastructure Program Coordinator) Mar 2015 to Oct 2015 (Contractor, Insight Global)

AbbVie split technical infrastructure from parent company (Abbott). Worked as IT Infrastructure program coordinator to manage status, schedule, risks and change for 10 interrelated work streams.

Create weekly work stream status reports, pull SharePoint data then format for presentations, data manipulation in MS Access (SQL) extracts to produce weekly reports for 10 technical work streams.

Facilitate program level meetings for infrastructure work streams such as Active Directory, Global Network, Service Desk, Security, SAP for 130 locations. Produce weekly meeting presentations for 10 project managers to monitor due dates, past due, upcoming activity, adjust scheduled milestones and due dates.

Create weekly executive summary reports, extract project data from SharePoint to create executive level PowerPoint dashboards. Create summary dashboard for leadership with drill to supporting details.

Monitor and control work stream milestones and their dependences between work streams and evaluate impact of change, approve change requests.

Create slides & facilitate morning Standup meeting, bringing directors and technical leads together, to understand progress, remove barriers, resolve issues and mitigate project risks.

Create Vendor Metrics (SLA) Server Build Metrics – Create business requirement, mock ups, and prototypes for vendor metrics. Design BI dashboard with drill through to detail, allowing leadership to measure volume and duration of vendor’s work thru each phase of the workflow.

Managed data quality of the extract, collaborated with vendors to create consistent clean data and gain acceptance from business stakeholders.

Create Excel prototype translate to technical specifications for QlikView developer. Perform testing of Qlikview data quality, to assure requirements were translated into technical design. Execute testing, document test plan, report issues, retest thru resolution and migration to production.

AON HEWITT (Test Engineer) Oct 2014 to Dec 2014 (Contractor, Randstad)

Design and execute system test for TM1 data conversion for AON’s Financial Operations team. Test TM1 data for conversion of source system from People Soft to Workday. Meet with stakeholders to understand and document data requirements. Create test methods to check accuracy of financial data in Cognos TM1 cubes.

Import data extracts into MS Access, manipulate, compare, validate old vs new data. Report issues to developer, regression test. Verify accuracy of all years of historical data for the dimensions and measures in Cognos TM1 Cubes. Collaborate with business and technical leads to plan an effective testing method.

Execute testing using Cognos TM1, MS Access & Excel. Log issues, regression test, document-test artifacts.

HOSPIRA (PMO Project Coordinator) Jul 2014 to Nov 2014 (Contractor, CRS Group)

Hospira Enterprise PMO team. Project coordinator and scheduler for the Vizag SAP project to implement SAP at new pharmaceutical manufacturing plant in Vizag India. Utilize MS Project to coordinate tasks and status from each functional team.

Monitor status for 1500 tasks, with multiple project managers and high amount of coordination between technical and business functional areas.

Communicate with Project Managers, relationship managers, and functional leads to maintain project schedules and ad-hoc requests. Produce daily & weekly project status reports, meeting minutes to summarize key points, action items, issue-tracking reports.

Organize go-live task list, on-call schedule for Hyper care, so all go live tasks would be performed at the right time in the correct sequence resulting in a successful technical go live.

Daily use of Excel, Word, PowerPoint, SharePoint and MS Project for project tracking and artifacts.

DISCOVER FINANCIAL, Finance Dept. (UAT Manager)) Sep 2013 to Feb 2014 (Contractor, CRS Group)

Test Manager for a large-scale conversion from legacy General Ledger system to new accounting HUB (Microgen accounting software.). Oversee work of vendor during UAT and internal subject matter experts for each functional area (Data Conversion, Period End, Map, FX, User Experience).

Monitor task list in MS Project, time lines, schedules, open items list, communication plan, report progress to executive management in easy to interpret format so business had snapshot of testing progress.

Oversee testing activities for User Acceptance Test, Test Environment Configuration, End User Functional Test, Tech Team Data Conversion, Disaster Recovery Test, Performance Test.

Create test case progress reports and defect statistics from HP Quality Center. Format into management ready reports, for leadership.

Create and monitor task list, timelines, schedules MS Project. Document open items and project risks. Monitor test team resources, progress, test plan creation by functional SME, test schedule, batch schedule, defect tracking and resolution in HP Quality Center

Document process flow (current state/future state) for general ledger system. Track team tasks, time line, open items. Assure follow up on action items, code delivery, defect resolution to user acceptance.

Meet daily with team leads to monitor progress, discuss open items, identify risks, escalate issues and defects.

Create project status reports, defect summary reports for leadership team. Coordinate work and resource allocation for all aspects of testing by vendor, business stakeholders, testers, developers, and QA teams.

Facilitate cross-functional team meetings to address open items with business, internal tech leads and vendor technical teams.

Perform Business Analysis for Foreign Exchange module, from ‘current state’ to ‘future state’. Kick off with team, elicit business/technical requirements for Foreign Exchange Rate transmission process.

Document new FX data flow, facilitate technical requirements, business requirements, document future state for the daily batch process to load FX rates from vendor to new General Ledger system. Monitor cross-functional team (treasury, accounting, technology, vendors) to keep work on schedule.

ARTHUR J. GALLAGHER, Corp Division (PMO Lead/Project Manager) Jul 2009 - Dec 2012

Manage Enterprise PMO, perform project and program reviews of high dollar IT initiatives for resource, schedule and budget. Summarize project status for 20 projects each month for executive dashboard.

Improve process by creating project-tracking templates for Project Managers to document status at a glance meeting CIO’s requirement. Train off shore team in PMO responsibilities and procedures.

Create monthly IT metrics reports for global CIO. Summarize project status for a portfolio of projects, summarize operational metrics (server uptime, help desk response times) using MS Excel graphs.

Gather requirements from Global CIO to enhance the report offering with new reports and graphs. Create mockups, collaborate with CIO for best presentation to convey the desired message, sign off & publish.

Manage off shore team to create the monthly PMO deliverables, perform internal audit for SOX testing,

Analyze operational issues with expense management process for Finance Dept. (data flow from Concur to HR to Payroll to JDE and Cognos). Document current state, interview stakeholders, create new staffing model to build in quality control procedures.

Manage on boarding of new web/email domains for merger and acquisitions. Improve workflow/hand-offs between multiple divisions, departments, functional areas, and external vendors with templates and regular communication plan.

ARTHUR J. GALLAGHER, GB Division (Cognos Quality Analyst/Test Lead) Oct 2006 - Jul 2009

Cognos QA Lead (3 yrs.) Sr. Quality Analyst for the Cognos development team, creating metrics for corporate insurance data in Cognos web reports: claim summary, claim frequency & severity, claim dashboard, liability scorecard, managed care, workers’ comp, loss summary, prescription utilization, etc.

Performed all testing to assure consistent quality prior to prod migration.

Write SQL to create complex quires to reverse engineer new or upgraded Cognos report to validate results.

Create a testing methodology to implement repeatable testing process and a sound test methodology be used as standard operating procedure for the development team.

Trained on shore and off shore testers, mentor new analysts, divide and assign work, monitor and signoff on completed testing assignments.

Perform testing for data and report quality, for the Cognos Report development team. Perform all aspects of data, report and system quality for new reports and Cognos upgrades. Manage issue list; coordinate w/developers for resolution.

Code complex SQL scripts to verify the accuracy of prompted, variable driven Cognos Report Studio reports.

Create multiple validation techniques to quality check report result matched manual result in Excel. Assure accuracy of data, security, user functionality, and adherence to requirements, resulting in fully functional interactive web reports (Cognos Report Studio).

Test Cognos features: prompts, drill through to source system, user security, navigation, integration, report scheduling & email delivery. Assure features work at optimum performance levels for end users to access reports via the web.

Suggest system enhancements, elimination of unnecessary steps to improve efficiency, create end user guides. Promote standardized report formats for consistent quality.

Cognos Reports developed by our team were highlighted in newsletters, sales and marketing materials bringing greater value to over 2,000 corporate clients.

ACCENTURE, HRIS (Business Systems Analyst) Jan 2005 - Oct 2006 (Contractor, Techni-source)

Accenture HR (internal) report team. Improved Cognos Payroll Reports for Finance Department using Cognos Impromptu, Excel, MS Access and SQL.

Elicit business requirements for the report consolidation effort. Deliver Webex presentations to summarize business requirements to gain approval from leadership.

Perform current state analysis to determine approach to consolidate Cognos Impromptu data extracts.

Design streamlined approach in Cognos, SQL, MS Excel, and MS Access, to eliminate redundant tasks creating an efficient standard procedure. Cut labor hours by 75% reducing costs.

Present proposal to team, incorporate feedback, code and test changes (Cognos Impromptu, SQL MS Access, SharePoint).

Train remote teams using PowerPoint and Webinars assuring team is fully trained and comfortable with supporting the new process.

HEWITT, Total Benefits Data Warehouse (Cognos Developer) Jan 1997 - Apr 2004 (7 years 2 roles)

Hewitt data warehouse team 1999-2004. Code SQL scripts to test ETL process, assign work to testers, and develop Cognos Cubes for large-scale startup of Benefit Plan Web Site for HR executives.

Interface with business sponsors to gather requirements for executive employee benefits summary reports. Delivered corporate benefits data aggregated via BI Tool (Cognos Cubes) on the web for Work Force Analysis, Health Plan Participation Analysis, Investment 401K Analysis, Pension Plan Analysis. Annual Enrollment and Health Plan Migration

Perform cube and report design, using Start Schema models, create prototype, test and sign off from business, and publish to external Web Site.

Code SQL, Cognos Impromptu, Transformer, Power Play Enterprise Server, Upfront, and Access Manager. Performed data mapping, cube design, development and roll out of cubes and views, enabling benefit plan administrators to have dashboard reports at their fingertips.

Setup Cognos security for Cubes Views on web portal for corporate clients, eliminating programmer intervention.

Configure custom report views (Cognos Powerplay) for each client based on user security and custom business models.

Interface with Cognos vendor to troubleshoot technical issues.

Redesign process to onboard client customizations of the Cognos Report web portal. Wrote specifications of the setup steps for developers to engineer code from manual steps to a scripted automated process, improving setup and delivery time exponentially.

HEWITT, Pension Administration (System Consultant) 97 to 2000

Performed three years in application Technical/Client support for Pension Administration System.

Setup test environments, created specifications for custom code, setup and document client configuration.

Customized client documentation and instructional material for system upgrades.

Organized team of shared service system consultants to meet client demand and resolve client system issues and upgrades, Using issue tracking and project tracking databases. Setup and organized database structure.

Traveled to client sites for system setup and support.

MetroMail, Division of RR Donnelly, (Production Database Support) 94-96

Technical/Client support Marketing Mainframe Database, configuring database updates, on call support, creating client custom extracts for large publishing company marketing campaigns.

The Bradford Group (Programmer Analyst) 88-94

Four years programmer analyst, coding Cobol and JCL, creating time estimates and project plans, performing coding, testing, preparing paper work for production migration. Fully trained in SDLC processes and Project Management Methods.

Two years Client Service Representative talking to external customers on inbound call center, assisting customers with orders and resolving issues with product or returns.

Contact this candidate