Adekunle Oyaniyi

§ Installed DuckCreek, SQL Server 2016 with necessary configuration. § Code Analysis on the existing system. § Redesign/refactored C# Custom Code for DuckCreek. § SQL Server Performance Troubleshooting. § C# code review using TFS. § Unit testing of C# custom code against DuckCreek local and local SQL Server using Example UTIL to make a server request. § Installed SonarLint and StyleCop on VS2007 for error, bug fix and code refactoring. § Bind SonarCube to Solution Project to help analyze code against configuring issue. § Queried Splunk to get requests sent through different application for analysis. § Created issues on JIRA.

 Worked with Amazon Gov Cloud environment using different resources, EC2 Instance, Lambda, RDS to provision SQL Server, Cloud Watch for Lambda function, Elastic Beanstalk for hosting, S3 for storage, API gateway for lambda action and operation.  Integrated Maximo work package to primavera work product, activities to primavera activities, Maximo Rel to Primavera Project Document, using C#, .NET framework core 2.0, AWS Lambda, AWS S3 bucket.  Setup trigger in AWS for a function to run upon certain function operation.  Performed unit testing using Moq and Xunit.  Created view in Oracle and used Dapper as ORM framework to consume data from Oracle Database.  Consumed Maximo and Primavera web services to perform creation, update and delete operation.  Gather logs in AWS to debug lambda errors.  Moved data within S3 bucket programmatically to achieve certain process.  Led the integration of several other systems using SSIS.  Provisioned SQL Server Database 2016 to be used for Data Warehousing.  Provisioned and Setup SQL Server Reporting Engine for a report to be developed.  Used VSTS and git for source control.  Wrote PowerShell script to call .Net .exe file then use SQL Server to scheduled job that run the .exe.  Led the generation, configuration, and optimization of the performance of the data stores.  Supported the efforts of the test lead and deployment lead to plan, manage, and deploy the application.  Updated logical and physical data model designs with changes.  Documented benchmarks and procedures needed to optimize performance. Ensure that all guidelines are followed.  Provided input on any design decisions for loading data  Provide administrative support for the data store.

Writing of querys such as views, functions, procedures, trigger. Conduction of data analysis on the system. ETL development to exctract, transform and load data from an environment to another. Developed tables as needed creating realtionships among them and making sure its normalized. Report creationst using power bi. Data Analysis and implemetation by designing the logical and physical model. Data dictionaries to make query as fast as possible. Indexing on appropriate fields.