? 10 years of experience in analysis, design, development and implementation of Client/Server, 3-Tier and Web Applications. ? Expertise in designing and developing applications using the Windows DNA Architecture. Implemented the Presentation Layer (Windows and Web Forms), Business layer (COM and COM+ Services) and Database Layer. ? 5 years of experience in .NET Framework and .NET technologies. ? Strong hands on experience in C#, VB.NET, ASP.NET, ADO.NET, Visual Basic 6.0,VBA, VBScript, JavaScript, HTML,XML, ActiveX, ADO, RDO and MS-IIS,VS2005. ? Very strong in Object Oriented Analysis and Designing (OOA and OOD), Object oriented programming (OOPS) including .NET Remoting,. ? Expertise in SQL Server 2005 such as SSIS, T-SQL, Stored Procedures, Views, Triggers. ? Expertise in Oracle database, PL/SQL, SQL*Loader, SQL*plus, packages, procedures, functions, triggers. ? Involved in all the stages of Software Development Life Cycle including Requirements, Analysis and Design, implementation, integration, testing, deployment and maintenance. ? Experience in developing UML diagrams including Use Case diagrams, Class diagrams, interaction diagrams, State diagrams and deployment diagrams by using Microsoft Visio and Enterprise Architect. ? Hands on experience in writing effective Use Cases. ? Functional experience includes Employee Benefits, Health Care, Financial Accounting, Enterprise Resource Planning, Web based and B2B applications along with excellent communication, analytical, teamwork and Interpersonal Skills. ? Actively work with customers to analyze business needs, gather and document business and system requirements. ? Strong knowledge in ERP System Design, Development, Implementation. ? Experience in Unit Testing, UAT and deployment of windows and web applications. ? Team player with an infectious positive attitude and strong communication skills.
EDUCATION
Bachelor's Degree in Computer Science from Mhd.Sathak College of Arts and Science.
Professional Diploma in Software Technology and Systems Management (PTM) from NIIT Ltd.
SKILLS
High Level Languages: C#, VB .Net, Visual Basic 6.0/5.0, C++, C and Java 2.0.,Visual FoxPro 5.0,Power Builder. Server Technologies: ASP, ASP.NET, JSP, Servlets Web Technologies : HTML, VB Script, JavaScript, XML, DHTML, IIS,Webservices Database: SQL Server 2000/2005 , Oracle 9i /10 G, MS Access, Sybase Software / Tools : SSIS,DTS,FarPointSpreadSheetControl,CrystalReports9, CrystalReports.Net, Erwin 3.5.2,MS Visio 2003,MS Office 2003 Operating Systems : Win NT 4.0, Win 2000,Win 2003, Win XP Version Management Tools : Windows Team Foundation Server, Visual Source Safe, Serena Version Manager, Merant Tracker, MKS Client.
PROFESSIONAL EXPERIENCE
Project Profile:
Catalina Marketing Corporation, Florida Aug 08 -- Dec 08 Sr. Programmer Analyst / Team Leader
Catalina Marketing is the global leader in behavior-based marketing solutions, providing brand manufacturers, retailers and healthcare providers with targeted marketing solutions to meet growth objectives. Utilizing a sophisticated database, Catalina Marketing enables the users to reach consumers and patients with precision targeting on a truly mass scale.
Responsibilities:
* Support and customize the existing .Net 2.0 and Visual Basic 6.0 applications. * Worked on enhancement projects for the existing .Net applications. * Created .Net applications to import data from Excel sheet to the Oracle Database to create links for business needs, this was developed using two layers (GUI and web services for the actual import of data.) * Converted .Net 2.0 applications to .Net 3.0. * Created Program specification, Test cases and data flow diagrams for the existing and new applications. * Designed Data Modeling for the new .Net Applications. * Involved in the Review of Low Level and High Level Design. * Responsible for Object Modeling and Object Relationship Diagrams. * Extensively involved in requirement study, coding, testing and implementation. * Conducted knowledge transfer sessions with the offshore team. * Successfully coordinated with offshore Team in India for development and delivery. * Created Technical/Functional documentation for the existing and new .Net Applications.
Environment:
VB.Net 2005/2008,C#,IIS 5.1, Visual Basic 6.0,Oracle9i, Microsoft Office 2003, Microsoft Visio 2003, Team Foundation Server,Serena Version manager, Merant Tracker.
Magellan Health Services, Earth City, Missouri Jan 08 -- July 08 Sr. Programmer Analyst / Team Lead
Magellan Health Services is the nation's leading specialty health care services organization, managing behavioral health, radiology and specialty pharmacy services for government agencies, health plans and corporations. Magellan offers access to high quality, clinically appropriate, affordable health care, tailored to each individual's need, while managing costs responsibly for their customers.
Informa Relocation: Migration project from SQL Server 2000 to SQL Server 2005. Edi-Automation: Enhancements to the existing .Net Application.
Responsibilities:
* Worked on enhancement projects for the existing .Net application (Edi--automation), which automates the Auth data extraction process and sends to different clients based on FTP/HTTP/SFTP protocols. * Worked extensively in the migration process of Existing DTS Packages to SSIS jobs. * Extensively worked in Data Analysis and correction through DTS jobs. * Conducted Knowledge Sharing sessions for SSIS packages. * Involved in coordinating with team members to discuss and implement different methods to improve the project performance and securities. * Involved in creating technical and user documentation. * Involved in testing and debugging of SSIS jobs. * Used XML based Web Services.
Environment: VB.Net 2005,C# ,Asp .Net 2.0,SQL Server 2000,SQL Server 2005,SSIS,DTS, Microsoft Office 2003, Microsoft Visio 2003, Visual Source Safe,PGP Keys, MKS client, Windows Share Point Portal server 2003.
CUNA MUTUAL GROUP, Madison, Wisconsin Jan 2007 -- Jan 2008 Sr. Programmer Analyst / Team Lead
The CUNA Mutual Group is the leading provider of financial services to credit unions and their members worldwide, offering lending, protection, financial, employee and member solutions through strategic partnerships, technological innovations and multiple service channels. The mutual insurers of the CUNA Mutual Group are owned by their policyholders and operate to serve their best interests.
Web Vision II
This project is a migration project from Main Frame to .Net 2.0.They are currently in the process of digitizing the Employee Benefits domain which takes cares of the Retirement Solution Plans across all credit Unions. Worked specifically in Deposits and Transfers work streams as part of the Retirement solution domain.
Responsibilities:
* Worked on Requirement Analysis. * Conducted Knowledge Sharing sessions. * Responsible for Object Modeling and Object Relationship Diagram. * Created Sequence Diagram for Deposits and Transfers Work stream based on the Requirement analysis. * Designed Data Modeling for Deposits and Transfers work streams. * Developed Data Dictionary as part of Data Modeling. * Prepared Process Flow Diagrams. * Involved in writing Program Specifications for complex scenarios in work streams. * Non Functional Requirement Gathering. * Involved in designing the Batch Process for Deposits and Transfers Work streams. * Estimation of Development efforts till code drop. * Involved in the Review of Low Level and High Level Design. * Successfully coordinated with offshore Team in India for development and delivery. * Conducted Knowledge Tranfer sessions with the Offshore Team. * Extensively involved in the coding for Batch Process operations. * Extensively involved in writing Stored procedures and Triggers.
Environment: VB.Net 2005,C#,SQL Server 2005, Microsoft Office 2003, Microsoft Visio 2003, Team Foundation Server, Visual Source Safe, Windows Share Point Portal server 2003.
CPA2BIZ, Santa Clara, CA Jan 2006 -- Jan 2007 Sr. Programmer Analyst / Team Lead
CPA2Biz is a business Partner of AICPA. They build and maintain websites for AICPA.
Responsibilities:
* Worked on enhancement projects for AICPA.org. * Designed and developed user friendly navigation system using ASP.NET and JavaScript. * Worked on Content Management Server to configure templates for CSC websites. * Developed SQL Server stored procedures and triggers. * Worked on production issues. * Designed and developed database and program (C#, SQL Server) for polling application. * Maintaining website on SharePoint 2003. * Developed administrative application to track the data using C#.Net Web Forms * Configured ASP.NET Web.Config file for the entire web application. * Involved in debugging legacy ASP and ASP .Net code in a complex environment. * Developed Web forms using ASP.net. * Used C# using code behind. * Used Ado.net for interaction with database. * Utilized Visio 2000 for developing flowcharts and data flow diagrams of the modules developed. * Converted non secure pages to secure pages using SSL communication. * Working with MS Office, SQL Server 2005, VB.Net, C# CMS 2000, MS Share Point 2003. * Share point server was used for maintaining the documents. * Used XML based Web Services.
Environment: C# .Net, ASP.Net, ASP 3.0, VB Script, JavaScript, XML, XSL, SOAP, HTML, ADO .Net, SQL Server 2000, Microsoft Office 2003, Microsoft Visio 2003, Windows 2003, IIS 5.1, Visual Source Safe, Accurev 4.0.1 , XML Spy, Windows Share point portal server 2003.
Digitech Solutions Co Ltd., Mauritius
Billabong Group of Companies, Mauritius Feb 2005 -- Nov 2005 Team Leader
Sports wear and Casual Cloth Manufacturer.
As Dot Net/SQL Server programmer designed and developed a Reporting Tool in Microsoft SQL server 2000. I was also involved in developing Automation 2005, an automation tool that automates the daily activities of the company.
Responsibilities: > Involved in requirement gathering and Object Oriented Analysis. > Used ADO.Net to connect to the SQL Server 2000. > Designed and developed a Meta data driven reporting tool to generate reports, similar to Analysis services cubes, to compare with the existing reporting tool for Quality Assurance Team. > Used SQL Server 2000 authentication to authenticate the user and table level permissions are maintained using the SQL server 2000 user permissions. > Involved in implementing a cost effective tool which can be used as a Bug tracking software. > Involved in coordinating with team members to discuss and implement different methods to improve the project performance and securities. > Involved in creating technical and user documentation. > Used CVS for Version control and for source code check-in. > Used XML to transfer data between the application server and the SQL server 2000 database. > Microsoft Excel Pivot table was used to display reports to the client. > Performed the Unit Testing, Functional testing, Integration testing and System testing. > Modified existing code for code reusability and also to improve the performance. > Involved in enhancing the performance of the Project. > Extensively used Microsoft Visio 2003 for creating technical documentation.
Environment: VB .Net, ASP.Net, JavaScript, XML, XSL, SOAP, HTML, ADO .Net, SQL Server 2000, Microsoft Office 2003, Microsoft Visio 2003, Windows 2003, IIS 5.1
Sotravic Limitee, Mauritius Jan 2004 -- Jan 2005 Team Leader
This project is to automate the day-to-day activities of the company and its construction sites. It includes Plant management, recruiting, termination, leave management, Finance and Pay roll management. This system also generates reports for auditing and Income tax calculations.
Responsibilities: > Developed Client/Server application and 3-Tier application to keep in track of tasks such as file maintenance, Ticketing, Report generation, delivery schedules of the Plant Equipment. > COM port communication was done for interfacing with the Digitizer, which was used to weight the trucks > Performed business and system analysis, designed in UML the structure of three-tier solution, defined the hierarchy of classes to incorporate the business logic and implemented key components using COM+ architecture as ActiveX DLLs in MS Visual Basic 6.0. > Created Web Forms using ASP.NET, MS Visual Studio .NET, C#, VB.NET, XML, VBScript, HTML, DHTML and JavaScript > To improve the performance a copy of the data was saved on the local computer in MS Access for quick report generation and a copy of the data is saved in the SQL server located in the Head Office > Extensive use of crystal reports for generating various reports depending on the user requirement > Developed Stored procedures for insertion of new record set in the MS SQL Server. > Developed components using Visual Basic that are used by the application to access the database and implement the business rules. > Focus on minimum memory wastage and overall performance of the System > Designed reports for auditing, income tax calculations and payroll using Crystal reports. > Coordinate with the QA Team for Unit Testing and Integration Testing of different modules. > Maintained the application, added new features and generated new reports. > Developed FAQ/Help by using HTML Workshop
Environment: C#, ASP.NET, Visual Basic, VBScript, ASP, IIS 5.0, VS InterDev, VSS, MS SQL Server 2000, COM+
Pearl Beach Resorts, Mauritius Aug 2003 -- Dec 2003 Sr. Programmer Analyst
This project is the add-on for the Hotel management software developed in VB6.0. This is used for the customers to reserve hotel rooms Online. We have Used Pay pal for Online Payment (Credit Card processing).
Responsibilities: * Involved in Requirement Gathering * Participate on Database Design * Database Programming * Responsible for Module Integration
Environment: HTML, ASP3.0, CDONTS MAIL, SQL server 7.0, VB6.0, Windows 2000/XP
IBL Pharmaceuticals, Mauritius Jan 2003 -- July 2003 Sr. Programmer Analyst
It's a retail management package developed for Pharmacies located around the Island for IBL group of companies. * Inventory * Purchase *Goods Receipt * Sales * Employee Payroll * Inventory includes, stock maintenance with multiple warehouse maintenance and stock evaluation and corresponding reports. * Purchase includes raising PO, PO amendment and vendor evaluation. * Goods receipt includes, GR against PO, Stock movement to inventory and movement to warehouse. * Sales include Invoicing, Cash Register Monitoring. * Employee Payroll includes Employee maintenance, attendance, leave approval, late approval. * Responsibilities include Requirement Study, Development, Testing, and Implementation & Training.
Environment: Windows 2000/XP, MS SQL Server7.0, VB6.0, Crystal Reports 9
Maars Software International Ltd., Chennai, India.
MAARSMAN is a comprehensive integrated ERP solution for enhanced operational efficiency of manufacturing industries. MAARSMAN employs client server architecture and offers GUI front end. MAARSMAN has unique query features like Security, General-purpose enquiry and on line help, Menu Management. With wide experience in manufacturing systems MAARS has developed an integrated manufacturing solution called MAARSMAN. It enhances the operational efficiency through meeting the information needs of the business with more than 15 functional Modules. It supports various databases like Oracle 8i, MS SQL 7.0 and MS Access. The modules are seamlessly integrated and are designed for easy customization to match specific Industry/customer requirements. This package is suitable for Medium and large size industries. There are over more than 50 MAARSMAN sites in India.
As a Team Leader, I was responsible for the entire SDLC Cycle:
* Design & Development: Front-end: VB 6.0, Back-end: MS SQL Server 7.0/Oracle 8i * Unit test plan, Integrated Test Plan, Code review. * Unit testing, Defect log, Module testing, Integrated testing. * Final inspection report, Program release report. * Product delivery note, Configuration audit, User acceptance. * Back up log, Repository & CPMS ( Project Monitoring Tool )
Environment: Windows NT 4.0/2000/XP, Oracle 8i,MS SqlServer, Visual basic 6.0 / 5.0, Far Point Spread sheet List of Maars software Client sites where I have implemented the ERP.
Bhilai Engineering Corp. Ltd., Bhilai Dec 2001 -- Dec 2002 Team Leader
IFB Industries Ltd., Goa Jun 2001 -- Nov 2001 Senior Software Engineer
STAHL India Ltd., Chennai Jan 2001 -- May 2001 Senior Software Engineer
Alstom Industries Ltd., Chennai Sep 2000 -- Dec 2000 Senior Software Engineer