SUMMARY

Confidential Oguntuase is a BI Developer/Architect. He has a Bachelor of Science degree in Computer Engineering and a Master's degree in Computer Science. He also has several industry certifications. With over 12 years of IT experience, Mr. Oguntuase specializes in Design and Development of BI Analytics, Architecture,Data Integration processes, Data Warehousing, Enterprise Reporting Solutions andCustom Application Development. Mr. Oguntuase has designed and developed BI and Data Integration solutions for clients that address critical business needs across numerous platforms and corporate environments. As a seasoned BI architect developer, he has inspired and led both clients and fellow team developers to turn abstract concepts, problems, and other ideas into tangible solutions. Mr. Oguntuase leverages this passion and a wealth of past experiences and the knowledge of other thought leaders in this space to create solutions that consistently exceed the expectations of his clients. His client list includes multiple Fortune 1000 companies acrossFinancial Services, Healthcare Services, Home Builder, Manufacturing, Retail, and Educational Services Industries.

SKILL

• Relational Databases: SQL Server 2000/2005/2008/2012Database, Oracle 10g Database, T-SQL,DB Visualizer, Toad, PL/SQL, Microsoft Access, My SQL, 3NF Database Modeling, Azure SQL Database
• ETL:Integration Services SSIS , IBM Datastage, Informatica, SAP BOBJ Data Services, Power Query
• Multidimensional Databases/Platform:Analysis Services OLAP Cubes SSAS , MDX,Microsoft Master Data Management MDM , Oracle OBIEE, Microsoft Parallel Data Warehouse Appliance, IBM Neteeza Big Data Appliance, Erwin, Visio, Dimensional Modeling, Power Pivot, Apache Hadoop Clusters
• Report Development:SQL Server 2005/2008/2010 Reporting Services SSRS , Power View, Azure Reporting Services, Microsoft Frx
• Development Platform: Business Intelligence Development Studio, C .NET, VB .NET, XML, ADO.NET, .NET Framework , Microsoft Azure Development Framework, Visual Basic for Applications VBA , Microsoft Access, LLBLGen Pro Object Relational O/R Mapper, SharePoint.
• ERP:Microsoft Dynamics GP Great Plains , Microsoft Dynamics CRM, SAP, Lawson, PowerCAMPUS, PowerFAIDS

• Functional Technical Expertise:Business Intelligence Architecture and Development, Extract Transform and Load ETL , ERP System Conversion, Custom Application Development.
• Industry Expertise:Retail, Financial Services, Healthcare Services and Educational Services Industries.
• Other Skills: Strong Documentation Skills Rightly Energetic Customer Oriented and a Motivated Team Player.

Consulting Experience

Confidential

BI Developer/Architect

• Client manufactures and maintains rail cars for several customers in US and Canada.
• Projectsinvolves extracting data from legacy systems integrating with other structured data using ETL processes, Transforming and Loading the data into a Data Warehouseand OLAP cubes for several enterprise reporting initiatives.

• Serves as a lead architect and developer for the overall analysis, architecture, design and development of the enterprise data warehouse and business Intelligence solutions for each of the projects.
• Collaborate with business users to translate business requirements into functional specifications.
• Design, creation and enhancement of SSAS OLAP Cubes to facilitate enterprise reporting and decision making.
• Design and develop ETL processes using MS SQL Server 2008 SSIS for loading data into a Data warehouse and/or Data-marts.
• Design and develop logical and physical relational and multidimensional data models utilized for all aspects of the projects.
• Solution provided up to date enterprise view of the company's overall business operations.

Technologies: SQL Server 2008R2 Relational Databases, SQL Server 2008R2 Integration Services SSIS , SQL Server 2008R2Analysis Services SSAS , SQL Server 2008 Reporting Services SSRS , T-SQL, MDX, Visual Studio Business Intelligence Development Studio, Visio.

Confidential

Big Data Analytics

• Provide consulting services around Big Data Analytics Cloud solutions that provide actionable intelligence.
• Implemented cost effective and scalable Microsoft Azure Cloud distributed platform integration with an on premise Microsoft Dynamics CRM Data Warehouse system to analyze marketing and sales data and provide reports and dashboards that were used for improving marketing campaigns targeting and efficiency.
• Work closely with the sales / marketing team in helping to develop several lead nurturing and email campaign strategies that span across various lead generation medium, including paid search, organic search, direct mail, email and social media.

