Project Management
Resume:
KATHLEEN M. REILLY
** ******* ****** **** (***) 257-
Rocky Hill, CT, 06067
******@***.***
Arnold-Hanafin (Reference # 6986)
East Hartford, CT
December 7, 2010
Dear Hiring Manager -
This letter is to express my interest in bringing my experience in MS
Access reporting, loading and editing of data to your company. I have
gathered data from various sources and created numerous reports identifying
inconsistencies and invalid information. I believe I can add to the
success of your company in the field of information management, analysis
and reporting.
As my enclosed resume indicates, my knowledge has been acquired through
insurance operations experience, progressing to the information technology
sector.
. Management and updating of Access databases
. Gathering and sending of data via multiple sources
. Development of complex reporting for senior management
In addition to the above skills, I can offer your company:
. 8+ years of Access database experience
. Excellent customer relationship skills
. Ability to manage multiple projects and assignments
I am available for an interview at a mutually convenient time to further
discuss my qualifications.
Thank you for your time and consideration.
Kathleen M. Reilly
KATHLEEN M. REILLY
15 Orchard Street Home (860) 257-
1284 / Cell 860-***-****
Rocky Hill, CT, 06067
******@***.***
Business Analyst/MS Access Programmer with 8+ years expertise in relational
database development, the gathering of system requirements and
documentation.
SUMMARY OF QUALIFICATIONS
. Development and maintenance of multiple production Access databases.
. Design, development and distribution of custom reporting and extracts for
internal customers and outside brokers.
. Proficient at system analysis and documentation.
. 3+ years of SDLC (System Development Life Cycle) to document system
requirements.
. 4+ years of expertise in file transfer protocol and encryption.
TECHNICAL SKILLS
. MS Office suite of products: Access (VBA), Excel, Word, Power Point &
Outlook
. Visio, Cuteftp, Cryptocx, SAS, SQL, adTempus, Task Scheduler, JCL
PROFESSIONAL EXPERIENCE
Lincoln Financial Group, Hartford, CT
Business Analyst, Technology Services
2000 - 2009
Managed daily, weekly and monthly production schedules. Provided extract
files, system interfaces and reports to internal customers and specialty
brokers. Implemented new products and system changes to our internal
databases and vendor managed administration system. Documented business
requirements and provided technical solutions for all work requiring more
than 8 hours to complete. Responded to changing priorities and ad-hoc
requests on a regular basis.
. Developed and installed a Premium Tracking database system processing
over $300 million in annual premium. System provided numerous forms,
functions and reports.
. Initiated and implemented an automated balancing routine providing daily
premium and disbursement results with notification to customer area via
daily automated emails.
. Developed Electronic Compensation Statement process with statements
distributed via multiple venues. Built interface file for bulk mailing
and secure email to brokers and customers. This process resulted in a
savings of more than 1 day per week for the operations area.
. Project lead on several initiatives providing support for Tier1 brokers
and communicating all required changes to existing interfaces. This
included the development of complex reporting which the vendor was unable
to provide.
. Worked closely with the operations team to streamline processes and
responded to ad-hoc requests from actuarial and marketing units.
Provided support for system/business audits both internal and external to
Lincoln.
Kathleen M. Reilly ******@***.*** 860-***-****
Page 2
____________________________________________________________________________
______________
Lead Systems Designer, New Business and Underwriting
1999 - 2000
Provided production support for numerous reinsurance, reserve and financial
systems migrated to Lincoln as a result of the sale of Aetna Life Insurance
Company to Lincoln Financial Group.
. Provided expertise and led project to disentangle Financial Systems from
Aetna.
. Assisted in completion of Y2K work for Life Financial Systems for both
Aetna and Lincoln systems. Responded promptly to night production support
calls without disruption to the business area.
. Cross trained on new reinsurance system including the updating of new
products and system enhancements.
Aetna, Hartford, CT
Business Systems Delivery Specialist, IT Life Systems
1994 - 1998
Provided production support for reinsurance, reserves and financial
reporting systems within Aetna. Responded to customer requests, identifying
opportunities to streamline support and reduce expenses. Led projects
associated with the conversion of the reinsurance systems from Asi-st to
SAS and Paradox to Access
. As part of the conversion project and Y2K efforts streamlined processes
which resulted in the elimination of approximately 75 jobs and even more
reports.
. Achieved productivity goals of greater than 80% billable.
. Played a major role in the sale of the Individual Life business to
Lincoln. Provided the sales team and senior management with data files
and numerous reports necessary to secure the sale. Completed specific
research functions in support of the Ernst & Young and KPMG audits.
Maintained production support while responding to the sale requirements.
Aetna, Hartford, CT
1972 - 1994
Financial Systems Sr. Analyst, Individual Life (3/1991 - 10/1994)
Financial Systems Sr. Analyst, Allied Business Group (12/1987 - 3/1991)
Superintendent MIS, Auto Homeowners (3/1984 - 12/1987)
Specialist Quality Control, Executive Benefits, Aecclaims - (9/1981 -
3/1984)
Utilization Actng Tech, Data Processing Center, Resource Mgmt, (6/1979 -
9/1981)
Accounts Payable Technician, Corporate Accounting, (3/1974 - 6/1979)
Accounts Receivable Technician, Life, AVAR - (10/1972 - 3/1974)
____________________________________________________________________________
_____________
Education
SAS Institute e-Learning + Certification - Refresher (In Progress)
. Programming 1: Essentials
. Programming 2: Fundamentals
Central Connecticut State University (1984 - 1986)
. Business Communication
. Introduction to MIS
. Accounting I & II
. Insurance Accounting and Reporting
Company sponsored classes
. Obtained Series 6 designation (mutual funds and investments)
. How to Document Business Requirements, Project Management, Self
Correcting Teams, Project Planning & Control,
. Fundamentals of SAS, Advanced SAS, Participated in numerous technical
training sessions
Contact this candidate