Michael Ekeoma Email & Phone Number

United States

Extensively used SSIS transformations such as lookup, merge, derived column, data conversion, conditional split and aggregate for creating SSIS ETL Solution to Validate, Extract, Transform and Load data to Transaction, using different sources like SQL DB, CSV, REST APIs, JSON, Share point and XLS.Create Package containing several Procedures and Functions in PL/SQL to handle sequencing issue.Migrated database from On-prem to Cloud, implementing ETL workflows, ‘SSIS Package’ to extract transform and load data accurately to new environment with integrity.Created SQL Agent jobs to ensure data accuracy and consistency.Improved SSIS package by creating SCD type 1 and 2 to document and track field changes.Worked extensively on SQL Server, created Stored Procedures, Temporary Tables, Common Table Expressions, Table Variables, Views, Functions and Triggers. Created complex SSRS reports based on functional requirements, ensuring accurate data representation.Enhanced data quality monitoring capabilities by implementing data quality matrices and dashboard using DOMODeveloped a data integration mapping and data architecture diagram using VISO to track field changes in the databaseDesigned an ER diagram to analyze existing data Models and suggest improvement.Mapped out any intermediary dataflow used to stage data from source to target Established and maintained a mature data quality and governance program that ensures the accuracy completeness, consistency, timeliness and security of the organization data line with the ESG goalCreated a project timeline to track the structure breakdown of task for the ESG data quality and governance goalDeveloped data quality and governance policies and procedures, including data quality standards and data governance frameworks

United States

Reviewed code to identify SQL changes to improve system performance.Created tables, manipulated data, and updated data in SQL Server database.Troubleshoot complex SQL queries and stored procedures.Formulated SQL queries using analytical and aggregate functions.Pivot Transformation, Slowly Changing Dimension, Merge Join and Union, making it easier to analyze and present data in a more readable format.Utilized Power BI Desktop for frontend development to create visually appealing and interactive dashboards for fund performance.Creating new measures, using the DAX functions to carry out dynamic calculations including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE on company data.Created SSIS packages to Extract, Transform, and load data using different transformations such as Lookup, Derived Columns, Condition Split, AggregateUsed For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.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.Conducted research and compiled data/reports for requests, surveys, regulatory compliance issues and special projects.

United States

Designing, building, and maintaining complex stored procedures, tables, views, subqueries, triggers, materialized Views, synonyms, and functions for application development.Extensively using multiple Joins, sub-queries, CTEs, and SQL merge joins in stored procedures to load dimension and fact tables incrementally.Writing SQL stored procedures and user-defined functions (UDFS) to be used in SSIS packages and SQL scripts.Creating and implementing database designs and data models.Developing and maintaining database documentation, including data dictionaries, entity relationship diagrams, and standard operating procedures.Creating Normalization and De-Normalization of existing tables for faster query retrieval.Configuring Row-level security to control access to data reports.Developed reusable scripts for data wrangling which improved processes by 10%Developed and tested T-SQL stored procedures and SQL functions for ETL processing including staging and target processing from 10 sources.Developing and deploying SSRS reports using SQL Server Data Tool (SSDT) in Visual Studio.Developed and maintained complex SSIS packages for ETL tasks, enabling seamless data migration from diverse sources, such as Excel, Flat File, .CSV, XML, and OLE DB, to support reporting needs.Leveraged SSIS to validate, extract, transform, and load data into databases, ensuring data accuracy and consistency.Translated intricate business logic into robust database designs, consistently managing them through SQL objects like Stored Procedures, Views, and T-SQL scripting.Proficiently crafted calculated columns and measures within Power BI desktop, enhancing visualizations and Key Performance Indicator (KPI) tracking.Working with the Agile team to streamline tasks in the Sprint cycle.

United States

Developed and maintained complex SQL stored procedures and functions.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.Efficiently oversaw SSIS packages to facilitate data import and transformation between databases and external sources, employing various transformations like Data conversion, Merge Join, Lookup, Sort, Row counts, OLE DB Command, Data flow tasks and Automated ETL processes across millions of rows of data which reduced manual workload by 25% monthly.Established relationships between datasets to allow for cross-filtering and dynamic exploration.Implemented advanced DAX calculations to compute key financial metrics, including ROI, contribution growth rates, and claims cost ratios.Created end-to-end ETL solutions for data extraction, transformation, and loading from diverse sources into Power BI, ensuring data accuracy and integrity.Established proactive monitoring systems to detect and resolve data quality issues, maintaining data integrity across multiple platforms.Continuously improved ETL processes and reporting solutions through data analysis and performance tuning, resulting in increased efficiency and user satisfaction.Actively participate in the implementations' Design, Build, Test, and deployment phases.Collaborated with stakeholders to gather and analyze business requirements, translating them into actionable insights and data-driven solutions, thereby contributing to informed decision-making processes and improved business performance.

California, United States

Created tables, manipulated data, and updated data in SQL server database.Troubleshoot complex SQL queries and stored procedures.Collaborated and assisted analyzing data.Conducted in-depth data analysis and developed compelling visualizations in Power BI to present insights and trends to stakeholders effectively.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.

California, United States

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.

United States

Installation and configuration of devices, printers and other peripherals on LANCustody and Inventory of computer hardware, network devices and parts for daily hardware maintenanceSupported users having data and network connectivity issue.Provided first level support to customers before escalation.Provided back-up for other IT support representatives when needed