Technologies : Microsoft Azure Cloud infrastructure, HD Insight, Hadoop Clusters, Map Reduce , Hive, Azure SQL Server, SQL Server 2012, SSAS, SSIS, Azure Blob storage, Azure Tables, Azure Reporting Services, Power Query, Power Pivot, Power View, Big Data Analytics, Cloud Computing, Microsoft Dynamics CRM 2011 2013.

Confidential

Collateral Management Project

• Role involves overall gathering requirements from clients, architecting, analyzing and designing a reporting solution for delivering Incentive Compensation plans for the Wealth Market Specialists group at the Bank and a collateral management system for the risk management group of the bank.
• Designs implemented included translating complex business rules for the incentive compensation plans into a custom and easily maintainable rule engine.
• Designed ETL solutions for extracting, transforming and consolidating data from several data sources across the enterprise into a centralized repository for the reporting engine.
• Designed logical and physical data models utilized for the ETL and reports.
• Technologies: SQL Server 2008 R2 Databases, SSAS, SSIS, SSRS, Informatica ETL Tool, Ms Visio, Business Objects, Oracle Databases.
• Kimberly Clark Corp: A Global Consumer Goods Organization Irving TX Hitachi Consulting:Lead ETL Developer / Architect, Global Management Report Project March 2012 Oct 2012
• Role involvesarchitecting, designing, developing and implementing ETL solutions for the Global Management Reporting project across multiple regions including Europe, North America, Latin America and Asia.
• Business areas involved in include Product Customer Hierarchy implementations for Global Financial Reporting and Forecast Budgeting.
• Extracted data from multiple sources including SAP, MDM solution, Essbase, Enterprise Product Hierarchy system, Text Files and several others from multiple regions.

Technologies:Neteeza Big Data appliance, Neteeza workbench, Neteeza Databases, SQL Server 2008 R2 Databases, ErWin, SAP BOBJ Data Services, Visio.

Confidential

ETL Developer / Architect, Oracle BI Apps OBIEE

• Client is a leading communications and advertising organization in the United States.
• Project involved Implementation of Finance and Procure Spend Oracle BI Analytical and Reporting solutions with a minimal-customization, out-of-the-box approach.
• The financial analytics aspect of the project focused on G/L and A/P profitability.
• Role involved serving as a lead ETL Architect for all aspects of the project.
• Data was extracted from Microsoft Dynamics Great Plains, Essbase and custom Procurement Spend systems.
• Solution provided client with enhanced organizational capabilities and faster business decision making aptitudes by providing data acquisition, reporting and dashboards on a single platform OBIEE . It also providedthe ability to see pre-defined metrics, standards and reports that were not available.

Technologies: OBIEE, SQL Server 2008, SSIS, Microsoft Dynamics GP, Essbase, Custom Procurement and Spend App, Oracle 10g Databases, InformaticaETL tool, T-SQL, Excel, Visual Studio, Business Intelligence Development Studio.

Confidential

Business Intelligence Data Analyst/ETL Developer

• Client provides specialty financial services to individuals primarily in the United States and Mexico.
• Role involved defining, designing, developing and implementing solutions to validate and support key approved metrics and top management /operational reports for the client.
• Role was with primary focus of analyzing the underlying data and processes utilized by the reports, draw conclusions, and make recommendations for process and strategy changes in support of the BI department mission to maximize sales and minimize losses.
• Developed, implemented and supported a standardized data analysis frameworkfor the BI group, with a goal of supporting and enhancing analysis as an on-going function of the business.
• Designed and developed ETL processes using Datastage for loading data into an EDW and as part of the data analysis process.

Technologies: Oracle 10g Databases, Datastage ETL tool, DB Visualizer, Toad, PL/SQL, T-SQL, Excel, Visual Studio Business Intelligence Development Studio.

Confidential

BI Developer / Architect

• Client provides energy services, water services and paper services for refineries and other industrial applications.
• Project involved loading and transforming transaction, customer and material hierarchy data from SAP into a data warehouse and building a reliable hierarchy structures in OLAP Cube for reporting purposes. It also involvedloading other dependent data from other sources required for calculating various complex business metrics.

