Resume

Sign in

SQL / ETL Developer

Location:
Plano, TX
Posted:
May 20, 2020

Contact this candidate

Resume:

Gabriel Egbenya

Plano, TX

757-***-**** addclb@r.postjobfree.com

Professional Experience

5+ years of Business Intelligence expertise in Developing, Analyzing, Designing, and Reporting using Microsoft SQL Server Management Studio software 2012-2016 versions and Microsoft Visual Studio (SSIS, SSAS & SSRS).

3 years’ experience working with Health Care Data while adhering to all HIPAA policies, along with internal policies / procedures

Experience in medical terminology, ICD-10 codes, CPT / HCPCS codes, Diagnosis codes and 1500 claim forms

I train new and existing users on how to use EVV application, I also provide live technical support when needed.

Creating calculated fields and measures to track Claims billables, account payables, receivables and denials.

I built an automated system for AFHS to track all patient whose coverage, eligibility and benefits are due for renewal.

Extensive experience on developing Business Intelligence applications with SSIS, SSRS, Power-BI.

Created OLAP applications with OLAP services in SQL Server and built multi-dimensional cubes.

Strong Object-Oriented Analysis, design and scripting technical skills, ability to learn new emerging technologies and adapt quickly.

Highly motivated, self-starter that is also passionate about technology. Assesses and addresses a client's business needs and use right tools and frameworks to build effective solutions.

SSIS

Used various SSIS Transformations such as data conversion, conditional split, derived column etc. on the data retrieved, performed data validation checks during staging and then loaded the data.

Writing basic C# .Net codes to validate data within an SSIS package.

Developed, tested and deployed SSIS packages in different environments for various projects.

Implemented failure alerts using Send Mail Task in SSIS.

Provided logging, error handling by using custom logging for SSIS Packages.

Created SQL server configurations for SSIS packages and XML & Windows event logs.

Designed and developed SSIS Packages to extract data from variety of sources like XML, CSV, Excel and OLEDB.

Used Different component like Foreach Loop, Sequence Container, Execute SQL Task, Script Task,

Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints and protection levels.

Worked on data flow sources, destination and transformations like, multicast, merge Join, lookup etc.

Handled package deployment, package configuration model with SSIS configurations and scheduling SSIS packages with SQL agent.

SQL

Extensive experience in using T-SQL creating tables, stored procedures, complex joins, views, indexes, cursors, triggers, user defined functions, database models and data Integrity in SQL Server 2012/ 2014/ 2016 platforms.

Designed and developed databases with the best practices of data modeling and data normalization.

Extensive experience in performance optimization of SQL queries and stored procedures using query optimization tools, Database engine tuning advisor, SQL Server profiler.

Using Execution Plan and Statistics to troubleshoot slow running query.

Table partitioning for query optimization taking into consideration the File Group, File Path, Partition Function, Partition Scheme and Indexes.

SSRS / POWER BI

Able to Create Power BI dashboards and reports. Design, build and deploy BI solutions

Maintain current BI data model. Develop and administer new data models and enhancements.

Proven ability and extensive experience in creating actionable dashboards and reports.

Extensively experience in developing reports with drill down reports, drill through reports, parameterized reports, table reports, chart reports, matrix and sub reports.

Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.

Created SSRS reports with complex calculation fields.

Excellent experience in performance tuning and optimization of SSRS Reports

Implementation of security in SSRS report at item level and group level with SSRS roles.

End-to-end development experience from gather requirements to deployment of SSRS reports

Implemented and configured subscriptions (both data driven, normal subscriptions) to deliver reports.

Education/Certifications

Bachelors in Science – Business Administration & Management Technology, Lagos State University, Nigeria.

Microsoft Certified Technology Specialist – SQL Server 2012 - 2014

Texas Medicaid and Health Services Vesta EVV Mastery Certification.

Diploma in Desktop Publishing and Computer Appreciation, DVAST Computer College, Lagos, Nigeria

Awarded December 2006

Technical Skills

Operating Systems

Windows Server 2008/2010/XP/Vista, Windows 7/8/10

Database Tools

SQL Server Management Studio (SSMS), SQL Profiler, Query Analyzer, DTS Designer

BI Tools

Visual Studio 2012 - 2016, Python, Matplotlib, Seaborn, SQL, Agile Methodology, Software Development Life Cycle.

Languages

T-SQL, C# (Script Task), Python

OLAP Tools

SSAS, Power Query

ETL Tools

SQL Server Integration Services (SSIS), C#, Power Query, Pandas, Numpy, SQL

Report Tools

SQL Server Reporting Services (SSRS), Power BI, DAX, TABLEAU, Matplotlib, Seaborn

Data Modeling

SQL Server Analysis Services (SSAS), Power Pivot/Query, Power BI

Job Scheduler

SQL Server Job Agent

Office Tools

MS Word, PowerPoint, MS Excel

Communication Skills

Work Experience

American Family Health Inc, Wylie, TX Dec. 2017 - Current SQL/ETL Developer.

Responsibilities

Created packages using Integration Services (SSIS) for extracting data from Flat Files, Excel files, OLEDB to OLEDB Destination.

Responsible for loading the data using SSIS packages to fact and dimensional tables.

Used C# scripting to validate packages, and SSIS to create ETL process to extract, transform and load data into data warehouse databases.

Supported efficient data insertion, manipulation and retrieval using various joins, indexed views, stored procedures and functions.

Created SSIS packages to capture the incremental changes for the data warehouse.

Developed SSIS packages using Foreach loop in control flow to process all flat files within folder, File System Task to move file into archive after processing and execute SQL task to insert transaction log data into the SQL table.

Configured SQL mail agent for sending automatic emails when a SSIS packages fails.

Responsible for creating database objects like table, views, stored procedures, triggers, functions using T-SQL to provide structure to store data and to maintain database efficiently.

Created SSIS packages to capture the Incremental changes for the data warehouse.

Developed various operational drill-through and drill-down reports using SSRS.

Identified and added the report parameters.

Processed and generated automated reports for the end business users on a daily, weekly, and monthly basis.

Developed Reports in Visual Studio by using the variety of tools such as charts. map, matrix, indicator and more

Implemented data conversion from text file into SQL server tables.

Environment: MS SQL Server 2012 - 2016, Visual Studio (SSIS, SSRS)

Copaair.com (A Subsidiary of Global Links Holdings Inc) Aug. 2014 – Nov. 2017 MSBI Developer

Responsibilities

Worked with Sales, Production, Marketing, and Finance department with the collaboration of IT team to automate various business transaction to create reports and scorecards from Excel and Flat file.

Worked with Business, and Financial Analysis department to understand business sales processes for documenting project requirements and translate them into functional and non-functional specifications for BI reports.

Developed T-SQL scripts, dynamic SQL, Stored procedures, User defined functions, triggers and complex join and sub queries in SQL Server Management studio (SSMS) 2012.

Designed and developed ETL packages with various data sources and destinations using SSIS 2012.

Designed and developed reports, sub reports, data driven subscriptions, drill down reports and drill through reports using various features like Charts, graphs, filters etc.

Used SSIS transformation for data cleansing to remove unnecessary columns, eliminated redundant and inconsistent data.

Configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeeded.

Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler.

Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.

Environment: MS SQL Server 2012/2014/2016, Visual Studio 2012/2016



Contact this candidate