**** ******** ******* *****,

Falls Church, VA ***43

Mobile: 703-***-****

Email: ad11d5@r.postjobfree.com

LinkedIn: www.linkedin.com/in/fredrickomeniho

Fredrick Onyekachi Omeniho

20+ years of experience as a senior IT professional with expertise in Systems and Network Administration alongside System Solutions as it relates to MS SQL Server database, T-SQL, PL/SQL, CQL (Cassandra), Cypher Query Language (Neo4j), stored procedures, user-defined functions, SSRS, SSIS, SSAS, data warehousing, ETL/Data migration, disaster recovery, database replication, data analysis, and programming with Python and R, JSON, XML. Proven track record of designing, implementing, and maintaining large and complex databases, ensuring data integrity and availability, and performance optimization. Strong analytical and problem-solving skills, with a passion for data and technology.

Comfortable with emerging and traditional technologies such as SAIL(Appian), Python, C, C++, C#, JavaScript, Java, REST, PHP, R, T-SQL, JSON, XML, HTML/HTML5, CSS, Graph Database, NoSQL databases, relational databases, docker, Kubernetes, CI/CD and Cloud Infrastructure to name a few.

Percentage of Time Spent Coding/Hands-on: 80%

Most Preferred Interviewing Language: Python

Industry Experience: Investment, Retail/Supply Chain, Education, Finance, HealthCare & Hospitality

Jul 2019 – Dec 2020 University of North America (UONA) Virginia, United States

Masters - Computer Science (Major) & Cyber Security Management (Minor) - CGPA: 4.0

2001 – 2006 Federal University of Technology Owerri (FUTO) Owerri, Nigeria

Bachelor - Computer Science (Major) & Mathematics (Minor) - CGPA: 3.83

Jan 2000 – Dec 2000 National Institute of Information Technology (NIIT) Ikeja, Nigeria

Advanced Certificate in Enterprise Application Development (Global Net Curriculum).

Skills

Strong leadership and Problem-solving skills

Strong communication and interpersonal skills

Great teamwork player and collaborator

Experience with the technicalities and procedures of change management

Experience with the resolution of incidents to guarantee uptime as provided by SLA

Expertise in reporting and collaborating with matrixed stakeholders

MSSQL Server 6.5/7/2000/05/08/08R2/12/14/16/17/19 & 22, T-SQL, Stored Procedures, User-Defined Functions, Triggers, SSRS, SSIS, SSAS, Data Warehousing, Database Replication, Data Analysis, Python, R, JSON, XML, Data Integrity, Database Performance Optimization, Database Tuning, Training and Support.

Database Design, Modeling, Database Normalization, Data Migration, Data Integration, Security and Access Control, Database Backup Strategies, Database Mirroring, Database, Log shipping, Disaster Recovery Strategies, System Monitoring, and Maintenance

Expertise with design tools like MSSQL Management Studio, Erwin, Toad, ER/Studio, MySQL Workbench, Moqups, MS Visio

Strong software development skills in various programming languages such as Java, Python, VB, VBA, C#, C, C++, JavaScript, VBScript, Jira and more.

MS Access, MS Excel, Google Sheets, Tableau, Power BI, Snowflake, and Crystal Reports

Experience with Agile methodologies and DevOps

Expertise in system integration

Expertise in the implementation of EDI standards (ANSI X12)

Windows Server OS, Windows OS, Red Hat Linux, Ubuntu, Kali Linux, CentOS.

Design, Implementation, and Maintenance of LAN, WLAN, VLAN, and WAN.

Microsoft Hyper-V, Oracle VM VirtualBox, VMware Sphere, VMware Workstation.

Microsoft RDC, VPN, SSH, Remote Monitoring.

Experience with Public Key Infrastructure and Certificate tools like OpenSSL, EasyRSA, Java Keytool, ACM, Windows Certificate Manager, etc.

Experience with Single sign-on, and 2FA/MFA systems; Cisco Duo, Okta, RSA SecurID, and Symantec VIP Access.

Experience with cloud-based platforms and technologies, such as GCP, AWS, and Azure

Experience in distributed tech with knowledge of performance trade-offs and disaster recovery

Experience resolving incidents to guarantee uptime and in line with the terms provided by SLA

