ac4nw3@r.postjobfree.com VIBHA NARVE KUMARASWAMY Phone: *23975049

SUMMARY

An ambitious computer science graduate seeking a challenging position that needs innovation, creativity & strong problem-solving skills. An effective communicator with excellent relationship building & interpersonal skills and possessing a positive & flexibility oriented attitude.

ACADEMIC QUALIFICATIONS

Masters of Science in Computer Science, California State University, Los Angeles, July 2017, GPA = 3.55/4

Bachelor of Engineering in Computer Science, JSSATE (VTU), June 2015, GPA = 3.5/4

TECHNICAL SKILLS

Tools & Environment: Microsoft SQL Server 2012, SSDT, SSMS, SSIS, SSRS, Visio, Tableau, Power BI, Eclipse, Cygwin, MS Office

Languages: TSQL, C/C++, JAVA, HTML 5, CSS3, SQL, XML

Platform: WINDOWS 7/8, Ubuntu

EXPERIENCE

Drop the Keez, Los Angeles, CA February 2017 – January 2018

Project was to design and maintain an e-commerce solution to capture sales data. This data was converted into actionable intelligence to analyse market trends, identify weakness, and reduce associated cost.

Participated in requirement gathering and daily stand-ups with team members on design and development effort

Designed complex SQL queries involving multiple tables inner and outer joins

Created tables, views, stored procedures, functions, CTEs and indexes to support database and ETL applications

Created ETL strategies to populate the data mart with facts and dimensions utilizing star schema architecture.

Implemented data cleansing operations utilizing transformations in SSIS.

Assisted in implementing error and failure handling in SSIS packages utilizing event handlers and row redirects.

Performed data analysis in a timely manner with Tableau to answer business questions.

Combined data from multiple sources using data blending and created rich visualized dashboards utilizing Tableau desktop.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Designed and developed the most suitable user Interface such as Dashboards, multiple charts types, Trends, custom requests

Tricon Infotech Pvt ltd, Bangalore, India February 2014 - June 2015 Project was to design an end to end ETL process for the implementation of an OLAP data platform on an existing DWH to feed services data. Various reports and dashboards were developed in Tableau to gauge the efficiency of different services and profit analysis.

Designed T-SQL structures to implement business logics with CTEs, loops, dynamic SQL, table variables, temporary tables, and joins to support database applications.

Created strategies for data validation and data verification in staging databases using sql queries

Generated various reports such as drill down, drill through, cascading parameterized reports in SSRS.

Designed and managed the entire ETL framework (such as extraction, transformation, loading) using SSIS

Created master child packages to reduce the complexity of ETL strategy

Implemented data quality and verification utilizing SSIS (such as data viewers, lookup, event handlers, merge and derived column).

Employed donut charts, bar charts, pie charts, bubble charts, trend lines, forecast, to answer business questions with Tableau.

Restricted data for users using Row level security and User Roles in Tableau.

Published and managed the workbooks/reports to Tableau Online and set-up data extracts.

Designed data mapping document per business requirement with help of FRD document

PROJECTS

Lease Management System

Worked with two datasets from kaggle.com and created and a sample database which allows the manager of the apartments to maintain available houses for rent, current tenants, appointment with prospective clients and old resident’s information was developed using SSMS by building relationships and identifying cardinality.

Healthcare Dataset Visualization

Built Dashboards and Stories in Tableau on various aspects such as resource allocation, service distribution, area and Encounter details of the health institution to provide more insights into dataset.

COURSE WORK

Basic Data Descriptors, Statistical Distributions, and Applications to Business Decisions and Data Analysis using Excel which included filtering, pivot tables, macros, VLOOKUPs, advance graphing and charting (Rice University Coursera, Certificate Obtained)

Technical paper presentation on “Security Issues in Peer to Peer Networks” and “Nearest Replica Can Be Farther Than You Think” based on cloud services.

Introduction to Power BI course completion (Udemy).

Contact this candidate