Sql Server Project

Location:

Indianapolis, IN

Posted:

June 06, 2016

Contact this candidate

Resume:

PRANA KRISHNA DAS *********@*****.***

SUMMARY

More than 12 years of professional experience in Software Design, Development, Architect, Implementation, Testing and Deployment of web based applications and windows applications. Have good exposure in various Microsoft Technologies: ASP.Net 4.5, C#, MVC 4, VB.Net, Win forms, ADO.Net, Entity Framework, WCF Services, Restful Services, Web Services, WPF, SQL Server 2012/2008, Oracle 8i, Crystal Reports, SSRS, SSIS, Linq. Other technologies GIT/Perforce/TFS/VSS/SCM/Tortoise SVN, Sybase 12.5, DB2, IIS 6.0, XSLT, XML, AJAX, JQuery, JSON, JavaScript and Dev Express.

Sound knowledge in designing, architect and developing Web applications, WCF services, Restful, web services, windows applications, console applications and windows services. Good working knowledge of writing unit test cases and test driven test cases Mocking frameworks.

Got good experience in all SDLC cycles, documents requirements of all the SDLC phases, designed and developed software applications/services with given requirements, budget, timeliness and quality

Good knowledge of implementing N-Tier and SOA (Service Oriented Architecture) architecture applications.

Expertise in writing T-SQL Queries, Stored Procedures, Views and Triggers in MS SQL Server 2012/2008 and Sybase 12.5.

Used Microsoft Unit Test, NUnit, Rhino mocks, Log4Net, and ReSharper to enhance the application productivity, testability.

Sound working knowledge of Windows 7/XP/2008/2003/NT/98 and good knowledge of IIS 6.0/5.5.

Very good working knowledge of Dev Express tool.

Good at analysis, coding, functional design (both high level and low level), technical design and testing.

Also involved in supporting, maintaining and troubleshooting activities for software applications and services.

Exclusively worked and used source controls SVN, Perforce, TFS, SCM and VSS.

Always represented proactively team across the board of meetings, technical discussions, conference calls when and where required.

Demonstration of the applications with end users once each phase of the application is completed.

SKILLS

Technologies: SP.NET 4.5/4.0/3.5, ASP.NET MVC 4.0, Web Services 2.0, WCF 4.5, 4.0/3.5 Services, REST, CSS 2.0 and Visual Studio .NET 2012/2010/2008/2005/2003, ASP3.0, MSMQ, Win Forms.

Languages: C#.NET 4.5/4.0/3.5, VB.NET, PL/SQL, XSLT, XML, AJAX, JQuery, JSON, JavaScript,

Databases: Sybase 12.5, SQL Server 2012/2008, Oracle 8i, SSIS

Technology for DB interactions ADO.Net, Entity Framework, LINQ, nHibernate

Reporting Tools SSRS, Crystal Reports

Tools ReSharper, Microsoft Test, NUnit, Log4Net, DevExpress

Methodologies: Agile, Scrum, Waterfall, Spiral

Source Control: GIT, Source Tree, SVN, Perforce, TFS, SCM and VSS

Operating Systems: Win 2008 R2/2003/2000/NT, Windows 8/7/XP

IIS: 7.0/6.0/5.5

Domain Knowledge: Mortgage, Content Management, Health Care, Advertising, Logistic

IT Industries worked: Services and products

PROFESSIONAL EXPERIENCE

Indiana State Department of Health (Indianapolis) Nov‘15 – Current

Role: Sr. Dot Net

Project: State Wide Investigating Monitoring and Surveillance System (SWIMSS)

SWIMSS is basically an application used by Indiana State of Health Department (ISDH).

This application keeps record of all Indiana State HIV-STD patients. There is another system DREX which provides data to SWIMS which comes electronically via a scheduled SQL job. Here data means the Patients profile, Disease details, Lab details, clinic visit, and interview taken by the health department with patients. Apart from Electronic

Data import, SWIMSS has the ability to create the data manually too.

Responsibilities:

Analyze and review business requirements and interact with Business System Analyst.

Work with Project Manager in estimating the Project delivery.

Design and Implementation of Classes, Interface, and Web Service Components using C#.NET, VB.Net.

Develop Data Access objects using Entity Framework.

Developing Web Application using ASP.NET Webforms, ASP.NET MVC, Jquery, Javascript, and SSRS.

Implementing Stored Procedures, User defined functions, Indexes, Triggers, Views for on SQL

Server 2012.

Involve in Code Review activity.

Implementation of Unit testing code using Microsoft Test.

Involve in testing the application in Development Phase.

Involve in Application build and documenting deployment Activities.

