.Net Business Sql Server Data Development Experience

[pic] [pic]

Email:

*******@*****.***

Abin Mathew

Phone: 904-***-****

EDUCATION AND CERTIFICATIONS

. Masters in Computer Science from Bharathiar University, India

. Microsoft Certified in .NET Framework - Application Development

Foundation (MCPD).

. Microsoft Certified in .NET Framework - Web-based Client Development

(MCTS).

. Microsoft Certified in Designing and Developing Web-based Applications

by Using the Microsoft .NET Framework.

. Microsoft Certified Professional ID: 6543223

EXPERIENCE SUMMARY

. Senior Programmer Analyst with over 8 years of IT experience in Object

Oriented Analysis, Design, Development and Implementation of Web Based

and Standalone Client Server Applications.

. Experience working on n-tier web applications using latest Microsoft

technologies such as C#, ASP.NET, Visual, VB.NET, ADO .NET, AJAX,

jQuery, XML, XAML, XSLT, XPATH, SAX, XSD, WCF, WWF, WPF, SOA, Web

services, NET Remoting, ASP, COM, LINQ to SQL, DCOM, SharePoint 2007,

Dundas, DevExpress, Winform, ASP.Net MVC Architecture and ADO.NET

Entity Framework.

. Experience in working with .NET 1.1, .NET 2.0, .NET 3.5 and .NET 4.0.

. Experience in developing application layer using LINQ to SQL and

Entity Framework.

. Strong database knowledge and experience in RDBMS like Microsoft SQL

Server 2000/2005/2008, DB2, Oracle and associated SQL Programming

Knowledge in creating and maintaining SQL Databases, T-SQL, DB Tables,

Packages, Stored Procedures, Views, functions, Triggers and PL/SQL.

. Experience in developing Web, Smart Client, and WinForm applications.

. Strong Crystal reports and Dundas experience in developing web/client

server reports and charts and integrating into ASP.Net.

. Excellent Interpersonal, Analytical and problem solving skills.

. Experience in Designing, and developing OLAP Cubes using SSIS.

. Experience in creating and using COM components using VC++ and C++.

. Having good experience in developing SOA applications using Web

Services and WCF.

. Worked extensively with scripting technologies like VBScript and

JavaScript.

. Knowledge in developing web applications using ASP.NET MVC

Architecture (MVC 1.0 and MVC 2).

. Participated in developing .Net Silverlight application with MVVM

Architecture.

. Ability to work as a technical leader by providing guidance, support

in the design, development, and deployment of complex applications in

distributed computing environments.

SELECTED ACCOMPLISHMENTS

. Wrote detailed business specifications document based on results of

JAD sessions.

. Generated Business Intelligence report for Federal which generates

federal fund to the state.

. Closely worked with Interfaces and conversion teams to push and pull

the data from 13 Legacy systems.

. Architectural design using MVC, LINQ to SQL, ADO.NET Entity Framework

and Microsoft Enterprise Library Data Access Application Block.

. Worked on Reporting services using SQL server (SSRS).

TECHNICAL SKILLS

.Net Skills .Net Framework 1.0/1.1/2.0/3.5/ 4.0, C#, VB.Net, VC++,

ASP.Net, ADO.Net, Generics, Web Services, MFC, Lambda

Expression, Multi Threading, Silverlight, ORM, LINQ to

SQL, Entity Framework, Microsoft Enterprise Library Data

Access Application Block, DotNetNuke, XSD, XSLT, WCF,

WPF, WWF, Windows Services, MVP and MVC architecture.

Programming C#, VB.net, VC++, C++, C, Visual Basic 6.0(VB 6), SQL,

Languages PL/SQL.

Web Asp.net, JavaScript, jQuery, HTML, DHTML, CSS,

Development DevExpress, Dundas, WSDL, XML, XAML, AJAX, AJAX toolkit.

Tools

Operating Windows 2000/NT/XP/Vista, Windows7, Windows Server 2008.

Systems

Development Visual Studio 2010/2008/2005, Visual Studio Team

Tools Foundation Server (TFS), Microsoft Visio, PhotoShop 9.0,

Crystal Reports.

Database SQL Server 2008/2005, Oracle 8i/9i/10g, MS Access 97/00,

DB2.

Reporting & Crystal Reports 11, Dundas, SSRS, Visual Source safe

Other Tools (VSS), Skelta.

Web Servers Internet Information Server (IIS)

Testing NUnit, Visual Studio Test System (VSTS)

