Systems Analyst Data Scientist

ANNE ROHACH HOGAN

Commerce City, CO ***** *******@*******.*** 720-***-****

PROFESSIONAL EXPERIENCE

RxMx Corp (formerly RxMx USA, Australian Company with Division in USA)

Dec. 2017 - Present

Sr. Business Systems Analyst - Data Scientist

Denver, CO - REMOTE

·Sr. Systems Analyst / Data Scientist on Agile Team working on start up medical information technology company.

·Analyze Data Anomalies and System Process issues to ensure system functionality

·Responsible for gathering requirements, writing process flows, user stories and documenting development requirements, as well as create SQL Reports.

·Analyze system issues and trouble shoot possible fixes for system issues.

·Statistical Analysis of Lab Results for Predictive Analytics.

·Responsible for developing requirements documentation.

·Utilize and Design Tableau reporting, create GROW Reports (grow.com) via API, Google Analytics and external data for live broadcasting of information.

·Collaboration and communication with remote and spread out development, BI and End User teams to improve data quality, system bugs and system cohesiveness.

·Maintain JIRA Board for stories, bugs, tasks and reporting purposes.

·Liaise between Operations, Product and Development Teams for system improvements.

·Tableau Administrator – Account set up, System Layout and

WILLIS TOWERS WATSON

Jul. 2015 - Dec. 2017

Sr. Business Systems Analyst

Denver, CO - REMOTE

·Sr. Business Systems Analyst on Agile Team working on defects, system up-grades and implementations / modifications, as well as reporting, analysis and projections.

·Responsible for gathering requirements, writing process flows, user stories and documenting development requirements, as well as create SQL Reports.

·Lead on Client Implementations of new systems installations – for Off the Shelf and Client Specific Software

·Met with Client to discover, synthesize, and analyze information to elicit business needs, document processes, develop solution strategies as well as create test scenarios

·Documented current and future process definitions gathered during work sessions with Clients, SMEs and Product Owners

·SQL Meta Data fixes, TFS

·Researching and analyzing end user issues

·Providing RFP documentation support as-needed

·Communicated business and technical processes and requirements to key stakeholders both internal and external

·Configure and maintain function specification for client SQL Databases and load conversion files.

·Automation of communication templates interfacing between system and database.

·Ticket queue management for issue resolution.

·Attends client meetings relevant to the components they have responsibility for, to establish client relationship and ensure complete understanding.

·Responsible for developing requirements documentation.

·Responsible for system configuration based on requirements.

·Reviewed application designs and system test results

·Responsible for creating test plans, and testing system changes and enhancements to ensure completeness and accuracy. Regression testing as necessary based on the nature of the system change/enhancement.

* Colleague of the Month – twice, in 2016.

KAISER PERMANENTE

Dec. 2014 – Jul. 2015

Sr. Business Systems Analyst

Aurora, CO – (Contractor – Apex Systems, Inc.)

·Business Systems Analyst on Agile - KanBan Support Team working on defects, system up-grades and implementations of modifications.

·Responsible for gathering requirements, writing process flows, user stories and documenting development requirements.

·Worked with multiple divisions to update and maintain ETLs and data flow issues between systems as well as an upgrade to HL7.

·Collaboration and communication with remote and spread out development, BI and End User teams to improve data quality and system cohesiveness.

·Interviewed Stakeholders and worked with Product Owners in developing business requirements, functional applications while writing user stories and acceptance criteria.

·Identify, evaluated, and developed processes, procedures and resolutions, which were cost effective and met user requirements.

·Performed unit and integration systems testing.

·Created SQL, Crystal and Tableau Reports to maintain and improve business.

·UI Moc up, Data Mapping and Qlikview project.

·Worked with enterprise architecture to ensure best tools and techniques were being used in managing data within the warehouse(s).

·Very strong writing, negotiation and presentation skills.

·Collaborative, customer-focused and able to create value for the business.

·Utilized Teradata, MicrosoftSQL, Excel, Tableau, Qlikview, LAN/WAN, Rally and Other ETL/Developer tools

DEPT of HOMELAND SECURITY - FEMA

Aug. 2011 – Aug. 2014

Systems Analyst (GS-13 step-4)

Washington, DC – (Remote in Denver, CO)

·Business Systems Analyst advising on IT Upgrades and installations within multiple areas of the project for agency wide deployment systems and up-grades.

·Responsible for gathering requirements, writing process flows, user stories and documenting development requirements.

·Systems Analyst in both Waterfall and Agile environments.

·Wrote Use Cases and end user requirements and process flows, developed and interpreted policies, procedures, and strategies governing the planning and delivery of services throughout the agency, focusing on the disaster reservists

·Coordinated with internal and external customers to solve complex problems and document future solutions.

·As the government liaison for these other agencies I worked within their computer systems as well as FEMA’s to ensure that program and user needs were met.

·Defined milestones and deliverables, monitored activities, and evaluated and reported on accomplishments to senior management.

·Manage and presented on various cradle-to-grave federal acquisition activities supporting the development, testing and implementation of enterprise IT projects.

·Skilled in the Software Development Life Cycle as an Analyst and a Project Manager supporting Enterprise Relationship Programs as well as smaller development and implementation projects.

HEALTHGRADES

Feb 2010 - Feb 2011

Scrum Master/Business Analyst - Denver, CO

·Agile Software Development leading two teams of developers on Search Engine development and Web UI/UX.

·Gathered requirements and documented in Rally and other agile tools, lead standups, problem solved and documented team processes during Search Engine Development and Web Site creation.

·Assisted Product Owner in writing stories, documenting end user requirements and interviewing end users on needs and issues.

·Scrum Master/ Team Lead on the Project to redesign the Ratings Process as part of a global data warehouse installation.

·Utilized Rally in agile environment.

DEPT of HOMELAND SECURITY - FEMA

Jul. 2006 – Jan. 2010

Regional Liaison –Program Analyst

·Deliver IT programs, solutions and services; develop solutions for integration/interoperability issues; designing, developing, and managing systems that meet current and future business requirements and applying and extending, enhancing, or optimizing the existing architecture; and applying new developments to previously unsolvable problems.

Disaster Reservists - Computer Specialist, Technical & Emergency Management Instructor

·Develop Training Course Materials for a variety of classes (including, but not limited to all computer software courses, ELB469, ELB470, etc.).

·Work as a Unit Lead, Trainer and Special Projects developer for Regional Offices, Disaster Workforce Division (DWD), Emergency Management Institute (EMI), as well as HQ.

·Served as the Regional Liaison between the Headquarters Disaster Workforce Division (DWD), Regional Cadre Managers and Regional Management in the development, interpretation and consistent application of all workforce related policies, programs and standard operating procedures.

·Coordinated policy reviews, consolidate comments from Regional Program Managers, provide information, and draft responses to Congressional inquiries regarding the Reserve workforce or Disaster Reserve Workforce Program.

·Selected for special implementation project of TalentLink HR hiring tool as the technical analyst and project manager.

·Responsible to implement new hiring programs that incorporate atomization standardized hiring practices as established by the DWD.

·I serve as the primary Regional contact for Automated Disaster Deployment system data requirements.

·In collaboration with the DWD and Emergency Management Institute, I serve as the Regional Coordinator in the project planning and tracking of the reserve workforce training and credentialing.

·Develop and maintain the SharePoint site for Regional Office, maintain intranet site, and support Regional office with data analysis, reporting and technical expertise.

·Worked to align the Regions data processes with the agencies to work within the agencies secure structure and policies.

·Automated and streamlined reporting for Regional analysis and reports to Head Quarters. Design, Secure, Update and Manage Websites via SharePoint, Adobe Suite (Dreamweaver, Flash, Fireworks, etc.) Microsoft .NET and other web based technologies to support users in sharing and collaborating information or projects.

LEVEL 3 COMMUNICATIONS (STREFFCO)

Oct 2007 – Jan 2008

Analyst/Senior IT Project Manager

·Was brought in to create a unique reporting capability using Business Intelligence - CUBES to project the future sales in the pipeline and project market changes based on special promotions being offered.

·I analyzed business and system needs for Financial Accrual and Reporting from various companies as Level 3 had acquired more than 9 other companies within a year prior to me coming on board.

·Working with these companies remotely I was able to abstract and convert their data to a standard design and build reports based on live data.

·I used RUP to document process flow of the project and maintain accountability between departments and document user processes for future uses.

·Combining systems from multiple companies made me process model their data, their processes and their flow of activities. This saved the company a great deal of time and money when determining which systems to absorb into others for time saving and licensing cost effectiveness.

·Using the ETL Tools to manage data flows for source systems to warehouse and user marts I was able to streamline data backups and teach end users to pull reports more efficiently for more dynamic results.

·Utilized Rational, SQL, Oracle, Rally, Business Object/Crystal Reports, CUBES

PEAK PROFESSIONAL SOLUTIONS

Jun 10, 2002 – Jul 12, 2008

Systems Analysis Consultant/Project Manager

·Managed projects, analyzed organizational procedures and developed new business processes and documented the procedures and process flows for training

·Worked with many local and county governments to develop strategic plans, moderate their organizations through training and learning processes as well as assist them with staffing development plans.

·Worked with teams of architects and developers in ETL implementations to provide guidelines and testing strategies. This is done in order to roll out new applications and reporting technologies through Wide Area Networks (WAN) to international sites.

·This assists government agencies in developing plans in a very short amount of time with the least amount of impact to their daily routines. (Teller County-CO, Golden-CO, Lafayette-CO, Brighton-CO, Pitkin County-CO, etc.)

·Senior Analyst and Network Administrator in the Implementation of enterprise data warehouse (EDW), IT Infrastructure (LAN/WAN) set-up and configuration and application integration projects. Web creation and management for business development and solutions.

·Utilized LAN/WAN, SQL, Oracle, Erwin, Business Object/Crystal Report, SharePoint, MSProject

DOD/DFAS Lowry Air Force Base

July 2001 – May 2002

Lead Sr. Analyst, Process Modeler - Consultant (NAC Government Clearance)

·Systems and Business Analyst of Government Payroll System – analyzed, wrote documentation and implemented data warehouse to provide for future growth

·Managed Repository Documentation Project

·Documented Process Flows for Repository Requirements

·Process Modeling (Using IDEF0 Methodology – BPWin) Military Payroll System

·Read and Analyzed COBOL Code for the purpose of redevelopment of system

·Utilized SQL, Oracle, COBOL, IDEF0, Crystal Report, Access, Excel

AT&T Broadband, Denver, CO

Nov 2000 – Jun 2001

Sr. Project Planner, Process Modeler - Consultant

·Managed Project Plan and Senior Executive Communications

·Systems and Business Analysis performed on multiple areas of the project

·Data Mapping and Process Modeling

·Created requirements documentation and developed Use Cases

·Documented system processes and user needs

·Utilized SQL, XML, Oracle, Toad, Crystal Report, Brio, Access, Excel

ICG Communications, Denver, CO

April 2000 – Nov. 2000

Application Systems Analyst IV, Managing Engineer – Contract - Lead

·Conducted Systems and Business Analysis, Data Mapping and Data Flow management

·Designed and developed ETL solutions and Implementation of OLAP/Business Intelligence solutions

·Implemented New Systems, Data Loads and Validations of Security

·Installation of systems across area networks and tested implementations of new platforms

·Requirements Development and Business Application Assistance

·OSS Developer on New Corporate system implementation

·Utilized Oracle dB, Developer, Designer2000 and reporting tools

·Utilized PL/SQL, Oracle, Toad, Crystal Report, Brio, MSProject, Access, Excel

Micromedex, Inc., Englewood, CO - CONTRACTOR

June 1999 – Nov. 1999

Project Lead / Technical Manager

·Managed a team of developers to integrate applications

·Systems modeling, functional and process flows and Use Case development

·Responsible for functional area and projects that financially affected the company

·Defined, monitored and maintained project plans

·Utilized SQL, PL/SQL, Unix, Unison, MSProject, Access, Excel

Echostar Communications, Littleton, CO - CONTRACTOR

Dec. 1998 – June 1999

Sr. Business Systems Analyst

·Analysis and development of data solutions for internal business customers

·Systems modeling, functional and process flows

·Developed and deployed reporting and analysis projects

·Utilized Oracle DB, Developer, Designer2000 and Discoverer, MapInfo, Toad, SQL, PL/SQL, Excel, LAN/WAN and Other ETL tools

EAS, Golden, CO - CONTRACTOR

June 8, 1998 – Sept. 30, 1998

Sr. Business Systems Analyst – Consultant

·Analysis of Sales department, resources, systems and procedures

·Performed systems modeling, functional and process flows and data mapping

·Managed retail sales force and automation process

·Statistical analysis of sales, competitive pricing, and profit margins

·Utilized Legacy system, Oracle dB, and Designer2000, and Discoverer, SQL, Access, Excel

America West Airlines–

June, 1991 – April, 1998

Cross Utilized Ticket/Gate/Ramp Agent

·Booked Passengers (Ticket and Gate Agent)

·Wrote Customer Service Manuals for Special Airline Project

·Loaded baggage into plane

·Worked on Manifests and plane load capacity

EDUCATION

MSCD – Course – Javescript, HTML, XML, Pearl, GitHub Rutgers University 2014-2015

M.A. St. Mary's College - Minneapolis, MN (Counseling and Psychology - DP) 1990-1992

B.A. St. Olaf College - Northfield, MN (Psychology and Asian Studies) 1985-1989

Semester (6 months) - in South East Asia (Thailand, Japan, Taiwan, Hong Kong, and China)

AWARDS

CBEP Leadership Award 2013

Cash Award for Service Above and Beyond 2012, 2011 (2), 2010, 2008, 2007

COMPUTER PLATFORMS & SOFTWARE SKILLS (Instructor of Microsoft Suite)

SQL Server, Tableau, Cache-Intersystems, GROW grow.Com, JIRA, R, Python, PMI Certification Training (Federal Program), Microsoft Office Suite (OneNote, Communicator, Word, Excel, PowerPoint, Outlook and Access (All Versions) MS Project, Visio, FrontPage, SharePoint (All Versions), Adobe CS3/CS4 Suites (Camtasia, Photoshop, Dreamweaver, Flash, Fireworks) Oracle, Designer and Discoverer, LIMS, SQL, PL/SQL, XML, Rally, Qlikview, Tableau, Crystal Reports/Business Objects XI, BI, Brio Reports, Rational Rose, Rally, Informatica 5, Tivoli Enterprise Data Warehouse, Business Object, Toad, Cognos 5.1 MapInfo, ArcGIS 9.2 and Web, Cobol, IDEF0, Documentum, Quark Xpress, PageMaker, Photoshop, Corel, HTML, InfoPath, Vocus, NEMIS, ADD, CISCO VPN, HSIN, iPass

Contact this candidate