SUMMARY

• 6 years of experience in Designing, Coding, Testing and supporting Enterprise class end user application especially web applications.
• Good experience in development of SSIS, SSRS, Stored Procedures, Functions, Triggers, Cursors, Views, Joins and SQL queries.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Knowledge and experiences in designing, developing and deploying Reports.
• Experience in creating reports by using Report Builder in SSRS.
• Proficient in ETL processes for Data Conversion using Integration Services (SSIS).
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handler to fix the errors.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like MS SQL Server 2000, XML and Flat file to Microsoft SQL Server by using SSIS .
• Experience in creating Console Application to send mobile text messages using Visual Studio 2010, C# and FTPWebRequest, HttpWebRequest objects.
• Excellent problem solving and analysis skills
• Experience as a developer in SharePoint Services.
• Good experience in developing application using N tier - Architecture.
• Experience in designing, developing and consumption of WCF services using C#.
• Good experience in developing data access layer using ADO.NET objects like Connection, Dataset, Data Adapter, Data Reader, Command, Data Table and Data Relation objects.
• Good experience in developing MS Excel documents using Application, WorkBook, Range and FTPWebRequest objects.
• Good experience in the development of .RDLC Reports and integration with web application for easier user accessibility.
• Good experience in using configuration tools like Visual Source safe.
• Good in effort estimation, code reviews and tracking and managing QA defects and process.
• Self-Motivated with good verbal and written communication skills.
• Good in mentoring and guiding junior team members.
• Excellent problem solving and analytical skills.

TECHNICAL SKILLS

Programming: ASP.net, ADO.net, C#, WCF, Web Servies

Database: MS SQL Server 2008, Microsoft Access

Database Tools: Sql Agent

Web Server: IIS 7.5

Reporting Tools: SQL Server Reporting Services (2008 and 2005), Crystal Reports, SSIS

Other Tools: Microsoft Visual Studio 2010,Visual Source Safe, Microsoft Office

Server: Share point 2010

Operating Systems: Windows Xp, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Software Developer

Responsibilities:

• Developed Web page using ASP.NET controls like GridView, RepeaterControl, ListBox and Ajax controls like FilterTextBoxExtender, AuutoCompleteExtender and Accordion Pane
• Reposonsible for creating .NET application which consumes WCF web services.
• Built SSIS package to perform extraction, transformation and load (ETL), the data into sql server .
• Built the SSIS package to e-mail the generated SSRS reports in PDF format to business users.
• Generated reports in various formats like Table and Matrix using Reporting services (SSRS 2008).
• Experience in bulding and deploying SSRS Report Models with the help of Visual Studio 2008.
• Wrote business logic code in Class Library files to read data from database stored procedures.
• Developed the data access layer class using C# which is reusable for data transactions of entire project. Extensively used ADO.NET objects like Dataset, Data Adapter, Data Reader, Command, Data Table and Data Relation objects.
• Wrote Stored Procedures, Triggers, Functions and Views, Joins,Cursor for business logic implementation.
• Deployment of Web application on IIS server.
• Used dataset, data reader, data view to read data using ADO.Net objects.
• Web Form design and coding using Master Pages, Server controls, Cascading Style sheet, JavaScript, HTML
• Wrote business logic code in C# code behind files to read data from database stored procedures.
• Used C# and ADO.NET to define and implement secure middle-tier components using both connected and disconnected environment strategies.
• Designed and developed the database and wrote stored procedures for SQL Server 2005.
• Update ASP.NET Pages, UserControls, C# Classes, SQL Databases, CSS, and JavaScript.
• Was responsible for managing project documentation and for Visual Source Safe administration
• Responsible for Unit testing.

Environment: SSRS,SSIS,Visual Studio Professional 2010,.NET Framework 4.0, SQL Server 2008, ASP.NET, C#,ADO.NET,VSS

Confidential -Perth Amboy, NJ

Sr Software Developer

Roles and Responsibilities

• Responsible for creating stored procedures to pair down the databases.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS 2005/2008).
• Involved in designingTabular Reportsand alsoCascaded Parameterized Reports (SSRS)
• Involved in migration of reports from SSRS 2005 to 2008.
• Experience in deploying the SSRS reports to Development Server
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
• Involved in designing and Developent of services using Web Services
• Built WCF web services and consuming them in web application.
• Requirement Analysis and design of Web pages using ASP.net.
• Developed application using 3-tier architecture (i.e.Design Layer, Business Access Layer and Data Acces layer)
• Wrote code to establish Database connections in Data Access Layer.
• Developed the data access layer class using C# which is reusable for data transactions of entire project. Extensively used ADO.NET objects like Dataset, Data Adapter, Data Reader, Command, Data Table and Data Relation objects
• Wrote business logic Code in Bussiness Access layer.
• Wrote Stored Procedures, Triggers for business logic implementation.
• Install and deployment of Web application on IIS server.
• Used dataset, data reader, data view to read data using ADO.Net objects.
• Web Form design and coding using Master Pages, Server controls, Cascading Style sheet, JavaScript, HTML
• Used AutocompleteExtender to display autopopup Ids uing Webservices.
• Update ASP.NET Pages, C# Classes, SQL Databases, CSS, and JavaScript.
• Was responsible for managing project documentation and for Visual Source Safe administration
• Responsible for Unit testing.

Environment: Visual Studio Professional 2010.NET Framework 3, SQL Server 2008 ASP.NET, C#,CSS,HTML,ADO.NET,VSS

Confidential

Software Developer

Roles and Responsibilities:

• Design Database using Entity Relation and created on MS sql server 2005.
• Anaylsed the number of User Interface Pages in this Application.
• Developed in 3-tier architecture using Design Layer, Business Access Layer, Data Acces layer
• Established Database connections in Data Access Layer.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on a daily basis.
• Provided documentation for all kinds of reports, SSIS packages.
• Developed the data access layer class using C# which is reusable for data transactions of entire project. Extensively used ADO.NET objects like Dataset, Data Adapter, Data Reader, Command, Data Table and Data Relation objects
• Wrote business logic Code in Business Access layer.
• Wrote Stored Procedures, Triggers for business logic implementation.
• Generated Crystal reports version 13.0
• Install and configure IIS and deployment of Web application on IIS server.
• Used dataset, data reader, data view to read data using ADO.Net objects.
• Web Form design and coding using Master Pages, Server controls, Cascading Style sheet, JavaScript, HTML
• Update ASP.NET Pages, C# Classes, SQL Databases, CSS, and JavaScript.
• Was responsible for managing project documentation and for Visual Source Safe administration
• Responsible for Unit testing.

Environment: Visual Studio Professional 2010.NET Framework 3.5, SQL Server 2008 ASP.NET, C#,CSS,HTML,ADO.NET,VSS