Stefan C. Goga, B.Sc, M.Sc, P.Eng, PMP, SPOC
403-***-****, ado3c9@r.postjobfree.com, www.linkedin.com/in/goga-stefan
Project Management Business Analysis Data Science
Professional Summary
Multi-disciplinary experience and qualifications as a skilled Engineer and resourceful IT Professional who designs software solutions to directly help with engineering projects to bridge the gap between digital technology and technical practice. A customer-focused Business Analyst having the knowledge to understand and model business processes. A pioneer thought leader to devise Business Intelligence Reports and Analytics, document requirements and specifications, assess solutions to determine the required actions to streamline business, to enhance processes and procedures. A goal-oriented and engaging team Project Manager, passionate about technology and science, dedicated to deliver 21st century solutions through innovation and forward thinking.
Core Competencies & Qualifications
Product Management: full project lifecycle, Requirements Gathering, Development, Deployment, Implementation Presentations, Demos, Training
Project Management: Scope, Schedule, Budget, Quality, Resources, Communications, Risk, Stakeholder, Procurement, Change
Business Intelligence: KPIs, Dashboards, Reports, Analytics
Business Analysis: Assessment, Elicitation, Analysis, Monitoring, Evaluation, Documentation Design
Tools and Techniques: Interviews, Workshops, Gap Analysis, Process modeling, BPMN 2.0, Data modeling, RACI Matrix, Value Engineering, User Stories, Use Cases
Estimating, Prototyping, Prioritizing, Organizing, Coordinating, Facilitating
Aha, Jira, Confluence, Trello, Balsamiq, Miro, Azure DevOps; Agile methodologies
Bit Bucket, Team Foundation Server, Git, TurtoiseGit
MS SQL Server, T- SQL, SSIS, SSAS, SSRS
MS Access, MS Excel, MS Project, MS Visio, VBA
MS Power Apps, MS Power BI, MS Power Automate, MS SharePoint
Azure, AWS, GCP; Azure SQL MI, Azure Data Factory, Azure Data Explorer, Azure Data Bricks
XML, Json, HTML, JavaScript
Oracle, MySQL, SAP Hana, MongoDB
Relational, Object Based, Graph Databases
Technical Product Owner Current
Teck Resource Ltd., Calgary, Canada
Implement centralized enterprise-wide data hub, over 600 site to cloud pipelines, more than 0.5 Tb data per day, over 800 Tb in total. Devised unified layer, semantic layer, self-serve analytics services, data democratization, citizen developer empowerment. Establish data governance framework, data catalog using Colibra, data quality using Talend. Devised DataBricks as a Service solution to empower data engineers and data scientists to build solutions fast
Project Manager, Product Owner, Business Analyst 2016 - 2020
Resource Energy Solutions, Calgary, Canada
Prepared documentation for a government grant of 500k dollars. The grant was honored. The total budget for the project is over 10 million. The project is a Regulatory Compliance web-based application that supports multi jurisdiction rules and regulations
Managing the project teams of 30 multidisciplinary professionals. Teams are based in Canada, Mexico, Indonesia and India. Using self-organizing team Agile frameworks as Scrum, Kanban and Scrumban as well as scaled frameworks as Scrum of Scrums. Using Atlassian tools as Confluence to document requirements, Aha, Trello and Jira to devise the roadmap, organize and prioritize the projects, manage the sprints
Devised and executed groundbreaking architecture by building an engine to run BPMN schemas during a challenging time of consistent change with rules and regulations. As a result of the quick implementation of the new, dynamic and user-friendly system, each regulator can devise its own business process schema, task forms and reports in record time
Acknowledged as a domain expert, devised requirements for a web-based application for real time monitoring of well drilling and completion operations
Leading interviews with stakeholders, gather data and requirements, elicit and document specifications, build mock-ups and wireframes, prepare project scope dictionary and scope statement, devise project charter, roadmap, deliveries, milestones
Model business processes, devise KPIs and Dashboards using tools as PowerBI, ReDash, SAP Lumira, Python. Design and build reports in SSRS (RDL) or Visual Studio (RDLC)
Devise user stories, translate engineering and business requirements into technical terms, prepare sprint backlog, facilitate backlog refinement, daily standups, sprint retrospectives and sprint planning meetings, prepare burn up and burn down charts
Use different development techniques as test driven development and behavior driven development, continue integration and continue delivery pipelines. Implement different levels of testing as unit testing, automatic testing, user acceptance testing
Devise and maintain Stakeholder Register, Communication Matrix, Responsibility Assignment Matrix, Risk Register, Budgeting, Schedule, Quality Standards, Quality Assurance Methodologies
Investigate and decide on the database technologies to be used, relational, object based, columnar in memory or graph, depending on the business need and solutions’ particularities
Consultant - Business Analyst, Project Manager 2007 - Current
Orphan Well Association, Profoxx Energy Services, Journey Energy, Diamond Integrity, Ceilidh Environmental Ltd. – ongoing consulting, Calgary, Canada
Phase out current software applications and implement new solutions and processes as result of the business overgrowing the existing ones. Analyze current business processes, model processes using standardized BPMN definitions. Devise the data and information flow diagrams, model interfaces for business process systems and business process functions. Devise business process improvement redesign. Prepare documentation for RFP, review bids, choose the vendors. Manage the execution and implementation of the new solutions into the business process
Built Office 360 cloud application that integrate PowerApps, PowerBI, PowerAutomate (Flows), SharePoint, on premises databases using Gateways or on cloud through Common Data Services. Create connections with Excel on cloud through OneDrive, DropBox or SharePoint. Application used for assigning work to consultants, tracking progress, actual costs, AFEs
Streamlined the business processes by developing an Assets (Sites/Wells/Facilities/Pipelines) Data Warehouse Application. Devised discrepancy reports between different applications as CS Explorer, Qbyte, PVR, SAP or government data. Built SQL server agents for Daily and Monthly updates, e-mail delivery of reports or alerts. Designed meaningful PowerBI dashboards tailored for different stakeholders, built analytics that process and interpret large amount of data. Devised PowerApps applications mobile and portal, model-driven and canvas, Power Flows, connections with cloud or on premises databases, Excel files, SharePoint lists and forms
Reduced time considerably to receive Reclamation Certificates from the regulators by developing an Oil & Gas Sites Reclamation Application to implement a management of documentation and approvals, resulting in saving on levies and fees
Decreased the likelihood of pipeline failure by developing a Pipeline Integrity Application: field data collection through submittable forms (tablet, Excel or SharePoint), pipeline profile through google Elevation call, company summary or individual pipeline reports, Pipeline flow charts, networking, risk assessment
Improved the efficiency of Field Inspections by developing an application where the Inspections are taken using tablets and the data is then synced to the database. The Clients can see their inspected assets on a web-based application resulting in an increase from 1 to 5 inspections per day. The efficiency has improved considerably for pipeline right of way inspections, where a pipeline can be tens of kilometers long
Project Manager, Business Analyst Regulatory Compliance 2008 - 16
TERVITA Corporation, Calgary, Canada
Improved the effectiveness of Tervita and Client’s operations by devising ClearCompliance application, a Regulatory Compliance web-based software designed mainly to reduce Environment impact, improve personnel safety and increase resource conservation
Managed half of Alberta’s well population and maintained relationships with clients and liaised with the regulatory bodies
Provided expert advice on several projects to the Alberta Energy Regulator finalizing in changes to Digital Data Submission system as well as to the provincial rules and regulations
Business Analyst 2004 - 08
Alberta OIL and Gas Orphan Abandonment and Reclamation Association, Calgary, Canada
Streamlined the business processes and significantly reduced the work load of abandonment and reclamation coordinators by developing a Sites Management Application resulting in increased activity from approximately 50 wells to over 600 annually
Software Developer 2003 - 04
Web Design SRL., Ploiesti, Romania
Implemented CarTrack, a web application for tracking the vehicle fleet in real time on a map. Application was sold to the national electricity distributor
Business Analyst 1995 - 03
National Company of Natural Gas "ROMGAZ", Medias, Romania
Increased the personnel’s productivity by developing several key applications for Engineering, as calculation of wells’ gradients (pressure, fracture and mud weight) as well as graphical representation of such gradients
Pioneered expert solutions for wellsite automation, command and data acquisition systems and implementation, systems used for the real time observation of all drilling and geological data
Improved the productivity of design engineers by developing an application for dimensioning of natural gas distribution networks for steel and plastic pipes. This allowed to quickly design and construct the entire consumer gas pipeline network for 3 entire cities in record time
Education
Project Management Fundamentals Certificate
University of Calgary – Continue Education
Bachelor of Computer Science, Applied Informatics and Programming
Technical University of Cluj-Napoca, Romania
Master of Science, Reservoir Engineering
Oil and Gas University of Ploiesti Romania
Bachelor of Science, Drilling and Production (Oil and Gas)
Oil and Gas University of Ploiesti, Romania
Professional Certifications
APEGA – Professional Engineer
PMI – Project Management Professional
SCRUM – Professional SCRUM Product Owner; SAFe – Professional SAFe Product Owner
MICROSOFT – Professional Data Scientist, Azure Fundamentals
LinkedIn – Advanced Microsoft Power BI