SUMMARY

• Results - oriented, dedicated Data Architect professional with career success developing and maintaining high-demand infrastructures and schemas, specialized in supporting Data solutions across various systems and platforms. Service delivery targets maintained.
• Proven success in Oracle RAC, IBM’s DB2, Administration Tools, Oracle Enterprise Manager, PE, Automation, SQLPA, Shell scripting, Sybase and Query Monitor.
• Expert in building and implementing innovative database solutions utilizing both Logical / Physical data architecting and modeling. Highly analytical in the analysis, testing, and execution of leading database platform applications.
• Skilled project leader, able to direct multiple tasks effectively, achieving deadlines and prioritizing work schedules to meet project demands and tight development schedules. Hands-on all around technician in all aspects of Data Architecture.
• Assisted Financial Institutions in avoiding fines for noncompliance with Federal and State regulations. Increased profitability by supplying financial advisors with more information about their clients. Single handed effort to provide a model and code to reduce financial exposure. Created methodology to upgrade dozens of technology systems with no costly manual intervention.

Areas of Expertise

• Conceptual, Logical and Physical Data ModelingMetadata Management: Update, Analysis, and Reporting
• InformaticaMapping
• Business Intelligence Reporting and PlatformsSecurity & Disaster Recovery Planning
• Full Lifecycle Project ManagementMultidimensional Modeling
• Custom Database Software DevelopmentTroubleshooting & Problem Resolution
• Software Application Monitoring & RepairPredictive Analytics
• Instructor, Mentor of staffData Pattern Analysis
• Data WarehousingPerformance and Tuning
• Star and Snow Flake SchemasStructured, Unstructured Data Modeling
• Data Governance, Stewardship and QualityColumnar
• Stored ProceduresMaterialized Views
• SDLC (System Development Life Cycle)Data Integration
• FlashbackRMAN recovery
• Master Data Management (MDM)ETL

TECHNICAL SKILLS

Platforms: Z/OS, CICS, VM, Windows, UNIX, LINUX, Microsoft, Stored Procedures, Batch

Tools: Microsoft Office (Word, Excel, PowerPoint), Starteam BI reporting, Enterprise and Data Architecture tools ERWIN, ER/Studio, Powerdesigner, and Toad

Data Platforms: Oracle RAC, DB2, VSAM, BDAM, BSAM, TCP/IP, DB2II (Federation), OLTP/OLAP, Sybase

Database Tools: Powerdesigner, Oracle SQL Developer, Informatica, IBM’s Admin, CA/Platinum, Query Monitor, SQLPA, Automation, DB2 Util, Omegamon, Explain, EEE, BMC

Languages: PL/SQL, T/SQL, COBOL, JCL, Z/OS Assembler, SQL, QMF, Java, REXX, CMS EXEC, XML, Perl, Shell Scripting

SDLC Methodologies: Agile/Scrum, Waterfall, RAD/JAD, UML, ITIL, TOGAF, DLP, Data Lifecycle Management

Main Industries: Financial, Medical, Payroll, Human Resources

PROFESSIONAL EXPERIENCE

Confidential

Application Architect, Data Architect

Responsibilities:

• Provide documentation, SQL, Informatica mapping, to input banking book to Volcker compliance procedures. This made the bank avoid heavy fines for noncompliance such as Confidential has had to pay.
• Architected to conform to regulatory and compliance issues. This was essential to avoiding prosecution for noncompliance.
• NASDAC SMARTS HKEX input. Interfaced with Hong Kong and India teams to provide mapping. SMARTS in turn generates alerts telling us when we are out of compliance. This saves us the cost and possible errors we would have if we wrote these alerts ourselves.
• Data mapping and documentation to provide Wash Alerts.
• Applied Oracle, Oracle SQL Developer and Informatica knowledge to investigate and verify mapping issues. This improved the quality assurance phase of project updates and so avoided errors in the compliance software.
• Performance and Tuning - SQL review demonstration of faster, and therefore cheaper, ways of running.

Confidential

Data Architect

Responsibilities:

• Performance and Tuning - Analysed ADDM reports to improve load and materialized view generation from 4 hours to 12 minutes.
• Architected to conform to regulatory and compliance issues.
• Integration of several different systems into a data warehouse using PL/SQL, SQL Loader, and other tools.
• Converted T/SQL Microsoft SQL Server to PL/SQL Oracle an entire system they had. This allowed us to shut down old vendor products and save the investment in them.
• Converted Sybase procedures to Oracle Stored procedures.
• Wrote large numbers of complex SQL for materialized views, procedures, functions and triggers. Performance and tuning of old queries.
• Metadata management and ontology on Power Designer and Erwin products.
• Designed, developed and led relational and data warehouse architecture for eCommerce. Put relational tables in normalized form.
• Designed and developed new data warehouse, data modeling and testing standards for warehouse appliance. Predictive analysis on this data. This will help the banks customers to make more money by giving advisors more information.
• Designed and developed relational and dimensional data models for OLTP and Data-Warehouse applications. Utilized both flat file and CSV as import concepts. Used Powerdesigner for modeling.
• Extensively worked on developing data quality, predictive analytics and data profiling data models and presented model visually. Output to data visualization tools. Mainly used to evaluate financial advisors, product specialists and managers.
• Responsible in maintaining common data dictionary across the portal.
• Rolling out data modeling (OLTP/Data-Warehouse/Data-mart) and coding standards for IT.
• Designed and developed intelligent proactive business process monitors to achieve high portal availability goal.
• Developed, tested, and rolled-out PL/SQL Stored Procedures, Materialized Views, and ETL processes.