Jan 2021 – Till Date Renoxx Lead Solutions Architect/Database Administrator

oResolved incidents to guarantee uptime as provided by SLA of the various departments

oPerformed database administrator functions

oPerformed software and database development tasks

oPerformed infrastructure/system engineering functions

oPerformed administrative functions like team member evaluation based on KPI

oReported to management and other non-IT stakeholders

oLed the design and implementation of EDI processing and reconciliation, ensuring seamless data exchange between internal systems and external partners.

oDeveloped and maintained SQL scripts for data transformation, mapping, and validation, resulting in a 20% reduction in processing time.

oImplemented EDI standards (ANSI X12 – 837 & 835) and collaborated with cross-functional teams to troubleshoot and resolve EDI-related issues.

oSuccessfully integrated SQL databases with EDI software, enhancing data accuracy and consistency.

oLed the migration of a legacy relational database to Neo4j, resulting in improved insight into clients, subscribers, group subscribers, service providers, supervisors, insurance providers, service allocation, and service consumption giving rise to better service allocation and scheduling.

oCollaborated with business analysts and stakeholders to gather requirements and translate them into effective graph data models.

oImplemented and maintained data import/export processes between Neo4j and other relational data storage systems, ensuring seamless data flow and integration.

oConducted training sessions for development teams on Neo4j best practices and usage, fostering a deeper understanding of graph database concepts.

oManaged and optimized Snowflake databases, ensuring high performance and scalability.

oImplemented security measures in Snowflake, including encryption and access controls.

oConducted regular vulnerability assessments and implemented remediation strategies.

oAutomated security tasks using scripting languages like Python, PowerShell, and Bash.

oLed database administration efforts, including schema design and ETL processes.

oImplemented security best practices for databases and contributed to the secure development lifecycle.

oIn-progress (Appian Infrastructure)

Modernizing and scaling all four (4) software platforms to achieve software as a service (SaaS) architecture using Appian BPMN (manage workflow) and Infrastructure, thus raising the organization’s earnings by a projected 75% within the next 5 years.

Design and develop an automated subscription module to be integrated into all four (4) Appian applications.

Designing and optimizing complex workflows, including task assignments, escalations, and notifications, to ensure streamlined business processes.

Spearheading the migration of legacy systems to Appian, forecasted to result in a 40% reduction in maintenance costs and improved user experience.

Leading a 10-man development team in the successful implementation of Appian solutions.

Conducting code reviews and providing mentorship to junior developers to enhance team productivity and code quality.

Implementing best practices for application design, including process modeling, user interface design, and integration with external systems.

Developing custom plug-ins and integrations with third-party systems using Java, JavaScript, and Python to improve system interoperability.

Implementing advanced reporting and analytics solutions within Appian, enabling real-time monitoring and decision-making.

oAchievement in the first 1 year

Led and directed the conversion of all (4) existing applications to a more robust architecture, improved performance, enhanced security, and ease of disaster recovery which was forecasted to reduce downtime to 0.001% going forward;

MySQL to MSSQL with complex stored procedures, functions, and triggers as needed

PHP to C#, ASP, JavaScript & Python

Implemented data processing scripts, leveraging libraries such as Pandas and NumPy for efficient data manipulation in combination with MS SQL stored procedures

Dec 2019 – Dec 2020 Appteon Software Engineer/Database Administrator

oResolved incidents to guarantee uptime as provided by SLA of the various departments

oPerformed software and database development tasks

oRevolutionized the organization’s Appian development style into a true object-oriented cum service-oriented design paradigm within a month of learning Appian Cloud Development by bringing prior knowledge of;

architecting enterprise-scale and analysis-ready databases

converting business model/logic to software blueprint/BPMN

modularity and code reusability in archiving a service-oriented architecture

oWorking across project teams to provide optimization strategies, bug fixes, technical guidance, and support for the entire development process in wiping technical debts.

OFCCP Team – Office of Federal Contract Compliance Program

OTAA Team – Office of Trade Adjustment Assistance

AEMF Team – Apprenticeship Expansion and Modernization Funds

oDeveloped a well-thought-out plan that helps produce a simple and scalable solution to meet clients’ needs.

oDesigned and drafted six (6) DOL approved Mentorship Plans and Apprenticeship Roadmaps and Curricula for Appteon's Apprenticeship Program for the following occupations.

