SUMMARY:

• 12+ years of experience in analysis, design, development, testing and implementing client/server, web, Windows and ETL applications, Management software engineering lifecycle in Microsoft and Oracle technologies.
• Delivered software solutions including windows applications, web applications, and corporate portals using Microsoft Technologies.
• Experienced in using the SQL Server 2005/2008/2012 and 2016 and Business Intelligence Development Studio (BIDS)
• Expertise in Microsoft Technologies like VB 6.0, ASP 3.0, ASP Classic, using Visual Studio.NET, .Net Frame work 1.1/2.0/3.5/4.5 , ASP.NET, MVC3/4 /5.0 Razor, C#, VB.NET, ADO.NET, JavaScript, AJAX and Java.
• Well versed in .NET n - Tier architecture with Web technologies and Windows technologies using .Net Frame work, Java, Web Forms, Win forms, Web Services, SOAP, WSDL, IIS 7.0/8.0, XML, XSL, XSLT, CSS, DHTML, Classic ASP HTML, HTTP and TCP/IP Protocols.
• Experienced in designing and tuning database tables, views, stored procedures, user defined functions, cursors and triggers using Sybase, Oracle 9i, 10g, MS Access, M S SQL Server and experienced with SQL Server Reporting Services (SSRS) and Crystal Reports.
• Experience in creating Parameterized, drill-down, sub-reports, matrix, tabular and graphical Reports using SQL server 2008/2012 Reporting Services, Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using ETL tools (SSIS, Data Transformation Services (DTS), Bulk Insert, and BCP) and Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience with configuration management tools Visual source safe (VSS), Team foundation server (TFS) and SVN.
• Experience in creating the Replication (Transactional) between the servers for highly availability of data.
• Experience in Using JavaScript frameworks Like jQuery and Prototype.
• Experience with Agile practices of software development.
• Experience with application security management using Authentication, Authorization, secure level communication (SSL/TLS, IPsec and RPC Encryption) and manual methods testing for SQL injection, Cross Site Scripting and Cross Site Request Forgery.
• Quick learner with strong analytical and problem-solving aptitude
• Motivated team player with ability to work independently

TECHNICAL SKILLS:

.NET Technologies: VB.NET, C#, ASP.NET, Win Forms, ADO.NET, Net Framework 1.0/1.1/2.0/3.0/3.5/4.0 and 4.5, Web Services, Remoting Services, WCF, REST API, LINQ, MS Enterprise Libraries, AJAX and Silverlight.

Other Technologies: Java, C, C++, Excel, Word, APAMA 5.0, Actimize RCM UI 5.6, Informatica, SAP-BO and ArcGISDatabases M S SQL Server, Sybase, Oracle 8i, 9i, 10g, MySQL, MS Access 97/2000, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Query Analyzer and DTS.

Scripting and XML: Classic ASP, JavaScript, VB Script, JQuery, JSON, XML, XSLT, XAML, DHTML, HTML5, CSS, Front Page.

Reporting Tools: SQL Server Reporting Services (SSRS), QlikView, Tableau and Crystal Reports

Version Control: Visual Source Safe 6.0/2000, TortoiseSVN1.7 and TFS.

Methodologies: MVC, MVP, MVVM design pattern and Waterfall.

Operating Systems, Servers: UNIX, Linux Win 2003/2008, IIS 7.0/8.0 and SharePoint Server 2010.

PROFESSIONAL EXPERIENCE:

Confidential, Urbandale, IA

Sr.MS BI and UI Consultant

Responsibilities:

• Design, developed and implemented the UI applications using Asp.net 4.5, MVC 5.0, VB.NET, C#.NET classes, jQuery, AngularJS JavaScript, Html 5, bootstrap and CSS.
• Used jQuery for cross browser functionality and client side validation.
• Developed several Custom CSS files, UI controls skins and custom jQuery data grids.
• Worked on Log4Net API for application log management and Lazy Loading.
• Wrote custom Ajax controls using asp.net, bootstrap css and jQuery.
• Work closely with the Business analysts for requirements gathering, designing the database and creating workflow for report.
• Implemented Test Driven Development (TDD) practice for Agile Software Development
• Involved in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Experience in Performance Tuning and Query Optimization.
• Worked on TFS management and application testing process.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server (text files, Excel docs, Oracle DB, MYSQL, MS Access and Sybase). from different environments for the SSAS cubes.
• Experience in SSRS creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. ( Table , chart and matrix report ).
• Identified the dimension, fact tables and designed the data warehouse using star and snowflake schema.

