Objective
Contract


Summary

SUMMARY OF QUALIFICATIONS :
20 years IT experience : Financial, mortgage, manufacturing, medical, education, direct marketing, scientific computing

Doctoral Degree, over 20 scientific articles on Biomathematics, Statistics, Pharmacodynamics.

15 years Technical Project Leadership, Project Management. Major projects for Fortune 500 Companies

10 years System Analyst, Systems Architect Hardware, Network, Capacity Planning. Data Integration, Data Planning, Data Migration

5 years System Audits, Capacity Planning, Disaster Planning, Sarbanes Oxley, Specialized healthcare audits

Object Oriented : 10 years OO-Design and Programming : OO Design : 2 years Rational Rose Suite, 5 years Oracle Designer. Use Cases, UML, Logical Design
OO Application Creation : 5 years JAVA.. Java 1.0 1.1 2.0 J2EE : JavaBeans, Servlets, JSP, JDBC, Borland TOGETHER, Jbuilder v.5 Oracle JDeveloper 3 10g, XML, WASD
4 years XML. SOAP 1.2 XML SCHEMA, DTD, WASD, Application to-Application communication via Web Services, WSDL. MS-BizTalk v. 12 UDDI. DOM, Xerces, Xerces2 XML Parser, Validator. XMLSpy2
7 years VB, VBA, VBScript, ASP,. NET

10 years Enterprise Architect, Data Warehouse Architect, Application Architect. Data warehouses, datamarts, full SDLC, Business Requirements, Logical Design, Physical Model, initial loading, ongoing maintenance, data loads and data pruning. Upgrade to 2nd level. Zachman Conceptual Framework, Inmon Information Factory, Kimball Methodology, Joint Application Development Methodology, Microsoft Design Framework. Use Case analysis, Activity Diagrams, UML methodology.

13 years Oracle DBA 10 years Oracle Developer, PL/SQL, Developer 6i, Forms 4.5
7 years Oracle RAC or Parallel Server on Unix and Clustered Server on NT.
6 years Data Guard or Oracle Standby or Oracle Fail Safe. Enterprise Manager.
5 years replication on Oracle, advanced replication
5 years Oracle Applications Administrator, Developer, Releases 9 to 11.5.8 Oracle RapidClone, AutoConfig.

10 years Sybase v 4.9 to 12.5 MS-SQLServer v. 6.5 to 2000 SP3. DBA tasks
4 years Sybase Replication, 3 years SQLServer Replication.

10 years Teradata DBC to v.2. rel. 5.0 DBA, developer, extensive ETL experience

5 years DB2 UDB v. 4.1 5 6.1 7.1 8 EEE DBA and ETL, DB2 AS/400 v. 6.0 2 years DB2/390.

12 years Data Administrator, Data Manager, DBA. Performance tune up, backup scheduling, Disaster Recovery, lifecycle management, environment resizing on Oracle, DB2 Teradata, Sybase, Informix Universal Server

12 years ETL : 5 years Informatica, 6 years DataStage, DataStage XE, Prism Warehouse Extractor, DataStage/390 for mainframe, Ab-Initio 1 year, Oracle Pro*C, SQL*Loader, OWB ETL. Teradata MultiLoad, FastLoad, FastExport, DataPump. Microsoft DTS, BMC BackTrack, Computer Associates UniCenter 5.0. Data Integration : D and B, InfoUSA, HCFA data formats.

9 years OLAP and reporting : Cognos Impromptu, Cognos PowerPlay, Analytic Applications, Cognos Framework. Crystal Reports, SQR, Microsoft Analytic Services, Microsoft Data Mining. Hyperion Essbase, DB2 - OLAP, BusinessObjects, Brio Query, Andyne GQL and Cube, MicroStrategy, MicroStrategy NarrowCaster Sybase IQ, Oracle Reports, Oracle Express, Oracle Data Mining,.

QA : Mercury Test Center, MS Web Stress Test

6 years Web Technologies : Oracle WebDB, Portal, ATG Dynamo, BEA WebLogic, ColdFusion, BMC Patrol, Microsoft IIS4 IIS5 IBM WebSphere.

6 years ERP, Manufacturing, Public Utilities, Telephony. Manufacturing to Market, 6 Sigma QA. Methodology. SAP, Oracle ERP.

8 years Peoplesoft. Installation, configuration and ongoing support of HR, Manufacturing Suite, Production, Time and Materials, Billing, Payroll, Purchasing, Finance, Government Finance. Module customization and SQR. Set up of PeopleSoft ERP using ERO, data mart, Cognos.

8 years CRM. Siebel Customer Markets 6.3 Motiva, Siebel EIM. Siebel VB, escript. PeopleSoft 5 6.1 7.5 8.4 8.8 Oracle HR, MicroStrategy, Avaya Call Center application, Callidus.

4 years HRMS. Architecting, design and implementation of 2 custom HR management systems, with OO design and OO application code.

5 years Healthcare applications. MMIS, IMS, Regulated Environment. CDC, FDA, HCFA regulations. 21CFR regulations. Developed data outputs conforming with both HL7 and ANSI X12 HIPAA

2 years Telephony applications CRIS, CABS, NexTel Messaging, Avaya Call Center application, Callidus., Siebel Customer Markets..

Additional Database Experience : MySQL on Linux ; Postgress, SQL Navigator, TOAD, Embarcadero DB-Artisan.

8 years NT 3.51 4.0 Windows 2000. Extensive experience with NT Server Enterprise, Domain Server, Backup Domain Server, NT Clusters on NT 4.0 and Windows 2000. Windows XP-Professional Cluster. Server and Work Station Configuration. LDAP, Exchange Server, Visio, ADOBE Photoshop, DB-Artisan, ERWin.

Network Technology, Novell, Microsoft, Banyan, TCP/IP

Inter process Messaging : IBM MQ-Series, Microsoft MQ, Oracle Streams, WebServices.

15 years Unix. AIX, HP-UX, Solaris, BSD, Ultrix, Interactive and SCO. Complex shell scripting, new daemons and real time processing. Perl 5.0 with database extensions. Competent to install and configure new Solaris and HP-UX servers. Linux 6 years on Intel. PHP. Vantive

7 years Mainframe : IBM AS/400 Burroughs, Bull, Hitachi. JCL, MVS, TSO, CICS. Cobol, Fortran. Data extraction from IMS, DB2/390..

SUMMARY OF SKILLS :
Data Warehouse Analyst and Planner : Oracle CASE Methodology, Microsoft Solutions Framework Methodology. IBM Data warehouse Methodology. Process Modeling and Data Modeling. Zachman Cenceptual Framework. Inmon Data Factory, Kimball Methodology. Met with Clients and Clients customers and staff. Used Joint Application Development Methodology to expedite Analysis process. Defined and formulated all Requirements with Rational Rose UML : Business Rules, Use Cases, Object Sequence Charts.