Software Developer, Software Engineer, Software Architect, Database Developer, Software Tester & Quality Assurance, Business Analyst (* Got approved by the DOL without comment for the first time in a long while).

Sep 2019 – Nov 2019 University of North America IT Helpdesk/Network Support Assistant

oRestructured the Universities’ LAN & WLAN, and VPN architecture to limit vulnerability.

oCreated a customized workplace group policy for the Universities’ network.

oInstalled and administered a network of Intrusion Detection Systems for UONA.

oInstituted Active Directory and Group Policy for UONA.

Mar 2008 – May 2019 PrimeApps Lead Solutions Architect/Engineer

ERP/CRM/WMS/MMS Experience

oImplemented agile methodologies and Scrum practices, resulting in a 30% increase in productivity and a 50% reduction in project completion time.

oDeveloped and executed technical software development strategy for e-commerce applications and systems using the current business roadmap by analyzing competitive trends and patterns; analyzing the technology landscape; evaluating short- and long-term implications; and communicating strategies and change initiatives.

oWorked closely with stakeholders, including business analysts and product managers, to define requirements, set project goals, and deliver software products on time and within budget.

oCollaborated with cross-functional teams to drive continuous process improvement and innovation by identifying inefficiencies in current processes; improving the agility of the team; and adopting industry trends for innovation to support business objectives.

oImplemented continuous integration and delivery practices, resulting in a 50% reduction in deployment time.

oEnsured product quality by developing and executing quality assurance plans; using data and experience to determine customer needs; directing continuous improvement and eliminating non-value-added work; measuring milestones for quality; and developing mitigation plans to ensure quality.

oImplemented new features and functionalities to improve the overall performance and user experience of the software systems.

oProvided technical guidance and mentorship to team members to improve their technical skills.

oDeveloped and maintained software systems used in inventory management, sales operations, reporting, and price optimization.

oDeveloped and maintained software development processes and standards, including coding, testing, and documentation.

oLed the design and implementation of EDI processing and reconciliation, ensuring seamless data exchange between internal systems and external partners.

oImplemented EDI standards (ANSI X12 – 810 & 850) and collaborated with cross-functional teams to troubleshoot and resolve EDI-related issues.

oArchitected and led application design, development, implementation, support, and bug fixes with application design/implementation covering

Point Of Sale Management

Client Relationship Management, Operations/Back Office Management,

AR, AP, and Expense/Journal Management, Fixed Asset Management

Financial Reporting (Operating statement, P & L, Balance sheet, General Ledger) and Bank Reconciliation

Human Resources and Payroll Management

Inventory Tracking, Reporting, and Barcoding/Labelling complexities

Warehouse and Dispensary Management

Manufacturing/Production Management (Cost and Raw Material Management)

Maintenance Management

oAchieved enterprise system security using Windows Server as the domain controller with Windows and Azure AD.

oDatabases used include; Oracle, MySQL, PostgreSQL, DB2, Informix, and MSSQL database

oThis was implemented for multiple clients with multiple retail outlets and warehouses and having numerous users in various departments.

Data Mining/Reporting Experience

oSpearheaded the designing and implementation of a robust Neo4j graph database system to model and analyze customer purchasing behavior, resulting in a 20% improvement in targeted marketing campaigns for supplementary and complimentary items, raising annual sales by 30%.

oCollaborated with cross-functional teams to identify and define graph data models based on business requirements, ensuring optimal representation of relationships between entities such as products, customers, and transactions.

oImplemented optimized Cypher queries to enhance query performance, reducing response times by 30% and improving overall system efficiency.

oDeveloped and maintained ETL processes to integrate data from various relational databases into the Neo4j graph database, ensuring data accuracy and integrity.

oConducted regular performance tuning and troubleshooting to address bottlenecks, ensuring a scalable and high-performance graph database system.

Financial Modelling Experience

This is an Enterprise software solution for handling NSE (Nigerian Stock Exchange) Stocks Market and Commodities Market historical data analysis towards clients’ investment recommendations for both short- and long-term investments.

This application made heavy use of the daily trading data from the floor of the stock exchange market and a lot of Financial Ratios like;

- Profitability Ratios, Liquidity Ratios, Solvency Ratios, Valuation Ratios, etc.