Have daily SCRUM meeting with the team for ongoing development.

Use TFS for code repository.

Use JIRA for issue and task logs.

Environment: ASP.Net 4.5, MVC 4.0, WCF Service, C#.Net 4.5, VS 2012, SQL Server 2012, Win 7, TFS, IIS 7.0/6.0, ADO.Net, JQuery.

Stonegate Mortgage (Indianapolis) Aug‘14 – Oct’ 15

Role: Lead Dot Net Developer

Project: Online Loan Information Exchange (OLIE)

OLIE (Online Loan Information Exchange): This is basically a public facing web site used by both internal Stonegate employees and external customers. Here external customers mean Third Party loan Originators (TPO) or brokers and Correspondent Financial Institutions (CFI) or small banks. In other way OLIE is divided into three sub applications Retail, CFI and TPO. A borrower can approach to Stonegate directly or TPOs or CFIs to get a loan. To get the loan process from open till close need to go via a certain workflow with various loan statuses. Here a loan status can start with Mortgage Adviser and closes with Closer.

Responsibilities:

Analyze and review business requirements and interact with Business System Analyst.

Work with Project Manager in estimating the Project delivery.

Design and Implementation of Classes, Interface, and Web Service Components using C#.NET.

Develop Data Access objects using ADO.Net & LINQ.

Developing Web Application using ASP.NET Webforms, ASP.NET MVC, Jquery, Javascript, Win forms technologies.

Implementing Stored Procedures, User defined functions, Indexes, Triggers, Views for on SQL

Server 2008 R2.

Involve in Code Review activity.

Implementation of Unit testing code using Microsoft Test.

Involve in testing the application in Development Phase.

Involve in Application build and documenting deployment Activities.

Work with Application support team on Deployment of Applications and tools to production.

Have daily meeting with off-shore team for ongoing development.

Use GIT and Source Tree for code repository.

Use Team City for code builds.

Use JIRA for issue and task logs.

Environment: ASP.Net 4.5, MVC 4.0, WCF Service, C#.Net 4.5, VS 2012, SQL Server 200 8R2, Win 7, GIT, Source Tree, TemCity, Octopus, IIS 7.0/6.0, ADO.Net, JQuery, Win forms.

Cognizant-Xerox (Client State of Navada) Mar‘14 – Aug’14

Role: Dot Net Architect/Sr. Dot Net Developer

Project: Health Insurance Exchange (HIX)

HIX is a web portal for shopping online health insurance. It is a part of Obama Health Care for the State of Navada. Individuals and employers can compare and shop health insurance using this web site. The buyers would be able to compare, select and buy a health insurance plan by paying online payment based on the individual’s eligibility to get the federal benefit.

Responsibilities:

Followed agile methodology for the project development.

Providing architect and design to developers when and where required using ASP.Net 4.5, MVC 4, C# 4.5, SQL Server 2012 and WCF Service, TFS.

Designed and Implemented interfaces and classes using Object Oriented Programming features

Used Unity Dependency Injection to reduce dependencies, more code reusable and testable.

All the Data Access activity done using Entity Framework.

Used MSMQ for some of the important application logs.

Used TFS for code repository and defect logging.

Responsible go give production support when some critical issues are there in production.

Extensively used generic code to increase performance of application and services over object type collections.

Optimized most of the code by using Linq, lambda expressions and other generic codes.

Is responsible to write Unit Test Cases using Microsoft Unit Test for all the newly created methods in the Service layer.

Made regular code review to ensure that all the Processes and Standards are being adhered i.e. ensuring correct implementation of requirements, coding standard, project architecture, efficient code writing techniques etc.

Environment: ASP.Net 4.5, MVC 4.0, WCF Service, C#.Net 4.5, VS 2012, MSMQ, SQL Server 2012, Win 7, TFS, IIS 7.0/6.0, Entity Framework.

Software Solutions, Cincinnati(Lebanon), Ohio Sep‘13 – Feb’ 14

Role: Sr. Dot Net Developer

Project: Visual Intelligence Portfolio (VIP)

Software Solutions is a 35 year old software development farm is well known for their web-based ERP suite (Accounting, Purchasing, Payroll and Utility billing) and Customer Information Systems solutions. Local governments, private and public utilities, libraries, county boards and metro parks and others have been using this product since long time.

Responsibilities:

Designed, architected and developed VIP dash board page using ASP.Net 4.5, VB.Net 4.5, WPF, C# 4.5, SQL Server 2008R2, Dev Express 13.2, and WCF Service.

Designed and Implemented interfaces and classes using Object Oriented Programming features

Used Dev Express entity framework to for data access.