Data Architect : Created Logical Models : translated Requirements and Business Rules to entities, attributes, relationships, domains. Star Schema and Snowflake Schema as appropriate. Transferred logical models to physical data warehouse design, Created data dictionary, tables, primary and foreign keys, constraints. Created database and migrated data into it. Designed Meta Data Repository meeting the Metadata Coalition Standard and populated that repository. ERwin DataMart 4.1 ModelMart 3.0 Power Designer 6.1. Embarcadero ER, Studio 6.0. SQL, Transact SQL, PL/SQL. Teradata Meta Data Services. Oracle CASE 5.1 Designer/2000 and Designer 6.0 Oracle Warehouse Builder. IBM Data Warehouse Center, IBM Information Catalog Manager. Teradata Meta Data Services.

24x7 Experience : Chief Production DBA on Oracle, Chief Production on Sybase, DB2 DBA in Charge on Teradata. In charge of daily operation of OLTP installations processing up to 20000000 transactions, day. Planning and implementation of disaster recovery. Backup and Recovery. Sybase Replication setup, maintenance, optimization and performance tuning. Oracle Parallel Server, Clustered Server. Performance Tuning at server configuration level, devices, schema level, SQL query level and input, output levels. Veritas, Raw Devices. On Teradata use ARC and ASF2.

Oracle Server, Tools and Applications : Oracle 5.0 to 9.2 on Unix, NT, Windows 2000 and Linux. Oracle Enterprise Manager 2.2 RMAN. OracleParallel Server, Real Application Cluster. Oracle Fail Safe on NT Cluster. Oracle Standby, Managed Standby, Data Guard. Data Guard Broker 9.2. Replication and Advanced Replication. Extensive Performance Tuning on Oracle. Enterprise Manager 2.2 Performance Tuning Package. Designer 2000 Designer 6.0 Oracle DataWarehouse Builder 1.0 to 9.2 OWB Data Quality Module. Developer 2000 Oracle Forms, Oracle Reports, Pro*C, Pro*Fortran, Pro*Cobol, Oracle Express 2.0 Oracle Sales Analyzer, complete suite of Oracle CASE tools and Oracle CASE Methodology. Oracle Applications : Oracle Financials, Oracle Projects, Oracle WorkFlow, Oracle Alert, Oracle RapidClone.

Data warehouse performance tuneup and maintenance : Performance tuning to 1000 tables, 2.3 Terabytes. Table partitioning, Indexing and Index separation, SQL query tuning. Platinum DBScope, Oracle Enterprise Manager 2.2 DbArtisan 4 MS-SQLServer Enterprise Manager. Platinum PRF, Oracle Trace, Sybase SysMon, NT PerfMon.

Data Loading : 8 successful data migrations. Teradata TPump, Teradata FastLoad, MultiLoad, Teradata Tbuilder, Platinum InfoPump.
Informatica v.34 4.7 5.1 6.2. Striva, Informatica PowerConnect to Mainframe.
Ardent DataStage 3.6 Ascential DataStage 4.0 5.2 7.2. DataStage XE, ProfileStage, QualityStage. Custom conversion programs, Oracle SQL*Loader, Import, Export, Oracle OWB ETL.
Sybase/MS-SQLServer BCP, SqlServer DTS.
Platinum Data Transport, XML, XSLT, Computer Associates UniCenter 5.0.

Reporting : Cognos PowerPlay, Cognos Impromprtu, both on NT and Unix. Cognos Enterprise Framework, Cognos Analytic Services. Oracle Reports, Crystal Reports, SQR. BusinessObjects 4.1 and 6.0 6.1 BusinessObjects WebIntelligence, BO Administration nusing Supervisor. Brio Query 5.0 Brio Enterprise Server 6.5 Andyne GQL and Pablo, MicroStrategy 7.2 MicroStrategy NarrowCaster. MS-SQLServer Analysis Services. SQLServer data mining. Oracle Express, Oracle Discoverer 3.1 Oracle Sales Analyzer. Sybase IQ 12.0 Visual Basic 6.0 and 5.0 Front End Applications, PowerBuilder 6.0. Java 1.2B: JavaBeans, JSP, Portia, Interlinq MortgageWare, Oracle Data Mining..

Web Applications, Tools : HTML 4 XML, XSLT, PHP 3 and 4, Cold Fusion v.4 BEA WebLogic, Microsoft Interdev 6.0 ATG Dynamo v. 4.51 and v 5.00 Oracle Application Server 9 oracle Web Database, Sybase Power Dynamo, Tango2000 Apache, Microsoft IIS4 IIS5.
Oracle Tools and Applications : Designer 2000 Designer 6.0 Oracle DataWarehouse Builder, Developer 2000 Oracle Forms, Oracle Reports, Pro*C, Pro*Fortran, Pro*Cobol, Oracle Express 2.0 Oracle Sales Analyzer, complete suite of Oracle CASE tools and Oracle CASE Methodology. Oracle Financial Applications, Oracle Projects, Oracle WorkFlow, Oracle Alert.
HRMS : Designed a custom enterprise wide HRMS system. Installed and configured Peoplesoft v.6 7.0

Programming Languages : IBM 360 Assembler, Fortran, Cobol, PL/1 Business Basic, C, C++, COM, DCOM, VB, VBScript, Java, JavaScript, XML, Informix 4GL, Perl, CGI, Unix Shell, PHP.
Network : Set up NT 3.5 and 4.0 networks w, multiple domains. DNS. CheckPoint Firewall setup. Unix networks
Version Control, Change Management Tools : ClearCase, SCCS
Process Management Tools : Microsoft Project 2000 ; Microsoft Powerpoint, Visio.

PROFESSIONAL EXPERIENCE
all positions Full Time except those marked P/T

09/04 - present Lead Physical Architect, DBA PartnerRe Inc Greenwich, CT.
Implemented new enterprise data warehouse for an international re-insurance company. Led local team of 1 ETL Architect and 1 BO Architect, each of whom managed an offshore team.
IT Audits : Modified project design and security to meet Sarbanes Oxley requirements. Prepared live data and transmitted that data to the SOX Outside Auditors. Prepared full capacity plan and specified required raw storage. Prepared Disaster Recovery Plan.
Data Warehouse : Created Table and materialized view Partitioning and Nested Materialized Views. Led extensive system and query tuning and optimization. Coordinated ETL loads to data warehouse, set up duplicate environment to provide 24x7 availability to end users, with less than 1 sec downtime per day, while performing daily incremental loads. Created Table and materialized view Partitioning and Nested Materialized Views. Performed extensive system and query tuning and optimization. Upgraded Oracle from 9.2.0.5 to 9.2.0.6. Created new database on Oracle 10.1.0.3.
Heterogeneous Database Integration : Set up a data mart for the US operations of PartnerRE on SQLServer 2000. Architected and implemented data transfer from the Data Warehouse on Oracle to the Data Mart on SQLServer.
ETL : Coordinated ETL loads to data warehouse, set up duplicate environment to provide 24x7 availability to end users, with less than 1 sec downtime per day, while performing daily incremental loads.
ERP : set up data loads from PeopleSoft 8.8 ERP and HRMS modules based on daily incremental loading. Upgraded Oracle Financials from 11.5.1 to 11.5.6 and then to 11.5.8 retai8ning the original functionality. Set up dynamic reports of database data on Oracle Portal. Extracted data for reports using JSP.
Platform : Oracle 9.2 and 10g on Unix, Oracle Applications 11.5 8 Oracle Rapid Clone, Oracle Data Guard 10g, Oracle AutoConfig. Oracle Portal 10g, JSP 2.1 J2EE. SQLServer 2000 on Windows XP Professional. Informatica Power Center 6.5.1 BusinessObjects 6.5 PeopleSoft 8.8 SicsNT Reinsurance Transaction System on Unix. ERWin 4.1 HP Unix. Multiple Citrix servers, XML, Web Services,. Net, ASP,. Net Framework 1.1 Visual Studio 2003 C#, BMC Patrol.

08/04 Management Consultant, First Data Merchant Services, FDC, Melville, NY Performed second tier review of plan for Enterprise Data Warehouse. Advised CTO on defects in existing plan, reviewed budget and recommended modifications to simplify structure and improve performance, meet budgetary targets and timeline. Performed Hardware Audit and prepared Disaster Recovery Plan.

07/04 Enterprise Architecture Consultant, OpenWave, Redwood City CA Investigate current NexTel messaging operations on Oracle platform. Evaluate performance issues and identify current and potential performance bottlenecks. Defined test system to determine maximal capacity of current NexTel cellular messaging system. Created object oriented design of test system using Rational Rose, with C++ instantiation of process workflow.

05/04 - 08/04 Lead Architect, Harvard Pilgrim Health Care, Boston, MA Led a team of 3 Architects, 2 Modelers, 6 Ascential DataStage Developers, to design the entire ETL process for a new data warehouse under development.

Data Warehouse : Designed ETL process to support the Organizations EDI and paper Claim Adjudication System. Set up ETL processing of incoming claim batches in the HIPAA 837 format for both UB-92 and HCFA 1500 claims. Designed the loading process for incoming claim data into the Organizations Health Care Data Warehouse. Configured output of the Adjudication System to the HIPAA 835 standard. Created the underlying architecture and designed the physical database structures and procedures to support that data, while ensuring strict adherence to the HIPAA confidentiality standards for all data during the preprocessing, processing and output phases. Established Best Practices for ETL loads for new health services data warehouse. Defined ETL load model for Oracle to-Teradata data transfer and for DB2 - to-Teradata data extraction and load, using Ascential Data Stage. Using the RACF/DB2 module of OS/390 created a mainframe Ascential user to enable data extraction Determined and specified correct load sequence for a model containing over 200 individual tables. Created data audit trail and defined breakpoints and the associated metrics for audit at each breakpoint. Defined QualityStage parameters for cleansing, validation of incoming data. Implemented data deployment from Oracle to ODS and from the ODS to the data warehouse. Tuned ETL architecture to improve performance.
IT Audits : Audited ETL Process to verify compliance with Sarbanes Oxley requirements. Reviewed and modified database schema to assure compliance with HIPAA regulations. Modified Disaster Recovery Plan to assure full data integrity.
ERP : Incorporated daily load from Peoplesoft 8.4 ERP module and integrated data with medical services information.
Platform : OO design and documentation of ETL process with Rational Rose to create a UML representation.. Teradata v2R5 Oracle 9i, Oracle Financial and HRM Applications 11.5.7. PeopleSoft 8.4 DB2 on 390 RACF. Ascential DataStage 7.2 with Parallel Extender and mainframe options, QualityStage. HP Unix.

05/04 Senior Consultant, Novartis, East Hanover, NJ Correct errors in existing DataStage Jobs, train developers and provide Knowledge Transfer to clients technical staff for ETL project built on Ascential DataStage, with >150 jobs, hashed file and sequential file inputs and outputs.
IT Audits : Reviewed QualityStage process for physical location of subjectsto ascertain accurate address data..

Platform : Ascential 5.2 XE server on Windows XP Advanced Server. QualitySDtage for data verification. Oracle 9i target on HP-UX

03/04 - 05/04 Performance Consultant, Bristol Technologies, Danbury, CT. The leading manufacturer of transaction control software for Fortune 500 financial institutions. Scaled up performance of their TransVision middleware transaction monitor, logging system to 1000+ transactions/ sec on DB2 and Oracle. Scaled up Sybase performance. Performed measurements to determine performance bottlenecks and recommended changes in device layout, database initialization parameters, JDBC and application design. Resolved issues related to the database, Java interface, JDBC Drivers and Oracle, DB2 and Sybase. Database performance tune up on NT, Solaris and AIX.
Heterogeneous DataBase Integration : Established bi-directional data connectivity between DB2 Oracle and Sybase.
Platform : IBM AIX 5.1 Sun Solaris 5.9 Oracle 9.2.1 10g, DB2 8.1 FP5 Sybase 12.5 IBM WebSphere 5.1 Apache Tomcat, Java, J2EE, JSP 1.2 and 2.1 JDBC. Apache Struts, XML, UML, LDAP. C++, C#..

11/03 - 03/04 Enterprise Architect, Enterprise Data Warehouse, Travelers Life and Annuity, Hartford, CT. Design, development and deployment of company wide Data Warehouse. Evaluated and fleshed out the big picture. With help of a team of an Architect, a Modeler, a DBA, 2 Informatica Developers and 2 Business Objects report Writers, created an Enterprise Data Model based on the Zachman Conceptual Framework. Designed and optimized the physical database model for data warehouse based on the Enterprise Data Model.
Enterprise Architecture : Analyzed hardware requirements and wrote detailed specifications for new hardware to be purchased 2nd Qtr. 2004. Created comprehensive Enterprise data warehouse Capacity Planning. Saved all metadata in OWB. Evaluated network induced performance cost of distributed computing systems vs. CPU resource over utilization in centralized computing system and created repeatable metrics for quantitative assessment of the optimal system architecture.
IT Audits : Prepared ground up hardware inventory and created hardware deployment plan for next 36 months. Reviewed ETL Load Workflows to verify accuracy of financial data and conformance with Sarbanes Oxley requirements. Reviewed existing Disaster Recovery Plan and implemented Oracle RAC with Data Guard to increase data reliability, improve performance and speed up database recovery. Analyzed performance bottlenecks at the system architecture, hardware, network, system software and application software levels and application storage and determined focal points for improvement. Created data validation procedures, defined breakpoints and range of data validation metrics.
Data Warehouse : Managed RAC with Enterprise Manager and managed Data Guard with Data Guard Broker. Revised Informatica Mappings and tuned Informatica ETL performance. Revised the COBOL data extracts from IMS on mainframe, to include only fields required for Informatica, resulting in smaller flat files, prviding faster FTP transfer and faster acquisition by Informatica. Prototyped revised ETL system using Ascential DataStage XE Parallel Extender to improve ETL throughput. Tuned and optimized Business Objects reports. Set up, tuned and optimized Web Messaging with Oracle Streams, MS SQLServer MQ. Set up Web Reporting of BO with BO WebIntelligence. Created reports from Oracle with JDeveloper 10g, J2EE, XML, DOM, Xerces2 Web Services with SOAP. Designed Disaster Recovery system. Defined and coordinated Data Warehouse Load Schedule. Defined and implemented Data Warehouse Maintenance Schedule. Evaluated Cognos Enterprise Framework.
Platform : SQLServer 2000 on Windows XP Server, Oracle 9.2 on Unix Servers. RMAN, Enterprise Manager 9.2 with Tuning and RAC Control Packages. OWB 9.2. Embarcadero ER, Studio 6.0 DB-Artisan. Informatica PowerCenter v. 6.2 7.0. Informatica PowerConnect for Mainframe. Ascential DataStage XE. Ab-Initio on Unix, IMS on mainframe, COBOL. Erwin 4.2 Business Objects v. 6.1 for Client and Web Reporting on NT servers. IBM WebSphere on NT2000. Xerces2 Oracle JDeveloper 10g, Borland Together, VB 2003 C#, NT Network, LDAP.

