SUMMARY

• Over Six years of IT experience in N - Tier Client / Server and Web based application development for finance, education and telecom domain.
• Involved in all phases of SDLC including Requirement Analysis based on extensive Client Interaction, Application Design and Development, Quality Control / Analysis, Implementation and user training.
• Extensive experience in Microsoft technologies including ASP.net, MVC, C#.net, ADO.net, SQL, T-SQL, JavaScript, HTML, Oracle 9i, SQL Server 2005 / 2008, Crystal Reports, AJAX, jQuery, CSS, XML, IIS and WCF.
• Development experience in an Agile (Scrum) environment.
• Experience in database design, creating tables, views, relationships, indexes and normalization of tables.
• Experience in writing complex SQL queries for reports, stored procedures, functions and database triggers for SQL Server 2005 / 2008 and Oracle.
• Experience in developing reports using SQL Server Reporting Services.
• Involved in all phases of testing activities such as unit testing, system testing, integration testing and user acceptance testing.
• Experience in creating web forms, user controls and custom web controls using HTML, JavaScript, C # and Asp.Net.
• Proficient in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Expertise in analysing the performance issues, identifying software bottlenecks, troubleshooting and solving problems related to production environment.
• Excellent team player with strong analytical, problem solving, interpersonal skills and quick learning abilities.
• Expertise in creating Sprints, user stories, tasks, bugs and impediments using scrum.
• Capable of working independently with minimal supervision.
• Strong interpersonal and communication skills with the ability to interact effectively with others and set a positive example.

TECHNICAL SKILLS

• Windows Server 2003 / 2008
• Windows XP / Windows 7 client
• ASP.net
• MVC
• C#.net
• ADO.net
• SQL
• T-SQL
• PL / SQL
• WCF
• Web Services
• Windows Services
• HTML
• JavaScript jQuery
• AJAX
• XML
• XSL
• XSLT
• CSS
• SQL Server 2005 / 2008
• Oracle 8i / 9i
• MS Access
• Visual Studio 2005 / 2008 / 2012
• SQL Developer
• Visual Source Safe
• TFS
• Tortoise SVN scrum
• Jira
• SSRS
• SSIS
• IIS

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Programmer Analyst

Responsibilities:

• Responsible for functional requirements, design, development, and testing.
• Analyzed, designed and implemented the form control components like MVC controls, data binding controls, action events, logging and exception handling.
• Design and development of web pages using MVC, HTML, C#.net and jQuery.
• Used JQuery and JQuery UI for various types of form validations.
• Used fluent nHibernate to create Entity Models.
• Implemented Autofac for Dependency Injection (DI).
• Extensively used firebug for debugging JavaScript and jQuery.
• Implemented LINQ to perform simple database operations.
• Designed various database tables, relationships and Indexes.
• Responsible for writing complex SQL queries for reports, stored procedures and functions.
• Created SSIS packages to load data into Staging Tables using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, and xml task.
• Created various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Experience in creating user stories, tasks, impediments using scrum.(JIRA)
• Experience with automated testing (TDD, Mocking, Unit/Functional/Integration).
• Worked with testing team to ensure that the development issues are resolved.

Confidential, Jersey City, NJ

Programmer Analyst

Responsibilities:

• Analyze business requirements, perform systems analysis in order to provide estimates and split the project into small, workable units.
• Develope enhancements and features for the organization’s web-based software utilizing my skills in ASP.NET, C#, SQL Server, JavaScript, XML and HTML.
• Assist in theperformanceoptimization of the application by utilizing code profiling techniques and databaseperformancetuning.
• Write Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Problem identification, troubleshooting, resolution, and index tuning databases.

Confidential, Brooklyn, NY

Programmer Analyst

Responsibilities:

• Development of the application using n-tier distributed architecture.
• Developed software solutions by studying information needs; conferring with users; studying systems flow, data usage, and work processes; investigating problem areas; following the software development lifecycle.
• Outlining Project Standards and architecture to be followed for all the applications.
• Used ASP.NET Validation controls for validating user inputs.
• Setup of TFS folders for all the applications as source control tool for the applications.
• Experience in creating the DLLs to customize and developed user interface controls.
• Research and evaluate alternative technical solutions and recommend the most efficient and cost-effective solution.
• Unit testing using Visual Studio .Net testing tools.
• Understanding the existing application design and architecture.
• Developed stored procedures and triggers to implement Business Rules.
• Assist in theperformanceoptimization of the application by utilizing code profiling techniques and databaseperformancetuning.
• Involved in testing activities such as Unit Testing, and Integration Testing.
• Responsible for creating deployment packages for the production environment.
• Troubleshot and resolved bugs in .NET applications to ensure optimal development environment.

Confidential

Systems Engineer

Responsibilities:

• Developed from scratch an in-house web application for Approval of Rate Plans.
• Worked with functional analysts to deliver quality web applications while satisfying all client requests.
• Implement ADO.net to communicate with SQL Server using stored procedure to handle database operations.
• Develop custom database driven web applications in support of client business needs
• Worked directly with clients and project manager to define requirements
• Utilized ASP.NET & C# to build dynamic interfaces including advanced data search capabilities, dynamic menus built on security profiling and through the use of customized controls; I designed and programmed advanced functions to enable clients to perform their tasks more efficiently.
• Using SQL Server as the backend database, I designed and built the data infrastructure for each application I was responsible for - setting up table, indexes, stored procedures, functions and views. Utilized MS SQL Server capabilities whenever possible to keep IO to a minimum - maintain performance.
• Responsible for developing SQL queries for reports, Views and Stored Procedures.
• Research and evaluate alternative technical solutions and recommend the most efficient and cost- effective solution.
• Involved unit testing, integration testing and web test.
• Designing and maintaining reports using reporting services.
• Worked with testing team to ensure that the development issues are resolved.