Michael C. Ekeoma

California, Ca +1-916-***-**** ad2eem@r.postjobfree.com

SQL Developer/Power BI Developer

CAREER SUMMARY:

• Backend SQL Server programmer with 5+ years of hands-on experience writing simple to complex SQL queries, writing Stored Procedures, creating Views, and joining tables from the SQL Server database.

• Power BI Developer with 5 years of experience delivering actionable insights to companies by creating custom Microsoft Power BI dashboards and reports. Focused on designing easy translated solutions that align with the firm’s data management principles and policies.

SKILLS:

• Strong communication, Patience, Problem Solving, Time Management, Team Building. Responsible, highly motivated, and strong commitment to cooperative teamwork TECHNICAL SKILLS:

Databases SQL Server, MySQL

Database Tools SSMS, Configuration Manager, SQL Server, MS SQL Server, Power BI, MS Project

Technical Tools Database MS-SQL Server, Power BI, DAX, ETL, (SSIS), Tenable Nessus Pro, Splunk, Burp Suite Pro.

Operating System Microsoft’s Windows, Apple’s MacOS and Linux. Methodologies Agile, Waterfall, Scrum, FISMA-NIST SP 800 series, Vulnerability/Patch Management, SDLC, RMF, POAM, SSP, ATO Package, SOC, Technical Documentation.

EXPERIENCE:

EMADE CONSULTING -SQL Developer/Power BI Developer March-2022 to Present

• Reviewed code to identify SQL changes to improve system performance.

• Created tables, manipulated data, and updated data in MySQL Server database.

• Troubleshoot complex SQL queries and stored procedures.

• Formulated SQL queries using analytical and aggregate functions.

• Helped team implement important BI systems for insights on company data and changes to existing BI systems. Creating new measures, using the DAX functions to carry out dynamic calculations on company data.

• Created reporting systems that provide accessible information for accurate decision making.

• Developed and maintained constructive and cooperative working relationships with corporate team members.

• Document program development logic, coding, and corrections.

• Providing data analysis that is cogent and timely.

• Analyzing data to identify business problems.

• Analyze source files and prepare documents with the mapping details from source to target files.

• Identified and analyzed user requirements, procedures, and problems to improve existing processes.

• Produce key departmental performance metrics and adhoc reports.

• Develop design specifications and test plans/scripts to meet business requirements.

• Conducted user acceptance testing to ensure that developed systems satisfied the needs of clients.

Michael C. Ekeoma

California, Ca +1-916-***-**** ad2eem@r.postjobfree.com

• Conducted research and compiled data/reports for requests, surveys, regulatory compliance issues and special projects.

EMADE CONSULTING - Database Developer September-2020 to March-2022

• Developed and tested T-SQL stored procedures and SQL functions for ETL processing including staging and target processing from 10 sources.

• Experience in creating temp tables, CTE and Table variables for improving performance in T-SQL code.

• Created and debugged complex stored procedures, views and functions for better performance and flexibility.

• Worked closely with quality assurance analyst and business analysts.

• Developed reusable scripts for data wrangling which improved processes by 10%. EMADE CONSULTING - Quality Engineer August-2019 to September-2020

• Worked closely with 15 teams across the company to identify and solve business challenges utilizing large structured and unstructured data in a distributed processing environment.

• Developed a new pricing strategy that boosted margins by 4 percent.

• Automated ETL processes across millions of rows of data which reduced manual workload by 25% monthly.

EMADE CONSULTING-Data Analyst June-2018 to August-2019

• Created tables, manipulated data, and updated data in MySQL Server database.

• Troubleshoot complex SQL queries and stored procedures.

• Collaborated and assisted analyzing data.

• Leveraged SQL-based data systems, collected and integrated data.

• Formulated SQL queries using analytical and aggregate functions.

• Assisted in report and dashboard creation.

• Assisted in user acceptance testing.

EMADE CONSULTING-Information Security System Analyst July-2017 to May-2018

• Develop, review, and update Information Security System Policies, System Security Plans, and Security baselines in accordance with NIST, FISMA, OMB and industry best security practices. Applied appropriate information security control for Federal Information System based on NIST 800-37, SP 800-53, FIPS 199, FIPS 200.

• Create ATO packages such as System Security Plan (SSP), Risk Assessment Report

(RAR), Security Assessment Report (SAR), Plan of Action, and Milestones (POA&Ms) for over 5 IT systems.

• Review and update security authorization documents as needed, perform periodic internal audits, vulnerability scanning using Nessus and Web Application security testing using tools such as Burp Suite Pro.

• Real-time monitoring of systems for possible security incidents, using Splunk.

• Working with Developers, System Engineers and in ensuring security is baked into the SDLC process.

• Performed Security Incident Response activities including investigations, follow-up and coordinating with the SOC to resolve Incident tickets. IT Support Specialist – Aiko Freights LLC February-2016 to June-2017

• Installation and configuration of devices, printers and other peripherals on LAN

• Custody and Inventory of computer hardware, network devices and parts for daily hardware maintenance

• Supported users having data and network connectivity issue. Michael C. Ekeoma

California, Ca +1-916-***-**** ad2eem@r.postjobfree.com

• Provided first level support to customers before escalation.

• Provided back-up for other IT support representatives when needed. EDUCATION:

University Of Calabar 09/2014

Bachelor Of Science, Degree in Applied Geophysics

SECURITY CLEARANCE LEVEL:

Eligible for clearance.

REFERENCES:

Available upon request

Contact this candidate