08/02 - 11/03 Technical Lead, Support Services, Enterprise Marketing Data Warehouse, BellSouth, Atlanta, Georgia. Provided ongoing support, performance monitoring and tuning, troubleshoot and break fix, architectural and process improvements and new loads for the BellSouth Corporate Marketing Data Warehouse, 11+ TB on Teradata, with multiple Satellite Data Marts on Oracle, DB2 and DB2 EEE and SQL Server and mainframe.
Ongoing Support : Maintain more than 300 Jobs per month used for Marketing, Sales, Compensation, Corporate Decision Support and Informatica data loads. Maintained more than 100 Reports and datamart population Jobs and over 500 ad-hoc users connecting via BusinessObjects, Brio, MicroStrategy, GQL. Monitored Teradata with Teradata Manager. Created and supported multiple Brio, GQL, BusinessObjects and MicroStrategy universes, models, metadata sources. Implemented and tracked multiple Unix, mainframe, NT and remote data feeds and data exports. Created new Data Marts on Oracle using OWB. Set data partitioning on DB2 EEE.

IT Audits : Set up ongoing automated audit of all scheduled data loads and data exports. Audited and corrected financial errors resulting for incorrect data loads. Created and implemented Change Management Protocols and recorded process changes using SCCS. Created full hardware inventory and designed process for ongoing documenting of hardware upgrades. Created automated process for monitoring hardware status.
Performance Tuning : Designed and implemented automated ongoing Teradata Production monitoring of hourly user access and user resource utilization, drawing data from dbc. ampusage. Designed and implemented an automated system for ongoing ETL job performance and Report creation, logging start and end time of each step in each ETL Job and each Report. Optimized performance and corrected all data feeds to the CHATT, MKIS, CRIS, CABS, BRIS and reports generated by these systems. Set up Teradata Priority Scheduler, for control of Production workload and reconciliation of ad-hoc users with management Reports and required ETL Jobs Optimized performance on Oracle server and Oracle RAC.
Data Warehouse : Tune performance on ongoing basis. Dynamically set query priorities using Teradata Scheduler. Capacity Planning : Re-size storage and spool space proactively, to accommodate growing data content. Created Disaster Recovery Plan ; monitored and modified as needed backup schedules for both Teradata and Oracle. Monitor access and usage using SQL, Shell utilities and Teradata Manager.. Update Data Warehouse architecture and add Data Marts, to satisfy new business requirements, eg data collection from Siebel system. Archiving on set schedule using ARC connected to mainframe channel.

Teradata Upgrade to V2R5.0 Defined procedures for upgrade from V2R4.1 to V2R5.0 Provided education to developer team on V2R5.0 new features, partitioned indexes and field compression and developed with DBAs procedures to commence using the increased functionality provided by Roles and by the SQL Logging features of V2R5.0 Evaluated code in existing Jobs for potential issues related to the upgrade to R5.0.
Heterogeneous DataBase Connectivity : Managed bi-directional data transfers between databases on mainframe, Oracle, Teradata, DB2 - UDB, SQLServer 2000
ETL : Managed over 300 ETL Jobs per month. Extracted data from DB2/390 on mainframe through use of COBOL and loaded it to Teradata using MultiLoad and to Oracle using SQL*Loader. Extracted data from IMS and loaded into Teradata using Ab-Initio. Loaded Teradata from Oracle using MultiLoad and FastLoad, Ascential DataStage and Informatica Workflows. Set up, debugged and managed production of Ab-Initio 2003 release loading data from Oracle to Teradata. Loaded Oracle from Teradata using FastExport and SQL*Loader and Informatica WorkFlows. Created new ETL loads and exports as needed, using Ascential DataStage 6.0 and DataStage XE and validated incoming data using Ascential QualityStage. Informatica, Teradata MultiLoad, FastLoad, FastExport and Oracle SQLLoader, freestanding and embedded in Unix Shell scripts. Wrote ProC scripts for Oracle and C++ Inmod modules for Teradata. Parallelized DataStage loads to improve throughput, using the Ascential ParallelExtender module. Also SQL Server Data Services, MVS JCL and hybrid Informatica, Shell Script ETL processes. Evaluate and monitor on ongoing basis data quality. Troubleshoot data discrepancies, timing issues.
Architecture : Created new Teradata data warehouse schema to combine separate loads and exports to 3 different data marts on Oracle, RedBrick and Teradata, 700 Gig total. The 3 prior loads are replaced by a single load to a dedicated area in the central warehouse, with the different requirements of the 3 data marts supplied by views and by Informatica transformations.
CRM : Maintained on daily basis Oracle Instance supporting Siebel Call Center schema with close to 3000 tables, with up to 50 million rows, used as a key component of BellSouth marketing strategy, enabling up-sales and cross sales to customers making contact with the Call Centers. For each incoming call, the Siebel database provided the Call Center personnel with customized real time sales offer. Modified the VB, escript for the Siebel database. Created daily loads from Siebel to an Oracle Staging database and from there to Teradata Star schema. Developed a Data Warehouse application to monitor sales performance of the Call Center personnel, based on a nightly snapshot of the Siebel Schema transferred to the Enterprise Data Warehouse. Participated in Corporate Callidus implementation.
Reports, OLAP, DataMining : Support over 500 users of Cognos ReportNet 1.01 Cognos PowerPlay, Cognos Impromptu. Microstrategy, GQL, Brio, Microsoft Analytic Services for SQL Server 2000 Essbase/DB2 - OLAP and BusinessObjects. ROLAP and MOLAP systems. Manage Brio Server, Microstrategy servers 6.1 7.1 7.2 Business Objects Repositories on Teradata and on Oracle. Created new Cognos PowerPlay reports and new Universes for BusinessObjects. Create logins and maintain the different security models of Microstrategy, GQL, Brio and BusinessObjects. Troubleshoot and optimize Brio reporting. Tune performance on BusinessObjects DSS queries. Create BusinessObjects Dashboard applications and set up thresholds and dynamic interactive properties of BusinessObjects Dashboard applications. Created BusinessObjects security, new users, roles nand permissions using BO Supervisor. Troubleshot and optimized Brio reporting. Oracle Data Mining for 9i, MS-SQLServer Dataminer. Integrated multi platform services using Oracle Streams, MS-MQ and Unix Pipes. J2EE and JSP for populating database reports off Oracle.
ERP : Supported an upgraded Oracle Financial Applications and Oracle Project. Migrated from Oracle Application 10.6 to 11i 11.5.2. Implemented Peoplesoft 7 8.1 installation. Module customization, SQR queries.
Internet : Multiple server based JSP reports disseminated via BEA WebLogic. Implemented report security. Maintained JD Edwards 1 World database on DB2.
Telephony specific Reporting and ETL : Took leading role in development of a major reporting system tracking sales agents performance, based on correlation of sales call data, available offers data and Siebel sales agent performance tracking.
Platform : Oracle 7.3.4 8.1.6 8.1.7 9.2 Oracle RAC, RMAN, Replication, Transportable Tablespaces. OWB 9.2 Oracle Standby 8.1.6 and Oracle Data Guard 9.2. Data Guard Broker 9.2 and Oracle Enterprise Manager 9.2 for management of RAC and Data Guard. Teradata v2R4.2 Redbrick v. 5.0. HP-UX, AIX and NCR servers. Mainframe with TSO, JCL, SPF. Microsoft SQLServer 2000 with Microsoft Analytic Services and Microsoft DTS. DB2 UDB 8.0 EEE on AIX, DB2 AS/400 v. 6.1. DB2/390 on mainframe, TSO, COBOL. Oracle Streams and AQ, MS-MQ, IBM MQ-Series. Embarcadero ER, Studio 6.0 ErWin 4.1 Siebel Customer Markets 6.3 Siebel VB, escript. ConnectDirect v. 3.3 Cognos ReportNet, PowerPlay, Impromptu. Microstrategy 7.2 Brio Enterprise 6.5, GQL 4.2 Brio 5.1 Essbase 5.1 DB2 - OLAP, Business Objects 6.1 on Unix server with multiple NT clients and repositories on Teradata and on Oracle. Ascential DataStage 4.0 Ascential DataStage XE. ProfileStage, QualityStage. Informatica Power Center 6.2 Ab-Initio Co-Operative OS and Component Library on AIX. Oracle Financials and Oracle Project v. 10.7 and 11.5.1. Oracle Developer 6i, Oracle Forms 4.5 OWB 2.0 w, Address Validation Module .C, Perl 5.1 Korn and C Shell Scripts, C and C++ on Unix, Java, J2EE, JSP, JDBC, VB and. NET, XML, XSLT, GQL 4.2 Vantive, BMC SQL BackTrack 3.2 Computer Associates UniCenter 5.0. Visual Studio 2003 VB, Visual C++, C#.,

