Project Manager Sales
Resume:
Dear Sir or Madam,
I am enclosing my resume with the intention of explore opportunities at your company. As you can see from my resume, I have a bachelor’s degree in Computer Science from the Metropolitan University, where I graduated Magna Cum Laude. I also have over Twelve years of experience as a senior Datawarehouse and BI Architect, responsible for the development and implementation of business IS applications and systems, to include analysis of all phases of the software development life cycle, risk management, Data warehouse and business intelligence. I am fully qualified to train and supervise personnel, since I possess excellent interpersonal skills, excellent oral and written communications skills, both in Spanish and English, and experience in short and long range project management.
If my qualifications are of interest, I would be delighted to meet with you to further explore opportunities. I hope we have the opportunity to meet shortly, and I look forward to hearing from you.
Thank you for your time and consideration.
Sincerely,
Carlos Esquilín
SUMMARY
Over 10 years experience in IT Architecture in multiples platforms and data backend engines. Report Development, Administration, Datawarehouse Management, Development & Training
Over 10 years experience in Risk Management, Business Intelligence, Data Warehouse, and Business Impact Analysis
12 years experience as a Visual Fox Pro, Visual Basic 6.0, Cognos BI Tools , Business Object BI Tools, Cognos transformer, Oracle and SQL Server software developer, responsible for the development of client server computing software.
Experience in relational database management systems, MSSQL, Oracle and Oracle Warehouse Builder suite.
Experience in ETL Tools systems, MSSQL Integration Services, MSSQL Analysis Studio and Oracle Warehouse Builder suite, Cognos Decision Stream and Cognos 8 BI Data Manager.
Experience in Data Modeling Tools systems CA Erwin and MS Visio Professional.
Experience in MS Integration Services Development.
Project management/ Business Analysis for various application developments; project planning, tracking and reporting status, leading assigned software development staff, and resolution of all project related issues.
TECHNICAL
Computer Software Experience: Cognos ReportNet, Cognos 8, Cognos Impromptu, Decision Stream and PowerPlay, OLAP Modeling, Cognos Framework Manager, Business Object Designer & Reporter, Oracle Warehouse Builders, Microsoft Project, MS Windows XP, Windows 2000, MAS90, Office 2000 Professional Edition, Crystal Reports, Toad, SQL Navigator Internet Explorer 5.0, FTP Explorer, Netscape Communicator, Adobe Acrobat Reader, WS FTP, WinZip 7.0, JCL, Crontab, VAX-VMS, PeachTree, QuickBooks Pro, Lotus 1-2-3, Novell Netware, DB2 and CA Erwin.
Computer Programming Experience: Microsoft Access 2000, Microsoft SQL Server 7.0, Microsoft Visual Studio 6.0, MTS, Fortran 77, Pascal, COBOL, Ansi C, C++, Clarion, D-Base, Shell script, FoxBase, Microsoft Visual FoxPro, and ORACLE Server 8i/9i/10g. Some Btrieve, and Remedy-Client exposure.
EXPERIENCE
05/2011–Present ConvaTec NJ, PA and San Juan, PR
Principal IM Analyst - Global Cognos Lead (Contract)
• Support ConvaTec Cognos Global Site (Sales, Direct Sales, Budget and Planning) Framework projects and packages.
• Support ConvaTec Cognos Global Site (Sales, Direct Sales, Budget and Planning) Transformer Models and packages.
• Perform Customize and out of the box Cognos Trainings for users all around the world depending on the ConvaTec Facility to assist.
• Created the conceptual and physical data model in CA Erwin
• Implemented Data Modeling Best Practices over the ConvaTec Data Schema.
• Performed Analysis and design of an OLTP Systems.
• Performed Analysis and design and Data integration from Sap, Kingston and Hyperion Software.
• Database Architecture and Design of built procedures using PL/SQL for Oracle 10g and SQL Server.
• Support, Maintain and develop SSIS Packages for ETL process.
• Develop reports using Cognos 8.4 for the following ConvaTec’s departments: Sales, Finance, Warehouse, Logistics, Customers Service and Marketing.
• Support and manage a Load Balanced Cognos Architecture (6 Gateways, 9 Dispatchers and 5 Contents Store).
05/2010–04/2011 Medicare y Mucho Mas San Juan, PR
BI and DW Data Architect (Contract)
• Creation of the conceptual and physical data model in CA Erwin Data Modeler 7.3.
• Performed Trizzeto CA Erwin Reverse Engineering.
• CA Erwin Data Model.
• Performed Analysis and design of an OLTP Systems.
• Support Claims, Providers and Members Framework Model.
• Support ACT Framework Model.
• Design and develop a set new reports using Cognos 8.4 MR2 for the following Medicare y Mucho Mas (AVETA) departments.
• Design and develop the integration and interfaces report using MS SQL2008 Integration Services, Reporting Service, Analysis Services and SharePoint as intranet portal.
02/2009 – 05/2010 Wyeth, Empresas Diaz, Cordis LLC, DoralBank, Scotiabank and Ethicon San Juan, PR
BI and DW Specialist/ Architect (Contract)
• Migrate 4 Container’s Process reports from BusinessObjects XI to Cognos 8.4
• Create 2 Framework project and packages using Cognos Framework Manager 8.4
• Performed Analysis and guidelines about the current OLTP Systems.
• Develop a set 10 new reports using Cognos Report Studio 8.4.
• Develop and maintained Marketing and Sales Reports using as data source transformer cubes.
• Wrote functional and technical design documents.
• Performed User Acceptance Test.
12/08 – 02/2009 Highmark Insurance Company Pittsburgh, PA
Cognos Architect (Contract)
• Created The Ratequote Framework project and packages using Cognos 8.3
• Created the Ratequote conceptual and physical data model in CA Erwin
• Implemented Data Modeling Best Practices over the Ratequote Data Schema.
• Performed Analysis and design of an OLTP Systems.
• Database Architecture and Design of built procedures using PL/SQL for Oracle 10g.
• Develop a set 16 new reports using Cognos 8.3 MR2 for the following Highmark’s departments: Underwriting, Proposal Prep, Sales, Customers Service and Marketing.
• Integrate Cognos 8.3 functionality within a new application in Java (Rate Quote) to execute predefined reports, Ad-Hoc query capabilities and event management.
06/08 – 12/08 Heinz Inc Pittsburgh, PA
Cognos/Oracle Lead (Contract)
• Creation and maintenance of a Marketing and Sales report system for a Global organization.
• Creation and maintenance of a Marketing and Sales report Cognos Framework Model and Packages for a Global organization.
• Corporate DW QA and Tuning
o Oracle 10g Corporate Datawarehouse Quality, analysis, documentation and Tuning.
o Implementated Data Modeling Best Practices.
o Performed Analysis of existing OLTP Systems, Database Architect, Designed, and built procedures using PL/SQL for Oracle 10g.
• Develop a set of 5 new Sales and Marketing reports using Cognos 8 MR2.
• Migrate, Designed and Develop a set of 3 new transformer models with 20 OLAP Cubes using Cognos PowerPlay Series 7.4 for the following departments: Marketing, Sales, IT and Ketchup.
• Integration of Cognos Powercubes in Cognos Connection.
• Perform the migration of 6 Daily sales Impromptu reports to Cognos ReportStudio 8.3.
12/07 – 05/08 PRTC San Juan, PR
Cognos Lead Consultant and BI Project Manager (Contract)
• Provide PRTC’s clients with a tool for the analysis of theirs accounts using an Internet Portal with the Integration of invoicing and payments applications. The solution needs to provide row level security (clients and client types) but without the creation of a user for each PRTC’s client of the corporation with a 24/7-365 Internet access into a secure system.
• Developed 21 Bilingual Report Studio Reports using 1 Secure Bilingual Framework packages in a Cognos 8.3 Report Studio.
• Gathered Requirements for the Ebill/Cognos integration.
• Created the eBill Framework project using Cognos 8.3
• Wrote functional and technical design documents.
• Supervised and Directed 4 Mid to Entry Level Resources including 1 DBA 3 Report Developers.
01/07 – 12/07 STR Enfield, CT
BI Lead Consultant and Project Manager (Contract)
• Creation and maintenance of a DSS and Integration system for a Global organization, which represented 3 new contracts for 8 million dollars averages per year in direct profit for the company. In addition to turn the organization into leader in their business between his competitors and clients with the offering of reports for analysis and data integration with a 24/7-365 Internet access into a secure system.
• Complete a Corporate BI solution using BO Business Intelligence XI (Web & Client Server Technologies including Crystal Report XI and Data Federator)
• Universes or Metadata Layer Design and creation to serve multiple BI and Report Systems including but not limited to
o Client Information Delivery Systems(extranet, Single Sing on secure platform)
o Senior Management Decision Support Systems
o Internal Accounting and Sales Reports.
o Others
• ODS Data Model design using Erwin Data Modeler.
• Creation and maintenance of the Corporate ODS
• Creation and maintenance of the Performance Management and QA and Transactional.
• Corporate applications Integration system for a Global organization, in a 24/7-365 Internet access into a secure system.
• Gathered requirements for new DSS enhancements and/or new systems.
04/06 – 01/07 OJI Papers Ware, MA
Cognos Lead Consultant and Project Manager (Contract)
• Creation and maintenance of a Datawarehouse and a reporting system for a Global organization.
• Creation of the Corporate Manufacturing Process Datawarehouse
• Data Modeling Documents and Best Practices Implementation.
• Cognos Business Intelligence Series 7 MR2 (Web & Client Server Technologies) and Cognos 8 MR2
o Gathered Requirements for any BI project.
o Performed Analysis of existing OLTP Systems, Database Architect, Designed, and Built ETL procedures using PL/SQL for Oracle 10g on UNIX environment.
o Created reports using Cognos 8 MR2
o Designed and created OLAP Cubes using Cognos PowerPlay Series 7 MR2.
o Wrote functional and technical design documents.
o Supervised and Directed 6 Mid to Entry Level Resources
o Performed User Acceptance Test.
o Presented status reports to senior management.
• QA, Order Process and Product Manufacturing Status Data Integration in a Real Time Cognos 8 Dashboard.
• Product Inventory and Accounting Cognos 8 Dashboard
• Sales Performance and Cognos 8 BI Suite (IDS) Creation
• Accounting and Sales DataMart
o Gathered Requirements for new systems enhancements and/or new projects.
o Designed and Built ETL procedures using PL/SQL Cognos Decision Stream in MSSQL 2005 Environment.
o Designed and built OLAP Cubes, using Cognos PowerPlay Series 7 MR2
o Performed User Acceptance Test.
• Integration of Cognos Powercubes and Cognos Connection.
• Migration of Impromptu to Cognos Reportnet 1.1 reports.
05/06 – 07/06 Decision Resources Waltham, MA
Cognos Lead Consultant and BI Project Manager (Contract)
• Cognos Business Intelligence Series 7 MR2 (Web & Client Server Technologies)
o Gathered Requirements for new systems enhancements and/or new projects.
o Created reports using Cognos ReportNet 1.1.
o Designed and created OLAP Cubes using Cognos PowerPlay Series 7 MR2.
o Wrote functional and technical design documents.
o Performed User Acceptance Test.
• Cognos Powercubes and Cognos Connection Integration.
• Migrate Impromptu and Cognos Reportnet 1.1 report to Cognos 8.
11/05 – 05/06 Centennial of PR San Juan, PR
BI and DW Lead (Contract)
• Gathered Requirements for new systems enhancements and/or new projects.
• Created and implemented ETL procedures using Oracle Warehouse Builder and PL/SQL for an Oracle DB.
• Designed and built OLTP Reports for Decision Support BO 6.5 and BO XI.
• Presented status reports to Senior Management.
• BI and Reporting solution design and Development for Customer Service, Accounting and Marketing
• Created technical design documents.
• Supervised and trained 3 individuals including:
o 2 Reports Developers.
o 1 ETL Programmer.
08/05 – 05/06 AIG Insurance San Juan, PR
BI and DW Lead (Contract)
• Datamart and Integration Requirements Gathering.
• Created and implemented ETL procedures using Cognos DS and Oracle Warehouse Builder and PL/SQL for an Oracle DB.
• Cognos Business Intelligence Series 7 MR2 (Web & Client Server Technologies)
o Gathered Requirements.
o Performed Analysis of existing Transactional Systems to create DM Schemas, Database Architect, Designed, and Built ETL procedures using PL/SQL for Oracle 10g on UNIX environment.
o Created reports using Cognos ReportNet 1.1.
o Designed and created OLAP Cubes using Cognos PowerPlay Series 7 MR2.
o Wrote functional and technical design documents.
o Performed User Acceptance Test.
• Cognos 8 migration from Cognos Serie 7 MR2 (Web & Client Server Technologies).
• Cognos 8 Self-Service IDS and Reports Creation
• Presented status reports to Senior management.
02/05 – 08/05 Island Masters Finance San Juan, PR
BI - DW Lead and Project Manager (Contract)
• Developed and administered corporate Data warehouse, Risk Management Data warehouse and Cognos Business Intelligence tools.
• Implemented and maintained Cognos Business Intelligence Report Portals and ETL Solutions.
• Developed reports in Cognos BI Suites, Cognos ReportNet, SQL and Oracle 9i.
• Developed Oracle Server 8i and 9i PL/SQL, stored procedures, triggers and functions to upload mining data from the corporate data warehouse and corporate applications.
• Create UNIX shells to schedule ETL Jobs Execution, Monitoring Crontab shells execution for completion.
• Examined all aspects of financial risk management in banking, from global considerations to the fundamental aspects of the management of profit.
• Assessed processes and methodology, and implemented strategic project management, to include disaster recovery, business impact analysis, and money laundering training.
12/2000-02/2005 Popular, Inc. San Juan, PR
Senior BI Programmer/Cognos Administrator
• Development and administration of the corporate Data warehouse, Risk Management Data warehouse and Cognos Business Intelligence tools.
• Implemented and maintained Cognos Business Intelligence Report Portals and ETL Solutions.
• Developed reports in Cognos BI Suites, Cognos ReportNet, SQL and Oracle 9i.
• Analyzed, developed, implemented and maintained reports in Cognos ReportNet for Customer Care, Marketing, Risk Management, & finance departments, in the intranet and internet browsers and schedulers.
• Developed Oracle Server 8i and 9i PL/SQL, stored procedures, triggers and functions to upload mining data from the corporate data warehouse and corporate applications.
• Developed work-flows and Oracle Warehouse Builder suite.
• Performed system administrator duties for Cognos & Business Objects systems.
• Create UNIX shells to schedule ETL Jobs Execution, Monitoring Crontab shells execution for completion.
• Examined all aspects of financial risk management in banking, from global considerations to the fundamental aspects of the management of profit.
• Implemented issues of risk management to include value at risk (VAR), risk-based capital (capital at risk), asset liability management, loan portfolio management, credit risk, market risk, interest rate risk, liquidity risk, funds transfer pricing, and capital allocation.
• Assessed processes and methodology, and implemented strategic project management, to include disaster recovery, business impact analysis, and money laundering training.
• Supervised and trained 3 individuals including:
o 2 Reports Developers.
o 1 ETL Programmer.
03/2000-12/2000 TTI, Inc. San Juan, PR
Software Manager/DBA
• Development and administration of the corporate Data warehouse, Risk Management Data warehouse and Business Intelligence tools.
• Implemented and maintained Cognos Business Intelligence suite.
• Developed reports in Cognos BI Suites versions 6.5 to 7.3, Cognos ReportNet, SQL and Oracle 9i.
• Defined and implemented the database set-up, coding, tolls, processes and systems, necessary to enable the success of the Red Reserva database.
• Responsible for managing, supervising, and training 5 individuals in the design, development, programming, and implementation of banking regulated applications using Visual Basic 6.0, VB Script, Access 2000, and SQL Server 7.0 in a Windows NT 4.0 environment.
• Worked with Microsoft Transaction Server, MAS90 regulated software, and Remedy-Client software.
• Able to analyze and interpret information, highlight key issues and present finding to cross-functional teams.
• Supervised and trained 7 individuals including:
o 6 Software Engineers.
o 1 DBA.
01/1995-03/2000 PR Computer Guaynabo, PR
Senior Computer Programmer
• Responsible for the development and implementation of business IS applications and systems for customers like: Triple SSS, Caribbean American, and National Insurance
• Carried out technical reviews of systems and designed program interfaces utilizing Fox Pro, Visual Fox Pro 6.0, FoxBase for Unix, Btrieve, Visual Basic 6.0, Microsoft Access, C and C++, and SQL Server in a Windows NT 4.0 environment.
• Analyzed and developed tables, reports and forms of database designed in Foxpro.
• Supervised and trained individuals.
EDUCATION
Certificate, Cognos 8 Data Modeling and Advance Report. San Juan, Puerto Rico, 2006
Certificate, BO Designer. San Juan, Puerto Rico, 2005
Certificate, BO Reporter. San Juan, Puerto Rico, 2005
Certificate, Oracle Warehouse Builder. San Juan, Puerto Rico, 2005
Certificate, Crystal Reports. San Juan, Puerto Rico, 2002
Certificate. Risk Management. Banco Popular de Puerto Rico, San Juan. 2001
Certificate, Cognos Impromptu Administrator. San Juan, Puerto Rico, 2000
Certificate, Cognos PowerPlay Administrator. San Juan, Puerto Rico, 2000
Certificate, Cognos DecisionStream Administrator. San Juan, Puerto Rico, 2000
Certificate, MS Office 2000. San Juan, Puerto Rico, 1998
Certificate, Visual Basic 6.0. San Juan, Puerto Rico, 1998
Certificate, Microsoft SQL Server. San Juan, Puerto Rico, 1998
Certificate, Microsoft FrontPage. San Juan, Puerto Rico, 1998
Bachelor’s Degree. Magna cum Laude. Computer Science. Universidad Metropolitana, Cupey, 1992.
Contact this candidate