Jessica Claire
  • Montgomery Street, San Francisco, CA 94105
  • H: (555) 432-1000
  • C:
  • Date of Birth:
  • India:
  • :
  • single:
Highly motivated Sales Associate with extensive customer service and sales experience. Outgoing sales professional with track record of driving increased sales, improving buying experience and elevating company profile with target market.
Core Qualifications
  • Expertise in Full project life cycle development for implementation and integration
  • Motivational and co-ordination skills with ability to deliver systems on schedule
  • Analyze and drill data marts for Information Mining
  • Change Management Process for Data Quality
  • Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
  • Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
  • Experienced in development of ETL mapping and scripts. Understand , Debug of ETL jobs, for transforming data , remove duplicates
  • Experienced with Batch systems scheduling and processing.
  • JAD sessions to determine the requirements for Purchase Order Requisition Conceptual Model
  • Experience with large enterprise data warehouse (OLAP) architecture design including logical and physical model development.
  • Data models and enterprise data models.
  • Expertise in extracting and transforming large data-sets; experience with ETL tools like IBM Infosphere Data Stage, SSIS
  • Experienced working with offshore vendors and establishing offshore teams and processes.
  • Demonstrated experience with database technologies (e.g. Oracle, MS SQL Server, Sybase, MySQL).
  • Move data from Oracle to Sybase using Sybase gateway
  • Experience with hybrid cloud platforms, Oracle VM Server
  • Hands-on experience with production reporting and BI platforms
  • Setup Oracle RAC clusters for Production and Non-Production environment
Technical Skills
Oracle 10g, 11g , 12c , Oracle RAC , MSSQL Server 2012, Sybase ASE 12.5 , IBM Infosphere
Professional Experience
Lead Data/Database Architect, 12/1993 - 12/1994
, ,
  • Worked collaboratively with team members using Microsoft Lync / Webex; Led/coordinated meetings between multiple time zones with both on/offshore team members.
  • Provided findings with questions to business analysts for verification; provided metadata such as allowed values, defaults , constraints , domain inconsistencies, data layouts for flat files etc.
  • for reference to data modeling or ETL team.
  • Worked on TXBase ERP software for Inventory Systems at the factory Worked on Shop Floor in understanding the movement of items from bins to factory floor Understand and identify data relationship for inventory of items and automating of Issues/Receipts using scanner software Design and Creation of models for maintaining Product receivables and issues Generation of reports of stock ledger for use by purchase department for ordering of new items Schedule of quotations and Bill of materials for each items Building of large database in Sybase System 10 for inventory and Materials Generation of Purchase Orders from quotations.
  • Design and Creation of tables for each process Change Management Impact analysis of data.
Sr Programmer/Systems Analyst, 11/1988 - 12/1993
NA , ,
  • JAD sessions to determine the requirements for Purchase Order Requisition Conceptual Model Designed Logical and Physical Data Models.
  • Analyzed Source Data to determine what meta-data was to be included in the Logical Data Model Performed data mapping to determine where identified source data belonged in the Data Base.
  • Created Forward Engineered SQL from Case Tool, which was loaded to build and maintain the Data Base.
  • Used Transact SQL to load data into Sybase/MSSql Server to load Source Data into the Data Base Designed tables for Bank reconciliation system , Purchase Order requisition System Identified Attributes , Entities and converted into Physical tables for different account heads related to company Purchase Order Requisition System towards identifying of customers , supplier rates , deviation from scheduled delivery dates.
  • Designed tables related to generation of Max/Min Levels of Inventory in hand for production Reports for cost of total stock in hand Installation of audit trail for the system for changes made and a report to management about date-time of change Enforce data integrity using Primary key , Foreign key and Composite Key Identifying Indexes on tables for optimum data retrieval Residency Status: United Sates Citizen.
