TECHNICAL SKILLS:

DATABASES: DB2 9.5, OS/390 Z/OS, IMS, ORACLE v7, SQL*PLUS, SQLserver 2005

OPERATING SYSTEMS / STORAGE SYSTEMS: Windows 2003 Enterprise Server, Z/OS - OS/390, OS/2, AIX, LINUX, NetAPP

SOFTWARE: JCL, BMC, CICS, Embarcadero/ERSTUDIO; IEF/ COMPOSER / COOL GEN; ERWIN / MODELMART / ALL FUSION

PROFESSIONAL EXPERIENCE:

Confidential, Ohio

Database administrator / Data architect

Responsibilities:

• Re - architected DB2 UDB AIX Informatica ETL / Business Object reporting BI / OLAP system, migration to open source LINUX, adding double 365x24x7 availability protection with fail-over architecture and taking advantage of virtual machine technology
• Overhauled security architecture: Introduced DB2/ZOS role-based security /Trusted Context security; conducted testing, published results, convinced lead ZOS DB2 systems programmer buy in / test / implement the expensive / complex infrastructure changes and security overhaul
• Performance tuning on Informatica jobs and Business Object reporting - revised job stream flow, helped fixed up Informatica target definition, dropping/recreating indexes ( and physical database index redesign), transformation, adding job stream checkpoint restart capability
• Analyzed data / growth / change requirement across DB2/mainframe - DB2/LINUX; QA checks (caught / raised data quality issues / data governance issues ); advised on data model / meta-data model / enterprise repository design
• Transferred MDM /model management knowledge / meta-data management design, proposed new standards and best practices in database object naming convention to address existing inconsistence across different systems, proposed series of scripts/jobs to improve data quality / prevent potential production problem

Confidential, Ohio

Database Analyst/Database Administrator/Architect

Responsibilities:

• Reverse engineered production system back into data models.
• Maintained data model changes.
• Trained developers on data modeling practices.
• Developed various re-usable common “sub-models” and common entities to train developers / analysts on various data modeling techniques: normalization vs. de-normalization, role-based security modeling, component-based modeling, business rules - data driven modeling, OLTP / OLAP dimensional modeling and OLTP/OLAP integration, data model sub-setting, business area analysis, data life cycle analysis, state-transition diagramming, data decision tree, unique identifier generation strategy, XML and hierarchical data structures and XML physical database implementation, physical data modeling - performance best practices
• Created / maintained data model change control / version control procedures, emergency change procedures, and monitored new software releases impacts.
• Developed / promoted and ongoing maintenance of standards/ best practice templates on naming / usage of tables / views / attributes / TRIGGERS / STORED PROCEDURES, OLTP normalization / de-normalization cost/benefit, db-referential integrity vs. programmatic RI enforcement
• Established standard practice of information gathering on data volumetric / archive -retention requirement of data
• Supported OLTP/OLAP ETL from core DB2 to SQLServer / DTS /SSIS service, consulted on OLAP designs / slow changing dimension - conform dimension design / multi-clustering design / partitioning design
• Introduced / championed for data-warehousing / data-mining and event driven BI to IT executive management, resulting in the creation of new data analytic team and attracted senior corporate executive office sponsorship.
• Reviewed / approved new project data models and existing model changes; ran data models quality checks, identified potential data quality problems, referential integrity problems, performance problems, provided advices and alternative design, requested rework
• Investigating legacy systems data QA issues, created jobs to investigate data pattern, growth pattern, data inaccuracy pattern
• Devised roadmap for step-by-step system overhaul toward an organized master data management infrastructure, including long term data governance strategic goals and short term tactical direction
• Trained two DBAs on database / instance parameters setting / performance tuning / log file performance bottleneck get-arounds, refresh job scripts explanation, high availability fail over procedures etc.
• Additional technical experience on database administration / disaster recovery / primary production on-call tasks will be provided if interested

Confidential

Data Modeler/DBA/Data Architect consultant

Responsibilities:

• Uncovered the lack of disaster recovery practice; designed templates for both IT / hardware / software failure scenarios and recovery procedures, and high level business continuity templates, sent to IT executives and championed for enterprise DR procedures
• Researched and scum work to gather cost / benefit / payoff for data mart /warehousing, to promote business intelligent benefit to senior IT management
• Introduced / set up standards / assisted developers in building triggers and stored procedure; naming standard; usage standard

Confidential, Ohio

Data Modeler/DBA/Database Architect

Responsibilities:

• Helped set up ERWIN MODELMART new DDL gen guidelines/ naming conventions, backup strategies across OLTP/OLAP
• Ran ERWIN model checks, model compares, automatic DB2 host database synchronization; identified / fixed ERWIN objects, investigated model corruptions, uncovered and worked with CA tech support to fix ERWIN bugs
• Worked with business analysts to develop pieces of data models and addressed integration issues into next release of XML banking software for the banking clientele
• Developed OLAP / OLTP interfaces, dimensional model with data source/target mapping, ETL jobs and performance tuning
• Explained various modeling practices and techniques ( role - based security, data-driven modeling, CRUD matrix ) to enterprise IT architects, fellow DBAs and designed customized adaptation
• Ad hoc Huntington Bank support - COOL:GEN data model enhancement and reporting; collected volume info and statistics.
• Published data model reports on Intranet, kept track of change and versioning and model backups.
• Built, reviewed, made recommendation to data models /database design and implemented logical and physical data model.
• Replication of database objects and data; promotion of database changes and data changes across different environments and across OLTP/OLAP ETL changes / source-target mapping
• Configured subsystem and DB2/ZOS- ZPARMs tuning; generated ZPARM module; improved dynamic SQLs, increased JDBC connections limits, reset max. concurrent users limits, configured connection timeouts; performance and system monitoring on I/Os, bufferpool /EDM / hiperpool pool setups.
• Additional tec hnical experience on database administration / disaster recovery / primary production on-call tasks will be provided if interested

Confidential, TX

DBA/Database Analyst

Responsibilities:

• Managed ERWIN user accounts / profiles /access; worked with vendor technical support, managed/leveraged software.
• Mentored database staffs /application staffs in ERWIN / MODELMART usage.
• Led ERWIN NT/MODELMART 3.5.2 upgrade ORACLE 7/UNIX with team of ORACLE DBAs, INTEL Server Admins.
• Led effort on improving ERWIN ModelMart Library management efficiency; planned cleanup cycle, improved space utilization.
• Handled / implemented database change control with Embarcadero DBArtisan/ DB2 / ORACLE and ERStudio DDL gens
• Developing interfaces and sub - setting strategy to the IBM IIA Insurance Data Model for practical implementation
• Repaired model corruption ER1 file on Windows NT and assisted ORACLE DBA in database recoveries.
• Advised on model/ database design / normalized / de-normalized / index usage / SQL tuning / RI issues / BIND parameters.
• Additional technical experience on database administration / disaster recovery / primary production on-call tasks will be provided if interested

Confidential

Database Administrator

Responsibilities:

• Data Modeler, Advanced Systems Engineer, IEF Encyclopedia Administrator / Technical Leads Canada,USA,UK - Jun/94-Feb/98
• Promoted / applied process engineering, SEI CMM, SDLC, TQM systems / data quality methodologies and best practices
• Laid down EDS North America central data model management road-map, provisions for individual EDS client customization / optimization within a master framework / strategy for adaptability flexibility into the global EDS enterprise
• Defined/ maintained model subsets, encyclopedia access, models migration, models merges, models adoptions, models splits.
• Developed DB2 / OS390-mainframe data models, process models / applications / web-apps with COMPOSER/COOLGEN COBOL/CICS/IMS/DB2/ ORACE with C++ / JAVA / HTML / JSP
• Performed check-in/check-outs and version control of data models and common action blocks of process models.
• Re-architected SIGNET bank model repository, re-architected banking COBOL/CICS-transactions and program structures to more model-based structures ( received $2,000 bonus and baseball tickets / paid day off at baseball game)
• Trained team in OLTP / OLAP dimensional data model, conform dimensions, model management, sub-setting, version control
• Installed / upgraded / resolved OS, DB2, DB2/2, data model corruption / encyclopedia issues