Tools

PROFESSIONAL EXPERIENCE

State of Florida- Department of Health (DOH), Tallahassee, FL

Nov'2009 To Till date

Florida Community Health Assessment Resource Tool Set (CHARTS)

Senior Programmer Analyst and Web application Developer

Florida Community Health Assessment Resource Tool Set (CHARTS) combines

elements of the previous county map with great new features and uses the

latest technology to provide new ways of visualizing health data. CHARTS

helps to find Florida health statistics that will help identify health

problems in various communities

The State Epidemiology Workgroup (SEW), which meets face-to-face on a semi-

annual basis, is composed of members with expertise in epidemiologic data

and/or drug policy drawn from a wide variety of state agencies,

universities, and community-based organizations. In this module data is

presented that prevention providers, coalitions, and other stakeholders can

use to design, and monitor their programs.

Evidence-based Health Intervention Strategies is an interactive, evidence-

based public health intervention planning tool. It describes effective

intervention practices to improve community health and provides

information, tools and resources for intervention design, implementation

and evaluation.

Florida Birth Query System provides access to such data as low birth weight

infants, prenatal care status and pre-term births. Additionally, this

system allows users to filter this data by variables such as race, age,

marital status and ethnicity of the mother.

Responsibilities:

. Responsible for communicating with business users to get business

requirements and prepare detailed functional specification document.

. Architectural design and implemented high volume, high traffic

transactional application using conventional design practices (test

driven development, SOA, design by contract, MVC).

. Developed highly interactive AJAX based ASP.NET MVC application with

SQL Server.

. Involved in designing Online Analytical Processing (OLAP) cubes to

create highly

. Architected and developed new web based application using MVC

architecture, LINQ to SQL, C#, ASP.Net 3.5, Lambda Expressions, AJAX,

jQuery, JavaScript, DevExpress controls, Dundas, SQL Server 2008,

SSIS.

. Developed customizable reports, gauges, maps and charts using Pivotal

CRM, Dundas and Crystal Reports.

. Designed database structure to accommodate business requirements.

. Developed custom Membership and Role providers to access legacy

database.

. Created WCF Services to communicate with SOA and interact with

different Services modules.

. Participated in converting existing modules to advanced reporting using

Dundas reporting controls with OLAP Cubes.

. Perform Unit testing, System Integrating testing and deploy the

application modules to the QA environment for user acceptance.

. Used XML to save and load pre-defined Olap reports to the Dundas

asp.net controls.

. Designed and developed custom .NET components and user controls using

ASP.NET and C#.

. Successfully worked with the clients Quality Assurance team to get the

Document Management application tested and ready for production under

a tight deadline.

. Used TFS for code versioning.

. Created technical documentation covering the changes and improvements

to the Document Management application.

Technologies: Visual Studio 2008, ASP.NET 3.5, C#, WCF, WPF, Linq to SQL,

Entity Framework, MVC Architecture, ADO.NET, Dundas, DevExpress, Crystal

Reports, Pivotal eRelationship Lifecycle Server (PBS), AJAX, HTML, XML,

XSD, Java Script, JQuery, CSS, TFS, SQL Server 2008, SSIS, OLAP Cubes,

Visual Source Safe (VSS).

State Of Alabama-Department of Human Resources (DHR), Montgomery, AL

(Deloitte Consulting) SACWIS - FACTS

Senior Programmer Analyst June'2007

To Nov'2009

Description: FACTS (Family Adult and Child Tracking System) was developed

to improve the quality of services to children. FACTS are Alabama's

Statewide Automated Child Welfare Information System (SACWIS). The Foster

Care and Adoption components were developed first to meet Federal

requirements and to provide management support for Family and Children's

Services county staff and SDHR staff. Alabama social workers used to manage

their work through a number of stand-alone, or "legacy systems" that were

merged into one computer system. It Consolidate 13 legacy systems into one

uniform system, Standardize practice statewide Convert legacy data from 9

major systems. This application was designed to gather data consisting of

Intake for adults and children, Assessments that contain Preventions and

Child Abuse and Neglect (CAN) cases, Interstate Compact for the Placement

of Children (ICPC), creating Comprehensive Family Assessment(CFA), creating

Safety plans, Case plans, Services, Placements, and Intake & Investigations

for adult services

Responsibilities:

. Worked closely with application, Interfaces and conversion team to

fulfill business requirements.

. Involved in developing application modules Intake, Investigation,

Case management, Provider, Finance and Admin using C# and asp.net.

