SUMMARY

• 6+ years of experience in the area of Software Design and Development.
• Professional experience in analysis, design and implementation of Web based and Client - Server applications, Web Services in Microsoft Technologies using ASP.NET, C#, MS Enterprise Library, VB.NET, ADO.NET, XML, HTML, Cascading Style sheets (CSS), JavaScript, Visual Studio.NET (2003, 2005 & 2010),Team Foundation server.
• Expert in SQL data architecture design.
• Experience in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, user defined data types and functions.
• Experience in ETL Technologies.
• Implemented the Authentication and authorization in ASP.net
• Involved in the SQL Server 2000 to SQL Server 2005 Migration.
• Involved in the Sybase to SQL Server 2008 Migration.
• Developed reports using Crystal Reports.
• Developed UI using Infragistics and Dashboard Reports using Crystal Xcelsius.
• Fixed the High priority Issues with quick turnaround time and Handled the Production outages
• Expert in SDLC process: Analysis, Design, Architect, Development, Deployment, Maintenance and Testing.
• Experience in SQL Server Migration and Migration of DTS Packages to SSIS.
• Experience in creating Jobs, Sending Alerts using SQL Mail. Used Microsoft Source Safe for version control and configuration management.
• Experience in Creating Window application using WPF.
• Developed Application using LINQ, MVC, JQuery, MVVM, and WCF.
• Strong communication skills and ability to work in a team and individually.
• Self-motivated, excellent communication, analytical, interpersonal, presentation skills, ability to meet deadlines.
• Designed and Developed SSIS for data Exchange and Integration.
• Designed and Developed Reports using SSRS and crystal Reports.
• Maintained the ASP applications.

TECHNICAL SKILLS

Language: C#.net, VB.Net, Java Script, JQuery, T-SQL, ADO.net, C, C++, and familiar with UNIX and PowerBuilder

Web Tools: Asp.net, Web Services, HTML, XML, CSS

Frameworks: .Net Framework 4.0, 3.5, 3.0, 2.0 & 1.1, Visual Studio 2003, 2005 & 2010

Middleware: ADO.Net and Web Service (SOAP)

Relational Database: MS SQL Server 2000-2008, and MS Access

Reporting Tools: Crystal Reports and SQL Reporting Services

Version Control Tools: Visual Source Safe 2005(VSS) and TFS

Third Party Tools: Replicate1 (Double Take), Infragistics, Crystal Xcelsius, Aspose

Database Tools: SSIS and SSAS, Query Analyzer, Profiler.

PROFESSIONAL EXPERIENCE

Confidential, Fremont, CA

Senior Software Engineer

Responsibilities:

• Created/Modified Store procedure/Triggers/SSIS packages for batch jobs.
• Have made design changes across the application, based on new requirements.
• Created the Check Sum Tool using C#.
• Rewrote the existing complex procedures/triggers to improve the performance.
• Implemented NDM tool for secure file transfer.
• Have interacted with customer for requirement collection and clarity.

Environment: SQLServer 2008, C#, Visual Studio.NET 2010, Net Framework 4.0, T-SQL, Tuning Advisor, SQL Profiler, Visual Source Safe, LINQ.

Confidential, Los Angeles, CA

Responsibilities:

• Have interacted with customer for requirement collection and clarity.
• Developed a new Windows using WPF, WCF, LINQ and MVVM.
• Prepare migration plan and steps.
• Consolidating the issues given by SSMA report.
• Identifying the issues which are not reported by the tool.
• Fixing Joins and other format oriented syntaxes used in Sybase to SQL.
• Prepared separate plan for the UDT (User defined Types).
• Filled the gaps caused by the functional differences between the Sybase and SQL in-built functions.
• Converted many stored procedures from old cursor statements to SET based statements
• Have made design changes across the application, based on new requirements.
• Rewrote the existing complex procedures/triggers to improve the performance.
• Involved in the Sybase to SQLServer Migration.
• Tuned quires and batches to avoid frequent deadlocks
• Used Visual Source Safe (VSS) for software code management.
• Created New Store procedure/Triggers/SSIS packages for batch jobs.
• Designed and Developed Reports using SSRS.
• Handled the five member team.

Environment: SQLServer 2008, Sybase, PowerBuilder, C#, Visual Studio.NET 2010, WPF, .Net Framework 4.0, Replicate1 (Double Take)., T-SQL, Tuning Advisor, SQL Profiler, Visual Source Safe, LINQ, MVVM.

Confidential, Englewood Cliffs, NJ

System Analyst

Responsibilities:

• Created new Module For de-Authorization process, Marketing Activities which includes creating new ASP.net web page, store procedure.
• Performance tuning was successfully completed using the tool Execution Plan (SSMS).
• Implemented the Authentication and authorization in ASP.net
• Used infragistics Control for displaying and manipulating the data.
• Designed and Developed Reports using Crystal Reports.
• Tuned quires and batches to avoid frequent deadlocks
• Have interacted with customer for requirement collection and clarity.
• Rewrote the existing complex procedures/triggers to improve the performance.
• Created the Reports using Crystal Reports.
• Implemented Dashboard using Crystal Xcelsius.
• Used Visual Source Safe (VSS) for software code management.
• Created New Store procedure/Triggers/SSIS packages for batch jobs.
• Implemented ETL to import the data from different Application.
• Implemented the interface between AST and other application.
• Have made design changes across the application, based on new requirements.
• Handled the five member team.
• Maintained the ASP application.

Environment: SQLServer 2005,VB.NET, Visual Studio.NET 2003, Net Framework 1.1, Net Framework 2.0, Crystal Reports, Infragistics, Aspose, SQLServer 2000,Web Services, JavaScript, VSS,IIS, AJAX,HTML,CSS

Confidential, Englewood Cliffs, NJ

System Analyst

Responsibilities:

• Development and Drafting the Integration plan.
• Design and development of Tables
• Have made design changes across the application, based on new requirements.
• Handled the three member team.
• Handled the deployments
• Fixed the defects.

Environment: SQLServer 2005, VB.Net, Visual Studio.NET 2003, Net Framework 1.1, Net Framework 2.0, Crystal Reports JavaScript, VSS, Oracle, IIS, AJAX

Confidential

Senior Software Engineer

Responsibilities:

• Developing the SP’S for the reports.
• Enhancements & Development
• Handling Application quires requested by client.
• Understanding Business changes and updating the process procedures.
• Have made design changes across the application, based on new requirements.
• Debugging and Analyzing Stored procedures, views, triggers, T-SQL and DTS
• Have made coding pages using VB.NET and ASP.NET.
• Have involved in client support.
• Used Visual Source Safe (VSS) for software code management.
• Performance tuning was successfully completed using the tool Execution Plan (SSMS).
• Created Unit test cases.
• Error handling and Exception handling across application.
• Bug-fixing & preliminary testing

Environment: SQLServer 2000,C#, Visual Studio.NET 2003, Net Framework 1.1, Crystal Reports JavaScript, VSS,Webservices,VB.Net