Herve Noudo

SUMMARY

**+ years of programming, database design (logical and physical), development, testing and implementation.

15+ years of cumulative experience working with MS SQL Server 2008, 2008R2, 2012, 2014, 2016 and 2017, Oracle.

Experience with .Net Technologies (.NET Framework, MS Visual Studio .NET, ADO .NET, ASP.NET MVC, VB.NET, C#)

15+ years of experience working with Microsoft Access and Excel.

15+ years of experience working with the Microsoft Visual Studio Platform.

7+ years of experience using Power BI

5+ years of experience using Cloud platforms and technologies like Microsoft AZURE, Hadoop

Experience in application development using Microsoft .NET, Informix and Oracle data management and enterprise-wide application development software as well as several leading third generation programming languages.

Very proficient with Microsoft Visual Basic®, C#, SQL, Python, and Transact-SQL

In-depth knowledge and experience of writing SQL and T-SQL script modules, simple to complex stored procedures, triggers, self-join queries, error handling codes, etc.

Experienced in migrating from SQL Server 2000 to SQL Server 2012.

Experienced in migrating from Microsoft Access to SQL Server, Oracle, MySQL, Dbase and vice versa.

Microsoft Certified Professional in Querying Microsoft SQL Server 2012

In-depth knowledge and experience of Financial, Accounting, Payroll and Fiscal information systems analysis and modeling.

COMPUTER SKILLS

Languages

Proficient With: Microsoft Visual Basic®, C#, SQL, Transact-SQL, DAX and MDX, Python, R

Familiar with Microsoft Visual C, C CSS, Java,

Software

Development Platform: Microsoft Visual Studio®

Data Manipulation Tools: Power BI, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), SQL Server Management Studio (SSMS), Hadoop

Database Management System: Microsoft SQL Server, Microsoft Access, ORACLE, MySQL, DB2, AZURE

Operating Systems: Microsoft Windows® (XP/Vista/7/8/10), Microsoft Windows® Server 2012 R2

EXPERIENCE

Business Intelligence Consultant for Insight Global Apr 2021 - Present

As a PowerBI SME assigned to Octo Consulting Group, I lead a team of 4 to build a PowerBI dashboard to assess performance of all services at the U.S. Department of Health & Human Services.

In addition, I lead my team to migrate Octo’s data warehouse to the cloud using AZURE technologies.

Duties and responsibilities include (but is not limited to):

Collected business requirements from users (mainly data team that were keeping manual legacy Excel reports) and converting them into technical requirements for the BI team.

Build multiple PowerBI dashboards from scratch to support client.

Wrote simple to complex DAX queries to compute data.

Trained the client team on how to maintain and administer dashboards.

Created a Microsoft Azure SQL Database for Octo Consulting Group.

Leveraged Azure Data Factory (a cloud ETL service) to migrate data from Octo’s on-prem database to the cloud.

Business Intelligence Architect for Amur Equipment Finance Sept 2019 – March 2021

For the Sales department, I built a “Vendor Dossier” dashboard, a reporting application by which the Sales department could assess all vendors bringing business to the company by measuring their performance over a period. This dashboard helped identity and eliminate poor performing vendors while incentivizing good performing ones.

Duties and responsibilities included (but, not limited to):

Collected business requirements from stake holders and converting them into technical requirements for the BI team.

Build a new SQL Server 2014 Datawarehouse from scratch.