02/02 - 07/02 Senior Data Architect, Deloitte Consulting, Harrisburg, Pennsylvania. Commonwealth of Pennsylvania component of the National Project for Medical Disaster and Bio Terrorism Recovery. Planned, designed and implemented high availability Oracle system using Windows 2000 Cluster and Oracle Fail Safe, with VB front end, Microsoft IIS-5 and multiple Web clients.
IT Audits : Brought all design into compliance with 23CFR and HIPAA requirements. Developed stress test battery over the internet to quantify system and individual component availability.

Reporting : Installed and configured Cognos PowerPlay for analysts use and created summary reports. Created Java reports with Oracle JDeveloper, XML.
Platform : Oracle 8.1.7 and 9i on Windows 2000 Cluster. Oracle Data Guard and Fail Safe. Web applications via Microsoft IIS-5 and VB6 ASP, XML,. NET front end, LDAP, ERWin 4.01

03/01 - 01/02 Lead DBA, Legg Mason, Western Asset div Fixed Income Investment Management company with over $100 Billion in managed assets.
Supporting 24x7 production in 2 US locations, Europe and the Far East and over 40 developers in C, VB and Java. In charge of a distributed data warehouse spanning Sybase and Oracle components.
Data Warehouse : Resized the data warehouse to 120 GIG. Performed a security inventory and revised data access procedures ; Analyzed performance bottlenecks. Greatly improved performance through incorporation of Oracle Transport Gateway and Oracle DB-Link. Created an offline repository for aged data. Instituted automatic culling of aged data by AutoSys activated Stored Procedures and PL/SQL procedures

IT Audits : Ensured compliance of locally developed applications with SEC regulations. Created automated process for validation and reporting of proper flow of SWIFT data and other inputs and the inclusion of timely data in all Regulatory Reports. Uncovered an error in existing Trading software and devised strategy of migration to a more accurate Trading Application.
DBA tasks : Database Group management, Disaster Recovery Plan. Change Management. Extensive performance tuning, upgrade and redesign of financial data repository. Capacity planning, management of Global Data Repository trading support data mart. Implemented database components of recent conversion to a 3 - tier system. Installed and configured Sybase Central. Actively participated in Corporate Change Management process.
Oracle Parallel Server : Architected installation of OPS to support 24x7 operation. Disaster Recovery : Set up Sybase Replication v. 12.0 and optimized performance through use of Stored Procedure Replication and adjustment of Stable Queue parameters.
Installed, set up, tuned and maintained on ongoing basis Oracle Parallel Server, RAC for protection of transactional data and Oracle Standby, Data Guard for data warehouse.
Data Source Integration : Integrated Oracle with Sybase and MS-SQL Server via Oracle DB-Link and Oracle Transparent Gateway for Sybase, enabling join queries between tables and views in same kind and heterogeneous database servers.
ETL : Created new data feeds to Oracle using Ascential DataStage 4.0. Created data feeds to Microsoft SQLServer 2000 and 7.0 using DTS. Managed data feeds of 2 million rows from Bloomberg, Wilshire, Charles River, PAM, SWIFT 4.1 Betrieve and 7 internally developed ETL packages in C++, Oracle Pro*C and Pro*Cobol. Tuned all facets of the ETL and Reporting processes enterprise wide.
Reports, OLAP, DataMining : Installed and configured Sybase IQ 12.0 Created IQ databases and defined tables. Loaded data from Sybase Adaptive Server 11.93. Managed users and tuned queries. Created Cognos PowerPlay reports. Used Microsoft SQLServer 2000 Analysis Services for OLAP and data mining. Crystal Reports. Created and maintained reports in PowerBuilder 6.0.
ERP, HRMS : Installed Peoplesoft 7.0 HRMS and customized reports. Supported Oracle Financial Applications 10.7 11i
Platforms :. Installed, activated and optimized Sybase Replication 12.0 and 12.1 Installed, configured and put into use Sybase EA Server 4.6 and 4.1.1 Power Dynamo 3.6 Jaguar CTS. Sun Solaris 2.6 and 2.8 Windows 2000 Server. Oracle 9i, Oracle 8.1.7 Oracle 7.34 OWB 1.2 for creation of data mart. Sybase 11.93 12.0 12.5 integrated with Oracle instances via Oracle Transparent Gateway. Sybase IQ 12.0 .3 instances MS SQLServer 7.0, 4 instances MS SQLServer 2000 Perl 5.0. Computer Associates AutoSys 3.5 Cold Fusion 4 BEA WebLogic, XML and XSLT. Cognos Impromptu and PowerPlay. Peoplesoft 7.0 on NT. Erwin 3.51 Korn shell scripting, Perl 5.0

Accomplishments : Improved performance metrics from 77.0% to 99.95%. Installed Sybase Replication and tuned up Replication performance to over 1 Million rows, day. Integrated multiple heavy data loads without marked degradation of performance. Reorganized security, expanded Data Repository, improved database availability for London and Singapore offices. Revised and improved failure recovery. Reorganized security, expanded Data Repository.

Chief DataMart Developer, Quattrochi and Son, San Dimas, CA

Data Warehouse : Integrated data marts at east coast and west coast company locations into an enterprise wide data warehouse while retaining data mart functionality during an 18 - month transitional period : Performed analysis of business needs. Defined the logical design for enterprise wide data warehouse. Created the physical design and created the data warehouse at the east coast location. Performed an inventory of tables and other objects in both data marts. Created a staging database containing images of all needed tables from both data marts. Created at the staging database new tables and associated objects views, triggers, PL/SQL Connected the staging database with both existing data marts via Oracle DB-Link. Set up PL/SQL packages to populate the staging database. Used Informatica to combine data from the staging database and port it into the data warehouse. Set up a data validating PL/SQL package executed on a daily schedule. Set up code Change Management through SCCS.
Disaster Recovery : Installed Oracle Standby, Data Guard with Managed Recovery.
ERP : Installed, applied Patches, backups, capacity planning on Oracle Financial. Installed and configured JD Edwards 1 World for production control.
Applications 11.0 Upgraded to 11i and performed full data migration.
Reporting and OLAP : Upgraded Hyperion Essbase from v. 4.1 to 5.0 : Migrated Applications, Databases with related files and security files. Performed all Essbase DBA functions, Archiving of entire databases and Export Utility applied to Level 0 blocks. Created a new Essbase Installation on Sun Solaris. Copied Applications and databases from NT to Unix and resolved all configuration and file naming differences. Reloaded data. Transferred databases to the Unix platform using archived data. Created users and used Essbase Diagnostics to tune performance. Wrote batch scripts using ESSCMD.
Extended existing Cognos Installation. Added PowerHouse development environment and ReportNet remote connectivity via the Web. Created new reports.
ETL : Upgraded Informatica PowerCenter 4.7 to PowerMart 5.1 : Reinstalled and configured server, repository and clients. Completely redesigned mappings, to acquire data from new flat files and from the staging database. Defined new transformations as needed : Selected input data ports using the Filter and Source Qualifier transformations. Combined data ports using the Joiner transformation. Created new data ports by feeding the outputs of the preceding transformations into the Expression, Aggregator and Rank transformations. Selected rows using conditions coded in the Update Strategy transformation. Used the Sequence Generator to create new primary key values for the output ports and routed these ports into a number of distinct tables using the Router transformation, Verified data integrity. Set up new sessions. Debugged and Tuned performance by modifying the size of the Index Cache and the Data Cache, ii optimizing queries selecting input ports from relational databases and through use of the Normalizer transformation on a port derived from a Cobol file of demographic marketing information. iii placing efficient indexes on the data warehouse tables receiving the output ports, iv directing these new indexes into a dedicated table space and placing that table space on a different device.
Integrated multiple transformations into Mapplets and created new Mappings. Set up a regular production schedule with new Sessions.
Platform : Oracle 8.1.7 on Sun Solaris 2.8. Korn and C-shell scripts.


Employment

2000 -  2001
DBA

DBA Tasks : Developed Oracle Logical and physical models for new Internet products and services. Created the database components of a on-line loan application implemented in Java and XML. Provided ongoing support of multiple database instances. Established ChangeManagement via ClearCase.
Disaster Recovery : Set up Oracle Parallel Server, RAC with RAID 0 to provide full protection against loss of completed transactions in the event of server failure.
Reporting and OLAP : Set up internal reports on Oracle WebDB 2.0 Deployed MicroStrategy 7.0 server, client and NarrowCaster for Management DSS. Supported users of Cognos Impromptu. Connected to Oracle 8.1.6 on Unix
IT Audits : Created reports for management on performance of Web Loan Processing system.. Modified new application to ensure customer confidentiality.
ETL : Set up Informatica PowerCenter 5.1 and created transformations. Manager user accounts and Job workflow. Set up MySQL database and transferred data from Oracle to MySQL using custom Korn Shell scripts.
Platforms : Oracle 8.1.5 and 8.1.6 Windows 2000 Unix, Perl 5.0 CGI, Java 1.2 Java 2 J2EE, JSP 1.2 JavaBeans, JavaScript, MySQL on Linux, XML, DOM, XSLT. ATG Dynamo 4.51 ATG Developer Workbench, ErWin 3.52 Oracle J-Developer 3.11 Rational ClearCase. Documentum v 4 Verity, Cognos Impromptu, Oracle WbDB, Portal, MicroStrategy 7.0 MS-SQLServer 7.0 IIS 4.0 HTML 4.0 DHTML Korn shell scripts, remote shell. NT 4.0 VN 6.0. ASP, COM, DCOM.

Was responsible for on-time release of new versions of customer interface, for improved disaster recovery, for development of new management DSS tools and for new Java, Javascript and XML, Xerces modules for manipulating database contents.

Lead DBA, Lendx.Com Internet Business Equipment Leasing
DBA Tasks : Configuration and ongoing maintenance of 4 database instances and 1 Standby Database. 24x7 environment. PL/SQL.
Oracle Parallel Server, RAC : Implemented OPS 8.1.7 to provide Disaster Protection of the OLTP system..
Reporting : Created management reports with Crystal Reports 8.0.
Platforms : NT 4.0 Cluster. Oracle 8.1.5 on Sun Solaris 5.7 Oracle 8.1.6 on Linux Korn Shell Scripts. Apache Web Server, C++, COM, DCOM.

Managed successfully all DBA functions for startup until prior to going public for a leading b-to-b internet site.

12/99 - 10/00 Lead DBA BigStep.Com. Largest e-commerce hosting service for small business.

DBA Tasks : Led 4 other DBAs. In charge of daily production, backups, schema upgrades on a site processing 1.5 - 2.0 million transactions, day. PL/SQL Stored Procedures. Exports and Imports. Oracle Parallel Server, RAC to support high volume 24x7 OLTP. Oracle Replication. Standby/ Data Guard configuration and maintenance. Disaster Recovery planning and full implementation via OPS, RAC and Standby, Data Guard.. RMAN backup Manager. Managed on ongoing basis Oracle ATG Dynamo interface. Created and Maintained MySQL database for Prototyoing.
Data Warehouse : Created 1700 GIG data warehouse to support marketing efforts of the e-commerce businesses hosted by BigStep.com : Initial logical design and physical design of data warehouse. Created staging database to receive input from ongoing activity in the BigStep OLTP database. Set up ETL procedures. Instituted data validation standards and procedures. Redesigned for enterprise wide 200 GIG data warehouse supporting over 5000 individual e-commerce businesses generating 2 million hits or day businesses, capability of scaling up to 25000 e-commerce businesses, using OWB. Set up internal data warehouse metrics. Set up reporting system using BusinessObjects. Set up maintenance and backups. Created a hierarchical security system for access to data warehouse by customers.
ETL : Informatica PowerCenter 4.7 : installed and configured server, repository and clients. Created data transformations from OLTP database to data warehouse, filters and source qualifiers, joiners, aggregations and rankings Added sequence generators for some aggregated fields. Defined mappings and set up sessions. Created Staging Database for data feeds. Tuned ETL performance from OLTP database to Staging Database and from there to the data warehouse.
OLAP : Implemented complete suite of multidimensional analysis with BusinessObjects 6.0 and BusinessObjects WebIntelligence 2.0. Created new Universes, Classes, End User Objects and Report Objects. Tuned performance of BusinessObjects reports using the BusinessObjects Auditor. Data mining applications with Oracle Express 2.0.

