PICHAIYA. S
Mobile: +91-994*******
Email: *********@*****.***
Project Management and Delivery
Over 20 years of experience in Project management and Delivery in the field of IT Infrastructures
Experience Summary
With over 20+ years of IT experience with excellent analytical, problem solving, decision-making and Knowledge of managing/leading teams with strong communication and managerial skills. Exceptional people management skills, ability to motivate, coach and mentor the team to achieve common goals with Project objectives. Expertise in project Management and delivery using on-site/off-shore model, Capability of handling parallel tasks for Management reporting to organization unit level. Green Belt in Six Sigma and ITIL certified. Experience in Pyramid optimization, Margin improvement initiatives & cost improvement initiatives. Ability to manage Up (Executive/Senior Management), Down (Direct Reports), and Across (Peer Groups, Stakeholders, etc.)
Experience in Leading Oracle Center of Excellence in Data Center to manage 24X7 production system and Database Implementation consultancies.
Professional summary
Name of Company
Designation
Duration
Cognizant Technology Solutions, Chennai
Associate Director
Dec 2007 - till date
HCL Comnet, Chennai
DBA – Project Lead
Dec 2006 – Dec 2007
GE IND, BANGALORE
Sr System Analyst
July 2003 - Dec 2006
FRONTIER TRADING, MUMBAI
System Analyst
Jun 2002 - July 2003
CELLTECH SYSTEMS INC, USA
System Analyst
Sep 2000 – March 2002
SCORP INFOTECH, CHENNAI
Sr. Programmer
Aug 1998 – Aug 2000
Certifications
Green Belt in Six Sigma and ITIL certified.
AWS Sysops Admin
Technical Skills
Operating Systems
Unix/Linux, Windows
Database Tools
Oracle & Sybase
Other tools
Oracle Enterprise Manager 10g Grid, OEM, TOAD,SQL*Loader, PL/SQL,
Scripting Language
Shell Scripting
Professional – Project Experience
Current Employer
Cognizant Technology Solutions
Role
Associate Director - Delivery
Project Abstract
AIG American International Group, Inc is a leading international insurance organization with operations in more than 100 countries and jurisdictions. AIG companies serve commercial, institutional and individual customers through one of the most extensive worldwide property-casualty networks of any insurer.
Key Accountabilities
1.IT operations leader who is proven, and managed end to end service delivery
2.Work closely with account management/Account team for customer satisfaction, financial health and maintaining the target set.
3.Driving transformation programs, ensuring that customers and internal business stakeholders are kept informed about the status and development of the Engagement / Project in a transparent / proactive manner.
4.Identify- initiate and implement continual service improvement and transformation plans.
5.Responsible for Operational aspects of Project Administration & Experience in forecasting & managing account
6.Responsible for optimum resource planning and management. Setup regular customer meeting for project / engagement updates based on the Governance plan.
Current Employer
Cognizant Technology Solutions
Role
Sr. Manager - Delivery
Project Abstract
True Value is a company with a proud heritage of supporting the growth and success of independent retailers — it's the reason this cooperative was founded. This diverse group of retailers operates True Value stores and specialty businesses for Hard ware in thousands of communities in the United States and around the globe.
Key Accountabilities
Project requirement analysis, planning and execution of application retirements, upgrades and Migrations for Legacy & unsupported platforms.
Conduct Regular meetings with the client and the team for maintaining project plans and weekly project status.
Manage the profitability of the Account. On-site & Offshore coordination is maintained.
Handling escalations and delivering Governance with customer, Higher Management and within the team for both Onsite and Offshore Mangers and Leads
oIdentified knowledge transition requirements, prepared coverage maps.
Current Employer
Cognizant Technology Solutions
Role
Sr. Manager - Delivery
Project Abstract
AstraZeneca a global biopharmaceutical company. Formed on 6 April 1999 through the merger of Astra AB of Sweden and Zeneca Group PLC of the UK – two companies with similar science-based cultures and a shared vision of the pharmaceutical industry. The merger aimed to improve the combined companies’ ability to deliver long term growth and enduring shareholder value through:
Global power & reach in sales and marketing/Stronger R&D platform for innovation-led growth and Greater financial strategic flexibility
Key Accountabilities
Responsible for 22 M $ YTD revenue upstream and ensure that the Profitability is taken care.
Present the Monthly Audit report and the PMR.
Manage the Off-shore team by Periodic review and suggestions given to the team in a daily basis on technical issues.
Requirement analysis, planning, execution, cost estimation for the overall scope.
Handling escalations and delivering Governance with customer, Higher Management and within the team for both Onsite and Offshore Mangers and Leads
oIdentified knowledge transition requirements, prepared coverage maps.
oResponsible and coordination with process groups like Quality, Security and change management for successful completion & avoid any process issues.
oWorking with team for standard Technical execution document for various Middle Ware technologies and Apps Retirement & process group approvals.
oInitiated Marginal optimization levers for cost reduction for CP improvement.
Current Employer
Cognizant Technology Solutions
Role
Manager - Operations
Project Abstract
ING-A Global financial institution with a strong European base, offering banking services. The commitment to excellent service and the global scale to meet the needs of a broad customer base, comprising individuals, families, small businesses, large corporations, institutions and governments.
Key Accountabilities
Conduct Regular meetings with the client and the team for maintaining project plans and weekly project status.
Present the Monthly Audit report and the PMR.
Manage the Off-shore team by Periodic review and suggestions given to the team in a daily basis on technical issues.
Interacting with offshore delivery team to ensure proper communication.
Prioritizing the tasks for various team members.
Identified knowledge transition requirements, prepared coverage maps.
Taking care of the shift schedule and other infrastructure related to the team.
Planned, scheduled and tracked knowledge sessions, collected metrics. Continuously involved in the performance reports generation and giving suggestion to the client.
Current Employer
Cognizant Technology Solutions
Technology
Oracle 8i/9i/10g RAC on Linux/Solaris, Windows 2000/2003 and OpenVMS OS, Database Console & 10g Grid, TOAD
Project Abstract
Wyndham Vacation Ownership is the Retail and Hospitality domain having head quartered at Florida USA. Leading a well experienced team of Oracle and SQL Server DBA professionals from the off-shore, setup includes off-shore /onsite model with nearly 75% of the time are covered from the off-shore and rest is done from on-site.
Key Accountabilities
Ensuring Delivery for Middleware Database engagement for BAU’s
Handshake and governance between Horizontals and Verticals.
Done the Transition for database offshore support delivery
Maintaining the RAC production databases.
Initiated and resolved various performance related stuff.
Applying regular Critical CPU patches for Oracle.
Supporting OS patches.
Performing Query and Database Tuning.
Trouble shooting the daily development/production problems.
Database cloning using RMAN scripts.
Schema Migration through refresh of Dev/QA from production by RMAN/Exp-Imp utility.
Analyzing, reorganizing the objects and rebuilding Indexes.
Writing Linux/Unix Shell scripts, RMAN scripts etc for backups.
Employer : HCL Comnet, Chennai ( Dec 2006 – Dec 2007)
Project Abstract
The Armstrong, USA is a global leader in the design and manufacture of floors, ceilings and cabinets.
Role
Oracle DBA Project Lead
Key Accountabilities
Responsible for more than 100 + production databases.
Setup Team, Training Material and Knowledge Sharing.
Managing Onsite/offshore DW/DBA deliverables, with onsite Data Architect/DBA teams and Offshore DBA teams on multiple product line projects.
Resource planning, work prioritization, release planning and coordination; progress and issues reporting.
Build a strong relationship with the client, by establishing various communication channels
Replication of production database for reporting purposes. Replication includes adding new ember and changes to existing objects.
Taking care of patch updates.
Adhoc user requests like creation of new objects.
Employer : GE IND, Bangalore (July 2003 - Dec 2006)
Project Abstract
As part of the Integration, GE-RAIL, a profitable business involved in the manufacturing of various components for RAILWAYS worldwide, was integrated to GE-Industrial business Oracle apps 11i financials was using this database; hence we maintained a standby database, which was upgraded to 10g from 8i. RMAN was used for backups for both archive and cold backups happening on the regular intervals
Role
Oracle DBA Project Lead
Key Accountabilities
Studied and lead the team of DBA’s for various activities of New GE-RAIL business.
Attending and oversee of the team performance and reporting to the GE management.
Taking care of RMAN archive backup and cold backups.
Earlier catalog database was separately maintained, but we took over we created a new catalog database for 10g database and a single catalog for the rest of the databases using RMAN for backups.
Automated most of the jobs for purging of data and files from the OS level.
Maintenance of Standby database.
Everyday management of production and lower environment. Involved in creating database objects and sizing of existing databases based on business rules.
As DBA, Monitoring for free spaces. Dealing with index issues. Regular reorg and rebuild of offending indexes.
Regular exp backups through crontab entries for other databases.
Employer : FRONTIER TRADING, MUMBAI (Jun 2002 - July 2003)
Project name
MLM SYSTEM
Client
FRONTIER TRADING, MUMBAI
Duration
JUN-2002 – JUN 2003
Technology
Oracle 8i/9i
Project Abstract
Frontier Trading, MLM Company, manufactures herbals and other products. This project involves re-engineering of the existing old modules from PowerBuilder to VB 6.0 and Oracle 9i.
Role
Oracle DBA
Responsibilities
As part of the development team involved in the design of the entire system. Frequently interacting with the developers for the code review and their performance.
Backup and Recovery: Periodical backups of all oracle servers. Day-to-day monitoring of the database performance.
Maintain and creating user profiles for all databases based on the user report from HR department.
Employer : Celltech Systems INC, USA (Sep 2000 – March 2002)
Project name
HR-BENEFITS AND COMPENSATION
Client
Goldman Sachs, New York, USA
Duration
SEP 2000 – APRIL 2002
Technology
Oracle 8i/9i, SQR
Project Abstract
Goldman Sachs, a wall street major and employs over 25000, uses the People Soft (7.5) package to handle its human resources related data. This project was an effort to service the requirements of various departments like Payroll, benefits & compensation etc.
Role
Oracle DBA/Developer
Responsibilities
As part of the 3-member study team, was involved in requirements gathering through interaction with various user groups. Finalization of requirements specification. Design phase activities: Preparation of high-level design document (Entity-relationship diagram, data dictionary). Co-ordination and review of Program / test specification Primarily responsible for coordinating the various activities amongst team members during the coding phase, apart from coding few critical reports. Data transfer from other environment to Oracle using SQL LOADER.
Previous employer : Scorp InfoTech Pvt Ltd, Chennai( Aug 1998 – Aug 2000)
Project name
WAREHOUSE MANAGEMENT AND ENQUIRY
Duration
JULY 1999 - AUGUST 2000
Technology
Oracle 7/8i, PL/SQL
Project Abstract
Web application based on Internet / Intranet model. System that provides Enquiries on the availability of items via Internet Stock management functions within the organization-using intranet. The first level of enquiry, that is the item availability, passes through the web server / database server and back to the web page.
Role
Oracle DBA
Responsibilities
As part of the 3-member study team, was involved in requirements Involved in the database connectivity with the backend Oracle8.0 database using ADO.
Stored procedures, Database Triggers and functions were used for validating the values entered by the user. In the Intranet module, designed the web pages using ASP in sales, purchase and stock management of the module. Created various server variables for the data. Created various Application and Session variables for the modules.