• Served as the lead architect for the overall analysis, architecture, design and development of the enterprise data warehouse, Data-marts, SSAS cubes and business intelligence solutions.
• Designed and developed ETL processes using MS SQL Server 2008 SSIS for loading data into a Data warehouse and/or Data-marts.
• Worked with other team members to design and develop analytics/reporting solutions using SSAS and PerformancePoint and developed complex business metrics and components required for the dashboard and reporting solutions.
• Provided time estimates for technical components of project implementations.
• Collaborated with business users to translate business requirements into functional specifications.
• Solution provided a great enhancement to the company's overall business decision making process.

Technologies: SQL Server 2008 Relational Databases, SQL Server 2008 Integration Services SSIS , SQL Server 2008 Integration Services SSAS , SQL Server 2008 Reporting Services SSRS , T-SQL, MDX, Visual Studio Business Intelligence Development Studio, Visio, ErWin.

Confidential

ETL Developer / Architect

• Client is a nationwide homebuilder who hasjust acquired another nationwide homebuilder organization operating over 60 regionalized divisions.
• Each division has traditionally been run as its own business and needs to standardize and centralize some functions to cut costs.
• Project involved leveraging previously developed integration processes to migrate all divisions from newly acquired company from multiple legacy transaction and financial applications into Lawson Financial module and other 3rd party applications.
• Role involved serving as a lead architect and a developer for the overall conversion strategy and plans.

Technologies: SQL Server 2008 Relational Databases, SQL Server 2008 Integration Services SSIS , SQL Server 2008 Reporting Services SSRS , T-SQL, Visual Studio Business Intelligence Development Studio, Lawson, AS400 on DB2, Hit OLEDB provider, Visio.

Confidential

Lead ETL Developer / Architect

• The client is a worldwide leader in convenience snacks, food with global presence.
• The project involves implementing a Microsoft Master Data Management MDM solution to solve the client's DSR data management issue that enabled data stewards to collaborate and manage the enrichment of product and store master attributes and hierarchies.
• Role involved serving as a lead ETL Architect for all aspects of the project by designing, developing, testing and deploying inbound and outbound ETL components and other programming modules.
• Assigned, scheduled, and guided other project team's ETL developers.
• Managed the technical requirements and technical specifications for all ETL development efforts.
• Participated in creation and management of the overall MDM development and modeling initiative by working effectively with team members and all levels of management.
• The solutions eliminated redundant work and unify customer team knowledge. It also enabled scalability of data management as more retailers/customer teams begin using DSR and lessen dependency on costly syndicated data.

Technologies: SQL Server 2008/2005 Relational Databases, SQL Server 2008 Integration Services SSIS , SQL Server 2008 Reporting Services SSRS , T-SQL, Visual Studio Business Intelligence Development Studio, Microsoft MDM.

Confidential

ETL Developer / Architect, SAP

• Client is a nationwide homebuilder, operating over 60 regionalized divisions. Each division has traditionally been run as its own business and needs to standardize and centralize some functions to cut costs.
• Project involved moving all divisions from their current multiple legacy Financials applications into SAP Financial module.
• Served as a lead architect for the overall conversion strategy and plans.
• Designed, developed, tested and deployed cross application ETL components.
• Created technical requirements and technical specifications for development efforts.
• Participated in creation and management of conversion and cutover plan by working effectively with all levels of management.
• The standardization and centralization of the client's financial system into SAP provided one version of the truth organization wide. This reduced significant maintenance costsassociated with of all legacy systems and gave them a significant advantage over their competitors.

Technologies: SQL Server 2005 Relational Databases, SQL Server 2005 Integration Services SSIS , SQL Server 2005 Reporting Services SSRS , T-SQL, Visual Studio Business Intelligence Development Studio, SAP, AS400 on DB2, Hit OLEDB provider.

Confidential

Lead SQL Developer

• Client is a telecommunications company based in Dallas with multiple office locations in the US and Canada.
• Role involved implementing, customizing, installing, providing on-going support, maintenancesand upgrades of Microsoft Dynamic GP Great Plains application system.
• Developed customized reports accessible within Microsoft Dynamics GP by interacting with SQL Server Reporting Services SSRS web services.
• Installed, administered and supported Microsoft FRx and its integration with Great Plains for delivering web based financial reports to users.
• Maintained and managed system and data integration of Great Plains solution with other third party applications by installing and configuring Integration Manager for users.
• Maintained user and system Security for Great Plains access and troubleshoot Great Plains application errors, processing errors and all data issues.

