Jessica Claire
  • Montgomery Street, San Francisco, CA 94105
  • H: (555) 432-1000
  • C:
  • Date of Birth:
  • India:
  • :
  • single:
Career Overview

Business Intelligence Data Architect and Developer with 5 + years experience working with data integrations and migrations in data warehousing environments. I have experience working in all phases of the SDLC

  • Programming and design skills
  • SQL expert
  • Data Modeing
  • ETL Design
  • Database Servers
  • MS Visio, Embarcadero Data Architect
  • Technical Writing
  • Agile development methodologies
  • Requirements analysis and design phases
Technical Skills
Programming SQL 7 Current
Programming T-SQL 5 Current
Programming PL-SQL 2 2011
Database SQL Server 2008 & 2012 7 Current
Database Oracle 10g & SQL Plus 2 2012
Data Modeling Microsoft Visio 7 Current
Data Modeling Embarcadero Data Architect 1 2012
ETL/Application Development Visual Studio 3 Current
ETL SSIS 3 Current
ETL Informatica 1 2011
Ad Hoc & Canned Reports SSRS Report Builder 2 Current
Application Development C# 1 2010
Application Development Java 2011
Application Development JSON 2014
Operating System Unix 2011
NoSQL Mongo DB 2014
Data Analysis/Technical Documentation Redgate 2 Current
Technical Documentation Technical Specifications 7 Current
Work Experience
Senior Consultant, 04/2013 - Current
National Financial Partners Corp. Washington, DC,
  • Contracted to CDC, Atlanta, GA & Cleared for Public Trust
  • Designed and implemented a Data Migration and Archiving Strategy for tables containing 100+ million rows each, using type two slowly changing dimensions, reducing table sizes by 80%, & increasing database performance.
  • Improved communications between client and development team by implementing documentation, creating Data Models (MS Visio), Data Dictionaries (Redgate) & Technical Architecture Documents, & Source to Target Mappings of existing systems
  • Wrote Advanced T-SQL stored procedures, dynamic SQL, SQL Functions, Merge Statements, SQL Pivot Tables, & Table Partitioning
  • Met with CDC directors and data team to determine requirements and business rules for a new reporting portal
  • Performed Data Quality Analysis and Database Reverse Engineering (MS Viso) of Source Databases
  • Analyzed inbound and outbound EDI X12 Interchanges and SAP IDocs to understand transaction types available, as well as data flows, within a Microsoft Biztalk Server for a new reporting portal
  • Created SQL Server Views and SSRS Data Sets for new Reports
  • Created SSIS ETL packages sourcing data from multiple production databases into to data warehouse
  • Production support of existing data warehouse SSIS packages, Stored Procedures, SQL Server Views, and SSRS reports
Data Modeler, 09/2012 - 04/2013
Accenture Contractor Jobs Herndon, VA,
  • Reverse engineered SQL Server, Oracle, & MUMPS Hierarchal databases, to document and understand data structures & lineages (Embarcadero Data Architect)
  • Analyzed source data and source metadata in SQL Server
  • Identified common entities and attributes between disparate source systems and created a common Master Data Enterprise Target Model
  • Designed target architecture and data models for a new enterprise data warehouse and Analytics capability
  • Worked with IT team and managers to understand current state architecture and data flows
  • Worked with business unit directors to determine requirements, reports, current issues, and business rules
  • Researched analytics and key metrics being done in other hospital settings and wrote a Recommendation Paper for business unit Stakeholders
  • Created technical document templates to be used for future project deliverables
  • Implemented best practice methods for a new development shop within a hospital environment
  • Completed Vendor training in Embarcadero ER Studio
  • SQL Server, Oracle, Embarcadero Data Architect, Mumps Hierarchal database, Visio
Software Engineer, 07/2011 - 09/2012
Abbott Laboratories Eaton, OH,
  • Analyzed source data and source metadata from SQL Server and Oracle data marts and cubes, using SSMS to identify data redundancy, quality, shared, and degenerate dimensions
  • Determined data sets to be migrated to a new target SQL Server database and newly designed analytics area
  • Worked with client Directors, Business Analyst, and Data Architects to identify analytics requirements, business rules, and types of slowly changing dimensions needed to capture historical data
  • Created functional and technical design specifications for sign client sign offs and deliverables
  • Designed a migration strategy, source to target mappings, package design, and Audit Balance Control for error handling thresholds, of initial and subsequent data loads, for offshore development teams
  • Mapped data in Informatica PowerCenter 8
  • Worked as point of contact for offshore development teams and participated in weekly meetings remotely with offshore staff to track progress, determine risks and issues, and relayed back to onshore project management team
  • Contributed to RFI by conducting Gap Analysis of current to future state architecture, data architecture, and vendor scoring
  • Mentored junior level staff
  • Planned & organized team/client dinners
  • SQL Server, Oracle, Informatica PowerCenter 8, Viso
