SANDIP CHETTIAR
Contact: +***-*********** Email: **************@*****.***
[pic]
Project Manager / SAS Platform Administrator
High-integrity, energetic leader known for ability to envision and create
successful outcomes in complex situation(s). Diverse industry and
functional expertise. Tenacious commitment in managing up to 100 member
development team. Strong ability to anticipate and shape customized data-
warehouse & database solutions.
Expertise in the fields of Data Base Administration (DBA), SAS Platform
Administration and Data Warehousing (DW). Proven ability in entire SDLC
activities with an active involvement in Stakeholder Management and Program
Management.
[pic]
EXECUTIVE HIGHLIGHTS
Built solid track record of success leading teams and rapidly evolving the
business prospects
Strategic Planning Finance Management Business Development
Corporate Management New Business Opportunities Project Management
Promoting PMI Procedures Managing Large Teams Risk Management
Stakeholder Management at
customer site and offsite
[pic]
TECHNICAL HIGHLIGHTS
Capacity Planning Database Administration Data Modelling
Data Profiling SAS Platform Administration Linux Administration
Performance Tuning Automation
[pic]
TECHNICAL SKILLS
Operating Systems: UNIX (AIX), Windows, Red Hat Linux
Languages: Visual Basic
Scripting Languages: Shell Scripting, VB Scripting
Databases: DB2 UDB, SQL Server, Oracle, Sybase, MYSQL, Access 2000
Reporting Tools: Crystal Report 4.5, Word Reports
Data Modelling Tools/Utilities: ERWIN, TOAD, SQL Navigator, Rapid SQL,
Spotlight, Quest Central for DB2, Swiss SQL
Data Warehousing/ETL: Informatica, Jasper, Talend, Datastage, Teradata
Project Tools: Microsoft Project
Analytics: SAS 9.3 Platform Administration, SAS Grid and Platform LSF
Administration, SAS RTM and SAS APM
[pic]
ACADEMIA & CERTIFICATIONS
Pursuing Master's of Business Administration ICFAI University Completed
3 Groups
Graduation - B.E. (Civil) Mumbai 1996 60%
XII/High School Mumbai 1992 76.5%
[pic]
Oracle Certified Professional
SAS Certified Platform Administrator
Trained on Project Management Book of Knowledge (PMBOK) of PMI (USA)
Wipro Certified Project Manager
[pic]
EMPLOYMENT HISTORY & ACCOMPLISHMENTS
Wipro Technologies (India)
Since Mar'2010
Technical Project Manager
Responsibilities
Lead the Project team for timely and quality project delivery.
Implementing & enforcing organization standard quality and PMI procedures.
Involved in software architecture and design, implementation and testing.
Creating Project Estimates, RFP's, Execution plan, resource estimates,
defect tracking metrics.
Coordinating activities with the client in understanding and finalizing the
scope of work
Creating and maintaining the WBS, issue log, project status and documents -
SOW, detailed scope document, MPP, project management plan, revenue
tracking
Involved in review of the deliverables and escalation mechanisms.
Creating the SCM plan by initiating the necessary change requests and
deployment plans.
Preparing the communication plan - status reporting, weekly senior
management presentations, stake holder management.
Involved in risk mitigation and reviews, preparing risk analysis reports,
project life cycle management
Performance appraisal of the team and project.
SAS Administrator -
Responsibilities:
SAS Installation/Configuration, designing the DR solutions
Configuration & troubleshooting for SAS Platform with SAS Tech Support.
Applying Hot-fixes and license renewals.
Maintain software depot. Software packaging and distribution
Implementation of SAS Metadata Security following best practices
Installation of new software i.e. APM
Managing metadata libraries, folders etc using SAS Management Console
Troubleshooting and root cause analysis of production issues
Administering and Supporting the SAS BI Platform: SAS Management Console,
Stored Web Application, Enterprise Guide, Enterprise Miner, SAS Model
Manager, SAS Forecast Studio
Setting up security, users, groups, roles and permissions using ACTs and OS
permissions
Administering Metadata, Content Server and OS Backups.
Automation of archiving and purging SASApp Logs, space usage report
SAS Platform Grid Administration, Platform LSF Administration and RTM
Liaising with SAS solutions architect, SAS consultants, Linux and
Websphere teams
Involved in Change management and implementation
Involved in SAS Strategy Meetings for defining future road map of the
platform.
Sierra Atlantic Limited (HYDERABAD)
2006-2010
Project Manager
Responsibilities
Guided the Project team on technical issues
Managed complete project life cycle
Provided technical guidance and monitored the project execution
Implemented and enforced organization standard quality procedures and CMMi
/ PMBOK guidelines
Actively participated in software architecture and design, implementation
and testing
Created Project Estimates, RFP's, Case Studies, Data sheets for prospective
clients
Involved in risk mitigation and reviews, prepared risk analysis reports,
handled project life cycle management
Responsible for quality audits and task/project closures
Performance appraisal of the team and project
Developed documents for integration of China and Indian organizations
Verizon Data Services (I) Pvt. Ltd. (CHENNAI)
2004-2006
Project Lead/Sr. DBA
Responsibilities
Performed analysis of the data warehouse and logical design of the objects
using ERWIN
Developed and implemented the physical database design
Coordinated with the on-site team for creating the tasks and understanding
the project scope
Created Database sizing and estimating space for the table spaces
Performed Database Backup and Troubleshooting
Created the necessary indexes using the index advisor
Maintained the DR database for quick turn-around
Worked with IBM for opening the PMR and closing any issues
Handled Shell Scripting for database admin activities
Involved in the Performance Monitoring and Tuning queries using Query
Patroller, Quest Spotlight
Installed Query Patroller for database performance and monitoring
Generated reports to be presented to the necessary stakeholders
Syntel India Ltd. (MUMBAI)
2000-2004
Senior Analyst/Sr. DBA
Responsibilities
Coordinated with the team for creating and managing the tasks
Performed analysis of change request, estimation and modification of the
project scope
Performed analysis of the data warehouse and logical design
Developed and implemented the physical database design after sign-off
Wrote Database Procedures, functions and queries for the users
Database sizing and estimating space for the table spaces
Managed Database Backup and Troubleshooting
Created the necessary indexes using the index advisor
Maintained the development servers and user administration
Handled Shell Scripting for database admin activities
Ensured Performance Monitoring and Tuning queries and suggested performance
parameters
Created and delegated the tasks as well as monitored the team members
Monitored the deliverables and resolved the issues raised by the QA team
Generated defect reports and project plans to be discussed with the client
and PMO
Blue Chip Computers Pvt. Ltd. (MUMBAI)
1999-2000
Software Engineer
Responsibilities
Performed Database Analysis and Design
Handled Client Co-ordination
Wrote database procedures and functions
Created Visual Basic Forms and Word Reports
Developed reports using Crystal Reports 4
ESP Interactive Ltd. (MUMBAI)
1998-1999
Software Analyst
Great Eastern Shipping Ltd. (MUMBAI)
1996-1998
Site Engineer
[pic]
Other Accomplishments
Awarded the best Project Manager Award at Wipro
Awarded the title of "Mr. Defect" for the Best Defect Management Practices
at Wipro
Recipient of Outstanding Team Award for 2 projects at Sierra Atlantic
Recipient of Best Employee Award at Verizon Data Services
[pic]
PERSONAL DOSSIER
Date of Birth - 06-July-1975
Marital Status: Married
Nationality: Indian
[pic]