PROFESSIONAL SUMMARY:

• Experienced Project Management Consultant, with demonstrated history of working in technology delivery focusing on Software, Business Intelligence, and Enterprise Data Warehousing solutions. Strong professional skills in Strategic Planning, Leadership
• Project Management and Process Improvement. Have strong analytical skills with a proven ability in managing people to work in challenging situations and delivering solutions with a commitment to high stands and team collaboration.
• Most recently as an AIM Consultant at Alaska Airlines, I led the Data Services team to integrate Virgin America with Alaska Airlines’ Enterprise Data Warehouse post - acquisition. Also helped transition the team from Waterfall to Agile Scrum project execution.
• While at Microsoft, led a development team in the implementation of a data mart for Supply and Demand Capacity Management.

TECHNICAL SKILLS:

Project Management & Collaboration: MS Project, TFS, VSO, JIRA, SharePoint

Database: MS SQL Server, Oracle, MySQL, Teradata

Data Modeling & Process Modeling: Visio, ERwin Data Modeler

Data Analysis & Reporting: SQL, SSAS, SSRS, Power BI, Excel, Hyperion Interactive Reporting, MS Office Suite, some Tableau

Programming / Scripting: T-SQL / SSMS, PLSQL / TOAD, R, some C#

Functional Expertise: Project/Program management, Change Management, Agile Methodologies, Business Intelligence, Data Analysis & Reporting, Business Process Improvement, Business Analysis, Lean Quality Improvement, Software Development Life Cycle (SDLC) and QA/Testing

PROFESSIONAL EXPERIENCE:

Confidential, SeaTac, WA

Sr. IT Project Manager

Responsibilities:

• Leading the Data Services team cross-company collaboration effort to integrate Alaska Airlines and Virgin America data source systems into the Enterprise Data Warehouse.
• Quickly ramped up to fully understand the complexities of the Business and Functional flow of Alaska’s data systems.
• Introduced the team to Agile Scrum project execution using VSO to ensure that the team is functional and productive, which led to more work being completed and increased business value.
• Manage programs and projects to design, develop, test, and implement new systems as well as enhancements.
• Provide support for company projects that involve coordination between various groups both within divisions as well as across divisions and multiple vendors.
• Coordinate and lead discussions between Business and SMEs for Business changes, and help business set priorities and roadmap development.
• Monitor project schedule and progress to ensure projects are completed on time and fulfill the objectives of the project charter. Communicate program and project status to participants and stakeholders in writing as well as in formal presentations.
• Organize meetings with various work teams to collect and disseminate project information, plan and schedule tasks and resources, generate timelines, and structure a process for consensus and individual commitment for deliverables.
• Identify and communicate any unresolved problems or possible timeline issues along with recommended actions for correction. Track project issues and risks.
• Partnering with the teams to define QA/UAT testing requirements.

Confidential, Redmond, WA

Lead Consultant/ Sr. Project Manager

Responsibilities:

• Led requirements gathering effort in coordination with source system owners and other stakeholders to document business requirements.
• Performed basic research of processes, applications, systems and data to support identification of functional requirements for application or system design.
• Evaluated multiple data source systems using SQL and Excel to perform detailed analysis and data profiling that helped to improve consistency across all data quality initiatives.
• Managed offshore delivery team to implement a data mart solution, using Microsoft BI technologies (SQL Server, SSIS, SSBI Tabular Model, SSRS, Power BI, and Excel).
• Assisted in the development and execution of tests cases & scenarios to validate system functionality against specifications.
• Managed project plan, scope, schedule, and reported status, issues, risks, and escalated as appropriate.

Technical Program Manager

Confidential

Responsibilities:

• Managed all aspects of the project throughout the development lifecycle, including project scope, schedule, resources, quality, and change.
• Work closely with stakeholders and to define project parameters, then translate customer needs into formal requirements, using knowledge of the industry and delivery methodology.
• Interfaced with all areas affected by the project, including end users, Operations, vendors and the engineering team to ensure the Confidential of servers and performance measurement of Azure IaaS VMs against On-Premise servers.
• Evaluated the impact of migration to business functions and upstream/downstream applications. Provided feedback for any issues to the team and escalated as appropriate.
• Completed compliance check documentation for application, code quality, and security.
• Established plan for technical support request for tier 1, tier 2 and tier 3 escalations.
• Provided organized and timely management of project communications/meetings, dependencies, action items, issues and risks.

Confidential, Redmond, WA

Sr. Project Manager

Responsibilities:

• Led the entire software development lifecycle including requirements gathering & analysis, design, development, testing, and acceptance.
• Led discussion with internal customers and vendors to develop detailed project plan.
• Led the team’s Agile development process via Scrum Master role and maintained the product backlog and scrum board in TFS.
• Planned and coordinated work with data source system owners and data scientists to gather and prepare data sets used to train and validate various predictive models.
• Facilitated UAT and end-user sessions to support adoption and usability.
• Provided support in developing the product vision and roadmap for new features and enhancements that improve overall product design & development.
• Owned stakeholder communication, developed management plans, analyze risks, and work with the teams to mitigate subsequent issues.

