Resume

Sign in

Sql Server .Net

Location:
Naperville, Illinois, United States
Posted:
February 20, 2018

Contact this candidate

Professional Summary :

Over * years of experience in programming, ETL development using SSIS, T-SQL.

Experience in various phases of Software Development Life Cycle (SDLC) such as Analysis, Design, Development, Testing, Deployment and Maintenance of web and windows applications.

Experiences in .Net Technologies include Object Oriented Languages (C#), Database (SQL Server), ADO.NET, VB.NET, MVC, WCF, Server administrations (IIS) and other supporting technologies and tools.

Worked on ADO.NET Entity Framework to associate with database for CRUD operations and LINQ to Entities, Lambda Expressions, and OO Design Patterns.

Very proficient in HTML, CSS, JavaScript, JQuery, JSON, AJAX, XML and other web tools.

Designed rich user interface in web application using HTML, CSS, and SKIN.

Experience on architecture design using Tiered architecture and knowledge of design patterns (Factory pattern, Singleton etc).

Experience in Object Oriented Analysis and Design(OOAD) techniques like UML using Flow Charts/Process Flows, Use Cases and Class, Sequence, Activity and State Transition diagrams

Extensive experience in monitoring, troubleshooting and supporting .NET based applications and infrastructure.

Having knowledge of SOA using WCF services (Security, transaction etc).

Good command over commercial RDBMS such as MS SQL Server, Oracle and MS Access.

Experience in using VSS, TFS and SVN for project source control management.

A Skilled at progressing from problem statement to well documented design. Managed complete life cycle of multiple projects including project plan / timeline setup, maintaining project deliverables, creating status reports.

Worked in both Agile and traditional SDLC software methodologies driven developments.

Proven ability to work as a Team Player as well as an individual. Good Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities. Done Client interaction. Hard working and motivated.

Technical Skills:

Operating Systems: Windows and Linux

GUI Tools: Visual Studio.NET 2008/2010/2012/2013/2015

Languages/Technologies: C#.Net, VB 6.0, VB.Net, PL/SQL, UML, T-SQL, SQL

Web Technologies: ASP.NET, MVC, AJAX, HTML, XML, XSL, XSD, WCF, Web Services, JavaScript, JQuery, Ext js, CSS and SKIN

Databases: MS-SQL Server 2005/2008/2008R2/2012, Oracle 10g

Middle Ware: LINQ and ADO.Net

Methodologies: OOP, OOAD, Client/Server

OR Mapping Technologies: Entity Framework, Linq2Sql

Version Tool: Team Foundation Server, SVN, Visual Source Safe

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Web Servers: IIS 0.5/0.6/0.7

Frameworks: .NET Framework 2.0/3.5/4.0/4.5

Professional Experience:

Duration : Mar 2017 – Nov 2017

Client : Bank of America

Technologies : ASP.NET, C#, Ext js, WCF, MS-SQL Server,SSIS(SQL server integration services).

Role : Dot Net Developer

Description :

Access Request Management (ARM) is an Enterprise standard access governance solution and provisioning portal that manages resource access lifecycle processes through a single user-friendly portal.ARM is a tool that allows users to request access to resources such as applications and

within different Lines of Business (LOBs).Requests stored within the ARM database ensure compliance and an accurate trail for every application and every user request.ARM allows users to request and provision access to applications within the bank.

Responsibilities:

Involved in the SDLC of requirement analysis, design and development of the web based application.

Designed and developed web pages using ASP.NET, C#.NET, WCF, JSON, HTML5, JQuery and Ext js.

Developed the application with n-tier architecture using Class libraries, Data entities, Services, Data access layer, business logic layer and stored procedures.

Developed the business layer with LINQ to Objects and LINQ to SQL.

Worked on migration of SSIS packages.

Used Team Foundation Server (TFS) for all the source code maintenance needs, tracking using work items.

Microsoft SharePoint for managing the documents and wiki.

Performed unit testing and involved in documentation

Involved in support and maintenance

Duration : Sep 2015 – Oct 2016

Client : Edelman

Technologies : ASP.NET, C#, MVC, MS-SQL Server.

Role : Sr. Software Engineer

Description :

Daedalus involves two primary project workflows: creating and publishing monitoring reports and content analysis.

1.Creating and Publishing Monitoring Reports

Daedalus provides the “behind the scenes” tools for creating reports. The Platform allows users to set up reports and report templates with various properties and sections for easy organization of content. Users can determines which sections and content to be visible to the client in the final report or “Cover Page” and which sections and content will be visible to the analyst working on the report.

2.Content Analysis

Daedalus also provides a platform for content analysis, where analysts can tag articles for brand mentions, tone messaging, influencers and more.

Responsibilities:

Developed and Implemented Web Forms using ASP.NET and coded the Business logic in C#

Worked on migration of ASP.Net application into MVC architecture.

TFS for code repository and for tracking work items.

Microsoft SharePoint for managing the documents and wiki.

Used n-tier architecture and Object Oriented Methodologies for application development.

Performed unit testing and involved in documentation

Involved in support and maintenance

Duration : Mar 2013 – Mar 2015

Client : JP Morgan chase & Co., USA

Project Name : Cards UDBA Control

Technologies : ASP.NET, C#, Web Services, XML, MS-SQL Server.

Role : Sr. Software Engineer

Description :

2.JPMC has many business defined applications developed which do not have mandatory checks on them. Cards UDBA team helps out to implement these checks on many of these users defined different applications.

3.To implement these checks team is required to implement cyber Ark and peregrine on different Applications such as web Applications, SSIS packages, UNIX and Access based applications.

Responsibilities:

Involved in full Software development life-cycle (SDLC) for this project.

Was involved in requirement analysis, preparing design documents and knowledge transfer calls with SME's for different UDBA’s from different block such as FRD, CSD and ORI.

Worked on Web Applications with MVC Pattern, and SSIS Packages for this and previous releases.

Design and develop SSIS packages, stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.

Developed CyberArk and Peregrine code for all set of UDBA's.

TFS for code repository and for tracking work items.

Microsoft SharePoint for managing the documents and wiki.

Was involved Unit Testing, bug fixing and production deployment of these applications.

Designing and solving technical and functional queries of the team.

Conducted peer reviews and code reviews for the code implemented.

Supporting testing team to understand functionality during System testing.

Duration : Jun 2011 – Aug 2012

Client : Tata Communication Ltd.

Project Name : Travel & Expense System

Technologies : ASP.NET, C#, MS-SQL Server.

Role : Developer

Description : Web base Travel and Expense portal to facilitate employees to claim their expenses through this system and it has integrated with workflow management system to accommodate multiple levels of approval. System communicates with SAP ERP system to post and get information real time. It enables Admin to take control of administrative activities like Policy Management, Email Management, Mobile Claim data management, HR data integration with internal application. It validates all the expenses based on integrated HR policies. It has the facility to generate different types of reports.

Responsibilities:

Involved in interacting with business analysts, other developers and management to develop the application.

Prepared design document based on the requirement.

Involved in all phases of Project life cycle (SDLC).

Developed Web pages using ASP.NET using Server controls, AJAX toolkit controls, HTML Controls and CSS.

Developed business layer components in C#.NET.

Involved in front end design and controls using ASP.NET.

Developed web pages using JavaScript for Client side Validation.

Created Master Page to provide rich look feel for entire application.

Designed and Developed an Interactive Graphical User Interface for various modules using Win Forms, Windows service and User Controls.

Created Master Page to provide rich look feel for entire application.

Designed and Developed an Interactive Graphical User Interface for various modules using Win Forms, Windows service and User Controls.

Used ADO.NET objects such as Data Adapter, Command Builder, Data Reader, and Dataset for consistent access of data from SQL Server database for legacy applications.

Used VSS for version control on a shared team environment.

Involved in Unit and Integration Testing and Implementation.

Participated in User Acceptance Testing (UAT) with business users.

Worked on the Build Release document for deployment.

Worked in Production Support after the release.

Duration : Nov 2010 – May 2011

Client : LaQuinta, USA

Project Name : Vendor Portal

Technology : ASP.NET, C#, MS-SQL Server.

Role : Developer

Description : Vendor portal allows suppliers to create, upload and send invoices in an electronic format with date and images both. This portal allows integration of supplier with the customer organization eliminating paper in the Accounts Payables process. Suppliers can view the status and track their remittance online using the Vendor Portal. Vendor can also change the payment terms i.e. Dynamic Discounting for early payment processing and customer can avail discount for the same. It also controls admin activity like new user registration, queue and status mapping etc.

Responsibilities:

Gathered business requirements from the business, analyzed the requirements and prepared design document.

Developed Web pages using ASP.NET using Server controls, AJAX toolkit controls, HTML Controls and CSS.

Developed business layer components in C#.NET.

Involved in front end design and controls using ASP.NET.

Created Master Page to provide rich look feel for entire application.

Developed web pages using JavaScript for Client side Validation.

Used ADO.NET objects such as Data Adapter, Command Builder, Data Reader, and Dataset for consistent access of data from SQL Server database for legacy applications.

Used VSS for version control on a shared team environment.

Involved in Unit and Integration Testing and Implementation.

Duration : Jun 2010 – Dec 2010

Project Name : e-Process Manager+

Technology : ASP.NET, C#, MS-SQL Server.

Role : Developer

Description : e-Process Manager+ is a sophisticated web based workflow management framework to help organizations optimize their Financial Operations. Through a series of hosted offerings, customers gain tremendous efficiency improvements within Payables Management, Receivables Management and General Ledger Management. The web based interface of ePM+ makes it a highly user friendly and geographically scalable solution that can be customized easily to handle complex workflows for specific business requirements. An online supplier portal enables e-invoicing, auto-routing of invoices for approval, and highly responsive customer service.

Responsibilities:

Gathered business requirements from the business, analyzed the requirements and prepared design document.

Developed Web pages using ASP.NET using Server controls, AJAX toolkit controls, HTML Controls and CSS.

Developed business layer components in C#.NET.

Involved in front end design and controls using ASP.NET.

Created Master Page to provide rich look feel for entire application.

Developed web pages using JavaScript for Client side Validation.

Used ADO.NET objects such as Data Adapter, Command Builder, Data Reader, and Dataset for consistent access of data from SQL Server database for legacy applications.

Used VSS for version control on a shared team environment.

Involved in Unit and Integration Testing and Implementation.

Duration : Jun 2009 – May 2010

Client : ICICI Lombard

Project Name : Health Insurance

Technology : ASP.NET, C#, MS-SQL Server.

Role : Developer

Description : This module is developed for direct Issuance of health policies through the Policy Administration System. It also caters to the further facilities like Endorsement, Cancellation and renewals of the issued policies. Suitable Policy Certificates, Renewal Notices, Endorsement Letters are generated through the system.

Responsibilities:

Requirement Analysis, Preparation of functional and technical document.

Developed and enhanced the Graphical User Interface of the Website using ASP.NET, C#. NET, HTML, JavaScript.

Performed unit testing and involved in documentation

Involved in support and maintenance

Duration : Jan 2009 – May 2009

Client : ICICI Lombard

Project Name : MDS (Master Data Synchronization)

Technology : ASP.NET, C#, MS-SQL Server.

Role : Developer

Description : MDS (Master Data Synchronization) is a central Repository of organization wide Master Data points. Worked on Integrating the Policy Admin related master level data directly from MDS to Policy Administration System.

Responsibilities:

Requirement Analysis, Preparation of functional and technical document.

Developed and enhanced the Graphical User Interface of the Website using ASP.NET, C#. NET, HTML, JavaScript.

Performed unit testing and involved in documentation

Involved in support and maintenance

Education Qualification: Master in Computer Science (M.Sc.), University of Mumbai



Contact this candidate