Conducted analysis on various tools available at the client to recommend the best possible option for different project, for example Informatica Data Explorer, Informatica Data Quality, Power centre, Micro strategy, etc.

Prepared BI Interactive Dashboards using calculations, parameters in Tableau.

Expertise in connecting to Oracle and SQL databases and troubleshooting.

Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.

Creation of Jobs and scheduling of flows through Management Console.

Used excel sheet, flat files, CSV files to generated Tableau Ad-hoc reports.

Creation of ER diagrams and database design for the project.

Data Analyst

Shivangi Gupta

SUMMARY

3+ years of IT experience in the field of Data analysis and Data Modeling.

Highly proficient in Agile, Test Driven, Iterative, Scrum and Waterfall, Software Development Life Cycle (SDLC).

Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.

Very good experience in Integration and design of complex OLTP database models using ER diagrams and handling performance issues of the OLTP databases.

Experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau and other BI technologies like Teradata etc.

Performed Data cleansing and Data profiling for detecting and correcting inaccurate data from the databases and to track data quality and to assess the risk involved in integrating data for new applications.

Good Knowledge in writing, for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.

Experienced in Writing PL/SQL, ETL routines in Data warehousing applications Involved in database design and Data modeling.

Experienced in creating filters, quick filters, data source filters global filters, context filters, user filters, actions and creating Dashboards for key performance indicators (KPI).

Proficient in extracting, transforming and loading data from various data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by Informatica/SSIS.

Extensively used ERwin Repository to provide rich support for model version management and designed to allow organizations to easily manage all successive states of models and Implemented Security Management by defining Users and inheriting permissions by providing roles.

Experience in using Eclipse, PyCharm, Visual Studio, PyScripter and Sublime Text while developing different application in python.

Designed and implemented large scale business critical systems using Object oriented design and Programming concepts using Python and Django.

Excellent communication and interpersonal skills, good analytical reasoning and ability to learn quickly, high adaptability to new technologies and tools.

Possess excellent communication, interpersonal and analytical skills along with positive attitude.

SDLC, Agile, Scrum, Waterfall, Erwin, Iterative, Tableau, SQL, PL/SQL, SQL Server, Oracle, MS Access, MySQL, MongoDB, PostgreSQL, MATLAB, Informatica, SSIS, SSRS, Python, Eclipse, Visual Studio, Pyscripter, Sublime Text, Django, JIRA, REST API, Git, OWASP, Windows, Linux

M.S. in Computer Engineering,

San Jose State University, CA

SKILLS

EDUCATION

EXPERIENCE

Huntington, CA

JAN 2019 – CURRENT

Data Analyst

Roles and Responsibilities:

Performed data profiling in the source systems that are required for RML System.

Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.

Built multifunction readmission reports using python pandas and Django frame work.

Responsible for defining the key identifiers for each mapping/interface.

Reverse engineered all the Source Database's using Erwin.

Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.

Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.

Independently organize the project, analyse the data and develop the detailed reports, dashboard and scorecards by Tableau.

Extract data from different systems, design and develop ETL processes for loading data into the data warehouse utilizing SSIS.

Built Tableau visualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Teradata, Oracle, SQL Server).

Worked on development of SQL and stored procedures on MYSQL.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Extracted the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau.

Developed Python modules to extract data from MYSQL database.

Responsible for debugging the project monitored on JIRA (Agile).

Metasystem, India

JAN 2015 – JUN 2017

Data Analyst

Roles and Responsibilities:

Create and enhance Technical Specification Document TSD and Customer Requirement Document CRD through constant interaction with Manager and Tech Lead.

Created data model with required fact and dimensions.

Create and Maintain Teradata Databases, Users, Tables, Views, Macros, Triggers and Stored Procedures.

Importing and Exporting Data from Access Database and building SQL Queries for data manipulation Reporting in Access and VLOOKUP in Excel.

Created and updated Crystal Reports to client specifications using SQL.

Developed a database in MySQL to manipulate data with monthly updates and created reports in Crystal Reports.

Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.

Effectively used data blending feature in tableau to connect different databases like Oracle, MS SQL Server.

Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends at various geographic locations.

Contact this candidate