Used MS Unit Test to write the Unit Test Cases in both the UI and Data Access layers.

Well Supported, maintained website and troubleshot issues

Extensively used generic code to increase performance of application and services over object type collections.

Optimized most of the code by using Linq and other generic codes.

Dash board is a new feature introduced in current version of VIP independently developed by me only.

Architecture and designed the entire dash board which contains 40 pages

The flow of the application is ASP.Net UI to Web Service which accesses the Data Access layer

Environment: ASP.Net 4.5, WCF Service, C#.Net 4.5, VB.Net 4.5, VS. Net 2012, SQL Server 2008 R2, Win 7, TFS (Source control), IIS 7.0/6.0, Dev Express 13.2

Sterling Info systems, Cleveland, Ohio May‘13 – Sep’ 13

Role: Sr. Dot Net Developer

Project: Web Service replacement

Sterling Info systems is well known for the back ground check company. In Sterling they do have two types of application user interfaces one is business to candidate and the other is business to business. For this verification sterling uses some third party data providers. This application has been developed few years back. Now Sterling wants to replace the existing data provider with a new data provider to achieve some new features.

Responsibilities:

Followed agile methodology for the project development.

Designed, architected and developed Web Service replacement using ASP.Net 4.5, MVC4, WCF Rest, C# 4.5.

Designed and Implemented interfaces and classes using Object Oriented Programming features

Used ADO. Net to design and create the data access layer.

Well Supported, maintained website and troubleshot production issues

Extensively used generic classes to increase performance of application and services over object type collections.

Was responsible to write all the unit test cases related to this project using MS Unit Test.

Applied dependency injection to handle multiple data providers.

Environment: ASP. Net 4.5, WCF 4.5, REST, C#.Net 4.5, ADO.Net, VS.Net 2012, SQL Server 2008 R2, Win 7, SVN (Source control), IIS 7.0/6.0.

Morgan Stanley, NYC, New York Dec ‘10 – Apr '13

Role: Lead ASP.NET Developer

Project: Generic Content Management Application (GenApp)

Morgan Stanley is known as one of the leading investment banks in the world and has one of the top financial advisor sales forces. Involved in developing web based application GenApp, using ASP.Net. This is a Content Management application and is a two step workflow. The creator creates the content and sends for approval (1st step) and then the approver approves the content (2nd step). Apart from this there is another important feature in this application called the 'Search'. The application uses two technologies 1. IDOL (search engine) 2. Restful WCF service to provide the searched data to the application.

Responsibilities:

Designed, architected and developed GenApp using ASP. Net, C# 3.5, 4.0 to create all the required user interfaces.

Integrated JQuery, Ajax logic into client user interfaces for smooth and enhanced UI experience.

To preview the submitted content in one go, ADOBE MQ Service has been integrated with the application, so that the submitted document can be converted into such a format which can be previewed on click of the content title.

Designed and Implemented interfaces and classes using Object Oriented Programming features

Used ADO. Net to design and create the data access layer.

Implemented customized exception logging framework and alerts using log4Net.

Used ASP.NET Session objects throughout the application to manage user’s state.

Well Supported, maintained website and troubleshot production issues

Extensively used generic classes to increase performance of application and services over object type collections.

Developed SOA Restful WCF services with centralized business logic and control flows.

Designed and developed User Controls and Master Pages using ASP.NET.

Modeled and built database using Sybase 12.5, written stored procedures and views at the back end.

Created separate admin pages for user management.

Used SSIS as ETL for transferring legacy Excel data to this Application.

Created some external applications using console C# application, and later these tools has been added into windows scheduled job, which can execute as per the scheduled time.

Performance testing to ensure that web application, windows application and supporting WCF services are pretty robust to handle more than expected load at peak hours.

Created health check pages, to check the applications health status for ASP. Net web server, Sybase database connection, WCF service URL access and connection to IDOL search engine.

Environment: ASP. Net 3.5, WCF 4.0, WPF, REST, C#.NET, ADO. Net, Sybase 12.5, VS. Net 2010/2008, Win 2008 R2, Win 7, SSIS, Perforce (Source control), IIS 7.0/6.0/5.0

Hitachi Consulting – Pune, India Apr‘10 – Dec’10

Role: ASP.NET Developer

Project: Jordan Lloyd Thomson (JLT)

It’s an employee benefit system, including various benefits, Life Insurance, Health Insurance, Overseas travel insurance, Student health insurance, Fire Insurance, Motor Vehicle Insurance, Aviation Insurance, General Insurance, Marine Insurance, Shop Keeper Policy, Transportation Policy, and Accident Insurance etc.

