JAMES R. CIMINO

*** ******* ** ***** ******, Pa *6046

Home 724-***-**** Cell 412-***-****

acgiyz@r.postjobfree.com

CAREER SUMMARY

Experienced DBA with comprehensive expertise in the design and implementation of relational databases and warehouses.

Background includes the design, development, modification, documentation, and integration of hardware and software systems

used in product applications.

WORK EXPERIENCE

SAS INSTITUTE INC. Cary, North Carolina ( Pittsburgh regional office )

10/2004 - Current

DBA / Principal Solutions Architect – Fraud and Compliance Division

11/2010 - Current

• Responsible for the logical & physical database design for two of SAS’ next generation software products. Visual Data

Builder, which is a data integration & ETL tool. And Visual Studio Designer, which is a business rules authoring, promotion,

and analysis tool.

• Support of multiple internal development teams. Responsibilities include mentoring, tuning, & troubleshooting/debugging

during product development.

• Data Governance & development of naming standards and data modeling conventions within the division.

• Emerging Technologies Group. Responsibilities include Big Data initiatives using Cloudera Hadoop and its associated

ecosystem tools. The goal is to access the viability of porting traditional relational based products & solutions into a

Cloudera Hadoop based data store.

Sr. Technical Consultant – US Professional Services & Delivery

10/2008 – 11/2010

• Wakefern Foods project. DB2 v9 Enterprise Edition running on a 5 node DPF cluster. This client was experiencing

significant performance and scalability issues. Redesigned & architected the DB2 partitioning scheme enabling

data co-location. Educated / mentored application team & client DBAs on improved sql techniques & physical

database design within a DPF environment.

• Bank of America Anti-Money Laundering project. Migrate & Rearchitect AML1.4 running on Oracle 9i to AML 4.2 running

on Teradata v2r6. All SAS AML scenario code was ported and rewritten as Teradata stored procedures running within the

Teradata engine.

• US DOE project. Oracle 10gR2. The client & SAS team were experiencing performance problems with a

Student Loan Fraud Detection System. Worked with the team to troubleshoot, identify, diagnose, and ultimately

resolve performance & design problems at multiple levels. Remediation included physical database design

changes, scheduling automated maintenance, revised database parameters, and changes to the mid-tier connection

pool configuration.

• Pinnacle Entertainment Corp. Developed a large scale (15Tb) active data warehouse on Teradata v13. Patron value

optimization project which focused on improving customer relationship management, marketing automation, campaigns and

analysis.

• Worked on various other consulting engagements with an emphasis on the backend RDBMS.

DBA / Data Modeler – R&D Financial Services

10/2004 - 10/2008

• Logical and physical database design including transaction processing, ODS, and data warehouses. The primary

project was a custom credit card fraud detection system built for the world’s third largest bank. It is a high volume

oltp database and a multi-terabyte data warehouse. Average transaction rates exceed 120+ per second with

3 Tb of data moving into and out of the data stores daily.

• Established and enforced product naming conventions. Documentation of data flows, data content, data

relationships and structure, processes that manage, transform or touch data, business rules that govern the

data, durations for which data is required.

• Requirements analysis and design. Documentation of technical and functional requirements including data

availability, data volumes, response time, data security and privacy. Worked with technical architects, developers,

business owners, and end users to ensure that all specifications were captured and reflected in the product design.

• Performance tuning and troubleshooting responsibilities at the system, database, and sql levels. Including stress

testing and capacity planning.

• Development of standardized stored procedures to encapsulate complex business logic within the database engine.

JAMES R. CIMINO

115 Bristol Dr Seven Fields, Pa 16046

Home 724-***-**** Cell 412-***-****

acgiyz@r.postjobfree.com

WORK EXPERIENCE

ENTIGO, INC. d/b/a SIGNAL INTERNET TECHNOLOGIES, INC. Pittsburgh, Pennsylvania 6/1999 - 10/2004

Sr. Database Administrator

12/2000 - 10/2004

• E-commerce architecture ( system level and database level ). Business requirements analysis, tool selections,

high availability.

• Development of enterprise wide database policies, standards, and best practices. These include security, backup

and recovery, object naming, structural standards & database layout, data integrity, and programming standards.

• Analyzed and determined data requirements for internal/external applications and users.

• Established and managed a team of 3 DBAs.

• Support and advisory responsibilities for offsite client and web hosting technical staff.

• Review and assess the impact of system changes prior to their implementation.

Database Administrator

6/1999 - 12/2000

• Administered sixteen Oracle instances (development, QA, stress testing, pre-production, and production).

Currently responsible for three 24x7 Oracle instances. Duties include day to day problem determination and

monitoring, backups, configuration management, and maintenance.

• Designed and developed an online automotive parts catalog database (WebCAPS); a 120 gigabyte database

servicing the internet, an intranet, and an extranet.

• Installed and configured Oracle RDBMS sever software utilizing OFA guidelines. Installed and configured OEM,

Oracle Intelligent Agents, Oracle Context/Intermedia, and Oracle Reports.

• Performed complex server level PL/SQL application programming including stored procedures, functions, packages, nested

arrays, and user defined types.

• Support of development staff and application teams with regard to query & database design. Support of QA staff

including production data migration and replication.

• SQL analysis and tuning; including logic flaws, and the underlying database structures supporting the SQL.

• Full life cycle development experience; including requirements gathering, logical & physical modeling, development,

quality assurance, user acceptance, and production.

INNOVATIVE SYSTEMS INC. Pittsburgh, Pennsylvania

11/1994 - 6/1999

Systems Analyst

• Designed, developed, & implemented a 45 gigabyte enterprise wide Oracle 7 (migrated to Oracle 8) data

warehouse and a 55 gigabyte DB2 Common Server warehouse. Familiar with logical model to physical

model transformations.

• Administered three Oracle databases and two DB2 Common Server databases. Duties included installation,

upgrades, maintenance, end-user training & support, backups, applications programming (including shell scripts),

& database/query tuning.

• Developed & implemented a data warehouse for DEC, Oracle, & ISI for demonstration at Telecom ‘95.

• Administered seven Unix servers. Duties included installation, hardware & software upgrades, maintenance,

licensing, backups, and purchasing support.

• Analysis & design of UNIX and PC based database scrubbing & matching software used in the banking industry.

• Enhanced existing mainframe Cobol and C software.

JAMES R. CIMINO

115 Bristol Dr Seven Fields, Pa 16046

Home 724-***-**** Cell 412-***-****

acgiyz@r.postjobfree.com

WORK EXPERIENCE

AMERICAN STERILIZER COMPANY Erie, Pennsylvania

7/1991 - 11/1994

Applications Programmer

• Designed & implemented a real-time information collection and multi-user database management system using

the C programming language, Novell Netware APIs, & RS-485 APIs.

• Wrote, tested, provided troubleshooting and customer support for software utilized in hospital equipment products.

• Supervised several Novell 3.11/3.12 networks.

• Modified existing sterilizer embedded systems programming to correct operational problems.

• Revised product test specifications to reflect changes to software programs.

EDUCATION

PENNSYLVANIA STATE UNIVERSITY - The Behrend College Erie, Pennsylvania

1991

Bachelor of Science Degree Major:

Mathematics, Computer Science Option

SKILLS

Hardware Sun, HP-UX, IBM-AIX, Windows. Departmental level severs to Enterprise level.

Operating Systems Sun 2.4 -11, HP-UX, IBM AIX, Linux (REHL & Suse), System V & BSD kernels

Languages C/C++, Pascal, Cobol, Fortran, SQL, PL/SQL (Oracle, DB2, & Teradata dialects),

Unix Shell Scripting (Bourne, Korn, C shell)

Database & Tools Oracle (v6.0 through 12c), PL/SQL (Triggers, Stored Procedures, & Packages),

various Oracle utilities including OEM, AWR, Snapshots, Rman, SQL*Loader,

Tkprof, Oracle trace

DB2 (v5.2 – v9.7 Unix Based), DB2 Parallel Edition for SP/2, DB2 (v2.1.2) Common Server for AIX,

DB2 tools including Control center, Visual explain, Snapshot monitor, ect.

DB2 Stored Procedures & Triggers

Teradata v2r5, v2r6, v12, 13, & 14. Teradata tools & Utilities v2r5 through v14.

Cloudera Hadoop version 5, including the Hadoop ecosystem tools: HBase, Impala, Hive,

HDFS, ect.

CA ErWin, Embarcadero ER/Studio, ETI*Extract

References available upon request

Contact this candidate