Insurance Sql Server

BHAGYASHREE PATIL

Tel: 425-***-**** E-mail: ****************@*******.***

EpathUSA Inc., IO.

Experience:

Programmer Analyst

****-****

• Provided contracting services for website development and maintenance.

Deloitte & Touché LLP, NY

Senior Consultant, Enterprise Risk Services

2004-2008

• Managed client relationship in a variety of industries including insurance, manufacturing and

telecommunications for SAS No 99 testing, Consideration of Fraud in Financial Statement Audit.

Independently coordinated high level discussions of reports of US and international entities with

managers, senior managers and client contacts before filings.

• Supervised team of three consultants across engagements to file quarterly and year end SAS 99

reports for large size insurance and manufacturing clients covering US based and international

entities. Trained and delegated parts of assignments to client’s internal audit department.

• Performed financial statement reconciliation for verification of completeness and accuracy of

financial reports. Investigated significant journal entries and adjustments during the beginning and

end of quarters. Scrutinized items that appear to be unusual and may indicate error or material

misstatement.

•Designed procedures to examine unusual journal transactions, performed unpredictable audit procedures

by changing the nature and timing of audit from interim to year end. Performed surprise inventory

observations and test unusual accounts.

• Designed effective SQL query tool to audit the transition of securities and resulting

reconciliation of position data between former and new custodian bank for US Domestic securities,

Global securities, and Outstanding securities loans..

•Developed analytical routines to audit policy loans, death claims, and reserves for large size insurance

clients. Provided stratification results by planning materiality, statistically analyzed and sampled

data extracted from mainframe system using SAS and JCL.

•Developed routines to perform revenue recognition assurance for Technology, Media and

Telecommunication clients. Key responsibilities included coordinating with CFO and IT department

to perform reconciliation of third party billing statements to the financial statements.

•Audited and attested procedures related to design and operating effectiveness of computer controls of

commercial clients to meet Sarbanes-Oxley regulations. Inquired, observed, and inspected

companies IT manual control structure. Performed preliminary assessment of design of computer

controls and evaluated controls to detect and prevent frauds.

Graduate Teaching Assistant, State University of New York, Albany, NY.

2003 – 2004

•‘Computer Security’ and ‘System Programming’, teach and conduct lab sessions.

•Allocated to top 5% graduate students enrolled for M.S.

KPIT Info systems Ltd. Pune, India

2001-2002

Internship, Project team leader

•Six months internship in the business IT department under the Chief Technology Officer.

•Developed a generic tool to automatically reorganize and indent code written by programmers in

multiple languages. Identified customer needs to develop standards according to the company

requirements. Designed and tested various modules and developed User Interface in Visual Basic.

University at Albany.

Education:

State University of New York, Albany, NY.

Master of Science, Computer Science, May 2004. GPA: 3.74

Maharashtra Institute of Technology, Pune, India.

Bachelor of Engineering, Computer Engineering, July 2002.

•

Computer MS Office, SAS, C, C++, JCL, XML, PL/SQL, ASP.NET.

Skills: • IBM DB2, Oracle 8i, Microsoft SQL Server 2000/2005, ACL.

• Windows.

•

Professional Association of Certified Fraud Examiner.

Associations:

Contact this candidate