. Developed framework for development process In Object Oriented

Development (OOD).

. Worked on Crystal reports to generate reports on PDF and DOC through

application.

. Developed stored procedures, functions, Triggers, Views, Packages and

invoked them through data objects.

. Involved in performance tuning for database stored procedures,

functions and views.

. Extensively worked on developing core .Net components (data container,

User interface, Business work flow, Business Component and data access

layer) in n-tier architecture.

. Established database connectivity and data retrieval using ADO.Net

objects in an enterprise environment.

. Involved in Data Migration from DB2 to SQL Server 2005.

. Used Infragistic controls with asp.net controls to develop web

screens.

. Developed user controls and custom controls using asp.net and

Infragistics controls.

. Used Netrics tool for search engine and used Skelta for Workflow

maintenance.

. Involved in loading and unloading data from production database tables

to test Database according to the Client requirements.

. Developed web methods using Web services to communicate with external

systems.

. Implemented Service Oriented Architecture (SOA) for service modules.

. Used JavaScript for client side programming and validate user input.

. Responsible for code review and Unit testing using NUnit.

. Involved in Knowledge transition sessions to client staff of

programming techniques from end to end.

Technologies: ASP.NET 2.0, C#, SOA, ADO.NET, Web Services, AJAX, HTML,

XML, XAML, XSD, XSLT, Java Script, SOAP, MSHTML DOM, SSL, FTP, DTS, DB2,

SQL Server 2005, Visual Source Safe (VSS), CSS, Crystal Reports.

Fidelity National Financial, Jacksonville, Florida

March'2006 to June'2007

TRAX

Programmer Analyst

TRAX is an in house project of Fidelity for their title insurance business.

It mainly deals with operations and accounting of the title business. It

has a subsystem, which deals with the agencies of the title business called

Agent TRAX. This application has the capability to do all the operational

activities and accounting transactions for customers, titles forms, and

maintain all the transaction between the third parties called agents all

over US and Canada.

Responsibilities:

. Involved in the architectural design of the software.

. Involved in all stages of SDLC from requirements gathering to final

deliverable which includes designing, coding, unit testing,

integration testing and regression testing for improving application

performance.

. Involved in Configuring IIS and deploying the solution on all

application server environments as per the client requests.

. Developed stored procedures, functions, Triggers, Views, Packages and

invoked them through data Objects.

. Developed web modules using C#, telerick controls and asp.net

controls.

. Implemented Microsoft application blocks for Data access and executing

stored procedures.

. Implemented .Net Web Service for the above application in distributed

environment

. Designed the user Interface and logos using HTML, Photoshop, Flash and

Dream Weaver

. Developed data driven Web pages using C# and ADO.Net.

. Developed reusable custom controls different modules.

. Created public DLLs or libraries to implement business logic and to

integrate the application.

. Provided database connectivity using Microsoft OLE-DB Provider.

Utilized database components (Data Adapter and Data Set) to access

database using ADO.Net.

. Involved in Knowledge transition sessions to client staff of

programming techniques from end to end.

. Created Stored Procedures and triggers to perform automated rules,

updating to related tables.

Technologies: Visual Studio 2005, C#, ADO.Net, telerick, ASP.Net 2.0, Web

Services, Crystal Reports 11, JavaScript, CSS, AJAX, XML, Oracle 9i.

SkyeTec, Jacksonville, FL Aug'2004 to

March' 2006

Programmer Analyst

My Safe Florida Home (WindMit) is a Wind Certification Entity. The Database

and Data Dispatch System facilitates the assignment of inspection requests

and collection of inspection data for the My Safe Florida Home (MSFH)

program. - WCEs are responsible for performing the actual inspections and

submitting the inspection data back to the system. WCE gets database files

that DBDDS produces for WCE. The main modules covered in this web

applications: Data Import and Export, a Complete on-line inspection survey

