Karina Isabel De La Rosa Contreras

Karina Isabel De La Rosa Contreras Email and Phone Number

Data Visualization Engineer @ The Commonwell Mutual Insurance Group
Chestermere, AB, CA
Karina Isabel De La Rosa Contreras's Location
Chestermere, Alberta, Canada, Canada
Karina Isabel De La Rosa Contreras's Contact Details

Karina Isabel De La Rosa Contreras work email

Karina Isabel De La Rosa Contreras personal email

n/a
About Karina Isabel De La Rosa Contreras

• 15 years of combined experience in Business Analysis, Project and Software Development • OPG Security Clearance Approved• Domain and knowledge of Project Management Life Cycle methodology (PMLC)• Skilled in the Software Development Life Cycle (SDLC)• Experience in the implementation of document management systems and processes• Expert in Structured query language (SQL), data modelling, database design and highly experienced in optimization and performance tuning of databases.• Ability to understand, collect and interpret optimally complex business requirements, providing appropriate solutions and client support strategies to use in their business processes• 2+ years of experience working from home 100% of the time• Experience of working with high volumes of data • Strong work ethic and professionalism with good judgment, organized and time management skills • Critical thinking and excellent problem-solving skills• Decision making and negotiating skills with internal and external Customer• Experience to work independently and as a team member on multiple projects at the same time• A motivated and enthusiastic leader in achieving goals• Excellent interpersonal relationships and communication skills• Capability to learn quickly and enjoy the challenge• Bilingual fluency in English, Spanish

Karina Isabel De La Rosa Contreras's Current Company Details
The Commonwell Mutual Insurance Group

The Commonwell Mutual Insurance Group

View
Data Visualization Engineer
Chestermere, AB, CA
Karina Isabel De La Rosa Contreras Work Experience Details
  • The Commonwell Mutual Insurance Group
    Data Visualization Engineer
    The Commonwell Mutual Insurance Group
    Chestermere, Ab, Ca
  • The Commonwell Mutual Insurance Group
    Data Visualization Engineer
    The Commonwell Mutual Insurance Group May 2021 - Present
    Ontario, Canada
    • Support regulatory reporting requirements of IT and Business.• Generate, extract, and support the validation of insurance data required for the Market Conduct Survey - MCS using SQL scripting• Support the generation, analysis, and validation process of policy data for statistical reports in SQL, Regul8, and GISA• Analysis, design, and development of reports from the EDW ingestion process to the deliverables to the user using tools such as Azure Data Factory, SQL, Visual Studio, and Power BI• Generate monthly and weekly reports for the business area using SQL scripts• Recognition from the QA team for the documentation supporting the tickets developed by me
  • The Commonwell Mutual Insurance Group
    Data Analyst
    The Commonwell Mutual Insurance Group Jan 2020 - May 2021
    Ontario, Canada
    • Promoted to Data Visualization Engineer in a short time for exceeding goals and supporting company culture• Support the data migration project to the new software• Gather, analyze, and interpret information from Auto and Non-Auto lines to build the Data Marts• Create data mapping for Lines of Business, Claims, and Underwriting identifying data sources, fields, metrics, and detailed calculations in Pseudo Code• Support the gathering requirements and identification of data elements for the data mapping structure of the operations use cases• Support to different areas during the project such as QA, IT, Vendor• Design data dashboards, reports, and visualization for business areas, data transformation, VPs, and CEO in BI tools such as Qlik and Power BI• Design the data mapping with data elements and calculations of internal and external CMIG reports to support the Data Foundation project• Generate monthly and weekly reports for the business area using SQL scripts• Reduce monthly report generation time by 70% by using Excel Power Query • Lead the UAT tests for each of the Non-Auto lines, to support the project, achieving 100% Satisfaction
  • Ontario Public Service
    Application Analyst
    Ontario Public Service Mar 2017 - Feb 2018
    Oshawa, Ontario, Canada
    • Support in gathering project requirements for benefit programs in the OntTax application portfolio• Interpret different XML structures received, e.g. from CRA, and identify affected data structure of applications designed on .Net and databases in MS SQL Server to register them and contribute to the technical documentation development• Analyze, design, develop and maintain data models, workflows, presentations, reports, XML structures and PDM to support gathering requirements, other areas such as Information Technology (IT) architecture, update the knowledge base and to support different projects that are being boarded• Produce E-R models and data dictionary to support AIH documents and testing processes • Generate documents and training to share my knowledge IT tools with team members• Establish effective communications with the multifunctional teams of the organization, such as business, projects, IT & development, and IT architecture• Achieved a 100%+ satisfactory evaluation on my performance and contributions to the Cluster Applications Division, and demonstrated that I quickly learned with a full understanding of business processes and IT tools in-house faster than expected
  • Community Development Council Durham (Cdcd)– Welcome Centre Immigrant Services
    Systems Analyst / Developer
    Community Development Council Durham (Cdcd)– Welcome Centre Immigrant Services Aug 2016 - Nov 2016
    Ajax, On
    • Gather and analyze the requirements and/or user needs to design and implement a solution that allows the customer management (newcomers) and the activities performed in the CDCD• Develop a client/server IT solution under the SDLC methodology; developed in .Net with MS Access database and an administrative module to manage the DB• Implement the dynamic report generation in Excel to obtain statistics of the activities performed and clients attended to support decision making to promote, modify and/or implement activities• Build user manuals and train non-technical staff• Implement a project to centralize and make information available, increasing the quality and effectiveness of data and customer service by 50%, allowing optimal monitoring to continue supporting newcomers in adapting to their new life in Canada
  • Sistran
    Business Analyst
    Sistran Mar 2007 - Mar 2016
    Colombia
    • Gather, analyze, research and interpret technical and (functional) business specifications to provide the best IT solutions• Prioritize project delivery according to business requirements and criteria• Design and execute use cases, performance analysis, root cause analysis, project documentation update, and programmer technical requirements• Oversee the software product specification and systems design compliance at all checkpoints, UAT, performance testing, audit controls, Quality control (QC), and Quality Assurance (QA)• Research and analyze government regulations on financial IFRS-based information to provide consultancy service and technical support to clients and stakeholders (technical and non-technical advice)• Plan, design, develop, monitor, maintain and support the execution and implementation of new solutions or enhancements in existing applications with tight deadlines• Identify, analyze and control potential risks, based on risk management principles for solution delivery and execution• Support evaluation of vendor contract management for training and internal projects• Design, develop and implement Incident Management (IM) and Problem Management (PM) workflows in JIRA to administer and control services, issues and incidents on the Service Level Agreements (SLA) basis on each client• Lead, Implement and manage the QMS project under ISO 9001, establishing the quality policy creation, governance processes standardization, internal audits, external audit support, audit reports and continuous improvement to support the strategic direction and high business management• Reduced processing time by 66%, improving the quality, reliability, and integrity of client data for Govt compliance• Received recommendation letters from clients expressing 100% satisfaction with the quality of service provided in internal and external projects
  • University Enterprise Of Salamanca
    Systems Technology Instructor
    University Enterprise Of Salamanca Aug 2004 - Jan 2007
    Colombia
    • Coach new IT professionals in subjects such as algorithms, OOP languages, Databases and OS• Advice for changes in the training program in Operating Systems and Databases • Set up an initiative for teaching new technologies (e.g. Linux OS and open source tools)• Facilitated learning through different methods based on the principle of "learning to learn"• Managed new tools and methodologies as an aid to teaching
  • Ci Mercury Trader Ltda
    Software Engineer
    Ci Mercury Trader Ltda Oct 2002 - Mar 2004
    Colombia
    • Develop and implement export information systems for trade between Aruba and Colombia• Analyze, design, develop, implement and support software solutions in Filemaker, Visual Basic and MS SQL Server for Aruba• Generate and design test cases based on acceptance criteria • Developed user manual as a guide for industry users • Provided post-implementation support and training to end-users
  • Rey Fals Laboratory Clinic
    Systems Consultant / Business Systems Analysis
    Rey Fals Laboratory Clinic Jun 2000 - Jul 2002
    Colombia
    •Prepare user requirements and specifications specific to a big laboratory clinic•Managed and developed the project of systematization of the production process of the clinical laboratory using technological tools like Java, Linux and MySQL•Implemented a preliminary prototyping model as provisional solution to generate the final software•Developed test strategies to implement change process•Developed technical and general user guides and dictionary•The project has improving 20% the quality, effectiveness and efficiency in the process of clinical laboratory results which is applicable for 10 years from development

Karina Isabel De La Rosa Contreras Skills

Microsoft Sql Server Visual Basic Mysql Sql .net Xml Microsoft Project Methodology Pmi Atlassian Jira Software Development Life Cycle Sharepoint Ms Visio Scrum Iso 9001 Iso 27001 Cmmi Itil Delphi Filemaker Sybase Linux Uml Software Development Project Management Microsoft Office Databases Java Team Leadership Business Analysis Systems Analysis Microsoft Excel Power Designer Outsystems

Karina Isabel De La Rosa Contreras Education Details

Frequently Asked Questions about Karina Isabel De La Rosa Contreras

What company does Karina Isabel De La Rosa Contreras work for?

Karina Isabel De La Rosa Contreras works for The Commonwell Mutual Insurance Group

What is Karina Isabel De La Rosa Contreras's role at the current company?

Karina Isabel De La Rosa Contreras's current role is Data Visualization Engineer.

What is Karina Isabel De La Rosa Contreras's email address?

Karina Isabel De La Rosa Contreras's email address is kc****@****ran.com

What schools did Karina Isabel De La Rosa Contreras attend?

Karina Isabel De La Rosa Contreras attended Universidad Autónoma Del Caribe.

What are some of Karina Isabel De La Rosa Contreras's interests?

Karina Isabel De La Rosa Contreras has interest in Science And Technology, Education.

What skills is Karina Isabel De La Rosa Contreras known for?

Karina Isabel De La Rosa Contreras has skills like Microsoft Sql Server, Visual Basic, Mysql, Sql, .net, Xml, Microsoft Project, Methodology Pmi, Atlassian Jira, Software Development Life Cycle, Sharepoint, Ms Visio.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.