Women's Job List

DBA/ Data Analyst/ Business Analyst Resume


LOG IN OR REGISTER TO CONTACT ME

This button will open the login/register page in a new tab. After logging in, come back to this page and refresh your browser.

Resume:


Jean Chen\\r\\\\r\\n\\r\\n------------------------------------\\r\\nEXPERTISE\\r\\n\\r\\nDatabase Administration, Application Development, System Administration, Data Analysis, Business \\r\\n\\r\\nAnalysis, Project Management.\\r\\n\\r\\n------------------------------------\\r\\nSUMMARY\\r\\n\\r\\n. years in DBA roles, years as IT professional, years programming experience, \\r\\n\\r\\nyears of undergraduate education in Management Information Systems. \\r\\n. Proven track record in supporting IT projects through the full life cycle of development \\r\\n\\r\\nin database, application and system areas. \\r\\n. Subject matter expertise in data architecture of new database systems, data dictionary, \\r\\n\\r\\nSQL programming. \\r\\n. Strong troubleshooting capability and hands-on experience in managing multiple \\r\\n\\r\\nenterprise databases with % uptime and zero data loss.\\r\\n. Extensive exposure to Business Intelligence, Data Warehouse and ETL solutions. \\r\\n. years experience in external and internal consultant roles, excellent client facing \\r\\n\\r\\nand team work skills in large and small end user/IT teams with members of diverse backgrounds.\\r\\n\\r\\nWORK ELIGIBILITY\\r\\n. Candidate does NOT need HB sponsorship or transfer. \\r\\n\\r\\n------------------------------------\\r\\nCERTIFICATONS\\r\\n\\r\\n. Oracle i Certified DBA (OCP)\\r\\n. Oracle i Certified DBA, Oracle Certified DBA\\r\\n. Oracle . Certified DBA\\r\\n. Microsoft Certified Technology Specialist (MCTS) on SQL Server (July, )\\r\\n. SUN Solaris Certified System Administrator (SCSA) \\r\\n\\r\\n------------------------------------\\r\\nTECHNICAL SKILLS\\r\\n\\r\\nRDBMS \\r\\nOracle ., , i, i, g Server with replication, partitioning options as well as management \\r\\n\\r\\nutilities, Oracle Lite (Oracle Database Lite), SQL Server , MS Access\\r\\n\\r\\nApplication Tools and Languages \\r\\nSQL and PL/SQL, UNX shell scripting, Oracle Developer Forms and Reports, SPSS, C, C++, VBA, \\r\\n\\r\\nExcel Marco, MDX. Oracle Application Server Enterprise Edition, Oracle Warehouse Builder, Oracle \\r\\n\\r\\nDiscoverers, BRIO Query, MS Analysis Service, MS SSIS.\\r\\n\\r\\nPackages \\r\\nSQL Navigator, TOAD, Spotlight on Oracle, iWatch, MS Office , Oracle Enterprise Manager, \\r\\n\\r\\nSTATPACK, Veritas Netbackup, Trace Analyzer, TKPROF, Explain Plan, SQL/Plus, DBCA, SQL \\r\\n\\r\\nOptimizer. \\r\\n\\r\\nOperating systems \\r\\nSun Marco Solaris Unix, Windows /NT Servers, Windows //XP/Vista.\\r\\n\\r\\nModeling Tools \\r\\nOracle Enterprise Manager \\r\\n\\r\\nNetwork \\r\\nSQL*Net config V.X, Oracle Names, ODBC\\r\\n\\r\\n\\r\\n------------------------------------\\r\\nPROFESSIONAL EXPERIENCE\\r\\n\\r\\nCompany: Genworth Financial\\r\\nRole: Sr. Data Analyst/ Actuarial Analyst\\r\\nDuration: Sep. to Feb. \\r\\nSoftware/Environment: Oracle Database i and g, SQL Navigator, TOAD, VBA, MS Access, MS \\r\\n\\r\\nExcel, Excel Macro, AXIS, Pivot Table, MS SQL Server \\r\\nOperating System: UNIX, Windows XP, MS Office Suite, Windows Server\\r\\n\\r\\nKey Projects handled at Genworth:\\r\\n\\r\\nClient: Actuaries in valuation team\\r\\nProject Description: The clients were in need of expertise in data transformation to extract, \\r\\n\\r\\ntransform and load data (ETL) from legacy system to new system. \\r\\nResponsibilities: \\r\\n. Migrated expense data, converted Valuation tables and performed policy validations to \\r\\n\\r\\nassist in the roll-out of new Valuation system. \\r\\n. Developed Excel macro using VBA to generate data files in desired format by \\r\\n\\r\\nchannels, products and expense types to upload to new system. \\r\\n. Collected data requirement from business owner and established mapping of existing and \\r\\n\\r\\nnew data format to design VBA scripts. Handled exceptions to mapping rules to ensure data \\r\\n\\r\\naccuracy. \\r\\n. conducted Long Term Care Experience Study in support of Actuarial and Risk users \\r\\n\\r\\ninformation needs.\\r\\n\\r\\nClient: Actuaries in Immediate Annuity (SPIA) business unit\\r\\nProject Description: The clients were seeking an unbiased independent third-party to perform \\r\\n\\r\\ndata cleaning and data integrity improvement activities on policy, customer, claim data and \\r\\n\\r\\nultimately to carry out data-driven business analysis in order to verify the business owner¡¦s \\r\\n\\r\\nactuarial mortality research. \\r\\nResponsibilities: \\r\\n. Clarified data descriptions and column interdependencies, defined client requirements, \\r\\n\\r\\ntranslated business logic to select relevant columns and leave out the irrelevant and built \\r\\n\\r\\ntables in MS Access by importing original data set. \\r\\n. Performed ETL tasks, removed data redundancy, resolved inconsistency, eliminated errors, \\r\\n\\r\\nand worked around data insufficiency.\\r\\n. Acquired external data set containing massive death records, identified key columns for \\r\\n\\r\\nlinkage. \\r\\n. Linked internal data set to external data file to produce list of accounts overdue. \\r\\n. De-normalized tables to create one unified data table, applied business logic to \\r\\n\\r\\npopulate calculated columns, aggregated data on selected data fields and derived desired data \\r\\n\\r\\noutput. \\r\\n. Pulled data to pivot table in MS Excel and manipulated data for analytical purposes. \\r\\n. Dissected existing SQL scripts and modified Access queries adding new analytical \\r\\n\\r\\ndimension.\\r\\n\\r\\n\\r\\nCompany: Capital One Financial Services\\r\\nRole: Sr. Data Analyst / Sr. Operations Analyst\\r\\nDuration: May. to June. \\r\\nSoftware/Environment: Oracle Database i and g, Teradata, SQL Navigator, MS Excel, Pivot \\r\\n\\r\\nTable, \\r\\n MS Access, MS SQL Server \\r\\nOperating System: UNIX, Windows XP, MS Office Suite, Windows Server\\r\\n\\r\\nKey Projects handled at Capital One:\\r\\n\\r\\nClient: Operations Managers and business analysts\\r\\nProject Description: The clients needed a variety of data analyses on both recurring and ad-hoc \\r\\n\\r\\nbasis to maintain day to day operations at call center and to tackle emerging operational \\r\\n\\r\\nproblems. \\r\\nResponsibilities: \\r\\n\\r\\n. Developd and ran SQL scripts against Teradata to verify data accuracy in data migration \\r\\n\\r\\nIT initiative. Designed queries to assess level of data inconsistency and explain source of \\r\\n\\r\\nerrors. \\r\\n. Built SQL scripts to pull values for an array of operational metrics, tracked values \\r\\n\\r\\nmonth by month and designed queries to zero in source of discrepancy. \\r\\n. Populated data to compare actual sales verses forecast numbers and designed queries to \\r\\n\\r\\nperform gap analysis. \\r\\n. Responded to client ad-hoc requests in support of operations improvement initiatives. \\r\\n. Executed data refresh in operational reports to provide an updated view of application, \\r\\n\\r\\ncalls and booking counts and dollars. \\r\\n. Designed and modified forecast spreadsheet to produce sales target and recommended \\r\\n\\r\\nalternatives to solve operational performance variances. \\r\\n\\r\\n\\r\\nCompany: New York Life\\r\\nRole: Database Administrator \\r\\nDuration: April to Aug \\r\\nSoftware/Environment: Oracle i and i, TOAD, iWatch, Oracle Enterprise Manager\\r\\nOperating System: Sun Solaris , Windows XP, Windows \\r\\n\\r\\nKey Projects handled at NYLI:\\r\\n\\r\\nClient: NYL IT partner Infosys\\r\\nProject Description: The IT partner was in need of local hardware and software support to \\r\\n\\r\\ndevelop customized system architecture and to smoothly integrate new and legacy systems. \\r\\nResponsibilities: \\r\\n. Provided Oracle database production support for IT systems and managed pilot run in UNIX \\r\\n\\r\\nand application servers environment to successfully roll out new application systems. \\r\\n. Provided / on-call technical support to Infosys, logged database issues for Oracle \\r\\n\\r\\nmaintenance support, managed Oracle International license for NYL, resolved license issue, \\r\\n\\r\\nsecured on-going support from vendor. \\r\\n. Assisted database installation, database creation, and database backup and recovery. \\r\\n\\r\\nEstablished SQL*Net and set up TNS names enabling data links across databases. Created database \\r\\n\\r\\nalert scripts, monitoring scripts and RMAN backup procedures. \\r\\n. Performed database modeling and design (logical and physical), database migration onto \\r\\n\\r\\nvarious platforms, database upgrade, version control\\r\\n. Executed data load, import and export, automatic distributing, data streaming, cleaning, \\r\\n\\r\\ntesting\\r\\n. Conducted database installation and configuration, scheduling, Database integration, \\r\\n\\r\\nmirroring, Database license management, maintenance contract management. \\r\\n. Configured Veritas disk arrays for data warehouses and created alert system for \\r\\n\\r\\ndetecting bottlenecks. Gathered statistics and wrote UNIX scripts to compress, backup and \\r\\n\\r\\nmaintain the remote databases. \\r\\n. Supported Oracle developers, performed data extract/load in testing environments, \\r\\n\\r\\nrevised data structure as needed, created database stored procedures and integrity checks, set \\r\\n\\r\\nup primary and foreign keys on master and detail tables\\r\\n\\r\\nClient: NYL selected software vendor \\r\\nProject Description: The vendor was in need of technical expertise to overcome system \\r\\n\\r\\nperformance issue in order to launch product on schedule. \\r\\nResponsibilities: \\r\\n. Provided technical leadership to vendor on areas including database, application server, \\r\\n\\r\\nperformance monitoring tools, and internal computer environment. \\r\\n. Devised testing plan, proposed system framework, organized laboratory, secured testing \\r\\n\\r\\nservers to form a testing environment for performance tuning and troubleshooting. \\r\\n. Optimized database performance by identifying performance bottleneck in I/O access and \\r\\n\\r\\nmemory swap and adjusting database and server parameters using Spotlight, TOAD and Oracle \\r\\n\\r\\nEnterprise Manager and STATPACK. \\r\\n. Resolved data locks, monitored data file growth, tuned problematic SQL statements, wrote \\r\\n\\r\\ndatabase triggers, fine tuned performance at table, tablespace and database levels. \\r\\n\\r\\nClient: Accounting department lead and Telemarketing manager\\r\\nProject Description: The clients was in need of upgrading current statistical software package \\r\\n\\r\\nExcel to a more powerful statistical software for the purpose of analyzing accounts and \\r\\n\\r\\nselecting name lists. \\r\\nResponsibilities: \\r\\n. Researched relevant software products available in the market, compared functionality \\r\\n\\r\\nand capability, and short-listed potential solutions for trial. \\r\\n. Introduced Business Intelligence software to client, arranged vendor presentations, \\r\\n\\r\\nprovided technology leadership to assist user experience\\r\\n. Executed and implemented selected software and troubleshoot integration issues \\r\\n. Designed data dictionary and created database objects with SQL Navigator and OEM in data \\r\\n\\r\\nwarehouse environment to meet client request of integrated data access.\\r\\n\\r\\nCompany: Stark Technology\\r\\nRole: Application Developer \\r\\nDuration: Feb to Feb \\r\\nSoftware/Environment: Oracle i and i, BRIO QUERY, Oracle Enterprise Manager, Oracle Developer \\r\\n Forms and Reports\\r\\nOperating System: Sun Solaris, Windows\\r\\n\\r\\nKey Projects handled at Stark Technology:\\r\\n\\r\\nClient: Yu-Lon Automobile Manufacturing \\r\\nProject Description: The client was seeking to customize the supply chain model of Oracle \\r\\n\\r\\nApplication with the assistance of Stark and Oracle. \\r\\nResponsibilities: \\r\\n. Performed Application Server installation and configuration, trouble-shooting, issue \\r\\n\\r\\nlog, System (multi-tiered) management, performance tuning, trouble-shooting, activity tracking, \\r\\n\\r\\nstatus reporting\\r\\n. Conducted requirements gathering, definition and documentation, System and process \\r\\n\\r\\nanalysis, definition and documentation, System architecture and design.\\r\\n. Led System (multi-tiered) security management, Storage system management (Veritas), OLTP \\r\\n\\r\\napplications report design and interface with front-end app.\\r\\n\\r\\nClient: Accounting department and sales department\\r\\nProject Description: The clients were in need of inventory, sales and procurement/purchase MIS \\r\\n\\r\\nsystems for transaction recording and reporting. \\r\\nResponsibilities: \\r\\n. Developed financial accounting reports (monthly, annually, semi-annually, ad-hoc), \\r\\n\\r\\napplication (client-server, web-base) analysis, definition, documentation.\\r\\n. Led application development, testing, integration, version control, trouble-shooting, \\r\\n\\r\\nissue log, launch.\\r\\n. IT hardware and software evaluation and procurement, Internal and external customer \\r\\n\\r\\nsupport, helpdesk, road-show/training, IT personnel training.\\r\\n. Mobile application system administration, web administration, client app installation \\r\\n\\r\\nand data downloading, performance tuning\\r\\n\\r\\nCompany: D-Link Corporation \\r\\nRole: Engineer \\r\\nDuration: July to Jan.\\r\\nSoftware/Environment: Powerhouse, Powerbuilder\\r\\nOperating System: Windows \\r\\n\\r\\nClient: Product line, supply chain\\r\\nProject Description: The client was in need of a report that showed all the materials associated \\r\\n\\r\\nwith a semi-product or a product. \\r\\nResponsibilities:\\r\\n. Designed bill of material (B.O.M.) report for manufacturing.\\r\\n\\r\\n------------------------------------\\r\\nEDUCATION\\r\\n\\r\\nTHE UNIVERSITY OF NORTH CAROLINA AT CHAPEL HIL\\r\\nChapel-Hill, North Carolina\\r\\nMaster of Business Administration in High Technology, \\r\\n\\r\\nNATIONAL CENTRAL UNIVERSITY \\r\\nChung-Li, Taiwan\\r\\nBachelor of Business Administration in Management Information Systems, \\r\\n\\r\\n------------------------------------\\r\\nPROFESSIONAL TRAININGS \\r\\n\\r\\nDesigning and Implementing OLAP Solutions Using Microsoft SQL Server (June, )\\r\\nMicrosoft SQL Server SSIS Service (July, )\\r\\nMicrosoft Project (July, )\\r\\nOracle Database Administrator Certification Training (Five courses) by Oracle \\r\\nOracle Developer Forms by Oracle\\r\\nOracle Developer Reports by Oracle \\r\\nSun Certified System Administrator for the Solaris Operating System (Four courses) by SUN \\r\\n\\r\\nMacro Systems\\r\\nUNIX Shell Programming by SUN Micro Systems\\r\\nCisco CCNA Training by Cisco \\r\\nVeritas Netbackup Training by Veritas\\r\\nProject Management Training by Project Management Institute \\r\\n\\r\\n------------------------------------\\r\\nProfessional Membership \\r\\n\\r\\nFormer member of Project Management Institute.\\r\\nMember of Oracle University. \\r\\nLOMA ¡V Fellow, Life Management Institute (FLMI) Level I and partial Level II qualified.\\r\\n