Experience

Precision Dialogue, an RRD company

• United States
• Advertising Services
• 1 - 100 Employee

• Database Architect

  • Mar 2018 - Present



CGI

• Canada
• IT Services and IT Consulting
• 700 & Above Employee

• Data Architect

  • Nov 2007 - Present

  Worked to design and enhance ProperPay (formerly CAS) commercial and government products as member of Architect team. Technical liaison on client projects. Works with external contractors on product functionality. Provided technical support and guidance to development teams and production support teams. Previously managed a group of SQL developers and SQL DBAs that are responsible for loading, retrieval, and maintenance of all data for CGI's ProperPay Auditing System. 17 years experience working in MS SQL Server. Show less



Citi Fund Services Ohio, Inc. / BISYS Fund Services

• Columbus, Ohio Area

• Lead Technical Architect

  • Nov 2004 - Sep 2007

  • Managed resource allocation and workflow assignments for an architectural team. • Applied technology and Design systems to achieve operational goals and business objectives for the company. • Reviewed project requests to determine development approach and relative scope and direction of modifications. • Developed small-scale proof of concept demonstrations of new applications or application components, test new technologies. • Created High-Level Design (HLD) documentation for Application Development. • Reviewed and optimized overall hardware configuration, and coordinated hardware and software purchases. • Administered and enhanced Enterprise Data Warehouse. • Developed SQL Server DTS packages and stored procedures for Crossroad Data Warehouse, BISYS Cash Management System (BCMS), Institutional Center of Excellence (ICE) and Commissions and 12B1 System (ARC12). • Maintained configuration of hardware & software development, testing and production environments. • Responsible for application code base and release management. Show less



BISYS Fund Services

• Financial Services
• 1 - 100 Employee

• Senior Lead Software Engineer

  • Sep 1998 - Nov 2004

  • Designed and developed Enterprise Data Warehouse. Developed SQL Server DTS packages and stored procedures for Crossroad Data Warehouse, BISYS Cash Management System (BCMS) and FundPlex. • Maintained configuration of hardware & software development, testing and production environments. • Monitored project status to ensure established procedures are followed and projects remained on schedule within the prescribed budget. • Planed and managed multiple projects through the development life cycle. • Met with clients or business sponsors to identify and/or create project time frame, scope, requirements, risks and deliverables. • Provided technical advice and guidance for systems development. • Identified and implemented best practices from a technical and user perspective. • Provided maintenance and support for applications. • Identified process improvements to streamline development and reduce man-hours. • Y2K remediation of existing BISYS applications. Show less



Healthcare Research Systems

• Columbus, Ohio Area

• Network Administrator

  • Sep 1996 - Sep 1998

  • Developed new and modified existing IS procedures to enhance network performance for in-house users and external customers. Analyze operational issues and develop workable solutions. • Installed, and maintained all computer and network equipment. Worked with customers to identify system requirements and resolve operational conflicts. • Supervised network support staff and provided ongoing end user training and support. • Performed cost/benefit analysis to assist with software/hardware purchases. Show less



Healthcare Research Systems Ltd

• Columbus, Ohio Area

• Systems Analyst Lead

  • Aug 1995 - Sep 1996

  • Worked with external customers and end users to develop specialized survey reporting systems. • Analyzed and developed detailed program requirements based on customer needs. • Identified process improvements for existing systems and the development of new systems. • Maintained data integrity and improved reporting efficiencies. • Provided on going quality assurance, maintained and enhanced the database driven mail entry system, and upgraded existing programs. • Provided PC tech support and network support to the network administrator. • Provided ongoing staff and end-user training. • Developed statistical analysis program to streamline the reporting process and provided statistics support for staff. Show less



Cardinal Health

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Programmer Analyst II

  • Jan 1995 - Sep 1995

  • Designed, developed and maintained Inventory Control Systems. • Designed, developed and maintained Inventory Control Systems.



Healthcare Research Systems, The Ohio State University College of Medicine

• Columbus, Ohio Area

• System Analyst II

  • Dec 1992 - Jan 1995

  • Worked with external customers and end users to develop specialized survey reporting systems. • Analyzed and developed detailed program requirements based on customer needs. • Identified process improvements for existing systems and the development of new systems. • Maintained data integrity and improved reporting efficiencies. • Provided on going quality assurance, maintained and enhanced the database driven mail entry system, and upgraded existing programs. • Provided ongoing staff and end-user training. Show less



Center on Education and Training for Employment, The Ohio State University College of Education

• Columbus, Ohio Area

• Systems Support Specialist / Consultant

  • Mar 1990 - Dec 1992

  • Designed, tested and documented a variety of software programs. • Designed, developed and maintained several database programs. • Installed and maintained all computer equipment. • Provided cost/benefit analysis to assist with equipment and software purchases. • Performed statistical analysis for research staff. • Provided formal and informal staff training for a variety of computer applications. • Designed, tested and documented a variety of software programs. • Designed, developed and maintained several database programs. • Installed and maintained all computer equipment. • Provided cost/benefit analysis to assist with equipment and software purchases. • Performed statistical analysis for research staff. • Provided formal and informal staff training for a variety of computer applications.



Center on Education and Training for Employment, The Ohio State University College of Education

• Columbus, Ohio Area

• Student Programmer II

  • Mar 1989 - Feb 1990

  • Development of a job-specific basic math application program and an associated tracking system for instructors. • Development of a job-specific basic math application program and an associated tracking system for instructors.