Developed core functionality with the ASP.NET MVC Framework (C#, ASP.NET)

Wrote complex queries: including views, stored procedures, functions, and triggers.

Developed new ETL solutions using SSIS.

Developed BI solutions using SSRS, SSAS

Built dashboards using Power BI.

Wrote simple to complex DAX queries to create calculated columns, calculated tables, and measures SSAS cubes and PowerBI models.

Wrote simple to complex Python scripts to support our predictive models.

Design and Developed Web Services using ASP.Net, Web API.

Troubleshooted existing Databases, ETL and BI solutions

Used Hadoop and Python to process business data to and from AWS cloud platform for predictive analysis and machine learning to support the Customer service department.

Business Intelligence Architect for Mariner Finance Mar 2018 - Jul 2019

As a contractor, I helped build a new SQL Server 2014 data warehouse which helped the company achieve its goal of keeping a single source of truth for all financial reporting as opposed to the multiple redundant sources, error prone reporting system they were struggling with before I joined their data team.

Duties and responsibilities included (but, not limited to):

Collected business requirements from stake holders (mainly accountants, sales representatives) and converting them into technical requirements for the BI team.

Performed dimensional data modeling and data mapping.

Wrote complex queries: including views, stored procedures, functions, and triggers.

Developed new ETL solutions using SSIS 2017

Developed BI solutions using SSRS 2017, SSAS 2017, Excel with Power Pivot

Built dashboards using Power BI

Wrote simple to complex DAX queries to compute data.

Troubleshooted existing Databases, ETL and BI solutions

Took turn with teammates on a weekly basis to maintain Night Operation Automated Jobs.

Document solution in JIRA

Perform code versioning with GitKraken

Used Hadoop and Python to process business data to and from AWS cloud platform for predictive analysis and machine learning to support the Customer service department.

Database Developer for Convergenz Mar 2017- Feb 2018

As a contractor assigned to the Federal Aviation Administration, my main mission was to troubleshoot and improve existing database infrastructure to make reports faster.

Duties and responsibilities included (but, not limited to):

Performed dimensional data modeling and data mapping.

Wrote complex queries: including views, stored procedures, functions, and triggers.

Developed new ETL solutions using SSIS 2016

Developed BI solutions using SSRS 2016, SSAS 2016, Excel with Power Pivot

Built dashboards using Power BI

Wrote simple to complex DAX queries to compute data.

Document solution in JIRA

Perform code versioning with GIT

ETL Engineer for Robert Half Technology May 2015- Feb 2017

As a contractor, I helped develop the business intelligence infrastructure (Data warehouse, SSAS cubes, SSRS Reports) of client Bacchus Importers which improved the decision-making process of their Accounting and Sales department.

Duties and responsibilities included (but, not limited to):

Leading a team of 4 database junior developers through the steps required to deliver a robust BI solution (Analysis and data mapping, data warehouse development, ETL work, Cubes design and dashboard design).

Conducting weekly or bi-weekly peer review meetings to coordinate and stimulate team efforts.

Designed and developed multiple modules using .NET MVC 4.0

Collecting business requirements from clients and converting them into technical requirements for the BI team.

Providing data analysis, database design, programming (C#), testing and implementation support to the development team.

Analyzed, designed & developed large scale distributed system using .NET

Coordinating with database administrators ‘staff regarding data warehouse development, migration of data either manually or using ETL (Extract, Transform and Load) processes, revision and update of data marts and cubes, procedure development, troubleshooting, system configuration, security administration, and account setup.

Developing data models and data maps for data warehouse system.

Developing processes and applications for centralization and transformation of data from local agencies-wide systems to the data warehouse system using SSDT and SSMS.

Implemented input validation using the ASP.NET Input Validation Controls.

Writing SQL and T-SQL script modules involving simple to complex functions, stored procedure, triggers, self-join queries and error handling codes in both SQL and T-SQL.

Developing and maintaining data marts, data cubes, queries, and reports.

Assisting end users and programmers with data warehouse related issues like data source connections with the ADO.NET technology (C#), report design, subscription and data import/export from/to Microsoft Excel Worksheets using SSRS and SSMS or code.

Initiates processes and documentation of data warehousing system; develops procedures to ensure security and integrity of data.

Keeping current with the latest technology by self-training and performing Microsoft TechNet virtual lab.

Providing effective recommendations for the overall information system upkeep.

BI Developer for VA Data Center Jun 2010 - Apr 2015

As a full-time employee working for the data team, I mostly helped maintaining and optimizing existing database and reporting infrastructure which overtime significantly reduced the downtime in business operation.

Duties and responsibilities included (but, not limited to):

Collecting business requirements from stake holders (mainly accountants and sales representative) and converting them into technical requirements for the BI team.

Providing data analysis, database design, programming, testing and implementation support to the development team.

Developing data models and data maps for data warehouse system.

Writing SQL and T-SQL script modules involving simple to complex functions, stored procedure, triggers, self-join queries and error handling codes in both SQL and T-SQL.

Involve in bug fixing, production support issue of previously developed Windows application using Win forms, C#, VB.NET

Developing and maintaining data marts, data cubes, queries, and reports using ORACLE tools.

Develop ETL processes to transfer data from production databases to the data stage.

Perform data cleansing operation on data stage and transferring cleansed data to the data warehouse.

Designing tabular and multidimensional applications to support reporting activities.

Browsing OLAP cubes with Microsoft Excel and Power Pivot.

Designing reports and dashboards with SSDT, Report Builder and Crystal Report.

Keeping current with the latest technology by self-training and performing Microsoft TechNet virtual lab.

Providing effective recommendations for the overall information system upkeep.

EDUCATION

University of Maryland University College, College Park Maryland 2019

Master of Science in Data Analytics

University of Maryland University College, College Park Maryland 2016

Bachelor’s Degree in Computer Science

University Institute of Technology Ngaoundere, Cameroon 2004

Associate degree in Computer Engineering

CERTIFICATIONS

Microsoft Certified Professional 2014

• Exam 461 Querying Microsoft SQL Server 2012

Microsoft Technology Associate 2013

• Exam 361 Software Development Fundamentals

• Exam 364 Database Fundamentals

Contact this candidate