Sql Server Insurance
Resume:
Laura Sagalchik
Buffalo Grove, IL 60089
**************@*****.***
SUMMARY
Sr. SQL Developer with broad-based skills in all aspects of the software development life cycle. Areas of expertise include:
• over ten years of experience with SQL Server to support OLTP databases and business applications
• three years of experience with SSIS,SSRS, C#
• experience in optimizing complex queries and stored procedures
• expertise with insurance software applications
• experience with manufacturing data warehouse and OLAP cubes
• completed three LOMA courses
• self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills
Software: Microsoft SQL Server 2000/2005/2008/2008R2/2012, SSIS, SSRS, SSAS, Microsoft Visual Studio 2005/2008/2010, Visual
Source Save, DB2, Oracle, UNIX
Languages: T-SQL, C#, XML, XQuery, VB 6.0, JAVA, HTML
EXPERIENCE
InfoPlanIT Schaumburg, IL
SR. SQL Developer/Consultant September 2013 - Present
• Developed complex stored procedures using XQuery and dynamic SQL for ERP database
• Created ETL SQL Server 2008 R2 processes and SQL Jobs for manufacturing data warehouse
• Created and implemented OLAP cube for OMAR GL data using Visual Analyzer
• Analyzed General Ledger database and gave recommendations for improvements
• Created OLAP cube for shortage of materials using SSAS
Guarantee Trust Life Insurance Company Glenview, IL
Project Leader/ Sr. SQL Developer
January 2002 – August 2013
• Designed, developed, tested, debugged and documented highly complex SSIS packages and made significant enhancements to
existing packages
• Coded and implemented interfaces and reports for the claims system using SSIS, SSRS and C#
• Rewrote DTS packages to SSIS to upgrade from SQLServer 2005 to SQL Server 2008
• Used the SQL Profiler tool to debug, troubleshoot, and monitor application's SQL statements and stored procedures
• Modified and developed new VB 6.0 applications for Batch Scheduler, Time reporting and Commission systems
• Created SQL Server DTS packages and complex stored procedures and views for LifePRO data repository
• Optimized SQL queries and index tuning to improve performance
• Lead large scale LifePRO version upgrade projects
• Provided advice and recommending solutions to highly complex technical problems
• Provided technical leadership and supervision for the team members
• Developed Access applications for the Accounting system
ACE Systems, Inc.
Independent Senior Consultant December 1996 - November 2001
Clients:
TriZetto Group, Inc Naperville, IL
• Developed online application for ClinicaLogical Healthcare Benefits Administration System using Micro Focus
COBOL in UNIX environment
Anixter, Inc. Skokie, IL
• Developed and maintained custom Inventory System using COBOL, CICS, DB2 and IMS
• Developed MQSeries/CICS bridge programs to receive incoming client/server transactions and update DB2 and IMS tables
• Wrote stored procedures using DB2
Zurich Insurance Schaumburg, IL
• Developed Conversion online and batch programs for ACCESS Claim Processing system from DataCom 9.1 to DB2
5.0 using CICS, DB2, COBOL, and JCL. This project included:
o Analyzed existing DataCom calls and conversion into DB2 SQL statements
o Tested Managed Care online programs by initiating CICS transactions from Metadata system based on UNIX environment
utilizing Reflection software
Aurora Solutions, Inc Schaumburg, IL
• Designed, developed, and tested Personal Calendar for IT Professional web application Portal using Java Servlets,
SQL, HTML, Java Script, Access, Visual Café, and Dreamweaver.
Kemper Insurance Long Grove, IL
• Analyzed existing COBOL/IMS and Micro Focus COBOL/DB/2 programs for creating technical specifications of the
current process
• Wrote specifications for Oracle reporting processes to extract data from PYRAMID claim system based on Client-
Server Oracle database
• Created and ran DB/2 queries on UNIX environment
• Supported EDI applications using the IBM DataInterchange translator and DI JCL Utilities
• Analyzed current EDI applications, producing recommendations for improving security and system efficiency
• Implemented DB2 utility jobs
• Upgraded DataInterchange software version
• Installed DI Client and GUI interface to the MVS Data Interchange translator
Trustmark Insurance Lake Forest, IL
• Translated business requirements into programming specifications, coding and testing online and batch programs for
the Insurance Billing system using COBOL II, DB2, CICS, EASYTRIEVE PLUS
• Supported DB2 Database by creating, altering and reloading tables, creating indexes, recovering table spaces and
indexes
• Monitored, analyzed and independently resolved production system problems
Allstate Insurance Northbrook, IL
• Worked as a member of the NOVA/MI team on new development, maintenance and support of the Interface system
between AS400 Sales and Service Processing and mainframe Customer Database, Risk Management and Billing systems
utilizing COBOLII, DB2, PL/1, IMS and CICS
Washington National Insurance Lincolnshire, IL
Programmer/Analyst April 1995 - December 1996
• Coded new programs and enhancements for the Insurance Claim System using Micro Focus COBOL and C in DOS environment
• Analyzed current process of the Production Tracking System
• Performed object oriented design and coding using Object Pal for Paradox for Windows
• Investigated various alternatives and recommended appropriate system enhancements/modifications
Industrial Commission Chicago, IL
Programmer/Analyst Supervisor May 1991 - March 1995
• Handled day-to-day DB2 database activities using SQL language, QMF, SPUFI and File Aid for DB2
• Design, coded, and implemented online and batch programs for the Accident Reporting System
EDUCATION
E-Commerce JAVA Development, RCES Training Center, 2000
LOMA I, LOMA II and LOMA VI, 1995-1996
Systems Analysis and Design, CASE tool, Harper College, 1994
B.S. Computer Science, Belarusian State University of Informatics and Radioelectronics, Minsk, USSR
Contact this candidate