Career Objective:

To be associated with a progressive organization that would give me scope to apply my knowledge and skills abreast with least trends and be a part of the team that dynamically works towards the growth and thereby gain satisfaction in all aspects in the process.

EXPERIENCE SUMMARY:

• Having 9 years of experience in design and development of business applications using Client Server Applications and Internet technologies.
• Developing DTS SSIS ETL packages and SSRS Reports in SQL Server 2000/2005/2008.
• Having hands on experience on Infosphere Data stage framework.
• Developing web applications using Visual studio 2005, 2008 and 2010.
• Having 5.6 Years experience in SQL2000/2008 SSIS/DTS and SSRS
• Having 3.6 Years experience in Microsoft .NET Technologies.
• Balanced exposure to Analysis, Design, Development, Testing and Documentation.

TECHNOLOGY SKILLS:

• GUI's : VB6.0, Visual Studio 2005/2008/2010
• Database : Oracle 11i, SQL Server 2000/2005/2008
• MSBI Technologies : DTS, SSIS SSRS and Infosphere Data stage
• Internet Technologies : ASP.Net, C . Net, VB.Net, WCF, HTML, JavaScript, VBScript, ASP3.0 and IIS
• Platforms : Windows 2000, Windows NT 4.0 and Windows95/98
• Database Connectivity : ADO, ADO.NET, OLEDB and ODBC
• Tools Packages : Crystal Reports 8 and MS-Office
• Design Tools : Enterprise Architect EA and UML2.0

PROJECT DETAILS:

Confidential

Role : Requirements gathering, Analysis, Designing HLD's LLD's , coding and Testing

Environment: C . NET, VB.NET, SQL Server2008, SSIS Packages, Windows 7.

Abstract: Dollar Thrifty Automotive Group is a Car Rental service provider in United States. Fast Lane Control Files is a web application in which the business user has to feed information like Brand, location, Address, Option Codes, Class Code, Primary Rate and Weekly Rate etc. to set up a new location to extend the business to other locations. Business Users are categorized into 10 Groups, Each Group has to Login to their corresponding Pages to Complete the Location Set Up information. After Completed Location Information it needs an approval from Admin Team to complete the Location Set up Process. This Application used to keep track of all Groups who has completed their Location set up Information and sends an emails to the Respective groups if it is pending for Completion through SSIS Job.

Responsibility:

• Create and Support of SSIS Packages in SQL 2008 server and Monitoring SQL Jobs and Interfaces Data analysis, Analysis of SQL Reports, Forms and Interfaces pertaining to SQL2008. Performance/Fine tuning the programs/processes
• Project Performance Analysis and Reviews checkpoints, Data Integrity Checks
• Creating SSRS Reports in SQL2008 server
• Support of bug fixes and Production Support issues
• Review BRD documents and seek for clarifications
• Review of Test cases and Execution Cycles-Onsite Offshore Coordination
• Coordinating with business teams

Confidential

Role : Requirements gathering, Analysis, Designing HLD's LLD's , coding and Testing

Environment: C . NET, VB.NET, SQL Server2008, SSIS Packages, Windows 7.

Abstract: EAS application is designed for employees of EMC. It mainly deals with efforts tracking of the EMC employees. The application is personalized for different countries. End User of an EAS application can be an Employee or a Manager or an Administrator. Depending on the role of the employee, the access rights for different functionalities are limited. The following are the various modules of EAS application.

• User And Address Management
• Time Management
• On call Management
• Vacation Management
• Sickness Management
• Travel Management
• Service time planning
• Planning Tool
• Payroll

Responsibility:

Involved in Requirements gathering, Analysis, Coding, Reviews and Ticket Reduction Initiatives

Confidential

Role : Requirements gathering, Analysis, Designing HLD's LLD's and coding

Environment: C . NET, ASP.NET 3.5, WCF, SQL Server2008, SSIS Packages, JavaScript, UML 2.0, Enterprise Architect EA , Windows XP.

Abstract: The route and schedule information for the state of Victoria is currently maintained in a number of databases managed by Metlink and numerous departments within the DOT. The key issue with this is the same data is held in different databases and also it is not synchronised causing confusion for management and reporting.

• Data is provided once for use by multiple entities, e.g. For route and master schedule, the Operators provide data to one source i.e. the Master Database.
• All databases requiring common data, receive their data from the one source, i.e. the Master Database
• A data dictionary is developed and maintained for the Master Database

Responsibility:

Requirements gathering, Analysis, Designing HLD's LLD's and coding

Confidential

Role : Requirements gathering, Analysis, Designing, Coding, Review

Environment: VB. NET, ASP.NET, SQL Server2005, SSIS Packages, JavaScript, Windows XP.

