We provide IT Staff Augmentation Services!

Senior Technical Consultant Resume

Qualification Summary:

  • 20+ years of experience with the last 12 years of experience focused within complex Data Warehouse environments including experience with: PL/SQL, ETL process, Oracle8i, Oracle9i, Oracle 10g, Oracle 11g ,SQL Loader, Query tuning and Optimization, multi-dimensional data modeling and overall design, development and support of large Enterprise Wide Data Warehouse systems.
  • Financial industry experience includes Northern Trust, CBOE, Ralf & Nolen and Allstate Financial Services.
  • Extensive experience in developing both Online Transaction Processing (OLTP) and Data warehousing data models.
  • Experience building LDM and PDM models to accommodate new complex BI and/or Data warehousing projects.
  • Expert with ETL, OLAP and other data warehouse fundamentals including data and dimensional modeling. C/C++, Open Client, and Rogue Wave, experience with Oracle and Sybase Analysis, detailed design, development and support.

Technical Summary:
Databases: Oracle, Sybase, Informix, SQL 2000, Access

Database Tools: Informatica PowerCenter, OWB 10.2, Import/Export, Oracle Enterprise Manager (OEM), SQL 2000 Enterprise Manager, Oracle Reports, Business Objects, Developer 6i, Com Express, RapidSQL, Dbartisan, ER Studio, Toad, Erwin, Webdb, PowerDesigner, DDL, DML, Oracle Loader (SQL Loader).

Languages: PL/SQL, TSQL, 4gl, C/C++, Pro*C, ESQL, SQR, VBS, JBS

UNIX Tools: KSH, CSH, AWK, SED, PVCS, MKS, RCS, ClearCase, Autosys, Puma, MQ Series, VI Editor. , TKPROF, Trace

Software: Visio, Ms Office, Lotus Notes, Fmlabs

Networking: TCP/IP, UDP, IPX/SPX, SLIP/PPP, SMTP, POP3, SNA, and FTP.

OS: RS6000 UNIX, HP11 UNIX, Solaris UNIX, Wang, NT, XP.

Professional Experience:
Experis May 12-Present
Client: Confidential
Senior Technical Consultant

  • Review of reporting system.
  • Review and tuning SQL and PL/SQL code.
  • Designed, coded and tested complex database packages and procedures testing.
  • Tuning and implementation of the application and processes.
  • Perform data analysis.
  • Creation and migration of the solution for the full suite of development, test and production environments.

Technical Environment: Oracle 11g, TOAD, Oracle SQL Developer, Oracle Data Modeler, Oracle SQL Tuner, TKPROF, Trace, PL/SQL, ETL, DDL, DML, KSH, Visio, TCP/IP

Apex Systems Dec 11 - May 12
Client: Confidential
Technical Lead

  • Technical Lead to the team of offshore developers. Building new ETFH Hub application, including Oracle VPD security, signaling and messaging.
  • General and detail technical specification.
  • Review and tuning SQL and PL/SQL code.
  • Designed, coded and tested complex database packages and procedures.
  • Perform data analysis.
  • Build new LDM and PDM models to accommodate new complex data warehousing system.

Technical Environment: Oracle 11g, TOAD, Oracle SQL Developer, Oracle Data Modeler, Oracle SQL Tuner, TKPROF, Trace, PL/SQL, ETL, DDL, DML, KSH, Visio, TCP/IP

Confidential, May 11 - Dec 11
Client: Confidential
Senior Technical Consultant

  • Review and tuning SQL and PL/SQL code.
  • Designing database packages and procedures..
  • Support and assistance to the development team in the design, development, testing, tuning and implementation of the application and processes. Perform data analysis.
  • Creation and migration of the solution for the full suite of development, test and production environments.

Technical Environment: Oracle 10g, TOAD , OWB, Oracle SQL Developer, Oracle Data Modeler, Oracle SQL Tuner, TKPROF, Trace, PL/SQL, ETL, DDL, DML, KSH, Visio , TCP/IP

Confidential, Oct 10 - May11
Client: Confidential
Senior Technical Consultant

  • Responsible for Metadata management.
  • Design, developed and tested PL/SQL packages, stored procedures, functions, triggers in the complex metadata driven data warehouse environment.
  • Participated in the performance review and optimization effort.
  • Perform data analysis and functional requirements.
  • Perform data analysis on functional report requirements, and provide recommendations on the preferred solution for development.

Technical Environment: Oracle 10g, TOAD, Informatica PowerCenter, PL/SQL, ETL, DDL, DML, KSH, Visio, Windows 7, TOAD, TCP/IP

Confidential, Jan 10 - Oct 10
Senior Technical Consultant

  • Prepared Technical Design Specifications for the Motorola spinoff initiative.
  • As a part of the data warehousing team designed and coded new packages under Oracles Applications concurrent manager.
  • Participated in the performance review and optimization effort.
  • Perform data analysis and functional requirements.
  • Prepared detail design specs for various ETL processes

Technical Environment: Oracle 10g, Oracle 9.2, Oracle Applications , OWB, PL/SQL, DDL, DML, KSH, Visio, Windows XP, TOAD, TCP/IP, HP, PVCS, KSH.

Confidential, April 09 - Nov 09
Senior Technical Consultant

  • As a part of the data warehousing team developed PL/SQL packages, stored procedures, triggers to retrieve, update and validate database information.
  • Develop outgoing interface solutions and data source loads using Oracle Warehouse Builder.
  • Perform data analysis on functional report requirements, and provide recommendations on the preferred solution for development.
  • Work with other developers to develop and maintain standardized solutions.
  • Build LDM and PDM models to accommodate new source system

Technical Environment: Oracle 10g, Oracle 9.2, Informatica PowerCenter, PL/SQL, DDL, DML, KSH, Windows XP, TOAD, TCP/IP, HP, PVCS.

Confidential, July 07 - Jan 09
Senior Technical Consultant

  • Taking part in architecture, design and development of the product rating and sales incentives system (MARS).
  • Responsible for developing functional Business requirements and design specifications. Prepared detail design specs for various ETL processes.
  • Produced and documented logical and physical database design using ER STUDIO as a data modeling tool, while working with users and developers to understand their data needs and relationships to existing corporate data
  • Build LDM and PDM models to accommodate new source system.
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs
  • Participated in the performance review and optimization effort.
  • Perform data analysis and functional requirements.
  • Provided Informatica PowerCenter solutions.
  • Designed and implemented new PLSQL packages to load and support new data models.

Technical Environment: Oracle 10g, Oracle 9.2, PL/SQL, DDL, DML, XML, KSH, HTML, Windows XP, Oracle Import/Export, Informatica PowerCenter, ER STUDIO, TOAD, TCP/IP, HP, PVCS, Maestro, IBM PC, Visio, Microsoft Visual Basic.

Confidential, Jan 07 - July 07
Senior Technical Consultant

  • Primary responsibilities included developing conceptual, logical and physical data models in support of a data warehouse system; deriving data models through requirements gathering with developers and end users; working with application developers to map process models to data models.
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs
  • Assisted developers with application design and performance tuning
  • Selected and implement the appropriate tools, software, applications, and systems to support data technology goals.
  • Prepared detail design specs for various ETL processes.
  • Provided combination of OWB 10.2 and PowerDesigner solutions.
  • Designed and implemented new PLSQL packages to load and support new data models.
  • Perform data analysis on functional requirements, and provide recommendations on the preferred solution for development

Technical Environment: Oracle 10g, Oracle 9.2, Oracle SQL Loader, PL/SQL, DDL, DML, XML, KSH, HTML, Windows XP, Oracle Import/Export, PowerDesigner, OWB 10.2, TOAD, Rapid SQL, TCP/IP, HP, PVCS, IBM PC.

Confidential, Sept 06 - Jan 07
Senior Technical Consultant

  • Performance effective improvements to spatial data warehouse. Build new logical and physical data model to accommodate new Indonesia data mart (ODS, DSS).
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs
  • Prepared detail design specs for various ETL processes
  • Provided combination of Informatica and FME Workbench solutions.
  • Perform data analysis on functional requirements, and provide recommendations on the preferred solution for development.
  • Developed PL/SQL packages , stored procedures, triggers to retrieve, update and validate database information

Technical Environment: Oracle 9.2, Oracle SQL Loader, PL/SQL, DDL, DML, XML, KSH, PROC/C++, HTML, Windows XP, Oracle Import/Export, Informatica, FMA Workbench , TOAD, TCP/IP, HP, PVCS, IBM PC

Confidential, June 06 - Sept 06
Senior Technical Consultant

  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs.
  • Prepared detail design specs for various ETL processes
  • Development and testing of Limit Orders Reporting System including large data loads and on demand reports.
  • Perform data analysis on functional report requirements, and provide recommendations on the preferred solution for development including logical and physical data model.
  • Designed and coded new PLSQL packages to load and support new data models.

Technical Environment: Oracle 9.2, Oracle SQL Loader, PL/SQL, DDL, DML, XML, KSH, PROC/C++, HTML, Windows XP, Oracle Import/Export, Oracle Reports, ER Studio, TOAD, TCP/IP, HP, PVCS, IBM PC, TOAD, TKPROF,

Confidential, June 05 - June 06
Senior Technical Consultant

  • Responsible for developing functional Business requirements and developing detailed design specifications, participated in design, development and testing of Millennium Billing System including data loads, merge, pricing, invoicing, and on demand reports.
  • Selected and implement the appropriate tools, software, applications, and systems to support data technology goals
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs.
  • As a part of the data warehousing team developed PL/SQL and TSQL packages , stored procedures, triggers to retrieve, update and validate database information
  • Develop outgoing interface solutions and data source loads using Informatica PowerCenter.
  • Perform data analysis on functional report requirements, and provide recommendations on the preferred solution for development including logical and physical data model.
  • Work with other developers to develop and maintain standardized solutions.

Technical Environment: Oracle 9.2, Sybase 12, Oracle SQL Loader, PL/SQL, Informatica , TSQL, DDL, DML, XML, KSH, C/C++, HTML, Windows XP, Oracle Import/Export, Oracle Reports, Oracle Forms, Rapid SQL, TCP/IP, Hammingbird, HP, PVCS, IBM PC

Confidential, Jan 05 - June 05
Senior Technical Consultant

  • Designed and implemented business intelligence components including data models, enterprise reporting, testing and deployment.
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs
  • Develop outgoing interface solutions and data source loads using Informatica PowerCenter.
  • Perform data analysis on functional report requirements, and provide recommendations on the preferred solution for development.
  • Work with other developers to develop and maintain standardized solutions.
  • Work with warehouse designers to refine data models and data source loads
  • As a part of the data warehousing team developed PL/SQL and TSQL packages , stored procedures, triggers to retrieve, update and validate database information

Technical Environment: Oracle SQL Loader, PL/SQL, Informatica PowerCenter, TSQL, DDL, DML, XML, KSH, C/C++, Rogue Wave, Open Client, HTML, Windows XP, Sybase 12, Oracle Import/Export, Rapid SQL, Business Objects, Erwin, Sybase 12, Oracle 9i, TCP/IP, Reflections, HP, IBM PC

Confidential, June 04 - Jan 05
Senior Technical Consultant

  • Migrating reports from Brio to Business Objects.
  • Developed PL/SQL packages to retrieve, update and validate database information
  • Participated in the performance review and optimization effort for the DSW (ODS) - reporting system
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs.
  • Designed and implemented business intelligence components including data models, ETL, enterprise reporting, testing and deployment.
  • Participated in data mapping, data transformation and data parsing, foreign key and surrogate key assignment in the complex warehouse environment