CRM : Captured end customers keystrokes and navigation through each of the participating Websites, prepared summary reports using Business Objects and presented these reports to vendors, to enable them to make customer specific special sales and services offers.
Platforms : NT 4.0 Server Cluster. Oracle 8.1.5 Instances ; 1 Oracle 8.05 Instance, 2 Oracle 8.1.6 Instances. OWB 1.0 24x7 operation. Configure Net8. Oracle Snapshot Replication .4 ATG Dynamo Application Servers 4.0., Java, Javascript, Java Beans, JSP, HTML, DHTML. Oracle 8.1.6 8.1.5 8.0.5 on Sun Solaris 5.7 and 5.8. Oracle Express on NT 4.0. Veritas Volume Manager 3.02 and 3.1 Veritas Cluster. MySQL on SuSE Linux. NT clients, Korn Shell scripts, Perl Scripting. Set up of CheckPoint firewalls.

Data Mart Specialist, Quattrochi and Son. NY, NY

ETL : Upgraded Informatica 4.0 to PowerCenter 4.7. Revised existing sessions, modified existing transformations and added new transformations, modified mappings. Reorganized sessions. Debugged and verified data and tuned Informatica performance by conducting a Read Test Session with the Collect Performance Data option and comparing the timing to that of a database query executed from SQL*Plus. Transformations requiring high counts of lookup rows and having high error count were revised. The size of the session DTM function was increased where the bufferinput_efficiency and bufferoutput_efficiency were found to be low. The size of the Data Cache and Index Cache was adjusted in sessions using Rank, Aggregator, Joiner and Lookup transformations. Finally, the Oracle database was tuned and additional RAM was allocated to it at the Unix level.
DBA Tasks : Upgraded Oracle Financial and Projects Applications from 10.7 to 11.0 with Data Migration. Reconfigured Oracle server.
OLAP and DataMining : Installed, configured and activated Arbor Essbase 4.0 instance on NT. Created users and security. Set up archiving on regular schedule. Monitored activity and tuned performance.
Installed and configured Cognos Impromptu for OLAP and DataMining. Added Cognos PowerPlay and created reports.

1999 -  1999
Chief Production DBA

DBA Tasks : Manage 0.5 Terabyte Marketing Data Warehouse on Teradata. Capacity Planning and expansion. Backups, query optimization. FastLoad, MultiLoad. Archiving using ARC into an ASF2 unit with 2 tape silos.
ETL : Managed Data feeds and modified custom ETL applications written in C and Korn Shell to extract data from mainframe IMS database to Sybase staging database ; ii transfer data from Sybase to Teradata. Also transferred schema and 50 GIG data from Teradata to Informix Universal Server.
Reporting, DataMining : Supported developers in SAS v.6. Created Reports in SQR for Sybase Created, optimized and executed DataMining queries for analysts using SQL. Set up BusinessObjects 5.0 with a Repository on NT.
CRM : Implemented MicroStrategy CRM package on top of existing MicroStrategy 5.0.
Platforms : Teradata 2.1 on NCR 5100. Informix Universal Server 9.1. Unix. Korn shell scripts. Staging database on Sybase 11.5 on IBM AIX C Shell scripts. Set up ETL from IBM mainframe IMS using MVS and JCL, NT 4.0 for Reporting.

1998 -  1999
Chief Data Architect

Data Warehouse : Ground up new design for enterprise wide accounting data warehouse i Made enterprise wide Assessment of Needs for the accounting, fiscal reporting systems ii Created ground up enterprise wide Logical data warehouse design integrating seamlessly 2 different accounting systems through the discovery of atomic elements in each system and establishing an equivalency lookup repository iii Prepared full specification of the physical design of the planned data warehouse iv Made plan for the initial data warehouse load v Prepared detailed specifications for the ETL system for merging the 2 accounting systems, based on Informatica PowerCenter, processor requirements and allocation of daily and weekly time slots vi Set up data validations procedures vii Created electronic signature repository viii Prepared execution time plan and detailed budget for implementation of data warehouse ix Evaluated reporting needs, created specifications, selected reporting tools and estimated time allocation required for daily reports and EIS reports. Specified server requirements for ad-hoc reporting and for EIS.
x Created plan for backup and disaster recovery xi Defined performance metrics, ETL metrics xii Developed specifications for access security
Platforms : Warehouse designed for Teradata on NCR 5100.
Development on NT 4.0 Erwin 3.5

Database Guru and DBA, Inference Corp Novato, CA
Performance Tuning of knowledge base database for Call Center Artificial Intelligence Software made by Inference Corp And in use by Dell, NEC, etc. Redesigned and tuned for improved performance on Oracle 7 and Oracle 8. Analyzed PL/SQL programs.
Platforms : Oracle 7.32 7.34 8.0.5 on Unix, NT 4.0 server and NT 4.0 Clustered Servers.

Removed processing bottleneck and allowed proprietary Inference application to scale x10 of previous limit.

01/98 - 011/98 Senior Consultant, State of Michigan, Bull HN. In charge of the Physical Design team, of the ETL group and of OLAP and Reporting Tools, for a 500 GIG data warehouse for medical claims submitted to the State from 9 medical insurance plans, 3 HMOs and Medicaid at that time 1 of the largest in the nation : Data warehouse : i Cooperated with business analysts in the Assessment of Needs and the preparation of the Logical Design ii Led a team of 3 data architects converting the logical design to physical design iii Defined the meta data to be stored. Created meta data repository. Created a dynamic meta data definition and updating process to be used by designated State analysts for ongoing update of meta data to reflect ETL configuration changes.
iv Created a password protected VB application to display/ modify on desktop client current meta data in the teradata data warehouse meta data repository.
v Defined specifications and data format for the data transmitted by the various providers to the data warehouse vi Created a staging database for the data generated in above vii Set up the ETL needed in order to validate and combine the different data streams generated by the 13 individual providers viii Prepared implementation project plan and overall budget for implementation ix Established procedures for data validation x Established procedures for assigning and maintaining electronic signatures in conformance with Federal specifications set up in 21 CFR and HCFA Regulations.
xi Created an operation plan for ongoing data warehouse operation, aging of existing data, backups and maintenance xii Prepared budget estimate for ongoing operation xiii Prepared full specifications for reporting system, MOLAP queries, ad-hoc relational queries, management EIS, DataMining and standard reports. Evaluated multiple OLAP and DataMining tools xiv Established performance metrics, ETL metrics and reporting performance metrics xv Created the data warehouse access control and security system, based on a dedicated repository
ETL : Prism Warehouse Extractor, Prism Metadata Manager, Platinum Repository, Cobol II data extraction from mainframe..
OLAP and Reporting : Evaluated BusinessObjects 4.1 Brio Query,. Installed MicroStrategy DSS Agent and BusinessObjects. Set up GQL queries, created multidimensional cubes with MicroStrategy DSS Agent and built BusinessObject Universes to provide multidimensional functionality.
Platforms : NCR Unix 2.0.1 on Teradata 3600 5100 FastLoad, MultiLoad. Data sources on Bull 8000 and 9000 mainframes using GCOS 8 JCL. ERWin 3.5 Platinum Repository .C - Shell scripting, C++, COM, DCOM, VB v. 50 ASP.

