HECTOR FLORES
CONTACT INFORMATION
San Antonio, TX 78238
ac7ucd@r.postjobfree.com
SKILLS PROFILE
-Business Intelligence ETL Integration Development and Enhancement – Informatica, Microsoft SSIS, Information Builders iWay DQC
-Business Intelligence ETL Report Development and Enhancement – Oracle Applications BI Publisher, Oracle Discoverer, Microsoft SSRS, Microstrategy Desktop and Web, Tableau Desktop 10.2
-Database development – Oracle, SQL Server, Teradata EDW
-Testing - (Unit Testing, System Integration Testing, Regression testing, End to End)
-Support - Root cause identification, Problem Resolution, Process Improvement, Process Documentation
-Requirements Identification and Creation, Data Modeling, SQL Tuning
EMPLOYMENT HISTORY
Blue Cross Blue Shield of Texas May 2015 Current
Lead Information Analytics Specialist – B.I./Database/ETL Development
Responsibilities:
• Requirements analysis and documentation in accordance with business requests among business users.
• Delegation/Assignment of Sprint items to Mid and Junior level Developers.
• Provide guidance and knowledge transfer to Mid and Junior level Developers.
• Reprioritization and Balancing AdHoc work efforts against Sprints.
• Create Transact SQL Schemas, Tables (#Temp, ## Temp, Static Staging and Storage), Views, Stored Procedures, Linked Server extracts,Functions to ingest and source business data according to requirements.
• Develop/modify/tune/test SSIS ETL solutions from functional specifications to efficiently extract, transform, and load data from various data sources (DB2, SQL Server, Mainframe Flat files) to their respective targets (EDW, Files).
• Develop/modify/tune/test outgoing Reports utilizing SSRS and Tableau Desktop 10.2 for data integrity/aggregation totals.
• Create and execute Unit, Functional, Integration, End to End, Regression, Test Cases Create and execute
Data Validation Test Scripts.
• End to End Integration Process Documentation.
• Coordinate closely with Internal Stakeholders to provide daily grain/weekly/monthly/year end Data Extracts/Reports according to specifications.
• Consolidation/Staging of multiple Excel data files in SSMS to produce desired snapshots/data cleansing according to specifications.
Tools: Microsoft SSIS, Microsoft SSRS, Tableau Desktop 10.2, Microsoft SSMS, Toad for DB2, Excel (vlookup and data extraction from SQL Server)
RDBMS: DB2, SQL Server 2005/2008/2012
Operating Systems: Windows XP, Windows 7
Languages: Transact SQL, SQL, DOS Batch Scripting
SWBC Jan 2014 May 2015
ETL Developer
Responsibilities:
• Requirements analysis and documentation in accordance with business requests among business users.
• Develop/modify/tune/test ETL mappings,workflows,service channels from functional specifications to efficiently extract, transform, and load data from various data sources (DB2, SQL Server, Mainframe Flat files) to their respective target systems.
• Develop/modify/tune/test outgoing Reports for data integrity/aggregation totals.
• Create and execute Unit, Functional, Integration, End to End, Regression, Test Cases Create and execute
Data Validation Test Scripts.
• End to End Integration Process Documentation.
• Coordinate closely with Vendors to provide daily grain/weekly/monthly/year end Data Extracts according to specifications.
• Data Modeling and Solutions Design for ETL development efforts.
• Create DDL and DML for table/view/upsert logic to build Database objects for staging and storage for ETL development efforts.
• Coordinate daily with vendors, end users, cross functional teams to facilitate work efforts.
Tools: IBI Iway Data Quality Center, Iway Data Integration Tool, Iway Service Manager,Microsoft SQL Server Management Studio, DQC SQL Editor, Web Focus Reporting Tool
RDBMS: DB2, SQL Server 2005/2008
Operating Systems: Windows XP, Windows 7
Languages: Transact SQL, SQL, DOS Batch Scripting
HEB Data Solutions Mar 2011 Nov 2013
Senior BI ETL Developer
Responsibilities:
• Requirements analysis and documentation in accordance with business requests among business users.
• Develop/modify/tune/test BI EDW Integration workflows from functional specifications to efficiently extract, transform, and load data from various data sources (Oracle, DB2, SQL Server, Access, Mainframe files, Teradata, to their respective target systems.
• Develop/modify/tune/test Microstrategy Reports.
• Create and execute Unit, Functional, Integration, End to End, Regression, Test Cases Create and execute
Data Validation Test Scripts.
• End to End Integration Process Documentation.
• Coordinate closely with Vendors to provide weekly Automated Sales Data Feeds according to specifications.
• Data Modeling and Solutions Design for ETL development efforts.
• Coordinate daily with vendors, end users, cross functional teams to facilitate work efforts.
Tools: Informatica (Powercenter Designer, Powercenter Workflow Manager, Powercenter Workflow Monitor, Teradata SQL Assistant, Oracle SQL Developer, Putty, Toad Data Modeler, Microstrategy Desktop and Web
RDBMS: DB2, SQL Server 2005, Oracle 10G
Operating Systems: Windows XP, Windows 7, Unix
Languages: Unix Shell Scripting, SQL, PL/SQL, Teradata BTEQ
Accenture National Security Svcs. Jul 2007 Mar 2011
Oracle BI Sustainment and Development Analyst – Dept. of Defense
Responsibilities:
• Oracle BI Publisher report development and break fix.
• Oracle Discoverer report development and break fix.
• Custom object (PL/SQL pkb, pks, scripts, ad-hoc queries) creation, tuning, and break fix.
• Data validation testing against report requirements using test scripts.
• SQL Logic Tuning
Tools: Oracle BI Publisher, Oracle Discoverer, Oracle Sql Developer, Oracle PL SQL Developer
RDBMS: Oracle 10G
Operating Systems: Windows XP, Unix
Languages: SQL, PL SQL, XML
West Telemarketing May 1997 Mar 2003
Technical Production Support Analyst
Responsibilities:
• Identify and Document work effort Requirements. Code - using proprietary QAT software (SQL under the hood).
• Create and Execute SQL Extraction/Transformation Scripts to deliver reporting requirements.
• Implementation of code to Production Environment.
• Client ad hoc sql reports and queries.
• Modify/clarify requirements as needed.
Tools: Quality Assurance Testing Software, In house SQL Editor
Operating Systems: Windows
Languages: SQL
Education
Masters Degree in Technology Design and Instruction, West Texas A&M University
Bachelors Degree in General Business Studies, West Texas A&M University
Oracle University - BI/XML Publisher Fundamentals
Oracle University - 11i Financial Applications Overview
Oracle University - Oracle Database 10g: Program with PL/SQL
Microsoft Office Specialist Certification - Outlook and Powerpoint
Microsoft 70-462 - Administering Microsoft SQL Server 2012 Databases
Microsoft 70-463 - Implementing a Data Warehouse with SQL Server 2012
IBM Infosphere DataStage Essentials v11.5 SPVC (2M204)