Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
OTHER EXPERIENCES
EDUCATION & TRAINING
Timeline
Generic

Liena Capin

Mississauga

Summary

do not list years of experience.

For over12 years, Liena Capin has been working in the field of data analysis and engineering. She holds a bachelor's degree in Mathematics and a diploma as a .Net Developer. Liena has acquired a vast experience in the data world and excels at data integration, data pipelines, data warehouses, datasets for business intelligence (BI), data analysis, and business processes. As a hybrid technical professional, she integrates many career identities together and often wears different hats to accommodate multiple projects' needs. She has developed her skills in front-end and back-end applications. She uses her knowledge to develop custom solutions to increase Indellient's clients' productivity. She is very adaptive to fast changing and unfamiliar environments. Her work is very thorough and embraces learning new technologies with positive attitude. Liena stands out for her analytical and creative mind. She ensures to have a fundamental understanding of the “bigger picture” (the project objective, life cycle and what value it brings to the customer) and takes ownership of moderate to large projects. She possesses superior verbal and written communication skills with team members, customers and stakeholders. Customer satisfaction is her priority. She balances well multiple projects and assignments at one time. She delivers high quality work for all her projects. Liena does an excellent job of prioritizing work and ensuring deliverables are met. She includes team members in important discussions where there are dependencies on data projects. She is always willing to help out other employees and held resolve issues or meet deadlines.

Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.

Knowledgeable [Desired Position] with robust background in data architecture and pipeline development. Proven ability to streamline data processes and enhance data integrity through innovative solutions. Demonstrates advanced proficiency in SQL and Python, leveraging these skills to support cross-functional teams and drive data-driven decision-making.

Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.

Experienced with designing and optimizing data pipelines to ensure seamless data flow. Utilizes advanced SQL and Python skills to create and maintain robust data architectures. Track record of implementing scalable solutions that enhance data integrity and support informed decision-making.

Adaptable professional with background in developing and maintaining data systems within collaborative environment, seeking to transition into new field. Developed skills include data analysis and process optimization. Proven ability to drive impactful changes through data-driven insights.

Offering highly analytical mindset and passion for leveraging data to solve complex problems, eager to learn and grow within dynamic team. Brings foundational understanding of data systems and database design that can be quickly developed through hands-on experience. Ready to use and develop skills in SQL and Python in [Desired Position] role.

Results-oriented achiever with proven ability to exceed targets and drive success in fast-paced environments. Combines strategic thinking with hands-on experience to deliver impactful solutions and enhance organizational performance.

Innovative technology professional with several years of diverse experience. Skilled in enhancing systems and aligning technical solutions with business objectives. Proven success in leading projects from start to finish and contributing to organizational growth and success.

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Tech-savvy innovator with hands-on experience in emerging technologies and passion for continuous improvement. Skilled in identifying opportunities for technological enhancements and implementing effective solutions. Adept at leveraging new tools and methods to solve problems and enhance productivity. Excels in adapting to fast-paced environments and driving technological advancements.

Thorough team contributor with strong organizational capabilities. Experienced in handling numerous projects at once while ensuring accuracy. Effective at prioritizing tasks and meeting deadlines.

Detail-oriented individual with exceptional communication and project management skills. Proven ability to handle multiple tasks effectively and efficiently in fast-paced environments. Recognized for taking proactive approach to identifying and addressing issues, with focus on optimizing processes and supporting team objectives.

Demonstrates strong analytical, communication, and teamwork skills, with proven ability to quickly adapt to new environments. Eager to contribute to team success and further develop professional skills. Brings positive attitude and commitment to continuous learning and growth.

Possesses versatile skills in project management, problem-solving, and collaboration. Brings fresh perspective and strong commitment to quality and success. Recognized for adaptability and proactive approach in delivering effective solutions.

Pursuing full-time role that presents professional challenges and leverages interpersonal skills, effective time management, and problem-solving expertise.

Proactive and goal-oriented professional with excellent time management and problem-solving skills. Known for reliability and adaptability, with swift capacity to learn and apply new skills. Committed to leveraging these qualities to drive team success and contribute to organizational growth.

Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level [Job Title] position. Ready to help team achieve company goals.

Equipped with strong problem-solving abilities, willingness to learn, and excellent communication skills. Poised to contribute to team success and achieve positive results. Ready to tackle new challenges and advance organizational objectives with dedication and enthusiasm.

Experienced leader with strong background in guiding teams, managing complex projects, and achieving strategic objectives. Excels in developing efficient processes, ensuring high standards, and aligning efforts with organizational goals. Known for collaborative approach and commitment to excellence.

Recent graduate with foundational knowledge in [Area of study] and hands-on experience gained through academic projects and internships. Demonstrates strong teamwork, problem-solving, and time-management skills. Prepared to start career and make meaningful contributions with commitment and drive.

Dynamic individual with hands-on experience in [Area of expertise] and talent for navigating challenges. Brings strong problem-solving skills and proactive approach to new tasks. Known for adaptability, creativity, and results-oriented mindset. Committed to making meaningful contributions and advancing organizational goals.

Results-focused data professional equipped for impactful contributions. Expertise in designing, building, and optimizing complex data pipelines and ETL processes. Strong in SQL, Python, and cloud platforms, ensuring seamless data integration and robust data solutions. Known for excelling in collaborative environments, adapting swiftly to evolving needs, and driving team success.

Positive, analytical problem-solver with strong foundation in data systems and processes. Possesses solid understanding of data modeling and database design, coupled with skills in SQL and Python. Capable of driving data-driven decision-making and improving data infrastructure.

Detail-oriented [Job Title] designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Data Engineer

Indellient - Levio
  • Blue Relay data project
  • Responsibilities:
  • Revision of requirements and knowledge transfer of the BR project documentation, diagrams, materials, queries, database schemas, database tables, current reporting tool CubeJS and other insights
  • Research of a new ELT software solution(s) that fulfills the requirement of daily faster data loads and calculations as compared to the current reporting tool CubeJS
  • Review BR public schema tables and create queries that flattens workflow's data
  • Create queries that provide KPI meaningful and analytical information about the workflow's activity, avg workflow completion time, workflow's task duration comparison, etc
  • EKO data project
  • Responsibilities:
  • Designed a file management structure in AWS S3
  • Creation of Amazon Athena tables/views based on data sources on S3
  • Coding python scripts in AWS Jupiter Notebooks for data cleaning and transformations
  • Opimian BigCommerce project
  • Responsibilities:
  • Designed a Logical Model Diagram which described the process flow of Opimian
  • Converted business requirements into workflow diagrams at business level
  • IBM GCLM data project
  • Responsibilities:
  • Implementation of GCLM integration for Mexico invoices into IBM system
  • Responsible for different phases of the project: Data discovery process, field mappings, table creation, query and views design
  • Responsible for troubleshooting bugs and various issues reported through IBM ticketing system
  • Environment: db2, SQL, Jira, DbVisualizer
  • GGA Partners data project
  • Responsibilities:
  • Developed Data Model/Elastic Cube in Sisense for GGA Partners
  • Created Amazon S3 Buckets to continually add new trial balance csv files when collected and formatted by client
  • Set up a stream in Amazon Athena by creating tables that point to the data in existing S3 buckets
  • Created a Glue Data Catalogs database where all Amazon Athena metadata tables reside in
  • Set up Athena connection settings for every existing table in Amazon Athena
  • Set up Sisense data connector to Amazon Athena
  • Set up Data Security Rules to limit the dashboard to a subset of data (through SQL filter on data retrieval to the dashboard) for each user who views the dashboard
  • Developed Income Statement and Balance Sheet dashboards
  • Created technical and business language Documentation for the project
  • Environment: Amazon S3, Amazon Athena, AWS Sisense, Glue Data Catalogs database, Sisence, Atlassian, EXCEL
  • OSG Financials data project
  • Responsibilities:
  • Implemented changes to OSG Great Plains (GP) billing data ingestion process to onboard new entities and transition existing entities billing ingestion process to pull data from GP MeM
  • Implemented various automated processes that facilitated the generation of revenue and billing reports for executive data analysis:
  • O Modified DimensionLoad ingestion process to handle the data load for GP MeM entities
  • O Onboarding and integrating Optimal Billing and Analytics data
  • O Calculating Volume KPI metrics for Optimal Billing and Analytic data
  • O Onboarding and integrating PowerMail Billing data
  • Updated queries embedded in the SSIS workflow
  • Tested and Deployed implementations to UAT and Prod Environments
  • Managed project version control with GitHub repositories
  • Created technical and business language Documentation for the project
  • Produced various estimates for project changes
  • Mentored and transferred knowledge to onboard OSG's new contracting company into the existing projects developed by Indellient
  • Environment: SSIS, SQL Server, GitHub, Atlassian
  • Perfect Output data project
  • Responsibilities:
  • Fixing and Updating MicroStrategy Reports
  • Implementing an automated Meter Reads process to ingest and process customers data that increased10% of productivity which meant saving16.3% of man-hours per week
  • Implemented automated processes in SSIS and SQL Server that saved5% of man hours daily:
  • O Implementing an automated Sprint Retail Invoices process to ingest and process customers data Queue Builds process that exports shipped device information daily from the central depot into csv files
  • O MAC Clone process that inserts daily shipped device information into the MAC Table from the central depot
  • O Implemented project changes where additional scenarios had to be included for a new type of shipped files with UNKNOWN source location of devices
  • Environment: SSIS, SQL Server, MicroStrategy
  • ASCO data project
  • Responsibilities:
  • Converted business requirements into functional and technical requirements
  • Implemented a warehouse solution with an actionable and insightful dashboard for their business analytics empowering them with the right revenue performance indicators
  • Designed Data Discovery templates to present to the client, that would be used to better understand the data relationships they have
  • Designed and Implemented Data Models for3 complex dashboards
  • Created a Data Dictionary using the Azure Data Catalog
  • Created technical and business language Documentation for the Dashboards ETL Process in SSIS
  • Designed and Implemented a Revenue Dashboard ETL Process in SSIS
  • Environment: SSIS, SQL Server, Azure Data Catalog

BI Designer

Indellient - Levio
01.2017 - Current
  • KHP data project
  • Responsibilities:
  • Revision of requirements and knowledge transfer of the KHP project documentation POC, diagrams, materials, previous Power BI reports and other insights
  • Design of Data Model Diagram for Social Media Data to be scrapped from6 platforms using SPOTIFY
  • Creation of tables and views in Microsoft Azure Data Bricks
  • Creation of Elastic Cube in Sisense
  • Creation of Sentiment Analysis Dashboards to uncover trending statistics

Data Analyst

Indellient - Levio
04.2017 - 10.2018
  • Law firm prospect
  • Responsibilities:
  • Data Fabrication for a POC contributing to close a deal with a new client
  • Environment: EXCEL, Dundas BI
  • IBM Reporting and Dashboard Authoring project
  • Responsibilities:
  • Implemented the front end of a complex Cognos Dashboard Balanced Scorecard for BPRM projection extremely short deadline
  • Created new and enhanced ACCENT Project Reports in terms of performance, layout and features
  • Refactored Certification Reports from Cognos10 to Cognos Analytics V11
  • Troubleshooting problems as reported and managed production issues and tickets
  • Loading of data files as required on a weekly and ad hoc basis
  • Environment: IBM Cognos10+, Cognos Analytics11, Dundas BI

Data Analyst

HNHB Community Care Access Centre
01.2016 - 01.2017
  • Ministry of Health data management service
  • Responsibilities:
  • Performed ETL operations in relational databases
  • Analyzed raw data to find patterns and insights within structured and unstructured data
  • Configured databases ensuring integrity and consistency of data
  • Queried databases Identifying issues and gaps
  • Provide regular extracts to the Ministry of Health and approved external Integrated Data Stores (IDs) compiled from the applications' databases and related systems in use
  • Supplied timely and accurate reports/statistics for all levels of staff and/or create ad hoc reports, utilizing the HNHB BI Platform
  • Prepared statistics for administrative and performance reports for scheduled reviews
  • Perform enhancements to reports and related systems, providing conclusions and recommendations based on the data
  • Manages data integrity at a business process and technical level; identifies and remedies software and design errors; and recommends solutions for any errors; test data conversion from existing systems; generates reports and statistical analysis
  • Environment: SSIS, Power BI, SQL databases

IT Consultant

VENA Solutions
01.2013 - 01.2016
  • Vena Product for Corporate Performance Management (CPM) services
  • Responsibilities:
  • Collaborated closely with client stakeholders to implement the Vena product from end-to-end
  • Gathered business requirements from the clients and implemented business rules to transform and load data gathered externally as well as within the application
  • Assisted in project planning responsibilities including development of project plans, business requirements, functional specifications, and reporting on project deliverables
  • Built and tested complex templates and reports based on client specifications and imbedded required functionalities
  • Built OLAP databases including dimensionality, calculations, automation, and optimization requiring very complex calculations and difficult performance tuning
  • Performed ETL operations in both OLAP and relational databases
  • Created reports using analytics of Vena software as a part of the product implementation
  • Created re-useable processes using SQL stored procedures, functions, SSIS Packages, and automated data loads using SQL Jobs
  • Created VBA applications as imbedded functionalities of the product implementation
  • Created scripts to perform calculations using a VenaLisp programming language
  • (A new domain-specific language embedded in Common Lisp)
  • Environment: Vena Product, SQL and OLAP databases, Lisp scripting language, EXCEL, VBA Automation

Data Modeler / Software Developer

American Gaming Systems (AGS Toronto)
03.2012 - 08.2012
  • Slot machines, video poker games
  • Responsibilities:
  • Implemented and enhanced software code of math simulators in C# (Visual Studio2012)
  • Performed SQL queries to test background functionality using SQL2012
  • Developed VB Applications (macros) in Excel using VBA Automation
  • Debugged errors and tested software code
  • Researched and synthesized data, math releases and updates of games
  • Researched simulation results to determine frequency of game features, verify performance and calculate Volatility Index of games
  • Performed statistical analysis and maintained mathematical model based on corporate directives
  • Prepared relevant mathematic information for presentation needs, executive review and compliance requirements
  • Performed math verifications, statistical analysis of Spreadsheets, PAR Sheets (pay tables, reel strips) and Charts
  • Environment: C #, SQL, EXCEL, VBA Automation
  • Environment: Team foundation Server (TFS) and Bugzilla

Education

.NET Developer Program -

Humber College
Toronto, ON
01.2012

B.Sc. - Mathematics

University of Havana
01.2005

Skills

  • Data Analysis
  • Rapid Skill Acquisition
  • Goal-Oriented Approach
  • Spanish Fluency
  • Analytical Problem Resolution
  • Great communication, mentoring and team player
  • Experience with statistical analysis tools (R, MATLAB, SPSS)
  • Knowledge of computer languages (Python, C#, VBA, Lisp, AWS Glue)
  • Report and dashboard authoring (SSIS, Sisense, Power BI, Dundas BI, Cognos Analytics)
  • Design of Data Warehouse, Elastic Cubes and ETL integration process development (SSIS, SQL Server, Amazon S3, Amazon Athena, AWS Sisense, Glue Data Catalogs database)
  • ETL development
  • Data warehousing
  • Data modeling
  • Scripting languages
  • Data quality assurance
  • Data integration
  • SQL and databases
  • SQL programming
  • Data analysis
  • Relational databases
  • Data analytics
  • Analytical thinking
  • Problem-solving
  • Teamwork and collaboration
  • Interpersonal communication
  • Requirements gathering
  • Excellent communication
  • Key performance indicators
  • Organizational skills
  • Time management

Accomplishments

  • Documented and resolved [Issue] which led to [Results].
  • Achieved [Result] through effectively helping with [Task].
  • Resolved product issue through consumer testing.
  • Used Microsoft Excel to develop inventory tracking spreadsheets.

Certification

IBM Certified Designer - IBM Cognos Analytics Author V112019

OTHER EXPERIENCES

  • Institute of Computer Science, Mathematics and Physics (ICIMAF)2006 -2011
  • Data Modeler / Software Developer

EDUCATION & TRAINING

Various courses and self training for AWS Developer Associate Certification (In progress)2021

Timeline

Data Analyst

Indellient - Levio
04.2017 - 10.2018

BI Designer

Indellient - Levio
01.2017 - Current

Data Analyst

HNHB Community Care Access Centre
01.2016 - 01.2017

IT Consultant

VENA Solutions
01.2013 - 01.2016

Data Modeler / Software Developer

American Gaming Systems (AGS Toronto)
03.2012 - 08.2012

Data Engineer

Indellient - Levio

B.Sc. - Mathematics

University of Havana

.NET Developer Program -

Humber College
Liena Capin