Anthony Patrick Email & Phone Number

United States

Clients include an Accounting Firm, a third party Claim Processing Bureau for The Second Injury Fund, a Large Financial Institution based in Columbia as well as a consultant for an Application Integration company. I have been responsible for managing all facetsof these projects. Including supervising less experienced developers.Some projects include…..WCS - Created a Custom Accounting browser app for a small business including payroll, timekeeping, and an invoicing system. (ASP.NET)BSolutions - Processed 4 separate data conversions with over 15 million records using SQL 2000, Visual Basic 6 , and ADO. Welch Consulting Group - Created Custom Claim processing system to track file info for over 30,000 clients.(VB.NET) Met with the owner and end users to design an application which transformed their business from a file based system to a computer based system. Sourcelink – ASP.Net VB.Net, C#, SQL, Crystal Reports - Customized third party application so it was a better fit for the clients business model. Modifications and enhancements to a backoffice app managing accounting, inventory, client relationships, job scheduling and tracking as well as job costing.HP – .NET, SSIS ETL/BI Tools - Conversion Team for new Court Case management System being developed to manage and track family court proceedings and Child Support Enforcement activities

Columbia, South Carolina Area

Data Quality Manager DSS – Current RoleManaged a team responsible for researching and reporting data integrity and data quality related issues in the PACSS application. Using data mining methods as well as business expertise to identify case, employer, and member related scenarios that violated database integrity constraints or PACSS business rules. Due to the conversion into PACSS of 47 disparate systems, it is imperative to implement a strong data Quality initiative. Worked with State SME’s, BA’s, as well as executive leadership, to help identify and correct issues typical in this type of enterprise wide application with the vast degree of complexity. These issues may be the result of conversion, application bugs, or user error. Interfaces with other DSS departments such as Medicaid , SNAP/IVA, and IVE(Foster Care), bringing data into PACSS were analyzed for Data Integrity and accuracy.Designed and Implemented a process where issues were identified, prioritized, developed, tested and released to users for corrections. Created recurring jobs to run each month for distribution to users. Communicated with stakeholders and end-user’s best practices and data entry process changes as well as the long term effect it will have on the effectiveness of PACSS.

Columbia, South Carolina, United States

Data Conversion Manager DSS – Previous RoleCompleted statewide rollout of a Federally Certified Child Support Enforcement System. During my time on this project, I have led the state team through the Data Conversion Requirements, Design, and test phases of the project. The Successful rollout of the new system to 46 South Carolina counties. The Conversion of over 270,000 cases, and over 650,000 member records.During the initial stage of the project, I provided the required services to build and recruit a strong and qualified State team (through State Beeline recruiting process), worked with the vendor (Xerox/Conduent/Protech) to further clarify contractual obligations and met with the Clerks of Court stakeholders to confirm assumptions remaining from the last project. During this requirements phase, the technical design of the conversion framework was created. Mr. Patrick was integral in creating the Data Conversion Plan laying out the foundation of a successful implementation. I created, estimated, and resourced the project schedule of over three years from Design to Production. An Integral part of the State leadership, I worked with various teams from Functional, testing, training, an implementation/Site-Support. I maintained and managed the Microsoft Project plan for Conversion related tasks, reporting statuses weekly to the project team, and monthly to the Federal Oversight body. I effectively communicated to all levels of management, internal and external to the project team.This team performed as a cohesive unit and exceled in all facets of their work under my leadership. My consistent approach to high quality and self-empowerment provided the team a person they enjoyed working for and with.I reviewed and approved Functional design documents as well as technical design documents. I was an integral part of the requirements definition and review team and aided in the modeling of Business processes, both as-is and to-be.

Columbia, South Carolina Area

Managed analytics and reporting project to deliver a system that is state of the art to south Carolina Medicaid services. Transforming the business from a fee for service to a quality of care model. Taking advantage of EHR and other relevant information to drive to a new way of doing Medicaid analysis.Managed the Fraud team in the RFP process. This was Requirements, and design phase of the MMIS Project to implement a modernization application to conform to the Affordable Care Act requirements. Managed a team of three resources who were responsible for creating the RFP for a COTS system to replace the former Pearson system. Understanding of the current application and needed changes was imperative in understanding the needs of the new system. I interviewed stakeholders and end users to ensure current processes would be maintained and documented any business process changes needed. I also reviewed application design documents for clarity and conciseness.I defined and documented a Data Governance framework for the MMIS application and Interfaces. Working with Departments managers, key data stewards as well as interfacing agency representatives, I presented the road map, key data elements, Data Dictionary, data stewardship plan. This included acquiring tools, defining processes, and developing the Project plan and schedule from Design to implementation at the enterprise level.

Information Management And Analytics

Working as a consultant with the Information Management and Analytics division I wear several hats. I work with clients to provide consulting, architecture, implementation, and management solutions while delivering a business intelligence foundation. These services provide the ability to convert "big data" into practical, contextual facts and figures, unlocking the value in an organization's data mines. This connected intelligence enables clients to proactively manage information-related business risk, enhance customer experiences, and optimize business performance to create competitive advantage and discover new market opportunities.

