SUMMARY

• A career of 18+ years has provided a senior level of proficiency in Business Intelligence disciplines.
• This experience includes leading and providing solutions in IT architecture in multiple platforms and data backend engines.
• The responsibilities executed in order to successfully comply with project terms has included: Report Development, Data Administration & Data Warehouse Management.
• Team development and training has also been an important aspect in delivering optimal results.
• Also possess strong project employed in various application developments, tracking & reporting, leading software development staff, and resolution of issues.

PROFESSIONAL EXPERIENCE

Confidential

Member of executive Change Control Board

Responsibilities:

• Contracted to execute Data and BI Architecture tasks such as: and implement BI software and systems, integration with databases and data warehouses, gathering requirements, designing and rolling out BI solutions to end users
• Established data architecture and BI best practices, standards and data models; recommended data warehouse and reporting performance-tuning techniques. Mobilized and directed BI professionals and offshore development team of 3+.
• Generated 80%+ performance gain for enterprise BI systems and by strengthening OLAP database systems.
• Instituted end-to-end technical guidance and end state roadmaps for Clinical, Finance, Research and Analytics & Servicing and Broker and Correspondence data marts.
• Partnered with stakeholders to identify business problems and develop state-of-the-art solutions aligned with business objectives. Provided data warehouse & BI technology vision, roadmaps and blue prints and project plans.
• Implement the Big Data(Hadoop) solution to support the institution research department
• Formulated and executed corporate roadmaps to ensure compliance with SOX and corporate governance criteria.
• As member of executive Change Control Board, developed and refined repeatable framework/processes. Consolidated BI reporting technologies to increase project/program value proposition.

Confidential, United States

BContracted to executeI & Data Warehouse Specialist

Responsibilities:

• Tasks such as: and implement BI software and systems, integration with databases and data warehouses, gathering requirements, designing and rolling out BI solutions to end users, ensuring high levels of BI availability through support functions and in-depth testing
• Requirement's Gathering iImprovement of the current ODS/DW Confidential DW
• Redesign the DW and Data Hub for Confidential • Analysis and design of ETL (Cognos Data Manager 10.1S,MS-SSI and Informatica Powercenter 9) artifacts and report in Cognos 10.2
• Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.
• Involved with business and functional people to collect and gather requirements
• Implement Mock report layouts before the actual report implementation.
• Creating value prompts, Date & time prompts, Text box prompts, cascading prompts
• Hide and Show the objects by using conditional blocks Implemented java script in reports.
• Involved and performed unit testing (manual testing) for the reports that has been developed.
• Developed multi format reports (PDF, Word, HTML & Excel).
• Raised tickets and interacted with different teams for migration of code (SQL Structures, packages and reports) to different environments.•
• Creating & publishing the packages according to the business requirements
• Involved in the scheduling and deployment of the reports, Unit Testing of the reports and preparing the Test cases

Confidential

Contracted to execute Business Intelligence Specialist

Responsibilities:

• Tasks, such as: strategically design and implement BI software and systems, integration with databases and data warehouses, gathering requirements, designing and rolling out BI solutions to end users, ensuring high levels of BI availability through support functions and in-depth testing. Manage up to $500K budget and cross-functional teams (up to 5 team members)
• Roadmap Assessment: current state (physical) & future assessment (conceptual)
• Multi-Year Plan - detailed implementation plan Installation, configuration and administration of Cognos 10 in multiple server environment and 3 tier architecture.
• Support, develop and/or maintain Cognos production global user's environment, metadata layer in Cognos Framework Manager, migrate and deploy application code in multiple environments.

Confidential, United States

Contracted to execute BI & Data Warehouse Specialist

Responsibilities:

