Project Manager Sales
Resume:
Luis Rovegno
*** ** **** ** *** *-Q SUMMARY
Miami, Florida 33138
305-***-**** IT professional adept in refining business processes, supporting business
305-***-**** applications systems, and all phases of project management. Skilled in conducted
***********@*****.*** internal and external business processes analysis. Able to identify, analyze and
resolve internal customer problems. Proficient in optimizing and applying data models
and developing information systems to improve sales and operational efficiencies.
Defined project scope, wrote requirements, coordinated with experts, programmers /
developers and site testers to ensure successful delivery. Able to clarify, consult and
direct plus work independently or as a team player to solve complex problems. Fluent:
English and Spanish. Experienced in:
● Best Practices in Project Management
● Processes and Systems analysis
● Revenue Management
● Software developing life cycle
● Data warehouse - BI - Reporting
● Business cases / Use cases
● Data Modeling / Business Processes Modeling
SOFTWARE/HARDWARE SKILLS
Proficient in Microsoft Project, PowerPoint, Excel, Word Access, T-SQL and PL-
SQL. Knowledgeable in HTML, Windows/Unix Operating System, Oracle, MS-SQL
Server 2000/2005, Visual Basic, Visual Basic Scrip. Understanding Micro strategy BI
Suite, Business Objects Universe Design and Business Objects Report Design.
ACHIEVEMENTS
Greatly improved LanChile Cargo’s performance reporting process and the
company saved significant time by designing and implementing a centralized and
consistent data warehouse for more rapid and improved decision making.
Realized 7% incremental cargo revenue increase and initiated move to next
implementation phase of revenue management by analyzing the commercial process,
defining required software modifications and new software needed to implement
changes, and evaluating economic impact.
Standardized Lan Cargo’s capacity area to support expected future growth and
enable more money to be made with less people.
WORK EXPERIENCE
7/2009-today
Independent Consultant Miami, Florida
I do consultant in processes and systems analysis, project management, data
warehouse, data modeling and web design.
I have been working as consultant for LAN Chile Cargo where I have done the
following projects:
Design and implementation of a prototype to analyze sales by station, by product, by
commodity and by customer. The prototype was built using SQL as database and
excel.
Currently, I am working in the design and implementation of a prototype to analyze
the performance of the flights by gateways. The architecture used is SQL and excel.
LAN Chile Cargo Group Miami, Florida 1/2002-6/2009
IT Processes Senior Manager
2008-2009
Business Processes Manager
2002-2007
My responsibilities included working collaboratively with customers, users, and
systems architects and designers to identify that needs to be solved, to design and to
implement the solution.
I successfully worked on various projects to make the internal and external
processes more efficient. In particular, defining business requirements, doing cost
benefit analysis, designing the solution, testing and implementing the solution. I
managed all aspects of project (including budget, timeline, scope, quality and
customer expectations). Also, I worked defining data warehouses solution to support
the decisions of different business areas of the organization.
Also, I was in charge of help desk field Team USA to support the communication,
network and hardware infrastructure of USA. The goals of this team was to solve the
problems in the minimum time, to keep the infrastructure up and running and to
implement projects related with communication and networking such as
implementation a PBX in LAX office, renewal of the laptops for USA personnel,
implementation of video conference and changes of menu of PBX . I managed a
budget of 280K/year in different initiatives to keep the hardware and network
infrastructure up and running.
As project manager of business and processes, I managed the portfolio of
commercial projects. Primarily, I worked with users defining business case of any
initiative and then, once the initiative was approved by stakeholders, I managed the
following phases of the project.
Among of the projects where I worked with my team were:
• To design and to implement from the scratch a data warehouse solution this
allowed having information on time to support middle management. The
solution consisted in to create several data marts to support the commercial
and capacity areas of the company. The architecture of this solution was
SQL servers with a several DTS to extract and to transform the data from
online transaction systems. The interface to access these data marts was
access or excel.
• To define and to implement Data warehouse and BI architecture solution to
support the growth of the company in next four years. The solution
proposed was Teradata with BO.
• To analyze, to design, to build and to implement a solution to generate a set
of reports to support capacity weekly operation.
• To incorporate revenue management model for cargo business and its
integration with the different applications of the company. In particular:
o Standardize tools used for commercial and capacity areas (400K)
Sales tools
Capacity tools
Backlog flight tools
Interline purchase tools
Passengers Itinerary tools
o Implementation a revenue management systems for cargo
business (2000K)
• To analyze the pricing processes of LAN cargo and to make the changes
that allowed having rates updated and available for everyone. With these
improvements the pricing process became more efficiency and the billing
system was more accuracy.
• To analyze, to design, to build and to implement a BI application to measure
how well the company accomplishes what it promises to the customers.
The KFI defined was “flown as booked”.
• To analyze, to design, to build and to implement a BI application to measure
how well the customer accomplishes what it promises. The KFI defined was
“Delivery as booked”.
• To analyze local market planning process and to make a proposal to
automate some of KPIs.
• To define a prioritization model to rank shipments once they are accepted.
NCR Corporation, Dayton, OH
System Integration Support
5/2000 – 11/2001
During MBA program I held a co-op position with NCR, Dayton, OH. My principal
duties were providing technical support to NCR Sales Center and developing small
databases using Access.
LAN Chile Airlines, Santiago, CHILE
Project Manager 9/1995 – 8/1999
I worked designing information systems to support different areas of the company.
Projects included General Ledger, Fixed Assets, Treasury, Accounts Payable, Budget,
and Human Resources.
GENER, Santiago, CHILE
System Analyst 9/1991 – 9/1995
I worked as system analyst developing, designing and programming applications to
support different areas of the company. Major projects on which I worked involved:
re-design of supplier payments
overtime payment system
accounting system improvements
Formulation and budget control system using a multi-dimensional database (Oracle
Express).
tools control system using visual basic software
EDUCATION
11/2009 Workshop Micro Strategy, Micro Strategy, Miami
An Introduction TO BI with Micro Strategy
3/2009 Business Objects, SAP Chile, Santiago, Chile
Business Objects: Universe Design
Business Objects: Report Design
12/2001 Wright State University, Dayton, OH
Master's Degree
MBA degree with concentration in Management Information Systems, Wright
State University, 3.8 GPA. Graduated December 1, 2001
9/1996 Information Project Administration, Santiago, Metropolitan area
Certification
3/1988 University of Concepcion, Concepcion, VII Region
Bachelor's Degree
Computer Civil Engineering Degree with concentration in Management
Information System.
References
Reference Name Phone Email
Francisco Arana 786-***-**** ******@********.***
Francisco García (56-2) 327 1512 *******@********.***
Alex Woodman 305-***-**** ****.*******@***.***
Fr David G Russell 305-***-**** ************@*********.***
Contact this candidate