Senior Data Technical Solutions Architect, -
, ,
  • Responsibilities at AIG: Provide production support to various Oracle/Sybase/Microsoft database environments across enterprise.
  • Developed Dump/Restore Scripts for Sybase.
  • RMAN backup scripts Hot/Cold backup and Datapump scripts for Oracle.
  • Setup automated alerts for Disk Space monitoring, Database Server Up-time monitoring, thru CA ProNet.
  • Oracle/Sybase security patch updates on database home , when available through scheduled Change Tickets.
  • Autosys job scheduler for scheduling jobs, viz Backup/Dump/Datapump Database Upgrade to Newer versions, in order to maintain support from Software vendor.
  • Work with application teams on upgrade schedule.
  • Setup test servers/database for upgrade testing.
  • Written security stored procedures as required by compliance for password security.
  • Server, query, application performance tuning when there is deterioration in query performance.
  • Reverse engineer physical database to logical models when needed using Powerdesigner/Embarcadero/Er-win as needed for identifying table/data relationship.
  • Schedule time with Unix engineers for SAN migrate of datafiles/databases between storage , if database needs to be migrated to a new host.
Training from IBM in Datastage/Parallel Extender, Infosphere Datastage Training in LDOM , RAC , In-Memory Database from Oracle University Project Management Training towards Certification Masters In Administrative Management - Mumbai University: , Expected in
- ,
  • Coordinated with IBM's Warehouse Migration from Solaris to AIX Enterprise Data-warehouse DBA ( EDW and Re-Insurance Databases ) Data-warehouse Administration 7Tb to 10Tb Experience in building a scalable data warehouse (OLAP) database Database and Data migration between different technologies Proof of concept for Oracle LDOM architecture towards migration of services Compliance tools testing and POC , Imperva for Database compliance SQLServer Database migration to Sqlserver 2014 Logical and Physical Data Modeling ERWIN Performance appraisal during design of project.
  • These include the logical & physical database design covering database objects such as schema, tables, stored procedures, views, triggers, and defaults.
  • Setting up of metric numbers for performance parameters.
  • Reverse engineer from databases ( Sybase/Oracle ) , E_R diagrams.
  • Interaction with Data architects.
  • Estimation of table size & database size, reduce space/CPU utilization.
  • Creation & maintenance of databases for Test, Model, UAT, Production environments.
  • Maintenance of Fact Tables , re-org of large tables, identifying additional partitions Identifying tables which can used for parallelism for faster retrieval of data in a multicore host environment Materialized views setup for consolidation and viewing of data.
  • Identifying and setting of range partitions for large Re-Insurance Oracle tables ( Database size 3TB) Korn Shell Scripts to monitor database/servers.
  • Disk I/O, File system space, process monitoring.
  • Usage of AWK/SED for parsing data Perl numeric/alphanumeric scripting Database Migration expertise Oracle * Sybase * Sqlserver Data transfers using for two-tier and three tier application using ODBC.
  • Data Classification and analysis Hands on ETL jobs to move data from DB2 to Oracle/MSSQL databases.
  • Data consolidation using Data stage as ETL from Mainframe/Oracle/ MSSQL.
  • Enforce Change Management Process for Data Changes in Production MSSQL SQL Server Integration Services to move snapshot data from Mainframe Data provisioning updates, and outstanding issues that affected application and business Migrate Sybase System10 database to Sybase ASE12.
Administrative, Backup, Bank reconciliation, BI, Case Tool, Change Management, CA, data modeling, data warehouse, databases, Data Base, Database, Datastage, delivery, engineer, ERP, Er-win, ETL, gateway, IBM, Inventory, ledger, Management Reporting, Materials, Max, meetings, Memory, MySQL, enterprise, OLAP, Oracle, processes, Project Management, Quality, reporting, Requirement, SAN, scanner, scheduling, servers, Scripts, MS SQL Server, MSSql, SQL, Sybase, tables, Transact SQL, Unix, Upgrade, VM, Written

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy


Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:


resume Strength

  • Personalization
  • Target Job

Resume Overview

School Attended

Job Titles Held:

  • Lead Data/Database Architect
  • Sr Programmer/Systems Analyst
  • Senior Data Technical Solutions Architect


  • Training from IBM in Datastage/Parallel Extender, Infosphere Datastage Training in LDOM , RAC , In-Memory Database from Oracle University Project Management Training towards Certification Masters In Administrative Management - Mumbai University

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: