SUMMARY:

• 5 Years of experience on Microsoft technologies like C#, ADO.Net, ASP.Net, SOA, XML, WCF,WPF, SSIS, SSRS, Web Services, ASP.Net MVC, and tools like Visual studio 10/12/15 and SQL Server Management Studio.
• Troubleshot and resolved bugs in .NET applications to ensure optimal development environment.
• Experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using T SQL.
• Strong in front-end GUI development using C#, jQuery, JavaScript and CSS.
• Strong knowledge of building World class UX in Expression Blend and WPF 4.0/3.0
• Experience in writing Components, Pipes and Services to separate concern and handle different situations by applying Angular 2/4.
• Power user of SQL queries with multi-table joins, group functions, sub-queries, set operations and functions
• Expert in creating indexes, views, complex triggers, effective functions and stored procedures to facilitate efficient data manipulation and data consistency.
• Extensive experience in using SQL Management Studio, SQL Server Business Intelligence Solutions like SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Service Package).
• Strong experience on completing data migration task by using ETL Tools especially SQL Server Integration Services (SSIS).
• Experience in Windows Azure Services like PaaS, IaaS and worked on storages like Blob (Page and Block), SQL Azure. Well experienced in deployment & configuration management and Virtualization
• Excellent working experience in building complex data flow task to integrate and transform data from different source types to a variety of destination types.
• Maintains and managed assigned systems, Splunk related issues and administrators
• Assisted internal users of Splunk in designing & maintaining production-quality dashboard, assisted offshore team to understand the use case of business and provided technical services to projects, user requests & data queries
• Experience in working with Aspose/Slides to generate the complex PDF and PPT (Deck)
• Used Aspose Excel and Aspose Word to dynamically create custom Reports with standard header and footer from shared library and good knowledge on add-in express
• Experience in using Jira as ticket tracking and work flow tool
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experience in Query Optimization, Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Well versed in Object Oriented Programming (OOP) using C#.
• Worked with Windows Communication Foundation (WCF), Windows Card Space (WCS), Windows Presentation Foundation (WPF) and Windows Workflow Foundation (WWF)
• Solid knowledge and experiences of Agile software development life cycle and project manage methodology.
• Experience in using JIRA, Confluence and Team Foundation Service (TFS) for team communication and sharing.
• Self-driven with ability to take initiatives and meet deadlines in a fast-paced changing environment.
• Strong analytic and communication skills with the enthusiasm to learn new technologies.

TECHNICAL SKILLS:

Languages: C, C++, SQL T-SQL, PL/SQL, VB.NET, C#.NET, ASP.Net, ADO.NET, WinForms, MVC 4.0,5,Powershell, Splunk, Python, COM/DCOM, COM+, Java

SQL SERVER Tools: SQL SERVER Management Studio, SSIS, SSRS, SSAS, SQL Profiler, Query Analyzer, Data Transformation Services, Business Intelligence Development Studio, Visual Studio, Import/Export Wizard

Databases: Microsoft SQL SERVER, MS Access, Oracle

Web Technologies: HTML, XHTML, JavaScript, jQuery, CSS, XML, Web API,AJAX, AngularJS

Cloud Platforms: AWS (certified associate developer), Azure

Tools: Word, Excel, PowerPoint, Access, Outlook, Jira, Power BI, Tableau, TFS, GIT, ReSharper, Aspose Word, Aspose Excel

PROFESSIONAL EXPERIENCE:

Confidential, BOWIE, MD

Application Developer

Responsibilities:

• Involved in Design, Development and testing of enhancements preparing the Test case document and Deployment activity.
• Consuming services in website using Web API with HTTPS.
• Using Web API for creating web services.
• Using Entity Framework 6 for database interaction with Repository.
• Used ASP.NET MVC Data annotations to enforce data validation.
• Wrote stored procedures with complex SQL queries and reports development.Review, analyze and examine issues in the Custom Web Service (QMIES Web Service)
• Responsible for coding/Unit Testing in the change request and production issues
• WCF is used for building connected, service-oriented SOA application.
• Created Guard Service in Angular 2 to prevent invalid routing address for a better security purpose
• Used Angular 2 ng model to achieve two-way binding and ngIf to display validation message and error message
• Developed loosely coupled application using WPF, C#, MVVM pattern, LINQ, dependency Injection Container Unity Container, NHibernate.
• Created tickets for deploying software patches and upgrades to servers using TSQL and PowerShell scripts
• Implemented Azure Storage, Azure SQL Azure Services and developing Azure Web role.
• Developed a PowerShell script to automate Active Directory and server tasks and generate reports for administrators and management
• Used Team Foundation Server (TFS) for version control.

Environment: QNXT, .Net Framework 4.6, ASP.Net MVC 5, C#, WPF,WCF, VB.NET, OOPS, LINQ, PowerShell, JSON,XML,Angular, Visual Studio 2015, SQL Server 2012, SSRS, SSIS, VB.NET, ReSharper and Windows 10, Jira, Oracle 11g

Confidential, Sacramento CA

.Net/SQL Application Developer

Responsibilities:

• Hands on experience in using asp.net Ajax, jQuery, Java Script and .NET controls like chart control.
• Involved in creating Software Requirement Specifications for the application.
• Implemented technical use cases by designing and developing the appropriate web pages using C# code - behind.
• Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.
• Developed scalable modular software packages for various APIs and applications.
• Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself and Worked on TFS for version control, Code Review and for automatic builds.
• Implemented Business layer using Windows Communication Foundation (WCF) and Involved in Design and Development of the User Interface using WPF, XAML, VS2010, Expression Blend
• Complex store procedure, store procedure optimizing, functions, views etcetera heavily used and developed.
• Implemented service-oriented component (SOA) Layer using C#.net and WCF to decouple the UI with BL
• Hands on experience with Azure blob storage, SQL Database, App deployment, User access rights, basic firewall and load balancing.
• Used Git with TFS for version control. Also, we were using VSTS for bug tracking.
• Used ADO.NET for retrieving data from back end database Oracle and Created multiple PowerShell scripts for both applications and for team to get critical server and database information quick.
• Worked in Visual Studio.NET, Visual Source Safe and Team foundation server environment.
• Developed REST API using Web API.
• Very good understanding of all the parts of Agile methodology like user stories, Scrum meetings, iteration etc.
• Responsible for writing the code in Microsoft Visual Studio.NET 2012 with ASP.NET using code behind C# and Implemented ng-repeat to display tabular data and utilized CRUD features such as sorting, filtering, paging and data manipulation and by using AngularJS.
• Complex store procedure, functions and views in SQL Server.
• Transferred all data into SQL Server from different data sources using SSIS/ETL.
• Developed link reports, sub reports, standalone reports with SSRS and integrated with ASP pages.
• Supporting the production support issues/deployment.

Environment: VisualStudio2013, C#, ASP.NET MVC 4.5/4.0, Agile, WCF, Java Script, TSQL, PowerShell, jQuery, XAML, TFS 2010, WPF, VB.NET, WCF REST, JSON, SOAP, IIS 7.0, AJAX, ADO.NET, LINQ, XML, Microsoft Enterprise Library, SQL Server Integration Services, N-Unit, SQL Server 2012 R2, Windows Server 20012 R2/2008, SSRS, SSIS. CSS, HTML, Ajax Extension, Oracle10g

Confidential

.Net /Application Developer

Responsibilities:

• Created Web Application using .NET, SQL Server with Active Directory login.
• Responsible for Development team interaction and understanding the documents written by the business analyst.
• Involved with designing databases for better performance and automatic indexing daily.
• Developed T-SQL queries, triggers, functions, cursors and stored procedures.
• Created the SQL scripts and Stored Procedures required for the SQL Server Reporting Services.
• Worked on SQL Server Integration Services for scheduled movement of data between systems and SQL Server Reporting Services report creation and maintenance.
• Customized data model creation including tables, views, and indexes.
• Developed DTS/SSIS packages to extract and transform data. Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and developed front-end screens using Java Script, AJAX, CSS, and HTML and implemented Web Forms with XML, HTML5, CSS/CSS3, JavaScript, AJAX, and jQuery and Angular.js
• Created XML configuration file to display demonstration scenarios.
• Built XML Work Orders for use with SOAP ordering interface to replay problematic orders.
• Participated in the entire Software Development Life Cycle (SDLC) of the project.
• Implemented the code using C# as code behind and ADO.NET for connecting to the SQL Server database.
• Developed business logic using C# and connect to WCF services to get data and implemented MVC architecture using C# .NET, ASP.NET.
• Developed tools using C# and LINQ to ease the recording of the documentation that consists of the configurations in the database and worked on enhancements of the product, extensively by generating reports using SSRS.
• Designed Restful Web Services using SOAP, XML to expose the Data for using in Web Forms.
• Prepared and executed Unit Test Cases for the entire application.
• Implemented distribution to FTPS protocol (FTP with SSL certificate).

Environment: .Net Framework 3.5/4.0, Visual Studio 2010/2015, ASP.NET, C# 3.5, ADO.NET, XML, HTML5, DHTML, CSS3, XML,JSON, Java Script, jQuery, IIS 7.5, SSRS, SSIS, Windows Server 2012, MS SQL Server 2012, WCF Services, Microsoft Office 2013, Office 365.