Sql Server Maintenance

VINODH THANKAPPAN Phone : 732-***-****

PeopleSoft Administrator Email :

*********@*****.***

SUMMARY:

• Over 7+ years of experience in IT and 5+ yrs of experience in PeopleSoft Administrator.

• Superior Understanding of PeopleSoft internet Architecture.

• Expertise in installing and configuring PeopleSoft 8.x PIA (PeopleSoft Internet Architecture), Web Server,

Application Server and Process Scheduler.

• Expertise in Web Server, Application Server and Process Scheduler Administration.

• Experience with Integration Broker.

• Experience in setting up Environment Management Framework (EMF) and setting up Change Assistant for

updates, Object Migration, Data Migration.

• Experience in applying Maintenance Packs, Patches and bundles.

• Expertise in using version control tool STAT for migrating the projects.

• Experience in providing Production support.

• Expertise in UNIX.

TECHNICAL SKILLS:

PeopleTools : PeopleTools (8.50/8.4x), Application designer, Upgrade/Change Assistant, Data Mover.

PeopleSoft Apps : EPM 9.0/8.9/8.8, HCM 9.1/9.0/8.8, Financials 9.0/8.9/8.8, Portal 9.0/8.9/8.8.

PIA : WebLogic 10.3/9.2/8.1/6.1, Tuxedo 10.3/9.1/ 8.1/6.1

OTHER TECHNICAL SKILLS:

Operating Systems : MS-Windows, UNIX, DOS, and Novell NetWare 3.11.

Databases : Oracle 8i, 9i, 10G, Microsoft SQL Server 2000/2005/2008, MS Access.

Languages : Java, SQL, PL/SQL, ASP.Net, HTML, C#

Other Software : MS Project

PROFESSIONAL EXPERIENCE:

Oracle Corporation, California Mar 2010 to Dec 2010

PeopleSoft Administrator

Responsibilities:

• As a Primary Consultant for Oracle On Demand was supporting many clients and all the PeopleSoft Pillars..

• Involve in Migrating the Customer Environments from "In House" to On Demand Hosted Servers.

• Involved in complete life cycle Peopletools Upgrades.

• Handling the customer calls to coordinate Migration or Upgrade projects with team of Developers @ customer

site, Service Delivery Managers and tech support.

• Support Production environments during stabilization period and in escalations.

• Maintain Documentation of all the customizations and architecture details deployed for all the Hosted

Environments.

• Involve in Knowledge transfer to Offshore after the project go live.

• Involved in automation of the processes based on the On Demand Standards and Procedures.

• Coordinate with GSC for product issues.

• Involved in PeopleSoft database refresh as per customer request.

• Perform sanity checks for all the environments before release.

• Implement and configure PeopleSoft user Productivity kit(UPK) for the creation of training materials on the new

PeopleSoft environment.

.

.

System Services Technologies (SST), MO Apr 2006 – Feb 2010

PeopleSoft Administrator

Responsibilities:

• Providing PeopleSoft maintenance and Production support for PeopleSoft Financials 8.8 (AR, AP, GL) and EPM

8.9 on Solaris environment.

• Upgraded PeopleTools from 8.44 to 8.47.09.

• Applied PeopleTools Updates/Fixes to the environments and HCM applications.

• Administered PeopleSoft infrastructure including Web-Server, Application Server and Process Scheduler on

Solaris and Windows Platform.

• Configuring and Monitoring of Application Server, Process Scheduler and Web Server on Solaris 8.0 and

Windows 2000/2003.

• Refresh activities of DEV and Sandbox database.

• Performed Weekly checkout of all controlled environment.

• Maintained controlled and non controlled environments

• Trouble shooting of Application server, Process scheduler server and Web server.

• Applied Tuxedo Rolling patch, weblogic service pack.

• Installed PeopleTools and application PeopleBooks

• Expertise in migrating projects from DEV through PROD environments

• Expertise in using version control tool STAT for migrating the projects

• Migrated SQRs and run dms scripts using DATA Mover tool

• Organizing & coordinating Continuity of business tests for the PeopleSoft applications

• Coordinated with Oracle and Unix team effectively to resolve major issues

• Setting up the report nodes for posting the reports.

• Investigated and solved many time critical issues

• Involved heavily in production support. Solved various issues occurred in testing and production environment.

• Monitoring of Batch jobs and file systems in PeopleSoft n-tier environment.

• Server monitoring and setting up of parameters for the best Server performance

• Setup Integration Broker for Application messaging

• Developer support to debug and trace Application Engine Processes, PeopleCode and Component Interfaces .

Pentagon Global Solutions, India – Oct 2003 – Dec 2005

Oracle Developer

Responsibilities:

• Involved in performance tuning of queries and stored procedures on various large-scale databases and redesigned

physical layout of databases to justify OLTP and Decision support.

• Developed various shell scripts for database maintenance and to purge data to maintain at optimum level.

• Developed a scheduler process, which is a fully automated process of rolling ledgers to next business day, prior

day and prior month. Used stored procedures, triggers and cursors for the development of scheduler. Target

database is Sybase SQL Server.

• Developed DB Library/C, stored procedures to populate core data tables to be later used by the Audits and Report

Publishing processes. Involved in Design and development of relational databases and administration of UAT

Sybase SQL Servers. Provided on call support 24X7.

• Developed MPP’s and audits using C, Embedded SQL, DB Library/C, Stored Procedures, triggers, rules and Syb

Perl Scripts (maintenance scripts) run on Solaris and IBM AIX and utilize Sybase SQL Sever for the physical

storage of financial data.

• Database design, database administration, creating scripts from data dictionary for table and index creation using

awk, performance tuning of stored procedures, triggers and front-end development using PowerBuilder 3.0a and

Sybase System 10 as the target database.

• Migration project (IBM to HP 9000) for Harvard University’s OIT. Responsibilities include physical database

design, database installation, device creations, shell scripting, defining constraints, rules and indexes.

APTECH LTD, India June 2002 – Sep 2003

Course Coordinator, Faculty

Responsibilities

• Facilitate course development through reflection and student evaluations.

• Supervise Faculties assigned to the course

• Organize and hold meetings of the Faculties to discuss issues affecting student learning, testing and other

classroom issues.

• Organize and hold periodic meetings with the class representatives for the course to obtain constructive student

feedback.

• Conduct classes on MS Office, Oracle, FoxPro, Visual Basic, Java.

• Evaluate Student Performance.

• Participate in instructor evaluation, assessment of student academic achievement and demonstrate modification of

teaching techniques in accordance with assessment feedback.

• Scheduling Batch start date, batch timings, allotting faculities.

EDUCATION:

• Bachelor of Commerce, Bharathidasan University, India

• Higher Diploma in Software Engineering, India

CERTIFICATION

ITIL Version 2 Certification

•

Sun Certified Java Professional

•

Contact this candidate