Summary

• IT Professional with 8 years of Internationalexperience in Oracle PeopleSoft CRM Implementation and emphasis on validation and verification. Managed teams of over 50
• Experience in complete Software Testing Lifecycle SDLC , analysis of business, functional specifications and formulation of Test Plan requirements.
• Developed modules for Oracle CRM Order Management service applications used in worldwide Apple retail stores
• Extensive training on PeopleSoft CRM 8.8 and PeopleTools suite 8.46.
• Excellent analytical, problem solving and personal skills which includes strong sense of organization and effective time management and have the ability to work in a team as well as independently
• Excellent interpersonal, intuitive, analysis and leadership skills.
• Proven ability to work efficiently in both independent and team work environments
• Expertise in executing SQL queries
• Known for ability to multi-task and work on different applications at the same time
• Strong working experience in Windows NT/2000/XP, MAC OSX and UNIX environments
• Extensively used SQL queries to interact with ORACLE database by using toad
• At ease in high stress environments requiring superior ability to effectively handle multi-tasks levels of responsibility.
• Good presentation and communication skills coupled with the ability to interact well with the Client
• Diligent worker, self-starter, quick learner and a consistent performer

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: I.T Analyst/ Associate Project Manager

Responsibilities

• Monitor and resolve the issues logged by the end users in the incident reporting tool Apple supplied tool Espresso
• Answer user inquiries regarding computer software to resolve problems
• Enter commands and observe system functioning to verify correct operations and detect errors. Techniques have been developed to do a better diagnostics of the problems
• Set up software on production boxes
• Install and perform minor software changes in production environment. Some coding is done to make quick changes
• Maintain records of daily transactions, problems and remedial actions taken and installation activities via ticketing tool
• Maintain issue backlog within agreed levels
• Read technical manuals, confer with users, or conduct computer diagnostics to investigate and resolve problems or to provide technical assistance and support.
• Refer major software problems or defective products to vendors or software development team
• Escalate L3 level issues to development / Operations teams after triaging
• Meeting IT staff, users and management to establish requirements for new systems or modifications.
• Provide Weekly and Monthly Status Report to Management and Application Owner
• Involved in the maintenance, operations and support of Oracle Fusion stack and SOA setup in the CRM installation
• Address all business critical issues related to
• AURA A transaction event management system based on Oracle BEPL and CEP.
• Esperanza Custom asynchronous data processor for product information

Environment

• Hardware Apple iMac, Apple MacBook Pro, iPhone, iPad and iPhone touch
• Operating System Mac OS X, Linux, Unix
• Languages Java/J2EE, Oracle, Shell scripting, PL/SQL, Web Services
• Special Software Espresso, Radar, SVN, SQL Developer, Soap UI
• Cupertino

Confidential

Role: I.T Analyst

Responsibilities:

• Led a 50-person cross-functional team in California, Singapore, India to manage software for the entire Apple E-commerce CRM platform including sales, orders, service management modules used by 10,000 Apple employees
• Directed the design thinking team to develop an in-house digital software tool to track the health of the production servers and map with the required data and analytics
• Member of Change management team that incorporated Oracle Service Bus functionality into the Apple's Oracle CRM architecture.
• Part of 12 major Apple Inc. product launches
• Subject Market Expert for Sales and Order Management B2B modules for Apple CRM system
• Reduced application issues by 30 through optimizing the D2P Development to Production cycle
• Created Business Requirement Documents and Use Cases.
• Created Test data according to different Scenarios to verify Reports.
• Involved in testing front-end web screens and web reports by executing the positive, negative test cases.
• Created and Verified the Business Scenarios and Business Test Cases on new builds to allow extended testing by the QA team.
• Involved in smoke, functional, regression and user acceptance testing.
• Interacted with Business Analysts for writing test Plans and test cases for end-to-end testing.
• Participated in Defect Review meetings and Quality Assurance meetings.
• Data validation and Database integrity testing done by executing SQL, PL/SQL statements.
• Hands-on experience in using SQL queries/Stored Procedures/Triggers/Views and fine-tuning of the database indexes.
• Used SQL Loader for loading data using CSV files.
• Coordinated with senior Apple Inc. directors for the re-engineering efforts. Collaborated with cross-functional IT teams and led high priority network security projects for Oracle Database 11g release
• Responsible for 125 increase in demand and scalability by increasing production-box and application capacity
• Analyzed customer trends, business requirements, anticipated needs and gathered business requirements to support an evolving planning and management reporting function that meets the needs of the users
• Environment
• Hardware Apple iMac, Apple MacBook Pro
• Operating System Mac OS X, Linux, Unix
• Languages Java/J2EE, Oracle, Shell scripting, PL/SQL
• Special Software Espresso, Radar, SVN, SQL Developer
• Bangalore/Cupertino

Confidential

Role: Systems Engineer

Responsibilities:

• Service contracts and case management applications for contact centre users
• Retail service and customer records management systems
• Online tools for customer self service and support resources
• Co-ordinate with business/client users
• Involved in entire QA Life Cycle, which includes Designing and Developing and Execution of the entire QA Process and Documentation of Test Plans, Test Cases, Test Procedures and Test Scripts.
• Involved in UAT testing and System testing of WL, GFEE Amortization modules.
• Coordinated with Multiple teams of System Testers, UAT Testers, Developers, Business Analysts, Team Leads, Release Managers and Business Executives to derive quick and quality solutions to achieve short-term and long-term project goals.
• Verified whether ETL Mapping documents followed data models and business requirements logic for various builds.
• Validated the process before and after amortization with the business requirements logic by writing and executing automated SQL and Unix Shell Scripts.
• Successfully covered all possible Test Scenarios with the help of a thoroughly thought-out test management plan.
• Developed test cases to validate the process of data flow and the transformations.
• Created Test cases and Executed Test Sets in Mercury Quality Center.
• Reported and Tracked Defects for Failed test cases in Rational Clear Quest.
• Co-ordinate with upstream /downstream /other application teams
• Provide solution for production issues to users and business
• Closing of production issues based on priority
• Environment
• Hardware Apple iMac, Apple MacBook Pro
• Operating System Mac OS X, Linux, Unix
• Languages Java/J2EE, Oracle, Shell scripting, PL/SQL
• Special Software Espresso, Radar, SVN, SQL Developer
• Bangalore/Cupertino

Confidential

Role: Assistant Systems Engineer

Responsibilities:

• Created Reports in Crystal Report and developed Queries using PS Query across various modules to fetch data based on user inputs
• End to end customization over a component for Job data reporting which involved creation of fields, records, pages, components, workflows and menus
• Creation of workflow for various business process
• Create Test Plans and Performing Internal Quality Assurance
• Performed backend testing using SQL queries and analyzed the server performance on UNIX
• Interacted with client user personnel to ensure continuing adherence to requirements and user standards.
• Environment
• Languages PeopleSoft HRMS 8.9, Crystal reports 9, People Tools 8.43, People Code, Workflows
• Bangalore

Confidential

Role: Assistant Systems Engineer

• Technical architecture design and developed Small Medium Business SMB Module for CRM mobile systems
• Led Product re-engineering efforts leading to improved customer experience and 15 increase in Sales
• Extensive training on PeopleSoft CRM 8.8 and PeopleTools suite 8.46.
• Manage the code review to ensure it maintains coding standards
• Involve in requirements gathering
• Taught and mentored 25 associates as a part of the TCS PeopleSoft Center of Excellence COE team
• Performed backend testing using SQL queries and analyzed the server performance on UNIX
• Collected metrics for software defects and reported these to management using Test Director
• Conducted Regression testing on various builds of the application.
• Used SQL Queries to verify the data from the Oracle database.
• Interacted with client user personnel to ensure continuing adherence to requirements and user standards.
• Involved in formal review meetings with project teams and developers to report, demonstrate, prioritize and suggest resolution of issues discovered during testing
• Actively participated in System testing, integration testing and coordinated UAT
• Environment:Oracle 10g, Rational Clear Quest, Mercury Quality Center, Windows 2000, Rapid SQL 7.3.3, PS Pad 4.3.3, VB Script, UNIX, Web logic, QTP, Share point.