Olalekan Owasoyo

Addison,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.

years of professional experience

Latent View, Remote, USA

11.2020 - Current

Extract, Transform and Load using SSIS and T-SQL Stored Procedures.
Extracted data from Oracle (Claims DB) and migrated into SQL Server 2005 using SIS.
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 Dimensions, cubes with star schema using SQL Server
Developed Data Warehouse is using Microsoft SQL Server Integration Services (SSIS).
Implemented checkpoint mechanism, SIS 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 report accuracy and in helping 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 migration documents and migrated code to production environment.

Clairvoyant, Remote, USA

11.2018 - 10.2020

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 Power Center
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.
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 Power Center tool - Source Analyzer, Data Warehousing Designer, Mapping & Marplot 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.

University of Ilorin

Nigeria

04.2017

LANGUAGE: SQL, PL/SQL and UNIX
TOOLS: SASS, SSRS, SSMS, Tableau, Power BI, MS Visio, AutoCAD and MS office suite
OTHER: Machine Learning, Azure Cloud, Data Analysis, Exploratory Data Analysis, Statistically Data Analysis, Data Modelling, Data Profiling, Data Warehousing, Data Cleaning and Data Migration

Latent View, Remote, USA

11.2020 - Current

Clairvoyant, Remote, USA

11.2018 - 10.2020

University of Ilorin