Employment History:

Confidential CA Lead Developer

Projects:

Compromised Customer Information Mgmt (CCI)

Security Control

Banker Exam

ATM Hardware Reporting

ETL Process Maintenance for different application

Responsibilities:

• Lead a team to day to day basis for development and maintenance applications.
• Involved in Design & Development of all new reports using ASP.NET, JavaScript AJAX, master pages, style sheets, and themes in Presentation layer, and C #in Business Layer and MS - SQL Server in Database layer.
• Enhanced existing reports basing on the new business requirement
• Converted ATM Hardware reporting written in SQL Server Reporting Services to custom application.
• Enhanced Compromised Customer Information Mgmt (CCI) to provide the Mail merge feature.
• Used SQL Reporting Services for developing Dashboard Applications & Customized online Reports.
• Successfully implemented Managing Premier Performance Online.
• Worked on Web Page design.
• Worked on exporting the reports to Word, excel and PDF formats.
• Worked closely with the testing team during the QA activities.
• Developed test specification, test plan, test cases and test report.
• Worked on database tuning and performance monitoring with a special emphasis on web based server.
• ETL Process Maintenance feed (daily, weekly, and monthly) from to Host to Oracle/SQL using NDM and Informatica and SSIS.
• Rewrite VB6 application to .Net one, and for sometime use CCW, to use business logic COM components wit callable wrapper.

Environment: Microsoft .NET Framework 2.0, MVC 3, ASP.NET, C#, VB6, CCW, VB.Net, ADO.NET, Microsoft SQL Server 2005/2008, Oracle 10g, DB2, TSQL, SSIS, SSRS, VB Script, JQuery, VSTO, JSON, JavaScript, AJAX, Toad, NDM, Informatica, Chart FX, XMLPDF, XML SPY (Altova), Microsoft Visual Studio 2005/2008/2010, SQL Server Reporting Services, Unit Testing, Microsoft Team Foundation Server, Microsoft Visio 2003.

Confidential Tax and Treasury

Wal-Mart Inc. Bentonville, AR Senior Programmer Analyst - ISD

Responsibilities:

• Involved in Design & Development of Tax and Treasury related system.
• SAP integration.
• Import data from AS400 for internal client server applications with SSIS
• Fixing Tax and Treasury related system issues reported my user.
• Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed test specification, test plan, test cases and test report.
• Design and developed SSRS necessary online reports, dashboard applications and give user training to use the new reports and updated features.
• Worked on Web Page design.
• Worked with java script, AJAX, master pages, style sheets, and themes.
• Experienced in Database Tuning and Performance Monitoring.
• Converting VB6 application, and use VB6 business com components with com callable wrapper (CCW) till rewrite business layer.

Environment: Microsoft .NET Framework 4.0, ASP.NET, ADO.NET, Visual Studio, MVC3, C#, SQL Server 2008, Informix, SSIS, SSRS, VSTO, JQuery, JSON, TSQL, CRM, JavaScript, AJAX, Microsoft Team Foundation Server, Microsoft Visio, VB6, CCW.

Confidential CA Sr. Software Developer

Projects: CLAIMS, MI CLAIMS.

Responsibilities:

• Lead a team to development and maintenance user requested applications.
• Involved in Design & Development of all user change request implementation.
• Create DTS using SSIS to import data from BOA legacy Claims database to new CLAIMS database.
• Worked on Web Page design.
• Worked with java script, AJAX, master pages, style sheets, and themes.
• Experienced in Database Tuning and Performance Monitoring.
• Developed test specification, test plan, test cases and test report.
• Create DTS using SSIS to reverse data from new CLAIMS database to BOA legacy Claims database for reporting purpose.
• Worked with the testing team during the QA activities.
• Use VSTO to create Word and excel documents for different report from new CLAIM system.
• Use share point server 2010 to manage development related documents.
• Fixing existing bugs in new CLAIMS system.
• Create online reports and dashboard applications for CLAIMS system using SSRS and provide users training to use those efficiently.
• Used Telecommunication Billing and Invoice Reconciliation Systems.

Environment: Microsoft .NET Framework 4.0, MVC2, ADO.NET, C#, SQL Server2008, SSIS, SSRS, TSQL, VB Script, Visual Studio, VSTO, JQuery, JSON, JavaScript, Toad, Unit Testing, Microsoft Team Foundation Server, Microsoft Visio.

Confidential CA

Lead Developer

Projects:

Compromised Customer Information Mgmt (CCI)

Regional Resource Planning (RRP)

ATM Hardware Reporting

ETL Process Maintenance feed from to Host (Main Frame)

Responsibilities:

• Involved in Design & Development of all new reports using ASP.NET, JavaScript AJAX, master pages, style sheets, and themes in Presentation layer, and C #in Business Layer and MS-SQL Server in Database layer.
• Designed the Object Oriented Design and Entity Relationship Model using Visio 2003.
• Designed the database for MPP and CCI Mail merge enhancements using Visio 2003.
• Used ASP.NET GridView and ChartFX Controls to display data in a customized format in the ASP.NET web pages.
• Enhanced existing reports basing on the new business requirements.
• Converted ATM Hardware reporting written in SQL Server Reporting Services to custom application.
• Worked on Web Page design.
• Experienced in Database Tuning and Performance Monitoring.
• Enhanced Compromised Customer Information Mgmt (CCI) to provide the Mail merge feature.
• Successfully implemented Managing Premier Performance Online
• Worked on exporting the reports to Word, excel and PDF formats.
• Worked closely with the testing team during the QA activities.
• Used XML PDF for report conversion to PDF format.
• Create online reports and dashboard applications for different applications using SSRS and provide users training to use those reports efficiently and timely.
• Use VSTO to create Word and excel documents for reports and mailing letters to customer.
• Worked with Telecommunication Billing and Invoice Reconciliation Systems.
• Use share point server 2007 to create workflow and to manage development related documents.
• Developed Stored Procedures in MS-SQL Server 2005. Also involved in the performance optimization of existing database objects.
• Developed test specification, test plan, test cases and test report.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Enhanced the performance of the company’s Oracle environment by providing advanced database tuning and performance monitoring and coding standards.
• ETL Process Maintenance feed (daily, weekly, and monthly) from to Host to Oracle/SQL using NDM and Informatica and SSIS.
• Database Maintenance and Administration including back-up, recovery plan (SQL 2000/2005/2008 )
• Rewrite VB6 application to .Net one, and for sometime use CCW, to use business logic COM components wit callable wrapper.

Environment: Microsoft .NET Framework 2.0, MVC, ASP.NET, ADO.NET, C#, VB6, CCW, VB.Net, Microsoft SQL Server 2005/2008, Oracle 10g, DB2, SSIS, SSRS, VB Script, JQuery, VSTO, JSON, TSQL, CRM, JavaScript, Toad, NDM, Informatica, Chart FX, XMLPDF, XML SPY (Altova), Microsoft Visual Studio 2005/2008/2010, SQL Server Reporting Services, Unit Testing, Microsoft Team Foundation Server, Microsoft Visio 2003.

Confidential, CT Sr. Software Engineer

Responsibilities:

• Developed an application which will upgrade data and database from Ikonisys20 version database to Ikonisys21 with converting related images using SSIS, C# and WinForms.
• Worked as a team member to enhance and supporting Ikonisys Image Viewer.
• Did routine performance tuning slow queries.
• Code new objects (programs) to meet the requirements.
• Worked on Web Page design to meet the requirements.
• Worked with java script, AJAX, master pages, style sheets, and themes.
• Design transactional and dimension databases to meet the requirements.
• Developed SQL 2005 reports as per user requirements.
• Developed test specification, test plan, test cases and test report.
• Did requirements gathering and analysis and system design with Altova UModel (UML).
• Extensive experience with UML using Business Process Diagrams, Flow Charts, Context Diagrams, Use Cases, Use Case Diagrams, Sequence Diagrams.
• Developed necessary Data Transformations packages (SSIS).
• Strong SQL Server Development skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types.
• Experienced in Database Tuning and Performance Monitoring.
• Created a database access layer component. This made application independent from backend database.
• Create necessary reports using SQL 2005 Reporting Service for researchers and trained then to use it.
• Maintained and Administered Database including back-up, recovery plan (SQL 2000/2005/2008 ).
• Create online reports and dashboard applications for different applications using SSRS and provide users training to use those reports efficiently and timely.
• Developed Biology “Sample Management System” application.
• Use VSTO to create Word documents for reports.
• Use share point server 2007 to manage development related documents.
• In all development and maintenance work, I have to strictly follow FDA rules and regulation.

Environment: C#, Visual Studio 2008, Visual Studio 2005, ASP.Net 2.0, ADO.NET, SharePoint, Visual Studio, JavaScript, WinForms, Webform, Team Foundation Server, VSTO, Remoting, Design Patterns, Agile Methodology, and Test-Driven Development, NUnit Unit Testing SQL Server, TSQL, XML SPY (Altova), NHibernate, SSIS, Analysis Service, UML (UModel), SVN.

Confidential CSSD Wethersfield, CT

Senior Developer

Responsibilities:

• Developed a new CMIS (Case Management Information Services) Web Application, GUI, Web Service and Database and WinForms application to administrate the application. (Convert ASP classic application to ASP.Net application)
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Worked on Web Page design to meet the requirements.
• Developed test specification, test plan, test cases and test report.
• Worked with java script, AJAX, master pages, style sheets, and themes.
• Used active directory to authenticate application user.
• Used database tuning and performance monitoring with a special emphasis on web based server
• Create SSIS to import data from Host system.
• Database Maintenance and Administration including back-up, recovery plan (SQL 2000/2005/2008 ).
• Optimize the existing SQL quarries too faster search.
• Experience in UML using Business Process Diagrams, Flow Charts, Context Diagrams, Use Cases, Use Case Diagrams, Sequence Diagrams.

Environment: VB.Net, Visual Studio 2005, ASP.Net 2.0, SharePoint, ADO.NET, JavaScript, AJAX, WinForms, Webform, Visual Studio, Web Service, Team Foundation Server, Design Patterns, NUnit Unit Testing, SQL Server, Oracle, TSQL, SSIS, Altova UModel (UML), MS Source Safe.

Confidential IA Senior Application Developer (Consultant, Team lead)

Responsibilities:

• Developed web application for new pool(5th) for under 65 age group BCBS customers (Convert ASP classic application to ASP.Net application with C#, and use COM+ with wrapper class)
• Upgrade some middle tire business logic COM+ component to C# component.
• Develop Stored Procedures, Views, Functions (UDF), Views, Joins and Sub queries to enforce the business rules.
• Developed Business Rules, Web Services (middle tire)
• Worked on Web Page design to meet the requirements.
• Worked with java script, AJAX, master pages, style sheets, and themes.
• Experienced in Database Tuning and Performance Monitoring.
• Use SharePoint site for development activities.
• Create online reports and dashboard applications for different applications using SSRS and provide users training to use those reports efficiently and timely.
• Created necessary SQL server objects and store procedures and use SSIS package to transform data.
• Developed test specification, test plan, test cases and test report.
• Extensive experience in Object Oriented Analysis and Design (OOAD) techniques with UML using Business Process Diagrams, Flow Charts, Context Diagrams, Use Cases, Use Case Diagrams, Sequence Diagrams.
• Maintained and Administered Database including back-up, recovery plan (SQL 2000/2005/2008 ).
• Helped other team members on critical issues.

Environment: C#, ASP.Net2.0, ADO.NET, VisualStudio2005, SharePoint, Webform, Web Service, Design Patterns, Team Foundation Server, Visual Studio, VSTO, JavaScript, AJAX, Unit Testing, SQL Server 2005/2000, Business Objects, PL/SQL, TSQL, SSIS, UML (Visio), Team Foundation Server, MainFrame, SharePoint, VB, Com+.

Confidential

Des Moines, IA

Senior Application Developer (Consultant) Streamlined Sales Tax Project.

Responsibilities:

• Developed two new application needed for Iowa Revenue Department to manage tax data and maintain existing applications.
• Requirements gathering and analysis; developed Data Transformations packages DTS and SSIS) to transform data from flat file to SQL server and SQL Server to Host.
• Worked on Oracle environment by providing advanced database tuning and performance monitoring and coding standards.
• Worked with java script, AJAX, master pages, style sheets, and themes.
• Responsible for creating COM Components using ActiveX DLLs and for creating database and database objects like Tables, Stored Procedures, Views, Triggers, Rules and functions.
• Developed necessary reports with SQL reporting service as per requirements.
• Developed test specification, test plan, test cases and test report.
• Managed releases, through development, and production servers.
• Used Active Directory and LDAP to authenticate user.
• Extensively worked on UML using Business Process Diagrams, Flow Charts, Context Diagrams, Use Cases, Use Case Diagrams, Sequence Diagrams
• Design and develop and administrate Streamlined Sales Tax Iowa portal
• Create online reports for different application using SSRS and provide users training to use those reports.
• Convert some of the Classic ASP Application and ActiveX component to .Net application and component.

