SUMMARY

• Motivated and ambitious Senior Database/.NET Developer experience delivering cost savings and productivity improvements for Center for Disease Control - Confidential, Confidential, Confidential LLC and Confidential software Development.
• Participated in a wide range of projects with advance experience in Database Development utilizing SQL Server Management Studio 2005/2008/2012 and Visual Studio 2005/2008/2010 , SSIS, SSRS, UML modeling, C#, ASP.NET XML and HTML.
• Demonstrate vast technical skill set with Masters in Computer Science and UML Business Analysis certification.
• Continuously grow knowledge through independent study and projects across technologies.

TECHNICAL SKILLS:

Languages: C#, Java

IDE & BI Tools: SQL Server BI Development Studio (BIDS), MS Visual Studio 2010/2008/2005

Web Technologies: .NET Framework, ASP.NET, HTML, Xml, AJAX, Java Script, IIS,MVC.

Databases: MS SQL Server 2005/2008/R2/2012,MYSQL, MS Access, MS Excel

Data Modeling & Data Access Tools: Rational Rose, ADO.NET

Version Control: SVN, Team Foundation Server (TFS)

Operating Systems: Windows 2003/2008 Server/XP/Vista/windows7/8

PROFESSIONAL EXPERIENCE

Confidential, Hyattsville, MD

Senior .NET /Database Developer

Responsibilities:

• Developed an intranet search engine using Visual Studio 2010(ASP.NET, C#).
• CreatedTables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database ModelsandData Integrityin observing Business Rules.
• Produced several complicated reports such asdrill down reports, parameterized reports, sub reports, usingSQL Server Reporting Services.
• Worked on SQLServer Analysis Services (SSAS) for designing OLAP Cubes.
• Developed manyMDXqueries for creatingcalculated measuresthat fits business logic.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Maintained front end web site using ASP.NET, C# and JavaScript as a back end.
• Fine-tuned database objects and server to ensure efficient data retrieval.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.

Confidential - Washington D.C.

SQL /.NET Developer

Responsibilities:

• Participated as part of application Development team and Developed financial analysis (programming) forecasting windows application using .NET 4.0(C #).
• Implemented the business logic following the OOP principles.
• Designed and implemented user friendly User Interface for the application using windows forms.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Created The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
• Involved in the preparation of user manual and different artifacts.
• Implemented test classes and re-factoring.

Confidential, Springfield VA

Application Developer

Responsibilities:

• Developed CMS application using .NET 2.0, Master Pages, ASP.NET AJAX, Java script, XML,CSS, and HTML tools
• Identified and defined the Datasets for report generation and also included report parameters.
• Have written several stored procedures and Triggers as per the client requirements.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Maintained legacy website in order to make it useable for the client’s immediate needs.
• Developed very dynamic and interactive components for the system using an open source like MPXJ to make it very attractive for users view.
• Created presentation layer logic using flash, which provided user-friendly interface for the end users.
• Designed and developed Test cases.

Confidential

SQL /.NET Developer

Responsibilities:

• Developed test plans/cases and actively tested source codes. Participated in system integration, business logic programming, SQL queries, and interactive user interfaces.
• Cut project expenses while improving productivity, creating reusable and easily-maintained systems via UML Modeling, Normalization, De-normalization and Design Patterns.
• Delivered projects on schedule through comprehensive unit, integration, and system testing initiatives.
• Served as key team member in many projects developing User Interface design and utilizing Macromedia Dreamweaver, Fireworks and Flash, HTML, CSS, JavaScript, SQL Server and PHP.
• Contributed to Full Software Development Life Cycle including business analysis, requirements, modeling, class diagrams and design patterns.
• Designed critical components including UML Class Diagram/Design Pattern-based subsystems, back-end database.
• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and optimized all the SSIS packages.
• Created presentation layer logic using Window Forms, which provided user-friendly interface for the end users.
• Launched interactive web-based data system utilizing ASP.NET, C#, Master Pages, ASP.NET AJAX, ADO.NET, XML, CSS, Visual Studio, SQL Server 2005, and HTML tools.
• Maintained and provided system support which helped to improve quality and productivity.
• Documented artifacts in detail, which enabled easy maintenance and troubleshooting.
• Provided customer support, which gave the end user to gain the most out of the new system.

Confidential

SQL Server Programmer

Responsibilities:

• Gathered requirements and produced requirement specification document.
• Analyzed requirements using use-cases and created use-case models, sequence diagrams and communication diagrams using Rational Rose tool, which enabled a clear understanding of the system
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Designed new job process, new database maintenance plans and DTS packages.
• Participated in business logic and data access layer using C# and ADO.NET, which provided a reliable, reusable and easily maintainable communication between the two layers.
• Implemented user-friendly Windows Forms, which helped the user to interact with the system very easily.
• Documented artifacts in detail, which enabled easy maintenance and/or troubleshooting in the future.