SUMMARY:

• Information Technology professional with more than 22 years of progressive responsibility and experience. Strong technical skills with a keen business acumen with respect to data warehousing, business intelligence, systems integration, and process automation. Hands - on technical resource committed to providing excellent customer service, product quality, and on-time delivery. Desires to increase scope of influence and responsibility as an Information Technology (IT) professional in an exciting and challenging role with a team-oriented organization.
• Extensive business intelligence and ETL tool development experience including Pervasive Business / Data Integration Suite (formerly Data Junction Integration Suite - includes Map Designer, Process Designer, and the Engine), Business Objects Data Integrator, SSIS / SSRS / SSAS, and complex SQL (including the use of SQL, T-SQL, PL-SQL, sub-queries, views, temporary tables, case structures, pivot tables, rollups, and cubes).
• A strong database and application developer, data modeler / data architect with over 22 years of progressive IT development and data analysis experience -- 12 years+ related to data warehousing, business intelligence (BI), data integration, data modeling, and ETL; 10 years developing COBOL CICS and COBOL Batch applications in the mainframe environment; 1+ years developing scripts for extracting and bridging data between the mainframe and database environments (Entire Connect).
• Experienced with data modeling tools such as CA Erwin and MS Visio; logical and physical database architecture and design for data warehouses, data marts, and reporting environments; database development; ETL/data integration; performance tuning of SQL queries; complex SQL, T-SQL, and PL-SQL query, stored procedure, view, trigger, and function development; familiarity with current versions of both MS SQL Server and Oracle databases and development environments including SSIS, SSRS, SSAS, ODI, and JDeveloper; application development experience with MS Visual Studio and NetBeans; data integration and ETL suites including Data Junction, Pervasive, SAP, SSIS, SSRS; writing technical specifications / requirements; documenting workflow processes (MS Visio), providing level 3 support and expertise; and configuring / deploying processes and applications / scripts.
• Expertise in the streamlining and tuning data integration and ETL processes, including designing database schemas, mapping data, extracting and cleansing data, developing interfaces with third-party software products, email notification, and extensive SQL development for databases (MS SQL Server, Oracle, Sybase, HP Non-Stop, Teradata, and MS Access).
• Experienced with Business Intelligence solutions to enhance database reporting, including query performance tuning and optimization. More recent experience includes SAP Business Objects universe design and development, and extensive data integration and ETL (extraction, transform, and load) to and from both OLAP and OLTP databases and various flat file formats (including ASCII-delimited, XML, binary, EDI, and HIPPAA).
• Experienced in assessing database system capabilities and weaknesses, performing database administration, and developing data metrics and statistical analysis for reporting purposes for data warehouses and/or data marts.
• Extensive education (MBA and BBA) in business and management information systems / business analysis with an emphasis on Finance, including continuing education in Java, Visual Basic, PL-SQL / SQL, and C++.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014, 2012, 2008 R2 and R1/2005; Oracle Database 12c / 11i / 10i; Sybase ASE, IBM DB2; MS Access 2012 / 2010 / 2007 /2003 Teradata.

ETL / Data Integration / Business Intelligence (BI) Tools: Microsoft SSIS / SSAS / SSRS; SAP Business Objects XI R2, R1, and 6.5 (including WebI and BOBI); Pervasive Business / Data Integrator (formerly Data Junction Integration Suite, now Actian), TOAD (Quest Software), Embarcadero Rapid SQL, Crystal Reports.

Programming Languages and IDEs: Microsoft Visual Studio, Visual Basic, Java, C++, Eclipse; NetBeans; Apache Tomcat, COBOL, COBOL CICS Command-Level and Macro-Level.

Scripting Languages: SQL, T-SQL, PL-SQL, HTML, CSS, DHTML, VB-Script, Java-Script, JSP, XML/XSL/XSLT, Tandem TACL, SQLCI, Entire Connect, VBA.

Data Modeling Tools: Visio; ERwin.

Mainframe Software: CICS, COBOL II, COBOL 85/74, Entire Connect, JCL, EXPEDITER, TSO, Panvalet, SDSF, Adabas Natural, Endeavor, IDCAMS, VSAM, EASYTRIEVE Plus, FILE-AID, DataExpert, Assembler.

WORK EXPERIENCE:

Data Integration Specialist

Confidential, San Jose, CA

Responsibilities:

• Designing and coding various data integration applications and automation processes for the “Professional Services” group at Xactly from their flat file and SalesForce.com data sources to ASCII-delimited output datasets and to Oracle databases.
• ETL process development included tasks such as data mapping, data cleansing, in-memory lookups, database lookups, code validation, and configuration of processes on both Windows and Linux / Unix servers.