Technologies: Windows Server 2008, Visual Studio 2013, TFS 2013, IIS 7.0, VB.NET, C#.NET, ASP.NET 4.5, MVC 5.0, .NET Framework 4.5, Ajax, Bootstrap 3.3.4, jQuery, AngularJS, XML, HTML, Sql Server 2008/2012, LINQ, COM, RDLC Reports, SSRS, SSAS, SSIS, Red Gate, WCF, Web Services, Microsoft Visio 2007, Agile Scrum, MySQL, PHP, Oracle 10g, and TFS

Confidential, New York, NY

Sr. Consultant

Responsibilities:

• Worked as a senior application developer to implement Confidential Trade Surveillance system for Citi Group’s Global Compliance.
• Worked closely with business users when the requirements were being finalized.
• Developed Web Forms for the modules using C#, ASP.Net server controls, Validation Controls, AJAX Toolkit, HTML, CSS and using ADO.NET Dataset, Data Reader, Data Adapter and Data Grid.
• Using jQuery and JavaScript for implementing client side validations at Controller level.
• Using jQuery JSON for dynamic User Interface, retrieval and posting of data.
• Designed a pre-process (staging) environment to synthesize Reference feeds from upstream Security Master and Accounts data, Market data feeds as well as Transactional data like Trades.
• APAMA GUI developed desktop application with Windows Presentation Foundation (WPF) and Implemented MVVM pattern and Web application with Silverlight 5.0 using MVP pattern.
• Customized APAMA GUI windows application using C#.Net, WPF, Visual Studio 2010 and SQL Server 2008 r2. Customized WPF Forms, Custom Controls and User Controls using XAML language for interactive UI as per Citi requirements.
• Generate exceptions and alerts to notify user of potential compliance violations Involved
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Use Silverlight and Microsoft BI (SSAS, SSIS and SSRS) to generate reports displaying alerts, trading activity, price variations, profitability and loss avoidance and other reports.
• Worked with ETL processes - using SSIS to load data from different data sources (text files, Excel docs, Oracle DB and Sybase).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Technologies: MS Visual Studio 2010, Silverlight 5.0, Microsoft Business Intelligence(BI), WCF,.ASP.NET 4.0,C#, Java, Oracle 9i /10g, SQL Server 2008 R2, Sybase, APAMA 5.0, Actimize RCM UI 5.6, and TortoiseSVN1.7.

Confidential, Minneapolis, MN

Responsibilities:

• Designed Templates and database for Image Capture process.
• Developed .Net applications in an Agile environment to integrate with Kofax Image Capture software
• Worked closely with the QA testing group, to deliver quality software, and to train new QA staff to understand the details in the Image Capture process.
• Involved in writing complex T-SQL queries and Stored Procedures in SQL Server 2008/2010/ Oracle 9i /10g to meet the business requirements.
• Created the Publication and subscription to get the data from Prod server to Dev for data.
• Created Clustered and Non-Clustered Indexes on tables, views, and columns.

Technologies: MS Visual Studio 2008/2010, KoFax, ASP.Net, WCF, .NET 4.0/3.5, C#, HTML, XML, Web services, AJAX, jQuery, JavaScript, VBScript, CSS, Oracle 9i /10g,SQL Server 2008/2005 and TFS.

Confidential, Wayzata, MN

Senior Developer

Responsibilities:

• Involved in Requirements Collection, Development and Customization of the Application.
• Designed & developed user interfaces using ASP.NET MVC 3 Razor forms (. cshtml Pages).
• Used web Grid and HTML Tables with Paging and Sorting for displaying various data on to the page.
• Created partial view files for code reuse and Shared Pages.
• Developed CSS for consistent look and feel of the web site.
• Created tables, views and established relationship between the tables.
• Created Stored Procedures, Functions, Views and Triggers using T-SQL.
• Involved in writing complex T-SQL queries and Stored Procedures in SQL Server 2008 to meet the business requirements.
• Implemented Unit Test using Test Driven Development (TDD) practice for Agile Software Development
• Created procurers and Optimizing the performance of query using query execution.
• Created Linked server to join the tables to between two servers.
• Involved in Client Side validations using Validation Controls, JavaScript and VB Script.

Environment: Visual Studio 2010, .NET Framework 4.0, C#, ASP.NET MVC3 Razor, Entity Framework 4.0, WCF, Windows Service, SQL Server 2008, HTML, CSS, JavaScript, JQuery, XML, XSD, XLS and TFS.

Confidential, Minneapolis, MN

Senior Developer

Responsibilities:

