Tim Kellard Email & Phone Number

Using sql server and crystal reports design custom reports for Partners member hospitals

Working on software upgrades to State of Ma Medicaid claims system

Create complex stored procedures using MS SQL 2000 to be used in software application development. Part of a team of DBA's responsible for the maintenance, upkeep and backup of Production, QA and Disaster Recovery SQL Server DatabasesCreate complex DTS packages using MS SQL 2000 and vbscript to automate daily import and export tasks for Fund Accounting and Fund Administration.Support and debug VB applications from design through implementation.Create complex SQL Server Stored procedures used to develop custom Crystal Reports for Fund Accounting and Fund AdministrationAnalyze/Research current workflows and macro driven excel spreadsheets in order to automate processes utilizing MS SQL (2000 and 7.0) and VB.Review BSA documentation for accuracy and feasibility.Develop and support Fundstation Reports for Fund Accounting and Fund Administration.

Wrote detailed business and systems requirements/specifications to enhance and support the SunGard/INVEST ONE Fund Accounting systems conversion as well as the in-house compliance tracking system (ChaseTrac).Acted as the lead BSA for the SunGard/INVEST ONE Fund Accounting conversion.Provided systems application support to Fund Accounting and Fund Administration groups.Provided business knowledge to programming team during systems/report design phase.Acted as a technical resource to the SQA team during the UAT and QA phases.Under the direction of a Systems Lead, participated in code unit testing and code movements.Presented new technology applications to Senior Management for possible implementation withinuser groups.

Acted as the Security Administrator for Chase Insight SystemProvided systems application support to Transfer AgencyProvided business knowledge to programming team during systems/report design phase of a Transfer Agency in house reconciliation VB Application.Developed complex SQL stored procdures for Transfer Agency in house Reconciliation VB application.Under the direction of a Systems Lead, participated in code unit testing and code movements.Provided Ad-hoc reporting for business users of VB Application using SQL

Responsible for the design, creation and testing of an Access Database to increase efficiency in both the reconciliation of Demand Deposit Accounts and the reconciliation of cash positions with fund accountingResponsible for the reconciliation of Demand Deposit accounts.Repsonsible for reconciling cash positions with fund accountingResponsible for the verification of work completed by team of Control Analysts

Responsible for the reconciliation of Demand Deposit accounts.Repsonsible for reconciling cash positions with fund accountingResponsible for the creation of Lotus 123 spreadsheets to facilitate the automation of reconciling cash positions with Fund Accounting

Ba, Economics

Bachelor Of Arts, Economics