Experience Summary

• Developed and architected Reference Data Applications for numerous Lines of business and Products, involving Sybase Data Server, Core Java
• Successfully managed multiple time critical strategic merger projects involving 1 to 4 people
• Exp rience in Microsoft .Net technologies VB.NET, C , ADO.NET.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Hands on experience in performing ETL using Informatica 9.1.0, BCP.
• Exp rience in handling production roll over tasks which involves planning and coordination between multiple teams.
• Extensive knowledge in tuning T-SQL DDL and DML queries to improve the database performance and availability.
• Expert in RDBMS logical and physical database designs with excellent Normalization and De-normalization techniques for efficient data storage and retrieval
• Experienced in Query Optimization, Debugging, Performance Tuning and Improvising performance of applications using SQL Trace and Explain Plan to analyze queries for efficient data retrieval.
• Strong knowledge in Sybase ASE 12.5/15.0 and SQL Server 2000/2005 database programming using T-SQL Stored Procedures, Built in Functions, Triggers, Cursors etc.
• Substantial focus on Project Management aspects, like capacity planning, project estimates,new project proposals and initial timeline design for last 1 year.
• Over 9 years of database development experience in Sybase/SQL Server.
• Project Lead with approximate 9.5 years of software development experience in Supply Chain Management, Trade Promotions Investment Banking.
• Extensive experience in working with geographically US, UK, Singapore Japan disparate teams and forging relationships with business, senior leadership and customers to deliver world class products.
• Experience in interacting with Business/Technology groups for analyzing and gathering business requirements.

Key Achievements

• Coaching and Mentoring Mentored new team members on application, domain and business understanding front.
• Awards Recognition Received Cognizant's Guiding Star. Received Appreciation mails from senior management client for successfully implementing Futures options Project Phase 1 2.
• Account Initiatives Created knowledge management repository for supply chain management portfolio in PepsiCo.
• Organization Initiatives Involved in validating Sybase Profiles to fulfill the onsite/offshore openings in PepsiCo.
• Strategic Thinking Created and implemented a strategic plan to rewrite the existing perpetual inventory calculation process in PepsiCo.

Technical Skills

Organization: Cognizant Technology Solutions

Confidential

Role Team Lead

• Leading a team of four inspired individuals at onshore and offshore location, to efficient successful delivery.
• Interact with business counterparts on daily basis to understand the requirement and provide solutions.
• Lead the Production Rollover tasks by coordinating with various teams in timely manner.
• Responsible for preparing technical requirement documents and get it base lined with customers.
• Responsible for migrating existing production data from DB2,flat files to Sybase.
• Responsible for complete database design of Sales admin tool
• Involved in the design of handling hierarchy changes and work flow to calculate the customers in planning level.
• Involved in development of key modules like planning/segmentation organization hierarchy changes for admin tool
• Involved in development of Sybase views to transfer data from Sybase to Oracle/CAS web services through Informatica.
• Involved in creating business test cases and assist users during their testing phase.
• Writing complex Stored Procedures and Views in Sybase to extract planning customer information.
• Optimizing the database queries objects to improve the performance.

Confidential

Role Senior Developer

Role and Responsibilities

• Understanding the requirement of the Certified Finalized Inventory in Supply Chain Management.
• Understanding the Sales extract process in Sybase and rewrite the process in Oracle.
• Involved in the design of data model and work flow to calculate the Certified-Finalized Inventory.
• Involved in the design to extract the adjustments and movements from Sybase Selling Servers to Oracle Inventory System
• Involved in the Data Model design for creating new tables, procedures, views.
• Involved in testing Database Links to ensure the performance of data transfer between Sybase and Oracle.
• Involved in Writing PL/SQL procedures.
• Writing Complex Stored Procedures and Views in Sybase to extract Sales Information
• Optimizing the database queries objects to improve the performance.
• Involved in Creating UNIX Shell Scripts and new Autosys job steps.

Confidential

Role Team Leader

Role and Responsibilities

• Leading a team of four inspired individuals at offshore location, to efficient successful delivery.
• Understanding the requirement of the F O Line of Business, along with the trade life cycle of this new product.
• Drafting the Technical Architecture of the interface for data exchange with the up-stream and downstream application.
• Coordinating the activities with the onsite team member.
• Designing Data Model for holding F O accounts.
• Designing new tables, stored procedures, triggers, views cursors.
• Writing TSQL statements for migrating data from external source into Sybase database.
• Optimizing the database queries objects to improve the performance.
• Preparing the project estimations >3000 Man-hours and milestone driven delivery plan.
• Reviewing the database schema design change and database objects
• Defining the IBML Formats International Business MarkUp Language to publish consume the reference data around F O Products.

Confidential

Role Team Member

Role and Responsibilities

• Drafting the Technical Architecture of the interface for data exchange with the up-stream and downstream application.
• Reviewing the database schema design change and the SP's.
• Optimizing the database queries objects to improve the performance.
• Unit testing.

Confidential

Role Senior Developer

Role and Responsibilities

• Designing Data Model.
• Designing Active Server Pages to accommodate new reports.
• Designing Visual Basic Macros to accommodate enhancements.
• Preparing Estimation using Functional Point Methodology
• Coordinating with onsite coordinators to collect requirements draft technical requirements
• Handling production issues and working on resolving them with request SLA timelines

Confidential

Role Team Member

Role and Responsibilities

• Coding Business Validations in database objects
• Taking ownership of the development activities end to end.
• Preparing executing unit test cases system test cases.
• Preparing Estimation using Functional Point Methodology
• Coordinating with onsite coordinators to collect requirements draft technical requirements
• Handling production issues and working on resolving them with request SLA timelines

Confidential

Role Team Member

Project Description

Role and Responsibilities

• Application Design.
• Programming in Visual Basic SQL Server.
• Client interaction for UAT support
• Preparing executing Unit test cases System test cases

Confidential

Role Team Member

Role and Responsibilities

• Application Design.
• Programming in Visual Basic SQL Server.
• Client interaction for UAT support
• Preparing executing Unit test cases System test cases