Melissa Ladner Email & Phone Number

Calgary, Alberta, Canada

- Data conversion specialist handling data going from one system and/or schema to another- SQL exception statements, error logging/handling, running conversion processes, creating unit tests - Key duties include: creating automated scripts to take data from an older system, transform it as needed, and convert it into a new schematic for use in a newer system- Writing scripts that take out exceptions or errors and place them in a log for review after the conversion scripts have been completed. This includes determining what type of data anomalies, errors, or inconsistencies might exist in a given dataset - Running commands from Powershell, reading C# code, XML handing, and executing set-up on machines that run the automated conversion code- Full use of GitHub, Jira, Confluence, and other typical software development tools- Analyzing requirements to determine error logging, best scripting approach, project set-up, and other BA-like activities

Calgary, Alberta, Canada

Member of a multi-faceted team that handled development (scripting), task prioritization, and some business analyst duties. Selections of code, are used in a proprietary software, to create workflow solutions including:• SQL• Java (object oriented programming) • HTML/CSS• XMLScripting involved: • creating validations• doing data transformation• parsing or coding complex logic• building aspects of user interfaces• controlling user workflows and experienceOther tools used for communication, assignment, and work organization included: • Jira• Sharepoint• Microsoft TeamsOther duties included: • Handling prioritization of many requests, deadlines, and conflicting needs• Setting up testers with instructions, templates, and pathways to confirm pass/fail• Creating and updating Jira tickets for both larger project pieces (epics) to individual tasks inside each project, epic or helpdesk ticket• Taking bare minimum requirements and developing them into full-fledged user interfaces• Communication with executive, other developers, IT, and SMEs to manage expectations and discuss innovations to enhance client experienceEnrich Software specializes in trucking and fleet workflow software for desktop and mobile devices. Creating software that gives drivers the opportunity to check-in, administrators to find vehicles, and handle all aspects of booking, maintenance, breakdown, and every aspect of the trucking industry.

Calgary, Canada Area

Recognized Subject Matter Expert (SME) for data in: Infrastructure Applications, Statements of Concerns (SOCs), Stakeholder Engagement and the AER's new application system OneStop. Primary technical tasks included:● Corporate database queries (SQL)● ETLs for blending data & data warehousing● Fulfilling ad-hoc data requests (formats included Excel, Tableau, SQL query, etc)● Building & maintaining enterprise reporting (Tableau)● AER tools system and support (IAR (apps), CMS (audits), DDS (data submissions))● Testing of application development and data feeds (OneStop)● Data analysis and interpretation● Documentation in JIRA and ConfluencePrimary business analysis tasks included:● Triage and prioritization of requests. Often multi-tasking many requests at once● Gathering business requirements for data or reporting● Participating on project teams● Customer service team supporting business groupsThis position involved many projects at various levels. Some high profile projects I worked on included: ● reducing application timelines (red tape reduction)● clarifying process for statements of concern (internally & externally)● reporting on Indigenous engagement (Pathfinder project)● reclamation certificate dataWork with One Stop projects which included: ● new functionality testing (UI), including writing test cases● data fixes● data warehousing and blending data with legacy systems (ETLs & Tableau)● building and maintaining reports based on business requirementsResponded to many action requests from media, Government of Alberta, and other high profile organizations. Requests were often same day turnaround. They involved knowing the data regarding its: collection method, database location, integrity, definition, related processes, and industry use.

Calgary, Canada Area

A member of the Routine Authorizations - Operations department. Processing routine applications for pipelines, wells, and facilities.Continuous Improvement - Project Management (May 2015 - Jan 2016)● Set-up of goals, outcomes and anticipations for projects to internally improve processes● Take project from start to finish allocating for roadblocks, successes and time constraints● Implementation from project outcomes to meet corporate and team goals● Evaluating benefits at beginning and end of projects● Data collection, organization and evaluation in order to determine next steps for projects● Pilot testing for new ideas and software● Organized back-log application projects. Lead staff through process of resolving back-log applications, tracking progress, meeting deadlines and overall assurance that back-log project would meet prescribed corporate goalsApplication Processing● Application types include: self-disclosures, sweet or sour situations, gas plants, pipeline installations, injection facilities, satellites, batteries, and all other 'routine' application situations● Ensuring compliance to D56 of routine applications for wells, pipelines & facilities by reviewing all details of applications, ROWs, well surveys, PFDs, PIDs & PPNs● Reviewing ROW surveys & base maps for accuracy● Ensuring application does not have non-routine component (ie: waterbodies, spacing, objections, technical non-compliance concerns, etc.)● Liaising and documenting communications with industry (applicants) to request/confirm information● Closing & withdrawing applications as required

Calgary, Canada Area

A member of the Non-Routine Participant Involvement (PI) Authorizations team. Primary role was reviewing well, pipeline, and facility applications with statements of concern (SOCs). ● Technical review of non-routine PI (objections and concerns) for compliance with D56. Including applications for wells, pipelines and facilities (PFDs, PIDs, PPNs, surveys, ROWs, etc.)● Identifying non-routine components and referring to appropriate specialists● Supporting PI coordinators including reviewing: cover letter, statement of concern, response from industry, project explanation, and other objection concern documentation● Liaising with industry contacts (applicants) to request/confirm information ● Documenting all aspects of communication, application progress, and key milestone dates● Supporting coordinators at Statement of Concern Application Review (SOCAR) meetings as required● Continuing support to Routine Authorizations as needed when time allows. This includes all duties listed below as a processor in Routine Authorizations● Multi-tasking many applications and timelines concurrentlyThis position was a trial to see if having a processor on the NR-PI team was beneficial. Due to internal changes to procedures, new regulations, and insufficient work this role was disbanded and I returned to my previous role as Routine Processor as seen both above and below.

