Summary
Overview
Work History
Education
Skills
Personal Information
Timeline
Generic

Omolara Salimon

Grapevine,TX

Summary

5+ years of Strong Experience in developing applications using SQL Server Integration Services and Reporting Services with Experienced in whole cycle of DTS/SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers. Worked on automating the SSRS work flows. Strong knowledge in creating Indexes, Views, Triggers, Common Table Expressions(CTE), effective functions, and appropriate Stored Procedures to facilitate data manipulation and data consistency. Conversant with various phases of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation. Experience in creating master and child packages, package configurations and logging Using SSIS. Expert in using tools like SASS, SSRS, SSMS and Power BI for monitoring & tuning SQL server performance. Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, MySQL, SQL Server, MS Access and flat file. Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs with Excellent Verbal & Written Communication skills and strong in Documentation.

Overview

6
6
years of professional experience

Work History

ETL Developer

Clairvoyant
11.2020 - 02.2024
  • Created analysis of source systems, business requirements and identification of business rules
  • Responsible for developing, support & maintenance for ETL (Extract, Transform and Load) processes using PowerCenter
  • Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications
  • Extensively used ETL to transfer & extract data from source files (Flat files and DB2) and load data into target database
  • Documented Mapping and Transformation details, user requirements, implementation plan and schedule
  • Extensively used Autosys for Scheduling and monitoring
  • Designed and developed efficient Error Handling methods and implemented throughout the mappings
  • Responsible for Data quality analysis to determine cleansing requirements
  • Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer
  • Development of Informatica mappings for better performance
  • Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads
  • Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance
  • Understand the business needs and implement the same into a functional database design
  • Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.

Junior ETL/SQL Developer

LatentView
04.2018 - 09.2020
  • Extract, Transform and Load using SSIS and T-SQL Stored Procedures
  • Extracted data from Oracle (Claims DB) and migrated into SQL Server 2005 using SSIS
  • Captured table join blind spots effects from existing reports and databases
  • Used dimensional conformance strategies for efficient loss ratio reports
  • Performance tuning of Queries and Stored Procedures
  • Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
  • Developed Data Warehouse is using Microsoft SQL Server Integration Services (SSIS)
  • Implemented checkpoint mechanism, SSIS Package Optimizations, Error handling and logging as part of fast development
  • Implemented various levels of Transaction Support and Dynamism
  • Wrote complex SQL against data store for validating the report accuracy and in helping the QA team with testing strategy
  • Deployed & managed SSIS packages for Package deployment, Import/Export, Configuration modifications & Backup
  • Developed & tested fact table partition strategy to min performance impact due to additional history data in fact tables
  • Design, development & testing of all Oracle PL and SQL stored procedures to improve performance Designed the deployment plan to rollout the data warehouse to production
  • Created the migration documents and migrated the code to the production environment.

Education

Bachelor of Science - Computer Science

University Of Ibadan
05.2019

Skills

  • SASS, SSRS, SSMS, Tableau, Power BI, MS Visio, AutoCAD and MS office suite
  • SQL, PL/SQL and UNIX
  • Oracle, MySQL, MS SQL Server and MS Access
  • Machine Learning, Azure Cloud, Data Analysis, Exploratory Data Analysis, Statistically Data Analysis, Data Modelling, Data Profiling, Data Warehousing, Data Cleaning and Data Migration
  • Windows, Linux and MacOS
  • Informatica, Informatica PowerCenter, SSIS and DTS

Personal Information

Title: SQL/ETL Developer

Timeline

ETL Developer

Clairvoyant
11.2020 - 02.2024

Junior ETL/SQL Developer

LatentView
04.2018 - 09.2020

Bachelor of Science - Computer Science

University Of Ibadan
Omolara Salimon