The Most Visited Job Board for Women
- Featured in the Wall Street Journal
Status: Logged Off
- Featured in the Wall Street Journal
Status: Logged Off
Search All Resumes | Submit Your Resume | Search Jobs
Registered Dental Hygienist Resume
Jean
US
DBA/ Data Analyst/ Business Analyst
a contract DBA/Data Analyst/Business Analyst role with a company with data management needs
Jean Chenrnshuchun.chen@gmail.comrn804-381-5091rn------------------------------------rnEXPERTISErnrnDatabase Administration, Application Development, System Administration, Data Analysis, Business rnrnAnalysis, Project Management.rnrn------------------------------------rnSUMMARYrnrn. 6 years in DBA roles, 8 years as IT professional, 12 years programming experience, 4 rnrnyears of undergraduate education in Management Information Systems. rn. Proven track record in supporting IT projects through the full life cycle of development rnrnin database, application and system areas. rn. Subject matter expertise in data architecture of new database systems, data dictionary, rnrnSQL programming. rn. Strong troubleshooting capability and hands-on experience in managing multiple rnrnenterprise databases with 99% uptime and zero data loss.rn. Extensive exposure to Business Intelligence, Data Warehouse and ETL solutions. rn. 7 years experience in external and internal consultant roles, excellent client facing rnrnand team work skills in large and small end user/IT teams with members of diverse backgrounds.rnrnWORK ELIGIBILITYrn. Candidate does NOT need H1B sponsorship or transfer. rnrn------------------------------------rnCERTIFICATONSrnrn. Oracle 9i Certified DBA (OCP)rn. Oracle 8i Certified DBA, Oracle 8 Certified DBArn. Oracle 7.3 Certified DBArn. Microsoft Certified Technology Specialist (MCTS) on SQL Server 2008 (July, 2009)rn. SUN Solaris 8 Certified System Administrator (SCSA) rnrn------------------------------------rnTECHNICAL SKILLSrnrnRDBMS rnOracle 7.3, 8, 8i, 9i, 10g Server with replication, partitioning options as well as management rnrnutilities, Oracle Lite (Oracle Database Lite), SQL Server 2008, MS AccessrnrnApplication Tools and Languages rnSQL and PL/SQL, UNX shell scripting, Oracle Developer 2000 Forms and Reports, SPSS, C, C++, VBA, rnrnExcel Marco, MDX. Oracle Application Server Enterprise Edition, Oracle Warehouse Builder, Oracle rnrnDiscoverers, BRIO Query, MS Analysis Service, MS SSIS.rnrnPackages rnSQL Navigator, TOAD, Spotlight on Oracle, iWatch, MS Office 2003, Oracle Enterprise Manager, rnrnSTATPACK, Veritas Netbackup, Trace Analyzer, TKPROF, Explain Plan, SQL/Plus, DBCA, SQL rnrnOptimizer. rnrnOperating systems rnSun Marco Solaris 8 Unix, Windows 2000/NT Servers, Windows 95/98/XP/Vista.rnrnModeling Tools rnOracle Enterprise Manager rnrnNetwork rnSQL*Net config V2.X, Oracle Names, ODBCrnrnrn------------------------------------rnPROFESSIONAL EXPERIENCErnrnCompany: Genworth FinancialrnRole: Sr. Data Analyst/ Actuarial AnalystrnDuration: Sep. 2008 to Feb. 2009rnSoftware/Environment: Oracle Database 9i and 10g, SQL Navigator, TOAD, VBA, MS Access, MS rnrnExcel, Excel Macro, AXIS, Pivot Table, MS SQL Server 2003rnOperating System: UNIX, Windows XP, MS Office Suite, Windows 2000 ServerrnrnKey Projects handled at Genworth:rnrnClient: Actuaries in valuation teamrnProject Description: The clients were in need of expertise in data transformation to extract, rnrntransform and load data (ETL) from legacy system to new system. rnResponsibilities: rn. Migrated expense data, converted Valuation tables and performed policy validations to rnrnassist in the roll-out of new Valuation system. rn. Developed Excel macro using VBA to generate 500 data files in desired format by rnrnchannels, products and expense types to upload to new system. rn. Collected data requirement from business owner and established mapping of existing and rnrnnew data format to design VBA scripts. Handled exceptions to mapping rules to ensure data rnrnaccuracy. rn. conducted Long Term Care Experience Study in support of Actuarial and Risk users rnrninformation needs.rnrnClient: Actuaries in Immediate Annuity (SPIA) business unitrnProject Description: The clients were seeking an unbiased independent third-party to perform rnrndata cleaning and data integrity improvement activities on policy, customer, claim data and rnrnultimately to carry out data-driven business analysis in order to verify the business ownerˇ¦s rnrnactuarial mortality research. rnResponsibilities: rn. Clarified data descriptions and column interdependencies, defined client requirements, rnrntranslated business logic to select relevant columns and leave out the irrelevant and built rnrntables in MS Access by importing original data set. rn. Performed ETL tasks, removed data redundancy, resolved inconsistency, eliminated errors, rnrnand worked around data insufficiency.rn. Acquired external data set containing massive death records, identified key columns for rnrnlinkage. rn. Linked internal data set to external data file to produce list of accounts overdue. rn. De-normalized tables to create one unified data table, applied business logic to rnrnpopulate calculated columns, aggregated data on selected data fields and derived desired data rnrnoutput. rn. Pulled data to pivot table in MS Excel and manipulated data for analytical purposes. rn. Dissected existing SQL scripts and modified Access queries adding new analytical rnrndimension.rnrnrnCompany: Capital One Financial ServicesrnRole: Sr. Data Analyst / Sr. Operations AnalystrnDuration: May. 2007 to June. 2008rnSoftware/Environment: Oracle Database 9i and 10g, Teradata, SQL Navigator, MS Excel, Pivot rnrnTable, rn MS Access, MS SQL Server 2003rnOperating System: UNIX, Windows XP, MS Office Suite, Windows 2000 ServerrnrnKey Projects handled at Capital One:rnrnClient: Operations Managers and business analystsrnProject Description: The clients needed a variety of data analyses on both recurring and ad-hoc rnrnbasis to maintain day to day operations at call center and to tackle emerging operational rnrnproblems. rnResponsibilities: rnrn. Developd and ran SQL scripts against Teradata to verify data accuracy in data migration rnrnIT initiative. Designed queries to assess level of data inconsistency and explain source of rnrnerrors. rn. Built SQL scripts to pull values for an array of operational metrics, tracked values rnrnmonth by month and designed queries to zero in source of discrepancy. rn. Populated data to compare actual sales verses forecast numbers and designed queries to rnrnperform gap analysis. rn. Responded to client ad-hoc requests in support of operations improvement initiatives. rn. Executed data refresh in operational reports to provide an updated view of application, rnrncalls and booking counts and dollars. rn. Designed and modified forecast spreadsheet to produce sales target and recommended rnrnalternatives to solve operational performance variances. rnrnrnCompany: New York LifernRole: Database Administrator rnDuration: April 2001 to Aug 2004rnSoftware/Environment: Oracle 8i and 9i, TOAD, iWatch, Oracle Enterprise ManagerrnOperating System: Sun Solaris 8, Windows XP, Windows 2000 rnrnKey Projects handled at NYLI:rnrnClient: NYL IT partner InfosysrnProject Description: The IT partner was in need of local hardware and software support to rnrndevelop customized system architecture and to smoothly integrate new and legacy systems. rnResponsibilities: rn. Provided Oracle database production support for IT systems and managed pilot run in UNIX rnrnand application servers environment to successfully roll out new application systems. rn. Provided 24/7 on-call technical support to Infosys, logged database issues for Oracle rnrnmaintenance support, managed Oracle International license for NYL, resolved license issue, rnrnsecured on-going support from vendor. rn. Assisted database installation, database creation, and database backup and recovery. rnrnEstablished SQL*Net and set up TNS names enabling data links across databases. Created database rnrnalert scripts, monitoring scripts and RMAN backup procedures. rn. Performed database modeling and design (logical and physical), database migration onto rnrnvarious platforms, database upgrade, version controlrn. Executed data load, import and export, automatic distributing, data streaming, cleaning, rnrntestingrn. Conducted database installation and configuration, scheduling, Database integration, rnrnmirroring, Database license management, maintenance contract management. rn. Configured Veritas disk arrays for data warehouses and created alert system for rnrndetecting bottlenecks. Gathered statistics and wrote UNIX scripts to compress, backup and rnrnmaintain the remote databases. rn. Supported Oracle developers, performed data extract/load in testing environments, rnrnrevised data structure as needed, created database stored procedures and integrity checks, set rnrnup primary and foreign keys on master and detail tablesrnrnClient: NYL selected software vendor rnProject Description: The vendor was in need of technical expertise to overcome system rnrnperformance issue in order to launch product on schedule. rnResponsibilities: rn. Provided technical leadership to vendor on areas including database, application server, rnrnperformance monitoring tools, and internal computer environment. rn. Devised testing plan, proposed system framework, organized laboratory, secured testing rnrnservers to form a testing environment for performance tuning and troubleshooting. rn. Optimized database performance by identifying performance bottleneck in I/O access and rnrnmemory swap and adjusting database and server parameters using Spotlight, TOAD and Oracle rnrnEnterprise Manager and STATPACK. rn. Resolved data locks, monitored data file growth, tuned problematic SQL statements, wrote rnrndatabase triggers, fine tuned performance at table, tablespace and database levels. rnrnClient: Accounting department lead and Telemarketing managerrnProject Description: The clients was in need of upgrading current statistical software package rnrnExcel to a more powerful statistical software for the purpose of analyzing accounts and rnrnselecting name lists. rnResponsibilities: rn. Researched relevant software products available in the market, compared functionality rnrnand capability, and short-listed potential solutions for trial. rn. Introduced Business Intelligence software to client, arranged vendor presentations, rnrnprovided technology leadership to assist user experiencern. Executed and implemented selected software and troubleshoot integration issues rn. Designed data dictionary and created database objects with SQL Navigator and OEM in data rnrnwarehouse environment to meet client request of integrated data access.rnrnCompany: Stark TechnologyrnRole: Application Developer rnDuration: Feb 1998 to Feb 2001rnSoftware/Environment: Oracle 7i and 8i, BRIO QUERY, Oracle Enterprise Manager, Oracle Developer rn 2000 Forms and ReportsrnOperating System: Sun Solaris, Windows98rnrnKey Projects handled at Stark Technology:rnrnClient: Yu-Lon Automobile Manufacturing rnProject Description: The client was seeking to customize the supply chain model of Oracle rnrnApplication with the assistance of Stark and Oracle. rnResponsibilities: rn. Performed Application Server installation and configuration, trouble-shooting, issue rnrnlog, System (multi-tiered) management, performance tuning, trouble-shooting, activity tracking, rnrnstatus reportingrn. Conducted requirements gathering, definition and documentation, System and process rnrnanalysis, definition and documentation, System architecture and design.rn. Led System (multi-tiered) security management, Storage system management (Veritas), OLTP rnrnapplications report design and interface with front-end app.rnrnClient: Accounting department and sales departmentrnProject Description: The clients were in need of inventory, sales and procurement/purchase MIS rnrnsystems for transaction recording and reporting. rnResponsibilities: rn. Developed financial accounting reports (monthly, annually, semi-annually, ad-hoc), rnrnapplication (client-server, web-base) analysis, definition, documentation.rn. Led application development, testing, integration, version control, trouble-shooting, rnrnissue log, launch.rn. IT hardware and software evaluation and procurement, Internal and external customer rnrnsupport, helpdesk, road-show/training, IT personnel training.rn. Mobile application system administration, web administration, client app installation rnrnand data downloading, performance tuningrnrnCompany: D-Link Corporation rnRole: Engineer rnDuration: July 1997 to Jan.1998rnSoftware/Environment: Powerhouse, PowerbuilderrnOperating System: Windows 97rnrnClient: Product line, supply chainrnProject Description: The client was in need of a report that showed all the materials associated rnrnwith a semi-product or a product. rnResponsibilities:rn. Designed bill of material (B.O.M.) report for manufacturing.rnrn------------------------------------rnEDUCATIONrnrnTHE UNIVERSITY OF NORTH CAROLINA AT CHAPEL HILrnChapel-Hill, North CarolinarnMaster of Business Administration in High Technology, 2006rnrnNATIONAL CENTRAL UNIVERSITY rnChung-Li, TaiwanrnBachelor of Business Administration in Management Information Systems, 1997rnrn------------------------------------rnPROFESSIONAL TRAININGS rnrnDesigning and Implementing OLAP Solutions Using Microsoft SQL Server 2005 (June, 2009)rnMicrosoft SQL Server 2008 SSIS Service (July, 2009)rnMicrosoft Project 2007 (July, 2009)rnOracle Database Administrator Certification Training (Five courses) by Oracle rnOracle Developer 2000 Forms by OraclernOracle Developer 2000 Reports by Oracle rnSun Certified System Administrator for the Solaris 8 Operating System (Four courses) by SUN rnrnMacro SystemsrnUNIX Shell Programming by SUN Micro SystemsrnCisco CCNA Training by Cisco rnVeritas Netbackup Training by VeritasrnProject Management Training by Project Management Institute rnrn------------------------------------rnProfessional Membership rnrnFormer member of Project Management Institute.rnMember of Oracle University. rnLOMA ˇV Fellow, Life Management Institute (FLMI) Level I and partial Level II qualified.rn
A job posting is required to contact candidates.
Click here to post a job now.
Cox Business - Field Service Rep
Fiscal Officer/Grants Manager III
Assistant Professor of Allied Health-Full-Time, Tenure-Track-Medical Coding and
Assistant Professor, Business-Full-Time, Tenure-Track-Marple Campus
Fashion Design and Product Development
Online Data Entry & English Typing Work in night shift ( Indian Time)
Looking for something to do at home
Dogpile Web Search (COJ217264)
DES SPACE TRAVELS (COJID218106)