Technologies: Ms Dynamics Great Plains , SQL Server 2005, SQL Server 2000, SSRS, SSIS, Integration Manager, Microsoft Frx.

Confidential

Lead BI Developer

• Client is a Casino Gaming Company with multiple remote gaming sites throughout the United States.
• Project involved loading and transforming data from multiple data sources from each of the company's gaming sites and loading a data warehouse and a multi-dimensional OLAP cube. It also involved creation of a SQL Server Reporting Services enterprise reporting solution for the multi-dimensional analysis of the consolidated data.
• Role involved Architecting and Developing the ETL Extract Transform and Load processes, Enterprise Reporting Solution,the Data Warehouse and the multi-dimensional OLAP cubes.
• Solution had a direct impact on revenue generation and cost cutting activities for client. Specific examples include: Provision of accurate and timely data to the marketing team that enabled efficient targeted marketing campaigns and better partnering relationships Overall company cost reduction by having quick access to data that facilitated better negotiations with Vendors.

Technologies: SQL Server 2000/2005 Relational Database, SQL Server 2005 Integration Services SSIS , SQL Server 2005 Reporting Services SSRS , SQL Server 2005 Analysis Services SSAS , T-SQL, MDX, Visio, Visual Studio Business Intelligence Development Studio.

Confidential

Lead Developer

• Client is a nonprofit organization dedicated to provide medical services to individuals who are living with HIV/AIDS.
• Project included developing an extensible and scalable case management solution for the case managers and other staff of the organization to record and maintains their progress notes with each patient.

• Role involvedleading, designing and development effort of the .NET custom windows application.
• Solution improved efficiency of the staff and provided enhanced security, proper audit trail and accountability. It also provided easy access to each client's free text legacy data and enabled the staff to view and analyze historical information of the patients and be able to generate standardized SSRS reports and formatted client's progress history.

Technologies: SQL Server 2005 Relational Database, SQL Server 2005 Reporting Services SSRS , T-SQL, C , XML, .NET Framework, ADO.NET, .NET Framework 2.0., LLBLGen Pro Object Relational O/R Mapper, Web Services.

Confidential

Lead Developer

• Project involved creating an application that consolidates data from disparate data sources to create a system that captures HIV negative persons for the client's eligibility for a federal government prevention grant program.

• Role involved leading the design and development effort of the .NET custom windows application.
• The solution provided a unified query tool that enabled the staff to query and analyze the consolidated data in various ways and view or export the data to excel for further analysis. It also provided the aggregated summarized data required for federal government CADR reporting compliances to qualify and retain the client's participation in the grant program as well as data required for management, accounting and billing purposes.

Technologies: Microsoft SQL Server 6.5/2000, C , ADO.NET, .NET Framework 2.0., SQL Server 2005 Relational Database, SQL Server 2005 Integration Services SSIS , SQL Server 2005 Reporting Services SSRS , T-SQL, C , XML, .NET Framework, LLBLGen Pro Object Relational O/R Mapper.

Confidential

Programmer Analyst

• Company is a private college of about 5000 students and about 500 employees.
• Provided ongoing custom application development, support and maintenance for a number of application systems, several functional reports and databases toa variety of teams in the college such as Finance Accounting Dept. and Admissions Dept.
• Designed and Developed system Integration and Interface processes between various implemented application systems i.e. Finance Accounting, Financial Aid, Admissions and the student information system.
• Developed and maintained streamlined procedures tobuild predictive data mining algorithm models for the implementation of decision support and executive information systems to increase student enrollment and retention in the college. This system was an instrument into a 30 increase in the college's enrollment achieved for the first time in history of the college within two successive academic years.
• Developed and maintained processes for generating and tracking of direct mailing campaigns, email campaigns and other marketing campaigns between the college and prospective or existing students.
• Technologies: SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , Visual Studio.NET C , VB , Visual Basic for Applications VBA , Microsoft Access, XML, Visio, IIS, ASP/ASP.NET etc on Ms SQL Server 2005 and 2000 database platforms, Microsoft Dynamics GP GP , Microsoft Frx, PowerCAMPUS, PowerFAIDS.