checklist (Information regarding House Owned, General Building, Front,

Left, Right, Elevation, Roof Details, Inspection reports :-Assigned,

Cancelled, Completed, invoiced, Require Change etc,

Responsibilities:

. Requirement analysis and development of the entire web application.

. Convert the .html files to .asp.net files using the struts front-end

components for all the modules.

. Designed and developed project architecture and data structure.

. Involved in Database Design, Data Migration and Analyzing and organizing

technical data.

. Involved in High Level and Low Level Functional Documentation.

. Involved in the development of Reusable components by using VB.Net.

. Involved in .Net 2.0 Form based Authentication process for user level

of access.

. Developed User Controls and Custom Controls for the ASP.NET Screens.

. Developed ASP.NET screens with RAD Controls based on functional

requirements.

. Implemented AJAX 1.0 in ASP.NET Screens.

. Created Stored Procedures Functions and Triggers using Sql Server 2005.

. Used ADO.NET for data manipulation and interaction with Database.

. Created Web methods for capture data from another server using Web

Services.

. Involved in creating and manipulating XML data with ADO.NET.

. Involved in Client Side Validation using Java script.

. Involved in writing Test cases and Unit testing using NUnit.

. Used the Asp.net 2.0 Exception handling mechanism.

. Involved in development of Crystal Reports.

. Involved in Code Review and following .NET coding standards.

Technologies: ASP.NET 1.1, VB.Net, Web Services, ADO.NET, NUnit, Crystal

Reports, Sql Server 2000, XML, FTP, SOAP, AJAX, HTML, Java Script, RAD

Controls, SAS, Visual Source Safe (VSS), Visual Studio 2003.

Standard Chartered Bank - United Kingdom

July' 2003 To Jun' 2004

EBBS (Electronic Branch Banking System) and e-Downloads

Software Engineer

EBBS(Electronic Branch Banking System) is a banking project which is

developed for the Standard Chartered Bank in their off-shore development

centre in India in order to roll out the product for all the countries and

which is replacing the old system BBS. Also several surrounding systems

and third party products are integrated with this core product.

This is a full-fledged banking project developed to cater the needs of

Standard Chartered Bank, which having branches in many countries. All the

core-banking operations are handled through this project and the

surrounding systems are integrated. Also surrounding systems are

developing for adding value to the customer needs. E-Downloads is a

standalone module, which can be integrated with EBBS which is used for the

accounting purposes and which will download information from the other

surrounding systems. The file format can be text or XML. The download can

happen either through HTTP or FTP.

Responsibilities:

. Object Oriented Analysis & Design using Rational Rose (UML) and

creating Test Plans.

. Involved Design and creation of Actors, Use case Diagram, and

Realization of Use Case Diagrams (Interaction Diagrams, and

Collaboration Diagram) for the modules Relationship, Accounts, Deals

and Instructions.

. Development of Business tier for the modules Relationship, Accounts,

Deals and Instructions.

. Developed code for e-Downloads for handling multi threaded environment

using C#.

. Involved in creation of ASP.NET User Controls and Custom Controls.

. Involved in the Coding using C#.

. Validation of the presentation layer using Java script.

. Created data base objects SQL queries, Stored Procedures and User

Defined functions.

. Used Visual source safe for source code control.

. Created the Custom Exception for Exception Handling.

. Involved in writing System Integration Test Scripts.

. Involved in System Integration Testing.

. Implemented performance tuning methodologies.

Technologies: C#, ADO.Net 1.0, ASP.Net, XML, SQL Server Reporting

Services, SQL Server 2000, Windows 2000/XP

Honeywell Technologies Solution Lab, Bangalore, India

Mar' 2002 To Jun' 2003

LEO USPS (Mail Automation System)

Software Engineer

LEO USPS (Mail Automation System)is a mail automation system developed

offshore at Honeywell Technologies, Bangalore, India for handling mails for

the carrier Qantas according to the standards of United States Postal

Service. The system can handle all the type of mail tracking, sending and

receiving messages like CARDIT, RESDIT, MLD, INVOICE, and CLAIM according

to IATA standards, payments and reports generation.

Responsibilities:

. Gathered business knowledge from the users for the Messaging module.

. Created Requirement Specification and Analysis Document.

. Designed and developed system framework based on Business Delegate,

Service Locater etc.

. Developed business logic and Database logic for the messaging using

VC++.

. Developed framework for messaging using MFC, Win32 and SDK. This

module mainly deals with back end data processing.

. Using xml parsing and multi threading and events, data are updated to

the database.

. Generated XML files according to USPS and EDI Standards.

. Configured data sources using drivers for managing different databases

and enabling two phase commit.

. Created COM components using VC++.

. Designed the System to adapt to different environment (Development, QA

and Production).

. Involved in Unit Testing and System Integration Testing.

. Implemented performance tuning methodologies.

. Involved in Production Support and Bug fixing.

Technologies: VC++, Oracle, TCP/IP, Microsoft Visual Studio, Microsoft

Office, XML, PL/SQL, Clear Case, VSS.

Contact this candidate