Data Analyst Resume San Francisco, CA - Hire IT People

SUMMARY

Database Administrator with 15 years private businesses and government agencies of experience and specialization in database maintenance, data modeling, performance optimization, replication, and migration, secure, recoverable and scalable database solutions, meeting business requirements and user specifications.
Easily adopter of new product features, tools and techniques.
Team player and mentor, self - motivated with strong team and interpersonal skills.
Open and have experience to work in 24x7 shifts.
12 years of experience on Z/OS, OS/390, 5 years DB2 UDB

TECHNICAL SKILLS

Hardware: Sun SPARC M4000, IBM 9672, IBM 2066, IBM 2064, EMS SAN

Operating System: Z/OS, OS/390, Solaris, Linux, MVS/ESAMS Windows

Databases: DB2, ORACLE, MySQL, SQL Server, PostgreSQL, MS ACCESS

Language: JCL, SQL, Shell Scripting, PL/SQL, CLIST, C

Software: IBM Data Studio, BMC TOOLS, CATALOG MANAGER, DASD, ERWIN, QMF, SPUFI, OMEGAMON, VISUAL EXPLAIN, DB2 CONNECT, TIVOLY, TSO/ISPF, ABEND-AID, VSAM, JCL,CHECK, JES2,JES3, CA, SDSF, RACF, SYNCSORT, QUEST, MQ, SAS, WebSphere, MS Office

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

Provide routine and consistent checks to ensure data integrity, correctness, and completeness with Oracle DB
Effectively performing Integration testing between Web App, WAP and External
Clients using internal API test tool and XML
Ability to create users and general system administrative functions
Designing, implementing the conceptual, logical and physical design for distributed databases (OLAP, OLTP)
Configuring Query Replication to full testing environmental and compare dates after changes applications
Create and present data reports, implement customers with statistical summaries using Informatics software
Testing recovery using NAS technology and TSM software
Test ETL function on different environment using VMware
Write summaries to accompany graphs and charts
Performing test for Marketing and Business teams using reporting tools eSearch and Omniture
Interacting with Compliance team to execute Certification test with every new product/short code
Implemented test plans and test cases templates

Confidential

Data Analyst

Responsibilities:

Responsible Capacity Planning, Database Performance & Tuning, Database Maintenance, Database Backup &Recovery, Data Administration, Logical Design and Modeling, Physical Database Design, Replication
Installation and administration DB2 on OS390, Z/OS and DB2 UDB on Linux, Windows
Provide support to System Administration in database installation, upgrade (PTF using SMP/E, Fix Pack)
Logical and physical database design, data modeling
Performance tuning using system software and thing tuning with ZPARM
Optimizing queries to be executed against high volume, high availability OLTP and OLAP
Database backup & recovery (offline & online backups; full, incremental & Delta incremental)
Write and optimize SQL, work with Developer Team to SQL tuning
Data Replication between Data Centers, subsystems, nodes and databases (Data Propagator, QReplication)
Designing system storage structure and planning future storage requirements (choice, performance and tuning DASD)
Tuning WLM, performing Databases (Reorg, Runstats, Build and others DB2 Utilities)
Database monitoring (event monitor outputs, security audit reports, performance report)
Installing, performing, executing, troubleshooting client applications on Z/OS, Unix, Linux, Windows platforms
Preparing to migrate databases from zLinux to AIX platform: create plan, organize rules, review application schema
Tune all Oracle instance components including SQL and PL/SQL
Control all migrations of Oracle schema objects
Install maintenance SAS Server on Z/OS and MS Windows. Work with thin, thick clients change codes in Macros, Procedures. Create Map Diagrams, detailed statistical charts and tables
Production support MS Access Databases. Work with developers to create SQL for business reports
Monitor systems performance on MS Access and MS Server
Integrate with SAS team to develop SAS application for ETL processing
Troubleshooting application writing on code VB, JAVA, C, C++, Cobol, SAS, Assembler
Create technical documentation and operational instructions
Management MS Windows Advanced Server 2000/2003

Environment: DB2, DBA, SQL, Windows Server 2000/2003, Linux, Z/OS, OLAP

We provide IT Staff Augmentation Services!

Data Analyst Resume

San Francisco, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship