SUMMARY:

• Senior technology professional driving growth and competitive advantage to businesses and corporations through solutioning and delivery of innovative, best - in-class business intelligence and analytic solutions.
• Excel in navigating challenging, matrix environments, managing multiple initiatives simultaneously, and delivering tactical solutions through all phases of project life cycle software delivery lifecycle (SDLC). Excellent interpersonal skills, effectively leading cross-functional teams while inspiring quality performance.
• Experience and broad-based skill set span numerous technologies applied in multiple industries, including state government, financial services, telecommunications, retail, and oil and gas industries.
• ETL and Data Integration Data Warehousing Big Data
• Business Intelligence Technical Management Data Transformation

TECHNICAL SKILLS:

Databases: Microsoft SQL Server Oracle Teradata DB2/UDB Netezza IMS

Cloud: Amazon Web Services (AWS) Fundamentals

Big Data: IBM BigInsights HADOOP Hive Cassandra HBase NoSQL Python Pig Sqoop

Data Integration/ETL: Microsoft SSIS IBM InfoSphere (DataStage) Informatica Ab initio

BI Reporting: Microsoft SSRS Microsoft Power BI Tableau TIBCO Business Objects Cognos

Languages: SQL MS Script Unix Script MVS/ISPF

Methodologies: Waterfall Agile

Operating Systems: Unix / Linux Windows Server MVS

Data Model tools: ERWin Data Modeler

Other: HPQC/Test Director Microsfot TFS Quest TOAD Embarcadero Autosys PVCS SourceSafe API XML OLAP/ROLAP XML

Languages: Fluent in English and Spanish (native Spanish speaker)

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Manager/Specialist Leader

Responsibilities:

• As part of the Maintenance and Operations (M&O) engagement for the State of Arkansas' Department of Health Services ( Confidential ), manage the Business Intelligence (BI) Team responsible for maintaining, operating and enhancing a large application portfolio that assists in the operations of multiple divisions within Confidential . Manage existing (and new requirements for) ETL interfaces, batch design, supporting data models and databases, reports development, BI solutions development and the extract, transformation and loading of data into the Enterprise Data Warehouse (EDW). Richard also support BI analytical requirements through the design and development of dashboards using Microsoft Power BI technology.
• At a major U.S.-based global supplier of telecommunications, managed software development and work products produced by the technical team, including Technical Design documents, Source to Target Mapping documents, Data Model, and Informatica job components. Team consisted of onshore and USI resources, responsible of implementing a Revenue Recognition Engine (“RRE”) to meet the requirements of the Accounting Standards Codification (ASC) 606. Designed future state target architecture, to support the ASC 606 Revenue Recognition solution.
• Engaged in all areas of the Software Development Lifecycle of technical solutions, including business requirements, design, development, User Acceptance Test, implementation/deployment, and product knowledge transfer .
• Project managed team activities of a team of 10-20 onshore resources, including contractors and Confidential consultants.

Confidential, Atlanta, GA

Executive Consultant

Responsibilities:

• Supported pre-sales/proposal, as well as the design, development and implementation of numerous Data Warehouses, Business Intelligence and Big Data deliveries.
• Proposed future state/solution architecture to modernize client’s information integration, and reporting/analytics capabilities, to enable better business decisions making.
• Engaged in all areas of the Software Development Lifecycle of technical solutions, including business requirements, design, development, User Acceptance Test, implementation/deployment, and product/solution
• Led, and participated in client's technical and readiness assessment to mission-critical Data Warehouse systems and applications.
• Project managed team activities and technical deliverables of small to large (10-30+) technical resources, both onshore and offshore resources.
• Partnered with Program Management Office (PMO) leadership, Architecture and Governance teams to define strategies for Data Quality Management, Master Data Management, BI Security Access strategy and Change Control Process, and gain alignment with Enterprise Data Governance around policies and standards supporting these areas.
• Trained and mentored junior programmers in programming methodologies and best practices.

Confidential, Edison, NJ

Senior Consultant

Responsibilities:

• Led development with track record of incorporating user and business requirements into cost-effective solutions, with high-degree of scalability and reusability.
• Engaged in all areas of the Software Development Lifecycle of technical solutions, including business requirements, design, development, User Acceptance Test, implementation/deployment, and product/solution 
• Project managed team activities and technical deliverables, of small to medium (10-20) technical resources, both onshore and offshore resources.
• Trained and mentored junior programmers in programming methodologies and best practices.

Confidential, Little Rock, AR

EDW/BI Manager

Responsibilities:

• As part of the Maintenance and Operations (M&O) engagement for the State of Arkansas' Department of Health Services ( Confidential ), I manage the Business Intelligence (BI) Team responsible for maintaining, operating and enhancing a large application portfolio that assists in the operations of multiple divisions within Confidential . Our team manages existing (and new requirements for) ETL interfaces, batch design, supporting data models and databases, reports development, BI solutions development and the extract, transformation and loading of data into the Enterprise Data Warehouse (EDW). We also support BI analytical requirements through the design and development of dashboards using Microsoft Power BI technology.
• Project managed team activities and technical deliverables of (20) technical resources, including contractors and Confidential ’s.
• Produced and presented weekly and monthly project status reports to Confidential and Confidential management, managed issues and risks impacting delivery of requirements in the project.

DI Team Manager, Solution Architect

Confidential, Linthicum, MD

Responsibilities:

• Managed software development and work products produced by the technical team (including Technical Design documents, Source to Target Mapping documents, Data Model, and Informatica Job Components). Team consisted of onshore and USI resources, responsible of implementing a Revenue Recognition Engine (“RRE”) to meet the requirements of the Accounting Standards Codification (ASC) 606. To assist client achieve New Revenue Standard compliance, the program included implementation of a custom staging layer responsible of extracting, transforming transactional data applying defined business rules, and creating outbound interfaces to be consumed by a 3rd party tool to support Revenue Recognition (i.e. Aptitude Revstream).
• Designed future state target architecture, to support the ASC 606 Revenue Recognition solution.
• Project managed team activities and technical deliverables of (25) technical teams, both onshore and offshore resources.
• Produced and presented weekly and monthly project status reports to management, managed issues and risks impacting the project.

Project Manager, Solution Delivery Lead

Confidential, Bakersfield, CA

Responsibilities:

• Supported the pre-sales/proposal phase of this ($4MM) Data Warehouse solution project in support of client’s Data Foundation program intended to modernize their information integration, governance and reporting/analytics capabilities.
• Led overall (end-to-end) solution architecture and solution outline, which supported all components of the solution, including ETL/Data Integration Solution (Data Quality component), (3NF) Data Warehouse and Semantic Layer Solution, and BI Report and Data Consumption Solution. Project comprised of the following delivery phases:
• Project managed team activities and technical deliverables of (20) technical teams, both onshore and offshore resources.
• Produced and presented weekly and monthly project status reports to management, managed issues and risks impacting the project.

Lead Architect

Confidential, Carrolton, TX

Responsibilities:

• Supported the pre-sales/proposal phase of this ($2MM) project to implement a Data Warehouse and BI Solution to support client’s Tax and Accounting Unit needs for deeper data analysis and reporting.
• Collaborated with client’s architects based out US, UK and Banglore, and India, to develop the overall (end-to-end) solution architecture, and capabilities to be supported. Future state architecture will support the process and integration of 60+ mission-critical source systems into a newly defined Tax & Accounting data warehouse and data marts.
• Partnered with PMO leadership, Architecture and Governance teams to define strategies for Data Quality Management, Data Privacy/PII and BI Security Access strategy, and alignment with defined Enterprise Data Governance policies and standards.
• The technology used in this project included Informatica, Oracle Exadata, and Business Objects.

Solution Architect supporting a Big Data Proposal

Confidential, Dallas, TX

Responsibilities:

• Served as a Solution Architect, supporting the pre-sales/proposal phase of a ($30MM) Big Data platform solution to address the growing needs for data analysis, as well as reporting and predictive analytics, for Government officials and managers at this city.
• Delivered proposal for a Big Data platform, to support the acquisition and integration of structured and unstructured data from multiple sources and departments, with the goal to enable city users to improve their operations, while concurrently providing better service to the City and its citizens. Solution incorporates Data Lake and Lake Reservoir data repositories, in conjunction with state of the art technology including BigInsight, BigMatch, SPSS, Apache Spark, Cognos BI/Cognos Mobile, and Watson Analytics.

Solution Architect, Technical Lead

Confidential, San Jose, CA

Responsibilities:

• Served as a Solution Architect and Technical Lead/Manager. Also, supported the pre-sales/proposal phase of the ($5MM) engagement.
• Managed software development and related work products produced by the development team, consisting of 40+ onshore and offshore members, targeted to implement client’s future state Data Warehouse and BI analytical reporting solution, geared to support the consolidation and integration of various company’s mission-critical source systems into a newly defined corporate data warehouse and data marts, as well as corporate-level reports, dashboards, and advanced analytics.
• Provided leadership, including SDLC and architecture oversight across the multiple data warehouse domains, and key associated constructs, with emphasis on Data Integration (DI) Architecture and Macro and Micro designs, Data Model, System Test Strategy, as well as Business Intelligence (BI) Architecture strategy and Semantic Layer design.
• Led client's technical and readiness assessment to mission-critical Data Warehouse systems and applications, including its Big Data/Hadoop Data Discovery system. Leveraged industry best practices and IBM’s BI Architecture, conducted a series of interviews and workshops to gather current state capabilities and maturity level, and produced executive report documenting findings, gaps and recommendations for each of these Data Warehouses and applications.
• Performed as a part-time Project Manager, including creation of the project plan and associated tasks and milestones, and estimating work efforts, produced and presented weekly and monthly project status report to the client, managing/reporting on issues and risks impacting the project.
• Partnered with Architecture and Governance/Data Steward teams to define strategies for Data Quality Management and Master Data, and alignment with defined Enterprise Data Governance policies and standards.
• The technology used in this project included Netezza, IIS Datastage and TIBCO Spotfire.

Solution Architect, Technical Lead

Confidential, Freeport, ME

Responsibilities:

• Served as the Solution Architecture with the responsibility to define and deliver client’s future state EDW/BI Architecture. Produced the Solution Outline, or high-level view of the architecture, defining the key components of the solution (business, architecture, organization), leveraging best practices from the IBM GBS Architecture.
• Supported the pre-sales/proposal phase of this ($3MM) project, working with a small team to develop proposed solution, statement of work/contract, and effort estimation.
• Managed software development and related work products produced by the Data Integration team, including Data Integration software development and related work products produced by our team (ie Macro and Micro designs), Data Model, Data Mapping, and BI Architecture.
• Delivered proposal for an Enterprise Data Provisioning solution, leveraging a Data Lake approach in a Big Data platform, targeted to support the ingestion, sharing and distribution of source system data for operational and integrated requirements by the data warehouse and other downstream applications in need of this data.
• Proposed strategy to deliver Financial Data to the client’s data warehouse, leveraging SAP BW accelerators (versus SAP R3 operational data) to reduce complexities and development time in delivering this data to the Data Warehouse.
• Partnered with PMO leadership, Architecture and Governance/Data Steward teams to define strategies for Data Quality Management and Data Privacy/PII strategy, and alignment with defined Enterprise Data Governance policies and standards.
• Performed project management activities, including estimating work efforts, producing and presenting weekly and monthly project status report to the client, managing/reporting on issues and risks impacting the project.
• The technology used in this project included DB2, IIS Datastage and Microsoft SQL Server Analysis Services.

Work stream Lead, BI Reporting SME

Confidential, Boston. MA

Responsibilities:

• Served as the Work Stream Lead in the BI Reporting area with the responsibility to conduct a readiness assessment against the reporting specifications, and produce an executive report summarizing findings, along with set of recommendations to improve current practices to produce these reports.
• Conducted interviews, and reviewed reports specifications produced by client teams producing reports, as well as SDLC practices in place supporting these reporting efforts. Performed interviews with SSC's Enterprise Servicing Platform (ESP) IT team in the US, to review established SDLC practices and procedures for design and implementation of new FNC Client source data into ESP, as well as the creation and implementation of corresponding ESP Categories and Report Marts, supporting FNC reports. After the conclusion of the interview cycle and facts-finding, produced the following deliverables:
• A comprehensive assessment report for the UK Accounting Pack and Dutch Investment as part of FNC Reporting effort
• Produced an executive report summary on the assessment results and gap analysis, along with a set of recommendations for SSC to review and act upon.

DI Architect

Confidential, Charlotte, NC

Responsibilities:

• Served as a Data Integration (DI) Architect, and lead a key organizational initiative to define a comprehensive Data Integration and Information Delivery platform.
• Defined the DI Architecture, ingesting DI best practices, and enabling standard processes and artifacts, to efficiently support data capture/acquisition, qualification, transformation, movement, and publish of data into/from the company’s data warehouse. A series of DI re-usable components were strategized (i.e. components solution decks were produced), and aligned for near-future development, including: Technical Data Quality, Change Data Capture (CDC), Surrogate Key (SK) Generation, ABCs (Audit, Balance and Controls, DB Load Strategy, Error/Exception Handling, Duplicate Keys Handling, and Job Failure and Recovery. Mr. Hernandez was ed with a Service Excellence .
• Performed project management activities, including estimating work efforts, producing and presenting weekly and monthly project status report to the client, managing/reporting on issues and risks impacting the project. As part of the Proposal phase in this ($2MM) project, produced technical content in the statement of work, for the proposed solution.

Solution Architect

Confidential

Responsibilities:

• Supported the pre-sales/proposal phase for this ($4MM) Enterprise level Customer Data Strategy that provides the necessary guidance for data management, consumption and governance to build a comprehensive and single view of a customer to effectively deliver a consistent and differentiated customer experience across all client’s businesses, products, and channels.
• Participated in the Development of the proposed solution architecture, statement of work/contract. Also, participated in Orals.

DI Architect, BI Manager

Confidential, Columbus, OH

Responsibilities:

• Served as the DI Architect and BI Manager with the responsibility to implement and deploy IBM’s Banking Data Warehouse Model (BDWM), to accelerate of key foundational goals in their Integrated Consumer Data Warehouse Organization (ICDW), which included:
• Reducing the complexity of information systems through: Rationalizing analytical systems and platforms, move existing information systems into a single environment, reduce data redundancy, standardize data management, Improving data quality and access controls.
• Building new analytical capabilities to enable JPMC lines of business to drive competitive advantage through more efficient use of client’s information assets.
• Deploying a less complex, fully integrated data model to enable cross-customer and product-domain analytics, and Implementing Informatica Data Integration (leveraging Pushdown Technology)
• Partnered closely and extensively with stakeholders, architects, leadership and subject matter experts at this client, to define, extend and implement following key directives within client’s ICDW organization:
• Defined/extended BI guiding principles in ICDW, focusing on Design and Development standards to be adopted under every project release in ICDW.
• Defined and extended the ICDW Audit Model and a technical solution supporting Audit Controls in ICDW.
• Partnered with client’s Data Governance group to define and solution process to effectively handle and integrate new Certified Classification values into ICDW, and align with defined Enterprise Data Governance policies and standards.
• Defined a standards Data Quality Framework for Technical and Business Data Quality (ie TDQs & BDQs), and mechanisms that are tightly coupled with Data Integration processes around data quality.
• Working with senior executive levels both at IBM and at the bank, delivered a proposal for a framework and roadmap to establish a consistent and differentiated customer experience through a single customer view.

DI Architect, Technical Manager

Confidential, Charlotte, NC

Responsibilities:

• Served as the DI Architect and Technical Project Manager with the responsibility to implement and deploy IBM’s Banking Data Warehouse Model (BDWM) to provide the bank with an end-to-end Customer view, and BI reporting capabilities.
• Managed software development and related work products produced by a large size IBM team in this engagement, consisting of 30+ onshore and offshore members. He led the implementation and deployment of the Data Integration Solution, for (4) major production releases, covering multiple Lines of Businesses (LOBs) within the bank, including: Customer, Mortgage, Deposits and Credit Card information; processing information from 30+ source systems across these LOBs, in a very standardized and highly effective fashion. The technology used in this project included IIS Datastage ETL jobs, Unix, Stored Procedure and Teradata technologies.
• Engaged in multiple areas of the implementation, including: Project Management, BDW Model Change Management Control, Technical Requirements, DI Architecture, DI Design and Development, Code Reviews, System Integration and User Acceptance Test cycles and Production Deployment. Mr. Hernandez was ed with several distinctions and Service Excellence s by this client and IBM, for achieving timely and quality delivery in all his deliverable.
• As part of the Proposal phase in this ($10MM) project, produced technical content in the Statement of Work, for the proposed solution.

DI Architect

Confidential

Responsibilities:

• Served as the DI Architect with the responsibility to implement and deploy an Enterprise Data Warehouse (EDW) as part of the BASEL II implementation at this client.
• Managed the ETL development and implementation efforts of the Staging Area and Operational Data Store (ODS) as part of the EDW architecture. These two areas serve as key architectural and data integration platform to receive, transform, store and integrate data from the 30+ (internal and external) source systems. The technology used in this project included IIS Datastage ETL jobs, MVS, Unix and DB2.
• As part of the Proposal phase in this ($4MM) project, produced technical content in the Statement of Work, for the proposed solution.

BI Manager

Confidential, Pontiac, MI

Responsibilities:

• As the I Manager with the responsibility to implement and deploy an Enterprise Data Warehouse (EDW), led the development and implementation effort of the EAS Subject Area in the EDW. The EAS Subject Area supported by IBM’s DB2 Entity Analytic Solutions (EAS), brings a new level of accuracy to encompass and maintain customer identity and relationships. This development effort leveraged the use of a DB2 Stored Procedures and XML technology as part of the ETL solution.
• The technology used in this project included Informatica (v8.1.1) (ETL Tool), XML, DB2 UDB DBMS, DB2 Stored Procedure and Unix.
• Performed project management activities, including estimating work efforts, producing and presenting weekly and monthly project status report to the client, managing/reporting on issues and risks impacting the project. As part of the Proposal phase in this ($3.5MM) project, produced technical content in the Statement of Work, for the proposed solution.

DI Architect

Confidential

Responsibilities:

• Engaged in the analysis and definition phase of the client’s Data Mart Consolidation program, in the role of DI Architect, and led definition of key requirements, target state solution/architecture and the fundamental steps in support of the defined cost reduction targets, business benefits and (future) built of the Banking Data Warehouse (BDWM) industry model.
• Managed the ETL Analysis effort to identify all current architecture and informational assets for target solution: 1) Existing ETL code and artifacts (Ab Initio, SQL, Cobol routines, etc.) that requires improvement and/or technology upgrade and 2) Reusable objects/assets that can be leveraged in the future ETL architecture. As part of the daily activities, I was involved in multiple areas of the implementation, including: Project Management, ETL Architecture and Design, Technical Requirements and Source Code Analysis. Interacted and closely collaborated with Senior Management level and the client’s Architecture team. The technology used in this project included Ab initio (ETL Tool), DB2 UDB DBMS, Unix and Erwin.

BI Manager

Confidential, Atlanta, GA

Responsibilities:

• Served as the BI Manager with the responsibility to implement and deploy a Credit Risk Management and Basel II Business Intelligence/Data Warehouses for this client.
• Managed the implementation effort of several Program Change Requests (PCR’s) to integrate new source systems into the Enterprise Data Warehouse to enhance its capabilities for additional credit risk reporting (e.g. Moody Risk Analyzer/MRA, Obligor information). As part of the daily activities, he was involved in multiple areas of the implementation, including: Project Management, Technical Requirements, User Acceptance Test (UAT), Data Source Analysis and ETL Design. Interacted and worked directly with Senior Management level and Subject Matter Experts in specific lines of business. The technology used in this project included Ab initio (ETL Tool), DB2 UDB DBMS, SQL Server DBMS, Unix and Erwin.
• Performed project management activities, including estimating work efforts, producing and presenting weekly and monthly project status report to the client, managing/reporting on issues and risks impacting the project.

Technical Lead, Business Analyst

Confidential, Chicago, IL

Responsibilities:

• Served as a Business Analyst and DI Lead, responsible for developing the business requirements for a new Credit Risk MIS reporting database for the new North American retail lending holding company of a large multi-national bank via the implementation of the Risk Management Data Mart. Responsibilities included interviewing Corporate Credit Management to procure Business Intelligence/reporting requirements and leading interviews with the 12 business unit and 3 corporate finance entities to source account level data and document logical business rules and physical transformations to create approximately 130 risk measures for storage in the database.
• Performed project management activities, including estimating work efforts, producing and presenting weekly and monthly project status report to the client, managing/reporting on issues and risks impacting the project. As part of the Proposal phase in this ($6MM) project, produced technical content in the Statement of Work, for the proposed solution.

Technical Manager

Confidential, Richmond, VA

Responsibilities:

• Served as the Technical Manager in the analysis of data sources and the development of high and low level designs to support mission-critical interfaces between multiple transactional systems (i.e. VISA, MasterCard and others) and the newly acquired Card and Merchant System, CAMS II, by this client.
• Managed software development and related work products of the technical team, and worked as a hands-on developer in the implementation of multiple Campaign Management Business Intelligence/Data Warehouse projects leveraging IBM Unica. Adhering to client’s SDM, the IBM team was responsible for the design, development and implementation of extraction and interfaces, transformations and load into the data warehouse.
• The technology used in this project included Oracle scripts, PL/SQL, NCR/Teradata, Ab initio software, HP’ Unix and Korn shell scripts.
• Performed project management activities, including estimating work efforts, producing and presenting weekly and monthly project status report to the client, managing/reporting on issues and risks impacting the project. As part of the Proposal phase in this ($6MM) project, produced technical content in the Statement of Work, for the proposed solution.

Technical Manager, Sr. ETL Developer

Confidential, Richmond, VA

Responsibilities:

• Served as a DI Technical Manager in the analysis of data sources and the development of high and low level designs to support mission-critical interfaces between multiple transactional systems (i.e. VISA, MasterCard and others) and the newly acquired Card and Merchant System by Confidential .
• Led the technical team composed of a mix of Senior and seasoned developers, through the development, test, implementation and migration of the ETL code.
• Worked as a hands-on developer in the implementation of multiple Campaign Management Business Intelligence/Data Warehouse projects. Adhering to client’s SDM, the IBM team was responsible for the design, development and implementation of extraction and interfaces, transformations and load into the data warehouse. The project built over 50 processes that Interfaces with numerous sources, including those from the Campaign Management tool--Unica as well as other internal (Teradata) Account Management tables owned by Users.
• The implementation was performed using multiple technologies, including: Oracle scripts, PL/SQL, NCR/Teradata, Ab initio software, HP’ Unix and Korn shell scripts. Worked closely with Ab initio graph components in the High and Lower Level designs for the coding and testing of the ETL code movement design and code, including: parametized and linked graphs, parallel and conditional components, wrapper scripts, promotion cycle into EM>E.
• Supported project management activities, including serving as single point of contact (SPOC) for issues that may affect solution and solution delivery, identifying issues and problems that need immediate focus and resolution leveraging key IBM and/or client resources to resolve issues.

Sr. ETL Developer

Confidential, Stamford, CT

Responsibilities:

• Successfully designed, code, tested and implemented all ETL processes to create and load the Operational Data Store and Data Mart (DM) for a major Re-Insurance client. The Data Mart has the purpose of providing multiple executive management and business reporting analysis. As part of the implementation, Mr. Hernandez and his team established a Standard Record Layout to be followed by the client's International subsidiaries and soon expected to implement a mart. The implementation was performed using both PL/SQL and the Informatica PowerMart Tool in a Oracle (v8.1.6) RDBMS and Windows NT environment.
• Successfully designed, coded and tested all negotiated G/L Interfaces for a major financial client (U.S. and Bermuda based) as part of the ExpressPac' PeopleSoft G/L and A/P implementation. ExpressPac is Confidential ' new mid-market offering for Financials. By means of negotiating specific design standards to be followed by both U.S. and Bermuda based companies, the team achieved to deliver a system that is as modular and reusable for (near) future Interfaces. The development was accomplished by using Informatica PowerMart as the ETL tool (while using Oracle 8i as the RDBMS platform).
• Delivered a session to leverage the client on the new system and acted as the Technical lead for the implementation while managing daily activities of one senior level Consultant.
• Acted as the Technical Lead and hands-on developer while managing daily activities of one junior-level consultant.