Sandra Patricia Smyth.

*** ******* ***. *********, **. 19707

Cell Phone: (1) + (302-***-**-**

E - mail: acomks@r.postjobfree.com

Summary:

The present document summarizes my professional and academic experience, which I present to your consideration as

part of the selection process.

The fifteen years of experience gained during my professional career have been based in the following roles:

Project Manager

Business Systems Analyst

Software Developer

As a Software developer I had work with Microsoft: SQL Server 2005, 2008 Databases, Visual Basic 6.0, Visual

Studio .Net.

Oracle: SQL, PL/SQL and Oracle 8i, 9i, 10g and 11g Databases and Oracle- Developer 2000 (Forms 4.5, Reports 2.5,

Browser), Oracle- Developer 6.0 (Forms 6.0, Reports 6.0), Oracle-Developer 6i (Form 6i, Reports 6i, Procedure Builder,

Query Builder).

• OLTP Experience

• Strong PL/SQL skills, writing Stored Procedures, Functions, Views, Indexes, Partitions, Triggers and Packages.

• Strong knowledge about Tables, Relations and RDBMS concepts.

• Experience with ETL processes, DLL, Data modelling and reporting.

• Experience reviewing, analysing and optimizing SQL code.

• Creating relevant test scenarios for the testing team.

• UNIX Client/ Server environment.

As business Analyst, Eliciting requirements using interviews, business process descriptions, use cases, scenarios, business

analysis, task & workflow analysis, Understanding the business needs to determine how to best functionally fulfil business

requirements.

• Reviewing and sign-off on completed requirements documents.

• Conducting research to determine if solutions to business requirements currently existed within or outside the

business unit, and if not, whether new solutions were feasible.

• Translating business requirements into functional requirements to viable technical architectures, database schema's,

and designs.

• Responsible for the planning and facilitation of standard meetings to include; backlog preparation, iteration planning,

and iteration reviews.

• Leading the project to validate the system accessibility through FDA Regulations (21CFR Part 11).

• Setting the technical standard to link the current Systems at that time with SAP/R3.

As a Project Manager provided support, maintenance services and development of new functionalities and integral

management of the information systems under the best ITIL practices, PMO is part of the Operations Management, in

charge of providing services and managing projects.

• Customize and operate de Customer Relationship Management Software – Sugar CRM.

• Coordinate activities on a specific effort to satisfy business requirements.

• Negotiates agreements and commitments by facilitating communication between business unit(s) and IT from initial

requirements to final implementation

• Able to establish and maintain effective key business relationships with both internal staff and external contacts,

Participate with business representatives/users and business analysts, release manager,

• Facilitate Project meetings and manage its logistics (e.g. Room, Conference Bridge, Agenda, and Participants.

• Manages all assigned projects to completion ensuring on-time delivery, meeting of budgetary demands, and

maintaining overall project ownership.

CERTIFICATIONS

Institute Title

PMP - Project Management Professional

Project Management

Institute RMP - Risk Management Professional

Oracle OCP - Oracle Certified Professional Application Developer

•

ACADEMIC BACKGROUND

Institute Title Year

Valle University MSc. Master in Business Administration 2008

Computer Systems Engineer 2001

School of Business Certified in Telecommunications Management 1999

Administration

INALCEC Internal Quality Auditor - ISO/DIS 9001:2000 1999

IT TRAINING

Institute Course Name Year

Carnegie Mellon Software PSP Personal Software Process Fundamentals 2011

Engineering Institute Leading a Development Team

TSP Team Member Training

TSP Executive Strategy Seminar

Procesix Inc. Development of skills in requirements elicitation 2008

Microsoft Project Professional 2007 2009

Expert Systems Functional Administration of Project Server 2007

Oracle University Introduction to Oracle: SQL and PL/SQL 2001

Develop PL/SQL Program Units

Oracle Forms Developer: Build Internet

Applications I

Oracle Forms Developer: Build Internet

Applications II

Oracle Reports: Build Internet Reports

ADDITIONAL TRAINING

Institute Course Name Year

Grafp Technologies Inc. Statistical Control of Processes 2008

Johnson & Johnson Introduction to Process Excellence Awareness 2005

Dashboards Awareness

Design Excellence Awareness

Six Sigma Awareness

Lean Thinking Awareness

Computer Systems Validation

Competitiveness Assessment Awareness

SAP R/3 Basics

PROFESSIONAL BACKGROUND

Zeotis - Pfizer Aug 2014 to Nov 2014

Environment: Zeotis is a global animal health company, before named as Pfizer Animal Health.

Roles: Business Analyst/Project Manager

Responsibilities:

• Coordinate the Sales Force CRM system integration project.

• Manage the different teams that are involved, local and overseas in order to deliver to production Interfaces with

the legacy systems.

• Prepared documentation to help the support team to respond correctly in case of failures.

• Defined and documents customer business functions and processes.

• Consulted with functional unit management and personnel to identify, define and document business needs and

objectives, current operational procedures, problems, input and output requirements, and levels of systems access

• Acted as a liaison between departmental end-users.

• Analyzed the feasibility of, and develops requirements for, new systems and enhancements to existing systems.

• Ensured the system design fits the needs of the users.

• Tracked documents changes for functional and business specifications.

• Identified opportunities for improving business processes through information systems and/or non-system driver

changes.

• Assisted in the preparation of proposals to develop new systems and/or operational changes.

• Read and interpreted case management systems and functional technical literature and translates in terms

understandable to the end-users.

PMRADAR S.A.S. From May 2011- Jul 2014

Environment: PMRADAR is a company of experts in project management and organizational process improvement.

Roles: Project Manager

I lead Software Development Projects based on the PMBOK project management framework.

The systems information that we support were built with the following technologies:

Microsoft: SQL Server 2005, 2008 Databases, Visual Basic 6.0, Visual Studio .Net.

Oracle: SQL, PL/SQL and Oracle 8i, 9i, 10g and 11g Databases.

Responsibilities:

• Working on multiple projects providing overall prioritization of work assignments, team resources, etc.

• Acts as a single point of contact with the stakeholders for project status, developing regular status reports and

presentations and providing project plan milestones updates.

• Develops, maintains, and manages detailed project plans, action item registers, and major milestone timelines for all

assigned projects.

• Insure resource availability / visibility associated with deliverables.

• Develop resource model associated with large-scale activities.

• Responsible for the planning and facilitation of standard meetings to include; backlog preparation, iteration planning,

and iteration reviews.

• Facilitate Project meetings and manage its logistics (e.g. room, conference bridge, agenda, participants)

• Set weekly agenda (based on program priorities)

• Proactively Manage Action Item / Issues List

• Manage action register and meeting notes

• Track actions that are assigned during working group sessions

• Update status of actions and resolution of issues as progress is made

• Escalate overdue actions for resolution/completion

• Work with the PMO/Operation Manager/Functional Manager to allocate resources to complete all work

• Allocate resources necessary to complete work, proactively identify resources gaps and escalate appropriately

• Using formal processes and tools to manage resources, budgets, risks, and changes.

• Manages all assigned projects to completion ensuring on-time delivery, meeting of budgetary demands, and

maintaining overall project ownership.

• Addresses problems through risk management and contingency planning and presents solutions and/or options to

executive management.

• Ensures effective implementation of solutions/changes.

• Verify and validate results during development of the solution

• Maintains communication with stakeholders.

SQA S.A. July 2010 to July 2011

Environment: SQA is a company dedicated to providing consulting services and software quality assurance.

Roles: Project Manager – Continuous Improvement

Responsibilities:

• Determine the company's operational processes that leverage the core of it, identifying opportunities for

improvement.

• Establish the estimated costs of the process, timing and good practices and / or rules thereof.

• Innovation in service processes and company operations.

• Responsible for training and knowledge of the organization over the area of operations, as well as their technical

documentation.

• Managing technology strategy, processes and IT suppliers.

• Ensure that the proper testing plans have been completed by working with the team to document system test

scenarios.

• Customize and operate de Customer Relationship Management Software – Sugar CRM.

• The company was certified ISO 9000 Bureau Veritas, I was responsible for the re-certification process.

MVM Ingeniería de Software S.A. May 2007 to May 2010

Environment: MVM is an IT Solutions provider. Its strategy is focused on the service of the power and

telecommunications sector. CMMI Level 4

Roles: Project Manager – PMO Project Manager

This role is part of the Operations Management, in charge of providing services and managing projects.

In charge of contracts for XM, an ISA affiliated company, and for other organizations such as: EMGESA E.S.P., an

ENDESA affiliated company, and GENSA E.S.P., in the power generation sector.

It was also my responsibility to coordinate the development group in charge of growing the company product SGR/2.

The systems information that we support were built with the following technologies:

• Microsoft: SQL Server 2005 Database, Visual Basic 6.0, Visual Studio .Net.

• Oracle: PL/SQL and Oracle 8i, 9i and 10g Databases.

Responsibilities:

• As PMO director, it was my duty to set standards and procedures.

• Responsible for project integration management through the PM methodology phases (discovery, planning, execution,

deployment, and close) and ITIL best practices.

• Lead and manage requirements gathering sessions

• Coordinates with other work streams, projects, and initiatives which may impact successful completion of project.

• Manage time, priorities, resources, tools, tasks and information with dependability

• Determining which activities are necessary to complete the project plan.

• Negotiates agreements and commitments by facilitating communication between business unit(s) and IT from initial

requirements to final implementation

• Monitor and create project deliverables.

• Able to establish and maintain effective key business relationships with both internal staff and external contacts.

• Participate with business representatives/users and business analysts, release manager, and/or development manager

in the requirements definition process.

• Manage conflicts, issues and changes with regards to the solution scope

• Lead role in code reviews, implementation plans, contingency plans and updating of disaster recovery plan.

• Work with test team to develop system integration test scripts and execute testing - all to ensure the testing results

correspond to the business expectations.

Major contributions:

• Setting, designing and executing a new model of level requirements service systems. One of the results of this model

was the successful control of the budget.

• Implementation the following processes: Incident, Problem, Change and Application Management.

Johnson & Johnson de Colombia September 2004 to April 2007

Environment:

Johnson & Johnson - Colombia is a multinational company dedicated to the manufacturing and distribution of personal

care products.

Roles: Business Systems Analyst and Oracle Consultant

This role is part of the IM – Information Management area, which provides information management services to each area

of the company.

Responsibilities:

• Eliciting requirements using interviews, business process descriptions, use cases, scenarios, business analysis, task &

workflow analysis

• Understanding the business needs to determine how to best functionally fulfil business requirements.

• Reviewing and sign-off on completed requirements documents.

• Conducting research to determine if solutions to business requirements currently existed within or outside the

business unit, and if not, whether new solutions were feasible.

• Translating business requirements into functional requirements to viable technical architectures, database schema's,

and designs.

• Implementing the designs (design, code, test, deploy) and supporting the deployed applications through debugging,

fixing, and maintenance releases.

• Creating and executing testing plans for the project.

• Working with users, contractors, vendors and technical personnel to meet project milestones.

Some of the main tasks performed were:

• Leading manufacturing automation projects

• Management of the CIM/Factory Link System (which is the Manufacturing Information System).It is relevant to

mention the direct contact with Johnson & Johnson Brazil, as I had to report my performance to them.

• ASAP Methodology knowledge.

Major contributions:

The company worked with BPCS system as its ERP and decided to switch to SAP/R3. During this project my functions

were:

• Setting the technical standard to link the current Systems at that time with SAP (MM & PP Modules).

• Leading the migration and interfaces group for the ORACLE applications.

• Modifying the CIM structure to achieve communication with SAP/R3.

• Leading the CSV-Computer System Validation project to the CIM/Factory Link System.

• Validating the system accessibility through FDA Regulations (21CFR Part 11).

• Generate a better atmosphere between the technology and manufacturing areas through the good service and quality

of the implemented solutions.

• Ensure that the software meets Sarbanes-Oxley regulations.

ESE Antonio Nariño Clínica Rafael Uribe Uribe 11 August 2003 to 30 June 2004

Environment:

The Rafael Uribe Uribe Clinic (www.ESE-AN.com) is a state institution dedicated to provide health care services, being it

the largest clinic in south-western Colombia.

Role: Director IT Department.

Executing administrative and operative tasks of the area, by leading the workforce group in charge of supporting the

Management Information System of the institution and also directly involved in the billing, planning and statistics

processes.

Major contributions:

• Stabilizing the GIS management information system, providing support and acting as a channel of

communication between the institution and the system’s suppliers.

• The systems information that we support was built with the following technologies:

Oracle: Oracle- Developer 2000, PL/SQL and Oracle 8i Database.

• Managing and maintaining the database and reports related to the operation of the institution. (RIPS,

management report, EVALPLAN, Billing, among others).

Open Systems Intl. March 04, 1998 to November 23, 2001

Environment: Open Systems Ltd. www.open.intl, is a company dedicated to developing software for the

telecommunications sector. CMMI Level 4

Role: Oracle Developer

Worked as a development engineer in the production area, by participating in the entire software development cycle

starting from gathering requirements, analysis and solution designing, construction, testing and integration, reaching up

to the review of the end user documentation, using the following development knowledge, tools and skills:

• Oracle- Developer 2000 (Forms 4.5, Reports 2.5, Browser), Oracle- Developer 6.0 (Forms 6.0, Reports 6.0),

Oracle-Developer 6i (Form 6i, Reports 6i, Procedure Builder, Query Builder).

• OLTP Experience

• Strong PL/SQL skills, writing Stored Procedures, Functions, Views, Indexes, Partitions, Triggers and Packages.

• Strong knowledge about Tables, Relations and RDBMS concepts.

• Experience with ETL processes, DLL, Data modelling and reporting.

• Experience reviewing, analysing and optimizing SQL code.

• Creating relevant test scenarios for the testing team.

• UNIX Client/ Server environment.

Major contributions:

• I participated in projects for clients across the country. Clients were telecommunications companies, as Edatel,

Capitel, EPM, Orbitel and Telecom.

• I also worked with this company in Londrina, Brazil, with Sercomtel www.sercomtel.com.br, in an international

project. Among my duties were the collection of specifications for end-user needs, definition of software

enhancements and proposing new developments, which have entailed me to interact with the client throughout the

project.

• I belonged to the group of research and development of new technologies, responsible for research and

implementation of new tools and methodologies within the company.

Other areas of the company with which I had indirect contact:

• Quality assurances area, participating in the tests released by verifying that each program met the requirements and

standards specified by the company.

• Configuration Control Area, participating in the task of verification of object versions ensuring that each

development engineer worked with the latest release and that each client received this latest version.

• The company was certified ISO 9000 ICONTEC, activity in which I participated as Internal Quality Auditor.

Contact this candidate