Candidate Information Name Available: Register for Free Title Sql Server Programmer Analyst Target Location US-OH-Cleveland Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Data Quality Sql Server Parma Heights, OH Sr SQL Server DBA l Architect Lyndhurst, OH Sql Server Database Administrator Cleveland, OH Software Engineer Sql Server Cleveland, OH Information Technology Sql Server Cleveland, OH Lead/Senior Programmer Analyst Westlake, OH Information Technology Customer Service Cleveland, OH

Candidate's Name
Street Address
H PHONE NUMBER AVAILABLE, C PHONE NUMBER AVAILABLE E-Mail: EMAIL AVAILABLEPROFESSIONAL PROFILESYSTEMS ANALYST with expertise in SQL Server application design, development and implementation. U.S. Citizen experienced in both Fortune 500 and small entrepreneurial businesses in banking, insurance, healthcare and social expressions industries. Good understanding of the IT and Finance interface. Knowledgeable in SQL server store procedures, SSIS, SSMS, DTS, query analyzer, enterprise manager, indexing, triggers, constraints and complex queries. Adept at translating complex business needs into integrated system design that improves functionality and reduces cost.SOFTWARE: SQL server, SSMS, SSIS, DTS, AbInitio ETL tool, COBOL-II, IDMS Batch / ADS/O, OLQ, Culprit, IBM Utilities, JCL, File-aid, Easytrieve, Endevor, ROSCOE, TSO/ISPF, CA-7, SCLM, TWS.WORK EXPERIENCESedgwick CMS, Seven Hills, OH 5/2009 to presentSQL Server Programmer Analyst: Currently working at Sedgwick CMS. I am designing and developing SQL server SSIS packages, stored procedures for various applications for Clients like Avis Car Rental, Amex MasterCard, Enterprise Rent A Car.Key Bank, Cleveland, OH 2006 to 2009Lead Programmer Analyst: SQL server Developer AnalystWorked for Lending system Department to design and develop data reporting project to extract data from complex vendor application using SQL server Store Procedures, DTS, SSIS, T-SQL and AbInitio ETL toolDisguised data to protect confidential information as part of company effort to comply with Sarbanes Oxley regulations using AbInitio.Cambridge Integrated Services, Solon, OH (former BTG division of Progressive Insurance) 1999 to 2006SQL Server Programmer Analyst: SQL server Programmer Analyst.Was responsible in designing and developing DTS and SSIS module to load MasterCard and Enterprise rent a car Claims data to SQL server Claims database.Was responsible to support claim services system on SQL server Database. Duties involved were Writing new Store Procedure (T-SQL) and DTS for Voyager applications and Financial Interface with Lawson.Designed and developed Claim Search System for clients to interface company claims with ISO central repository. Process saved client companies thousands of Dollars in fraudulent claims. Designed and Developed batch billing system for claims that are sent to ISO using SQL server store procedures and DTS.Created reports using SSIS & DTS to verify all system data was entered ensuring accurate and on time billing.Was responsible for maintaining Corvel Billing system (for PIP features),Enterprise Rental car location and sub location data load to voyager system using DTS.Involved in MasterCard, Chrysler, Thrifty and Rise customers claims data conversion to SQL server database using DTS (ETL), SQL server scripts and SQL server store procedures (T-SQL). The claims data source that were loaded were in different formats like access database, Excel spread sheet files, tab delimited flat files, and special characters delimited files.Designed and developed OFAC compliance system to prevent payments from being issued to suspicious parties.Send and receive files to customer using various FTP software (Win SCP, File Drive, WS-FTP PRO).Entire SDLC experience from Requirements Definition through Post-Implementation Support.As a SQL server developer I have a knowledge and experience with SQL server indexing, triggers, constraints, query analyzer, enterprise manager, DTS, store procedure and complex queries ( Insert,delete, update, table joins, views, sub queries, dead locks, commit and rollback)Converted IDMS mainframe claims data to Microsoft SQL server database to support new client server application.Computer Horizon Corp., Independence, OH 1997 to 1999Programmer Analyst: IT Consultant for manufacturing and healthcare.Worked on Moen Inc.s Y2K millennium conversion project team that changed IDMS, COBOL, ADS/O and Culprit programs for Y2K. Performed parallel testing for compatibility ensuring there were no discrepancies between unit tests and production environment.Developed Cleveland Clinic system to interface between IDMS ADSO dialogs and Phamis LastWord System on Tandem VIA IDMS-DC, IDMS subroutines, Queue records and Scratch records.American Greetings Corp., Brooklyn Hts., OH 1989 to 1997Mainframe Programmer AnalystSupported Order-Processing System, Accounts Receivable, Shipping Control System and Customer Database System for Everyday Redesign Department (EDR) on IBM Mainframe using COBOL-II, IDMS and IDMS ADS/O.EDUCATIONB.S. in Computer and Information Science, Cleveland State University, Cleveland, OHB.S. in Accounting, Baroda University, India.