11/97 - 12/97 Senior Analyst, Bank of America. Developed reports and ad-hoc queries for Bank marketing projects on a 1.3 Terabyte Teradata data warehouse.
Reporting : Created a new BusinessObjects Repository. Set up new Universes, defined classes and mapped Teradata tables to End User Objects. Created for analysts BusinessObjects Reports accessible through BusinessQuery for Excel. Also ad-hoc queries using Teradata SQL with output through mainframe network connection.

1996 -  1997
DBA

DBA Tasks : Set up DB2 Development Instance, Production and Remote Replication for OLTP system. Created data input system in VB. Created 60 GIG data warehouse on Teradata.
Data Warehouse and ETL : Ground up data warehouse design, ETL and full implementation of the design : Assessment of Needs : Evaluation of Company business plan ; workshops with marketing team and validation of findings with management. Logical Design based on Assessment of Needs and functional structure of OLTP system. Converted the logical design to physical design for Teradatas MPP architecture. Created a 2 - tier data warehouse : Central Data warehouse and Derived Data Warehouse. Created DB2 stored procedures with row blocking to extract data from the OLTP system and load the CDW on Teradata. Created Teradata Macros to extract and transform CDW data and load to DDW. Created data validation procedures for incoming data and for summarized data. Established ongoing data warehouse operation and data aging procedures. Defined a schedule for data and index maintenance. Set up tape backups on a weekly schedule. Optimized data warehouse performance, focusing on loading of the CDW and the CDW DDW interface
OLAP and DataMining : Installed, configured and created queries against the Teradata DDW using BusinessObjects 4.0. Installed BusinessObjects 3.6 and created a Repository. Designed new Universes, Classes, End User Objects, the required underlying SQL queries and Result Objects. Defined users. Edited reports and charts with the BusinessObjects Report Editor. Installed and configured Cognos Impromptu for data mining ; set up ROLAP multi dimensional cubes and modified queries as needed for new marketing requirements
CRM : Created custom application to capture customers prior purchases, ii capture customers communications with AJCEN, iii merge with customer information received from government agencies and customize new product offerings based on. Application boosted sales by close to 20%.
HRMS : Installed and configured, Peoplesoft HRMS v.6 on NT Loaded employee records using Import Manager. Created reports using MS Access. 1997 upgraded to Peoplesoft v. 7.0. Wrote data entry modules and reports in PowerBuilder 5.0

1995 -  1997
Contractor

Data Warehouse : Developed 3 GIG Data Mart for $8 Million, year Nonprofit.
DBA Tasks : 2 - site database replication in Oracle 8.0.5 SQL, Cursors, Stored Procedures, Triggers. Replication and synchronization of data mart with production database at school and at Charity headquarters. PL/SQL code. Visual Basic 4 forms. Data migration. Database Replication with synchronization. Visual Basic procedures and functions for module integration, security control, error processing.
OLAP and Reporting : Queries with Oracle Discoverer. Reports with Crystal Reports 5.0
Platform : Oracle 7.34 and 8.0.5 NT Server 4.0 WIN95 clients.

06/94 - 01/98 Data Systems Manager, California Psychological Medical Associates. P/T after 12/95 Nationwide multi specialty medical service provider with offices in 13 states.
OLTP System : Created an enterprise wide medical service transaction and third part billing system. System captured services provided at all offices in 13 states and recorded all transactions at a central OLTP database, with centralized Third Party billing. 4GL front end and Sybase database.
Data Warehouse : A data warehouse for patient clinical information and insurance claim history, with feeds from OLTP system and from Third Party payors : i Prepared Assessment of Needs ii Performed the logical schema design iii Completed the physical design of warehouse iv Implemented the data warehouse v Planned and managed the initial data migration into warehouse vi Set up and scheduled periodic feeds of new data vii Set up and implemented procedures for validation of electronic signature following CFR and HCFA standards.
viii Established maintenance and backup specifications and schedule, disaster recovery ix Created a comprehensive reporting system, ad-hoc query capability, metrics, time based reports and preparation of third party claims x Planned and executed 3 resizing projects.
This was among the earliest data warehouse designs, implementations incorporating 3 - tier architecture.
ETL Created and managed data feeds from field offices in 13 states. Btrieve intermediate data extraction from in-house Third Party billing system.
OLAP, DataMining and Reports : Created a Third Party insurance billing system and linked that system to data warehouse. Developed data outputs in HIPAA HL7 format and HIPAA ANSI X12 HIPAA format and uploaded that data to directly to Third Party Payors. Employed SQR for basic reporting from Sybase. Installed Cognos Impromptu and PowerPlay. Set up multidimensional queries and data mining with drill down as required by management.
Platforms : NT 3.51and 4.0 Unix on IBM RS-6000. Sybase 4.9 and 6.0 C Shell scripts.

1991 -  1997
DataMart Developer

Data Warehouse : A data mart in support of marketing : Assessment of Needs, Logical Design and Physical Design. Initial implementation of data warehouse : created all objects. ETL and initial data migration into data warehouse and ongoing ETL of data feeds on a set schedule. Defined standards and metrics for data validation. Set up a reporting system. Performed 2 subsequent resizings of data mart and provided ongoing maintenance and backups on regular schedule. Installed and maintained Oracle Financial Applications
7.1 and 8.

Miscellaneous

ETL : Installed and configured Informatica 3.0. Created all source and target definitions, specified and implemented transformations and set up a full suite of sessions. In 1997 upgraded to Informatica 4. Maintained and tuned ETL and Reporting performance.
OLAP and Reporting : Installed MicroStrategy DSS Agent. Supported Crystal Reports, Oracle Express.

Platforms : Oracle 5.1 7.2 7.3.4 Oracle Parallel Server 7.2 and 7.3.4 SQL, ProCobol, ProC, PL/SQL, SQL*Loader, Stored Procedures, Triggers, Forms 4.0 and 4.5 Reports 2.5 Oracle Discoverer, Developer 2000 forms and reports. Oracle Financials 10.7 Database Replication. Interface to Gerber 3 - D design system. Additional Visual Basic 5.0 GUI and interface to Excel and to payroll system. Crystal Reports. DSS Agent marketing decisions. Interactive 360/IX Unix on Intel and Sun Solaris 2.4 - 2.6, HP-UX 9.0 and 10.0 Bourne, Korn, C-Shell scripting.