Resume

Sign in

Data Developer

Location:
San Antonio, Texas, United States
Posted:
November 30, 2018

Contact this candidate

Resume:

HECTOR FLORES

CONTACT INFORMATION

210-***-****

***** ***** *******

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)



Contact this candidate