SUMMARY:

• Business Intelligence Development, ETL, Data Warehousing, Data Modeling (OLTP, Star Schema, hybrid), SQL Server & Oracle Databases, SSIS, SSAS, SSRS, Informatica PowerCenter, Cognos Report/Analysis/Query Studio, Framework Manager, Transformer. Environments: on premise, AWS, Azure.

TECHNICAL SKILLS:

Hardware: IBM PC, Cisco routers, PIX firewall, SuperMicro and IBM.

Operating systems: Windows 9x, 2000, XP, 7, Linux.

Servers: MS Windows 2000, 2003, 2008, 2012, IIS, Tomcat, Active Directory, DNS, DHCP, WINS, MS Exchange Server 2000, 2003

Programming: VB, VB.NET, ASP.NET, C++, JavaScript, Perl, SQL, HTML, XML, CSS, UML, Object Oriented Methodology.

Databases: MS Access, Oracle, MS SQL Server 2000, 2005, 2008, 2012, 2014

ETL Tools: Informatica PowerCenter, Oracle Warehouse Builder (OWB), SQL Server Integration Services (SSIS), Cognos Data Manager

Software: Cognos 8, 10 BI, Framework Manager, Cognos PowerPlay, Cognos Impromptu, Cognos Transformer, Cognos Planning, Cognos Finance, Cognos Power Insight, Visual Studio.NET, Crystal Reports, Veritas Backup Exec 9.x, IIS, Symantec Anti - Virus Corporate Edition, MS Visio, MS Reporting Services (SSRS), Erwin and many more.

Web development: Macromedia: Dreamweaver, Fireworks, Flash, MS FrontPage, ASP.NET

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Data Architect/ETL Developer)

Responsibilities:

• Created data models for front end application in Oracle 11g.
• Built ETL, using PL/SQL Packages and procedures in Oracle 11g
• Learned Big Data processing engine Spark & Scala.
• Build ETL using Big Data Spark on DataBricks and AWS cloud.

Confidential, Miami

Cognos Business Intelligence Developer

Responsibilities:

• Developed custom Cognos reports and Active reports using Cognos 10.2.2
• Built Cognos Framework Models and extensions to existing models.
• Wrote custom stored procedures and scripts to extract data from SQL Server.

Confidential, Coppell, TX

Data modeler/Informatica ETL Developer

Responsibilities:

• Developed data models (hybrid OLTP & Star Schema) and source to target mappings.
• Built ETL mappings and workflows in Informatica PowerCenter.
• Loaded data into target Oracle schema.
• Wrote SQL and PL SQL scripts to extract data from Oracle & SQL Server databases.

Sabre, Southlake, TX

Data modeler/Solution Architect

Responsibilities:

• Developed sophisticated back end data models to support front end application using Erwin and SQL Server.
• Developed all required tables, views, functions and stored procedures to support front end web application.
• Designed workflow and processes from data collection to data retrieval.
• Build SSIS ETL and stored procedures using SQL Server 2014.

Confidential, San Jose, CA

Data Architect/ETL Developer

Responsibilities:

• Extracted data from cloud sources: VMWare, Network Appliances, Microsoft Azure, Amazon Web Services, Sales Force using proprietary charge back application and process.
• Developed ETL Cognos framework models and Cognos reports reflecting usage of cloud resources.
• Built custom data collectors using Perl and XML to extract data from data sources interfaced with REST API.
• Built and optimized very complex SQL Server stored procedures.

Confidential, Fort Worth, TX

