SUMMARY

• Around 10 years of experience in specializing system design, system analysis using Microsoft .NET and extensive database programming using MS SQL
• Well acquitted with the Software Development Life Cycle (SDLC), development of web and windows client/server architecture
• Experienced in MS.NET Framework, ASP.NET, VB.NET, C#, MVC, AJAX, Web Services, WCF, WWF, MSMQ, LINQ, JSON and Design Patterns.
• Experience in Object Oriented Programming (OOPS), development using C# 5.0, VB.NET on Windows and Web platforms
• Hands of experience in configuring WCF endpoints, Bindings, behaviors, Defining and implementing contracts
• Hands - on experience in developing SQL Azure DB programming.
• Strong knowledge in database and Data Mart designs.
• Strong work experience in developing Stored Procedures, Triggers, Functions, SQL Jobs, SQL CLR Procedures, and Functions using SQL and effectively performed DBA activities: database backup and restore, trouble shooting performance tuning, server setup and maintenance activities.
• Worked end to end in design development and deployment of Database projects.
• Extensive knowledge in Sql Server Integration Services(SSIS)
• Experience in design and development of user interface using HTML5, CSS3, JavaScript, JQuery and Angular JS
• Fully fledged with client side scripting like JQUERY Selectors, Events and AJAX etc
• Experience in designing & developing databases using SQL Server 2005/2008/2012 , MS Access
• Extensive working knowledge on SQL Reporting Services (SSRS), COGNOS and Crystal Reports
• Strong experience working with version control systems using Microsoft Visual SourceSafe, Team Foundation Server, Microsoft Visual Studio 2005/2008/2010
• Strong experience in MS Azure and Amazon Cloud.
• Hands on experience in Power BI reporting along with customization.
• Moderate knowledge on Tableau and R- scripting.
• Experience in building apps adhering to organization specific frameworks like ORM, Entity Framework etc
• Ability to handle projects independently and able to work proactively within team environment
• Worked on Agile/Scrum methodology which involves Poker planning and Bug triage processing.
• Hands on experience in testing process and involved in Test Case design Fully experienced in deploying, configuring and maintaining the web sites and services on IIS 7.0 with and without secured socket layer
• Proven ability in understanding system requirements, system architecture design, development, testing/QA and production environment setup and support
• Extensive working experience in unit, integration and performance testing framework

TECHNICAL SKILLS

Languages: C#, Asp.net, VB.NET, MVC5, JavaScript, JQuery, Angular JS

Databases: SQL Server 2005, 2008 & 2012.

Warehouse: SSIS (SQL Server Integration Service), SSAS (SQL Server Analysis Service)

Web Programming & Tools: AJAX, HTML5, CSS3, XML.

Source Controls: VSS, VSTS, TFS, Tortoise, Visual Studio online.

Visualization Tools: Power BI

Reporting Tools: SSRS (SQL Server Reporting Service), Actual Data Reports, Excel Power BI.

Scripting Languages: R scripting, Python

PROFESSIONAL EXPERIENCE

Technical Lead

Confidential, Branchburg NJ

Environment: ASP.Net, C#, JavaScript, JQuery, SQL Server 2012.

Responsibilities:

• Creating project management plans, schedules, cost estimates.
• Designed and developed the technical detail design documents based on functional requirements
• Establish inter process relation, for team communication and to produce high quality software
• Involved in Design & Development of software application, testing and procedures.
• Created application architecture, documentation of enhancements, and change in requests in UML and worked on designing UML diagrams like Use Case diagrams, Activity diagrams, Class diagrams used in all phases of SDLC using Microsoft Visio
• Designed and developed UI, input validations using ASP.NET, HTM5L and CSS3
• Used ADO.NET and its components DataReader, DataSet, Connection and DataAdapter as middleware component to access the SQL database
• Conducting knowledge transfer training sessions for each department users enabling smooth handover of system support and maintenance to the client.
• Regular client interaction and weekly reporting
• Developing performance tuning and enhancement approaches to improve overall system performance and provide value addition to the customer

Technical Lead

Confidential

Environment: ASP.Net MVC, C#, WCF, SQL Server 2012.

Responsibilities:

• Gathering Functional requirements & translating into Technical specifications
• Involved in Design & Development of software application, testing and procedures.
• Design and implement integration components using ASP.NET(C#) and JavaScript using latest industry standards and best practices
• Developed Single Page Applications using Angular JS, JavaScript, JSON and CSS3
• Designed the Views, Layout pages and Partial Views using ASP.NET MVC, AJAX and JQuery.
• Developed multiple web services for feeding data to multiple applications using WCF and implemented WCF to expose the web service which need to be consumed by other application.
• Migrated data from various data sources Excel, Flat file to SQL Server 2012 by using SSIS.
• Generated reports using SQL Server Reporting Services (SSRS).
• Regular client interaction and weekly reporting.
• Performed code reviews to improve performance of the application.
• Performed Unit testing, Integration testing and Regression testing of the application.

Sr. Associate Consultant

Confidential

Environment: PHP, Ajax, My SQL.

Responsibilities:

• Gathering detailed user requirements for key modules from the client to define the scope and deliverables.
• Involved in Performance tuning of database objects.
• Design and develop application, testing and procedures
• Manage and modify software program and improve their performance
• Daily-Weekly client reporting
• Managing Post production support

Sr. Associate Consultant

Confidential

Environment: ASP.Net, C#, SQL Server 2012, Ajax, Excel Reports.

Responsibilities:

• Designed and developed web based UI in C# using different controls like HTML controls, Data controls and Web controls
• Worked with ASP.NET web forms, Master pages, Web services, state management, caching features, configuring Optimizations and securing the web application
• Used ASP.NET Ajax extensively for calling web services without writing a lot of custom JavaScript code to handle the request and response messages.
• Created Reports using Crystal reports.
• Used Data Controls and Telerik Controls for binding data from database.
• Used ADO.NET Entity code first approach in retrieving data using LINQ to Objects
• Used Web Services to interact with the data layer to acess data from the database
• Manage and modify software program and improve their performance.
• Analyzing and troubleshooting issues from production environment.
• Implemented Unit, Integration and System testing using NUnit
• Integrating and deploying the project.

Technical Analyst

Confidential

Environment: ASP.Net, Ajax, C#, SQL Server 2005.

Responsibilities:

• Designed and developed web based UI in C# using different controls like HTML controls, Web controls and Data controls.
• Implemented features of ASP.NET 2.0 Calendar controls, Repeater Control and Security using form Authentication and used Validation controls to do Server side validations and client-side validations.
• Created UI Pages using Telerik controls for AJAX and ASP.NET
• Involved in Performance tuning of database objects.
• Conducting knowledge transfer training sessions for each department users enabling smooth handover of system support and maintenance to the client.
• Responsible for creation, tracking and maintenance of Change Control Analysis, application and system documentation
• Managing Post production support

Technical Analyst

Confidential

Environment: SSIS, SSAS, SSRS, SQL Server, C#, ASP.Net, Web services.

Responsibilities:

• Understanding and converting business requirements into functional requirements doc, review and sign off with the customer.
• Perform Impact analysis and provide optimal solutions to the Client, Business users.
• Test cases review to ensure the test coverage is 100%.
• Conducting User Acceptance Testing, bug triages, Signoff meetings.
• Involved in Active coordination with the External Interface partners/applications, utilized/developed the Web Services and Batch jobs in order to meet the requirements in an effective way.
• Adhere to Service Level Agreements with the customers related to Cube release, Data delivery and Scorecard publication timelines.
• Developing performance tuning and enhancement approaches to improve overall system performance and provide value add to the customer.

Technical Analyst

Confidential

Environment: ASP.Net, Ajax, VB.Net 2.0, WWF 3.0, SQL Server 2005.

Responsibilities:

• Gathering detailed user requirements for key modules from the business users to define the scope and deliverables for the project.
• Involved in design and development of various layers like façade layer, business layer and data access layer.
• Spearheading the design, implementation for the queuing and messaging using SQL broker services.
• Spearheading the design, implementation for the workflow using Windows Workflow Foundation 3.0
• Design and development of T-sql stored procedures, functions and database objects
• Involved in Performance tuning of database objects.
• Managing post production support

Senior Programmer

Confidential

Environment: ASP.Net, C#, MS SQL Server 2005, Visual Studio.Net.

Responsibilities:

• Actively involved in Design and Development.
• Design and development of T-Sql stored procedures, functions, database objects.
• Spearheading the design, implementation for the queuing and messaging using SQL broker services.
• Performed the integration testing of the application.
• Involved in Performance tuning of database objects.
• Managing post production support

Senior Programmer

Confidential

Environment: ASP.Net, C#, Ajax 1.0, Infragistics, SQL Server 2005

Responsibilities:

• Design and development of T-Sql stored procedures, functions, database objects.
• Involved in integration and extraction of data from multiple databases and files
• Responsible for developing and fixing priotised Incident reports.
• Analyzing and ensuring IR assigned are valid defects and discussing the fixes with the team members from different teams to asses impact of any changes
• Involved in Performance tuning of database objects.
• Providing production support to modules or processes to ensure Confidential IRIN day to day activities have minimum downtime.

Developer

Confidential

Environment: ASP.Net, VB.Net, SQL Server 2000, MS SharePoint

Responsibilities:

• Migrating applications for higher versions
• Integrating with MS Share Point
• Performing integration testing of the applications.

Developer

Confidential

Environment: HTML, ASP.Net, VB.Net, SQL Server 2000, FrontPage, IIS

Responsibilities:

• Preparation of architectural designs for each of the components that were assigned for the development
• Development of Web Forms for Client-Server Interaction.
• Responsible for designing, developing and testing of application using Asp.Net, HTML, CSS, and SQL Server 2000 as database
• Responsible for writing Views, stored procedures, functions and triggers.
• Gave extensive production support.