Summary:

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

TOOLS and METHODOLOGY

James Martin Information Engineering /Computer Aided System Engineering C.A.S.E. tools - CA / ERWIN / ALL FUSION / IEF / COMPOSER / COOL:GEN, ER/STUDIO PACBASE cross platform meta-data repository, CHEN ERD, Yooden Object Oriented Analysis, IBM RUP / Zachman, DB2MON, TOAD, XML DOM Model / DTD / Schema, data flow diagram, decision tree analysis, mainframe / client-server / Master Data Management MDM

database administrator / data architect

• 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

Database Analyst/Database Administrator/Architect

• 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

DATABASE ADMINISTRATION / ARCHITECTURE

• 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.

Data Modeler/DBA/Data Architect

• 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
• Additional technical experience on database administration / disaster recovery / primary production on-call tasks will be provided if interested
• 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

DATABASE ADMINISTRATION / ARCHITECTURE

• 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 technical experience on database administration / disaster recovery / primary production on-call tasks will be provided if interested
• ERWIN Technical Lead / Lead ERWIN MODELMART Administrator
• 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
• 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

Senior Systems Developer

• IEF CASE tool business area analysis / data modeling/ code-gens against DB2 OS/390 mainframe systems/ testing/ internal design, external design, users and systems documentation.
• Employed JAD / ER diagramming / decision-tree / state-transition diagramming / entity-life-cycle diagramming / prototyping to extract / confirm business rules from business end-users / managers / directors
• Facilitating requirement gathering / business function analysis / system process re-engineering of legacy corporate bank Special Loan System led a team developer, IRM specialist, business end users, middle line manager and assistant manager in redesigning / converting the paper based / report-driven hierarchical IMS database system to online relational DB2 database system
• Retrofitted system interfaces between Special Loan system to General Ledger, Demand Deposit, Electronic Fund Transfer
• Built new corporate bank customer relationship management system : developed enterprise conceptual data model, decomposition into corporate banking / retail banking / investment banking / technology banking sectors built logical / physical data models decomposed enterprise business areas into line-of-business function, dwelled down multiple levels to basic elementary processes, where CRUD matrix was built. Performed / documented entity life cycle analysis, state-transition diagrams, decision-tree analysis
• Participated in requirement gathering and design of investment banking portfolio system developed 3rd normal form data model and with ORACLE DBA's help identified de-normalization consideration based on data / transaction volume helped debugged, built and tested ORACLE SQL FORM system involving ORACLE triggers, PL/SQL
• Developed re-usable flexible modular role-based security model to facilitate faster turnaround of business driven changes
• Developed rule-based / data driven model design concepts and template of best practices
• Developed and documented high level / external design, model entity-attribute reports, generated model consistency reports
• Developed unit test plans, system test plans, integration test plans, performance test plans.
• Coordinated and co-conducted design meetings, walkthrough / QA check meetings built consensus and resolved interdepartmental conflict of interest, obtained sign offs between IT management and business management
• Built / refined prototypes. Conducted offsite usability studies at the bank's multi-media video lab facilities

REFERENCES

SAFEAUTO INSURANCE

• extract sample performance review by Shane Switzer /Director IT Administration currently VP of Procurement - SAFEAUTO INSURANCE
• job knowledge :
• Alex does an excellent job of keeping himself updated about current development in his field. He demonstrates competency in the skills and knowledge required.
• quality:
• He displays a strong dedication and commitment to excellence. He works hard to improve quality in his own work and promotes quality awareness throughout the organization, Alex consistently and carefully monitors his work to ensure its quality.
• problem solving :
• Alex identifies the existence of problems quickly. He is skilled at gathering and analyzing information from multiple sources. He addresses problem solving situations by analyzing options and developing several alternative solutions.
• initiative :
• Alex is quick to volunteer whenever others need help. He undertakes self-development activities on his own initiative and he occassionally seeks increased responsibilities beyhond the normal scope of his job.
• cooperation :
• He usually establishes and maintains good working relationships. His outlook is generally positive and his manner is pleasant. He works cooperatively in group situations.
• dependability :
• His dedication to the job oftent exceeds normal expections. Alex responds promptly to requests for service and assistance.
• innovation :
• Alex generates many usable and ingenious suggestions for improving work. He has developed some highly innovative approaches and ideas. He displays creativity and original thinking in his work. Alex is usualluy resourcefully when faced with unexpected challenges.