Post Job Free

Resume

Sign in

Sql Server Project

Location:
Raleigh, NC
Posted:
September 22, 2015

Contact this candidate

Resume:

Sushil Fund

Mobile: 720-***-****

Email: acrsyn@r.postjobfree.com

Summary

Microsoft Professional with over 8+ years of experience in IT industry with Object-Oriented Design and Development including Software Development Life Cycle (SDLC) from analysis and design to implementation with .Net Technologies.

Proficient in programming with MS.Net frameworks and sound knowledge of associated technologies such as ASP.Net, MVC-3, C#.Net, Entity Framework,nuget,ADO.Net, WCF, and JavaScript.

Good understanding of Web development architecture & design.

Experience in working with Windows and Console based applications.

Adept at all phases of the Software Development Life Cycle including Requirement Analysis, Design & development, Testing, Implementation using Agile Methodology.

Demonstrated Technical Proficiency in a high paced production environment & exercise judgment within defined procedures & practices to determine appropriate action.

Experience in working with Windows Communication Foundation (WCF).

Good Experience in using XML and XSLT Transformations.

Proficient in creating Services and Endpoints using WCF (Windows Communication foundation).

Strong Experience in creating and consuming Web Services in applications.

Proficient in using version control tool like Visual Source Safe (VSS),TFS and MKS

Worked extensively on Relational Databases using “MS SQL Server 2000/2005 and oracle 9i

Well versed in writing of complex Database Queries, Stored Procedures and Triggers using Transact SQL and PL-SQL

Have knowledge using JavaScript, JQuery and client validations.

Have knowledge using AJAX with .NET web applications.

Experience in OOAD techniques, service-oriented architecture (SOA).

Having sound knowledge in Windows Workflow Foundations (WWF), Window Presentation Foundation (WPF) and LINQ as well as ORM, NHibernate.

Used CruiseControl for continuous build and mail notification.

Have done some POC on .Net Framework 4.0

A systematic, organized, hardworking team builder with an analytical bent of mind, reliable as a fully contributing, responsible & accountable member of task/project teams.

Technical skills:

Technologies : C#.net, .Net Framework (1.0, 2.0, 3.0, 3.5, 4.0), ASP.net, MVC3/4, Entity Framework, ADO.Net, SOAP, Web Services, LINQ, NHibernate,MS Unit test NUnit, WCF, bootstrap,HTML, AJAX, JQuery, JavaScript, AngularJS, webAPI,Install Shield 12,

Windows Installer (MSI).

OS : Microsoft Windows Family.

Tools : Microsoft Visual Studio 2003/05/08/2010, Toad, JavaScript, DHTML, HTML, CSS, IIS 5.0/6.0,

Mercury Quality Center 9.0, CruiseControl, Excel,SSRS, SSIS, ReSharper, Mantis bug tracker

Databases : SQL Server 2005/2008, Oracle 9i/10g, MongoDB

Design Patterns : MVC, facade, Single Ton, Factory Patterns, dependency injection, Abstract Factory pattern

TDD

Education:

Bachelors in Electronic Engineering

Diploma in Advanced Computing (C-DAC).

Professional Experience

Spectraforce Technology Inc. April 2014 to till date

Sr. Software Engineer

Project I: Passport - 1800PackRat

Passport application was built for Customer Service representative to replace existing different systems handling orders for local, long distance move and trailer service. In order to simplify and automate business processes to the greatest extent possible, passport application integrate this different system into one access point for the Customer Service agent.

Also this application consumes service from other third party vendor to get quotes and use the trailer service from OD(old dominion). This application gives ability to make payments using blue payment gateway using different payment methods, generate reports for the business analysis, Billing and Finance. Passport has ability to log the history for agent activities.

Responsibilities:

Coordinated with the offshore team on daily basis.

Scrum meeting on daily basis.

Mentor junior developer at offshore.

Extensive involve in analyzing business requirement and discussion with business users.

Assign work to other team member and explain them using detail technical document

Created LINQ Extension method to reuse the components.