Responsibilities:

Followed agile methodology for the project development.

Developed JLT using ASP.net 3.5, MVC 2.0.

Created WCF Service to fetch data into and from SQL Server database.

To preview the data different reports have been developed by using SSRS-SQL Server 2008.

Created some of the SSRS reports by using WCF service.

Designed and Implemented interfaces and classes using Object Oriented Programming features

Used NHibernate technology for all data access activity.

Used log4Net for implementing customized exception logging and alerts.

Used ASP.NET Session objects to maintain users throughout the application execution.

Used caching utility for the frequently used objects to get better performance.

Well Supported, maintained website and troubleshot production issues.

Used generic classes to increase performance of application and services over object type collections.

Developed WCF services with centralized business logic and control flows.

Designed and developed various Views which can be reused when and where required in the entire application using ASP.NET MVC 2.0.

Built database using SQL Server 2008, written stored procedures and views at the back end.

Created separate admin pages for user management.

Done performance testing to ensure that web application, windows application and supporting WCF services are pretty robust to handle more than expected load at peak hours.

Created health check pages, to check the applications health status for ASP.Net web server, SQL Server database connection, WCF service URL access and connection to SSRS engine.

Configured a Cruise Control setup to watch the build when new changes have been made.

Environment: ASP.Net 3.5, WCF 3.5, C#.NET, NHibernate, SQL Server 2008, Oracle 8i, MS-Access 2007,SSRS, VS.Net 2008, Win 2008 R2, Windows XP, TFS(Source control), IIS6.0, Cruise Control.

NTTData (Vertexsoft), Pune, India Apr‘09 – Mar’10

Role: ASP.NET Developer

Project: Critical Chain Visualization (CCV)

CCV is a tool which helps to manage a project following Critical Chain Project Management methodology, which is now a mandatory criterion for achieving projects from Japanese government.

Responsibilities:

This project has exclusively developed by using MS Project Server (web) and Client (windows).

Created web pages in ASP.Net C# 2.0 integrated with MS Project Server.

Created windows forms, integrated with MS Project Client as add-ons.

Used C# 2.0 Windows forms and Web pages to create the required user interfaces.

Created WCF Service to fetch data into and from SQL Server database.

Reporting part of the application has been done by creating ASP.Net pages.

Designed and Implemented interfaces and classes using advanced Object Oriented Programming.

User management has done in Microsoft Project Server only.

Built database using SQL Server 2008, also created stored procedures, triggers, views when and where required.

Responsible for application administration and managing users, using Microsoft Project Server.

Configured a Cruise Control setup to watch the build when new changes have been made to avoid any new change failure.

Environment: ASP.Net 2.0, WCF 3.5, C#.NET, ADO.Net, SQL Server 2008, VS.Net 2005, Win 2008 R2, Windows XP, SVN(Source control), IIS6.0, Cruise Control.

Vertexsoft, Pune, India May‘07 – Mar’09

Role: Sr. ASP.NET Developer

Project: Placement Management (Microsoft Media Console)

The Microsoft Media Console gives user all the visibility and control to manage report on, and optimize the digital marketing campaigns. Media Console project is divided into small different modules like Media Codes, Rich Media, User Defined Fields, Placement Management which work together to form an efficient on-line Ad Campaign Management tool. Placement is like a container in a web page where the advertisers can put their Ads.

Responsibilities:

Followed agile methodology for the project development.

Used the Atlas developed MVC module to design the architecture.

Used ASP.Net 2.0, Telluric UI controls to design and develop UI pages.

Used NHibernate and ADO.NET as ORM Tools for storing and retrieving data to and from SQL Server 2005 database.

Implemented JavaScript to validate user inputs.

Written stored procedures and triggers for various database activities.

Worked on all layers i.e. Presentation, Business and Data layers.

Understood the business requirements, created Technical Design documents from Use cases documents comprised of sequence diagrams, class diagram, activity diagram etc.

Implemented technical design document and written rhino mocks tests to verify the functionalities of business, data access layer classes.

Supported production issues with given SLA and made sure that applications in production environment are always up and running.

Interacted with clients on queries, discussion, meetings etc.

Represented my team in terms of technical discussion, meetings, KT sessions, mentoring etc.

Used ASP.NET caching technique for better performance while accessing frequently used data

Configured a Cruise Control setup to watch the build when new changes have been made to avoid any new change failure.

Implemented TDD architecture by using NUnit and Rhino mocks for Unit testing.

Environments: ASP.Net 2.0, C#.Net 2.0, Nhibernate, ADO.Net, SQL Server 2005, Tortoise SVN, Windows XP/2003, IIS6.0

