Livecareer-Resume
Jessica Claire
  • Montgomery Street, San Francisco, CA 94105
  • H: (555) 432-1000
  • C:
  • resumesample@example.com
  • Date of Birth:
  • India:
  • :
  • single:
Professional Summary
Two years of experience in business and data analysis data modeling, database management, strategic analysis, requirements gathering, application and decision support.
Skills
  • Financial Industry, Insurance and Retail industry.
  • Hands on experience in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems (Data Marts).
  • Expertise in the latest version of ERwin.
  • Knowledgeable in modeling Kimball and Inmon Data Warehousing environments.
  • Experienced in using SQL/DB2/Oracle/ SQL Server for data analysis and data profiling.
  • Proficient in using Normalizing (1NF, 2NF, 3NF) and De-normalizing techniques for optimum performance in relational and dimensional database environments.
  • Experienced in performing Data Analysis on SQL querying on Oracle, DB Visualizer Pro, MS SQL Server & MS Access and Information Data Quality (IDQ)
  • Working knowledge on creating Dashboards in Tableau.
  • Working knowledge in using 'R'.
  • Skills:
  • Database Modeling Tools
  • Erwin 7.1/7.3/8/8.2/9.5/9.5.2,Rational Rose 2000, MS Visio 2000/2007/2010
  • Databases & Database Tools
  • MS & SQL servers 2000/2005/2008 , Oracle 10g/11g/12c, MS Access 2007/2010/2013, DB2 Visualizer Pro 9.1.2
  • Reporting & Analysis Tools
  • Informatica Developer Quality(IDQ) 9.6.1 , Tableau, Delphi Report Builder, OBIEE, R Studio
  • Web Technologies
  • C#, HTML
  • ETL Tools
  • Informatica Power Center, Datastage
  • Technology
  • NET Framework 4.0, ASP.NET Microsoft Visual Studio 2010/2013
Work History
Data Modeler, 05/2016 - Present
Accenture Trenton, NJ,
  • Experience in working with JD Edwards and performing extensive analysis on the data.
  • Designing Data warehouse for different subject areas.
  • Using Erwin to design physical model for the subject areas.
  • Creating and maintaining Naming standard and source to target documents.
Data Analyst, 06/2015 - 03/2016
The Nielsen Company Oldsmar, FL,
  • Worked closely with the Project Manager in creating the process swim lane and estimates for completion of the technical artifacts needed for development.
  • Participated in requirement analysis and efficient in understanding business requirement documents (BRD) and functional requirement documents (FRD).
  • Working knowledge with IBM Mainframes, DB2 tables, VSAM files and SSRS to migrate from legacy system to distributed environment like SQL Server and HDFS.
  • Worked on source to target Data mappings in excel as well as Informatica Data Quality (IDQ) tool to deliver the application level specific rules to the developers and performed Data Profiling.
  • Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
  • Performed Forward engineering, Reverse engineering, and applied naming standards in Erwin.
  • Worked closely with ETL, Hadoop and SSRS developers to deliver the business rules for them to produce report, flat file or PDF format.
  • Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN Created an enterprise data dictionary and maintained standards documentation.
Data Analyst, 12/2014 - 06/2015
The Nielsen Company Chicago, IL,
  • Involved in requirement gathering and analysis with Business analyst, systems analysts, Developers and DBA and translated them into detailed reporting requirements.
  • Created and maintained Logical Data Model (LDM) and Physical Data Model (PDM) Generated DDL scripts and view on DB2 layers using forward engineering utility.
  • Written SQL Views for UI and Downstream to send data (Both Normalized and de-normalized views) Proficient in model versioning based on the releases on ERwin model mart Developed Data Mapping, Data Governance, and Transformation and cleansing rules as part of transferring the data from source to target.
  • Performed Reverse Engineering for a wide variety of RDBMS including DB2 in order to connect to an existing database and create ER diagrams.
  • Created an enterprise data dictionary and maintained standards documentation.
  • Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment Designed tables and implemented the naming conventions for Logical and Physical Data Models in ERwin r9.5 Conducted performance tuning of the database that included creating indexes, optimizing SQL statements.
Software Developer Intern, 06/2014 - 12/2014
Datawatch Troy, MI,
  • Designed and created Data Views from Oracle and SQL Server databases.
  • Performed analysis using Microsoft Office consisting index matching, v-look-ups, Macros and pivot tables in Excel.
  • Identified data errors and inconsistencies found through data mining activities and analysis.
  • Created reports using Dashboards in Tableau.
Graduate Assistant, 08/2012 - 05/2014
Jefferson Health North Philadelphia, PA,
  • Hands on experience on maintaining SQL Database for EHS department.
  • Performed Data profiling on the chemical Inventory depending on the requirements.
  • Generated reports in Delphi Report Builder using SQL.
  • IT and Computer Network needs.
Education
Master of Science: Systems Science, Expected in May 2014
-
Louisiana State University - Baton Rouge, LA
GPA:
Systems Science
Bachelors of Technology: Information Technology, Expected in May 2012
-
JNTU- HYD - ,
GPA:
Information Technology

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

Disclaimer

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:

76Average

resume Strength

  • Formatting
  • Personalization
  • Strong Summary
  • Target Job

Resume Overview

School Attended

  • Louisiana State University
  • JNTU- HYD

Job Titles Held:

  • Data Modeler
  • Data Analyst
  • Data Analyst
  • Software Developer Intern
  • Graduate Assistant

Degrees

  • Master of Science
  • Bachelors of Technology

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

*As seen in: