Project Manager Data

Richard Macedo

*** ******** *******

Middletown, CT 06457

813-***-**** **********@*****.***

Skills Summary

Bilingual Program Manager, Business and System IT Analyst with more than ten years of experience

assisting users in identifying and describing problems and opportunities addressed by implementing

new software and changing existing systems as well as providing software management and

business solutions to privately own companies. Recognized for ability to establish, target, and meet

all facets of the project lifecycle to achieve critical goals. Demonstrated great communication, team

building capabilities, organizational skills and analytical thinking oriented to business processes.

Experience

University of Tampa, Tampa, FL Aug 2007 – May 2009

Graduate Assistant – MBA Program

As a Graduate Assistant on the Academic Advising Department, I was responsible for integrating data

from different business sources and allocating data by functional, operational, business, and reporting

units. Several of my responsibilities included to:

Provide weekly/monthly metrics updates of student progress across departments using excel

reports

Created data cross-reference maps and attribute transformation tables between what

business needed and current system tables

Led specification review meetings with business and IT to ensure accuracy of extracted data

Developed SQL store procedures and VBA Excel scripts for Proof of concept reports and

testing

Program Analyst and Data Analyst for a MS Access system for Student Demographics,

Accomplished Practices, Surveys Analyst and Reports and a range of statistics for the

students. The aim was to transform data into information used to support critical decision-

making and university management reporting.

Privately owned companies, Lima, Peru Jan 2004 - Jul 2007

Independent PM/System Analyst

Managed and implemented all facets of the customer IT projects lifecycle. From gathering customer

requirements to managing all phases of the of the business process including project budgeting, time

and cost control as well as all the SDLC phases to its final implementation, data analysis, customer

training and support. Responsibilities included, among others:

Create, maintain and follow a Project Schedule to keep track of tasks and milestones

Worked closely with developers, testers, solution architect and the PM team to deliver

software solutions to internal business customers

Performed requirements analysis & documented these business requirements into systemic,

accurate and detailed functional & technical specification documents

Authored gap analysis documents, data flow diagrams, logical & physical data models &

assisted in the design of OLAP data marts and views for the company EDW

Analyzed stored procedures and SSIS jobs to find the source of data anomalies & initiated

and managed change requests

Additional responsibility included building, publishing & maintaining Data Dictionary for

relational and analysis services databases

Acted as an information specialist identifying data sources and providing data points to

multiple project requirements as part of application integration processes

Created conversion process flow documents, enterprise relationship diagrams, data flow

diagrams, and program flowcharts in Visio

Performed extensive data validation & data manipulation, developed report prototypes

including trend analysis reports, pivots tables, test automation scripts, test cases for end-to-

end & user-acceptance testing

Analyzed users' business requirements in detail, prepared functional specifications for new or

changed systems

Designed templates, training documents, process flow diagrams and other crucial artifacts to

help business set expectations and provide sign off prior to development

Performed the cost/benefit analysis for having or not having the system

Obtained estimates of the cost of operating and maintaining new or changed systems,

assuming use of appropriate technology and tools

Managed systems’ budgets monitoring costs and expenditures in accordance with the original

estimates

Maintained strong working relationships with business groups, managers and all stakeholders

while reporting progress at regular intervals

Banco de Credito of Peru, Lima, Peru Feb 1997 -

Dec 2003

System Analyst / Project Manager

Assembled project teams, assigned individual responsibilities, identified appropriate resources

needed and developed schedules to ensure timely completion. Project leader for a broad range of

systems based on different technologies (web, B2C, B2B, client/server and n-tier level) using a

variety of tools.

Gathered and documented business requirements from end-users. Performed analysis of business

processes generating precise and detailed functional and technical specification documents while

gathering feedback and sharing the vision. Prepared Data Flow Diagram for all the assigned systems.

Experience in linking functional requests and technical support, negotiation, problem resolution, team

building and decision-making.

Member of the Project Management Team for the Internet Strategy of Banco de Credito of Peru.

Active member of the IT Committee for establishing best practices and standards for software and

development. Member of the team in charge of coaching new IT personnel.

Analyzed and developed the entire data models to link and support all the stages of business