Project Engineer, 02/2010 - 07/2011
Drs Technologies Fitchburg, MA,
  • Data analysis in SQL Server and Oracle SQL Developer to determine data quality
  • Analyzed data and metadata from Oracle and SQL Server databases, in order to identify common data attributes across three disparate database systems located in the US, UK, and Singapore
  • Created a common conceptual and normalized logical model of common attributes, and a target data dictionary from disparate sources for a new data store
  • Created source to target mappings from multiple source systems to common target model and documented known data issues
  • Interacted with Business Analyst, end Users, and directors to determine requirements and understand current processes, reporting methods, and source systems
  • Conducted playbacks of analyses to clients for monthly deliverables
  • Attended weekly meetings remotely with offshore teams in India, Singapore and the United Kingdom to document and understand workflow processes and data stored in offshore source systems
  • Mentored junior level staff
  • Planned & organized team outings, & trainings with outside vendors for our consulting analytics and data warehousing group at direction of the PMs
  • SQL Server, Oracle, Teradata, Quest Toad, Embarcadero Rapid SQL, SQL Plus, Informatica PowerCenter 8, Business Objects Universe Designer, Erwin, Visio
IT Administrator, Intern, 09/2009 - 2010
Carestream Ca, CA,
  • Designed and implemented a SQL Server database to be used for personal asset management that would allow clients to track personal art collections on loan between various exhibits and homes.
  • Documented Requirements & Database Attributes
  • Wrote use cases and designed process flows/workflows for application development
  • SQL Server, Visio
Contractor, 09/2007 - 09/2009
Solomon Edwards Group City, STATE,
  • Assisted in the implementation of an insurance claims database, for the purpose of tracking claim trends to determine future premium and budget costs
  • Researched claimant information in an insurance claims system for discrepancies and updated records in the interim Access reporting database
  • Created a process improvement by designing a data model for a SQL Server database to be used by Claims Analyst that would replace redundant and complicated Excel spreadsheets and emails
  • Microsoft Access, Visio, and advanced Excel (vlookups, hlookups, macros)
  • Worked between Accounting and IT during a AR/AP systems integration
  • Served as Point of Contact and lead meetings with Pilot Plant Controllers & staff during an AR/AP systems integration rollout, to explain the purpose & capabilities of the new system, as well as to address any concerns pertaining to implementation roll outs and testing
  • Created weekly & end of month financial reports
  • Researched, tracked & reported on dollar amount variances that exceeded write off thresholds
  • Root cause analysis on AR/AP erroneous auto-matches for IT
  • Determined, reported, and tested Key Performance Indicators (KPI’s) for IT to bring the integrated system up to a 100% auto-match rate during the pilot plant implementation phase
  • Conducted testing & created reports for developers
  • Cognos 8 Query Studio, Excel Pivot Tables, Macros, Advanced Functions
Education and Training
Bachelor of Arts: Art History, Expected in May 1999
Louisiana State University - Baton Rouge, LA

CIS Certificate: Computer Information Systems, Expected in December 2009
Georgia State University - Atlanta, GA

SQL, Database Processing & Design- Course covered relational database design concepts as well as ANSI SQL & T-SQL: data ER modeling, data normalization & deNormalization (Dimensional Modeling), data cardinality, crowsfeet & Microsoft database notation, data integrity, database administration, OLAP, Data Mining, Reporting; Course projects completed using Microsoft SQL Server and Access rdbms; Conceptual, Logical & Physical data models completed in Microsoft Visio

Project Management- Course covered PMBOK, the SDLC, & project management methodologies such as agile and waterfall; Course Projects completed using Microsoft Project; Completed & presented a case study on the Denver Airport Automated Baggage System Implementation Failure

Systems Analysis: Course covered Systems Analysis & the SDLC. Final project presentation & deliverables included Requirements Specification Document including Formal Use Cases, Functional Specification Document, 8 UML Diagrams, which included 3 structural (Class, Object, Package) & 5 Behavioral (Use Case, Activity, Sequence, State Machine, & Communication) created using Rational Rose Software

Account Reconciliation, Accounting, Ad, agile, Analyst, AP, Application Development, AR, Architect, art, asset management, Balance, Billing, billings, billing system, BizTalk, budget, Business Analyst, Business Intelligence, Business Objects, Cognos 8, consulting, client, clients, Customer Service, Data Analysis, data dictionary, data migration, Data Mining, Data Modeling, data warehouse, database administration, databases, Database, data warehousing, designing, dimensions, direction, Drivers, EDI, Erwin, financial reports, Functional, Informatica, insurance, Macros, meetings, Access, Microsoft Access, C#, Microsoft C#, Excel spreadsheets, Excel, Microsoft Project, Microsoft Visio, migration, Modeling, Month end closing, MUMPS, Enterprise, object oriented programming, OLAP, Oracle, Developer, Oracle and SQL, Oracle SQL, package design, Pivot Tables, processes, process improvement, progress, Project Management, quality, Quest, Rational Rose, rdbms, relational database design, reporting, research, RFI, sales reports, SAP, SDLC, Specification, SQL Plus, Microsoft SQL Server, SQL, SQL Server, strategy, Systems Analysis, system analysis, systems integration, Technical Documentation, Teradata, Toad, T-SQL, UML, Visio, Microsoft Visual Studio, Visual Studio, workflow

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

  • Length
  • Personalization
  • Target Job

Resume Overview

School Attended

  • Louisiana State University
  • Georgia State University

Job Titles Held:

  • Senior Consultant
  • Data Modeler
  • Software Engineer
  • Project Engineer
  • IT Administrator, Intern
  • Contractor


  • Bachelor of Arts
  • CIS Certificate

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

*As seen in: