Orighoye Omatseye
Atlanta,Georgia
Summary
Dynamic technology professional with more than seven (4) years of IT experience, including extensive technical background in DB applications, Data Analysis, ETL Development, Data modeling and warehousing and Systems Administration. Strong knowledge of Oracle/SQL Server Architecture, schema, and Transaction management. Keen researcher with robust resolution pedigree; utilizing knowledge of relational database and Business Intelligence models to improve on efficiency and effectiveness of organization’s IT functions towards achieving a goal.
Overview
4
4
years of professional experience
Work History
ETL / BI Developer
DBSI Services
01.2020 - Current
- Using SSIS to import and export data from and into SQL Server tables
- Writing queries to fetch data from different tables by using JOINs, Sub-queries, Correlated sub-queries and derived tables on SQL Server platform
- Using Pivot tables to create reports that did dicing and slicing functions on data
- This is called dimensional analysis and gives business 360 view of what is going on
- Extracting data from flat files, Oracle, DB2, and SQL Server 2014, and to load data into target database
- Performing ETL data loads from flat files, DB2, Teradata, PL/SQL etc.
- To transform data into complex scripts and codes for software application testing
- Electronic interchange of business information using EDI database
- Developing automated tool for updating and running quality checks on ERWIN data models
- Creating Logical and Physical Models using ERWIN
- Inserting checkpoints in Oracle database to check functionality and data integrity of UAT
- Helps to identify problems, offer solutions, and participate in their resolution
- Perform data mapping for process
- Utilize standard excel macros to comply with department standards
- Checks for validity and reproducibility of quality/safety measures when indicated from multiple data sources
- Writing complex SQL queries using advanced SQL concepts like aggregate functions, Group by and
- OLAP (Online Analytical Functions)
- Creating numerous permanent tables, local and Global Temporary tables
- Developing and implemented strategies to handle errors by ETL teams
- Developing leading routines and data extracts with SSIS and SQL script procedures
- Oversaw database upgrade, backup, recovery and migration
- Wrote and optimized SQL statements to assist business intelligence practices
- Automated BI reports for secure virtual server environment
- Monitored and optimized SQL server performance
- Developed intelligence-sharing dashboards, providing company-wide access to collected data
- Generated reports, updated spreadsheets and presented results
- Planned, designed and implemented diverse business intelligence solutions
- Monitored assessment software for performance, security and database availability throughout lifecycle
- Compiled, maintained and developed database systems for tracking tailored content reports
- Collected data from wide-ranging sources
- Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes
- Maintained proficiency with latest database technologies
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles
- Designed customized data collection models for specific visualization tasks
- Improved data gathering, analysis and visualization procedures with strategic optimizations
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards
- Prepared targeted documentation, specifications and resources to analyze business data
- Created data analysis tools to allow teams to query acquired information for unique details
- Assessed platform statistics to create customized, data-intensive BI analytics
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence
Data Analyst
Bennett Insurance Agency
07.2019 - 12.2019
- Performed numerous data pulling requests using SQL server 2012 and Tableau for analysis
- Created tables with columns and rows using DDL and DML functions
- Cleaned, processed, and loaded data through ETL and SSIS systems and queries in SQL Server 2012, presented in MS Excel, Tableau report or PDF
- Implemented SSRS to deploy business reports for interactions with stakeholders regarding system design
- Executed ad hoc reporting requirements for executive management team
- Proficient in use of R STUDIO to create datasets for analysis from multiple, primary sources; R
- Programming skills should be sufficient for modular programming to support recurring production-level datasets
- Write SQL queries for data manipulation, sorting, summarizing, and reporting
- Collected data from all clients and make recommendations for improvement
- Created new database objects like Tables, Procedures, Functions, Indexes and Views
- Analyzed data and develop unique tables, charts, and other data displays for inclusion in reports to various clients and as data support for research/consulting staff
- Gathered, analyzed, and documented data requirements for projects of medium to high complexity and moderate to high risk, perform source system data quality analysis
- Supported company’s healthcare implementation and training
- Supported, managed, and maintained organizations clinical data in databases in SQL Server
- Designing Reports as per client Requirement and created reports using Excel file, SQL Server and Oracle databases
- Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images,
- Maps, Trend Lines, Statistics, and Log Axes
- Groups, hierarchies, sets to create detail level summary reports and dashboards using KPI's
- Created, organized, customized analysis and visualized projects and dashboards to present to Senior
- Level Executives
- Created complex reports like Detail Level Transaction report, monthly Aging, YTD cash goal Reports,
- Quarterly reports by creating multiple queries
- Produced Logical Data Models/Physical Data Models
- Worked on motion chart, Bubble chart, drill down analysis using tableau desktop
- Deployed Tableau Dashboards and worksheets in clustered environment
- Hands on experience to extract, manipulate and built complex formulas in Tableau for various business calculations
- Enhanced PL/SQL test scripts for data driven tests
- Involved in resolving reporting issues and design issues throughout reporting life cycle
- Creating Parameters for desired functionality
- Written complex SQL queries and optimized queries for performance tuning
- Produced monthly reports using advanced Excel spreadsheet functions
- Developed and implemented data governance policies and procedures
- Developed data mining algorithms to identify and classify patterns in data
- Deployed predictive analytics models to forecast future trends
- Developed and maintained data warehouses and data marts to support business operations
- Implemented business intelligence solutions to increase operational efficiency
- Designed and developed data pipelines to acquire, clean and process data
- Collaborated with stakeholders to identify business needs and data sources
- Provided technical support for troubleshooting analytics and reporting issues
- Created dashboards to monitor and track key performance indicators
- Participated in requirements meetings to understand business needs
- Utilized data visualization tools to effectively communicate business insights
- Extracted and interpreted data patterns to translate findings into actionable outcomes
- Documented effective and replicable methods for extracting data and organizing data sources
- Collaborated with business-unit leaders to identify and prioritize problems
- Tested data prediction algorithms based on historical data
- Worked with business intelligence software and various reports to glean insights into trends and prospects
- Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements
- Identified, analyzed and interpreted trends or patterns in complex data sets
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources
- Used statistical methods to analyze data and generate useful business reports
- Upheld security and confidentiality of documents and data within area of responsibility
- Analyzed transactions to build logical business intelligence model for real-time reporting needs
- Assisted with creating data cubes and OLAP models to improve data analysis
- Generated ad-hoc reports to evaluate specific business requirements
- Utilized data visualization techniques to present and explain complex data sets
- Updated and developed scripts and queries to extract and analyze data from multiple sources
- Optimized data access and storage to improve performance of analytics systems
- Created data models to support decision-making processes
- Generated standard and custom reports to provide insights into business performance
- Developed complex dashboard and reporting tools to track business performance metrics
- Identified patterns and trends in large data sets and provided actionable insights
- Developed customized reports, summarizing and presenting data in visually appealing format
- Analyzed data to identify root causes of problems and recommend corrective actions
- Implemented code solutions to answer analytic questions and test and assess new methods
- Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users
- Designed and implemented tools to support strategic value chain optimization initiatives
Education
Master of Science - Computer Science
University of Maryland - Eastern Shore
Princess Anne, MD12.2023
Bachelor of Science - Electrical Engineering
University of Maryland - Eastern Shore
Princess Anne, MD12.2013
Skills
- SKILLS SUMMARY
- Understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM)
- Excellent in data mining for fulfilling customer segmentation business requests and periodic report generation
- Experience in data Analysis and ETL techniques for loading enormous amounts of data
- Experience with DATA MINING
- Expert in developing Dynamic Visual reports in Tableau and Power BI
- Experienced in implementing Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension
- Table, Physical and Logical Data Modeling using ERwin Data modeler
- Identified issues when reports are created from several and complex data sources
- MS SQL Server 2012- latest, MySQL 52, 57, Oracle 12c - latest, Amazon
- Athena ETL/Other Tools: SSIS, Erwin Data Modeler, AWS Glue, Azure data factory
- Querying Tools: SQL Management Studio 2008/2012, SQL Plus, SQL Developer, Toad
- Querying language / Scripting: SQL, PL/SQL, TSQL, Python, R
- Business Intelligence Tools: Tableau 92, 93, 104, Excel and Power BI, SSRS, Micro Strategy
- Cloud Solutions: AWS, AZURE
Timeline
ETL / BI Developer
DBSI Services
01.2020 - Current
Data Analyst
Bennett Insurance Agency
07.2019 - 12.2019
Master of Science - Computer Science
University of Maryland - Eastern Shore
Bachelor of Science - Electrical Engineering
University of Maryland - Eastern Shore
Similar Profiles
HEATHER BARTONHEATHER BARTON
Pre-Construction & Estimating Coordinator at DBSI, Inc.Pre-Construction & Estimating Coordinator at DBSI, Inc.
ASHWINI LASHWINI L
Data Quality Specialist – Master Data Service at DBSIData Quality Specialist – Master Data Service at DBSI
Tanna ThurberTanna Thurber
Employee Services Specialist/Internal Recruiting at DBSI Inc.Employee Services Specialist/Internal Recruiting at DBSI Inc.
Tom MOOLAYILTom MOOLAYIL
Director of Engineering at Uchimura Robotics LLCDirector of Engineering at Uchimura Robotics LLC
Kevin FarewellKevin Farewell
Sanctions Compliance Senior Analyst at Pricewaterhouse CoopersSanctions Compliance Senior Analyst at Pricewaterhouse Coopers