ServiceNow
Obinna Alozie
Pittsburgh,PA
Summary
Skilled professional excelling in developing efficient processes, strategizing data planning, and establishing robust data frameworks. Keen eye for detail specializing in creating business intelligence analytical reports and devising effective access methods to tackle complex data load and management challenges. Expertise lies in streamlining operations and optimizing data-driven decision-making processes.
Overview
16
16
years of professional experience
Work History
Senior Programmer
UPMC Corporate Services
07.2020 - 04.2024
- Configured and maintained database servers and processes
- Ensured high levels of performance, availability, sustainability, and security
- Performed scheduled maintenance and support release deployment.
- Performed regression and system-level testing to verify software quality prior to release.
- Tested and deployed scalable and highly available software products.
- Designed and implemented scalable applications for data extraction and analysis.
- Implemented innovative systems for data collection.
- Wrote highly maintainable, solid code for software system.
- Developed reports using SQL server reporting services.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Developed custom reports for business stakeholders, providing valuable insights into key performance metrics.
- Mentored junior developers on best practices in ETL development, fostering a culture of continuous learning within the team.
- Conducted regular code reviews to ensure adherence to coding standards and maintain overall code quality across projects.
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
- Resolved production issues quickly and efficiently, minimizing downtime and maintaining high levels of user satisfaction.
- Streamlined data processing for improved efficiency by implementing performance tuning techniques.
- Conducted regular informatica server maintenance activities, ensuring high availability of services at all times while minimizing downtime risks.
- Optimized database management through the creation of robust ETL mappings, sessions, and workflows.
- Participated in code reviews, ensuring adherence to established coding standards and promoting continuous improvement within the team.
- Spearheaded the migration of existing ETL processes to Informatica platform, ensuring seamless transition.
- Corrected, modified and upgraded software to improve performance.
- Managed source control repositories to maintain versioning history of developed objects effectively.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Provided technical support for end-users by addressing SQL-related issues, enhancing overall user satisfaction with the application.
Senior Systems Analyst
UPMC Corporate Services
01.2011 - 07.2020
- Managed SQL Server databases, tables, and jobs - Configured and maintained database servers and processes
- Ensured high levels of performance, availability, sustainability, and security
- Cultivated a positive work environment that fostered teamwork, collaboration, and continuous improvement.
- Monitored and observed security servers.
- Utilized change management techniques to provide smooth transitions during new hardware and software introductions.
- Audited multi-system installations for conformance to business objectives, suggesting changes to meet performance thresholds.
- Documented ongoing system performance, verifying data metrics.
- Led successful system migrations, ensuring minimal disruption to business operations during transitions.
- Mentored junior analysts, fostering supportive learning environment that enabled professional growth within my team.
- Developed comprehensive user documentation, enabling efficient knowledge transfer between team members and clients.
- Enhanced system efficiency by optimizing software applications and introducing new technologies.
- Participated in acquiring and maintaining database contracts.
- Streamlined business processes by automating manual tasks, increasing productivity and reducing errors.
- Enhanced user experience by developing visually appealing and interactive dashboards using BI tools such as Tableau or MS PowerBI for effective data visualization.
- Demonstrated respect, friendliness and willingness to help wherever needed.
- Proved successful working within tight deadlines and a fast-paced environment.
- Ensured data integrity through rigorous testing and validation of ETL code.
- Streamlined data extraction, transformation, and loading for improved overall system performance.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Trained junior DBAs on best practices in SQL Server administration, fostering a collaborative environment where team members could continually grow their skills.
- Evaluated emerging technologies related to SQL Server administration; recommended strategic improvements benefiting both IT infrastructure and business objectives.
- Provided 24/7 support for critical database systems, quickly resolving any incidents that arose to minimize disruption to business operations.
Senior Data Coordinator
UPMC Children’s Hospital of Pittsburgh
Pittsburgh, PA
09.2008 - 01.2011
- Served as Lung and heart transplant program Senior Data Coordinator ensuring collection and entry of all patient clinical data into
- Developed and applied program data quality plans
- Managed transplant patient waitlist and completion
- Coordinated data entry and supported database users
- Built and generated statistical and department program performance reports
- Conducted research Honest Broker tasks
- Coordinated with research coordinators and Principal investigators
- Analyzed current systems and recommended new tools
- Coordinated with hospital helpdesk and external vendors
- Conducted data analysis and created quality analytics reports
- Ensured compliance with regulatory requirements for data transmission, storage, and data access.
- Served as point-of-contact for external partners and clients, addressing inquiries or concerns related to data-sharing agreements and protocols.
- Ensured timely completion of projects by efficiently coordinating cross-functional teams involved in data management activities.
- Conducted thorough audits on existing databases to identify errors, inconsistencies, or areas needing improvement.
- Facilitated communication between departments, ensuring alignment of data-related objectives and strategies.
- Ensured compliance with industry standards and regulations regarding sensitive information handling protocols, maintaining strict confidentiality where necessary.
- Developed comprehensive documentation to facilitate a seamless transfer of knowledge among team members and stakeholders.
- Managed complex datasets with precision, ensuring accurate representation of organizational trends over time.
- Evaluated effectiveness of current software tools used in managing company's database system; recommended updates or replacements as needed.
- Maintained an up-to-date knowledge base on emerging trends within the field of Data Coordination; applied new approaches as appropriate.
- Extracted system data, identifying challenges and proposing development solutions.
Education
Certificate - Cyber Security
Massachusetts Institute of Technology
Cambridge, MA11.2024
Master of Science - Information Technology
Kaplan University
Davenport, IA07.2011
Bachelor of Science - Information Technology
Kaplan University
Davenport, IA07.2009
Skills
- Service Bench and ServiceNow AdministrationStrong Communication Skills
- Efficient Project Management
- Big Data Processing
- Debugging
- Data Visualization Techniques
- Advanced Data Structures
- Solid Database Management
- Performance Tuning Expert
- Skilled in Cybersecurity
- ServiceNow and Service Bench Administrator
- Excellent Team Leadership
- ETL development
- Project management abilities
- DBMS
- Continuous integration tools
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Recentexperience
- Senior Programmer, UPMC Corporate Services, 07/01/20, 04/01/24, Managed SQL Server databases, tables, and jobs, Configured and maintained database servers and processes., Ensured high levels of performance, availability, sustainability, and security., Configured, Analyzed, resolved issues in real time and offer critical recommendations for solutions., Enhanced and automated regular processes and job calls, tracked issues, and documented changes as they occur to help ease future interruptions., Query tuning and schema refinement., Provide 24x7 support for critical production systems., Perform scheduled maintenance and support release deployment activities after hours., Managed user permissions, Extractor, Transformation and Loading (ETL), Cognos reporting, PowerBI and Qlik, SQL Oracle Administration, Cyber Server Monitoring
Primaryskills
- Self-starter with the ability to work independently and take initiatives.
- Solid understanding of automated database systems
- Requirement specifications gathering, documenting functional and nonfunctional requirements.
- Proficiency in Database Administration on Production Servers with server configuration, monitoring, performance tuning and maintenance with outstanding troubleshooting capabilities.
- Able to monitor performance and troubleshoot business-level problems at the server level (triage) and work with Development/QA/BA teams to provide guidance and advice on issues.
- Working knowledge of Microsoft Server, Active Directory and Informatica tool
- Ability to handle multiple tasks and adapt to a constantly changing environment.
- Excellent knowledge on Informatica and Data base (Oracle)
- Experience in ETL using SQL Server Integration Services (SSIS), report generation using SQL Server Reporting Services (SSRS), and data mining for Business Intelligence using SQL Server Analysis Services (SSAS).
- Cognos reporting, PowerBI and Qlik SQL Oracle Administration
- Microsoft Azure Databricks
Recentexperience
- Senior Programmer, UPMC Corporate Services, 07/01/20, 04/01/24, Managed SQL Server databases, tables, and jobs, Configured and maintained database servers and processes., Ensured high levels of performance, availability, sustainability, and security., Configured, Analyzed, resolved issues in real time and offer critical recommendations for solutions., Enhanced and automated regular processes and job calls, tracked issues, and documented changes as they occur to help ease future interruptions., Query tuning and schema refinement., Provide 24x7 support for critical production systems., Perform scheduled maintenance and support release deployment activities after hours., Managed user permissions, Extractor, Transformation and Loading (ETL), Cognos reporting, PowerBI and Qlik, SQL Oracle Administration, Cyber Server Monitoring
- Senior Systems Analyst, UPMC Corporate Services, 01/01/11, 07/01/20, Managed SQL Server databases, tables, and jobs, Configured and maintained database servers and processes., Monitor system's health and performance., Ensure high levels of performance, availability, sustainability, and security., Configured, Analyzed, resolved issues in real time and offer critical recommendations for solutions., Enhanced and automated regular processes and job calls, tracked issues, and documented changes as they occur to help ease future interruptions., Query tuning and schema refinement., Provide 24x7 support for critical production systems., Perform scheduled maintenance and support release deployment activities after hours., Managed user permissions, Extractor, Transformation and Loading (ETL), Cognos reporting, PowerBI and Qlik, SQL Oracle Administration, Monitored and observed security servers.
- Senior Data Coordinator, UPMC Children’s Hospital of Pittsburgh, 09/01/08, 01/01/11, Served as the hospital’s Lung and heart transplant program Senior Data Coordinator with the following responsibilities:, Developed, and applied program data quality plans for monitoring data integrity and recurrent database updates and general maintenance of the transplant database systems., Managed transplant patient waitlist, completion and regularly validated numerous United Network for Organ Sharing (UNOS) transplant forms on the UNet system., Coordinated data entry, supported database users, maintain regular contact with clinical research associates and medical team to ensure all required data are collected and entered the database system., Built and generated weekly/monthly statistical and department program performance reports using software packages such as Cognos, and SPSS., Research Honest Broker tasks: extracting, declassifying, and presenting patient data used for research., Coordinated with research coordinators and Principal investigators to identify, collect, sort, and enter data into research database., Continuously worked together with department leadership, clinicians, and users to analyze current systems and recommend where necessary new tools necessary to perform their jobs (e.g., interfacing external lab systems to directly push lab results in UPMC transplant patient management system., Coordinated with hospital helpdesk and other external vendors to resolve database system issues., Data Analysis & creation of quality analytics reports for various units using business intelligent tools such as IBM Cognos., Ensures compliance with regulatory requirements for data transmission, storage, and data access including documentation, testing, and remediation and Security.
Software
ServiceBench
Timeline
Senior Programmer
UPMC Corporate Services
07.2020 - 04.2024
Senior Systems Analyst
UPMC Corporate Services
01.2011 - 07.2020
Senior Data Coordinator
UPMC Children’s Hospital of Pittsburgh
09.2008 - 01.2011
Certificate - Cyber Security
Massachusetts Institute of Technology
Master of Science - Information Technology
Kaplan University
Bachelor of Science - Information Technology
Kaplan University
Primaryskills
- Self-starter with the ability to work independently and take initiatives.
- Solid understanding of automated database systems
- Requirement specifications gathering, documenting functional and nonfunctional requirements.
- Proficiency in Database Administration on Production Servers with server configuration, monitoring, performance tuning and maintenance with outstanding troubleshooting capabilities.
- Able to monitor performance and troubleshoot business-level problems at the server level (triage) and work with Development/QA/BA teams to provide guidance and advice on issues.
- Working knowledge of Microsoft Server, Active Directory and Informatica tool
- Ability to handle multiple tasks and adapt to a constantly changing environment.
- Excellent knowledge on Informatica and Data base (Oracle)
- Experience in ETL using SQL Server Integration Services (SSIS), report generation using SQL Server Reporting Services (SSRS), and data mining for Business Intelligence using SQL Server Analysis Services (SSAS).
- Cognos reporting, PowerBI and Qlik SQL Oracle Administration
- Microsoft Azure Databricks
- Service Bench and ServiceNow Administration - Creating orders, managing user and super user access
Similar Profiles
Denise BlackburnDenise Blackburn
Inpatient Medical Coder at UPMC Corporate ServicesInpatient Medical Coder at UPMC Corporate Services
Jennifer TamburroJennifer Tamburro
AR Account Specialist at UPMC Corporate ServicesAR Account Specialist at UPMC Corporate Services
Kristen SchumacherKristen Schumacher
Account Representative Sr./Medical Billing Specialist at UPMC Mon Yough Community ServicesAccount Representative Sr./Medical Billing Specialist at UPMC Mon Yough Community Services