SUMMARY:

• Over all 7+ years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2008/2005/2000.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data WareHouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

Data Warehouse Tools: SSIS, SSRS, SSMS, Business Intelligence Development Studio, DTS, Enterprise Manager, SQL Profiler.

Databases: Oracle 9i, SQL Server, MS Access

SQL Server Tools: SQL Server 2000/2005/2008 R2/2012, Oracle9i/10g

Operating Systems: Windows NT/98/2K/XP

Programming Languages: C#, VB.Net, Javascript, jQuery, AJAX

Web Technologies: ASP.NET, JSON

Other Tools: Aspose PDF/Excel, Crystal Reports, Dundas Reports

Productivity Tools: MS Office, Visio, Rational tools.

Domain knowledge: Investment Banking, Energy, Insurance, Loan, Healthcare

PROFESSIONAL EXPERIENCE:

Confidential

Technical and Functional lead

Responsibilities:

• All technical aspects of solution delivery including business requirements gathering, analysis, design, development, quality, documentation and support.
• Overall applications design and mapping the business requirements to technical specifications.
• Developing, maintaining and enforcing standards across the development team.
• Architecting, design and implementing ASP.NET web solutions with industry best practices and design patterns.
• Portfolio module technical and functional lead.
• Created data service layer using WCF.
• Created SSIS Packages to import data from different data sources.
• Developed complex SQL procedures, functions for extracting and loading data from database. Relational Sources/Targets include SQL Server tables.
• Point of Contact for any project related issues.

Environment: Sql Server 2008/12, SSIS, ASP.NET 2.0/4.0, C#, MVC 3.0, XML, WCF, Rational Synergy.

Confidential

Technical Lead

Responsibilities:

• Developed complex SQL procedures, functions for extracting and loading data from database. Relational Sources/Targets include SQL Server tables.
• Created SSAS cubes and SSRS reports for detailed report as well as Dashboard report.
• Implemented drill through and drilldown on the reports.
• SQL Server procedures and query performance tuning.

Environment: Sql Server 2008, SSAS, SSRS, BIDS.

Confidential

Technical Lead

Responsibilities:

• Lead team for most complex module (Search) of the project.
• Interacted with subject matter experts to understand the business requirement and design the application accordingly.
• Provided technical guidance and assistance to development teams.
• Was involved in Technical Design and documenting the same.
• Extensively implemented C# 4.0, Jquery, Page methods, AJAX in the module.
• Designed and developed ASP.NET MVC 4.0 web page using Ajax, Entity Framework 4.0, jQuery and Linq.
• Developed complex SQL procedures, functions for extracting and loading data from database. Relational Sources/Targets include SQL Server tables.
• Used Aspose.PDF for merging files and uploading to server and viewing at client-side.
• Write NUNIT unit test scripts/ test cases.
• SQL Server performance tuning.

Environment: ASP.NET, C# 4.0, MVC 3.0, JQuery, Javascript, Sql Server 2008, ASPOSE.PDF

Confidential

Consultant

Responsibilities:

• Daily scrum meetings, sprint planning, sprint review, and sprint retrospective.
• Development of Offerings module.
• Extensively implemented C#, VB.NET, Jquery.
• Used XSLT to dynamically generate the HTML rendered to the client.
• Defect fixing of other existing VB.NET modules.
• Involved in Functional Requirements gathering and documenting the same.
• Involved in Technical Design and documenting the same.
• Status reporting with client on fortnightly basis.

Environment: ASP.NET 1.1/2.0/3.5, C#, VB.NET, XML, XSLT.

Confidential

Consultant

Responsibilities:

• Was involved in Functional Requirements gathering and documenting the same.
• Was involved in Technical Design and documenting the same.
• Extensively implemented ASP.NET, C# 3.5.
• Plan and design Microsoft SharePoint environments, and develop web parts.
• Extensive development of stored procedures and functions using SQL Server 2008.
• Worked on SQL Server performance tuning.
• Writing unit test cases using NUNIT.

Environment: C#, .Net framework 3.5, MVC 3.0, SQL Server 2008, Sharepoint 2007

Confidential

Consultant

Responsibilities:

• Involved in Technical Design and documenting the same.
• Used WinForms, C# 3.5.
• Extensive development of stored procedures and functions using SQL Server 2008.
• Used strongly typed datasets for data exchange.
• Writing unit test cases using NUNIT.
• Responsible for preparing Project Status Report and distribution of the same to the onsite and offshore project team.
• Involved in Project Quality Scorecard review meeting.

Environment: C#, .Net framework 3.5, SQL Server 2008

Confidential

Senior Software Engineer

Responsibilities:

• Was involved in Technical Design and documenting the same.
• Analysis of any development or customization request for the application as raised by the business users.
• Used ASP.NET, C# 3.5.
• Developed web parts to be implemented in the Sharepoint portal of Confidential .
• Extensive development of stored procedures and functions using SQL Server 2008.
• Writing unit test cases using NUNIT.
• Responsible for preparing Project Status Report and distribution of the same to the onsite and offshore project team.

Environment: C# 3.5, SharePoint 2007, SQL Server 2008, Windows

Confidential

Software Engineer

Responsibilities:

• Designing and development of various custom controls.
• Analysis of the development or customization of the application modules.
• Involved in the mentoring of junior team members and new joiners with respect to the process flows in this project.
• Peer reviews and unit testing of application modules.

Environment: C# 2.0, ASP.NET, Windows

Confidential

Software Engineer

Responsibilities:

• Interfacing with the business users and onsite team to identify their requirements.
• Involved in HLD and LLD.
• Designing and development of new SSIS packages, SQL Stored Procedures, and tables.
• Worked on SQL Server performance tuning.
• Develop custom VB.NET script tasks, to transform excel data to XML and pass it as a parameter to the stored procedure to enter in the database.
• Involved in the mentoring of new team members with respect to the process flows in this project.

Environment: ASP.Net 2.0, VB.Net, XML, SSIS, SQL Server 2005, Windows

Confidential

Software Engineer

Responsibilities:

• Develop ASP.NET application using C# 2.0.
• Designing and development of new SSIS packages, SQL Stored Procedures, and tables.
• Writing unit test cases using NUNIT.
• Preparing Project Status Report and distribution of the same to the onsite and offshore project team.
• Writing Unit Test scripts for the SSIS packages.

Environment: ASP.Net 2.0, C#, SSIS, SQL Server 2005, Windows

Confidential

Software Engineer

Responsibilities:

• Client interaction to understand business functionality and identifying requirements.
• Involved in preparing Functional Specification document, GAP analysis document.
• Develop ASP.NET application using C# 2.0.
• Unit testing of modules.

Environment: ASP.Net 2.0, C#, Remoting, Oracle 9i, Windows

Confidential

Software Engineer

Responsibilities:

• Training in CRM as part of the COE (Centre of Excellence) team.
• Involved in giving presentations and sessions of the architecture and usability of the application.
• Worked on internal project to get hands-on experience.

Environment: MS CRM 3.0, Windows