processes. Intense use of database tools and objects to model, get, transform, upload, organize,

analyze, report and link several external and internal business areas and providers data.

Designed and developed users' manuals, corresponding training programs, test plans, installation

and start-up for all the assigned systems.

Analyzed existing reports, data entry screens, system applications, and captured process flows & use

cases to document policies, procedures & scenarios

Conducted user interviews, gathered, modeled & tracked requirements.

Created various workable templates and documents for the development team.

Intensive use of MS SQL Server Tools as the main database for the client/server and web

applications. Developed a range of interfaces to interact with IBM Host applications.

As data analyst, analyzed the business needs, data sources and current systems. Had interviews

with business users to create or understand requirements. Created mapping documents, enforced

data integrity and data quality. Developed and defined physical and logical data models, application

data dictionary and metadata. Used Erwin as Data Modeler to define, organize, create and manage

databases of several providers.

Accomplishments:

ViaInversiones website project. Internet Stock Exchange Market Services provided by Banco

de Credito of Peru. Increased the traded average volume from 700,000 USD to 2 million USD

per month

ViaInmuebles website project. Solution to buy and sell real state over the internet. Awarded

Peruvian Best 2001 Business Creativity Project

Project leader for a range of other Corporate websites (part of the bank internet service)

Installation on time of the new bank budget system. Acquired from Comshare: Budget Plus.

Allowed transition from an Excel sheets based budget to an automated budget software

Automated charged payment system. Automated payment bills for a range of services such

as telephone, cable, cellular phones and other utilities services. Implemented with 100%

satisfactory result

Automated customer follow-up system for the internal bank attorney’s department

WorkFlow for customer requesting for copy of documents delivered by the bank. Reduced

manual processes by 30%

Automated employee entry control system for the Human Resource department. Allowed

central control and management of employee schedules

Expropriated buildings and houses management system. Reduced the double tax payment

due to the manual process

TANDEM Computers del Peru, Lima, Peru Jul 1996 - Jan 1997

Network Consultant

ATM, Ethernet, Fast-Ethernet, etc network consultant.

Social Security Institute of Peruvian Government, Lima, Peru Jan 1996 - Jun 1996

Network Consultant

Member of the Implementation and Installation Team of the first ATM Network in Peru; done in

collaboration with Olivetti of Peru.

BCTS - Business Consulting & Technology Services, Lima, Peru Aug 1995 - Dec 1995

Programmer

Programmer of a Payroll Software Package sold and implemented in different financial institutions

University of Lima, Computer Science Department, Lima, Peru Jan 1992 - Jul 1995

Undergraduate Teaching Assistant

Undergraduate teaching Assistant in more than eight courses in the System Engineering Department.

Education

The University of Tampa, Tampa, FL May 2009

Master of Business Administration - Finance Concentration

ADEX (International Trade Association), Lima, Peru Sep 2005

International Trade

Stock Exchange Peruvian Institute, Lima, Peru Sep 1999

Specialization Program in Stock Exchange, Commodity and Financial Markets

University of Lima, Lima, Peru Dec 1995

Bachelor of System Engineering, Dean’s List

Technology Skills

Operating Systems: Windows

Modeling: UML, Visio, Erwin

Programming: Visual Basic, DCOM, COM, PowerBuilder, Visual InterDev, Centura, Java, Visual Age

for Java, Oracle PLSQL, JavaScript, VBScript, ASP, DHTML, Crystal Report

Data Bases: Microsoft SQL Server (satisfactory completion of the Implementing, Managing &

Administrating and Performance & Tuning courses), MS SQL Server DTS, Access, Oracle

Others: Microsoft Internet Information Server, Microsoft Office & Visual Basic for Application, MS

Project, Oracle Crystal Ball. High level skills analyzing business and financial data performing

sensitive analysis, scenario analysis and simulation as well as creating business models for optimal

solutions (Linear Programming) using MS Excel Solver and performing business forecasts using

seasonal and non-seasonal models.

Language and Personal Skills

Oral and written English and Spanish. Highly detailed and meticulous, organized, responsible,

leadership, work under pressure and good work companion.

Contact this candidate