Resume of IT Project Manager

Title
IT Project Manager

Primary Skills
Project Mgmt, Database Marketing, Business Process Improvement, Systems Integration, Data Warehousing, Business Analysis

Location
US-PA-Downingtown

Posted
Feb-02-08

BACKGROUND SUMMARY

Quality oriented professional with over 16 years experience in project management, team leadership and software development with Fortune 500 companies in the pharmaceutical and financial services industries including international consulting experience in US, UK and India. Demonstrated excellent communication, analytical and interpersonal skills and created a proven track record for meeting objectives and deadlines in highly regulated environments. Excelled at managing Strategic Process Improvement projects and regarded as a change agent. Expertise in the following areas:


IT Project Management, Database Marketing, Business Process Improvement, Systems Integration, Data Warehousing, Business Analysis, Software Development Life-Cycle Process, Business Intelligence, Data Modeling and Management Reporting.

EDUCATION

Master of Business Administration (MBA) from Villanova University, PA - 2007
Concentration in Marketing - GPA of 3.72
Member of Beta Gamma Sigma International Honor Society

Bachelor of Engineering (B.E.) from National Institute of Technology, Trichy, India - 1990
Electronics and Communication Engineering - GPA of 3.60
Awarded scholarship for academic excellence

Six Sigma Green Belt Certification from PMI - 2007


TECHNICAL CAPABILITIES

Operating Systems: UNIX SVR 4, HP-UX, Solaris 8, Windows NT/2000/XP, MS-DOS.
Data Warehousing: Sagent, Informatica, Microstrategy 6.5.
Data Modeling: Star & Snowflake - Dimensional & Relational Data Modeling, ErWin.
Business Intelligence: Business Objects, AlphaBlox 3.0, Hyperion, Brio 6.0.
RDBMS: ORACLE 8i & 9i, MS SQL Server 7.0, MS Access.
Web Technologies: XML Web Services, Java, .NET.
Methodologies: PwC Ascendant/Summit, Zentoria (PPM), DW Methodology.
Middleware: MQ Series, BAGS.
SQL Server Utilities: T-SQL, DTS, Job Scheduler, Enterprise Manager, Query Analyzer.
ORACLE Utilities: SQL*PLUS, PL*SQL, SQL Loader, TOAD.
Programming Languages: C, Pascal, UNIX Shell Scripts, COBOL.
PROFESSIONAL EXPERIENCE AND SELECTED ACCOMPLISHMENTS


GlaxoSmithKline (GSK), Philadelphia, PA
2001 - Present



Project Manager - Marketing Solutions
2006 - Present

* Currently leading an opt-in / opt-out business and IT strategy to centralize and standardize physician opt-ins and opt-outs in order to drive effective permission based email marketing.
* Currently representing IT in an enterprise wide project to bring the sample and material fulfillment in-house from a vendor provided services model in order to drive savings from economies of scale and scope and to enable control over Sample compliance issues.
* Currently managing off-shore resources in designing a marketing data warehouse as part of PRM (Physicians Relationship Management) project. The data warehouse addresses the business problem of disparate data from multiple systems that are in silos. The solution will result in speed and accurate data delivery for marketing analysis.
* Currently managing an e-Sampling initiative that enables physicians to directly order samples and promotional materials from a GSK portal while monitoring PDMA compliance.
* As the Primary Business Analyst Liaison for the Marketing Solutions Department, helped define the BA Strategy for the entire IT department.
* Coordinated with Brand Marketing, Global IT Risk Management, Data Warehousing and Sample Accountability teams in order to define GSK portal and User Management requirements.
* Managed a vendor hosted solution for directly recruiting and targeting to physicians who opt into direct marketing communication with GSK. The outsourcing of the e-detail functionality resulted in cost savings of $500K per year.


Development Manager - Marketing Solutions
2005 - 2006

* Managed five technical resources (offshore and onsite) on the design, development, testing and ongoing maintenance of Optimal Sample Allocation Process (a Sample BPI initiative).
* Coordinated between several cross-functional teams in delivering the project on schedule.
* Recognized with Platinum Impact Award (the highest GSK award for excellence in achievement) for performance that was above and beyond expectations.
* Benefits Delivered included sample annual budget reduction of $1MM, improving sales rep productivity by 2,865 hours and savings in shipping costs of $55,000 per year.


Lead Analyst - Marketing Solutions
2003 - 2005

* Led a technical team on the design, development and ongoing support of a Vaccines Campaign Management System (Vaccines CRM Initiative) to improve Vaccines Marketing efforts.
* Managed interfaces, expectations, contracts and deliverables with multiple vendors thus enhancing communication and improving vendor deliverables.
* Implemented ROI Module to measure and analyze returns on a variety of campaigns.
* Benefits delivered include Cycle-Time Improvement from 56 days to 27 days (more than 50%).
* Defined architecture requirements for Campaign Management across GSK's business units.


Senior Consultant - Sales Solutions
2001 - 2003

* Led a technical team on a Customer Targeting System for Sales & Marketing Department which provided the merged sales force with a new methodology for targeting customers.
* Designed technical specifications, data model, interfaces, data flow and process flow in addition to implementing and integrating the above system for Glaxo and SB Heritage data.
* Improved system design and performance tuned complex PL/SQL scripts, queries and reports to reduce processing time from 15 days to less than 24 hours.


PricewaterhouseCoopers, Wayne, PA
1997 - 2001


Senior Associate/Consultant at Gemstar-TV Guide International, Radnor, PA
1999 - 2001

* Led a technical team on a major JIT data warehousing implementation project.
* Designed the dimensional model (Star Schema) for the distribution data warehouse and the ODS.
* Developed complex ETL code using Sagent Plans, DTS and SQL Server Stored Procedures.
* Reduced batch cycle times in half by addressing complex scalability and performance issues.
* Saved TV Guide $3.5MM annually by implementing the above data warehouse.


Associate/Consultant at SmithKline Beecham, Philadelphia, PA
1997 - 1999

* Led a team of system testers for testing Sales Reporting System.
* Established overall system testing strategy and developed test scripts.
* Proposed and supervised design changes that enhanced performance and quality.


Rapidigm Inc., Pittsburgh, PA
1995 - 1997



ORACLE Financials Consultant at Oxford Health Plans, Norwalk, CT
1997 - 1997

* Customized and successfully implemented ORACLE GL, A/P and PO Systems.
* Generated Extracts of FSG reports to feed Essbase Management Reporting System.


ORACLE Financials Consultant at UPS, Morristown, NJ
1995 - 1997

* Developed customer, invoice and payment interfaces for conversion from legacy systems.
* Conducted client meetings and interviews to understand clients' requirements. Proposed, got approval for and implemented solutions that met these requirements.
* Created and maintained interfaces that fed new invoice and payment information.
* Played a key role in upgrade of the product and data conversion effort.


Tata UNISYS, Mumbai, India
1990 - 1995



ORACLE Financials Consultant at Unisys Corp., Uxbridge, UK
1994 - 1995

* Customized and successfully implemented ORACLE A/R and General Ledger systems.
* Developed reports that helped the management understand the customers, their credit lines and their complaints better. Customized the individual customer statements and aged trial balance reports to suit international requirements.
* Interfaced with the General Ledger system to split journals into different set of books based on the client-specified criteria.


Consultant/Systems Analyst at Tata UNISYS for Banco de Venezuela
1993 - 1994

* Implemented a CD-ROM based solution for storing huge and static customer's signature information as part of a product development effort. Played a major role in the qualification of the product by designing and executing test cases and ensuring highest level of quality.


Consultant/Programmer Analyst at Bank One, Columbus, OH
1992 - 1993

* Designed and developed a data entry interface to the document processing system.
* Analyzed the information technology needs and developed the system with utmost quality and under budget. Implemented the system successfully to meet with the global banking standards.
* Handled the responsibility of converting from the legacy system and single-handedly providing user-support. Conducted user training and created user manuals and technical documentation.


Programmer Analyst at Tata UNISYS, New Delhi, India
1990 - 1992

* Developed and tested financial accounting system, payroll system, procurement system and share accounting system.
* Provided installation and support for all of the above systems.

TRAINING/SEMINARS


* Database Marketing Conference 2007
* Forrester's GigaWorld IT Conference
* Essential skills for the Business Analyst
* Seven Habits of Highly Effective People
* Keys to successful project management
* ETL Tools - Informatica and Sagent
* Microstrategy - E-Business
* Data Warehousing Basics & Methodology
* Dimensional Data Modeling
* Ascendant Project Life-Cycle Methodology
* UNIX Shell Scripts & C Programming
* ORACLE Utilities - SQL*Plus, PL/SQL
* SQL Server Utilities - T-SQL, DTS

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-PA-Downingtown »
View all resumes in US-PA »

View other IT Project Manager resumes, IT Manager resumes