E-mail: *************@*****.*** Phone No: 518-***-**** (Cell)
PROFESSIONAL SUMMARY:
Over 12 years of strong experience in definition, estimation, design, development and implementation of multi-tier Enterprise Applications, Web based Internet/Intranet Applications and Web/WCF Services using agile development methodologies.
Certified Project Management Professional (PMP) & Certified Scrum Master (CSM) with extensive Technical and Project Management experience
Strong self-starter with extensive expertise as a .Net developer using the skills in Visual Studio.Net 2015/2013/2012/2010/2008/2005, SharePoint 2010/2007, C#.Net, VB.NET, ASP.NET, ADO.NET, XML/XSLT, AJAX, JQuery/Backbone/Knockout, JavaScript, (D)HTML, CSS/CSS3, IIS 7.x/6.0/5.x, MVC, Entity Framework, Web API, Enterprise Library, XML LINQ, Web Services, Windows Services and Windows Communication Foundation (WCF).
Expertise in designing and implementation of applications using SOA, WCF, Web Services technologies like SOAP, RESTful, etc., Entity Framework, Multi-threading, N-tier web applications using industry-proven patterns and practices like MVC, CSLA, MVVM.
Expertise in writing Data Access Layers using ADO.net Entity Framework and LINQ to SQL, LINQ to Entities.
Expert in Data Modeling using ERWIN, Visio tools with experience in handling complex database in SSIS/SQL Server 2012/2008/2005, Transact SQL, Oracle 12c/11g/10g/9.x, PL/SQL and MS Access
Proficient in writing Functions, Stored Procedures, Views, Packages and performance tuning using Transact SQL and PL/SQL
Proficient in developing Reports using Crystal Reports and SSRS Reporting tool, experience including Tablix, Matrix, chart and sub-reports.
Worked on creation of Process Modeling (Architecture Diagram, DataFlow Diagram, Use Case Diagram, etc.)
Experience with Software Development Processes & Models: Agile, CMM, Waterfall & Scrum Models.
Worked on developing applications including major business areas of Financial, Insurance, HealthCare, and NY State Agency Applications.
Worked under extreme deadlines and all the phases of software development life cycle (SDLC).
Strong analytical, problem solving and communication skills.
TECHNICAL SKILLS:
.Net Technologies
:
Visual Studio 2015/2013/2010/2008/2005, ASP.NET, VB.NET, C#, MVC 2/3/4/5, Web Services, Windows Services, ADO.NET, Windows Communication Foundation (WCF), LINQ, Entity Framework 6.0, Enterprise Library.
Web Development
:
SharePoint Services 2010/2007, XML/XSLT, IIS 7.0/6.0/5.0, VB Script, JQuery/Backbone/ Angular/Knockout, Java Script, HTML 4/5, CSS/CSS3, Bootstrap.
Languages
:
C++, C, TSQL, PL/SQL, COBOL, UNIX/C shell scripting
(R)DBMS
Oracle 12c/11g/10g/9i, SQL Server 2012/2008/2005/2000, MS Access
Active-X
AJAX Controls, Infragistics Controls, Component One controls
Data Access
:
ADO.NET, ODP, DevArt, Entity Framework, LINQ, OLEDB
OS Environment
:
Windows 10/7.0/2008/Windows Server/XP/2000, UNIX SVR4.2
Development Environment
:
TFS, Unisys open TI, Silverlight, Visual SourceSafe, Visio 6.0/5.0, TSO/ISPF, LDAP, Site Minder, ENDEVOR, QMF, PVCS, SQL Developer, Toad
Reporting Tools
:
SSRS, Crystal Reports, Component One PDF viewer
Others
AJAX Extensions, Embarcado, ERWin, Test Director, MS Office Products
EDUCATIONAL BACKGROUND:
MS in Computer Applications (Master of Computer Applications), pt. Ravishankar Shukla University (Govt. College of Engineering & Technology), INDIA.
PROJECT DETAILS:
CMA Consulting Services Inc, Jun’ 15 – Jul’17
Latham, NY
WOW: WOW is the web application to provide participant services for WIC (Women-Infant-Children), Commodity Supplemental Food (CSF), Vendor, Clinic, Senior Farmers Market and Farmers Market programs. WOW is designed as a tool to support participant-centered services for WIC. WOW is an integrated system provides services to four public health programs using the same process and flows. It is a flexible and customizable system that is operational in NJ state agencies. This application design is compatible with modern architecture design features that enable the speed of implementing changes to be faster and more effective as program and operational rules evolve.
Role & Contribution:
Working closely with Business users and the Managers on the business requirements, analyzing and writing formal documentation of BRDs and workflows.
Followed the MVC Design Pattern to model the Business process and Repository factory pattern to model the Data access layer.
Extensively worked with TFS 2013 for code management, code reviews, agile methodology and Scrum.
Used HTML JQuery and for designing master pages and model the text layout of the Web pages.
Used JQuery for client side scripting and validations.
Written LINQ queries to perform in memory data operations.
Configure the Entity framework to access the database tables and performing data manipulations.
Created and implemented the Data access layer using LINQ queries for CRUD operations on Database.
Created Entity Connection and Entity Command objects to call the stored procedures from the database.
Have Written Oracle Complex stored procedures, Cursors, functions to perform operations on data.
Implemented Web Services to integrate the client systems using WCF.
Environment: Visual Studio 2013/2015, ASP.Net, C#, MVC 4, LINQ, DevArt, Entity Framework 6.0, Oracle 12c/11g, HTML, WCF, JQuery, Team Foundation Server.and Windows 7.
NYS Office of Temporary and Disability Services (OTDA), Jul’ 12 – May’2015
67 N Pearl St, Albany, NY
TRACS2 - TANF Reporting and Control System 2: This is an Internet-based application that allows districts to provide program information and report families served and outcome results for TANF Services Projects and Employment Programs funded by the Flexible Fund for Family Services (FFFS). In addition, district staff must enter Drug and Alcohol Assessment information and report the number of Non-Custodial Parents Participating in Work Activities. Information reported on TRACS 2 will be used in the FFFS Performance and Accountability Matrix (PAM) located on the OTDA website.
FFFS - Flexible Fund for Family Services: FFFS is a Sharepoint site that district staff will use to complete, submit, revise, and view their FFFS Plans. OTDA and OCFS staff will use this site to upload the initial plans, receive, review, and approve or return to districts plans that require further clarification. The site houses FFFS and TRACS 2 resources such as ADMs, user guides and related useful information. The FFFS site automates and streamlines FFFS plan processing through systemic e-mail notifications at critical points in the planning process including Plan Approval, storing the Plan history and supporting the plan working copy that is readily available for district revision.
SOLQ (State Online Query): This is an Internet-based application that is used by both state and county personnel to enter demographic data for an individual and perform a search on the Social Security Administration (SSA) database in Maryland. It is used for the SSN Verification/Standard Response, Title II and Title XVI benefit information to NY State to determine clients’ eligibility to certain State-administered programs.
TRACS - TANF Reporting and Control System: This is a separate application from the above existing TRACS application. TRACS allows districts to submit claims for FFFS, TANF Block Grant programs, the Safety Net Assistance Program (SNAP), the Non-Residential Domestic Violence program, and the Local Administration Fund (LAF). It also is used to report outcomes for the Intensive Case Services (ICS) program and enter program information and outcomes for SNAP.
Role & Contribution:
Working closely with Business users and the Managers on the business requirements, analyzing and writing formal documentation of business processes and workflows and resolve production issues.
Worked on developing web GUI designing to enhance the functionality on the intranet web sites.
Worked on ASP.Net Web Forms using VS.Net 2012/2010, VB/ASP.Net, Web Services & WCF, ADO.Net, JQuery/Java Script, XML, VB Script, CSS and HTML etc.,
Enhanced user experience by designing new web features using MVC/MVVM Framework like Knockout.js, Backbone.js and node.js
Implemented MVC/MVVM, Object Oriented Analysis, Design and Development patterns.
Used various security protocols like LDAP and Netegrity SiteMinder to implement the security on the web applications.
Involved in creating and modifying the physical DB Objects like Tables, Views, etc.,
Written Functions, Stored Procedures and Triggers using PL/SQL coding.
Involved in analyzing and writing formal documentation of the complex business process design and technical solutions for the new and existing workflows enhancements.
Mentoring other developers to develop/document/implement coding & GUI design best practices.
Worked with non-technical staff to develop system specifications and resolve the problems.
Actively involved in regression and integration testing, installing .NET web sites and the production support activities.
Environment: Visual Studio.Net 2012/2010/2005, C#, VB.Net, ASP.Net, Silverlight,Web Service, WCF, ADO.NET, DHTML, AJAX, CSS, TFS, Share Point 2007/2010, JQuery/Java Script, Oracle11/10g, PL/SQL, Toad, IIS 7.0, LDAP, Netegrity SiteMinder and Windows 7/Server 2008
CIO-OFT, NY State, Mar’ 08 – Mar’ 12
40 N Pearl St, 7Th Floor, Albany, NY
SDCIRS (State Data Center Invoice Reconciliation System): This system automates all necessary functionality required for Customer Networking Solutions (CNS) managers to reconcile State Data Center (SDC) invoices received by CNS. The process includes three parts: first, a Windows Application uploads the SDC invoice into a database; second, a Web Application, using large volume business rules, presents the data to managers for their review and approval; and lastly, a Windows Application generates a summary report displaying aggregated payment data aligned to the appropriate NYS Cost Centers. Various screens and reports are provided to facilitate the unit managers in keeping track of their approval or disapprovals of the SDC charges. The interface provides dynamically generated Trend Analysis reports detailing actual versus projected costs and actual versus planned usage for the unit managers to measure current year spending and estimate expenses for the next year.
WILMA: This web application is used to keep track of procurement and maintain Inventory of the various datacom equipments being deployed at various sites for a particular project for various NY state agencies. Various modules like Order generation, Device/model maintenance, Invoices, PO, PO Contract information are maintained and updated according to the equipment movements. Various MIS reports were generated to assist CNS staff in resolving site equipment discrepancies. System also maintains Vendor, Usage codes, Projects etc.
Service Request System: This is a site developed to allow various NY state agencies to request for service request/work orders to CNS, and for CNS staff to receive and track the completion status of the request. The application has two parts: a Web Application is used to allow users to enter, upload, edit, or delete the service request and the other part is administration site, which is used to keep track of status, assign users the appropriate level of data access permissions. Various MIS reports were developed for the higher mgmt.
Network Infrastructure Resource Database: The Network Infrastructure Resource Database collects and maintains information about the sites throughout New York State that are supported by the Human Services Enterprise Network. The system maintains information about site demographics such as name, location, site contact information, data communications equipment installed, Visio diagrams, IP address information, etc. This information is critical to many units within NYS CIO/OFT and its customer agencies in conducting day-to-day operations such as resolving Helpdesk calls, planning infrastructure improvements, deploying equipment, and billing for CNS services. This was developed in classic ASP which has redesign and developed in Visual Studio 2005.
Role & Contribution:
Working closely with Business users and the Managers on the business requirements, analyzing and writing specifications on business processes and workflows.
Worked independently in developing GUI designing using C#/ASP.Net to develop intranet web sites start to finish from business analysis, develop, and implement, production support/maintenance.
Upgraded Classic ASP/VB6.0 sites to latest version of ASP.Net Web Forms using VS.Net 2005/2008, VB.Net/ASP.Net, ADO.Net, JQuery/Java Script, CSS, XML and XHTML etc.,
Developed Web Services (WCF) to access data from Database under n-tiered web applications with high volume business logic.
Implemented/added new AJAX features into VS.Net 2005/2008 environment for advanced/robust functionality.
Implemented MVC, Singleton, Object Oriented Analysis, Design and Development patterns.
Involved in creating physical DB Objects like Tables, Views and developed Stored Procedures, Triggers and Packages using PL/SQL and Toad
Involved in SQL tuning to improve performances.
Mentoring other developers to develop/document/implement coding & GUI design best practices.
Involved in analyzing and writing formal documentation of the complex business process design and technical solutions for the new and existing workflows enhancements.
Worked with non-technical staff to develop system specifications and resolve problems
Actively involved in regression and integration testing, installing .NET web sites and the production support activities.
Environment: Visual Studio.Net 2005/2008, C#, ASP/ASP.Net, Web Service, WCF, ADO.NET, DHTML, AJAX, CSS, Visual Sourcesafe, JQuery/JavaScript, Oracle 10g/9i, PL/SQL, Toad, Embarcado Data Modeller, IIS 6.0/7.0, LDAP, Netegrity SiteMinder and Windows XP/Windows 7
Computer Science Corporation (CSC), May’ 07 – Feb’08
East Greenbush, NY
eMedNY/ePACES (NY State Medicare): This system is an automation process of the New York State Medicaid program claims processing. The system allows New York Medicaid providers to submit claims and receive payments for Medicaid-covered services provided to eligible clients. eMedNY offers several innovative technical and architectural features, facilitating the adjudication and payment of claims and providing extensive support and convenience for its users. Computer Sciences Corporation (CSC) is the eMedNY contractor and is responsible for its operation.
URL: https://www.emedny.org
Role & Contribution:
Working closely with QA and BA teams on the business requirements, analyzing and writing specifications on business processes and workflows. .
Worked on the .Net classes, Web Services with high volume business logic and code using C#, ASP.Net, ADO.Net, XSLT/XML, Web Services, JAVAScript and (D)HTML etc.,
Implemented MVC and OODD patterns.
Worked on developing web GUI designing of Web Forms using C#/ASP.Net on claims intranet web sites to implement NCP changes.
Implemented Object Oriented Analysis, Design and Development patterns
Working on converting the existing DB2 Stored Procedures to JAVA/SQLJ to improve the processing speed.
Managed/participated in the complex business process design and technical solution for the existing workflow enhancements for National Provider Number implementation.
Actively involved in the production support activities.
Actively involved in testing, installing web site and the production support activities.
Environment: C#, ASP.Net, ADO.NET, COM+, XML/XSLT, Visual Sourcesafe, CICS,JCL, TSO/ISPF, ENDEVOR, QMF, MVS, DB2, DB2 Developer Workbench, JAV, LDAP and Windows XP
The Hartford Financial Services Group Inc (HIG), Mar’ 05 – Apr’07
Hartford, CT
Esid/eSubmission: This is a .NET and web based application that reads data submitted by customers and agents, presents this data to internal CSRs and back to the Customer. It’s an automation and orchestration solution for direct customer sales. It monitors various other systems like CDR, AL3/XML, UWQ, Score Card and prepares the XML and stores in Documentum. This XML will be translated to HTML using XSLT code and brings onto browser. It uses .NET, WebServices, SOAP, XML/XSLT, WEBSphere/MQ, etc.,
Claims Risk Alerts: This is a .NET and web based application that consists of windows service meant for to automate the information and process for Claim’s Risk Alert procedure so that the info is in the electronic file and to create an automated notification process and improve the consistency of underwriting action taken on risk concerns. It creates a centralized URL where the claims adjustors can enter the Risk Alert information. Then for Siebel users, an Activity is created automatically to notify the UW that he/she needs to look up the Risk Alert and do something about it. The UW can key in the action taken on the Risk Alert electronic document and then the adjustor is e-mailed that a response is ready.
Exact-Pay: This is a .NET and web based system developed and rolled out to the Payroll Alliance Center (PAC) as part of the PAC Migration project. It’s linked to and launched from hart.Source Siebel, the central location for the management of customers, leads, quotes, policies and underwriting functions. Serving as the only launch pad for Exactpay, hart.Source Siebel will update Exactpay with key business and policy information.
Middle Market Underwriting Authority: This is a Web App developed in .NET 2003 environment used by Underwriter to access their limits on each lines of Businesses. Various roles and modules are provided for administering the tasks and various Reports were developed using Crystal Enterprise version.
Customer Forms: These are various COM+ components developed in .NET which acts as an interfaces between CLA and Siebel Applications like Summary Of Insurance, Evidence Of Property, ARC, Certificate Of Insurance, AutoID Cards, Cancel Certs, TechEO, MassMail, Name & Address, AL3Prepare, HIGMQADP, GetAL3XML, Renewal Download etc.,
Role & Contribution:
Worked with BAs on business requirements, analyzing and writing specifications on business processes and workflows on multiple Projects.
Worked multiple projects with high volume business logic and code using Visual Studio.NET, C#, ASP.Net, ADO.Net, XSLT/XML, Web Services, IBM MQ Series, etc.,
Used Multi-Threading concept in the Services to getting/putting messages from/to IBM MQ Series
Implemented MVC and OODD patterns.
Developed various high volume Web Forms, .Net classes, Services using Visual Studio.NET 2003, C#, ASP.Net, XML/XSLT and (D)HTML.
Implemented client-side validations for cross browser compatibility using Java Script.
Involved in developing GUI Design patterns, complex business process design and technical solutions for existing and new workflows.
Implemented Object Oriented Analysis, Design and Development patterns
Developed middleware business objects (.Net Classes) using C# and heavily utilized ADO.NET objects.
Business objects has been exposed and transferred between the processing centers using Web Services.
Mentoring other developers to develop/document/implement coding & GUI design best practices.
Worked on developing DB objects like Functions, Views, Stored Procs, Packages, etc., for enhancements/changes using PL/SQL, SQL Queries tuning on large databases.
Worked on enhancements of various scheduled jobs for production monitoring systems.
Actively involved in testing, installing the web sites and production support activities.
Environment: Visual Studio.NET 2005/2003, ASP.Net, ADO.NET, VB.Net, C#, COM+, XML/XSLT, IIS, CSS, JAVA Script, WebSphere MQ/IBM MQ Series, Siebel Active X API, Visual SourceSafe, ITG, Tracker/Remedy, Siebel 6.x, Toad, PL/SQL, Oracle9i and Windows 2000/2003/XP