We provide IT Staff Augmentation Services!

Resume

Business Intelligence Project Lead Sr Project Manager Portland, OR

SUMMARY:

PMP and Scrum Master certified Senior Project Manager with 10+ years of in large - scale application development, business intelligence, infrastructure, and data center projects. Most recently, served as a Project Lead for Confidential, leading a team of 3 ETL Developers on the development and implementation of several data warehousing and business intelligence solutions. Prior to that at Confidential, served as a Senior Project Manager for four large infrastructure projects, including a 700-server Data Center build-out.Possess strong business and technical leadership and communication skills, excelling in ability to bridge the technical and business sides and drive difficult projects through to completion.

EXPERTISE AREA:

Leadership: Experience with C-Level management relations, strategies, enterprise level project dependencies, tactical planning, team facilitation and influence, negotiations, charters, budgets, offshore coordination, PMO status reporting, resource planning, SOW’s, staffing and performance reviews. Maintains a “servant leadership” style by listening, by acting with empathy and by demonstrating commitment.

Business Relations: Experience working with business priorities and roadmaps, solid ability to manage expectations, negotiate trade-offs, monitor product value and quality as demonstrated with Oregon State agencies, Schnitzer and Confidential, Confidential Hospital and Moda business stakeholders

Current Technical: Proficient in MS Project, SharePoint, Office, Clarity, VersionOne, Rational Team Concert, Visio, Skype, SQL, Business Objects, MicroStrategy, Cognos, Perspectives

Past Technical: 10+ years as a relational database and/or ETL developer using Oracle SQL, TSQL, Toad, SQL Server Management Studio, Sybase Power Designer, Eclipse, CVS Tortoise, Subversion; LAN/WAN system administration with skills in User/Group organization, batch and shell scripting, FTP, Unix cron / Windows job scheduling, IBM DataStage TX and Gentran Server. 5+ years as a marketing web developer using HTML, CSS, XML, XSL, Java scripting, WordPress, Shopping Carts, Verisign, Photoshop, Corel Draw and Quark Express.

EXPERIENCE:

Confidential, Portland, OR

Business Intelligence Project Lead / Sr. Project Manager

Responsibilities:

  • Led a Lean team of three DataStage ETL developers through three 4 week iterations to deliver healthcare records extracted from Epic Clarity and loaded into the Confidential for use by Cognos report developers.
  • Wrote SQL scripts to extract data from Clarity and the Confidential for transmission to external business partners. Set up scheduled inbound and outbound FTP transmissions.
  • Became familiar with Clarity data models for patients, providers, encounters, appointment scheduling, OR cases, flow-sheets and medications.
  • Mapped and identified gaps between the Confidential healthcare datamarts and the Epic Star / Business Objects Confidential and universes for identify, patients, providers, visits and immunizations. Built a couple of Cognos Frameworks and reports.
  • Managed a project to convert a financial Confidential front end application from Discoverer to Cognos
  • Extracted financial data from Oracle and the Confidential to be loaded into the budget system
  • Extracted data from the budget system to be loaded into Oracle and the Confidential
  • Built financial reports with IBM Perspectives
  • Administered the budget system user security

Confidential

Project Manager & Scrum Master

Responsibilities:

  • This project was to transform Confidential showrooms into Digital Showrooms by providing the capability to leverage interactive Selling Tools displayed on innovative Audio Visual technologies with Networks robust enough to support marketing artwork downloads.
  • As the Scrum Master, arranged a brainstorming session to capture the Epic stories associated with the future vision, built a product backlog, worked with the Global Sales team to prioritize the backlog and executed the first sprint.
  • As a Project Manager, assembled network health and bandwidth statistics for 26 key showrooms, investigated the Sales 2.0 software bandwidth requirements and provided those results to the Global Infrastructure team.
  • On behalf of the showroom future initiatives, built alliances between the Sales 2.0 software teams and the Digital Showroom team so that software enhancements could be tested on new AV technologies in the lab.
  • Encouraged Global Sales to partner with the Sales 2.0 Product Owners to align the showroom future initiatives with the Sales 2.0 enhancement roadmap.
  • Built audio visual partnerships with Western Europe, North America and Workplace Design Connectivity IT teams and established networking partnerships with Greater China, Emerging Markets and North America IT teams.

Technologies: Relay Project and Portfolio Management Center, VersionOne Agile Product Planning and Sprint Planning, Solar Winds Network Monitoring report analysis

Confidential, Portland, OR

Project Manager - Infrastructure

Responsibilities:

  • Responsible for managing (4) infrastructure projects.
  • 700-server Data Center build out outsourced to multiple vendors with VM and standalone servers, data replication and networking
  • Citrix upgrade and user migration
  • Citrix VDI servers build out and user implementation
  • Decommission old network cables, switches and routers
  • Responsibilities include working with vendor project schedules, tracking hardware purchases, maintain the budget, tracking labor, expenses, project metrics, approve contracts, project and change management, coordinate technical discussions and design approvals, and provide weekly status on milestones, deliverables, issues and risks to the Infrastructure PMO and project stakeholders.

Technologies: Network cables, firewalls, DMZs, circuits, routers and switches, Windows, Linux, AIX, HPUX, Solaris, Storage, Tape Backups, Symantec, VMs, Citrix, VDI, Active Directory, SQL Server, Oracle, TIBCO, WMS, SIMS and Freight Forwarding applications

Confidential, Portland, OR

Project Manager - Confidential

Responsibilities:

  • Developed a matured standard process for tracking work schedules, utilization, and demand management process
  • Assessed risk of delivery on time, quality and performed risk mitigation in delivering quality and timely product to the end-users
  • Coordinated day-to-day activities of multiple projects and team members in Portland, South Africa and India to ensure on-time delivery of ETL jobs and reports
  • Collaborated with Product Owners, Business Analysts, Data Analysts and Architects for timely delivery of technical specifications, data models, EDW & reporting design activities
  • Collaborated with the Freight Forwarding, Oracle Financials and other IT teams in delivering the reporting solutions to support their application reporting needs
  • Performed dependency and impact analysis as the DW / BI solution rollout was an integral part of a very large and complex global project and an overarching BI program
  • Prioritized and balanced the tasks, resources, and deliverables for an optimal delivery
  • Provided status reporting to Confidential PMO, Sr. Management and the sponsors
  • Ensured compliance to Confidential SDLC and Agile processes, in addition to demand management, CAB change management, methodologies, configuration management, etc.

Technologies: SQL Server Confidential, DataStage ETL, Cognos BI Tools that draw information from an in-house built Freight Forwarding application integrated with Tibco Master Data Management and Oracle Financials

Agile Product Owner

Confidential

Responsibilities:

  • Understood business needs, product roadmap, maintained the work backlog, prioritization, gathered requirements, managed expectations, negotiated trade-offs, monitored product value and quality, reported status
  • Co-ordinated with other product owners (1View) in delivering integrated DW solutions.
  • Acted as the conduit between the business and the Scrum Team, regularly engaging with both to translate and communicate business needs.
  • Worked with Product Owners from other teams to identify and align dependencies to ensure delivery of full end-to-end functionality expected by the business.
  • Identified and documented the business’ acceptance criteria for each feature requested. Ensured that code releases meet the acceptance criteria.
  • Ensured the backlog was groomed and met the definition of ‘ready-to-work’ prior to Release and Sprint planning activities.
  • Responsible for all Release Planning activities; scheduling, preparing, organizing, leading
  • Facilitated backlog grooming activities with the Scrum Team members. Helped identify and write user stories and acceptance tests. Ensured all items had estimates.

Agile Scrum Master

Confidential

Responsibilities:

  • Served the team by facilitating sprint planning, daily scrum, retrospectives and by resolving issues
  • Facilitated daily standup meetings.
  • Acted as the hub for internal and external communications, improving transparency and radiating information.
  • Worked with other teams to balance workloads, skills and commitments to ensure delivery of business value.

Project Manager

Confidential

Responsibilities:

  • Responsible for product delivery of backend Confidential structures needed to support Finance and Sales reports such as data modeling and ETL drawn from the custom built 1View Freight Forwarding and Tibco Master Data Management core software.
  • Responsible for the product delivery Corporate Financial and Sales Reports, Data Marts and Analytic Tools
  • Completed a 3-month project to deliver 10 financial reports before a major business milestone.
  • Responsible for managing demand for the Global Data Architecture and Reporting team

Confidential, Vancouver, WA

Project Manager

Responsibilities:

  • As part of the Infrastructure team, managed the delivery of 200 Windows 7 workstations to hospital Physicians, Nursing, Pharmacy and Informatics who were depending on McKesson core application software
  • Product delivery planning with the business to provide the right applications on the right workstation
  • Assessed the application inventory, determine business usage scenarios and identify workstation locations
  • Created the Project Confidential, Schedule, Budget and Resource Plan and ensured compliance with the Confidential SDLC processes.
  • Recruited 10 desktop service resources and 2 business analysts
  • Enterprise project dependency planning with project managers on McKesson core software upgrade project, Active Directory acquisition merge project, Cable and wiring project, a conversion to SCCM project for desktop software load automation and a print server project; all happening at the same time.
  • Purchased and provisioned $2M of desktop hardware and accessories for the project
  • Provisioned hardware for a VDI alternate solution to Windows 7
  • Tracked the Infrastructure desktop budget, managed assets and the receiving process for approximately 350 workstations.
  • Managed old hardware decommissioning

Confidential, Portland, OR

Project Manager

Responsibilities:

  • Managed a variety of IT projects from the Confidential through the Close following PMO, SDLC standards and CAB change management including budget responsibility.
  • Managed the delivery of 60 SQL Server databases consolidated on to one database server with 3-4 hardware environments. Created Confidential, scope, hardware budget and schedule. Coordinated server move events with the business, DBA’s and Infrastructure team.
  • Managed the decommissioning of acquired business applications and hardware. Procured new Unix and Windows hardware to support environments for the historical applications. Coordinated with the acquired business managers, their IT, our DBA’s and Infrastructure teams to move the old software and applications, print servers and file servers to the new corporate servers.
  • Took over a Business Objects Corporate Finance BI project during the build phase and led it through implementation.
  • Managed the delivery of a Business Objects, Oracle database, Linux and Windows patch implementation.
  • Took over a Lync Server pilot project that was failing, completed the pilot and provided the results options and costs to executive management. Worked with the vendor on Microsoft enterprise licensing options.
  • Created Enterprise Architecture Solution Designs such as SQL Server High Availability, server-decommissioning solutions, check processing solutions. Source Control, Fax solutions, etc.

Confidential, Salem, OR

Project Manager - Infrastructure

Responsibilities:

  • Managed 3 IT projects from the Confidential through the Close following PMO and SDLC standards and including budget responsibility.
  • Managed the delivery of a $2M Infrastructure project to consolidate4 0 UNIX, 50 Sun Solaris servers, one AS400 server into one IBM iSeries hardware platform and to consolidate and upgrade 20 Oracle database servers into another IBM iSeries hardware platform.
  • Product delivery planning with the state agencies; DAS, DOR, DOC, Legislature and others coordinate server move windows, software integration dependencies and identify firewall security rules.
  • Worked with the System Administrators and hardware vendors to configure and cost the new hardware. Prepared hardware procurement documents and expedited the DAS procurement process.
  • Created application architecture, integration and DMZ technical requirement drawings
  • Built a process for decommissioning the servers

Confidential, Tualatin, OR

Project Manager

Responsibilities:

  • Managed a variety of IT projects from the Confidential through the Close following PMO and SDLC standards.
  • Managed the delivery of data from an acquired telecommunications company that was converted and merged into the acquiring company’s databases.
  • Collaborated remotely with business and developers from both the acquiring company and the acquired company to coordinate events, arrange data mapping sessions, set up FTP data drop points and follow through with the schedule
  • Created the Enterprise software, database, hardware, integration diagram of the acquiring company
  • Worked together with six other project managers to identify application integration dependencies, the cutover chain of events and an hour-by-hour implementation schedule.

Confidential, Portland, OR

Systems Analyst

Responsibilities:

  • Seen as a trusted advisor to the Auto Insurance business users by active listening, understanding how reports fit into their business processes and providing training for sophisticated self-serve BI reporting tools.
  • Developed ETL mapping designs for integration with the Confidential
  • Wrote Oracle PL/SQL queries for verifying Confidential against report results
  • Created a report data element matrix and helped reconcile the common objects
  • Contributed to the design of a new security model for the MicroStrategy Business Intelligence tool
  • Created Visio wireframes for new .NET web interfaces

Confidential, Portland, OR

Systems Analyst

Responsibilities:

  • Created Oracle PL/SQL queries to compare and validate employee and payroll data received from the video stores.
  • Created technical design documents for three SQL development projects including data models and data flow diagrams.
  • Created functional requirements and process flow diagrams for a customer data cleanup project and a data integration project.
  • Created an end-to-end system test plan to integrate 20 different file types from 5 functional areas of an acquired business.

Confidential, Portland, OR

IT Staff Supervisor and Facets Software Implementation Project Manager

Responsibilities:

  • Product delivery planning with insurance Claims, Eligibility, Benefits, Enrollment business teams to implement a Facets core software application replacement
  • Responsible for day-to-day management tasks like performance appraisals, staff development, motivation, etc. Promoted fairness, transparency and respectful accountability with the developers by enabling them to make decisions about the work they are accountable for and involving them in the overall decision making process.
  • Managed the IT deliverables for the Facets core software from conception to system test following the SDLC standards
  • Wrote RFP’s and negotiated win-win solutions with software vendors during software evaluations for Job Scheduling, Database Performance & Monitoring
  • Effectively delivered oral communications and written documents on Strategy, Approach, Schedule and Resource Plans
  • Responsible for the master schedule and on 25 Facets integration sub-projects running simultaneously in the following technologies
  • Database environment build out
  • Business Objects - Facets reporting
  • Java - Web application conversion from mainframe to SQL Server and Facets integration
  • .NET - Facets enhancements
  • SQL- Data integration and printed output
  • HIPAA - Confidential and data integration
  • Responsible for up to 50 on-site and off shore application developers. Hired and balanced resources.
  • Key contributor to the Infrastructure hardware procurement of (2) IBM pSeries systems for hosting the SQL Server databases, a Blade Center on Citrix for the Facets applications and several other Windows servers, Business Objects, WebSphere, and other applications.
  • Created an enterprise level application integration drawing including all mainframe, database and application servers, integration points, server names operating systems, file transfers, reporting and web output
  • Focused on quality performance for the customer and ensured that solutions fulfilled the business requirements while responsible for design sign off on 25 Facets integration sub-projects running simultaneously in the following technologies
  • Database environment build out
  • Business Objects - Facets reporting
  • Java - Web application conversion from mainframe to SQL Server and Facets integration
  • .NET - Facets enhancements
  • SQL- Data integration and printed output
  • HIPAA - Confidential and data integration

Confidential

IT Staff Supervisor

Responsibilities:

  • Worked with business stakeholders and developers to identify business Confidential and BI reporting needs, maintain the work backlog, prioritize, gather requirements, manage expectations, negotiate trade-offs and report status
  • Managed the delivery of claims and eligibility to the Confidential and corporate reports
  • Product delivery planning with the HIPAA business team to deliver Confidential transactions in the new HIPAA format
  • Installed the DataStage TX Confidential enterprise application on both Window and Unix platforms
  • Gathered requirements, analyzed database integration, developed Confidential data transformation maps, FTP scripts, event workflow, job scheduling. Error handling and performance turning
  • Developed Sybase T-SQL database objects such as tables, views, stored procedures
  • Loaded claims and eligibility data into Sybase ASE and then to the IQ Confidential
  • Designed and maintained a Java application written to display HIPAA claims

Hire Now