Data Tableau

Vatsalya Davuluri

Email : ********.***@*****.***

Ph: 424-***-****

PROFESSIONAL SUMMARY:

Around 4 years of experience in design, analysis, development and implementation of various applications using SQL Server and BI tools.

Extensive ETL experience using SSIS for Data Extractions, Tranformations and Loads.

Experience in Architecting Visualization / Analytics using Tableau (both extracted and live connected data sources).

Experience in implementing dash boarding, data visualisations and analytics using Tableau desktop and server.

Experience in building Integration of Tableau with various data sources like SQL Server, Hadoop.

Expert in all areas of SQL Server development including user functions, views, indexes, Stored procedures, functions, triggers, clusteing, T-SQL, relational database models, data dictionaries and data integrity.

Experience in Extracting, Transforming, and Loading data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services.

Expert in creating SSIS packages to manage SQL server database and SQL server objects between instances of SQL server.

Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps using ahow me functionalty.

Strong analytic skills and ability to develop, and implement analytical data models and dashboard and reports using Tableau to enable customers to analyze data and make business decisions.

Ability to handle multiple tasks concurrently and meet the deadlines.

Experience with MS Excel, Ms office.

EDUCATION:

Masters in Computer science July 2019 – Dec 2020

University of Cumberlands.

Masters in Electrical Engineering Jan 2015- Aug 2016

University of South Alabama.

Bachelors in Electronics and Communication Engineering Oct 2010- May 2014

JNTU Kakinada.

CERTIFICATIONS:

Microsoft Certified Professional (MCP) – Sep 2018

Microsoft Certified Solutions Associate (MCSA) – Aug 2019

TECHNICAL SKILLS:

Data Tools : SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Languages : T-SQL, C, C++, Visual Studio

Databases : SQL, MySQL, Oracle Database 10g/11g

BI Tools : Tableau Desktop, Tableau server, Qlik View & Qlik Sense, MS Excel

Appl Web Technologies : HTML, XML, CSS, JavaScript

Operating Systems : Windows, LINUX

Networking : TCP/IP, UDP, IPV4, IPV6, OSPF

Applications : MS Office

PROFESSIONAL EXPERIENCE:

Operations Research Analyst Mar 2018 - Present

Heritage Sierra Medical Group, California.

Involved in requirement gathering, Analysis, Design, Development, Testing of entire portal.

Involved in planning, defining and designing database based on business requirements and provided documentation.

Provide Daily/Weekly/Monthly/Quarterly/Annual reporting to business with data analysis as required.

Work with business partners to gather and develop analytics/reporting requirements and enable Tableau visualizations and workbooks. This work can involve understanding data requirements, creation/modification of database views, as well as development in Tableau.

Provide data extraction, reports, dashboards, and analysis and consultation services across organization for small to mid-sized projects.

Worked on data compilation and writing simple to complex queries involving Joins, correlated sub-queries and functions.

Process ad-hoc data and reporting requests/enhancements, including maintenance of existing reports & dashboards.

Develop macros in MS Excel to dramatically decrease turnaround time and increase reporting efficiency.

Conduct performance tuning for Tableau and SQL views.

Designed, generated reports in MS SQL Server Environment to support the operations across the health care.

Collecting, compiling analyzing and reporting trends. Technical expertise & design for various Analytics projects.

Designs, creates, tests and maintains a portfolio of dashboards, reports, and scorecards in Tableau.

Supporting staff with problem identification and resolution.

Developing and maintaining systems to support analysis and reporting for corporate projects.

Researching and recommending operational enhancement which lead to efficiency and potential cost savings.

Design and automate data extraction from organization database and other sources to produce financial and operational reports in efforts to facilitate management review of key performance indicators, including accessibility, productivity, quality measures.

Conducting research, audits and data analysis.

Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into database using SSIS Packages.

Understanding of HIPAA and CMS Guidelines for privacy and security of data.

Lorhan corporation Inc, New Jersey Dec 2017 - Mar 2018

Software Trainee

Developed application code, unit and integration testing.

Involved in all facets of the Software Developmemt Life Cycle (SDLC).

Used SDLC concepts including performing analysis, testing and implementation of new applications, modules and features.

Maintained documentation that supports system configuration, training and user experience.

Suthra Technologies Inc, New Jersey July 2017 - Dec 2017

Systems Administrator

Worked on operating systems, Network and security and also computing dealing with Linux and windows servers.

Involved in installing, upgrading and removing software, configuring and troubleshooting of network connections and deploying of application.

Involved in different phases of Software Development Life Cycle (SDLC) which helps in knowing end to end applications.

Orabase Solutions, Texas Nov 2016 - July 2017

Systems Administrator

Trained across multiple departments on network operations including Network management software, login procedures, Printing issues, permissions, Security and use of software.

ACADEMIC PROJECTS:

Library Management System:

In this project used the Entity-Relationship model to design a database that will store and organize the library’s data.

Created the database using SQL server and populated it with some sample data tables.

The system can keep the track of library cards, customers, librarians, library locations, books, videos and the relationships between them.

Using java server pages, servlets, and JDBC we have created an internet based graphical user interface that allows customers and librarians to access the system remotely.

Design of Single and Multi Cycle CPU Architecture Jaggy:

The design is based on the existing 32-bit processor architecture MIPS but, designed in a way using different length of instruction field, Instruction and data memory sizes.

Designed and verified MIPS 32-bit Processor to support 7-Rtype, 5-Itype and 2-Jtype instructions.

Created data path of the design, and generated FSM for the main controller.

Programmed modules like register File, instruction memory, data memory, 16-bit shifter, ALU, multiplexers, and controller in VHDL and verified each individual module separately and also combined as one.

Simulating each module prior to RTL development for verifying functional correctness.

Developed an RTL code of three building blocks like ALU, cache memory and multiplexers.

Mars Simulator:

The simulator is basically a lightweight interactive development environment for programming in MIPS assembly language and is best described as a pop-up application that observes MIPS memory and/or register activity during MIPS program execution then communicates that activity to the tool user to serve a particular purpose.

Done a lot of low level programming most of them using fewer numbers of instructions.

Worked on few typical example problems at high-level and converting them into low level MIPS assembly language to see the data moments between various registers and memory.

Encryption and Decryption of Message:

Worked on Algorithm and Develop Cryptographic program to Encipher and Decipher any Message using C.

Worked on the design of the algorithms based on requirements.

Developed a code using C, Where C code encrypts the written data.

Contact this candidate