Data Developer

Carlson Ngale

Senior MSB.I. Developer/Analyst

Professional Summary

Experience in analysis, design, implementation and administration of BI Solutions with Microsoft SQL server in development, testing, & production environments

Experience managing Big Data platform deployed in Azure Cloud

Experience Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing

Experience with entire Microsoft Business Intelligence Stack: SQL Server Integration

Experience in Data Warehouses and Cubes, reports, dashboards, queries, and data visualizations.

Install, maintain, develop, and support Microsoft’s Business Intelligence Technologies including but not limited to Microsoft SQL Server, SQL Server Analysis Server, Reporting Services, Integration Services, MDX, Excel, Power BI and SharePoint

Experience in viewing and troubleshooting queries under execution using live execution plan(Sql server 2016)

Services (SSIS) SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS) and the Business Intelligence Dev Studio (BIDS) environment

Experience in extraction, transformation and loading (ETL) of data using SSIS with complex integration of OLE DB, Excel, flat file, .CSV, and .XML sources/destinations

Experience creating calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs using Microsoft Power BI data visualization tools.

Good Knowledge in Tabular/Dimensional Data Modeling and Cube Development, Designing of Star Schema, Snow Flake,partition, Aggregation and Optimization using SSAS

Experience in creating project plans in accordance with project management framework standards and procedures Identified ongoing issues and gaps within project plans, in order to eliminate implementation issues

Planned, facilitated and reported on quality assurance testing efforts

Applied advanced sampling & data analytic techniques to help with strategic initiatives, roadmaps & process models

Knowledge in writing complex DAX functions in Power BI and Power Pivot.

Analyzed quantitative and qualitative business data to develop a solution design capable of fulfilling the customer's

Experience in various aspects of the ETL Life cycle such as package configuration, deployment, and scheduling in development, test, and production environments

Experience in various aspects of Report Development Life cycle such as report server configuration, deployment of reports, and creating report subscriptions (data driven) in development, test, and production environments

Developed dashboard, sub report, drilldown and drill through reports with cascading parameters using SQL Server Reporting Services (SSRS)

Experience with other reporting tools including Business Objects, Power BI, Crystal Report, Tableau

Exposure to data-warehousing techniques and OLAP data implementations

Knowledge of analysis services (SSAS) cubes, k.p.i., facts, dimensions, measures, and multidimensional expressions

Experience in software development in a structured team environment requiring source code control and release management processes

Experience in design, analysis, optimization, and maintenance on database tables, stored procedures, indexes, triggers, views, and user defined functions as required

Developed and worked with trigger and logging implementations

Experience in all stages of formal and logical steps to develop a software product using iterative

Agile approaches to the Software Development Life Cycle (SDLC)

Experience working with TFS, visual Studio and SharePoint.

Assisted in analysis and designing of development programs as per functional and technical programming standards.

Coordinated with functional architects for gathering and interpretation of user requirements to produce design specifications. Implemented procedures for designing and development of system specifications and interfaces.

Experience in SQL script writing to pull specified data for creation and delivery of ad hoc reporting

Extensive experience in system analysis, design, development, testing, and the production of technical documentation

Experience in performance tuning and query optimization

Experience in working closely with business analysts to define and deliver requirements for data modeling, e.t.l. processing, reporting dashboards, analysis cubes, and data warehouse projects

Test driven development implementing the Nunit/JUnit package/framework

C#.NET development using Visual Studio 2012 IDE

Agile software development life cycle (Scrum framework)

Code management/Version Controlled project builds using Subversion & Hudson/Jenkins

Database interaction through Entity Framework (MSSQL) and MySql

Certifications

Designing Business Intelligence Solutions with Microsoft SQL Server (MCP 70-467)

Analyzing and Visualizing Data with Power BI (MCP 70-778)

Experience

Verizon – Irving, Tx February 2019 -March 2020

Lead ETL, SSIS Developer

Worked on Data mining and Incremental data loading for Sales data using SSIS and SQL Server, and generating YTD and MTD reports

Provide Azure technical expertise including strategic design and architectural mentorship, assessments, POCs, etc., in support of the overall sales lifecycle or consulting engagement process

Designed snow Flake, star schemas, partition, aggregation and optimization using SSAS

Troubleshoot slow running sql queries using sql server profiler and execution plans

Fixed failed sql agent jobs and ssis packages

Configured email notification system to send email incase ssis package or agent job fails

Ensuring data synchronization between the servers and flat file ad hoc data sources, creating SSIS packages and job scheduling.

Azure/Oracle API Management, Security, Cloud-to-Cloud Integration (Public, Private)

Coordinating with the data warehouse team to facilitate the development and integration of BI application with data sets, using MS SQL Server and SSIS.

