SAMUEL NYARKOH

SQL SERVER BI DEVELOPER

PROFESSIONAL SUMMARY:

7+ years of strong MS SQL Server Developer experience with expertise in MS SQL Server 2016/2014/2012/2008 suite of products like SSRS, SSAS, and SSIS.

Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.

Experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2016/2014/2012/2008.

Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.

Experienced in index maintenance and application of In-Memory technology.

Proficient in Database maintenance and query reviews.

Strong leadership, communication, problem-solving and multi-tasking abilities.

Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

TECHNICAL SKILLS:

Programming Languages:

T-SQL (7 years), Arcpy Python(2 years), MATLAB (2 years)

Web Technologies:

HTML &CSS (2 years),

Other Tools MS Office Suite:

Microsoft Word, Power Point), OLAP & OLTP, Adobe Photoshop, Abode Flash

EDUCATION:

Masters of Science in Geography, Western Michigan University, Kalamazoo 2017

Bachelors of Science in Geodetic Engineering, Kwame Nkrumah University of Science and Technology, Accra, 2007

PROFESSIONAL EXPERIENCE:

SAM LLC, Westerville, OHIO June 2017 to Present

SQL Server Developer

Responsibilities:

Manage ETL processes, Build and deployed SSIS packages using various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations using Microsoft Visual studio.

Routinely performs performance tuning using advanced methods like partitioned tables, In-memory technology, buffer pool extension and application of column-store indexes using SQL Server 2016.

Performs query optimization by checking and creating indexes and replacing unnecessary joins with CTE’s, derived queries, subqueries, Co-related sub queries, Dynamic SQL queries etc. using SQL Server 2016.

Improving query performance by Implementing memory optimized tables and memory optimized stored procedure techniques as well as troubleshooting and memory management.

Created SSIS packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.

Extensively used MS SQL Server 2014 and2016.

Implementing scalar functions and table-valued functions

Created and optimized complex SSIS packages to load contract details (like project name, crew name, labor, project location, Number of hours on project, vehicle log etc.) into staging stage and further into data warehouse and creating SSAS cube.

Worked on Data Warehouse design and created SSAS Cubes for Company Contracts (SQL server 2016)

Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)

Write queries for front-end applications. Experience in writing complex SQL queries, Stored Procedure and MDX and queries.

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job (SQL server 2016)

Designed and implemented stored procedures and triggers for automating tasks.

Created Parameterized, Cascaded, Drop-down Reports using SSRS.

Experienced in slowly changing dimension in SSIS packages.

Performed incremental data load packages in SSIS .

Upgraded SSIS 2012 and SSAS 2012 Solutions to 2016

Direct Energy, Houston, TX Sept 2013 to June 2015

SQL ETL Developer

Responsibilities:

Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.

Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) and Scripts using T-SQL Code.

Developed smart meter and data forecasting applications.

Involved in debugging Reports and deploying Reports and Report automation.

Generated parameterized reports, sub reports, tabular reports using SSRS.

Created complex SSIS packages using proper control and data flow elements with error handling.

Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.

Applied various data transformations like Slowly Changing Dimension(SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.

Expert in creating, configuring, and fine-tuning ETL workflows designed in SSIS.

Created SSIS package to extract data from OLTP to OLAP and scheduled jobs to call the packages and stored procedures.

Involved in developing Analysis Services Project. Developed, deployed and monitored SSIS. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions

Irrigation Development Authority, Aaccra Ghana March 2008 to Nov 2012

SQL Server Developer

Responsibilities:

Involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target Data Warehouse.

Primary technical resources in SQL tuning in SQL Server Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.

Provide and implement performance and tuning recommendations of all components in the SQL Server database.

Enhancing and deploying the SSIS packages from development server to production server.

Involved in creating jobs, Alerts and schedule SSIS packages using SQL Server Agent.

Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services(SSAS).

Essentially responsible for monitoring scheduled jobs and to ensure all packages are running without any disruption.

Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) table.

Contact this candidate