Project Manager
Resume:
VON AUSTIN, MBA
Morris Plains, NJ 07950
*********@*****.***
DATA OPERATIONS MANAGER / BUSINESS SYSTEMS CONSULTANT
IT business analyst and project manager with record of positive
results in the strategic areas of data warehousing, systems analysis,
application development and data analysis and administration.
Demonstrated ability using analytical and project management expertise
to successfully achieve goals. Recognized for combining interpersonal,
negotiation and leadership skills managing teams and multi-tasking
throughout project life cycles. Known for learning and understanding
new concepts quickly and using them to improve business systems.
Recognized for using communication skills to achieve success in areas
such as: Building client partnerships. Increasing customer
satisfaction. Developing and delivering informative presentations.
1 TECHNICAL SKILLS
Programming Languages Database Systems Operating Systems Services and
Tools
DB2 DB2 AS400 MS Excel
MS Visual Basic MS Access MVS MS PowerPoint
MVS COBOL SQL UNIX HP-UX MS Project
Oracle PL/SQL Oracle 9i UNIX SunOS 5.9 MS Visio
UNIX Shell Scripting Oracle 10g Windows NT MS Word
AWK Sqlplus DMExpress
SQL Informatica
Crystal Reports
PROFESSIONAL EXPERIENCE
Business Systems Analyst, Pfizer / Arrow Strategies
2009-current
Currently working as a member of the C&CM ITAM Project Team. The overall
goal of this project is to create a complete infrastructure footprint of
all Pfizer assets to facilitate communication of outages as they occur as
well as downstream effects on other CI's (Configuration Items).
. Part of a 69 billion dollar Integration project involving the
migration of over 45k assets ranging from hardware to software.
. Configuration and Change Management processes - to create a complete
infrastructure footprint of all IT assets.
. Collecting data and assisting with presenting, informing and training
of over 50+ clients on a global basis and helping them understand the
importance of the initiative and streamlining the data gathering
process for them.
. Assisting with loading and QA'ing data for all assets into the new
database that supports Pfizer's instance of ServiceCenter while
gaining knowledge of 21 CFR Part 11.
. Providing assistance to the Change process and helping clients with
training and acclimating themselves to the new Pfizer asset management
processes.
. Extensively used advanced functions of MS Excel including VLookups,
Pivot Tables and Macros, MS Access, SQL and Crystal Reports.
Data Operations Manager / Business Systems Consultant, Pursuit Consulting
Group 2008-2009
Pursuit Consulting Group partners with companies to provide IT solutions to
clients such as Sanofi-Aventis Pharmaceuticals.
. Greatly increased productivity and effectiveness of new vendors.
Combined technical and communication skills authoring New Vendor On-
boarding Guide, procedural information guide for vendors. Worked
extensively with external vendors. Collaborated with Accenture
Consulting.
. Increased consistency and control of existing data exchange processes
and standards. Presented recommendations to the IS Marketing and
Business Strategy department.
. Provided understandable, user friendly data to clients. Combined
interpersonal, communication and analytical skills bringing sponsors,
stakeholders and vendors together assuring clarity for all.
. Eliminated redundancy in deliverables. Analyzed business needs and
recommended changes to requirements. Performed gap analyses.
Monitored and reported on SLAs and SOPs.
. Documented and clarified business processes and systems. Wrote,
edited and published several documents including Project Charter,
Project Management Plan, User and Functional Requirements
Specifications and System Design Specifications for IS Marketing and
Business Strategy. Developed business process flows and traceability
matrices. Developed RACI roles/responsibility diagrams.
. Greatly improved the tracking of deliverables. Developed, recommended
and maintained an eRoom folder structure for documents and templates
authored and used by the consulting group.
IT Project Lead / Senior Systems Specialist, Johnson & Johnson/Pfizer
1999 - 2007
. Elevated the analytics and business intelligence required by
Professional Sales & Marketing. Developed, implemented and supported
robust data warehouse replacing a PC based system. Used Microsoft
Access extensively. Transformed data from multiple sources.
Developed knowledge of Dendrite SFA.
. Established data exchange standards assuring data quality. Led the
implementation of data exchange processes to the warehouse. Used SQL,
SQL Loader, Unix Shell Scripting and FTP extensively.
. Served as liaison between Professional Sales & Marketing and IT
responsible for project and issue management and communications. Led
the development team through all phases of the System Development Life
Cycle (SDLC). Coordinated Joint Application Development (JAD)
sessions. Developed project plans and was responsible for verbal and
written project team communications. Wrote RFPs for consulting
services. Worked to deliver project within budget constraints.
. Assured the project conformed to SDLC guidelines. Gathered, analyzed
and documented complex business, functional and system requirements.
Wrote and published SDLC documentation including technical design
specifications, report design and layout specifications.
. Gained system acceptance and satisfaction from the client. Managed
the project team and participated in application development,
development of test scripts, system and user acceptance testing,
technical analysis and deployment. Performed post-implementation
reviews.
. Assured design and development for system performance by providing
detail and aggregated data structures for MicroStrategy and Hyperion
Brio Business Intelligence. Led team efforts of dimensional modeling,
data mapping, normalization, star schemas, database design and
architecture of the warehouse using Erwin Entity Relationship
management.
. Increased system performance and streamlined applications. Developed
a strong knowledge of Oracle relational database management systems
and UNIX operating systems. Used SQL, Oracle PL/SQL stored
procedures and UNIX Shell scripting extensively for application
development. Used TOAD and SQL Navigator extensively.
. Increased the effectiveness of tracking project application
development. Researched, evaluated and recommended source code
version control tools. Used Samba, MS Visual Source Safe and PVCS.
. Upgraded servers and operating systems. Led the migration of the
enterprise Data Resource Center (DRC) data marts from HP to Sun OS
servers. Liaised with UNIX Network Administrators.
. Improved relationships with DRC data mart clients. Spearheaded the
effort of ensuring that DRC data mart requirements were met during the
SAP to RCS conversion. Worked extensively with ERP systems.
Conducted weekly project status meetings with data mart
representatives. Wrote and presented documentation of data used by
each data mart. Resolved issues and problems related to the
conversion. Received the coveted Panther award for exceptional
customer service as a result of building excellent customer
relationships.
. Developed knowledge of syndicated and third party data.
. Provided transformed data from ODS to data marts. Used Informatica
ETL to stage and load Supply Chain, EDI, shipment status, Item master
and Inventory data resulting in transformed data for marts.
Provided support to Pfizer Consumer Healthcare e-Commerce system.
. Assured conformity to financial principles and regulations. Supported
and maintained the interface between the Enterprise Data Resource
Center and the Corporate General Ledger. Supported the Corporate Tax
System.
1 EDUCATION
MBA, Marketing and Finance, Centenary College
BA, Mathematics, Lincoln University
Contact this candidate