Emmanuel Sane

I am an experienced Business intelligence developer with a passion in working with data and interpreting data to create meaning and assist management in making informed decisions.

Ace Systems       BI Developer                                  Remote       March 2021– April 2022

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases. 
• Involved in planning, defining, and designing database based on the business requirements document
• Implemented after insert, update and delete triggers to simultaneously populate multiple tables.
• Developed reports using Power BI software to generate all daily, weekly, monthly and quarterly Reports based on the user business requirements
• Created objects like tables, views, stored procedures and handled performance tuning using T-SQL
• Worked on property expressions, variables and configurations between SSIS packages
• Created and Deployed SSIS packages to file system and SQL Server
• Transformed the data using different transformations like Conditional split, join, merge, lookup, Derived column of SQL Server Integration Services (SSIS)

Environment: MS SQL Server 2012/2016, Reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), Power BI, Microsoft Excel

Nobilis Group, BI Developer                               Irving, TX      August 2014 - September 2020

• Interacted with users in gathering the requirements and analyzing the needs of the end users
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS
• Design, Develop and Deploy reports
• Extensively formatted reports into documents using Report Services for the creation of Dashboards
• Developed reports using Power BI software to generate all daily, weekly, monthly and quarterly Reports based on the user business requirements
• Played a key role in User Acceptance Testing of the reports
• Installed SQL Server Reporting Services (SSRS) and configure the reporting services configuration. 
• Created Tablix, Drill down and drill through reports, multi value parameter reports. 
• Created reports and dashboards using SQL Reporting Services (SSRS) 
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Used Best practices for package design, dataflow techniques, deployment, and management in SSIS

Environment:  MS SQL Server 2008/2012/2016, Reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), Power BI, Microsoft Excel

Monogram               Business Analyst         Plano, TX   August 2013 – April 2014 (Contract)

• Interacted with users extensively in gathering the requirements and analyzing the needs of the end users
• Extracted data from multiple sources including (Excel, SQL, etc.)
• Created dynamic tables and analytical chart objects to evaluate financials.
• Facilitated monthly meetings with stakeholders to document requirements and explore solutions.
• Developed Business architecture using requirements such as scope, processes, alternatives and risks.
• Liaised between the business and technical team to ensure mutual understanding of processes and applications.

Colaberry School of Data Analytics                                                  Certificate of Data Analytics

Indiana University, Indiana, USA ,2004-2009                                        Bachelor of Science in Finance

John Adams High School, USA ,2004                                                       High School Diploma

Laiser Hill Academy, 2001-2003                                                                            Secondary School

Olerai Primary School,2000