Livecareer-Resume

Data Modeler Data Analyst Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica Claire
Montgomery Street, San Francisco, CA 94105
Home: (555) 432-1000 - Cell: - resumesample@example.com - -
Professional Summary

SWATHI VELDURTHY PROFESSIONAL SUMMARY:

Data Modeler/Analyst with over 5 years of successful experience in Data Modeling, Data Migration, Metadata Management, Fact and Dimensions Tables, Physical and Logical Data Modeling. Recognized consistently for performance excellence and contributions to success in Telecommunications, Finance insurance industries. Strengths in Data-warehousing and Big Data Environment backed by foundation in SQL.

Skills

Erwin Data Modeler 9.64

SQL Server Management Studio 17

Snowflake 3.52.2

AWS Cloud Platform

Talend Solution Environment 7.1

JIRA 8.2

Oracle Database

Oracle SQL Developer 18.2.0183

TOAD Data Modeler 5.2

Microsoft Excel

SQL

SVN

Sharepoint

Tableau

Power BI

Microstrategy

Work History
11/2019 to Current
Data Modeler/ Data Analyst Amazon.Com, Inc. Appling, GA,

Projects: Target: Snowflake DB running on AWS, Sources: AKC, OSI, Eloqua and Google360.

· Analyze Business requirements, procedures, and problems to come up with solution by interacting with Solution Designer. Provide quality documentation, status updates.

· Work as a Data Modeler in Agile Environment and update the existing system files and data models.

· Create conceptual, Logical, physical data models based on the requirements and functional documents using ERWIN tool.

· Create and maintain data architecture, data management conventions and standards, naming and metadata standards

· Deep knowledge on Snowflake for writing SQL queries to design a star schema.

· Involve in defining source to target data mappings (STTM).

· Assist ETL developers while data loading to understand the STTM, handle UAT bugs by coordinating with business team.

· Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.

· Created and altered tables in target Snowflake dev environment and made sure they are deployed in prod environment after getting approval from UAT.

· Sound RDBMS concepts and worked with Snowflake, Oracle, SQL Server Management Studio.

· Give Sprint Demo during Product team meetings.

· Work with Erwin to do reverse engineering of database for reporting purpose.

· Create tables, indexes, views, snap shots, database links extracted from SQL.

· Generate reports from data model. Review the data model with functional and technical team.

· Generate DDL for data model and co-ordinate with DBAs to create database.

· Check to see data models and database are in sync. Assist developers, ETL team, BI team and end users to understand the data model.

SKILLS: Erwin Data Modeler 9.64, SQL Server Management Studio 17, Snowflake 3.52.2, AWS Cloud Platform, Talend Solution Environment 7.1, Jira 8.2, Oracle Database, Oracle SQL Developer 18.2.0183.

03/2016 to 10/2019
Data Modeler/Business Data Analyst Nic Info Tek Inc, AT&T City, STATE,

Projects: MAC, Timewarner Merger

· Hands on experience with end to end data modelling skills, source to target mapping techniques, data flow diagrams using Erwin Diagrams and Visio Diagram.

· Provide analytics and insights in support of the TV & Digital advertising businesses Xandr.

· Operations and support of BI enablement outputs (reports, visualization, data feeds) for Media & Advertising Sales and Operations Customers.

· Participate in Scrum calls as well as sprint planning sessions to support development efforts.

· Experience with industry leading Analytical, Data Processing and Business Intelligence tools and techniques for application in a Big Data environment

· The outputs and data sets are used for campaign planning & post-campaign reporting, which include campaign data, audience data and impression data across multiple data sources.

· Assist in the day to day management, routine maintenance and forecasting of the company’s linear television viewership

· Supporting the team through the execution of reports and analyses for the organization’s various product offerings

· Taking on special projects and ad-hoc SQL queries as needed

· Work with SVN repository tool to check in the data models to review with team, build and deploy.

· Exposure to Data Maturity Model. Used JIRA to plan, monitor and track work.

SKILLS: TOAD Data Modeler 5.2, Oracle 11g, CA Erwin Data Modeler 9.6, Microsoft Excel 2013, SQL, SVN.JIRA

07/2014 to 02/2016
Jr. Software Engineer JNIT Technologies Client : Charter Communications City, STATE,
  • Experience in Entity – Relationship modeling, Object – Relational modeling, Class modeling
  • Telecommunications industry experience, or engaging those businesses as part of data models
  • Designed, modified database objects such as tables, views, indexes, Stored Procedures, defaults, user defined data types and functions.
  • Work experience of SQL related to Oracle using Oracle SQL Developer tool.
  • Review DWH ETL mapping documents
  • Identify/Fix SQL performance issues
  • Support development teams on all misc. needs including: Creating scripts for Dimension tables, assigning key constraints by writing alter statements.
  • Conduct/attend requirements definition meetings with end users and document system/business requirements
  • Understanding of data representation and modeling including XML and related technologies.
Education
Expected in
M.S: Mechanical Engineering
Indiana University Purdue University Indianapolis - Indianapolis, IN
GPA:
GPA: 3.2/4
Expected in
B.S: Mechanical Engineering(Mechatronics)
Jawaharlal Nehru Technological University - Hyderabad,
GPA:
GPA: 3.2/4

By clicking Build Your Own Now, 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:

78Average

Resume Strength

  • Length
  • Personalization
  • Strong Summary
  • Target Job

Resume Overview

School Attended
  • Indiana University Purdue University Indianapolis
  • Jawaharlal Nehru Technological University
Job Titles Held:
  • Data Modeler/ Data Analyst
  • Data Modeler/Business Data Analyst
  • Jr. Software Engineer
Degrees
  • M.S
  • B.S