• Tasks to implement a new multi-dimensional Risk Management (RM), Continuity of Business (CoB), Supplier Service Agreements (SLA's) Business Intelligence model to generate reliable data about suppliers, regions and other units for analysis.
• Develop a strategy and plan for data analysis transformation, organizational alignment, and process and system refinement. Managed budgets of up to $2M. Provide leadership of all infrastructure technology driving business support services for Third Party Management, Risk Management, Financial Evaluations, CoB, finance, legal and quality engineering.
• Lead IT platforms in managing, configuration, installation, change control, version control, hardware and software utilization, monitoring, and reporting for Citi. Key Technologies: CRM Solutions, Web Solutions, Application Architecture, IBM Cognos 10.2, Oracle, MS SharePoint, MS-SQL Server, Business Objects, Confidential 9.0, Data Warehousing/BI (ETL, Metadata, BI tools), MS-Office suite and MS-Project.
• Responsible for managing technology and business services portfolio, including ETL architecture and development, data management, information delivery, QA and program/project management execution.
• Support North America Cognos Risk Management Site (Sales, Direct Sales, Budget and Planning) Framework projects and packages.
• Perform Customize and out of the box Cognos Trainings for users all around the world (EMEA, LATAM and North America) as per Confidential needs.
• Database Architecture and Design of built procedures using PL/SQL for Oracle 10g and SQL Server.Achievements: Integrated data from CRM, finance, supplier's definition management, onto a single scalable platform with the implementation of Virtual Integrated Report Application (ViRa) to support Global consuming data and reports for Citi within an accelerated 11 months period. Manage: ETL and Report Developers (5 resources), offshore ETL & Report Developers (10 resource) and Business Analyst Group (5 resource)

Confidential

Contracted to as BI Specialist

Responsibilities:

• Develop, maintain and document several BI solutions for Confidential .
• Support for Confidential Global Site (Sales, Direct Sales, Budget and Planning) Cognos Framework projects and packages.
• Perform customized and out of the box Cognos Trainings for users all around the world.
• 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 and manage a Load Balanced Cognos Architecture (6 Gateways, 9 Dispatchers and 5 Contents Store), Cognos 10.x migration and implement Life Cycle Manager.

Confidential, United States

Contracted as BI & Data Warehouse Consultant

Responsibilities:

• To performed analysis and design of a BI System.
• Create the conceptual and physical data model.
• Lead an onsite and offshore team of developers building application DB and maintained the current data warehouse which consisted of government institutions.
• The main fact table contained >1TB size and growing daily
• Design and develop a dashboard using MSTR 9 for the MSTRS clients.
• Design and develop the integration and interfaces report using MS SLQ2008 Integration Services, Reporting Service, Analysis Services and SharePoint as intranet portal.
• Implement MSTR Mobile Solutions.

Confidential

Contracted to perform BI & Data Warehouse Architect functions

Responsibilities:

• This included: Global Site support (Sales, Direct Sales, Budget and Planning) Cognos Framework projects and packages, transformer models, perform customize and out of the box Cognos trainings for users on different site facilities. Implement data modeling best practices.
• Created the conceptual and physical data model in CA Erwin and performed analysis, design and/or data integration: OLTP Systems, Sap, Kingston and Hyperion Software.
• Database Architecture of built procedures using PL/SQL for Oracle 10g and SQL Server and Cognos 10.x migration, using and implement Life Cycle Manager.
• Support, Maintain and develop SSIS Packages for ETL process; also support and manage a Load Balanced Cognos Architecture (6 Gateways, 9 Dispatchers and 5 Contents Store).

Confidential, United States

BUSINESS INTELLIGENCE & DATA WAREHOUSE ARCHITECT

Responsibilities:

• Started as a Consultant and 3 months later hired as an employee to perform analysis and design of an OLTP Systems. Also, provide support to Claims, Providers and ACT & Members Framework Model.
• MMM Data Integration Designer and PM.
• Design and develop a set new reports using Cognos 8.4 MR2 for the following Confidential (AVETA) departments.
• Design and develop the integration and interfaces report using MS SLQ2008 Integration Services, Reporting Service, Analysis Services and SharePoint as intranet portal.

Confidential, United States

Cognos Lead Consultant

Responsibilities:

• To create and maintain Data warehouse and a reporting system for a Global organization.
• Cognos Business Intelligence Series 7 MR2 (Web & Client Server Technologies) and Cognos 8 MR2 Gatheird Requirements, performed analysis of existing OLTP Systems, database architect, designed, and build ETL procedures using PL/SQL for Oracle 10g on UNIX environment. Created reports using Cognos 8 MR2 Designed and created OLAP Cubes using Cognos PowerPlay Series 7 MR2.
• QA, Order Process and Product Manufacturing Status Data Integration in a Real Time Cognos 8 Dashboard.
• Product Inventory and Accounting Cognos 8 Dashboard Accounting and Sales DataMart Gatheird requirements for new systems enhancements and new projects; also perform User Acceptance Tests. Designed and Built ETL procedures using PL/SQL Cognos Decision Stream in MSSQL 2005 Environment and OLAP Cubes, using Cognos PowerPlay Series 7 MR2

Confidential, United States

Cognos Lead Consultant

Responsibilities:

• To implement Cognos Business Intelligence Series 7 MR2 (Web & Client Server Technologies)
• Gatheird requirements for new systems enhancements and projects.
• Designed and created reports using Cognos ReportNet 1.1. and OLAP Cubes using Cognos PowerPlay Series 7 MR2.
• Wrote functional and technical design documents, also performed User Acceptance Test.

Confidential

Database Architect

Responsibilities:

• San Juan, PR (8/05 - 7/06)Contracted as BI & Data Warehouse Lead to perform the following functions
• Created and implemented ETL procedures using Cognos DS and Oracle Warehouse Builder and PL/SQL for an Oracle DB
• 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.
• Created reports using Cognos ReportNet 1.1 and designed and created OLAP Cubes using Cognos PowerPlay Series 7 MR2.
• Cognos 8 migration from Cognos Serie 7 MR2 (Web & Client Server Technologies).

Confidential

2 Reports Developers & 1 ETL Programmer

Responsibilities:

• San Juan, PR (11/05 - 5/06)Contracted as BI & Data Warehouse Lead to perform the following functions
• Supervised and trained: 2 Reports Developers & 1 ETL Programmer.
• 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.
• BI and Reporting solution design and Development for Customer Service, Accounting and Marketing

Confidential, United States

BI Project Manager

Responsibilities:

• To develop and administrate corporate Data warehouse, Risk Management Data warehouse and Cognos Business Intelligence tools.
• Also performed the following functions
• 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.
• 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.

Confidential, United States

SENIOR BI PROGRAMMER / COGNOS ADMINISTRATOR

Responsibilities:

• 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.
• 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.

Confidential, United States

SOFTWARE MANAGER / DBA

Responsibilities:

• 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.
• 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.

SENIOR COMPUTER PROGRAMMER

Confidential, United States

Responsibilities:

• 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.