Architect, Team Lead and Project manager for CFS Project Data Conversion Developer Team. Responsible for team of up to 14 analysts and 15 developers developing processes to load legacy application County Court data into the databases for new CSES and FCCMS applications. Interface with client and upper management setting priorities, delegating tasks to meet deadlines. Designing solutions based on customer and application requirements. Delivering metrics of weekly progress to ensure meeting the project plan for conversion team. Developing testing strategies and technologies to prove our conversion is acting correctly to the customers satisfaction. Responsible for design and access to our testing environments for ad hoc testing. Interviewed and hired new development staff. Updated weekly team progress to project plan and updated status report which was delivered to upper management on a weekly basis. Liaison between Testing team, Training team, IT Support group and the conversion team. Conducted requirements gathering effort.Facilitated Joint Application Design (JAD) and other design sessions.Coordinated activities with client and external agencies and interface partners.Oversight and administration of all project administration deliverables.Creation, Oversight and administration of detailed work plan and dashboards. Identified and documented Risks both internal and external to the project via risk management meetings and a risk tracking application. Helped set up our project schedule determining estimates and priorities, as well as assigning/leveling resources.Technologies utilizedMSProject, Office 2010, Sharepoint, Visio, SQL Server 2008, .NET 2.0/3.0

Cincinnati Area

Developed and re-engineered several processes and reports for a Reporting Delivery Group Supporting XPEDX in Cincinnati Ohio. To better support their client and to develop a robust and high-quality delivery system, I completed a thorough review of their “as is” processes. I redesigned any that were flawed or inefficient, and created new ones where needed. I also created detailed designs documenting the processes with schedules and areas of responsibility, notification chains and error logging/reporting. This included developing a configuration management plan and implementing version control software, creating a “One stop” Onboarding document for new hires, creating a “Best Practices” guide for developing Crystal Reports, and developing process guides for creating/modifying reports. I also integrated a new test/QA environment to help resolve issues found by the client while reports are still under development. I led Process review sessions with team leadership and identified issues and resolutions providing executive level updates monthly. I implemented CMMI methodology for continual improvement plans still being used by the client today. I authored several business design documents as well as technical specification documents for end users and developers to use for better understanding of the reporting system and implementation of future reports as needed.

I am the Technical Team lead for 14 SQL BI developers. We are developing the proces and software which will be used to convert the state's legacy Child Support and Family Court data to our Newly developed application database. SSIS/SSRS 2005 and 2008, Access 2007, Project, Erwin, and others

Responsible for Meeting with Client and determining conversion rules and elements needed to be converted to new Court Case management System being developed to manage and track family court proceedings and Child Support Enforcement activities. Developed SSIS packages to transform and load the data per the requirements. Created process to verify the conversion steps gave the expected results. Provided gap analysis for the conversion portion of the project. Set up access mapping database with reports, forms, and tables linked to the main SQL server mapping database. Created Testing Scripts to extract data from legacy client application database tables. Established cost cutting processes which leveraged commonalities in our diverse set of requirements.Technologies utilizedT-SQL, Visual Studio 2005, SQL Server 2008, SSIS, Erwin Data modeler, Access 2007JavaScript, VB.NET, MindJet Mapping tool

Worked as part of the data acquisition team to collect data from various public information channels to load in to national Background Check database. Primarily designed, developed and tested a process where business names were loaded into our database so that they could be searched/indexed for lookup. This had always been a “people” database and this was a new service that GIS was able to leverage and market to other clients.Technologies utilizedT-SQL, Visual Studio 2005, SQL Server 2008

Managed Quarterly Data Collections for the State Department of Education. Currently in charge of the data collected from the individual school districts across South Carolina. Extracted data is delivered to other state agencies, universities, and government entities throughout the year. Designed/Developed applications in VB, using SQL 2005, and access.Used Actuate to report on student and other educational data. Developed stored procedures to mine this data.

Helped Design and implement a Customer Relationship Data Warehousing effort. Created web services to interface with an address verification process.(.NET) Used Crystal Reports to report on Loan and Banking information for the respective departments. Developed complex stored procedures to mine this data.Consulted on a project to implement a new Information technology management application. Was the main developer to implement new reports and data mining processes for the app Information Technology Governance.Technologies utilized

Helped Develop CIF System and led Informatica Requirements analysis and implementation effort. SQL 2000, Crystal Reports, and Informatica, as well as others.

Bba, Management Information Systems, General

Systems Undergraduate degree courses included C, Database Design, Database theory, Marketing, Management, Cobol, Foxpro, Logic.

Bba, Information Systems / Operations Management

Activities and Societies: Sigma Phi Epsilon, Sigma Cum Laude, IFC Council Vice President, Intramural Sports Advisory Council