Summary:

• Application Analyst with experience of more than 6 year in System Analysis, Design and Development of complex software systems in Supply Chain management, Business Intelligence and Retail Domain.
• Very good functional knowledge of Demand Planning and Fulfillment using JDA Manugistics
• Experienced in requirement analysis, coding and testing of various modules in a software development life cycle using Agile and Waterfall methodologies.
• Hands on experience in Design, Development, Enhancement, Maintenance and Support applications in Oracle using SQL, PL/SQL,JDA Manugistics, Teradata, Cognos in Windows and UNIX environment.
• Have in depth knowledge in Oracle DB Architecture, Data Dictionary and DBMS Packages.
• Rich experience in creating and maintaining stored procedures, Oracle PL/SQL packages, functions and triggers.
• Very good experience in development and implementation of ETL using Teradata DWH tool in Star Schema including various facts and dimensions tables.
• Extensive experience in BI reporting using Cognos 7 and Cognos 8 including creating new Cubes, Reports and Packages and maintaining more than 50 Data Cubes and hundreds of Cognos Reports
• Strong knowledge in Oracle cursor management and exception handling.
• Experience in process improvement, query optimization to improve response time and Data availability to business.
• Excellent experience in Production Support while working with business.
• Excellent team player and proven track record working in various team sizes
• Good experience in UNIX environment in Maintaining and Creating new scripts and batch processes.
• Have good exposure towards normalization techniques for designing databases using RDBMS on N-Tier Architecture
• Maintaining client server applications and Developing new ones using front-end tools like Oracle Forms and Reports 6i.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Hands on experience as a Team lead, led a team of size 5 and successfully implemented the project before the given deadline with better quality.
• Working for the leading Footwear and Apparel organization The Timberland Company for more than 5 years.

Skills:

Databases - ORACLE Databases 9i and 10g Languages - SQL, PL/SQL, Forms Reports 6i, Unix Shell Scripting Front end Tools - Developer 6i Oracle Forms, Designer and Reports , JDA Manugistics,Cognos Tools/utilities - TOAD, PL/SQL Developer, SQL Developer, Teradata, Cognos7, Cognos8,JDA Manugistics, Putty, FileZilla, WinSCP, HP Quality Center, Remedy, MKS, SVN, CRON Scheduler,CRM etc

Operating System - Windows XP/7/2000, UNIX

Certification:- ITIL, NRF-PRBC

Confidential

Role Application Analyst

Environment Tools Oracle 10G, Teradata, JDA Manugistics Supply and Transportation, UNIX

Roles and Responsibilities:-

• Application Support and enhancement for various Supply chain application including JDA manugistics Supply Planning, Transportation, APO and Teradata
• Perform all the applications related roles using technologies like JDA Manugistics,Oracle, PL/SQL, SQL, UNIX, Teradata etc.
• First assignee and resolver for all the above mentioned applications issues.
• 24/7 support for all the Business and System critical issues
• Continue to provide ideas for optimization for the all the supporting application for better efficiency.
• Knowledge Transfer for all the new development work in order to continue with the optimum level of support
• Root Cause Analysis for all the re-occurring issues in order to save time and resources.
• Managing and updating all the relevant documents for all the above mentioned applications
• Resolving all issues within the given Service Level Agreement

Confidential

Role Oracle developer and Data Analyst

Environment Tools: Oracle 9i, Forms and Reports 6i, Toad, SQL Developer, UNIX, Confidential system was migrated to new VFC SAP platform in order to align all the brands.

Roles and Responsibilities:-

• Identifying all the major changes that needed to be done in order to safely remove all the North American interfaces from the Global Timberland System involving Order Management, JDA Manugistics, Procurement Rockblocks , Cognos Reporting, Data Warehouse.
• Working with various Technical and Business Teams to do a detailed Impact Analysis of all the changes
• Design Documents for all the finalized changes like Planning Routing, Purchase Info, Open Purchase Orders, Open Shipments etc. and new programs to support the migration.
• Involved in daily meetings with various teams involving senior managements as well.
• Developing Programs based on Oracle PL/SQL,SQL, Teradata SQL, UNIX for all the extracts and interface changes.
• Unit testing for all the changes.
• Involved in UAT with various business teams to support the changes.
• Be on line with all the defined time-lines as this is a very big projects including 7 different brands like Timberland, North face, vans , Jansport etc.
• Resolving all the problems and complications that arise any time during the project duration.

Confidential

Role Oracle developer and Data Analyst

Environment Tools: Oracle 9i, Forms and Reports 6i, Toad, SQL Developer, UNIX, Cognos and Teradata Entire Timberland Asia system was migrated to new VFC SAP platform in order to align all the brands.

Roles and Responsibilities :-

• Identifying all the major changes that needed to be done in order to safely remove all the Asia interfaces from the Global Timberland System involving Order Management, JDA Manugistics, Procurement Rockblocks , Cognos Reporting.
• Working with various Technical and Business Teams to do a detailed Impact Analysis of all the changes
• Design Documents for all the finalized changes and new programs to support the migration.
• Developing Programs based on Oracle PL/SQL, UNIX for all the extracts and interface changes.
• Unit testing for all the changes.
• Involved in UAT with various business teams to support the changes.
• Safe Implementation and cut-over for all the extracts and changes done.
• Post Implementation Support

Confidential

Role Oracle developer and Data Analyst

Environment Tools: Oracle 9i, Forms and Reports 6i, Toad, SQL Developer, UNIX,

the brands.

Roles and Responsibilities:-

• Identifying all the major changes that needed to be done in order to safely remove all the European interfaces from the Global Timberland System involving Order Management, JDA Manugistics, Procurement Rockblocks , Cognos Reporting.
• Working with various Technical and Business Teams to do a detailed Impact Analysis of all the changes
• Design Documents for all the finalized changes and new programs to support the migration.
• Developing Programs based on Oracle PL/SQL, UNIX for all the extracts and interface changes.
• Unit testing for all the changes.
• Involved in UAT with various business teams to support the changes.
• Safe Implementation and cut-over for all the extracts and changes done.
• Post Implementation Support

Confidential

Role Application Owner

Environment Tools: Oracle 9i, Forms and Reports 6i, Toad, SQL Developer, UNIX,

Production Support and Maintenance of following applications:-

• Cognos7
• Cognos8
• Teradata
• JDA Manugistics
• Rockblocks

Roles and Responsibilities :-

• Complete ownership of all Oracle and ETL based applications and Modules like Teradata Data Warehouse , Cognos Cubes and Reports, JDA Manugistics Demand, JDA Manugistics Fulfillment, Rockblocks,.
• Handling all the Critical issues for the above mentioned applications involving Batch Failures, Business Critical issues
• Working with Business teams like Sourcing, Demand, Customer Fulfillment, Distribution on a daily basis to understand their problems, requirements and advise a proper resolution in a timely and satisfactory manner.
• Handling all the Program changes in above mentioned applications for any change requirement involving changes in Oracle PL/SQL Package, Procedure, Unix Jobs/Scripts, SQL etc.
• Meeting all the predefined SLA's with no escalation.
• Proper documentation of all the Know errors, any new enhancement for Offshore Team.
• Working with all the 3rd party vendors for any application package related issues.