Olasubomi Olasubomi
Senior BI Analyst/ETL Developer
- Role
- Senior Business Intelligence Developer at Shellpoint Mortgage Servicing
- Location
- Dallas-Fort Worth, TX, US
- LinkedIn followers
- 500 followers
About Olasubomi Olasubomi
9+ years of IT experience in System Analysis, Design, Development and Support of MS SQL…
Experience
Senior Business Intelligence Developer
Oct 2021 — Present · Dallas, TX, US
Assisted in the definition of the database requirements, analyze existing models and reports and looking for opportunities to improve efficiency and troubleshoot various performance issues.Develop highly optimized stored procedures, functions and database views to implement the business logic and also created clustered and non-clustered indexes.Involve in performance monitoring, tuning and capacity planning.Created SSIS packages to load data from flat files, excel files, XML to data warehouse and report-data mart using look-up, derived columns, sort, aggregate. Pivot transformation and slowly changing dimension.Translate business requirements into business intelligence application designs and solutionsDesign, deploy and maintain complex canned reports using SQL Server 2016 reporting services (SSRS) and Tableau.Assisted in converting business objects from SSRS to tableau dashboard.Produced attractive dashboards and visuals that helps convey the story inside the data.Create parameterized queries, generated Tabular reports, sub-reports, drill down reports using expressions, functions, charts, maps, sets, groupings, sorting the data, defining data sources and subtotals for the reports.Customize reports by adding filters, calculations, summaries and function. Created reports to retrieve data using stored procedures that accept parameters.Advised optimization of slow performance queries by looking at execution plan for better tuning of the database. Detailed documentation of all existing and new processes, converting business requirements into technical solutions.Business analysis, understanding requirements, developing user stories and documentation of the acceptance criteria.
Education
University of Birmingham
Master's degree, Human Resources Management and Services
2009 — 2010
Indiana University - Kelley School of Business
Master of Business Administration - MBA
Babcock University
Bachelor's degree, Marketing
2003 — 2007
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.