Ernest Pachonick

Ernest’s Profile:

Senior SQL Developer, Power BI Developer

Data Analyst, Data Engineer, BPMN Engineer

Ernest's Essential Skills Summary:

C#, SQL Server Database Development, SSRS, SSIS, T-SQL, Power BI Reporting (DAX) & Data Analysis, BPMN Work flow Design, BPMN Development and BPMN Systems Integration, SQL Stored Procedures and Functions, Schemas Design. Automation and Analysis of Business Processes, Microsoft Azure, Active Directory (MS Graph). Experience in all aspects of the Development Life Cycle (SDLC). Strong Analytical and Problem-Solving skills. AGILE Development applying SCRUM and JIRA as an Agile Project Management Tool. Experience working with Enterprise Software Architectures and Design Patterns Planning, Designing and Developing new Features and Functionality for Software Solutions. Source Control (Team Foundation Server, Apache Subversion (SVN). ETL and Data Analysis on Data Warehouse and Data Mart data Design. SQL Server Integration Services (SSIS), Business Intelligence (Power BI), SQL Server Reporting Services (SSRS), Microsoft Excel (Data Analysis), Data Warehouse Schema Design.

Ernest is a SQL Database Developer, Power BI Report Development AND Data Analyst, with more than 25 years of experience, including International Work Experience.

Ernest has worked in different Organisations and Industries, as an Individual Developer or in Development teams in various other countries (UK, New Zealand and the Netherlands).

He has strong SQL Development and Analytical skills with a Proactive and Agile mindset.

He has Extensive Proficiency in working in teams and how to translate a business

problem into a technical solution. 

Ernest is always developing his Skills Set and has a resilient ‘Getting Things Done’ mentality while focusing on Quality.

Ernest’s Professional Profile Comprise SQL, T-SQL, SSIS, SSRS, ETL, Power BI, Business

Process Analysis, Data Analysis, Power BI Report Development and Systems and Data

Integration and Analysis. With 25 years of IT programming experience in building

complex software applications, within various industries, including Investment Banking,

Financial Markets, Insurance, Accounting, Retail and Manufacturing.

The following Qualities describes Ernest’s Professional Working Approach:

Analytical Approach, that proofs him to be a good Planner with a Proactive and Agile

Mindset with a Hands-On and Can-Do mentality.

Personal Result Driven and Quality Driven Approach with every new Project.

Good Verbal and Written Communication in English and is also a great Team player with

the Ability to work Independently.

Experienced in working both in a project-based Environment and according to the

BusDevOps Agile Scrum Methodology with Fortnightly JIRA Sprints.

Extensive Experience in Designing and Developing Databases, Developing Reports and

SSIS packages. Ernest is Independent, Cooperation-Oriented, Entrepreneurial, Team

Player, Pleasant to deal with, Innovative, Result-Oriented and Customer-Oriented.

High Level of HBO Working and Thinking level with Problem-Solving skills.

Oversee complex data flow structures and needs to be experienced with large

data volumes. Analysis of Business Processes and the Translation thereof into Automated

Work flow Processes.

Senior level of experience in the following:

Microsoft Power BI Development.

DAX Queries, Functions in Power BI.

Microsoft SQL Server Database Development.

SQL Server Analysis Services Development (including MDX).

SQL Server Reporting Services Development.

Setting Up and Configuring new Power BI enterprise gateways and scheduling reports.

Deploying Power BI reports to Gateways (workspaces, capacity settings, user permissions configurations, data refresh interval config, ect.)

SQL Server Integration Services Development.

General Warehouse Design Principles (Changing Dimension/ Reference Dimension/ Fact Dimension/ ETL Design).

Microsoft Visual Studio.

Microsoft Team Foundation Server.

Strong debugging skills.

Microsoft SQL Server 2019.

Advanced T-SQL.

Power BI Desktop / Service, Power Pivot, Power query.

SSAS tabular data model design, optimization and query using DAX.

SSIS design and development of ETL work flows.

Experience with data warehouse architecture and data modelling for reporting and analytics.

Demonstrated experience with Microsoft (SSRS, SSIS, SSAS, MS-SQL, Azure, PowerBI).

Experience in the development of SQL Views, Stored Procedures, and SSIS Packages).

Strong data analysis background.

Proven business analysis skills.

Strong Data virtualisation.

Strong Excel skills.

Experience with Power BI Embedded.

Knowledge of different Power BI capacities.

Knowledge of upper size limits for Power BI datasets & best practices to reduce size of datasets.

Power BI Incremental refresh on Gateway workspaces.

Managing different versions of datasets & reports and promoting those through different tiers e.g. dev, staging production.

Advanced SQL skills: SQL Programmatic knowledge – comfortable with Stored Procedures, Views, Functions.

Data reconciliation.

Data integrity.

CRM Systems(Large customer databases).

Advanced T-SQL.

SSAS tabular data model design, optimization and query using DAX.

SSIS design and development of ETL work flows.

Experience with data warehouse architecture and data modelling for reporting and analytics.

Database Developer and Data Analyst, Specializing in SQL Server Database Development, T- SQL, BPMN Work flow, Business Process Analysis, Data Analysis, Power BI Reporting, Power BI Dashboards, (DAX: Data Analysis Expressions) & (MDX: Multidimensional Expressions), Power Pivot, Power Query, C#, Systems Integration Analysis and Microsoft Azure, Active Directory, ETL Development, Data Warehouse Design and Data Analysis/Data Mining, SSAS Tabular Models for data analytics. With 25 Years of IT experience in building Complex Software Solutions, within Various Industries, including Financial Investment Services, Investment Banking, Insurance, Accounting, Retail, Medical and Manufacturing, Ernest is a Well Skilled and Experienced Power BI Developer on Cloud and on prem. Ability to Create visualizations of data using various components in Power BI. Excellent Dimensional modelling skills. Database Developer and Data Analyst, Specializing in SQL Server Database Development, T- SQL, BPMN Work flow, Business Process Analysis, Data Analysis, Power BI Reporting, Power BI Dashboards, (DAX: Data Analysis Expressions) & (MDX: Multidimensional Expressions), Power Pivot, Power Query, C#, Systems Integration Analysis and Microsoft Azure, Active Directory, ETL Development, Data Warehouse Design and Data Analysis / Data Mining, SSAS Tabular Models for data Analytics. With 25 Years of IT experience in building Complex Software Solutions, within Various Industries, including Financial Investment Services, Investment Banking, Insurance, Accounting, Retail, Medical and Manufacturing, Ernest is a Well Skilled and Experienced Power BI Developer on Cloud and on premises. Ability to Create visualizations of data using various visual components in Power BI. Excellent Dimensional modelling skills. Power BI Report and Dashboard Development. Data Storytelling to solve a business problem using extracted metrics from data. Experience working on large and complex data sets. Strong communicator verbally and in writing. BI Visualization developer using complex data sets. Interact with Business Analysts and End Users to establish information needs. Applying actionable insights on Power BI dashboards. Documenting dashboard content and data sources. Developing Power BI dashboards, containing information that is intuitive and simplistic through creative visual methods. Experience with SSAS tabular models. Working closely with stakeholders in an agile methodology. Design aesthetically appealing Visuals using using extracted metrics from data. Excellent Analysis and Communication Skills. Data gathering and collation, research and analytical abilities to develop insightful conclusions and generate solutions to address user needs and client engagement to define business requirements. Advising clients and stakeholders on how to use data to solve a problem as well as what data is available. Engaging with Data Engineers to include new data points as per business requirements. Create written communication materials that effectively summarize findings and support recommendations. Direct quality assurance and user acceptance testing (Unit testing and User Acceptance Testing)

Microsoft Azure Analytical Services using Enterprise Level Power BI Services, and Microsoft Azure SQL.

PERSONAL ATTRIBUTES:

Working Independently.

Self-confidence.

Ambition and drive.

Excellent communication skills (especially negotiating and influencing).

Handle responsibility.

Capacity to handle multiple priorities.

Flexibility and commitment.

Ability to work well under pressure.

Good organizational and time management skills.

Ability to work under pressure.

Strong administration skills.

Problem solving skills.

Analytical skills. Accuracy and good attention to detail.

Ability to prioritize.

Propensity for multi-tasking.

Deadline driven.

Excellent interpersonal and communication skills.

Attention to detail.

Proactive.

Integrity and honesty.

Analytical with problem-solving skills.

Able to work independently & also able to work as part of a team.

Self-driven and motivated.

Time and priority management.

The ability to work independently and as part of a team.

Ernest’s Profile:

Senior SQL Developer, Power BI Developer

Data Analyst, Data Engineer, BPMN Engineer

Ernest's Essential Skills Summary:

C#, SQL Server Database Development, SSRS, SSIS, T-SQL, Power BI Reporting (DAX) & Data Analysis, BPMN Work flow Design, BPMN Development and BPMN Systems Integration, SQL Stored Procedures and Functions, Schemas Design. Automation and Analysis of Business Processes, Microsoft Azure, Active Directory (MS Graph). Experience in all aspects of the Development Life Cycle (SDLC). Strong Analytical and Problem-Solving skills. AGILE Development applying SCRUM and JIRA as an Agile Project Management Tool. Experience working with Enterprise Software Architectures and Design Patterns Planning, Designing and Developing new Features and Functionality for Software Solutions. Source Control (Team Foundation Server, Apache Subversion (SVN). ETL and Data Analysis on Data Warehouse and Data Mart data Design. SQL Server Integration Services (SSIS), Business Intelligence (Power BI), SQL Server Reporting Services (SSRS), Microsoft Excel (Data Analysis), Data Warehouse Schema Design.

Ernest is a SQL Database Developer, Power BI Report Development AND Data Analyst, with more than 25 years of experience, including International Work Experience.

Ernest has worked in different Organisations and Industries, as an Individual Developer or in Development teams in various other countries (UK, New Zealand and the Netherlands).

He has strong SQL Development and Analytical skills with a Proactive and Agile mindset.

He has Extensive Proficiency in working in teams and how to translate a business

problem into a technical solution. 

Ernest is always developing his Skills Set and has a resilient ‘Getting Things Done’ mentality while focusing on Quality.

Ernest’s Professional Profile Comprise SQL, T-SQL, SSIS, SSRS, ETL, Power BI, Business

Process Analysis, Data Analysis, Power BI Report Development and Systems and Data

Integration and Analysis. With 25 years of IT programming experience in building

complex software applications, within various industries, including Investment Banking,

Financial Markets, Insurance, Accounting, Retail and Manufacturing.

The following Qualities describes Ernest’s Professional Working Approach:

Analytical Approach, that proofs him to be a good Planner with a Proactive and Agile

Mindset with a Hands-On and Can-Do mentality.

Personal Result Driven and Quality Driven Approach with every new Project.

Good Verbal and Written Communication in English and is also a great Team player with

the Ability to work Independently.

Experienced in working both in a project-based Environment and according to the

BusDevOps Agile Scrum Methodology with Fortnightly JIRA Sprints.

Extensive Experience in Designing and Developing Databases, Developing Reports and

SSIS packages. Ernest is Independent, Cooperation-Oriented, Entrepreneurial, Team

Player, Pleasant to deal with, Innovative, Result-Oriented and Customer-Oriented.

High Level of HBO Working and Thinking level with Problem-Solving skills.

Oversee complex data flow structures and needs to be experienced with large

data volumes. Analysis of Business Processes and the Translation thereof into Automated

Work flow Processes.

Senior level of experience in the following:

Microsoft Power BI Development.

DAX Queries, Functions in Power BI.

Microsoft SQL Server Database Development.

SQL Server Analysis Services Development (including MDX).

SQL Server Reporting Services Development.

Setting Up and Configuring new Power BI enterprise gateways and scheduling reports.

Deploying Power BI reports to Gateways (workspaces, capacity settings, user permissions configurations, data refresh interval config, ect.)

SQL Server Integration Services Development.

General Warehouse Design Principles (Changing Dimension/ Reference Dimension/ Fact Dimension/ ETL Design).

Microsoft Visual Studio.

Microsoft Team Foundation Server.

Strong debugging skills.

Microsoft SQL Server 2019.

Advanced T-SQL.

Power BI Desktop / Service, Power Pivot, Power query.

SSAS tabular data model design, optimization and query using DAX.

SSIS design and development of ETL work flows.

Experience with data warehouse architecture and data modelling for reporting and analytics.

Demonstrated experience with Microsoft (SSRS, SSIS, SSAS, MS-SQL, Azure, PowerBI).

Experience in the development of SQL Views, Stored Procedures, and SSIS Packages).

Strong data analysis background.

Proven business analysis skills.

Strong Data virtualisation.

Strong Excel skills.

Experience with Power BI Embedded.

Knowledge of different Power BI capacities.

Knowledge of upper size limits for Power BI datasets & best practices to reduce size of datasets.

Power BI Incremental refresh on Gateway workspaces.

Managing different versions of datasets & reports and promoting those through different tiers e.g. dev, staging production.

Advanced SQL skills: SQL Programmatic knowledge – comfortable with Stored Procedures, Views, Functions.

Data reconciliation.

Data integrity.

CRM Systems(Large customer databases).

Advanced T-SQL.

SSAS tabular data model design, optimization and query using DAX.

SSIS design and development of ETL work flows.

Experience with data warehouse architecture and data modelling for reporting and analytics.

Database Developer and Data Analyst, Specializing in SQL Server Database Development, T- SQL, BPMN Work flow, Business Process Analysis, Data Analysis, Power BI Reporting, Power BI Dashboards, (DAX: Data Analysis Expressions) & (MDX: Multidimensional Expressions), Power Pivot, Power Query, C#, Systems Integration Analysis and Microsoft Azure, Active Directory, ETL Development, Data Warehouse Design and Data Analysis/Data Mining, SSAS Tabular Models for data analytics. With 25 Years of IT experience in building Complex Software Solutions, within Various Industries, including Financial Investment Services, Investment Banking, Insurance, Accounting, Retail, Medical and Manufacturing, Ernest is a Well Skilled and Experienced Power BI Developer on Cloud and on prem. Ability to Create visualizations of data using various components in Power BI. Excellent Dimensional modelling skills. Database Developer and Data Analyst, Specializing in SQL Server Database Development, T- SQL, BPMN Work flow, Business Process Analysis, Data Analysis, Power BI Reporting, Power BI Dashboards, (DAX: Data Analysis Expressions) & (MDX: Multidimensional Expressions), Power Pivot, Power Query, C#, Systems Integration Analysis and Microsoft Azure, Active Directory, ETL Development, Data Warehouse Design and Data Analysis / Data Mining, SSAS Tabular Models for data Analytics. With 25 Years of IT experience in building Complex Software Solutions, within Various Industries, including Financial Investment Services, Investment Banking, Insurance, Accounting, Retail, Medical and Manufacturing, Ernest is a Well Skilled and Experienced Power BI Developer on Cloud and on premises. Ability to Create visualizations of data using various visual components in Power BI. Excellent Dimensional modelling skills. Power BI Report and Dashboard Development. Data Storytelling to solve a business problem using extracted metrics from data. Experience working on large and complex data sets. Strong communicator verbally and in writing. BI Visualization developer using complex data sets. Interact with Business Analysts and End Users to establish information needs. Applying actionable insights on Power BI dashboards. Documenting dashboard content and data sources. Developing Power BI dashboards, containing information that is intuitive and simplistic through creative visual methods. Experience with SSAS tabular models. Working closely with stakeholders in an agile methodology. Design aesthetically appealing Visuals using using extracted metrics from data. Excellent Analysis and Communication Skills. Data gathering and collation, research and analytical abilities to develop insightful conclusions and generate solutions to address user needs and client engagement to define business requirements. Advising clients and stakeholders on how to use data to solve a problem as well as what data is available. Engaging with Data Engineers to include new data points as per business requirements. Create written communication materials that effectively summarize findings and support recommendations. Direct quality assurance and user acceptance testing (Unit testing and User Acceptance Testing)

Microsoft Azure Analytical Services using Enterprise Level Power BI Services, and Microsoft Azure SQL.

PERSONAL ATTRIBUTES:

Working Independently.

Self-confidence.

Ambition and drive.

Excellent communication skills (especially negotiating and influencing).

Handle responsibility.

Capacity to handle multiple priorities.

Flexibility and commitment.

Ability to work well under pressure.

Good organizational and time management skills.

Ability to work under pressure.

Strong administration skills.

Problem solving skills.

Analytical skills. Accuracy and good attention to detail.

Ability to prioritize.

Propensity for multi-tasking.

Deadline driven.

Excellent interpersonal and communication skills.

Attention to detail.

Proactive.

Integrity and honesty.

Analytical with problem-solving skills.

Able to work independently & also able to work as part of a team.

Self-driven and motivated.

Time and priority management.

The ability to work independently and as part of a team.

MCSD INHOUSE OLD MUTUAL