Deevena Pilli
**** ****** *****, ***********, *** 6X4, Ontariomailto:
Home: 905-***-**** Cell: 416-***-**** ************@*****.**
Career Summary
An IT Professional with 25 years of experience in design, development & management of IT software and infrastructure projects across various public & private organizations. Successful at directing technical, functional, operational and quality assurance teams in design, develop, test, migrate and release innovative software solutions as per business requirements to the user best satisfaction. Well equipped with vendor negotiations on project delivery with phenomenal internal and external team collaborative skills. Spear-headed the teams in release process from baseline environment configuration until post-implementation support. Highly experienced in deploying new business processes, enhancing existing functionalities, infrastructure improvements and integrating new hardware into the production environment. Successful in implementing the transformational and change management PeopleSoft project initiatives with well recognized project management best practices & methodologies.
Professional Experience to Date
Senior Project Manager, Hospital for Sick Children (SickKids), Toronto, Canada
(October 2014 – July 2015)
Successfully delivered PeopleSoft 9.1 HR Transformation project encompassing all project management tasks including project feasibility studies, business requirements gathering, design, development, testing, stakeholder management, $1.7M budget, risks, change management, procurement and project quality control. Successfully planned, executed, monitored/controlled and closed the project based on the Project Management Institute’s (PMI) standards.
Total Compensation: Met compensation legislative requirements and support of SickKids policies (overtime and averaging agreement). Harmonization of job codes, positions, job descriptions, job titles, union codes, salary administration structures and role profile matrix implementation. Enabled automated tools for wage step progression to increase efficiencies in salary increase processes. Conducted fit/gap analysis to support the requirements, including any impact or additional effort/required changes related to downstream processes, modules and interfaces.
Occupational Health & Safety Services (OHSS): Sick related absence tracking and information sharing. Case management as per six stages such as Accrued sick day banks, EI, Income protection, Long term disability, Accommodated return to work and Full return to work. Statistical analysis on OHSS.
Automate CUPE Part Time Casual / Full Time requirements and reporting: Implementation of PeopleSoft 9.1 system functionality to facilitate the automation of seniority calculations, vacation premium enrolment, tracking and reporting.
Team Leadership and Project Management Skills:
Led around 30 - 45 cross-functional team members with IT and Business teams comprised of functional, operational leaders, technology professionals, vendors, contractors and external consultants to plan, design, implement and manage customer-focused strategic technology and innovative project.
Provided leadership to the technical staff to assist on complex tasks related to three tier architecture of Application Server, Web server, Client Server with Tuxedo middleware architecture in PeopleSoft environment for HCM 9.1
& PeopleTools 8.53 upgrade.
Coached team to improve efficiency of project work and interpersonal effectiveness.
Managed B2B automated functionality with Workplace Safety & Insurance Board (WSIB) for Electronic Integration Points through PeopleSoft integration broker for Form 7 implementation.
Applied an extensive knowledge and experience on PMI’s structured methodologies and also on stand-on meetings through Agile project management practices on this mission critical priority project.
Technical Knowledge & Skills:
Followed service management framework based on IT Infrastructure Library (ITIL) standards as an organizational structured policies and procedures and as an Oracle Certified Professional DBA and PeopleSoft Certified Professional Developer led technology resources in delivering the project.
Successfully implemented IT software deployments in a strictly bounded Software Development Life Cycle.
Led the technical resources worked in the three tier systems architecture, Oracle and PeopleSoft technology design and development, implementation and subsequent operational management and security of the applications.
Spear-headed the transition of corporate projects from the requirements phase through to the implementation phase, ensuring careful tracking and monitoring the statement of work orders of the third party vendors. Supported the translation of requirements to software Technical Design specifications and documentation.
Communication and Customer Relationship Management Skills:
Demonstrated strong communication skills, proven ability to effectively interact with staff across IT & Business units and at various level including senior and executive management.
Presented the Functional & Technical Design documents, change management and testing strategy to the core team including extended project stakeholders & executive sponsors
Consulted with the external technology contractors, vendors and negotiated statement of work orders and invoice payments to bring down costs.
Persuaded difficult resources to meet their task deadlines.
Spear-headed in conflict resolutions through cooperation and collaboration, tactfully resolved team conflicts.
Promoted informal and easy environment that brought good working relationships among team members by picking suitable resources for the work assignments.
Pinpointed the project dependencies and risks through discussions with the peer project managers and the project teams to ensure that they were effectively managed including risk assessment, risk prioritization, risk response strategies, risk mitigations and contingency plans to overcome the identified risks.
Consulted with clients concerning User Acceptance Testing (UAT) plans, execution strategies and in setting up best practice processes to reduce user errors during UAT.
Improved the issue escalation process using an understanding of how to communicate difficult or sensitive project status information tactfully to the executive steering committee & sponsors including the Corporate VPs by delivering informative and well-organized project status update presentations.
Analytical, Problem Solving and other Essential Skills:
Orchestrated the project charters, scope assessment, fit/gap analysis, business requirement validation, client consultation, project integrated plans, customizations, migration plans, change management protocols, quality assurance procedures and vendor procurement using exceptional multi-tasking skills.
Provided technical advises to the technical team members through regular weekly knowledge transfer sessions. This allowed the team to be hands on if any issues arise after deployment.
Played key role in the priority metrics facilitation meetings with the business to make wise and reasonable business decisions.
Budgeted & forecasted project expenditures and tracked them against actual expenditures.
Created and optimized PMO processes including end-to-end project management processes, optimizing project assessments, requirements management, resource management, project documentation & sponsor sign-off
Legal Aid Ontario, Toronto, Canada (November 1999 – October 2014)
IT Project Manager, Legal Aid Ontario, Toronto, Canada (June 2010 – October 2014)
Responsible for overall successful planning and implementation of projects related to PeopleSoft Financial and
Customer Relationship Management (CRM) modules. Performed day-to-day operations including issue resolution, escalation, general project management, resource management, timeline & budget mgmt. Facilitated workshops, ensured follow-up on outstanding items, Oversaw the development & delivery of custom components to ensure stakeholder requirements were met. Ensured integration with existing legacy systems and data integrity was maintained. Facilitated meetings with key executives and monthly status reports to the steering committee. Provided strategic direction to ensure the overall engagement and all of its components were successful.
Led project teams by leveraging a deep technical, functional and change management knowledge to provide innovative and proven technical solutions to satisfy business requirements with a team of over 25 members across functional & technical corporate internal staff, consultants & external contractors
Provided business requirement and quality assurance reviews, performance tuning guidelines, user acceptance, integration and regression testing strategies.
Managed PeopleSoft Financials 9.1 application upgrade which included Accounts Payable, Accounts Receivable, Purchase Order, General Ledger, Asset Management, Billing and Procurement modules of $2.5M budget.
Conducted fit/gap sessions for all modules and also for the SQR, Crystal and PS nVision reports. Captured action items and followed-up with the responsible resources until the actions were closed.
Fine-tuned the HRIS Upgrade & Payroll Implementation project for the HR and Finance Departments from internal and external resources, managed $1.5M budget, time lines, scope changes with best quality standards & practices
Successfully implemented the Personal Data System (PDS) upgrade for HR Department with Payroll interface for a biweekly pay cycle and for the Electronic Fund Transaction (EFT) through automatic File Transfer protocol (FTP) to Bank of Montreal for the biweekly salary payment to the employees.
Led infrastructure design workshops, data archival and data migrations from legacy to current business systems and load balancer implementation by following Information Technology Infrastructure Library (ITIL) processes.
Streamlined the Oracle 11G server upgrade, oversaw the training requirements of the project resources to face the challenges of new hardware with virtual memory builds, standby, disaster & recovery database server environments
IT Project Lead, Legal Aid Ontario, Toronto, Canada
(July 2007 – May 2010)
As a PeopleSoft Certified Professional Developer with proven experience providing project development leadership and support for medium to large size IT projects. Reviewed business requirements & functional design documents, developed application architecture, technical and security design specifications. Led the design, development, quality testing teams on application customizations, interfaces & reports. Successfully directed & collaborated with different types of project team members to achieve project goals & objectives.
Successfully led, architected, configured, designed, developed, enhanced, tested, deployed and documented various innovative projects in PeopleSoft CRM and Financials Applications.
Launched the interface of the Microsoft SharePoint system with the PeopleSoft CRM system.
Consistently and effectively offered successful technology solutions for the smooth running of the client’s business services through easy to use PeopleSoft CRM customizations which were embraced by the end users.
Learned emerging technologies such as cloud computing, SharePoint and Business Intelligence etc.
IT Competencies / Proficiencies:
PeopleSoft: Application Designer, PeopleCode, Debugger, Trace, Application Engine, Classes & Messaging
Configuration Manager, Data Mover, PS Query, Process Scheduler & Monitor, Query Manager, PeopleSoft
Security, Integration Broker, Component Interfaces, File Layouts and Tree Manager.
Oracle: SQL, PL/SQL Procedures/Functions/Packages, Forms & Repots, SQL Tuning and Database Administration.
Operating Systems: MS-Windows 2003, 2008, XP, Vista, Win 7 Professional, LINUX and UNIX.
Other: SQR, Crystal Reports, Toad, Golden, MS Query Analyzer, COBOL, Visual Basic, HTML, XML, Erwin, Embarcadero, Service Oriented Architecture (SOA), MS SQL Server, MS Project, MS Visio, MS Power Point, MS SharePoint, MS Excel, MS Word and MS Outlook
Senior Programmer Analyst, Legal Aid Ontario, Toronto, Canada
(November 1999 – June 2007)
As an Oracle Certified Professional DBA designed, developed and implemented many Oracle data cleaning, cloning and
migration projects. Provided production support for the database & applications. Scheduled & monitored batch
jobs/processes on the de-centralized area office Oracle Database servers. Utilized customer service skills, strong work
ethics and dedication. Remotely administered 51 Oracle database servers across the entire province of Ontario.
Developed Oracle database PL/SQL packages, functions and procedures for various applications.
Designed, developed, tested and implemented the data migration project from Oracle to Microsoft SQL Server.
Programmer Analyst, Sigma Systems Group – Toronto, Canada
(December 1998 – April 1999)
Instrumental in implementing and supporting the “Telcare” a billing software system.
Software Consultant/Tutor, Indotronix - Hyderabad, India
(August 1996 – July 1998)
Planned, designed, developed, tested and implemented customizations and reports of PeopleSoft Financials & HCM systems for a huge national pharmaceutical company.
Handled classes on MS COBOL, BASIC, Dbase, DOS, UNIX, Computer Principles, best Techniques and Practices for post-graduate students in the Informatics computer education branch.
Project Scientist/Manager, Indian Space Research Organization, Hyderabad, India
(May 1991 – June 1996)
Managed the design and development of a Marine Remote Sensing Information System (MARSIS) developed using Oracle Forms and Reports.
Worked on PAMAP & ESRI – GIS Applications for spatial analysis of the satellite remote sensing data
Mentored the research associates and interns performed the statistical analysis on satellite data and presented the results to the scientific community in the international space remote sensing conferences.
Coordinated the events with the presenters and participants on the international space remote sensing project seminars.
Education & Training
Project Management Institute (PMI) from Pennsylvania, USA:
Human Resource Management
Risk Management
University of Ontario Institute of Technology (UOIT) from Oshawa, Ontario, Canada:
Masters Certification in Project and Portfolio Management
Various Educational Organizations in Ontario, Canada:
Project Management Professional (PMP) Prep Course
Time Management
Customer Service Management
Oracle Corporation, Mississauga, Ontario, Canada:
Oracle & PeopleSoft Technologies
National Computing Centre, Manchester, UK:
Post-Graduate Diploma in Computer Sciences
Andhra University, Waltair, AP, India:
MS in Marine Sciences
MPhil in Marine Sciences
Professional Certifications
Masters Certificate in Project and Portfolio Management in 2013
Project Management Professional (PMP®) in 2011
PeopleSoft Certified Professional Developer in 2008
Oracle Certified Professional DBA in 2002
Security Clearance
Public Works & Government Security Clearance (PWGSC) in 2014