Business Intelligence Data Analyst

DONALD KIMUNGE

McKinney, TX *****

********@*****.*** 214-***-****

•8+ years of technical experience well versed in Data Analysis and Development.

•Mastered creating stylish Report Layouts using Global expressions, Functions, Subtotals, Sorting the data.

•Strong experience as a SQL Server/Business Intelligence Developer.

•Full System Development Life Cycle (SDLC) experience including Requirement Gathering, Analysis, Design, Development, Testing and Implementation of various medium and large-scale client/server applications in a structured development environment.

•Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance

•Extensive experience in creating complex SSIS packages for ETL purposes using various transformations in SSIS 2008R2 and SSIS 2012.

•Skilled in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports creating on demand and scheduled reports in SSRS 2008R2, SSRS 2012.

PROFESSIONAL EXPERIENCE

TOYOTA INDUSTRIES COMMERCIAL FINANCE – December 3rd 2024

Data Analyst

•Query data source using SQL to determine field type ingested in the destination staging server

•Data mapping and analyzing data patterns for reporting.

•Data warehousing using (SQL, ETL, data warehouse), making sure the dataset matches the Treasury request for calculations.

•Troubleshooting Stored procedures queries and performing multiple joins for tables and views for data mining.

•Analyzed large datasets using statistical model tools in the data lake.

•Data mapping of data source with ingested destination of new data using heavy Microsoft Excel analysis.

•Performed conversion of scheduled IBM DataStage jobs to SSIS for smooth transition of ETL workflows.

s.

LPL FINANCIAL – September 2021- May 2024

SQL Server Developer/Sr. Business Analyst –Enterprise Data Lake (EDL) Department/Agile Methodology

•Efficiently managed and monitored suspicious trading activities using Actimize surveillance for trading data in the data lake and Cloud Snowflake environment.

•Write user stories and Acceptance criteria in Jira platform and create ARD document and Design respectively and uploading for approval in the Artifacts SDLC site.

•Actively participate in scrum routines and help manage roadmap for PI Planning, backlog Iteration and user stories in Jira and spike.

•Experience in data warehousing/Business Intelligence (DB2, SQL, ETL, data warehouse, Data stage and using databases in a business environment with large-scale, complex datasets as well as Power BI data modelling and DAX programming language.

•Creating Confluence pages and publishing them as per test descriptions and query data in the MapR

cluster and SQL.

Data mapping from our MapR data lake datasets to Snowflake Cloud computing for the Transition Warehouse.

Creating tables and views for the Transition Database in Dev environment.

Run daily Stand up, create Fix Versions for Releases, create stories, tasks and bugs.

Used Tableau to examine data with SQL and build data solutions.

Used Tableau for data visualization and business intelligence

Pulled large data sets using Tableau.

Used Power BI for data reporting and visualization.

Used Power BI to make data easier to interpret.

Performed scrum master role in running the daily morning stand ups and solving any parking lot issues.

Scrum master duties that I performed was creating fix versions before sign-off by developer’s and QA team, actively involved during PI Planning sessions, assigns tasks, Spike to scrum team members.

As a scrum master controlled the retrospective at the end of an Iteration.

Statistical data analysis using horizontal slicing for large data sets models.

Mapping data using Microsoft Excel and providing analysis on data patterns.

Experience in converting IBM DataStage jobs to SSIS.

Data Analyst-/Business Analyst Underwriting Process Department

American Auto Association (AAA) Feb 2020 – Sept.2021

•Ability to blend technical expertise with strong Conceptual and Analytical skills to provide quality solutions and result-oriented problem-solving technique and leadership skills.

•Experience with Power BI data modelling and DAX programming language.

•Define variables in T-SQL, help in maintaining batches (sets of SQL commands and making each procedure independent of each other (Modular handling).

Implemented different types of constraints on tables.

•Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, and triggers.

•Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.

•Experience in data warehousing/Business Intelligence (DB2, SQL, ETL, data warehouse, Data stage and using databases in a business environment with large-scale, complex datasets.

•Should be to be able to Analyze, map requirements and do some data mining.

•Used Tableau to analyze through drag and drop functionality.

•Used Tableau to create interactive visualization, reports and dashboards.

•Pulled large data sets using Tableau.

•Used Power BI for integration and utilizing numerous data sources.

•Used Power BI to make data easier to analyze data.

Bank of America – March 2017-Sept. 2019

Test Execution Specialist/Sample Execution Analyst (SEA) /Business Analyst–EIT Department.

•Provided multidimensional advanced analytics when mapping the data in the database and schemas and helped improve accuracy and detect false information using Actimize surveillance and Trade surveillance tools.

•Wrote complex SQL queries involving multiple tables inner and outer joins.

•Experience in data warehousing/Business Intelligence (DB2, SQL, ETL, data warehouse, Data stage and using databases in a business environment with large-scale, complex datasets as well as Power BI data modelling and DAX programming language.

•Defined variables in T-SQL, helped in maintaining batches (sets of SQL commands and making each procedure independent of each other (Modular handling)

•Created and managed schema objects such as tables, views, joins, clusters, indexes, functions, procedures, and triggers.

•Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.

•Strong in SQL concepts writing queries, joining tables etc. and be able write medium to complex queries to Analyze, validate/QA the data.

•Used Tableau to create KPI’s and customize the charts.

•Used Power BI to make data easier to analyze data and make business decisions.

•Data modelling project using MagicDraw in the ETL datasets, created diagrams that represent data structures.

FIRST AMERICAN MORTGAGE SOLUTIONS – July 2016 – January 2017

SQL Developer (Contract)

•Created and modified all the needed SQL tables and SSIS packages to extract, transform and load (ETL) the data from several data sources to MS-SQL Server Data Warehouse.

•Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, for loop and For Each Loop Container, Execute SQL, Execute Package, Send Mail, File System.

•Creating T-SQL functions and calling them in a particular event, making termination exception by rolling back if the server breaks down.

•Developed unit test plans for SSIS packages. Modified the existing SSIS packages to meet the changes specified by the users.

•Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, views and other T-SQL code and SQL joins for applications.

•Created embedded Power BI reports using MS Azure and visual studio.

Brinks Inc. (Ettaingroup) March 2016 – June 2016

Data Analyst (Contractor)

•Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, for loop and For Each Loop Container, Execute SQL, Execute Package, Send Mail, File System.

•Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

Nationstar Mortgage LLC (Solomon Edwards Groups) – March 2015 – June 2015

SQL Developer (Contractor)

•Wrote production implementation documents and provided Production support when required.

•Implemented MS SQL Server Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.

•Examined execution plans, created covering indexes, and filtered indexes when necessary for Tuning SQL queries.

Bank of America (Wingspan Portfolio Advisors) – March 2013-April 2014

BI Developer

•Hired to support a Loan Modification Project; worked on the loan modification project to extract transform and load data (ETL) coming from different sources e.g., Excel, XML, DB sources, and created reports for various departments.

•Created stored procedures to convert various financial reports and scorecards from Excel, Access for report automation and created Analysis Service cubes to feed data to the Company Reporting System.

•Perform Data Audits between legacy systems and cleansed the data to move to the data Warehouse.

•Built and customized SSIS Packages to load the Data into Staging, ODS and dimensional model.

•Designed and built the multi fact tables cubes using SSAS.

•Generated and deployed the reports using SSRS from ODS using Stored procedures and Cubes using MDX.

JPMorgan Chase Bank (Aerotek) – Nov 2011 – Nov 2012

BI Developer/ Business Analyst

•Worked on the loan modification project to extract transform and load data (ETL) coming from different sources e.g., Excel, XML, DB sources, and created reports for various departments.

•Extensively used C# script component in SSIS packages.

•Wrote Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse. Created various Stored Procedures to validate the data from the source and update/insert the records into target Tables. Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler.

•Generated the reports in SSRS using MDX. Worked with users and business other analysts to design and develop tabular, matrix, gauges, chart, and drill down reports as well as interactive reports according to business requirements.

Environment: Microsoft SQL Server 2008 R2/2008/2012, SSRS, SSIS, SQL Server Management studio (SSMS), Business Intelligence Development Studio (BIDS), AGILE, Visual Studio 2010/2008, Unix

STANDARD CHARTERED BANK-KENYA (Jan2007 –Dec2010)

BRANCH MORTGAGE OFFICER

•Originated modification loans documents, Credit Report, paystubs, P & L statements and confirmed the borrower home saver notes are expressing modification. Reconciled Bankruptcy loans which are active, in Litigation, Mediation, Relief at Stay and Discharged

•Calculating Adjustable Interest Rate Mortgage if Modified Tenure and Term respectively on HECM loans.

Environment: Microsoft Office Automation tools, Windows Operating System, Excel, MS Outlook, Access, AS400

EDUCATION & CERTIFICATIONS:

Bachelor of Science Management Computer Science (B.Sc.)

KENYA SCHOOL OF MONETARY STUDIES NAIROBI-KENYA

•Programming SQL Server Database-SQL Server 2008R2 - T-SQL

•Populating Data Warehouse-SQL Server 2008R2 - SSIS

•SQL Server Reporting Service-SQL Server 2008R2 - SSRS

•Hadoop Big Data using Hive, Scala and Spark.

•Salesforce Administrator (201), Python

•CompTIA Security+ Certification (January 18,2025

Degree of Information Systems Cybersecurity, AAS (Current Student)

COLLIN COMMUNITY COLLEGE FRISCO, Tx

9700 WADE BLVD FRISCO, Tx 75035

Contact this candidate