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.

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

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))

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

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

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.
• 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

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

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

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)..