Technical Environment: PL/SQL, Ab Initio, DDL, DML, XML, KSH, HTML, Windows XP, Oracle, Oracle SQL Loader, Oracle Import/Export, Rapid SQL, Business Objects, Brio, Erwin, Oracle 9i, TCP/IP, Reflections, HP, IBM PC

Confidential, March 02 - June 04
Technical Consultant /Team Lead

  • Responsible for developing functional Business requirements and developing detailed design specifications, participated in design, development and testing of financial trading software. This software has an ability to collect intra-day price data, provide statistical analysis of the financial securities, and create customized trading reports. The system is Internet based and uses VB 6.0 with proprietary ActiveX controls, C/C++.
  • Designed and implemented an enterprise business system including various modules of CAT to PIMS and 911 client server application. Interact closely with the business end user community.
  • Participated in data mapping, data transformation and data parsing.
  • Modeled Business layer, transferred business narrative into graphical representation of business rule, designing the database based on the model developed in strategy and analysis phase with Oracle Designer case tools, modeled process and data by Function Hierarchy, Entity Relationship, Business Process.
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs
  • Designed and implemented business intelligence components including data models, ETL, enterprise reporting, testing and deployment.
  • Creating drill down reports using Oracle Reports 9i.
  • Query tuning and Optimization for Business Objects.
  • Developed PL/SQL packages and TSQL stored procedures to retrieve, update and validate database information

Technical Environment: ETL, Oracle SQL Loader, PL/SQL, VB6, VBA, TSQL, C/C++, DDL, DML, XML, HTML, Windows XP, SQL2000 Enterprise manager, Oracle Import/Export, Rapid SQL, Business Objects, Oracle Discoverer, Oracle Reports, Developer 6i, Com Express, Erwin, Sybase 12, Oracle 9i, SQL 2000, TCP/IP, Reflections, HP, IBM PC.

Confidential, April 00 - March 02
Technical Consultant/Lead Developer

  • Responsible for detailed design specifications, coding and testing of statistical software.
  • Took part in profiling and optimization of the existing system.
  • Designed, documented and coded major enhancements to the JSQC - statistical system.
  • Participated in the performance review and optimization effort for the JSQC - statistical system, utilizing various ETL tools, PL/SQL and TSQL load processes.
  • Developed PL/SQL packages and TSQL stored procedures to retrieve, update and validate database information
  • Supported a data warehouse application in MVS, UNIX and PC environment. Supported the batch load process of files from the mainframe to the UNIX platform.
  • Participated in data mapping, data transformation, foreign key and surrogate key assignment in the complex warehouse environment.
  • Designed, coded and implemented database slicing utility to downsize exiting production database 10 GIG into test and development environments of 20 GIG each.
  • Migrated databases from Oracle 7.x to Oracle 9i.
  • Designed and coded interface program (DLL) and library (PLL) to allow email to be sent from Oracle Forms applications with any MAPI-compliant email system (Microsoft exchange, cc-mail, GroupWise.
  • Responsible for all database remodeling and interface development.
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs.
  • Implemented backup and recovery procedures of databases.
  • Participated in data mapping, data transformation, data parsing, foreign key and surrogate key assignment in the complex data warehouse environment
  • Participated in the performance review and optimization effort for the ClaimDesk Reporting System, utilizing various ETL tools.
  • Creating drill down reports using Oracle Reports 9i.
  • Query tuning and Optimization for Business Objects.

Technical Environment: ER ETL, Oracle SQL Loader, Oracle, SQL, PLSQL, C/C++ (Sybase Open Client), KSH, AWK, PROC, ESQL, TSQL, DDL, DML, XML. HTML, UNIX, Windows NT, MKS, RCS, Oracle Import/Export, Oracle Designer 6i, Rapid SQL, DBArtisan, TOAD, WebDB, Business Objects, COM Express, Oracle Discoverer, Oracle Reports, Oracle Forms, Erwin, Sybase 11

Confidential, Oct 99 - April 00
Technical Consultant

  • Responsible for developing functional Business requirements and developing of detailed design specifications, coding and testing of financial trading order routing system.
  • Participated in all phases of database and application development, including definition of user requirements to design to maintenance and support.
  • Participated in data mapping, data transformation and data parsing, foreign key and surrogate key assignment in the complex warehouse environment
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs.
  • Documented, designed, and coded trading data conversion interfaces.
  • Designed custom RAN System API calls to support Commodity Exchanges to RAN System and RAN System to Clients data flow.
  • Designed and coded API calls to support querying dimensional data warehouses.
  • Resolved issues related to the implementation of the data warehouse.
  • Developed relational and dimensional business models.
  • Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS_SQL, DBMS_PIPE, DBMS_JOBS, UTIL_FILE, DBMS_OUTPUT

Technical Environment: ER ETL, Oracle, C/C++, ESQL, 4gl, DDL, DML, KSH, UNIX, PVCS, Windows NT/98/95, DBArtisan, Oracle Designer 6i, Oracle Forms, Business Objects, RS6000, IBM PC

Confidential, Feb 99 - Oct 99
Technical Consultant

  • Responsible for conducting performance review and optimization effort for the ClaimDesk Reporting System.
  • Duties included multiple improvements to the schema, optimization of various code components: C/C++, stored procedures and triggers. These tasks consisted of following: analysis of components (C/C++, DDL, DML, SQR, and KSH script), manual review of source code, and modification of component source code writing of comprehensive test plans and testing.
  • Participated in data mapping, data transformation, data parsing, foreign key and surrogate key assignment in the complex warehouse environment
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs

Technical Environment: ER ETL, Oracle, C/C++, T-SQL, PLSQL, Oracle Forms, DDL, DML, KSH, UNIX, PVCS, Windows NT/98/95, DBArtisan, RapidSQL, Oracle Designer 6i, Oracle Forms 6i, Crystal Reports, Sybase.

Confidential, April 98 - Feb 99
Technical Consultant/Team Lead

  • Led a team of six performing a multi project Y2K assessment.
  • Primary duties were to oversee all ongoing technical aspects and coordination of work assignments. These tasks consisted of following: analysis of components (C/C++, PRO/C, ESQL, T-SQL, KSH script, database objects), inventory of projects, modification of component source code, manual review of source code and scripts for Y2K, system administration and DBA responsibilities.
  • Utilized Y2K methodology to incorporate manual review of code, detail preparation of documentation and setup of an isolated Y2K infrastructure (Environment Preparation, Test Strategy and Test Plan, Communications, Lab Testing Schedules, Test Status Reporting).
  • Designed, coded, and optimized various parts of Clear Reporting and Claims Determination Systems.
  • Participated in data mapping, data transformation , data parsing, foreign key and surrogate key assignment in the complex warehouse environment
  • Created database tables and made it available for reporting applications.
  • Design database schemas including normalization of data, cordiality analysis, index design, sizing of database needs

Technical Environment: Oracle, C/C++, PROC, PLSQL, Oracle Forms 6i, Oracle Designer 6i, ISQL, T-SQL, DDL, DML, KSH, UNIX, PVCS, RCS, SCCS, Windows NT/95/98, DBArtisan, RapidSQL, Business Objects, COM Express, Sybase, RS-6000, HP, IBM PC

Confidential, Dec 97 - April 98
Technical Consultant

Confidential, Dec 96 - Dec 97
Senior System Analyst

Confidential, June 87 - Dec 96
Programmer/Analyst

EDUCATION:
BS in Civil Engineering

Hire Now