Created common framework and utility methods to use across the projects.

Created development task in TFS.

Used unity application block for Dependency injection.

Developed UI Screens with MVC 3/4.

Created html helpers for various controls.

Created WCF restful services to return JSON for business logic.

Implemented action filters for security and page access authorizations.

Created extension method for project framework.

Used TDD design for unit testing.

Used Nlog to log system errors.

Integrated BL components with UI components.

Implemented the project using n-tier architecture with presentation tier ( MVC3), Business Tier (C#.net and Linq to Entity Framework) and backend database tier.

Created stored procedure and used it with entity framework.

Implemented test driven development by integration and unit testing.

Involved in implement change request as per the business requirement.

Environment: DotNet4.0,C#.Net, MVC 3/4,Asp.net, Nuget, Entity Framework, Unity Application block,MS-Unit test,WCF restful, TFS,JSON, JQuery, JavaScript, Ajax,T-SQL, Sql Server.

State Gov. of Colorado (Unemployment) Denver June 2012 to April 14

Sr. .Net Consultant

Project I: MyUi Employer(ISS)

In an effort to serve the citizens of Colorado, the Colorado Department of Labor & Employment (CDLE) has partnered with Colorado Interactive (CI) in order to create an application MyUi Employer it gives ability to Employers to file their wage and premium report online, this also allows employer to pay their premium online. This application has implemented custom membership with one admin user(Employer) has access to add multiply user(Employee) and grant access to the pages.

Application has an ability to register agent and manage the employer wage and premium report.

Employer can view their history of the wage and premium report, and copy the previous report to file new report with same employee to minimize time for data entry.

Responsibilities:

Wrote technical specification for Admin to maintain the application.

Created an admin application to maintain MyUi Employer app.

Used entity framework as an EDM model.

Created LINQ Extension method to reuse the components.

Created custom validation on models using regular expression.

Created development task in TFS.

Implemented authentication using Active directory.

Used unity application block for Dependency injection.

Used DTC to handle transaction over different database servers.

Used transaction scope objects.

Developed UI Screens with MVC and Bootstrap.

Created html helpers for various controls.

Created WCF restful service to expose to other applications in state project.

Designed and developed configuration setting project for all application in state projects.

Implemented action filters for security and page access authorizations.

Created extension method for internal project framework.

Used TDD design for unit testing.

Integrated BL components with UI components.

Implemented the project using n-tier architecture with presentation tier ( MVC3), Business Tier (C#.net and Linq to Entity Framework) and backend database tier (Sql Server 2008).

Developed IssCommon Framework common for all the applications.

Implemented test driven development by integration and unit testing.

Involved in implement change request as per the business requirement.

Environment: DotNet4.0,C#.Net, MVC 3/4, nuget, Entity Framework, Unity Application block,WCF restful, TFS,JSON, JQuery, Ajax, Sql Server, bootstrap, WebAPI.

State Gov. of Colorado (Unemployment) July 2011 to June 2012

Sr. .Net Consultant

Project II: SmartPay(ISS)

SmartPay replaces the Internet Continued Claims application and the DIRT ICC. The claimants will access SmartPay via their MyUI account. Claimants will experience similar questions and follow up “drill down” questions as they do today. Should a claimant trigger the need for a reopen (where they indicate a new job separation or where their claim is inactive), SmartPay will advise them of such and present the opportunity to initiate the reopen transaction via SmartFile. SmartPay will have a built in “switch” allowing the Division to control whether the application presents one week for filing or two weeks. This allows the Division to implement a “one week filing” system whereby the Claimants file for benefits every week for one week each time or to remain or go back to the current system where Claimants file for benefits every other week for two weeks at a time.

Responsibilities:

Daily standup meeting with client team.

Used entity framework as an EDM model.

Developed UI Screens with MVC 3.

Created html helpers for various controls.

Designed and developed configuration setting project for all application in state projects.

Implemented action filters for security and page access authorizations.

Created extension method for internal project framework.

Created WCF restful service to expose to other applications in state project.

Used TDD design for unit testing.

Integrated BL components with UI components.

Used unity application block for Dependency injection.

Implemented the project using n-tier architecture with presentation tier ( MVC3), Business Tier (C#.net and Linq to Entity Framework) and backend database tier (Sql Server 2008).

Developed IssCommon Framework common for all the applications.

Implemented test driven development by integration and unit testing.

Involved in implement change request as per the business requirement.

Environment: DotNet4.0,C#.Net, MVC 3, Entity Framework, TFS,JSON,WCF restful, Unity Application block,JQuery, Ajax, Sql Server.

State Gov. of Colorado (Unemployment) Apr 2011 to Jul 2011

Sr. .Net Consultant

Project III: MyUi Claimant

In an effort to serve the citizens of Colorado, the Colorado Department of Labor & Employment (CDLE) has partnered with Colorado Interactive (CI) in order to create an application, MyUI Claimant (MyUI), allowing an unemployment insurance claimant to view claim status and additional claim information online, thus promoting self-service.

Currently, claimants cannot view claim status or additional claim information online. If a claimant needs claim status and information, they must call the Unemployment Insurance (UI) Customer Contact Center. UI personnel then retrieve claim status and information from the legacy mainframe.

This self-service function will be particularly helpful as the state seeks to keep pace with the increasing demand for unemployment services resulting from the recession. By using technology to help stakeholders share information, UI personnel should be able to increase customer service by decreasing response times.

Responsibilities:

Daily standup meeting with client team.

Used entity framework as an EDM model.

Developed UI Screens with MVC 2.

Created html helpers for various controls.

Designed and developed configuration setting project for all application in state projects.

Implemented action filters for security and page access authorizations.

Created extension method for internal project framework.

Used TDD design for unit testing.

Integrated BL components with UI components.

Implemented the project using n-tier architecture with presentation tier ( MVC3), Business Tier (C#.net and Linq to Entity Framework) and backend database tier (Sql Server 2008).

Developed IssCommon Framework common for all the applications.

Implemented test driven development by integration and unit testing.

Involved in implement change request as per the business requirement.

Environment: DotNet4.0,C#.Net, MVC2, Nuget,Entity Framework, LINQ, TFS,JSON, JQuery, Ajax, Sql Server2008.

Hitachi Consulting, India Jan 09 to Mar 11

Sr. .Net Consultant

Project II: BUPA [SWIFT]

SWIFT provides a set of services for consumption by BUPA applications. It's based on service-oriented architecture (SOA) with MVC pattern. SWIFT's services are implemented using a combination of business logic, business rules and business processes. SWIFT's services are accessed via web services that are exposed via the SWIFT application servers. SWIFT has a variety of different mechanisms for the implementation of these services including .NET code, Haley Rules. it also has Credit Control module involving claims payment/summary, dunning, different types of payments, collections and invoice generation, payment cancellation etc. and linking these to Swift’s in-house workflow systems to generate tasks and system events.

Responsibilities:

Used WCF (DotNet3.5) technologies to develop the services.

Developed UI Screens in ASP.NET with MVC Pattern with C#.

Used NUnit for TDD design.

Implemented the project using n-tier architecture with presentation tier (ASP.NET), Business Tier (C#.net and ADO.NET) and backend database tier (Oracle 9i/10g).

Developed, different layer for like Data Access Layer, business layer, Transformation Layer, Validation Layer.

Integrated certificate to secure the service, enable HTTPS and authenticate the outer client.

Involved in creating different environment like production and Non-production.

Mentor junior members of the team and provide them assistance and doing code walkthroughs according to documented policies, procedures, and standards

Provided WCF (Windows Communication Foundation) service for more than 30 other application.

Environment: DotNet3.5,C#.Net, Asp.net3.5, WCF (Windows Communication Foundation), MKS and TFS,JSON, JQuery, Oracle 9i/10g, Toad, Mercury QC, Re-sharper, CruiseControl, PL-SQL.

Approva System,India Mar 08 – Dec 09

Sr. Developer

Project III: Automate User Access Certification

Certification Manager Make’s periodic user access reviews a straightforward exercise by automating the review and approval process for business transactions. It automates the end-to-end process across ERP systems and other business applications. Comprehensive, easy to understand summaries are routed to approving reviewers to accept or revoke access rights for their teams. All actions are tracked and retained to facilitate the sign-off by senior management. Certification Manager automatically sends email notifications to reviewers to initiate the review process. Reminders and alerts notify managers when action has been taken. Notifications can be routed based on user-defined criteria such as role naming conventions, user attributes and organizational values.

Responsibilities:

Involved in integration of applications and maintained versions using VSS (Visual Source Safe).

Developed UI Screens in ASP.NET with MVC Pattern with C#.

Implemented service oriented component (SOA) Layer using C#.net and WCF to decouple the UI with BL

Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application.

Configure TCP Protocol in WCF Service.

Used LINQ to SQL ORM tool for mapping database tables with C# code.

Created Proxy for Client Application using SvcUtil tools and also used as Service Reference.

Implemented Windows Authentication in WCF to consume the Service as application is used in intranet.

Responsible for developing Contract and Fund Screens, this contains core business logic for the SVP application.

Mentored junior developers and made them to follow the standards as per specifications.

Performed code review and generated reports on code review comments and updates.

Created SSIS packages for importing data from BizRights database.

Move the business logic and complex mathematical calculations from UI layer to SQL Server wherever possible.

Environment: DotNet3 DotNet3.5, Asp.net3.5, WCF(Windows Communication Foundation),TFS SQL server 2005, Re-sharper,SQL server 2005/2008,SSIS,LINQ.

C.S Informatics, India Jan 06 – Dec 07

Project I: Career Age

This project was about online Consultancy & Job Portal including Job Placement, resume making etc. User was able to apply for jobs online & also update their profile later. Employer could post their requirements & find application for that job. Employer could also have an option for consultancy service. We also provided the password in case the user/employer forgot the password. The complete project was divided into three modules viz. Admin, Jobseeker & Employer.

Responsibilities:

Gathered requirements to produce Functional and Technical specifications

Engage with the analysis, design, development, testing of the application.

Developed & maintained Web Forms with ASP.Net and C#.Net.

Extensively using Datasets, Datatable of ADO.NET to retrieve and manipulate data and display it in an ASP.NET page and user control.

Using DataGrid, DataList to display data in a customized format in the ASP.NET web pages.

Created complex Stored Procedures, Triggers, Views & Functions using SQL Server 2005.

Handled all issues regarding database, its connectivity & maintenance.

Environment: Visual Studio .NET 2005, using C#, MS-SQL Server2005, Ajax, JavaScript, ADO.NET, IIS6.0,

HTML, Windows XP,

Developer Jun-05 to Jan-06

Project II: Lead Management System

This Software manages each activity starting from the BOC (Beginning of Campaign), Daily Activities and EOC (End of Campaign). BOC includes Loading of Lead Data (Customer Details), Scrubbing, Generating the Call Table. Daily Activities includes Scrubbing, Multiple Sales information Capturing, Report generation. EOC Includes inventory of the Lead data and its related Reports.

Responsibilities:

Involved Requirements Analysis Phase to Design, Development, Testing, Integration, impact analysis, Implementation, enhancement and supporting.

Implemented data module design with SQL server 2005.

Daily scrum meeting discussing with team members.

Implemented various User Controls in front-end forms using ASP.NET.

Implemented the project using n-tier architecture with presentation tier (ASP.NET), Business Tier (C#.net and ADO.NET) and backend database tier (SQL server 2005).

Use of Microsoft Enterprise Library classes along with ASP.NET for N-Tier project development.

Implementing Unit test cases.

Automation of build process of modules and integration of modules.

Execute authentication framework for validating installer.

Implemented functionality for validating report server and uploading SQL reports.

Environment: ASP.NET 2.0, C#.NET, SQL Server 2005, web services, Visual Studio 2005, PL-SQL, VSS.



Contact this candidate