SUMMARY

• Over Six years of experience in developing distributed applications leveraging C#, ASP.NET, HTML, Web Services, Windows Services, SQL Server, Oracle, HTML, XML and Java Script.
• Well versed with all phases of the Software Development Life Cycle.
• Proficient with Object Oriented Analysis and Design (OOAD).
• Experience with Service Oriented Architecture (SOA) implementing Web Services: SOAP & SOAP Extensions, and WCF: Hosting, Debugging, Tracing, Transactions, and Security.
• Experience developing rich GUI using Windows Presentation Foundation (WPF) and good working knowledge of Silverlight.
• Employed object oriented concepts like Data Abstraction, Inheritance, Data Encapsulation, Polymorphism using C#.Net.
• Experience with the Object Relational Mapping (ORM) using LINQ.
• Working knowledge of ASP.NET MVC pattern: Controller Actions, View Engine, HTML Helper methods, Entity Framework Model and the Windows Workflow Foundation.
• Solid experience in Database design and programming: writing Stored Procedures, Functions, Triggers, Views, Joins, performing Query Optimization and Performance Tuning.
• Expertise with reporting using SQL Server Reporting Services (SSRS), Power BI & Tableau.
• Expertise with various SQL Server Integration Services (SSIS) tasks such as Control Flow (Execute SQL task, For each loop Containers, Data Flow task, File System etc) and transformations such as Aggregate, Data Conversion, Union All, Merge, Sort, Lookup, Merge join, Multicast, Conditional split, Derived column etc.
• Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, table, index, etc.), space management, and monitoring.
• Involved in Normalization of Data, Creation of Dimensions using Star and Snowflake Schema.
• Experience in Creating Data Mart.
• Good Experience in understanding Data Warehousing concepts.
• Knowledge on Microsoft Excel, Pivot table
• Experience in creating tables using Microsoft Excel
• Strong knowledge of Design Patterns, and the UML methodology.

TECHNICAL SKILLS

Languages: C#, C, C++, PL/SQL, Transact - SQL, XML, XSLT

Web Technologies: ASP.NET, Silverlight, AJAX, JQuery, Java Script, HTML, CSS

Distributed Technologies: .NET Remoting, WCF, Web Services (SOAP, REST), LINQ

Databases: SQL Server 2000/2005/2008, Oracle 9i/10g, MS Access

Reporting Tools: SQL Server Reporting Services, Crystal Reports 9.0

Testing Tools: NUnit, Visual Studio Team System

Version Control: Visual Source Safe(VSS), Team Foundation Server(TFS)

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

.Net / SSRS Developer

Responsibilities:

• Involved in designing Architecture of various modules depending on user requirements and using the latest trends in technology.
• Developed various Web parts and Apps, using ASP.NET
• Used Web Parts and User Controls to develop some of the modular driven aspects of the Web Site.
• Involved in the Iterative process of development in agile methodologies.
• Working with Google Maps, Face Book Connect and other API.
• Developed SSIS packages and Deployed using Integration Services Catalog.
• Development of tabular and matrix reports in SSRS.
• Deployed Packages and Reports to web server.
• Development of UI using C#,ASP.NETand JS.
• Extensively used ASP.NET built in AJAX and other JavaScript method to do “Asynchronous Post Back Calls”
• Extensively used Web Services, WCF, SOAP and XML.
• Used Data Repeaters, Data List, Login Controls and several other ASP.NET Controls.
• Created and Modified several existing Class Libraries and API source Codes in C# to fit the custom functionalities depending on various needs.

Environment: MS Visual Studio 2010, ASP.NET 3.5, C#.Net and VB.net, SQL SERVER 2012, SSRS, SSIS, CSS, XML, Power BI

Confidential, Dearborn, MI

.Net Programmer/Web Developer

Responsibilities:

• Analysis, Design & Development of the Architecture.
• Developed Components for all business logic in C#.
• Designed the application using MVC architecture that promotes a clear separation of the presentation, business logic and data access layers.
• Reusing Existing COM Components from .NET framework, User Controls and Classes.
• Written Stored Procedures in SQL Server 2005 used ADO.Net and Data grid for data manipulation.
• Designed and developed ASP.NET User Controls.
• Involved in SSIS Transformations and Tasks
• Generated Drill down, Drill through, Parameterized and Cascading Parameterized Reports
• Made use of concepts like Assembly Loading and Reflection, Threading, Exception Handling and COM Interoperability to make the application more efficient.
• Used ASP.NET Validations for validating the personal information provided by the Customer.
• File Streams were used for reading XML data and Schema Validators were used for validating XML data against Schema.
• File Streams with the private information is saved on the database using the concept of Serialization for security.
• Designed and Created new SQL Server Tables as per requirements.
• File Streams with the private information is saved on the database using the concept of Serialization for security.

Environment: IIS, SQL Server 2008, MS Excel, Visual Studio.NET, ASP.NET, C#, ASP.NET, Microsoft .Net Framework, XML, SSRS, SSAS.

Confidential, Atlanta, GA

Web Developer

Responsibilities:

• Studied and analyzed the business requirements and transformed them into system inputs.
• Designed and developed excellent, user friendly Win Forms using ASP.NET for Investor data collection.
• Developed the data layer module using C# which is reusable for data transactions of entire project. In this module extensively used ADO.NET objects like Dataset, DataAdapter, Data Reader, Command, DataTable and DataRelation objects.
• Developed business logic using C#, used the developed data layer module extensively for database related transactions.
• Designed and developed various complex reports using Power BI and gave option to export to excel and .PDF files.
• Developed the necessary stored procedures and created complex views using joins for robust and fast retrieval of data.
• Designed and developed excellent, user friendly Win Forms using C# for Investor data collection.
• Used ASP.NET, JavaScript, IIS, HTML, and CSS for developing Web pages.
• Developed the data layer class using C# which is reusable for data transactions of entire project. In this class extensively used ADO.NET objects like Dataset, DataAdapter, DataReader, Command, DataTable and DataRelation objects.

Environment: Windows 2000, .Net Framework 1.1, ASP.NET Win Forms, C# ADO.NET, Visual Studio.Net IDE, Power BI, Visio 2002 and SQL Server 2005.

Confidential

Developer/ Analyst

Responsibilities:

• User interface was totally designed using Web Server Controls
• Developed Web forms using ASP.NET server controls and validated input using Java Script.
• Designed and Developed Windows Services for polling MSMQ and Update SQL Server 2000.
• Developed XML Web Services to communication with SQL Server 2000.
• Used ADO.NET objects such as DataAdapter, DataReader and Dataset for consistent data access.
• Developed the code using C# according to the coding standards.
• Designed and created database tables, stored procedures, triggers and views using SQL Server 2000.
• Tested the product feature before and after integration using NUnit.
• Code review and documentation for the feature.
• Generated SSAS Cubes.
• Involved in Normalization of data and Development of star and snow flake schema
• Developed the web service to make available the SiteMan data to other systems of AT&T
• Implemented search of building data, lease information, path information, Engineering projects
• Designed search results control to pull data from database and display in Data Grid.
• Involved in Middle Tier development
• Developed the User Control in C#.NET
• Used DATA access technologies (SQL Data Provider / ADO.NET)
• Also for data validations used Validation controls in C#.NET & Java script
• Designed a generic data access component to execute Stored Procedure and SQL. statements from the Business Layer

Environment: ASP.NET, HTML, Web Services, Windows Services, SOAP, C#.NET, Visual Studio.NET, ADO .NET, .NET Framework, MS SQL Server, SSRS, SSAS, JavaScript.