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 t work in a team as well as independently
• Excellent interpersonal, intuitive, analysis and leadership skills.
• Proven ability t work efficiently in both independent and team work environments
• Expertise in executing SQL queries
• Known for ability t 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 t interact with ORACLE database by using toad
• At ease in high stress environments requiring superior ability t effectively handle multi-tasks levels of responsibility.
• Good presentation and communication skills coupled with the ability t interact well with the Client
• Diligent worker, self-starter, quick learner and a consistent performer
• Salesforce Certification Training: Administration, features and customization of Salesforce1 Platform. Well-versed with the functionalities of Communities across the sales, service and collaboration clouds on Salesforce

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 t resolve problems
• Enter commands and observe system functioning t verify correct operations and detect errors. Techniques have been developed t d 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 t 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 t investigate and resolve problems or t provide technical assistance and support.
• Refer major software problems or defective products t vendors or software development team
• Escalate L3 level issues t development / Operations teams after triaging
• Meeting IT staff, users and management t establish requirements for new systems or modifications.
• Provide Weekly and Monthly Status Report t 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 t 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 t develop an in-house digital software tool t 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 int 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 t Production cycle
• Created Business Requirement Documents and Use Cases.
• Created Test data according t different Scenarios t 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 t 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 t 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 t derive quick and quality solutions t 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 t 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 t 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 t fetch data based on user inputs
• End t 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 t ensure continuing adherence t 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 t improved customer experience and 15 increase in Sales
• Extensive training on PeopleSoft CRM 8.8 and PeopleTools suite 8.46.
• Manage the code review t 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 t management using Test Director
• Conducted Regression testing on various builds of the application.
• Used SQL Queries t verify the data from the Oracle database.
• Interacted with client user personnel t ensure continuing adherence t requirements and user standards.
• Involved in formal review meetings with project teams and developers t 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.