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, Ivrine, TX

Data Warehouse Architect

Responsibilities:

• Architected Data Warehouse, using star schema design from scratch.
• Developed data model and all related objects, tables, views, stored procedures, SSIS packages, business data inputs, SSRS reports.
• Integrated four ERP systems + lots of business critical data feeds into DW
• Built six Data Marts, 6 fact tables with 35 + conformed dimensions.
• Developed ETL Framework and ETL process using SSIS (500+ packages).
• Built and configured Development and Production ETL Servers and implemented “one click” deployment, using project deployment model.
• Built reports and dashboards using SSRS and Power BI.

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.
• Collected customers’ requirements and translated them into Cognos reports and Cognos Framework models specifications.
• 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, 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.
• 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.
• Built multilevel SSRS reports to accommodate variety of business scenarios.
• Developed complex algorithms SSIS packages and stored procedures using SQL Server 2008R2

Confidential, Dallas-Austin, TX

Business Intelligence Solution Architect

Responsibilities:

• Served as lead BI/DW solution architect on customer facing projects.
• 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 Reference 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 training 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.
• 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, Dallas TX

Consultant

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.
• Performed Cognos Systems Engineering functions (installations, upgrades, migrations) with Cognos 8, Cognos 7, Cognos Planning.
• Clients - US midsize and large companies.
• 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.

Confidential

Systems Engineer, Developer

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 2000-2003 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.