(Business Intelligence Developer

Responsibilities:

• Developed complex algorithms SSIS packages and stored procedures using SQL Server 2008R2

Confidential, Dallas-Austin, TX

Business Intelligence Solution Architect

Responsibilities:

• Designed and built very complex Cognos Transformer OLAP models and cubes using Oracle 11g and Netezza databases as a data source.
• Built complex Cognos Framework Models.
• Developed very sophisticated multi-level reports using Cognos Report Studio with lots of JavaScript, based on OLAP and relational models with functionality exceeding capabilities of Cognos.
• Developed Intellectual Property for Quick Start Data Warehouse appliance, based on Microsoft Fast Track Architecture.
• Architected and developed full blown DW/BI solutions for mid-sized companies using Cognos and Microsoft SQL Server 2008/2012 stack.
• Implemented SQL Server cluster solutions & high availability groups.
• Delivered bimonthly four days class on SQL Server 2012 and Quick Start Data Warehouse appliance to clients, partners and internal employees.
• Built complex SSIS processes integrating data from multiple data sources.
• Led on-shore and off-shore teams on several projects.

Confidential

Business Intelligence Solution Architect

Responsibilities:

• Architected Business Intelligence, ETL and Data Warehousing solutions using Microsoft SQL Server, SSIS, SSAS, SSRS, Cognos BI and Oracle database technologies for various clients and industries.
• Designed metadata models, cubes, reports, dashboards using Cognos Framework Manager, Cognos Transformer, Cognos Report Studio.
• Developed ETL, cubes, reports, report models using SSIS, SSAS and SSRS.
• Led on shore/off shore teams on various projects.

Confidential, Dallas, TX

Developer

Responsibilities:

• Built new and enhanced existing ETL process for Bank Secrecy Act department.
• Reengineered, streamlined and automated various manual tasks.
• Built complex Extraction, Transform and Load (ETL) process, implementing sophisticated business rules using SQL Server Integration Services (SSIS).
• Created enterprise documentation for developed processes and procedures.

Confidential, Frisco TX

Developer

Responsibilities:

• Architected and developed Data Warehouse for multiple loan portfolios, accounting and servicing systems, using MS SQL Server 2008
• Built complex Extraction, Transform and Load (ETL) process, implementing sophisticated business rules using SQL Server Integration Services (SSIS)
• Developed cubes using MS Analysis Services.
• Developed reports using MS Reporting Services (SSRS)

Confidential, Fort Worth TX

Business Intelligence, ETL and Data Warehousing Consultant

Responsibilities:

• Provided strategic guidance for BI and Data Warehouse initiative.
• Build Data Warehouse and ETL process for US and international affiliates using SQL Server and Cognos Data Manager Technologies.
• Implemented very complex business logic in ETL process.
• Developed stored procedures, batches, scripts, SSIS and DTS packages
• Built Metadata Models and cubes in Cognos Framework Manager and Transformer.

Confidential, Dallas TX

Business Intelligence and Data Warehouse developer

Responsibilities:

• Delivered Business Intelligence and OLAP Solutions using Cognos 8, Framework Manager, Transformer, Cognos 7 series & 8, Microsoft Analysis Services.
• Developed Reports using Report Studio, Query Studio, Analysis Studio, Impromptu and PowerPlay
• Built Extraction, Transform and Load (ETL) process using Informatica PowerCenter, Oracle Warehouse Builder (OWB) SQL Server 2005 Integration Services (SSIS).
• Developed data warehousing solutions based on Oracle and SQL Server.
• Wrote sophisticated SQL/PL SQL procedures in SQL Server and Oracle.

Confidential, Dallas TX

Cognos systems engineer / Business Intelligence (BI) developer

Responsibilities:

• Implemented Cognos Business Intelligence Suite, Cognos Planning, Cognos Finance in wide variety of client environments.
• Upgraded and migrated Cognos Planning, Finance and Business Intelligence Suite and applications in very complex client environments.
• Built business intelligence models and reports using Cognos 8, Framework Manager and Transformer.
• Migrated data, wrote complex stored procedures and scripts in SQL for SQL Server and Oracle.
• Clients - major US companies.

Confidential, Waco, TX

Application Developer / Network Administrator

Responsibilities:

• Developed company’s proprietary, business specific, intranet applications, complex reports and public website (VB.NET, ASP.NET, SQL Server 2000, Crystal Reports)
• Developed XML, WSDL Web Services for affiliated companies.
• Developed stored procedures, triggers, cursors, DTS packages, scripts, and batches in SQL.
• Migrated data, optimized database queries and restored data integrity.
• Performed data modeling, using use cases and UML diagramming.
• Developed application functionality implementing very complex business scenarios.
• Solely built, maintained and administered corporate network (Windows environment), reorganized server room, installed racking solutions.
• Designed, implemented, configured and maintained disaster recovery (Veritas), anti-virus (Symantec Enterprise) and anti-spam solutions. (Hard disk arrays and robotic tape libraries, RAID)
• Performed all network related tasks including but not limited to: network wiring (whole building - 100 drops), hardware and software installation, Active Directory configuration, DNS, WINS, DHCP, maintenance, upgrade and troubleshooting.
• Responsible for 15+ servers (Supermicro, IBM), 3 routers (Cisco, Adtran), firewall (Cisco PIX), 40 workstations (IBM, HP, Dell).
• Administered MS Exchange (Front End - Back End environment), MS SQL Server and IIS.
• Installed, configured and upgraded Questys document imaging system.
• Implemented video and network surveillance solution, resulting in significant productivity increase.

Confidential, Waco, TX

Teaching assistant

Responsibilities:

• Designed and created web forms and databases using ASP.NET, MS SQL Server 2000, PHP and MySQL for Baylor intranet.
• Conducted research in various business and technology fields.

Confidential

Owner - Manager

Responsibilities:

• Owned and operated successful art and gifts distribution business.