Sandra Patricia Smyth.
*** ******* ***. *********, **. 19707
Cell Phone: (1) + (302-***-**-**
E - mail: ********@*****.***
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.