Calgary, Canada Area

A member of the Routine Authorizations - Operations department. On a team of approx. 9-11 members; working on routine applications for pipelines, wells & facilities.Selected to work on small projects within Operations department including; Land Use backlog, Confluence pilot program, self disclosures phase 2, and pilot testing for new or version updates to AER proprietary software. ● See description for Application Processing above for full job description

Calgary, Alberta, Canada

Contract position involved selecting, organizing, and writing the In Focus articles run in the New Home Living and Condo Living magazines. This was a telecommute position with a flat contract rate. ● Meeting deadlines (organization and prioritization) for publication● Communicating with corporate media departments, small business owners, and agencies to obtain information about trendy and relevant products ● Research and discovery current and upcoming trends in specific markets● Source and obtain high resolution images for print publication● Writing blurbs for photo-heavy magazine features

Calgary, Alberta, Canada

On a team of two staff handling regulatory submissions. Primary role to collect, validate and submit applications for construction of pipelines and facilities.Daily tasks included:● Balance workload, for multiple oil and gas companies, of regulatory submissions including: tracking projects (deadline requirements), obtaining asset specifications, and providing regulatory expertise to engineering● Compile and input data on applications for license submission of projects in Alberta and BC. Including submissions to (then ERCB) Alberta Energy Regulatory (AER) and British Columbia Oil & Gas Commissions (BCOGC)● Create all audit documentation. Responded to audit requests from AER● Historical data recovery & clean-up submissions to OGC for lost data (AsBuilts, LTOs, etc.)● Proficiency in AccuMap with plotting wells, facilities, pipelines & system area maps. Creating new maps via query & client provided data● Re-rating (calculations) for pipeline systems including changes of MOP, H2S, and substance● Maintain multiple spreadsheets & databases of projects, wells, gathering systems, etc.● Attend internal & client meetings discussing timelines and regulatory requirements for projectsSubmission types handled included: ● AER Direction 056 new & amendment license submissions (via DDS) for: o Pipelines; routine & non-routine (new, discontinued, abandoned) o Facilities; routine & non-routine (satellites, batteries, compressor stations)● Non-routine AER submissions included: noise non-compliance, environmental assessments, bitumen related heavy oil locations, and exempt locations● Alberta Utilities Commission (AUC), Alberta Transportation & Alberta Boilers Association (ABSA) applications● AER field notifications for Notice of Construction Start (NCS) & Notice of Pressure Test (NPT) via DDS● Code of Practice Water notifications for pipeline crossings (ESRD now known as Alberta Environment Protections (AEP)

Calgary, Canada Area

Sole Art Director and designer on a publication team of 6 (including editors and sales representatives).● Responsible for managing projects & designs for clients & in-house requests from start to finish● Data entry, ad tracking & administrative work related to ensuring everything is in the magazine● Created all magazine layouts & client ads for IMPACT Magazine● Photo manipulation & colour correction as needed● Put together photo shoots and organized on-site with models & photographers● Marketing materials for gala events & other promotional events. On-site organizer at events● Maintain a Joomla based large database website. Including posting articles, changing graphics & design, & administrative tracking of ads

Calgary, Canada Area

Sole Art Director and designer on a publication team (editors and sales representatives) of 5 people with occasional interns. ● Responsible for managing all projects and designs for clients & in-house from start to finish● Create all layouts & client ads for Where Canadian Rockies Magazine & Banff Resort Guide● Draw & edit over 20 maps in Illustrator for folding maps, notepad maps & other formats● Photo manipulation and colour correction for any project or layout● Produce & design brochures & other marketing material● Redesigned dining guide print publications & subsequently published each year● Built dining guide website templates from scratch. Coded with CSS & HTML● Created RMV Publications logo & worked on marketing strategies for both print & online to generate knowledge of the brand● Provide IT support for a small Mac-based network. Advised on purchasing software & hardware for the office while remaining mindful of budgetary constraints

Calgary, Canada Area

On a design team of 2-3 designers responsible for three major publications. ● Produced advertisements & layouts for three publications; Western Horse Review, Alberta Country & Northwest Business● Created media kits & promotion sheets according to sales needs● Supplied printers with press-ready files; proofed all pages & made changes as required

Calgary, Canada Area

Part of an international team of design & print specialists that ensured branding & marketing remained consistent for all locations globally. ● Responsible for printing, binding & shipping out all in-house printed books to all Canadian centers● Managed book orders as they came in & put into a priority queue for printing● Prepared shipping labels and customs documentation

Extension Certificate, Business Analysis

Business Analysis certificate with a focus on gathering requirements, project management, and data driven decisions. All concepts taught.

Bachelor Of Communications (Applied), Electronic Publishing

Activities and Societies: Student representative on committee to change Mount Royal College (MRC) to Mount Royal University (MRU)..