Tools: used include: SQL, SOQL (Salesforce), Oracle Database 12c, Oracle SQL Developer, Actian Data Integrator (formerly Pervasive), Git, Putty, Bash scripting, Xactly Connect, and Xactly Incent.

Senior BI Engineer

Confidential, Austin, TX

• Architected, designed, and developed an extensive SAP Business Objects XI R2 universe for Mitratech’s Collaborati data warehouse to simplify internal financial reporting.
• Developed various ad-hoc PL-SQL scripts and used SAP WebIntelligence (WebI) to produce financial reports based upon the new BO universe.
• Configured and streamlined the Apache Tomcat web server startup script to deploy the Mitratech TeamConnect product and SAP Business Objects by integrating the software package with the latest version of Java and to work with the multiple open-source java packages required by the product and currently supported by the open-source community.

Software Used: SAP Business Objects BI Platform, SAP WebIntelligence (WebI), Oracle Eclipse, MS SQL Server 2014, Pentaho Data Analytics, Oracle Database 12c / 11i, Java SDK and JRE, Apache Tomcat, T-SQL, PL-SQL, SQL.

Data Modeler / Sr. BI Developer

Confidential, Austin, TX

• As a member of a data integration BI team in HP’s Enterprise Services IT division, designed data models and assisted in designing, developing, and implementing a solution for HP’s financial and sales internal departments to extract, transform, and load data from an existing data warehouse into a third-party reporting solution using MS SQL Server, HP Non-Stop SQL, and T-SQL. Wrote various SQL and T-SQL scripts for use in stored procedures to perform the BI extraction process of data from an HP Non-Stop EDW and to perform bulk loading of this data into SQL Server to permit various data transformations intended for data cleansing, and for exporting this data from SQL Server to a shared secure FTP site for upload to an HP partner providing financial dashboard and statistical reporting of various multi-source data feeds from the enterprise.

Software Used: MS SQL Server 2014/2012, CA ERwin Data Modeler, Tandem HP Non-Stop TAL / TACL, T-SQL, SQL, Microsoft OneNote, MS Office, Microsoft Visio.

Business Intelligence (BI) Developer

Confidential, Austin, TX

• Designed, developed, and implemented ETL and reporting solutions using MS SQL Server stored procedures, views, and functions for reporting in SAP Crystal Reports.
• Architected, developed, and implemented SQL code changes to dramatically improve the existing extract, transform, and load performance, and enhanced the historical claim extraction processes to permit faster data extraction and more accurate snapshots of data at different points in time.
• Developed financial, sales, and executive-level summary reports and ETL processes using MS SQL Server T-SQL and Crystal Reports to validate the new healthcare system data warehouse load process and to improve the efficiency of data warehouse load from its former ERP data warehouse solution (AMISIS) into the new database solution (HealthRules). Developed new report processes to allow for the creation of multi-period reports from a single stored procedure and for providing multi-functional roll-up reports for handling ad-hoc reporting needs.

Software Used: SAP Crystal Reports, MS SQL Server 2014, SSIS, T-SQL, SQL, MS Office.

Business Intelligence (BI) Architect

Confidential, Austin, TX

• Architected and implemented a new automated SSIS BI data warehouse solution associated with an existing SSIS data warehouse implementation for a new state health insurance carrier, United Health Care (UHC).
• Modified Microsoft SSIS packages and various SSIS-called stored procedure scripts (Microsoft SQL Server 2008 R2 database ) to implement an multi-carrier conversion process for medical claim data within the ETL data warehouse load process.
• Architected, developed, and implemented code changes to dramatically improve the existing extract, transform, and load performance.
• Refined key stored procedure scripts so as to substantially enhance data integrity and BI reporting reliability for the health insurance carriers managed by ERS in the data warehouse.
• Designed and developed various summary and roll-up statistical tables via new stored procedures to provide counts related to legislative districts and claim-related HIPAA information to provide additional roll-up summary information to the Investments Department.

Software Used: MS SQL Server 2014, Oracle Database 12g, SSIS, SSRS, SSAS, T-SQL, PL-SQL, SQL, MS Office, MS Visio.

Consultant

Confidential, Austin, TX

• Performed code review of a “toll road image OCR” application written in Visual Basic 2010 which retrieves and stores information in a SQL Server 2008 R2 database. The code review involved analyzing and reviewing the imbedded SQL, application code, SSIS packages, stored procedures, and database table structure for issues prior to a Production implementation.

Software Used: MS SQL Server 2014, MS Visual Studio, MS Visual Basic, T-SQL, SQL, MS Office.

Data Warehouse Developer

Confidential, Austin, TX

• Architected, designed, developed, and tested a new data integration / ETL process for a data warehouse running within an Oracle database environment.
• Designed and developed a new OLAP database schema using the Ralph Kimball methodology for integration of OLTP data with 3rd party software databases and internally-developed application data.
• Analyzed and improved reporting processes within the Oracle PL-SQL database environments for Confidential -Lucent clients including AT&T (AT&T Chat), Verizon, CenturyLink (formerly Quest Comm., Sprint, and Embarq), and Windstream Communications.
• Activities included stream-lining reporting processes against existing databases, as well as the development of new reporting processes to provide quicker data retrieval and more effective reports for mobile devicework-flows.
• Assisted with the development of work-flow (wire-frame) processes for AT&T’s DSL, U-verse (cable TV), mobile, and VOIP applications.

Software Used: MS SQL Server 2008, Oracle Database 11i, T-SQL, PL-SQL, SQL, MS Office, MS Visio.

Developer Analyst

Confidential, Austin, TX

• Created a new MS Access 2003 “forms” application (VB-Script) for interfacing to a newly designed MS Access database.
• The application’s graphical user interface was designed for collecting Medicaid-related program and IT system information to help in preparing the PAPD (preliminary approval proposal document), which is necessary for obtaining further matching Federal funding for the Enterprise Data Warehouse (EDW) initiative.
• Activities also included performing data analysis and collecting various forms of information from agency sources and from technical expertise supporting the various HHSC, DSHS, DADS, DFPS, and DARS IT systems and applications.
• Responsibilities also included data governance activities and general IT system analysis, design, and architecture.

Software Used: MS SQL Server 2008, T-SQL, SQL, MS Access 2003, MS Office, MS Visio.

Data Warehouse / Applications Developer

Confidential, Austin, TX

• Performed SAP Business Objects universe development, HP Tandem stored procedure development, and Oracle PL-SQL development. The Medicaid HHSC project involved creating a crosswalk between the pre-existing Texas Provider Identifier (TPI) data and the new National Provider Identifier (NPI) data in an extensive dimensional data warehouse.
• Prepared detailed design documents, developed data warehousing / datamart ETL and reporting solutions (including loading EDI data into both Oracle and HP Non Stop databases), using Tandem TACL scripting for loading data into the data warehouse.
• Used data modeling tools including CA Erwin and MS Visio in implementing the data warehouse database changes Ralph Kimball (dimensional) methodology implemented in the data warehouse .

Software Used: CA ERWin, SAP Business Objects 11 / 6.5, SAP WebIntelligence (WebI), MS SQL Server 2005, SAP BOBI, MS SQL Server 2005, Oracle Database 10g and 11g, Java SDK and JRE, MS Visual Studio, T-SQL, PL-SQL, SQL, HP Non-Stop SQLCI/DBX/TACL (formerly Tandem), MS Visual Studio (C++.NET 2003), MS Visio, MS Office, COBOL.

Data Warehouse Architect / Developer

Confidential, Plano, TX

• Developed data warehouse (ETL) application processes and conversion maps using Pervasive Business Integrator (formerly Data Junction Integration Suite) for loading and unloading medical and workers’ compensation data into and out of SQL Server (and DB2 database tables) from XML blobs.
• Data structures worked with included database schemas, binary, DB2, ASCII-delimited, and XML data formats.
• Automated various data extraction and ETL processes, including customer statement generation and reporting.
• Created/modified UNIX scripts and developed complex SQL queries.

Software Used: MS SQL Server, Pervasive Business Integrator Suite, TOAD, IBM DB2, Unix/Linux, T-SQL, SQL.

Senior Data Analyst

Confidential, Austin, TX

• Performed analysis, designed, and developed advanced SQL scripts and stored procedures for a large DOL data warehouse residing on a Sybase ASE database in preparation for a new Business Objects BI implementation under development.
• The purpose of the report replication in using SQL and stored procedures was to provide a framework for which the existing BI reporting system of NJCDC could be converted into a Business Objects universe to be used for reporting and data analysis.
• I architected, developed, coded, and tested all of the new SQL scripts and stored procedures for replicating all of the existing weekly, monthly, quarterly, and annual reports generated for NJCDC and various government entities.
• Job duties included performing database tuning and process improvement of the ETL scripts and BI reporting extraction processes from the data warehouse, automating (and dramatically improving) the performance of the DW ETL processes, redesigning and corrected statistical measures, and architecting / developing / documenting / testing the complete solution.
• Evaluated and provided development templates for various ETL and data integration tools under consideration for purchase by the IT department.
• Other activities included supervising data analysis and database verification activities, and developing and testing validation scripts for the QA group to assist in validating existing reports against the data warehouse.

Software Used: Sybase ASE, Embarcadero, T-SQL, SQL, Unix/Linux, Pervasive Data Integrator Suite.