SUMMARY:

• Over 10 years of experience in analyzing, developing and implementing of business application.
• Working experience and strong business knowledge of the manufacturing industries, financial institutions and insurance organizations.
• Experience in all the phases of Software Development Life Cycle (SDLC) such as strategy and analyzing, designing, building (coding), testing and documentation of software products.
• Worked on .NET Security features such as Authentication & Authorization, Forms - based Authentication, Authorizing Users, Roles and User Account Impersonation, tracing.
• Good Experience in Web Services ..
• Strong experience in developing Packages , Stored Procedures, Functions, and Triggers for the implementation of data integrity using T-SQL and PL/SQL, data warehouse .
• Worked independently in multiple Operating Systems through VPN client.

TECHNICAL SKILLS:

Programming Languages: C, C++, JAVA, VB6, PHP, VBA, C#, VB.NET, MVC4.0, DNN 8.0, Java Script, XML Schema, XSL

Database: SQL Server 2012, SQL Server 2014 MS-Access 2016, Oracle 11G

Web Technologies: ASP.NET 3.0,4.0, 5.0, WinForms, MVC4, MVC Razor cshtml, JQuery, HTML5, AJAX, Angular1.5, Bootstrap, CSS, WCF Web Services ), ADO, ADO.NET, DAO, ODBC, Web API, OLE, Crystal Reports, SSRS, UML, Microsoft Visual Source Safe 6.0, Win CVS 1.2, TFS and N-Tier Development, Unit testing, DNN with MVC module.

Operating System: Windows 2012/ Microsoft Windows Server Environment 2008 R2, setup Lan & Wan both, SSO, Linux, Unix.

SAS Tools: Base SAS 9.3/9.2(mainframe), SAS/Stat, SAS Macros, SAS/SQL, SAS ODS, SAS DI STUDIO, SAS Graph, SAS Enterprise, and SAS Business Intelligence (BI) platform

Reporting Tools: Base SAS versions 9.3/9.2, SAS Enterprise Guide, SAS Enterprise Miner, SAS GraphAXUM, MS Excel, SAS BI Platform, and MS-PowerPoint

RDBMS: SAS SQL, SAS Enterprise, SAS BI Platform, MS-Access, Microsoft SQL Server, and MySQL

Languages: SAS, SQL, and HTML

PROFESSIONAL EXPERIENCE:

Confidential

Technical Programmer

Responsibilities:

• Used High performance risk data factors those calulate missing info or duplicate info at run time specially when get data from multiple medical platforms and also in different multiple formats using xml, txt..tried to evaluate all risk data factors in order to find leakage (Var) and recover from all platform calculated risk steps for all states & provider's EMR Data for correct reporting to the government. Used distinct statistical models on a monthly basis which expect correct test results.
• Worked on multiple formats of medical data and use correct mapping procedures for each market (NY,FL,SC,TX,CT,MO,KY,TAMS) as per business needs and explain better solution over all how handles critical data in a simple formats so that it give accurate consistency at the audit time to all insurance companies and pharmacies as well.
• Setup multiple automation processes which pull the files from their server and translate into our system and generates results using business routines and forward result to government.
• Use various techniques to shrink the size of result data base on patient id, Service date and doctor.
• Hands on experience in SAS Programming, Merging SAS Data Sets, Developing SAS procedures, Macros, Preparing
• Data, Producing Reports, SAS Formats, SAS Functions, SAS In formats, Storing and Managing Data in SAS Files.
• Experience with PROC SQL, PROC DATASETS, PROC FORMAT, PROC PRINT, PROC APPEND, PROC TABULATE, PROCGPLOT, PROC GCHART, PROC COMPARE, PROC IMPORT, PROC EXPORT, PROC TRANSPOSE, SAS/STAT procedures such as PROC FREQ, PROC MEANS etc.

Technology Stack: SAS Visual Studio 9.4. SQL Server 2014 TFS Versioning system, Oracle, Greenplum, SAS data warehouse environment, Unix

Confidential

Senior Technical Programmer

Responsibilities:

• Requirement gathering and analysis for new development.
• Design Visualization, Effort estimation.
• Design and implemented the website using MVC, Web API, jQuery, Angular1.5, Bootstrap, HTML5 and CSS3 .
• Developed an interface to transfer information seamless to Sales force.
• Developed a multithreaded windows service to migrate files from cloud Secure Shell.
• Responsible for writing stored procedures, views and functions.
• Involved in debugging and testing of the application using trace and log files.

Technology Stack: C#, Visual Studio 2013, 2015. MVC SQL Server 2014, jQuery, Bootstrap, HTML5, CSS3, Windows Service and TFS Versioning system.

Confidential

Senior Developer

Responsibilities:

• Fixed data tickets using Sql Server transaction scripts and verified through each environment and corrected the changes in the old ASP files to load legal documents according to new agreements.
• Added features in scheduled quantity for operators & scheduled quantity for shippers in Dart Application using .net win form.
• Used High performance Risk analytic factor which accurate return result and it find correct loss/gain items using in the gas pipelines .
• Design console application name RptPDFGen.exe. This application looks into the reports queue table for any request to create report in Pdf format through Tidal jobs.
• Checked in number of Dart application tickets as per priorities and properly co-ordinate each business user.
• Fixed heavy stored procedures bugs permanently using SQL SERVER 2008 and used JIRA , SQL Server 2008, Oracle, Microsoft Windows Server 2008 R2, .Net 4.0, Tidal tool, Win forms, Jira, Unit testing

Confidential, Houston, TX

Senior Developer

Responsibilities:

• Developed ASP.NET MVC design pattern and design several UI Enrollment processing screens which handles all kinds of customers validation related with meter location and used WCF services talking to Ercot and Non-Ercot utilities and fixed issues and worked on weather forecast using Global Energy tool resolved the pending JavaScript issues and made the website compatible with Fire Fox & Opera.
• Used Microsoft CRM application to maintain utility payment system.
• Used Execution plan and optimized complex Sql inside Stored procedures and functions.
• Added Console Apps services.
• Design data mart system to allow run load forecasting SRRS reports from demoralized data warehouse on daily basis.
• Monthly meeting with Customer Service to train new features and track pending issues if any .
• Attend multiple project managers meetings to discuss related features with their projects.
• Completed TFS tickets before deadline and test properly through multiple system before deployment to production
• Risk Management experience in Microsoft CRM tracking multiple areas updating multiple data sources using PL/SQL packages .
• Design WCF services for all Texas and Non-Texas markets
• Developed ASP.NET MVC design pattern and design several UI Enrollment processing screens which handles all kinds of customers validation related with meter location and used WCF services talking to Ercot and Non-Ercot utilities and fixed issues and worked on Weather forecast using Global Energy tool and also used Microsoft CRM application to maintain utility payment system and also design several console Apps too. Attend multiple project managers meetings to discuss related features with their projects. Complete TFS tickets before deadline and test properly through multiple system before deployment to production.
• SQL Server 2008, Oracle, Microsoft Windows Server 2008 R2, SSRS, Global Energy Tool & Microsoft CRM 3.2,Web API, .Net 4.0 MVC design pattern, VB.Net, WinForms, Web services, Enterprise Service Bus (ESB), Unit testing, SharePoint 2010 and Project server 2010.

Confidential, Houston, TX

.Net Lead

Responsibilities:

• Analyzed & design more features in the Learning Management System in Asp.Net 3.5 and migrated from Asp.net 2.0.
• Resolved the Pending JavaScript issues and made the website Compatible with Fire Fox & Opera.
• Added the Ajax technology for partially update the pages on some points.
• Used Execution plan and optimized complex Sql inside Stored procedures and functions.
• Added Console Apps services that run overnight and properly update customer past test, Future test & lessons.
• Fixed and added Template based and Non-Template based reports
• Designed Management of Tracking & Action Tracking Modules.
• Designed using OOAD methodologies and UML such as Cases, Class, and Collaboration.
• Added number of Views, Stored Procedure, Functions and new features of the application
• Converted build multiple type of lesson module into .NET environment.
• Worked independently in multiple Operating Systems through VPN client. Setup the Linksys router RV082
• Working closely with customers, gathering & defining requirements; Developing and representing strategies for automation of manual business processes or
• Enhancements to existing automated processes.
• Providing technical leadership to the development team; assisting them with complicated software engineering problems; identifying and rectifying complicated bugs. Collaborating with project manager to ensure requirements are well understood and development is in line with project’s vision

Environment: ASP. NET 2.0 & 3.5, MVC Architecture, WinForms, Web services, SQL Server 2005, SSRS, SQL Server 2000, C#, Microsoft Windows Server 2003 R2, IIS, WCF, Vb.Net, Unit testing

Confidential, Houston, TX

Computer Programmer

Responsibilities:

• Used Prea-Webservices and Code-Smith Schemas in which used strongly type datasets and Ajax.
• Solved average three tasks a day.
• Develop and maintain website & multiple console applications running multiple servers and set multi threading with Max 25 and resolved time-Out issues. And also resolved application, data feed and server problems.
• Fix bugs and report bug fixes back to the QA team. Used complex stored procedures according to all business logic and flow charts. Used Microsoft visual studio 2005, sql server 2005.
• ASP. NET, VB.Net, sql server 2005, SSRS, Visual Studio .NET 2005, Code Smith, SVN, Microsoft
• Windows Server 2003, IIS, Webservices

Confidential, Houston, TX

Developer

Responsibilities:

• Worked on Loan Applications (Loan creating, tracking, switching and loan closing applications ASP.NET, Oracle 9i, ASP & Crystal Report 9. Handle 55 million records SQL, optimized SQL through fine tuning methods, developed multiple forms and Asp pages integrated through ADO, used replication, Linked server.
• Automated Quality Check tasks by creating PL/SQL packages, procedures, cursors, ref cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling.
• Created triggers for auditing purpose.
• Import of data from SQL Loader to Oracle tables and creation of external tables.
• Tuning complex queries through execution plan and avoided running full table scan and used necessary indexes on join.
• Used Multidimensional objects such as cubes and return multidimensional cellsets that contain the cube's data. Used in cubical reports, matrix reports, drill down reports. Also stored data from various databases in de - normalize form.
• Used BI tool for OLAP to get information like Accounting, financials, loans etc