extracted from historical financial statements.

Enterprise database application design, development, implementation, and administration - Stock Market Index Analytics, Data Archiving System with Integrated Performance Dashboard, Document Archiving System, and Stock Screening System.

Database Developer/Administrator, Network Administrator & Site Reliability Experience

oRearchitected and refactored clients’ solutions for better performance, scalability, and availability

oDesign, implement, and maintain large and complex MSSQL Server databases, ensuring data integrity and availability

oDeveloped, implemented, and maintained complex data models using Entity Relationships and user-defined data types for consistency and integrity

oDevelop and maintain T-SQL views, stored procedures, and user-defined functions

oDesigned and implemented large and complex MSSQL Server databases

oDeveloped and maintained T-SQL stored procedures and user-defined functions

oTroubleshoot and optimize slow-performing queries

oDesigned and implemented advanced ETL processes for database migration, data integration, and analysis from MySQL, Oracle, PostgreSQL, and DB2 to MSSQL.

oDeveloped and maintained SQL scripts for data transformation, mapping, and validation, resulting in a 20% reduction in processing time.

oDeveloped and maintained SQL scripts for data transformation, mapping, and validation, resulting in a 20% reduction in processing time.

oSuccessfully integrated SQL databases with EDI software, enhancing data integrity.

oDesigned and implemented data migration during MSSQL Server Upgrade from the prior editions while taking advantage of new features and not overlooking backward incompatibilities as the application may require, from version 08, 08R2, 12, 14, 16, 17, to 19

oOLAP Cube Development using MDX, SSAS Cubes

oDeveloped and maintained data warehouses using SSAS and related technologies

oDeveloped and maintained SSRS reports and dashboards

oDesigned, developed, and maintained SSIS packages for data integration and analysis

oImplemented and maintained disaster recovery strategies using MSSQL backup and restore utilities, log shipping, database mirroring, and replication via both manual and automated using MS SQL Agent Jobs.

oConfigured MSSQL Database/Server performance optimization settings on Windows Server

oOptimize database performance through indexing, partitioning, and other techniques including reviewing the MSSQL execution plan and other strategies

oUtilize Python and R scripting languages for advanced data analysis and edge cases

oConfigured Role Based permission/privileges on both MS SQL Server and Windows Server

oMaintained documentation of data standards, procedures, constraints, relationships, and definitions for the data dictionary.

oCreated, configured, and supported both machine and application isolation using virtualization technologies like VMware, Oracle VirtualBox, and Microsoft Hyper-V, and containerization technologies like Docker & Kubernetes

oTroubleshoot and resolve database server, database, and hardware issues promptly

oProvided systems administration and support during routine maintenance and on-call including; configuring CPU, memory, and disk partitions for both physical and logical/virtual servers, performance tuning, hardware upgrades, resource optimization, and configuring new hardware and software with and without PowerShell

oRestructured clients’ LAN & WLAN, and VPN architecture to limit vulnerability.

oProvided Network Administration support with knowledge of network protocols (TCP/IP, SSL/TLS, DNS, SNMP, FTP, SFTP, SSH), WAF, Device-based Firewalls, and network devices (APs, Routers, Switches), cabling, LAN, WLAN, VLAN, WAN, VPN among others.

oProvide training and support to junior team members

oResolved incidents to guarantee uptime as provided by SLA

[Jan 2006 – Feb 2008] MindCraft Head - Application Development

oStandardized and automated application migration and release procedures that enhanced the application delivery process and decreased error by > 50%.

oEstablished a standardized process to streamline development, testing, approval, and product release for over 23 client locations.

oPerformed business process re-engineering for many start-up organizations.

[Nov 2004 – Dec 2005] MindCraft Team Lead - Application Development

oLed and directed the conversion of all existing enterprise desktop applications into full web-based (ASP/MSSQL) applications.

[Apr 2002 – Oct 2004] MindCraft Software Application Developer

oIntroduced and implemented a modular programming concept that reduced development time while enabling code reuse and eased debugging.

[Jan 2001 – Mar 2002] MindCraft Software Developer & Tech Support

oIntroduced and spearheaded technical support over the phone, this reduced the cost of transportation to the client site by almost 65% annually.

Contact this candidate