• Knowing the requirements of business.
• Preparing analysis, design documents, estimation, for different components and functional modules required by the system.
• Worked intensely on the User Interface. Developed Web Forms and Win Forms using C# and ASP.NET. Used AJAX in web forms. Worked on jQuery, JavaScript, JSON and Cascading Style Sheets.
• Import and Integrate OBI Clients on daily basis to migrate the events and tasks using SSIS integration and Windows Services.
• Used Windows Communication Foundation (WCF) to expose business logic as services and consumed those services from client applications.
• Created keys and Indexes while creating the SSIS packages.
• Developed business layer logic and Data Access Layer using C#.
• Created tables, views and established relationship between the tables.
• Created Stored Procedures, Functions, Views and Triggers using T-SQL.
• Involved in writing complex T-SQL queries and Stored Procedures in SQL Server 2008 to meet the business requirements.
• Extensive worked with ETL (extract, transform, and load) processes - using both DTS and SSIS to integrate data from different data sources (text files, Excel docs, Oracle DB) for reporting purposes.
• Created various types of reports using SQL Server reporting services.
• Worked on fixing Production BUGS with very quick turnaround time.
• Provided support for SharePoint Sites.

Technologies: MS Visio, Visual Studio 2008, SharePoint, jQuery, JSON, WCF 3.0, .NET 3.5/2.0, SSIS, SSRS, AJAX, ASP.NET, VB.NET,C#, HTML, XML, Web services, AJAX, JavaScript, CSS, Oracle 9i, SQL Server 2008, T-SQL,PL/-SQL,IIS and VSS.

Confidential, Phoenix, AZ

Developer

Responsibilities:

• Involved in Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.
• Designed & developed user interfaces using ASP.NET web forms (ASPX Pages) using C#.
• Extensively used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data View for reading/updating records in the database.
• Used ASP.NET Ajax Control Toolkit.
• Used core server controls (GUI design) such as Dropdown List, Checkbox List, and other advanced controls such as Calendar.
• Client and Server side Validations are done using JavaScript and ASP.NET Validation Controls.
• Used Grid View, Data List and Repeater controls with Paging and Sorting for displaying various data on to the page.
• Created User controls (.ascx) files for code reuse and Master Pages.
• Developed CSS for consistent look and feel of the web site.
• Involved in writing complex T-SQL queries and Stored Procedures in SQL Server 2005 to meet the business requirements.
• Created Stored Procedures, Functions, Views and Triggers using SQL/PLSQL.
• Involved in Client Side validations using Validation Controls, JavaScript and VB Script.
• Responsible for deliver bug free code to the Client Testing Environment.

Environment: Visual Studio 2008, .NET Framework 3.5, VB.NET, C#, ASP.NET, ASP.NET Ajax Extensions, SQL Server 2005, SSRS, Oracle9i, Classic ASP, VB 6.0, HTML, CSS, JavaScript, XML,VB Script, Crystal Reports and VSS.

Confidential

Developer

Responsibilities:

• Designed & developed user interfaces Web Forms and Win Forms using C# and ASP.NET.
• Extensively used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data View for reading/updating records in the database.
• Involved in extracting CPT and ICD codes from Snomed.
• Used NewCropRx web service for maintaining patient allergy and drug information.
• Developed XML Web services in C# to communicate with remote business components and as well with applications.
• Developed Reports using Crystal Reports.
• Used ADO.NET extensively for data retrieving, querying, storage and manipulation.
• Created User controls (.ascx) files for code reuse.
• Involved in the development of Analysis and code using C#. NET and Win Forms.
• Involved in Client Side validations using Validation Controls, JavaScript and VB Script.
• Modularized the existing code through assemblies.
• Writing business and data access components in C# utilizing ADO.NET for different databases (SQL Server 2005 and Oracle 9i).
• Created tables, views and established relationship between the tables.
• Created ASP.NET user controls to reduce the complexity of user interface design.
• Learned EDI claims submission formats HIPAA 3051,4010 Formats
• Implemented some of the EDI transaction like Healthcare Claim Professional, Eligibility Inquiry and Response (837P, 270 and 271,835 etc.).

Environment: ASP.NET 2.0, C#.NET, VB.NET, ADO.NET, Visual Studio.NET 2005, SQL Server 2005, SQL Reporting Services (SSRS), Oracle9i, Crystal Reports, HTML, XML, Web services, AJAX, JavaScript, CSS, HIPPA and VSS.

Confidential

Developer

Responsibilities:

• Design, Development of Web Forms Using ASP.NET & VB.NET.
• Used JavaScript for validating client side data entry web screens.
• Design and development of the components for middle tier (Business Layer) Using VB.NET.
• Developed Reusable Classes using VB.NET.
• Developed Data Layer using ADO.NET to communicate with MS SQL Server.
• Improved the application performance using stored procedures and connection pooling and Memory management.
• Developed Custom User Controls To reduce the Complexity in User Interface Coding and provide better look and feel.
• Writing Test Cases for production system.
• Visual Source Safe was used for version control.

Environment: .NET Framework 1.1, XML/XSLT, Windows XP/2000, SQL Server2000, HTML, JavaScript, Vss 6.0.