Aztec soft, Pune, India Jun‘06 – Apr’07

Role: Software Engineer

Project: ACT (Application Compatibility Test)

This an automation test script writing project, which helps to test different software’s in various operating systems (Windows Vista, Win2k3 English/German and Windows XP).

Responsibilities:

Used the VS 2005 C# windows forms, to design the architecture of this application.

Used VS 2005 C# to create a project template, which helped to create new projects in an ad-hoc way.

Used ADO.NET as ORM Tool for database activities when and where required.

Used Microsoft MOUI Library for writing the automation scripts.

Worked on all layers i.e. Presentation, Business and Data layers.

Understood the business requirements, created Technical Design documents from Use cases documents comprised of sequence diagrams, class diagram, activity diagram etc.

Worked on a separate logic to reuse the existing script whenever a new version of same software comes for compatibility.

Interacted proactively with business on queries, discussion, meetings etc.

Represented team in terms of technical discussion, new requirements, meetings, KT sessions, mentoring etc.

Wrote separate code libraries using C# 2.0, so that these libraries can reuse in future applications when and where required.

Environments: C#.Net 2.0 Windows forms, ADO.Net, SQL Server 2005, VSS, Windows XP/2003

PMAM IT Services - Mumbai, India Nov‘04 – May’06

Role: ASP.NET Developer

Project: Cargo wise Forwarder

This is a logistics management project, helps to create shipments, forwarding shipments, checking shipping status, tracking the shipment starting from booking till delivery.

Responsibilities:

Designed and developed VB 6, ASP.Net C# pages using .NET 2.0/1.1.

Shiptrax module has been developed using win forms.

Used Crystal Reports 8.0 for various reports.

ADO.NET has been used for all database activities.

Wrote Stored Procedures, views, user defined functions, triggers to achieve all database requirements.

Used ASP.NET caching technique to maintain the state information about users and to keep common data in memory to enhance performance of the application.

Gathered and understood the business requirements by interacting with BA.

Wrote technical documents for each and every task.

Reviewed code to ensure that all the processes and standards are being adhered i.e. ensuring correct implementation of requirements, coding standard, project structure, efficient code writing techniques etc.

Environment: ASP.Net2.0/1.1, C#.Net2.0/1.1, ADO.NET, SQL Server 2000/7, VB6.0, VSS, Windows XP/2003, IIS6.0

ShawMan Software Enterprises, Mumbai, India Oct‘02 – Nov’04

Role: Software Programmer

Project: Customer Relationship Management

This project captures a detailed demographic profile for each customer through a list of defined variables. To expand the profile, other variables and rules for accepting those variables can be defined on the fly through a build and deploy master model.

Responsibilities:

This is a win forms Client Server Application.

Created different windows forms by using VB6.

Used Visual FoxPro, SQL Server, Oracle and MS-Access databases for data storage.

Multiple databases Oracle and SQL Server have been used for data storage and retrieval on demand.

Later on migrated from Visual FoxPro database to SQL Server 7 and then SQL Server 2000.

Used Seagate’s Crystal Reports 7.0 and 8.5 for all the Reports.

Used Report Viewer control to view all the reports in windows forms.

Added the bulk mail feature so that whenever there is any event goes on, the customer can be invited by sending mails.

CRM is the product developed by ShawMan Softwares, so for initial set up we had to visit to the client location and configure the CRM system.

Providing training to the users once the setup is done, so that they can use the system smoothly.

Also created a Customer Profile page in classic ASP page and integrated this with the windows application so that a user can create the customer profiles from a remote location too.

Created a customer points statement report, which can be generated and send to the customers whenever required.

Interacted with Clients to understand and clarify requirements.

Interacted with clients to raise and clarify concerns.

Code reviewed to ensure that code is implemented as per the standards.

Supported, maintained the application and troubleshot production issues. Sometimes had to visit to the client location to resolve the issue depending upon its criticality.

Created user definable Security Shell extending to functions or tasks (Authorization in web applications).

Environment: VB 6.0, Visual SourceSafe, Windows 98/NT, Visual FoxPro 5/6, SQL Server 7/2000, Oracle 8i, MS-Access, Crystal Reports 7/8.5.

ACADEMIC QUALIFICATION

Master of Computer Application, IGNOU, India.

DNIIT in Computers, NIIT, India.

CERTIFICATIONS

Microsoft Certified Professional Microsoft SQL Server 2008, Business Intelligence Development and Maintenance – July 2011.

Microsoft Certified Professional Microsoft® .NET Framework 3.5 Windows® Communication Foundation – June 2011

Contact this candidate