Sql Server Information Technology
Resume:
BENGA OGUNTOKUN
RICHMOND, VA *****
********@*******.***
SUMMARY
Highly motivated Microsoft Certified Information Technology Professional with close to two- decade of experience in software development. Especially skilled in customized business software development, utilizing the SDLC. Expert in building effective, productive, working relationships with demonstrated ability to incorporate technology routinely into instructional responsibilities either in-person or remotely. Energetic self-starter with excellent analytical and project management skills, focused on providing solutions to address business problems. Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks/projects according to requirement on a timely basis. CERTIFICATIONS
Microsoft Certified: Azure Data Fundamentals
Microsoft Certified Information Technology Professional (M.C.I.T.P) Microsoft Certified Technology Specialist (M.C.T.S): SQL SERVER. Microsoft Certified Professional (M.C.P)
TECHNICAL SKILLS
Transact SQL, XML, DotNet Technologies (C#,Visual Basic, ASP.Net, LINQ, Web Services), JavaScript, NodeJS, CSS, AJAX,, Bootstrap, Cloud Services (Azure & AWS) Microsoft Technologies :
Azure – Platform Technologies.
SQL Server 2005/2008/2012/2017/2019
SQL Server 2005/2008/2012/2017 Reporting Services (SSRS) SQL Server 2005/2008/2012/2017 Integration Services (SSIS) Microsoft PowerBI
SQL Server Analysis Services (SSAS)
Databases:
Relational:
Microsoft SQL Server 2000/2005/2008/2012/2014/2017/2019 PostgreSQL
Azure SQL DB
Oracle
Non-Relational:
MongoDB, DynamoDB
Source Control Management:
GIT
Team Foundation Server
Operating Systems:
Windows 98/2000/XP, Windows Server 2003, Windows Server 2008, Red Hat Linux. In depth Knowledge of the Active Directory Technology OTHER SKILLS
Strong Consulting and presentation skills.
Ability to communicate technical concepts to non-technical audiences. Communication: Analytical, organizational, verbal. Project Management.
Experience working with Industry Standards for data exchange including HIPPA, HL7, EDI etc.
Teamwork, collaboration, problem solving, planning and organizing. Medical terminology.
PROFESSIONAL EXPERIENCE
SKILTREK INC. Richmond, VA Dec/2021 – PRESENT
Senior Data Warehouse Developer/Architect
• Architectural design and dimensional modeling of analytical database using Kimball’s Methodology.
• Designed and Implemented ETL processes to support the Enterprise Data Warehouse.
• Designed and Implemented Data abstraction layer needed for self-service reporting.
• Created Stored Procedures, Functions etc., to implement business transformations needed by Analytics team.
• Performed on-going Data Model reviews to ensure it conforms to business need.
• Performance Tuning of Data Load processes/ad-hoc queries, to ensure efficient and timely data loads and fast running queries.
• Automated cloud data load process testing.
• Collaborate with cross-functional teams to identify business requirements and develop technical solutions.
• Manage and mentor junior database developers and project team members. COSTAR INC. Richmond, VA Jul/2018 – Dec/2021
Senior Database Developer/Architect
• Designed and Developed Database Solution to support front facing Enterprise Applications.
• Architectural design and dimensional modeling of analytical database using Kimball’s Methodology.
• Implementation of star schema to support LOB data marts.
• Implementation of
• ETL design and implementation
• Analytic engine design and implementation
• Created and developed numerous simple to complex stored procedures, functions, triggers to handle complex business requirement for distributed business units.
• Designed and Developed Data Integration Projects and Utilities to support daily business operations.
• Led and Coordinated Enterprise effort to consolidate Enterprise distributed spatial data, working with teams located around the world to identify, and integrated distributed data.
• Architect and develop PowerBI reports.
• Knowledge management Knowledge Engineering
• Master Data Management Design and implementation. FUSION INC. Richmond, VA Apr/2016 – Jul/2018
Data Warehouse Architect
Architect Duties:
• Responsible for the full cycle corporate enterprise data warehouse including maintenance and support of software applications and database systems.
• Architect and Design ODS, ETL applications, exception logs, reporting cubes and dimensional modeling.
• Lead new feature implementations, architecture analysis and testing
• Determine sizing requirements and preform DBA tasks associated with development of the Data Warehouse environment.
• Design data mart and create reporting templates and reporting architecture
• Analyzing multiple internal and external sources to determine data requirements and identify inefficiencies.
• Working with the business/analytics teams to provide crucial data pertaining to the business
• Collaborating with the IT team to develop, modify or change required application and system interfaces.
• Managing all metadata relating to the warehouse architecture, data object descriptions, access methods and security.
• Architect solutions to enable data discovery, self-service, enterprise level dashboards and reports using SSRS,SSAS, Cognos, Table
• Review current hardware/software, identify gaps and support development of a solution life cycle strategy.
• Develop the Enterprise Data Warehouse Architecture document.
• Develop Logical and Physical Data Models using tools including Erwin, Oracle data modeler, Sql Server database diagrams etc
• Design the Enterprise Data Warehouse and appropriate Data Marts.
• Be the key point of contact and subject matter expert of the Data Warehouse for the requirements, ETL, BI and QA teams.
• Develop detailed documentation and ensure ongoing business process changes are easily integrated into the Data Warehouse.
• Develop a strong understanding of source systems, reporting, analytic and other information needs.
• Understanding of regulatory practices including Hipaa, SOX,
• Onboarding/Mentoring more junior team members of standards and best practices for data modelling.
• Internal Technical SME for Microsoft Azure Data Warehouse Implementation/Data Migration.
Developer Duties:
• Implement and/or supervise all the above architecture tasks.
• Ensure all daily enterprise data warehouse jobs run and resolve any issues that come up when job fails.
• Research and fix daily operational issues
Administrative Duties:
• Mentor developers
• Provide weekly status reports
• Interviews
BROWNGREER PLC. Richmond, VA Jul/2012 – Mar/2016
Database Developer (Senior)
• Support Deep Water Horizon (DWH) Oil Spill Production environment operations on Scheduled and Ad Hoc Issues.
• Designed Logical and Physical data model to support DWH processes.
• Lead Developer on Data Analysis, Data Conversion and Data Quality Analysis on the DWH Project.
• Development of efficient scripts and Stored Procedures ranging from simple to very complex based on Client need.
• Designed SQL scripts to source data from disparate sources using knowledge in building/Integrating Data Models from different Sources.
• Built data models, reports, and dashboard using MSBI/SSDT tools.
• Sets and administers standards for BrownGreer’s relational SQL Server database structure/architecture.
• Research database technologies, determine business requirements, propose changes, and develop migration and implementation plans. Executing Projects based on the above.
• Implements bulk ETL and real-time data integration solutions using enterprise data management/ Reporting tools with particular emphasis on defining best practices in the design, deployment and management of scalable, reusable and extensible integration components.
• Product delivery utilizing SDLC.
WELLPOINT Richmond, VA Oct/2011 – Jun/2012
Database Administrator Sr. Advisor
• Database backend support of the HRS Suite of Applications.
• Developed database designs based on business requirements.
• Reviewed and revised database designs to ensure that all technical and business requirements are met.
• Built database structures based on design.
• Developed and maintained simple to complex components of the HRS Information Systems.
• Analyzed, designed and developed database solutions in an agile environment to achieve company’s business goals.
• ETL using SQL Server Integration Services.
• Wrote simple to complex Stored Procedures, functions, DDL and DML scripts.
• Data Migration: Migrated DTS Packages to SQL Server Integration Services Package as part of Data Access Layer (DAL) decommissioning Project.
• Provided support for System Implementation.
• Developed and Performed System testing, fixed defects identified during testing and evaluated results of unit/regression testing with emphasis on performance.
• Participated in integrating activities for successful implementation and support of project efforts.
• Designed and developed simple to complex database objects that run Enterprise Letter system.
ACS Inc. (A Xerox Company) Richmond, VA Jul/2010 – Oct/2011 System Development Specialist
• Created and developed numerous simple to complex stored procedures, functions, triggers to handle complex business requirement for diverse business.
• Worked as a key part of several Enterprise – Wide teams to analyze and develop report requirements, LOEs, and systematically developed report/business intelligence solution to solve business problems.
• Worked with several State Government Healthcare Business representatives including Hawaii, Kentucky, Missouri, Alabama, North Carolina, Alaska etc, to gather business requirements, advice on realistic solutions and implement solutions from development to production.
• Developed and Maintained ETL solution using SSIS.
• On – Demand report rendering to numerous Business Clients.
• Authored, Installed, Deployed and Managed reports using SQL Server 2005/2008 Reporting Services based on business requirements following Industry best practices and standards.
• Worked closely with the developers, management, and medical professionals to develop and maintain pharmaceutical, patient, provider, eligibility and medical claims reports.
• Coordinated Enterprise Wide/Reporting Team Source control including working directly in Visual Studio Source Safe (VSS) and Visual Studio Team Foundation Server (TFS).
• Maintained Reporting Team SharePoint Sites.
• Automated Enterprise Wide letter generation process.
• Developed templates in Microsoft Excel to Improve Enterprise – Wide Requirement gathering process.
• Migrated, re-develop and enhanced Microsoft Access reports to SSRS.
• Fixed defects and enhanced existing reports.
Shalom Home Health Inc. Durham, NC
Systems Administrator Jan/2007 – Oct/2011
• Work with management to develop Information Technology Strategies to support Organizational goals and mission.
• ETL Development using SSIS.
• Designed, Developed and Implemented Database Schema and Objects
• Coordinates and Implements Database Administration Duties including backup and recovery plans, security policies, regulatory policies, Database Snapshots and backup restores.
• Constant Ad hoc T-SQL authoring
• Responsible for audit and security of Databases to ensure accurate use of resources and data.
• Develop high availability solutions including Log-shipping, Mirroring, Clustering etc.
• Performance Tuning.
• Writing Complex T-SQL queries, Stored Procedures, trigger and Functions
• Building Reports using SSRS.
• Documentation
• Maintenance of Company LAN.
SetFocus, LLC. Durham, NC Jun/2009 - Aug/2009
SQL Developer
• Created numerous simple to complex queries involving self joins, correlated subqueries and XML techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• As part of a team, analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu- Ray) rental company. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using XML and SSIS.
• As part of a team, created various reports according to the business requirements for the movie rental company. Individually authored, installed, deployed and managed reports using SQL Server 2005 Reporting Services for a library database.
• Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities.
• Developed a backup and recovery plan based on the data availability requirements of the library and on the potential impact of data loss on the business after considering and analyzing the different backup and recovery strategies.
• Designed database maintenance plans to set up core maintenance tasks to make sure that the database performs well, is regularly backed up in case of system failure and is checked for inconsistencies.
• Employed the Database Engine Tuning Advisor to analyze the performance effects of workloads and implemented its recommendations wherever appropriate.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server – particularly to analyze the performance of the stored procedures.
• Analyzed different high availability solutions and implemented database mirroring and replication.
• As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks.
• Familiar with employing Service Brokers, enabling HTTP support and establishing Notification Services.
• Familiar with the new relational features of SQL Server 2008 BW & Associate Durham, NC
Project Coordinator/Asst. DBA Dec/2006-Aug/2007
• Coordinated a virtual team on a website Project.
• Designed and Implemented Database Schema.
• Developed and Maintained client database in Microsoft Access.
• Installed, Configured and Implemented MS SQL Server 2005 Solution
• Migrated Access Database to MS SQL 2005
• Assisted in Writing Complex Queries, Stored Procedures, triggers, views Functions etc
• Development of Reports (SSRS) and SSIS Packages.
• Developed a maintenance plan including data recovery policy.
• Documentation.
• Monitored website content for accuracy and post updates.
• Trained staff on website maintenance procedures.
• Integrated virtual staff using go-to-meeting.
• Acted as Information Systems resource person.
• Expedited hardware/software upgrades including workstations Memory, and disk space.
• Networked workstations using LAN technologies.
• Coordinated focus on Customers’ needs in project planning and execution.
• Instructed use of tools like Microsoft office, Visio and Wikis for documentation and collaboration.
Duke University Health System Durham, NC
Patient Transporter/Dispatcher Mar/2007- Jul/2010
• Work in coordination with physicians, nurses and patient’s family to ensure patient is always on schedule.
• Facilitate safe movement of patients between two points.
• Ensure confidentiality of patient’s records between transit points.
• Approach, greet and offer assistance and direction to customers entering the hospital.
• Participate in the training of new employees.
• Help desk and customer service duties.
Obafemi Awolowo University Teaching Hospitals Nigeria Dental Officer 1 Jan/2005-Dec/2006
• Implemented the most practical and cost-effective match between Patients and Treatment.
• Gathered patient demographics information and entered into database.
• Performed treatments and made appropriate referrals. EDUCATION
GRAND CANYON UNIVERSITY Phoenix, AZ
Master of Business Administration,
Management of Information systems
OBAFEMI AWOLOWO UNIVERSITY Ile Ife, Nigeria
Bachelor of Dental Surgery
Contact this candidate