PSS-Europe
Project Service Solutions
Newsletter
27th February 2010 | Issue 13
Paul Schlein

Profile

Six years consulting experience in the IT industry has seen Paul work across a range of Industry Sectors including Public Sector, Health Care, Media, Technology and Transportation. This broad analyst background includes gathering requirements, creating and modifying business critical documents, process mapping, stakeholder management and leading UAT (User Acceptance Testing) across the full software development lifecycle.

Paul has gained experienced in Salesforce.com (CRM - Customer Relationship Management) through functional analysis, support and implementations. He is quality focused with strong communication skills to complement technical expertise in Oracle and SQL .

Having successfully operated a tourism and limousine business for 3 years, Paul has acute business acumen and the skills to work autonomously and in small and large team environments. Strong communication, customer service, business and people management skills have been developed and successfully applied for the benefit of his clients in understanding and enhancing the different processes, methods and frameworks.


Key Achievements

•  Led the design, development, testing and deployment of an Oracle de-duplication system for Salesforce.com (CRM) while contracting to Cisco. The solution created a 25% reduction (45K out of 200K records) of end customer data duplicates. This system was so successful that it was later deployed globally.
•  Worked within a team to develop, test and deploy a complex Oracle integration into Salesforce.com (CRM) for Cisco. Paul led the second phase of the complex integration through the full lifecycle of analysis, design, development, testing and deployment.
•  Designed, developed, tested and deployed an automated ETL (Extract, Transform and Load) system pulling data from Salesforce.com (CRM) at Cisco. Previously this process was manual which created time lags and was error prone. Paul identified and highlighted the need to automate this process and developed a new system after documenting the requirements.
•  The lead analyst of an Oracle APEX (Web development) system and played a key role in its design and implementation at LoftusIT. This application was highly visible to the client and ran seamlessly from its implementation.


 

Analyst Skills and Methodologies

Technical Skills

Highly Proficient

•  Formal documentation including Business Requirements Documents (BRD), Functional Requirements Documents (FRD) and Technical specifications
•  Salesforce.com ( CRM) entity relationships and functional analysis
•  Requirements gathering and performing gap analysis
•  Stakeholder management
•  Workshop facilitation
•  System testing and UAT (User Acceptance Testing)

•  Oracle RDBMS (8i, 9i,10g and 11g)
•  Oracle PL/SQL and SQL
•  Salesforce.com (CRM) Apex Data Loader

Proficient

•  Project Management Office ( PMO ) concepts and standards •  Presenting to internal and external clients
•  Business process mapping.
•  Six Sigma, Macroscope, SCRUM (Agile Software Development) and DMAIC methodologies
•  Salesforce.com (CRM) support

•  APEX (formerly HTMLDB) •  Oracle Forms and Reports (6i, 9i and 10g)
•  Unix shell scripts and Windows batch scripts

Familiar

•  Salesforce.com (CRM)implementations
•  UML ( Unified Modeling Language) process modelling

•  Microsoft Visual Basic
•  Java and JavaScript

Platforms

Microsoft Windows, DOS, Linux and Unix


Education

Feb 2003

to

Feb 2004

Graduate Diploma in Information Technology - University of South Australia

High Distinctions in Programming in Java G, Computer and Internet Technology, Object-Oriented System Development (UML process modelling) and Mathematics for Computing. Distinctions in User Interfaces and Objects and Algorithms.

Jul 1997

to

Nov 1999

Bachelor of Management ( Operations Management) - University of South Australia

Dean's Merit List 1998 and 1999. High Distinction in Business Application Programming 2 (Visual Basic). Credit in Business Application Programming (Visual Basic). Distinction in Business Information Systems.


Employment History

Oct 2009

to

Current

PPL – Contract
PPL licenses sound recordings and music videos for use in broadcast, public performance and new media.

Technical Business Analyst - Primary role as an Oracle analyst in within an IT department utilising SCRUM .

•  Reviewed and analysed the Salesforce.com (CRM) implementation.
•  Gathered and documented requirements to facilitate analysis and design of applications.
•  Created and updated Functional Specifications, Unit Test plans and System Test plans.
•  Provided support for system testing and UAT by documenting and repairing of defects.
•  Performed data analysis including the analysis and manipulation business critical of data .

Jun 2007

to

Apr 2009

Cisco – Contract
A multinational corporation with more than 65,000 employees.

Lead Business Analyst - Duties included gathering requirements, process mapping and creating documentation.

•  Created and updated Business Requirements Documents (BRD) and Functional Specifications.
•  Gathered and documented requirements for clients to facilitate analysis and design of applications.
•  Created and modified AS-IS and TO-BE process maps.
•  Performed and documented gap analysis for software releases.
•  Worked as a business analysis covering the whole project lifecycle utilising SCRUM (Agile Software Development).
•  Performed Salesforce.com (CRM) functional analysis and provided post deployment support.
•  Organised and facilitated workshops to gather client input and feedback.
•  Managed stakeholder expectations across all levels with regular communications on the progress of key issues.
•  Led a team in 'end to end' testing and UAT utilising Used Six Sigma, DMAIC methodologies.

Feb 2006

to

May 2007

LoftusIT Consulting
LoftusIT are an independent IT organisation consulting to the public sector and private organisations.

Technical Business Consultant - Including gathering and documenting requirements and developing in Oracle.

•  Designed and developed in Oracle Forms, Oracle Reports, SQL scripts, and Oracle APEX applications.
•  Designed and created Entity Relationship Diagrams (ERD) in Oracle Designer.
•  Gathered and documented requirements for clients as part of software development lifecycle.
•  Introduced Project Management Office (PMO) standards and documentation.

May 2004

to

Oct 2005

Fujitsu Consulting (formerly DMR Consulting)
Fujitsu Adelaide provides application development, support and maintenance to clients throughout Australasia .

Consultant – Administrator of the regional PMO, and as an Oracle Developer and Java Developer.

•  Designed and developed in Oracle PL/SQL, Java and Oracle Reports.
•  Created and tested Unit and System Test Plans.
•  Created and updated Functional Specifications. Participated in Coding Standards meetings and code reviews.
•  Provided support for system testing and UAT by documenting and repairing of defects.
•  Governed project standards and templates and managed Kmentor knowledge repository.
•  Created PMO dashboards and reports and contributed to project review meetings.

Jan 2000

to

Dec 2003

Fleurieu Wanderer and Advanced Limousines (Tourism and Limousine Service) Owner Operator

Owner operator of a business that employed, trained and managed up to 6 staff. Was a member of the local tourism board, developed promotional material and marketed business. Sold business and provided training to purchaser .

1994

to 1997

General Motors Holden
Production Worker

You are receiving this Newsletter because you have subscribed for our newsletter at our site. If you do not wish to receive further news or mailings from YourCompany.com click here to unsubscribe.

Copyright © 2009 PSS-Europe. All Rights Reserved.