Confidential

Data Architect, Database Administrator

Responsibilities:

• Created and maintained data model, and SQL for application posed to make large reductions in exposure to lending institutions.
• Mapped Medical Insurance claims into a relational data model.
• Toad and ER/Studio used in producing the Data Model.
• Wrote shell script to install Oracle database, including setting of storage and memory parameters based on particular system, configuration of OEM and other Oracle products.
• Data pattern analysis on Medical claim input from clearing houses.
• Architected to conform to regulatory and compliance issues. Avoiding violation of HIPPA
• Metadata management and ontology on Embarcadero products.
• Wrote large numbers of complex SQL for materialized views, procedures, functions and triggers. These would be used in calculating valuations to hugely reduce financial exposure. Performance and tuning in optimizing the SQL resulting in significantly less resources in use.
• Integration of several different systems into a data warehouse using PL/SQL, SQL Loader, Datapump and other tools
• Converted T/SQL programs from another company to PL/SQL for Insurance Claim analysis.
• Designed, developed and led enterprise data architecture for eCommerce in importing large amounts from clearing houses. Managed several terabytes. Text Analytics implemented on Oracle databases.
• Agile, global, early growth stage, entrepreneurial company with rapidly changing priorities.
• Designed and developed new data warehouse, data modeling and testing standards for warehouse appliance. Predictive analysis on this data.
• Designed and developed relational and dimensional data models for OLTP and Data-Warehouse applications. Utilized both flat file CSV as import concepts. Used Embarcadero (ER/Studio) for modeling.
• Extensively worked on developing data quality, predictive analytics and data profiling data models and presented model visually. Output to data visualization tools. Mainly used to evaluate claims by facility, insurer, and/or service code.
• Responsible in maintaining common data dictionary across the portal.
• Rolling out data modeling (OLTP/Data-Warehouse/Data-mart) and coding standards for IT.
• Defined performance standards to achieve acceptable performance for the portal.
• Responsible to design data-security on multi-tenant portal on centralized database.
• Designed and developed intelligent proactive business process monitors to achieve high portal availability goal.
• Rolled-out homegrown PL/SQL and ETLs.
• Designed Master Data Management generic data model to maintain data governance.
• Employed columnar storage to facilitate faster predictive analytical queries and data compression.
• Representing metadata HTML format, via use of ER/Studio products.
• Performance and Tuning - regular review of ADDM reports for optimizing system configuration, memory configuration, and application suggestions. This resulted in far better throughput, and therefore less costly runs.

Confidential

Data Architect, Technologies Consultant II, Lead Database Administrator

Responsibilities:

• Credited for driving the inclusion processes to support three new businesses, including Canadian payroll company, San Dimas Tax center, and Confidential retirement services. Each required data pattern analysis and ETL from data sources to company standards to include in our platforms. This resulted in lowering overall maintenance costs for these systems. Self written procedures used for integrating this data.
• Demonstrated innovation and technical acumen in conversion from Datacom to DB2. Datacom is a significantly different RDBMS than DB2 and had to be remodeled to company standards. This included Employee data and company data for all our several hundred thousand clients.
• Saved lots of money by writing engineering functions in shell scripts, like download of software upgrades, building of rollout streams, checking of performance parameters.
• ETL of Pay data from VSAM to DB2. Self written procedures used for data integration.
• Served as project leader in company’s first applications to run on UNIX.
• Demonstrated high-level dedication and professionalism communicating and educating application writers, DBA’s, and end-users on all new DB product tools, utilities and features.
• Exceeded expectations in developing, and documented new procedures to support data model in more than 50 databases.
• Served as project leader during upgrade of DB2 software upgrades to versions 7, 8, and 9 which resulted in using only 30% of resources to implement and maintain full functionality of new vendor software.
• Improved operational efficiencies by reviewing and downloading software, upgrades, and patches to support sandbox system, configuring parameters and application interfaces.
• Consistently sought out new opportunities to establish strategic analysis with operational staff, earning a reputation for resolving dependencies, addressing system inconsistencies, and devising installation schedules without affecting daily operational standards.
• Collaborated with management regarding infrastructure design and configuration of new applications and features to support application upgrades, functionality, and performance.
• Metadata management and ontology on Erwin products.
• Used Performance Monitor and Performance Expert to assist developers in performance and tuning. This resulted in the need to buy less hardware and less down time.