SUMMARY

• 9+ years of IT experience in design, development, testing and implementation of Web Applications, Windows Applications and Microsoft Business Intelligence.
• Expertise in ASP.NET for designing and developing web based applications using C#.
• Proficient in developing .NET applications using Win Forms and Web Forms to provide n - tier business solutions.
• 2 years of experience in ASP.NET MVC framework, 2 years of experience with jQuery, Angular.
• Expertise in designing and developing GUI for Web applications using ASP.NET, MVC, HTML, DHTML, Web Api, JavaScript, jQuery, Bootstrap, and CSS.
• Experience in using Language Integrated Query (LINQ) and Entity Framework (EF).
• Expertise in working with ADO.NET components such as Datasets, Data Adapters and Data Readers using MS SQL-Server.
• Expertise in many stages of Software Development Life Cycle (SDLC) which includes Requirements, Analysis, Design, implementation, integration, testing and deployment in Waterfall & Agile Methodologies.
• Exposure and expertise in Microsoft Business Intelligence tools like SQL Server Integration Services and SQL Server Reporting Services.
• Experience in creating Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Proficiency at Data Transformations, Tasks, Containers, Sources and Destinations to load data into OLAP Data Base.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task, and Data Flow Task.
• Extensively used Derive Column, Row Count, Data Conversion, Conditional Split and Aggregate.
• Expert in handling parameterized reports in SSRS 2012.
• Wrote stored procedure for reports using SQL Server Reporting Services (SSRS).
• Experience in creating Sub Reports, Tabular Reports, Matrix Reports, Drill down Reports and Charts, using SQL Server Reporting Services (SSRS).
• Ability to create table-valued functions on SSRS reporting services.
• Good exposure to Software Development Life Cycle.
• Excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS

Microsoft Technologies: ASP.NET, C#.NET, ADO.NET, VB.NET, MVC

Languages: C, C++, Core Java

Database Technologies: MS SQL Server 2012/2008/2005/2000 , MS Access, Oracle

ETL Tools: MS SSIS

BI Tools: MS SSAS, MS SSRS

Scripting languages: Java Script, knockout, jQuery, Angular

IDE: MS Visual Studio 2015/ 2010/2008/2005

Operating Systems: Windows 95/98/NT/2000/NT, XP, Vista, Windows 7.

Version Control: MS Visual Source Safe (VSS), Visual Studio TFS

Web Server: IIS

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Responsible for the development of enhancements, maintenance and support the Application.
• Used MVC4.0 frameworks and Developed a solution using Restful web services using web api to get data from, different application.
• Involved in Code maintenance through TFS. Was responsible in maintaining branches of code from Dev to QA to Stage to production.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations.
• Created snapshot process to snapshot data periodically.
• Created complex Stored Procedures, Functions, tables, and views and other SQL joins and statements for application.
• Identified the database tables for defining the queries for the reports.
• Defined report layouts for formatting the report design as per the need.
• Identified and defined the Datasets for report generation.
• Wrote queries for drill down reports to get the dataset required to build the report.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Meet with business analysts and understand the business challenges and design solutions.

Environment: MS Visual Studio 2012/2015, Knockout, MS SQL Server 2012/2008R2, SSIS, SSRS, Red Gate SQL Search, Red Gate Data Compare, TFS.

Confidential

Responsibilities:

• Responsible for assisting with the development, maintenance and application.
• Write quality code as part of development team.
• Developed Windows Forms using C#, ASP.NET with Visual Studio .NET.
• Used back end database Microsoft SQL Server.
• Involved in writing various Stored Procedures and Functions in SQL Server to update and display data.
• Developed Reports using SSRS.

Environment: ASP.NET, C#, MS Visual Studio 2010/2008/2005 , Java script, MS SQL Server2012/2008, SSRS.

Confidential

Responsibilities:

• Responsible for assisting with the development of enhancements, maintenance and support of The Concourse Manager (CCM) and its related applications.
• Meet with business analysts and understand the business challenges and design solutions.
• Write quality code as part of development team.
• Played a main role in the Client Builds. Provided 24/7 production support for the CCM application.
• Document code by creating flow diagrams.
• Developed Windows Forms using C#, ASP.NET with Visual Studio .NET.
• Used back end database Microsoft SQL Server.
• Involved in writing various Stored Procedures and Functions in SQL Server to update and display data.
• Developed Reports using SSRS.

Environment: ASP.NET, C#, MS Visual Studio 2008/2005, MS SQL Server2012/2008, SSRS, SQL Search, Red Gate, TFS.

Confidential

Responsibilities:

• Developed Web Forms using C#, ASP.NET with Visual Studio .NET.
• Used back end database Microsoft SQL Server 2008.
• Validated user inputs using JavaScript & using ASP.NET Validation Controls.
• Developed Reports using SSRS.
• Used Cascading Style Sheets for a unified look and feel of the application.
• Involved in writing various Stored Procedures and Triggers in SQL Server to update and display data.
• ADO.NET components such as DataSet, DataReader, and DataAdapter are used to access data.
• Made use of DataGrid and DataList Controls to display data in a customized format for ASP.NET Web forms.

Environment: ASP.NET, C#, Visual Studio .NET, ADO.NET, MS SQL Server 2008, Java Script, SSIS, SSRS.

Confidential

Software Engineer

Responsibilities:

• Created packages in SSIS Designer using Control Flow and Data Flow transformations to implement business rules.
• Created the mappings using Data Flow transformations such as the Derived Column, Conditional Split, Pivot, Lookup and Script Component etc.
• Used Control Flow elements like For Each loop and Sequence container, Execute SQL Task, Execute Process Task, Execute Package Task and Script Task, File System Task.
• Implemented the Master/Child Packages model so that only the master package has to be scheduled which will in turn fire the other packages.
• Extensively used Derived Column, Row Count, Data Conversion, Conditional Split and Aggregate.
• Scheduling and Monitoring the ETL Packages for daily load in SQL Server job Agent.
• Created Drilldown Report so that analysis can be done from top to bottom.
• Converted the Reports into PDF format.
• Delivered the Reports to the end users.

Environment: SQL Server Integration Service, SQL Server Reporting Service, SQL Server 2005, ASP.NET, C#, Microsoft .Net framework, MS Excel, MS Access, Oracle.

Confidential

Responsibilities:

• Created Web forms using ASP.NET and C# in Microsoft .NET Framework.
• Used SQL Server 2005 as back end database.
• Utilized Form Based Authentication for application security using C#.
• Implemented Client and Server Side Validations using ASP.NET and JavaScript.
• Managed application appearance using Cascading Style sheets for ASP.NET Web forms.
• Created and reused various Web User Controls for front-end Web forms using ASP.NET and C#.
• Extensive use of DataTables and DataRelation Objects using ADO.NET.
• Made use of DataGrid control for paging and sorting of data in ASP.NET Web forms.
• Involved in Unit Testing for developed ASP.NET Web applications.

Environment: ASP.NET, C#, Microsoft .Net framework, ADO.NET, MS SQL Server 2005, Java Script, HTML/DHTML, CSS.

Confidential

Responsibilities:

• Understood the existing system and developed the system accordingly.
• Involved in Design, Development and Testing of Windows Forms.
• Involved in designing the Advertisement Scheduler module using C#.
• Used Cascading Style Sheet for developing the look and feel.
• Developed a Navigation Menu using C#.
• Used MS SQL Server 2005 as the database and ADO.NET for database connectivity.
• Created Stored Procedures and Triggers using MS SQL Server 2005.

Environment: C#.NET, ADO.NET, MS SQL Server 2005, Microsoft .Net framework, Windows XP.

Confidential

Responsibilities:

• Designed and Developed application modules using C#.
• Used OOP concept in programming.
• Used MS SQL Server 2000 as backend database.
• ADO.NET was used to access data from MS SQL Server 2000.
• Created Stored Procedures in MS SQL Server 2000 to display and update database.
• Used ADO.NET components like Data Adapter, Data Reader and Dataset.

Environment: C#.NET, ADO.NET, MS SQL Server 2000, Microsoft .Net framework, Windows XP.