Provided technical input during project design and development

T-mobile Headquarters- Bellevue,WA July 2017- January 2019

MSBI developer /Analyst

Designed and created different ETL packages using SSIS from Oracle source, Excel, CSV Files, JSON files, Text files, MS Access to SQL server as destination

Involved in migrating archived data to Microsoft Azure Cloud for easy data access

Designed and provided Ad-hoc and Parameterized clinical reports using SSRS in SQL Server Data Tools for the internal use and client presentation

Coordinated integration activities

Created queries to track and record changes made to a table

Used different types of visualizations Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.

Created Subscriptions for the users to deliver the reports in a timely manner

Involved in protecting sensitive information by masking the actual data from all query results for unauthorized users

Evaluated technical information related to the project assignments

Merge Queries and Append Queries, remove columns and split columns, choosing required columns in the data using Power BI

Wrote Queries in Source Database and checked consistency and tested accuracy of data between Source database and Power BI.

Providing comprehensive consultation to business unit and IT management at the highest functional level on all phases of the project development cycle

Analyzing business and user needs and translating into proper business requirements documentation

Implemented Power view for the visualization of reports

Designed and maintained a web reporting environment including portal, dashboards

Created scripts to store and manipulate JSON files inside SQL server database

Created Pivot tables in excel using data from various sources like SSRS and MS Access

Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions

Diagnosing and tuning the server and query optimal performance using SQL Server Profiler and Database Tuning Wizard

Created indexes on selective columns of records for the faster retrieval of data in SQL Server Management Studio, sql assistant

Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions

IT Catalyst Services – Baltimore, MD March 2014 – April 2017

MSB.I. Developer/Analyst

Involved in developing business requirement documents (BRD) to implement ETL solutions for a small D.M.V. based real-estate group with no prior Business Intelligence (new development)

Complex SQL development utilizing stored procedures, triggers, cte’s, temp tables, table variables, views, and various other database objects

Developed various report types such as drill downs, drill through, matrix, sub reports, Parameterized, and cascading parameterized reports using SSRS 2012, 2014, 2016

Developed various reports types using report items such as charts, gauges, maps, Images, matrix, sub reports and used various types of functions to properly format report and to add clarity to reports such as IIF, Datediff, switch, lookup, is numeric, aggregate functions.

Scheduled Reports to run on daily and weekly basis in Report Manager, emailing them to management and analysts to be reviewed

Responsible for deploying reports to Report Manager and troubleshooting any errors occurring during execution

Analyzed the existing application programs and tuned SQL queries using execution plan, query analyzer, SQL Profiler and database engine tuning Advisor

Designed complex SSIS packages with error handling implementing various data transformations including but not limited to conditional splits, look ups, multi casts, data conversions, derived columns, and merge joins to establish a good foundation of functional data to begin report development

Created SSIS Packages to import from and export data to Excel spreadsheets, text files, XML files CSV files, and SQL database tables

Troubleshoot T SQL, SSIS and SSRS errors/performance issues and addressed them as required

Tested applications for performance, data integrity and validation issues

Designed and managed a data warehouse (star schema) with slowly changing dimensions

Designed and implemented OLAP cubes based on dimensional and tabular model within an SSAS instance

Created dimensional hierarchies for structured data aggregation and presentation

Fundamental knowledge of Multi-dimensional expressions (MDX)

Agile and Waterfall development on a team consisting of various personalities and skill levels

Mukete Consulting Ltd -Seattle, WA August 2012 – January 2014

Technical Support Specialist

Data retrieval/querying using SSMS (Advantage), PGAdmin (MessageCentral), NaviCat (Middleware)

Custom SQL target creation based on Affiliate requested criteria (suppressions/inclusions) of intended marketing effort segments of customers

Administration of the Zendesk Help Desk Ticketing System (account maintenance, workflow, testing, deployment, organization, vendor interaction)

Report and dashboard creation, management, and maintenance using GoodData as a reporting solution.

MAQL based metric creation and organization through GoodData as a web application based reporting option for analysis of support needs from and organizational and specialization group standpoint

Advantage CRM application interaction for support ticket resolutions

Custom list pulls using SQL language in the Advantage CRM

Process scheduling and load balancing of processing queue inside of the Advantage CRM

Orange -Cameroon January 2009 – May 2011

I.T. Help Desk

Computer and network maintenance, repair, and installation

Software and hardware troubleshooting and upgrades

Technological disaster recovery and prevention

Cisco router configuration and server backups

Windows desktop deployment and disc imaging (Symantec Ghost)

Domain and Group Policy Administration (Active Directory) Windows 7/ Windows Server

Education

Bachelors of Mathematics and Computer Science, University of Yaoundé, 2008

Contact this candidate