Ed Velasco 
   “ (860) 961 9550

SUMMARY
Mr. Velasco has eleven years of experience on Information Technology, providing
services and solutions to the Pharmaceutical, Financial Services, Insurance,
Manufacturing, Utilities, Retailing and Chemical industries. He has excellent
business analysis and technical skills. His experience includes full SDLC for
several projects within the Client Server and Web environments. He specializes in
the Design, Development, QA and Implementation of Data-warehouses and Enterprise
Business Intelligence / Reporting solutions. 

Functional Areas: Research & Development, Accounting, Finance, Human Resources,
Sales, Engineering, Information Technology, Customer Service and IT Support.
Methodologies: SDLC, RAD, Dimensional Modeling, Use Cases, CMM, Six sigma, ACE
and QA Testing.
SKILLS PROFILE 
Business Intelligence Tools: SAP Business Objects Suite, Informatica, Data
Stage, IBM Cognos BI, SQL Server Services, Hyperion IR , Oracle BI, Crystal
Reports, TOAD, CA ERWin, SQL Developer and SQL Programmer.
Databases / DB Tools: Oracle, Sybase, MS SQL Server, SQLBase, DB2, UniData,
Lotus Notes, Fox Pro, MS Access and SQL.
Programming Languages: PL/SQL Packages, TransactSQL SP, C++, HTML, XML,
Java/ASP, JavaScript, Centura-SQL Windows, Visual Basic, Power Builder, Oracle
Developer and UNIX's shell (sh, ksh and Pro*C).
Application Package: Oracle AS, Microsoft IIS, Computron, Adaytum, Ariba,
Documentum, Service Center, Rational Rose, SunGard Global One , Policy Management
System (PMS), PeopleSoft, Aurum's SalesTrak software, Autosys, BEA WebLogic,
InstallShield, SharePoint, Clarify, Visual Source Safe/PVCS, Microsoft Office and
Adobe Acrobat Writer.
Desktop Tools: Adobe Design CS, Visio, Cinema 4D, Adobe Photoshop, Adobe
Dreamweaver, Macromedia Flash, Fireworks, Adobe Illustrator, MS FrontPage, Corel
Photo-Draw and Photo-Paint.
Operating Systems: Windows Server, UNIX, Novell, OS/400 and Mac OS X.
Testing Tools: Mercury Quality Center, WinRunner, TestDirector and QARun.
EDUCATION
M.S. Management MIS
Rensselaer Polytechnic Institute B.S. Computer Science
Anahuac University

PROFESSIONAL EXPERIENCE
2008 - 2009 HANOVER INSURANCE GROUP, Insurance. Senior Business Analyst DW/BI
Developer - Worcester, MA
Business Analyst member of recently formed Enterprise Data-warehouse (EDW).
Dedicated to Commercial Lines and Personal Lines, gathering requirements to
conform subject areas for Policies, Quotes, Premiums, Claims and Billing data.
The subject areas were integrated into the Data-warehouse. The requirements
included the reporting needs for the created Data-warehouse.
Personal Lines
    Gathered requirements for the MVR Order Activity Report. Established key
Metrics for agent MVR  's requests (Metric Studio) versus new business issued.
Provided with business requirements and technical specifications for the data
model (Framework) and report layout (Report Studio. Created and prepared the
project and corresponding package to be published in the production environment.
The requirements included the scheduling and printing of the Agent  's Statement
report for distribution. 
    Based on the requirements gathered, proceeded to develop several key reports
for the MVR Operational group. Reports were based in both relational and
dimensional models. Pages (Dashboards) for quick analysis were created using
prompts (linked to transactional reports) and several graphical Cognos tools. 
    Worked closely with the QA team to guarantee the delivery of the user
functionality.
Commercial Lines
    Interviewed several key CL Vice-presidents, Underwriters and Actuaries to
gather and define business data elements requirements (BRs, definitions, names
etc) and priorities for the CL Auto Details project.
    Following the company  's BA best practices created several BA deliverables
such as the BA Strategy, Conceptual Data Model (CDM), Business Data Elements List
(BDE), Business Requirements Document (BRD), Data Dictionary, Traceability
Matrix, Security Review, Peer Review Checklist and required Signoffs (business
reviewed and approved the BA documentation). Comply with all the audits by
keeping up-to-date the SharePoint repository for the project.
    Constantly analyzed, estimated, logged and monitored changes to the
requirements which had an impact in the existing DW and the Business Objects
reporting environment. 
    Several meetings with the development team were held to review and approve
the technical designs to assure they met the Business Requirements. The technical
documentation included detailed DW Database Diagrams, resource planning,
timelines, mappings design, QA Activities and other considerations.
    Researched data from different source systems such as Policy Management
System (PMS) and Point Of Sale (POS). Created detailed information for valid
values and their business definition. This helped defining sources, loads,
transformations and target tables for the Informatica  's mappings creation.
    Created documentation for testing using Mercury Quality Center. The Business
Scenarios included cases for the ETL and Reporting.
    Gathered detail requirements for ad-hoc reporting such as the Data Elements
and Folder Structure documents. Using Hyperion IR defined and designed the
Data-model including complex queries and reports. 
Environment: Business Objects Suite, Cognos BI, Informatica, Oracle, DB2,
Hyperion IR, Sharepoint, PL/SQL, ERwin, TOAD, Mercury Quality Center, IBM QMF,
PMS, POS, MS Office/Project and Windows Server/Citrix.

2007 - 2008 UNITED TECHNOLOGIES CORP, Manufacturing. Senior Business Analyst
DW/BI Developer- Windsor, CT
As part of the HR Systems group, participated on the SWAT Reporting team to
identify improvement opportunities for Report Builder. RB is part of the EES HR
portal (Employee Self-Service - HR Application) used by all the busineses to
report on Employee information, Salary, Benefits, Performance evaluations, Global
Population, Strategic Planing.
    Interviewed several key HR Directors from UTC Corporate, Pratt & Whitney,
Hamilton Sundstrand, Carrier, Sikorsky, Otis, Fire and Security. Meetings and
minutes helped in gathering and defining business requirements and
priorities.During the process collected/analyzed several Business Objects
Universes and Reports that the different businesses used instead of Report
Builder. 
    Documented key aspects of the RB system (Replication, Report Scheduling,
Report Generation) by using Java style design patterns. This facilitated the
understaning of the complex tasks/components.
    Evaluated the possible sustutitution of the existing reporting enviroment
with Business Objects and/or SQL Services. Stablished a POC environment using SQL
Server Services. Created a project and reproduced several existing reports using
Reporting Services (SSRS). Additionaly created two data cubes for Analysis
Services (SSAS).
    Reported final findings to the HRIS Director, resulting in scheduling of
development work and process improvement projects.
    Created a Quality Assurance strategy for the offshore team. 
    Provided advice to the RB Support Team to document and improve their PS
process. By defining roles and reponsabilities (first level support vs. four
tier), created the first PS workflow. Drafted E-mail templates for the most
common issues such as reciving a request for service, followups, interruption of
key services etc.
    Based on the scheduled work. Created/modified several reports based on
different Data-Sets (similar to BO Universe). 
    As IT developer. Performed impact analysis, development (ETL PL/SQL) and
documented the activities according to the SDLC for the HR Application.
Development included change requests and new projects. Created detailed test
plans for IT and User Acceptance Test (Mercury Quality Center).
Environment: Business Objects Suite, Business
Analysis/Planning/Design/Development, Data-warehousing, Oracle AS, PL/SQL, ERwin,
TOAD, JavaScript, UNIX scripting, MS Office/Project and Windows Server.

2006 - 2007 UBS, INVESTMENT BANKING. DA Architect/BO Developer   “ 
 Boston, MA
Responsible for suggesting and implementing the critical reporting system for
Earnings, using the Business Objects platform (Desktop/Web). Acted as Universe
Designer, Developer and Administrator for BO.
    Played a substantial role in the business and functional requirements
gathering, in an effort to develop a practical technology solution for automating
the Client  's statement delivery process.
    Researched several BI tools according to vendor and the Gartner Quadrant
information. Created Proof of Concept using the two front runners Cognos and
Business Objects. Several reports were reproduced using the two BI tools and
presented to the client. Presented our preferences to the Bank and proceeded to
elaborate a robust presentation for the proposed solution.
    Resposible for the environment procurement and implementation. Established a
Business Objects Development, UAT and Production environments within the Bank's
shared services. Created the Best practices and related support documentation
corresponding to the implementation.
    Created/reviewed Use Cases/Activity Diagrams/State Chart Diagrams/Sequence
Diagrams, and Collaboration Diagrams thus defining the Data Process Model and
Business Process Model (Business / IT alignment).
    Based on the requirements, designed, administered and developed all reports
and the Universe. Reinforced the syncronization across environments by defining
rules for publishing and removing objects. 
    Used BroadcastAgent/VBA to design and develop a complete report distribution
mechanism for the Bank's internal and external clients.
    Coded several Sybase Stored Procedures to support reporting. Designed and
created database structures for the same purpose. 
    Provided daily production support for production releases. Migrated several
reports to