CAREER OBJECTIVE:

To grow and prosper along with a professionally managed organization that provides challenging opportunities to work on in the field of application development / maintenance alongside a team of dedicated and passionate people.

CAREER SUMMARY:

• 13 years of experience in Trackwise, .Net and SQL
• Hands on Experience on developing web applications using Trackwise, C#.NET, ASP.NET, ASP 2.0 SAP.Net connector and Crystal Reports
• Hands on Experience on designing database and creating database objects like Tables, Stored Procedure etc.
• Proficiency in Query Optimization, performance tuning and monitoring using SQL Profiler.
• Proficiency in Developing/Deploying SSIS Packages.
• Knowledge on developing reports using SSRS.
• Worked on Applications having in Multi - tier Architecture, Design and Programming.
• Good experience in Analyzing, Designing, Development and Implementation of real time business applications in a wide range of client server environments with good understanding of the full Software development life cycle.
• Good Knowledge in Analytical and Programming Skills.
• Quickly adapting to new Technologies.

TECHNICAL EXPERTISE::

C#.NET, VB.Net, Java Script and ABAP. : ASP.NET , ADO.NET and HTML.: Framework 1.1/2.0 : SAP .NET Connector, Crystal Reports, Trackwise , Visio, Remedy and Toad.: SQL Server 2000/2005, SSIS, SSRS and Oracle 9i , 10g .

WORK PROFILE:

Sr. System Analyst

Confidential, Waukegan, IL

Environment: Trackwise, Crystal Reports, Oracle 11g Application Name: SolTRAQs and SPECTRIS

Responsibilities:

• Gather requirements from customer and document the chant request form customer
• Create change request and make configuration changes based on requirements
• Develop query for Ad-Hoch reports requests from customers
• Support Trackwise application by processing access request and selection values Make changes / fix bugs in crystal report Plan and track the project delivery Perform resource planning Evaluate performance and make recommendations for promotions and salary revisions.
• Evaluate Team knowledge / skills and make recommendations for Trainings

Confidential, Andover, MA

Environment: Trackwise, C#.Net, Crystal Reports, Oracle 10g

Responsibilities:

• Manage the team and distribute the work load to the developer to day to day deliverables to the client.
• Responsible for communication, including status reporting, risk management, escalation of issues that cannot be resolved in the team, and, in general, making sure the project is delivered on schedule, and within scope.
• Plan and track the project delivery.
• Providing project management expertise to the team.
• Perform resource planning.
• Manage recruitment and release of Confidential personnel for the project.
• Evaluate performance and make recommendations for promotions and salary revisions.
• Evaluate Team knowledge / skills and make recommendations for Trainings
• Review new projects and provide recommendations for solutions

Confidential

Environment: Trackwise, C#.Net, Crystal Reports, Oracle 9i

Responsibilities:

• Manage Day to day deliverables Manage Resource planning and Publishing shift roosters Involve in New project proposal Involve recruitment and release of Confidential personnel for the project
• Involve Audits and make sure for the quality deliverables Creating WMP/SMQ in Cognizant2.
• Creating and maintaining project startup documents like BCP/ SCM/Resource / Training / Infrastructure/ Defect Prevention / Decision Making / SPP Plans
• Responsible for communication, including status reporting, risk management, escalation management

Confidential

Environment: SQL SERVER 2005, SSIS. C#.NET, ASP.NET.

Responsibilities:

• Collecting the user requirements. Documentation of the requirements and analyzing the same.
• Actively involved designing the logical and physical architecture for database.
• Draft the Design of the application Developing the Application Coding and Rigorous Testing Creating SSIS packages to bring data from different Swipe location to a single attendance database in the required format
• Extensively worked on writing store procedures to generate the attendance data from the swipe details
• Writing Stored procedures to generate the attendance details to monthly, weekly, daily formats as per the manager-report hierarchy and as per vertical/functional groups Actively involved designing the logical and physical architecture for database

Confidential

Sr. Software Engineer

Environment: SQL Server 2000, SQL Server 2005 with Reporting Services, SAP-.NET connectors. C#.NET, ASP.NET and IIS5.0

Responsibilities:

• Involved in Database Designing Involved in creating the databases.
• Involved in Creating/developing Database Objects(Tables, Stored Procedures, View, Functions)
• Developing/Deploying Various SSIS Packages for populating the data from different Sources
• Involved in Optimizing the database objects like Queries, stored procedures, functions etc Involved in Migrating the SQL 2000 database to SQL 2005 databases
• Involved in Configuring Alerts Using Database Mails Involved in Configuring Link Servers Involved in Configuring the Replication of database objects Involved in designing the SQL Scripts for data uploading during the Production Move Involved in Production Support Involved in creating reporting using SSRS

Confidential

Environment: ASP.NET 2005, C#.NET 2005, SQL 2005.

Responsibilities:

• Collecting the user requirements. Documentation of the requirements and analyzing the same.
• Architecture Design Designing Prototype. Implementing Web forms. Coding and Rigorous Testing DB Design and implementation.
• Creating procedures and triggers.
• Maintain the developed application

Confidential

Sr. Software Engineer

Environment: ASP.NET, C#.NET, SQL 2000, SAP.NET Connector and Reporting Service.

Responsibilities:

• Collecting the user requirements
• Documentation of the requirements and analyzing the same Architecture
• Design Designing Prototype Implementing Web forms Implementing SAP.Net Connections and creating Client Proxy to update SAP Coding and Rigorous Testing DB Design and implementation
• Creating procedures and triggers Developing reports using reporting services.
• Maintain the developed application