Joseph Ogwuche

Ogwuche Joseph -|- BI/ETL DEVELOPER A Senior Developer with 7+ years of experience in the design, development, management of Databases and Business Intelligence applications on MSSQL Server and MSBI stack. TOOLS & ENVIRONMENT SQL Server 2016, Impala, ODBC, SSMS, T-SQL, Power BI, JIRA, SSIS, Hadoop Big Data, SQL Profiler, DTA, Octopus Deploy, Tidal Enterprise Scheduler, SharePoint, TeamCity, MS Azure, Azure SQL, Azure Data Factory (ADF), Azure DevOps (TFS), Financial Analysis and Reporting. Python. PROFESSIONAL EXPERIENCE Covenant Visions Limited, Lagos NG Senior BI Developer 06/2022 – Present Job Duties: • Analyzed the business requirements in JAD sessions. • Coordinated with business users and stakeholders in JRD sessions for gathering business requirements. • Created source-to-target mapping (STM) documents to support enterprise data warehouse. • Designed Revenue-Volume impact analysis dashboard in Power-Bi to help call center services track its hiring impact • Delivered reports with standard and data-driven subscriptions to the business users. • Developed visually rich charts, maps, slicers, word cloud, funnel, gauges utilizing Power BI, delivering actionable insights. • Utilized different type of filters and slicer in Power BI reports for enhanced search operations per business requirements. • Built complex data queries to support BI solutions in Impala Big Data. • Automated report deliveries to multiple recipients with subscriptions in SSRS. • Designed and implemented ETL processes to make data available for revenue cycle reporting. • Used DAX time intelligence functions such as SAMEPERIODLASTYEAR, PREVIOUSMONTH etc. to manipulate date over and between periods of time in Power BI. • Created measures, calculated columns in Power Bi using DAX table functions such as CALCULATE to change the filter context. • • • Managed and manipulated data, performed data cleaning and transformations in Power Query with M-Code. Created optimized Power Bi data models using the most efficient relationships, cardinalityt and data import mode. Managed Power BI service workspace and app access across the consumer department. Trustfund Pensions Limited, Abuja NG BI/ETL Developer Job Duties: 04/2018 – 06/2022 • • • • • • • • • • • • Modified existing SQL scripts (stored procedures, UDF’s, views) for new enhancements as per the business logic. Wrote complex SQL queries using scalar and table variables which held user inputs and performed business logic. Improved the performance of SQL codes, procedures, and functions with SQL Profiler and DTA. Wrote different SQL scripts to implement the business logic utilizing joins, sub queries, and UDFs. Optimized queries by modifying T-SQL codes and eliminated redundant data. Performed unit and integration testing on ETL packages and reports. Fine-tuned the configuration of Azure SQL database environment in terms of database size, memory, processing tier. Design and Development of ETL methodology for supporting Data Migration, data transformations & processing in a corporate wide ETL Solution. Optimized the performance of T-SQL queries and SSIS packages following Microsoft best practices. Designed packages to generate manual reports in excel and flat file formats. Created process runbooks in ServiceNow to guide business users. Migrated complex operational reports to different enterprise data systems (CCA to GC). Asyst Tech, Abuja NG SQL/BI Developer 10/2014 – 02/2018 Job Duties: • • • • • • • • • • • • Assisted in designing and developing Use Cases, Activity Diagrams, and Sequence Diagrams using UML. Performed normalization and de-normalization of existing tables improving query processing. Analyzed source databases and created data mapping documents for the data migration process. Designed complex stored procedures to perform data profiling and auditing in the pre-staging database. Supported the development of object-oriented applications in MS environment. Developed stored procedures, views, triggers, and queries with SQL Server. Created partition scheme and function to improve the performance of queries and the availability of data. Scheduled report deliveries to multiple users utilizing subscriptions. Formatted reports with parameters and embedded functions with expressions. Deployed multiple types of reports on Share Point and utilized dashboards. Designed and created report templates, bar graphs, and pie charts. Carried out company health financial analysis for executive management. EDUCATION Master of Science in Financial Engineering WorldQuant University (Present) Bachelor of Science in Computer Science and Statistics University of Agriculture Makurdi (2014)