• There are many advantages to arranging funeral, cremation or cemetery services in advance with a Dignity Memorial provider.
• Dignity Planning has attempted to make the process as easy to complete and understand as possible. Planning your final wishes is a very important and sensitive step towards relieving your loved ones of the burden of having to guess what you may have wanted.
• Abstract: Dignity Memorial funeral and cremation providers lead the industry with end-of-life options and benefits. One of the most important objectives of Dignity Memorial providers is to offer extensive grief support and encouragement to families who have experienced the loss of a loved one. Below you will also find helpful information relating to our Community Outreach Programs as well as other important resources.
• Users protect their family from having to make such decisions at a difficult time.
• To make User wishes known to your loved ones.
• To make User own decisions about the type of service, merchandise and price.
• You prevent emotional overspending by family members who can only guess what user might have wanted.
• User funeral, cremation or cemetery prearrangement is transferable to other Dignity Memorial providers in 41 states and seven Canadian provinces if you move.
• Users to lock in today's prices for services that may not be needed for many years.

Responsibility:

Requirements gathering, Analysis, Designing, Coding, Review and Testing

Confidential

Role : Requirements gathering, Designing, Coding

Environment: C . NET, ASP.NET, SQL Server2005, JavaScript, Windows XP.

• Abstract:The scope of the application is to manage the content uploaded by the Talent/Film Maker and generate the Cards ordered by the End User, process it and deliver them as per the schedule based on a pre-determined set of processes.
• An Admin or a User with privileges can create the user types pre-determined in the Outcast Portal. All the activities performed on a user for creation/updates/changes are handled in UM User Management .
• FM upon registering with Outcast starts uploading the content once the access rights are provided by the admin.
• Once the content is uploaded the rest of the card management and maintenance is done by the CMS Content Management System . The content validation is purely in the hands of the CMS.
• The content is validated by the Outcast Staff. The content is saved into categories based on predefined values and names. This content is prepared for viewing on the User/Shop Sites and the cataloguing is done also based on available category classes.
• The delivery is made after payment confirmation in case of billed cards.
• In case of free cards, the card is directly sent for delivery.
• The whole process is performed in the OM Order Management .
• The CMS Content Management System status i.e. Card is approved/published/no. of cards purchased can be viewed by the FM.
• The end-user/customer browses through the cards on the user site and places orders for the cards to the desired recipients. He/she enters the personal details along with the card details for further correspondence. A user can also register with a Shop in Outcast. All the details pertaining to the user will be managed in the CMS Content Management System and the corresponding order and delivery details will be handled and processed in the OM Order Management .

Responsibility:

Requirements gathering, Analysis, Designing, Coding, Review and Testing

Confidential

Role : Requirements gathering, Designing, Coding

Environment: C . Net, ASP, SQLServer2000, Crystal Reports7/10, Windows 2000.

• Abstract: EPIC: The project provides issuing EPICs in Andhra Pradesh to everyone. The overall strategy for implementation of the programme of preparation and distribution of EPICs to cover both the residual electors in the current roll and new electors. It's integrated with the Computerization of a unique EPIC number will be allotted to every elector that will remain valid through the lifetime of the elector and even thereafter will not be re-used. The database of electors maintained in the Computerization of electoral rolls will be expanded to include the EPIC details. Chief Election Officer of the State, State Level Agency SLA , Vendors, District Election Officer and Mandal Revenue Officers uses the program. Vendors allot the Polling Stations to Designated Photography Locations DPL for capturing and issuing EPICs.
• ERoll: This provides valid Mother Roll Draft for all electors in the state. For every year CEO should change the ERoll like supplementary I, supplementary II etc. It's going to be changes for add new electors, Modifications in the existing ERoll and deletion for expired citizens.
• Registration: The web based application will provide on-line Registration for new electors, Modifications in the existing electors and deletion for expired electors from the ERoll. The Election Representative Officer ERO will give the list to change the ERoll details to MRO's after made through the physical verification what he received in the e Registration. This web site shows the CEO office details and daily activities.

Responsibility:

Requirements gathering, Analysis, Designing, Coding, Review and Testing

Confidential

Role : Requirements gathering, Designing, Coding

Environment: ASP.NET, C .NET, SQL Server 2000, Crystal Reports10, JavaScript, Windows NT/ 2000.

Abstract: This Project maintains on line transaction information of Micro Irrigation project of Andhra Pradesh. The farmer applied for micro irrigation drip/sprinkler system to Project Director Office mentioned either loanee or Non-loanee. A loanee application goes to concerned banks for scrutinization and comes to PD Office after scrutinization. PD Office handed over to MI companies for BOQ preparation. MI companies survey the land of farmers and send the details to PD's office. PD office sends loanee applications to banks for final sanction. After received all the details from banks it's giving the orders to MI companies to install the Micro irrigation system at farmers land

Responsibility:

Requirements gathering, Analysis, Designing, Coding and Testing