Post Job Free

Resume

Sign in

Sql Server Project

Location:
Cleveland, OH
Posted:
November 06, 2012

Contact this candidate

Resume:

DEBABRATA GHOSH

Email: abo9si@r.postjobfree.com

Address:

City: MAYFIELD HEIGHTS

State: OH

Zip: 44124

Country: USA

Phone: 301-***-****

Skill Level: Any

Salary Range:

Primary Skills/Experience:

IT Applications Programmer with more than five years of Insurance industry experience. Professional expertise includes applications software design and development, mainframe and project management.

Educational Background:

High School Dipolma from University Of Maryland, College Park MD 1/2001 to 5/2010 (Information Management)

High School Dipolma from Haldia Institute Of Technology, College Park MD 1/2001 to 11/2012

Job History / Details:

Career Overview

IT Applications Programmer with more than five years of Insurance industry experience. Professional expertise includes applications software design and development, mainframe and project management.

Qualifications

Masters in Information Management

Sun Certified Java Programmer (SCJP)

Microsoft Certified Professional (MCP)

Knowledge of Software Development Lifecycle (SDLC)

Proficient in Product Based Planning

Strong project management skills

Excellent communication skills

Excellent Team building/leadership skills

Experience in agile software development

Programming and design skills

Experience in Web technologies

Experience in Mainframe Systems

Extensive experience with thin client architecture

Knowledge of SQL Server Integration Services

Knowledge of PHP, Perl, Javascript, CSS3, HTML5

Extensive experience with thin client architecture

Education

2010 University Of Maryland College Park, Maryland

Master of Science Information Management

2005 Haldia Institute Of Technology Haldia, West Bengal

Bachelor of Technology Information Technology

Technical Skills

Skills Experience Total Years Last Used

Domain Knowledge: Insurance 5 2012

Languages: C#, Java, C, UML 1 2012

Scripting Languages: JavaScript, JSON, Perl, PHP 2 2012

Web Technologies: HTML5, CSS3, XML, XPath, XSLT 1 2012

Databases: MS SQL Server 2005/2008, PL/SQL 2 2012

Progressive Tools : TCA Navigator, XR, XM, NUnit 1 2012

Data Warehousing: SSIS 1 2011

Version Control Tools: TFS, VSS 5 2012

Business Process Modeling Tool : Modelio, ArgoUML 6 months 2009

Other Tools: Visual Studio, Visio, MS Project 2 2012

Mainframe: COBOL, BATCH, CICS, DB2, IMS DB 3 2008

Mainframe Tools: QMF, SEEC 3 2008

Certifications

Microsoft Certified Professional ( MCP )

Sun Certified Java Programmer ( SCJP )

Work Experience

November 2011 to Current

Progressive Casualty Insurance Cleveland, Ohio

IT Applications Programmer

PolicyPro - Currently working as a UI developer in PolicyPro, one of the biggest projects in the history of Insurance industry.

Worked in thin client web framework for enterprise applications in PolicyPro.

Used knowledge of UI frameworks and Web technologies to develop projects resulting in functional enhancements of Web-based applications.

Worked with business to analyze business needs and the requirement for a functional enhancement.

Responsible for design specifications and development of key components and features for the functional requirements.

Responsible for developing key functional enhancements for PolicyPro using technologies like C#, JavaScript, JSON for projects like "VOI & ID Flow", "LP Address Vehicle Flow", "Vehicle Eligibility Question" etc.

Designed and implemented all phases of functional enhancement including requirements gathering, design, development, testing, and deployment.

Used a wide variety of techniques and tools in the development and unit testing of software applications, including: object oriented programming languages, software tools (TCA Navigator, XR, XM, NUnit), analysis and design techniques, data base management systems.

Performed effort estimation for design, development and testing of functional requirements.

Developed and managed project plans while providing status updates to management.

August 2010 to October 2011

Progressive Casualty Insurance Cleveland, Ohio

IT Applications Programmer

SQL Server Migration (Wave 4) - This project was an IT Gov project for Progressive, an endeavor to keep up with the latest technology. It involved the migration of its applications from SQL Server 2005 to SQL Server 2008.

Worked with the Service Management team to change the Database names, DSN and port numbers using in-house tool "Connection Manager".

Worked in an architectural design effort to migrate existing MS SQL Server 2005 dependent applications to enterprise-class BI platform.

Migrated data using a data warehousing tool - SSIS, which is used for data extraction, transformation and loading.

Tested the migrated jobs in various environments - INTEGRATION, QA and QR.

Provided continued maintenance and development of bug fixes and patch sets for existing SSIS jobs.

Assisted in the monitoring and improved performance for critical SSIS jobs.

June 2009 to August 2009

Progressive Casualty Insurance Cleveland, Ohio

IT Summer Intern

Interned for three months in one of Progressive's financial reporting systems.

Responsible for re-engineering of a complex financial reporting system in mainframe.

Reverse engineered eighty-two BATCH cycle jobs.

Developed work-flow charts and diagrams using VISIO to support business needs and understanding.

August 2005 to June 2008

Larsen & Toubro Infotech Ltd. Pune, Maharashtra, India

Software Analyst & Developer

Client: Travelers, Hartford, CT

Designed, documented and developed recommendations for technology/process solutions to meet business requirements for the client.

Worked in many Reverse Engineering projects reverse engineered many of applications like AFO Roster, Premium Pipeline comprising of 14 other applications.

Developed the applications AFO Roster, Premium Pipeline with the data obtained in reverse engineering.

Collaborated on projects involving database migration from IMS to DB2 understanding the various segments in IMS and mapping it with the DB2 database.

Worked in platform migration of projects from Mainframe to .Net incorporating data analysis, mapping and tracking the flow of data from the point that the transaction gets triggered to its process and storage in the database and ultimately the response back to the front-end.

Served as team lead from offshore and took care of business requirements of projects.

Managed projects that involved defect prevention, project metrics, and PeopleSoft.

Accomplishments

Software Development:

Developed new applications to enhance the user interface.

Requirements Analysis:

Reverse engineered the back-end of a complex financial system and other systems like AFO Roster.

Application Design

Used thin client architecture with object oriented design/programming to design application for PolicyPro.

Performance Management

Successfully deployed complex end-to-end business intelligence solutions that delivered business value to the organization.

Facilitated effective working relationships between client and project teams throughout project lifecycle.



Contact this candidate