Environment: VB.Net, C#, ASP.Net, ADO.NET, Visual Studio 2005, SharePoint, Webform, Web Service, JavaScript, AJAX, Win Form, Team Foundation Server, Design Patterns, VSTO, Altova UModel (UML) & XML Spy. Unit Testing, SQL Server 2005/2000, Oracle, Business Objects, PL/SQL, UML (Visio), BizTalk, MS Source Safe, Main Frame, VB, Classic ASP. ActiveX, COM, COM +, TSQL, SQL Reporting service.

* Some of the new development is done by C# and all VB application and ASP website are upgraded by VB.NET.

Confidential CA Lead Consultant

This project to develop intra net Child/Family Welfare Information System application for Children Family Health department to manage family HELP Check Issuance System. The CA counties are using a IBM Main-Frame system called CASE-DATA, that system will discontinue from Jan 2006, Fresno county decide to develop their own intranet application, and this is what he developed. Which interact with Oracle Financial (to manage finance) and People Soft to manage checks.

Responsibilities:

• Requirements gathering and analysis;
• Designed detailed system architecture and design and development document with Visio and UML.
• Developed a .net intranet web application (GUI, Windows and Web services, related database) with all and more functionality than CASE DATA system.
• Worked with java script, AJAX, master pages, style sheets, and themes.
• Designed and developed web services to interface with People Soft.
• Enhanced the performance of the company’s Oracle environment by providing advanced database tuning and performance monitoring and coding standards.
• Developed necessary reports with Crystal reports as per requirements.
• Developed test specification, test plan, test cases and test report.
• Worked on Web Page design to meet the requirements.
• Developed some utilities classes/ services such as validating user in Active Directory, get city and state from zip codes, and get corrected address (Which get correct address from USPS online).
• Developed Stored Procedures, Functions, Views & Triggers to enforce the business rules.
• Worked on Business Process Diagrams, Flow Charts, Context Diagrams, Use Cases, Use Case Diagrams, Sequence Diagrams using UML.
• Coordinated tester and testing and manages releases, through development, testing and integration, and pre production servers.

Environment: VB.Net, C#, ASP.Net, ADO.NET, JavaScript, AJAX, Visual Studio 2005, BizTalk, Web Service, Win Form, Unit Testing, Oracle, Business Objects, PL/SQL, ActiveX, UML (Visio), MS Source Safe, TSQL, Crystal Report.

* All developments are with VB.Net except middleware components are written with C#.

Confidential NC Senior .Net Developer (Consultant)

Selected Project: Task Management web application, by which manager can monitor and manage the tasks assigned to the employee and also employee can monitor and edit their own tasks with automated email to employee when assign a new task to them and email to manager when status changes of any task. It’s an excellence piece of work, cutting edge, automated, and modern application. Experienced in Database Tuning and Performance Monitoring. Worked on Web Page design to meet the requirements. Used with java script, AJAX, master pages, style sheets, and themes.

Environment: C#, ADO.NET, Visual Studio 2003, SQL Server 2000, MS Source Safe, TSQL, ASP.Net, JavaScript, Ado, Unit Testing, Main Frame.