Confidential, Seattle, WA

Senior Consultant

Responsibilities:

• Perform basic research of processes, applications, systems and data to support identification of functional requirements for dashboard and report creation.
• Assisted in the development and execution of tests to validate system functionality against specifications.
• Drove the Business requirements gathering and wrote functional requirement specifications that describes business metrics, data sources-to-target mapping and transformation rules.
• Profiled and analyzed source system data to ensure that the data quality is sufficient to support the business purpose.
• Developed and deployed executive dashboard/Reports that provided insight into key business metrics using SSRS.
• Created presentation of materials and project communication plan for end users.

Sr. Business Intelligence Analyst

Confidential

Responsibilities:

• Analyzed current state business processes for resolving payments and dispute claims made by vendors, identified areas of process improvement, and automated manual processes to create timely and reliable reports.
• Coordinated with various functional groups to elicit requirements using interviews, use case analysis, document analysis, and workflow analysis to create current and future process flow.
• Provided root cause analysis affecting key processes, identified areas of inefficient manual processes that are error-prone, and highlighted winning strategies for improvement activities.
• Worked with EIT team to get access to source systems (MS SQL & Teradata) to drive requirements for the data needed for reports
• Developed a central data repository that periodically syncs with the dispute claim process application to show most up-to-date payment of claims.
• Developed a core set of decision support metrics, standardized reporting environment and data visualization leveraging Microsoft SQL Server Reporting Services (SSRS).
• Planned and directed all work activities leading to the delivery, and acceptance of project deliverables. Reported results, status, issues, risks, actions being taken, and any escalations to the project sponsor and stakeholders

Confidential, Seattle, WA

Senior Consultant - Business Intelligence

Responsibilities:

• Responsible for leading the offshore development team to design and implement enhancements for Volume Licensing Data Warehouse that consolidates data from multiple disparate source systems and distributes data to multiple repository servers used by downstream applications for analytics and reports.
• Participated in Joint Requirement Analysis sessions with other analysts, solution managers, and program manager to clarify and validated business requirements and understand project objectives, scope, and deliverables.
• Analyzed source systems to assess business impacts of the changes/enhancements to upstream/downstream applications
• Wrote functional and non-functional specifications used as by development team to document technical requirements for the solution.
• Served as a key point of contact between the business stakeholders and development teams to clarify requirements in all phases of the project.
• Created comprehensive project plans; project schedule, resource estimates, project status, and directed corrective measures to ensure project success.

Business Systems Analyst

Confidential

Responsibilities:

• Primary responsibility was to document UI components, Content & Content Management functional requirements needed to implement a centrally hosted, self-service Confidential destination for scorecards and reports.
• Created Use Cases/Scenarios, Event Diagrams, Workflows, and Data flows
• Document UI navigation components, Content & Content Management requirements
• Worked with the product owner to breakdown Epic/feature requirements and created User Stories & acceptance criteria.
• Maintained requirement traceability from business requirements through development and test requirements.
• Prioritize deliverables, estimated work effort, determine key milestones and provide weekly status reports.

Business Analyst

Confidential

Responsibilities:

• Responsible for extracting and consolidating Confidential data to perform supplier-spend analysis and identify cost saving opportunities for vendor selection across five business groups with different IT initiatives.
• Extracted huge amount of data from data source repository and merged data using Excel
• Performed analysis using Excel V-Lookups and Pivot tables and created reports to support business decisions.
• Presented key finding to senior management and made recommendations for cost saving opportunities.

BI/Functional Analyst

Confidential

Responsibilities:

• Responsible for partnering with business stakeholders to analyze business requirements and create functional and technical specifications for data integration effort to tie data from a variety of source systems across Confidential .
• Created data source-to-target mapping that provides dimension attributes’ definition, metrics calculation, and business rules’ transformation
• Analyzed and validated logical data models relating to multiple subject areas against source systems data requirements.
• Worked with the developers to provide clarification and guidance during the implementation phase.
• Wrote test scripts to validated acquisition data against integrated data QA.
• Validated taxonomy changes and developed business data dictionary and wiki to support ad-hoc and pre-built reports.

Confidential, Edison, NJ

Business Intelligence Analyst

Responsibilities:

• Worked closely with Product, Sales and Marketing teams to gather requirements and define data needs for business metrics and reports.
• Extracted, transformed, and loaded data from a wide variety of data sources to support business analysis and reporting.
• Owned the design, development, and maintenance of managed reports and dashboards using Oracle Hyperion Interactive Reporting to drive business insights.