Database Architect and Manager
Resume:
Falls Church, VA ***43
Mobile: 703-***-****
Email: ********.*******@***********.***
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