RUSSELL KENYA

817-***-****

adzdpi@r.postjobfree.com

PROFESSIONAL SUMMARY

Experienced Data Engineer with a strong background in transforming complex data into valuable insights by leveraging Business Intelligence tools and supporting robust technology infrastructures. Proven expertise in data engineering, analytics, and report development. Collaborative team player adept at translating business requirements into technical solutions. Passionate about delivering innovative data solutions to drive actionable insights and support informed decision-making.

POWER BI

Strong Knowledge on Power BI to import data from various sources

Developed and implemented reporting, analytics, and data visualization solutions with Power BI.

Experienced with DAX creating calculated columns and measures and providing insightful KPIs.

Experience in optimizing reports and setting up Power BI service, gateways, and scheduling data refresh.

SQL

Designing and Implementing Database Schema, Data modeling, creating normalized datasets, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Views, Temp tables and complex SQL statements.

Establishing referential integrity, data consistency, indexing and data cleanup procedures to maintain high quality data that can be used for reporting.

Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans, normalization, indexing and Transaction Isolation levels, and monitoring logs to ensure the completeness of batch processes and scripts.

EDUCATION AND CERTIFICATIONS:

Bachelor Of Science- The University Of Texas Arlington

Colaberry School Of Data Analytics

Certified SQL BI/EDW Developer

TECHNICAL COMPETENCIES:

Operating Systems & Environments: Windows

Databases (RDMS): SQL Server 2008/2012/2014/2016/ Azure Data Factory/ Azure Analysis Services

Administrative, Modeling, Tuning & Troubleshooting: SQL Server Management Studio (SSMS)

Business Intelligence: Power BI, SSIS, Excel, Power Pivot

Languages: T-SQL, R, Python, Dax, M-Code

PROFESSIONAL EXPERIENCE

WNA

Role: Data Engineer JULY 2021- Present

Collaborated within the FFIO Business Process Management & Analytics product area to address key analytics challenges and improve data-driven insights.

Designed and implemented ETL processes to extract, transform, and load data from diverse sources into the data warehouse, ensuring data accuracy and integrity.

Extracted data from multiple sources, performed data cleansing and transformation, and created data models for visualization.

Developed and maintained database schemas, tables, and indexes for optimal data storage and retrieval.

Utilized Azure Data Factory to orchestrate and automate data pipelines, extracting data from various sources, transforming it, and loading it into Azure Data Lake Storage for further analysis.

Implemented performance-tuning techniques to enhance query execution and overall database performance.

Implemented Dimensional Modeling techniques, including star-schema, to enhance data warehousing capabilities.

Conducted data analysis and identified trends, patterns, and anomalies in time reporting data, providing actionable recommendations for process improvements and cost savings.

Designed Cost Management Project Management (CMPM) for Application Power BI report, providing insights into software application costs.

Provided training and support to end-users on using Power BI to analyze and interpret data, fostering data literacy within the organization.

Restricted access to various databases to increase system security.

Created an automated email alert system to improve time reporting notification efficiency

Identified and implemented performance optimization techniques, enhancing the speed and efficiency of Power BI and SSRS reports.

Improved Drill- Down and Filtering functionality to allow stakeholders to explore the budget data at various levels of granularity, from an overall view down to specific projects

Wrote SQL queries and customized reports to meet client-specific requirements.

Created custom DAX calculations to meet complex business logic requirements and enable advanced analytical capabilities within reports.

Environment: Power BI SQL Server 2016, Power BI, Excel, SSIS, Visual Basic, BIDS, Azure Data Factory

TELVISTA

Role: BI Developer FEB 2016- JUNE 2021

Key Responsibilities:

Collaborated with cross-functional teams to translate business requirements into technical specifications for reporting and analytics solutions.

Spearheaded the integration of Power BI with Azure Data Factory to establish streamlined ETL processes and ensure consistent data updates in reports.

Created and optimized complex SQL queries, stored procedures, and functions to retrieve and manipulate data for various business applications.

Leveraged Azure Analysis Services to create multidimensional models, enhancing report performance and scalability.

Designed and implemented ETL processes to extract data from various sources, transform it according to business rules, and load it into target data warehouses or databases.

Connected Power BI reports to Azure Analysis Services models, enabling seamless and interactive data visualization.

Designed and developed SSIS packages to extract data from various sources, transform it according to business rules and requirements and load it into target data warehouses

Used SSIS to create ETL packages to validate, extract, transform, and load data to data warehouse databases

Assisted in the implementation and optimization of ETL processes for data extraction and transformation.

Environment: Power BI SQL Server 2016, Power BI, Excel, SSIS, Visual Basic, BIDS, Azure Data Factory

ADDITIONAL INFORMATION:

Strong analytical and problem-solving skills with the ability to work effectively in cross-functional teams.

Excellent communication and presentation skills, with experience in training users on Power BI reports.

Proven ability to meet project deadlines and deliver high-quality results.

Self-motivated and quick learner, staying up to date with the latest data analytics and business intelligence advancements.

Contact this candidate