BI Develoepr

Sowbhagya Lakshmi Chittajallu

adcl02@r.postjobfree.com, Mobile: 310-***-****

SUMMARY

•7 years of experience in the IT industry. Extensive working experience in Business Intelligence tasks like ETL Design, Developing and Designing dashboards, Data Analysis, Analytics and writing Complex Sql queries.

•5 years of extensive Tableau Experience in Enterprise Environment, in Tableau 8.0 and 8.1 to 2019.2.

•Experience in Tableau creating visuals, building dashboards, and customization to meet needs of end-user.

•Experience with different databases like AWS Redshift, Postgres, Teradata, Google big Query, Sql server, My Sql as data comes from different sources

Experience in Google Analytics, Mix panel, Branch Analytics, Social Media for data analysis.

•Experience in python programming for managing data and streamlining data analysis.

•Excellent knowledge in Data analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

•Sufficient exposure to designing and developing Tableau reports and dashboards for data visualization using R &Tableau.

•REST APIs to retrieve analytics data from different data feeds.

•Working knowledge of Hadoop, MapReduce, Hive, HBase and related big data tools considered an asset

•Involved in Data Extraction, Staging, Targeting Transformation and Loading.

•Expert experience in ETL processes using SSIS (SQL Server Integration Service) programs. Proficient in SSIS project design, implementation and troubleshooting.

•Extensive experience with SQL Server and T-SQL in constructing tables, views, triggers, indexes, functions, stored procedures, user profiles, relational database models, data dictionary, data.

•Experience with software development life cycle (SDLC) and project methodologies

•Extensive software development skills and experience in Object Oriented Analysis and Design.

•Experience in programming with ASP.NET, Web Forms, XML Web Services, C#, Windows Forms, ADO.NET and Python.

•Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS

•Tools: ERWIN4.0, MS Visio, MS Excel, MS Power Point, MS Project

•Languages: C, C++, C#, SQL, Java, python, HTML, VB Script

•Reporting tools: Tableau 10.2, SSRS

•Statistical tools: SPSS, R

•Databases: MS Access: SQL Server 2016, Google Big query, Posgre SQL, MySQL, DB2, Teradata

•Operating Systems: Windows 98/2000/ME/NT/XP, Mac OS, LINUX

•Methodologies: UML, RAD (Rapid application development), Agile, Business and Data Modeling

EDUCATION

•MBA, International Technology University, San Jose, CA

•B-Tech IN COMPUTER SCIENCE, JNTU

EXPERIENCE

INNIT, Redwood city, CA

Jan2019 - Present

BI Analyst

•Working in Data Analytics for various teams like Business development, Marketing, Finance in INNIT

•Design and Data analysis of many dashboards using extensive features of tableau.

•Developed dashboards for different KPI’s like App Conversion & Loyalty, App Usage, Marketing KPI’s, User Funnel for partners like Electrolux, Mars, ICA, Tetrapack, Uncle Bens.

•Developed dashboards for Shopwell App like User Engagement metrics, Web Usage /Engagement, Shopper Engagement metrics represented in various metrics with Maps a filter to see user behavior.

Developed Dashboard for different clients, where users can have access to their dashboards.

Developed Internal reports for marketing to analyze data for the campaign analysis, channels analysis.

Prepared reports that interpret consumer behavior, market opportunities and conditions, marketing results, trends, and investment levels.

Develop dashboards for paid conversions for company from web analytics like CPC, CTR, CPM, Engagement Rate

Create ETL scripts to retrieve data feeds, page metrics from Google analytic services

Wrote many complex Sql stored procedures, queries, views as per dashboard requirements and mostly involved in optimizing Sql queries using industry specific methodologies.

Worked on Google Analytics, Mix panel, Auth0, Branch Analytics for data analysis.

Worked on many databases like AWS Redshift, Postgres, Teradata, Google big Query, Sql server, My Sql as data comes from different sources. Used ETL extensively to blend these data as per requirement.

Worked on python programming to get data from Mix panel to Big query and push to our data warehouse for more analysis in tableau.

Worked in AWS server to load Database using Python scripting language.

Created adhoc reports to users in Tableau by connecting various data sources

Did all Tableau server upgrades, backup, set up various permissions by site, group and project level.

Extensively developed metrics for data analysis to help users to get most out of the data that help them to analyze easily for better results.

Had a lot of enthusiasm for data related events, conferences and news and always keeps up to date on new features and readily implement in work wherever it is needed.

Implemented new features in tableau like Set Actions, parameter actions, transparent sheets, hide show containers etc.

Kaiser Permanente, Pasadena, CA

June 2018- Jan 2019

Data Analyst/Tableau Developer

•Worked in SCPMG Financial Services and build Payroll Benchmarking Tool in Tableau.

•Build Customized and dynamic dashboards where they can calculate FTE values in dashboard.

•Built Customized Tableau Payroll Landing Page with different metrics where they can drill down to different areas & Metrics.

Developed Growth tool & Maps for the business development team where they can see how various center were doing on many KPI’s like Capacity %, Budget requirements, Variance by last year, Patient census by Physician. And also developed maps where users can select radius and point of interest to see how competitors were doing with in the radius.

•Mastered the ability to design and deploy rich Graphic Visualizations with Drill Down and Drop-down menu option and parameters using tableau.

•Involved in creating database objects like tables, views, Procedures, triggers, functions using Microsoft SQL to provide definition, structure and maintain data efficiently.

•Converted existing reports in Excel into Tableau.

•Created different KPI using calculated key figures and parameters.

•Developed Tableau data visualizations using Cross tabs, Heat Maps, Scatterplots, Pie Charts and density charts

•Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend lines, statistics and table calculations

•Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

•Responsible for creating calculated fields, combine field, bins, sets, geocoding and hierarchies using Tableau Desktop.

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

•Wrote complex SQL queries to profile the data received in source files.

•Created stored procedures to get the required data into tableau dashboards.

Environment: Tableau Desktop 10.5, SQL Server 2016, Teradata, MS Access, Excel 365, SSAS, SQL Server Integration Services, Microsoft Visual Studio 2010.

Satellite Healthcare, Redwood, CA

Dec 2014– March 2018

BI Analyst/Tableau Developer

•Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.

•Assisted to build analytic tools to manage data and streamline data analyses using Python and SQL.

•Complex incoming data cleaning and formatting using Python

•Experience in creating different data visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

•Hands on experience in publishing various kinds of interactive data visualizations dashboards and workbooks from Tableau Desktop to Tableau Servers.

•Created Cascading dashboards, data extracts Action filters for better performance of Tableau.

•Used data sources like SQL, Oracle, files to generate reports in Tableau.

•Created many parameters, quick filters, sets and shapes for better navigation in Tableau dashboard

•Performed many presentations to business users on data analysis and dashboard features.

•Created complex table calculations like MoM, YoY, Moving average, Diff from average in tableau

•Implemented swapping measures as a parameter for bars and tables in tableau.

•Connected various data sources like Google analytics, BIG Query, Teradata, Oracle, salesforce, and SQL to Tableau.

•Assisted to build analytic tools to manage data and streamline data analyses using python and SQL.

•Supported technical team members in development of automated processes for data extraction and analysis.

•Participated in learning of techniques for statistical analysis projects, algorithms, and new methods.

•Created adhoc reports to users in Tableau by connecting various data sources.

•Handled Tableau admin activities granting access, managing extracts and Installations.

•Data blending implemented on databases and generated interactive dashboards.

•Published Workbooks by creating user filters so that only appropriate teams can view it.

•Performed Data load management, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data

•Environment: Tableau 10.1, SQL Server 2012, SSIS, SSAS, SSRS2012, Import/Export tools, PL/SQL, SQL Server Agent, T-SQL, SVN source control.

June 2013– Dec 2014

SonicWALL, San Jose, CA

SQL Developer

•Manage the planning and development of design and procedures for metrics reports.

•Develop new reports and delegated tasks to team members.

•Perform market analysis to efficiently achieve objectives.

•Investigate and conducted study on forecasts, demand, and capital for products.

•Published Workbooks by creating user filters so that only appropriate teams can view it.

•Work with customers to define reporting needs and implement Tableau reports to satisfy needs.

•Design and create daily, monthly and ad-hoc reports for BI and Analytics customers.

•Provide recommendations for data presentation within reports/dashboards.

•Support for end users connected to servers in various departments with regard to connection and data access issues.

•Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.

•Implemented Incremental load, used Event Handlers to clean the data from different data sources.

Environment: SQL Server 2008/2012, SSAS, SQL Server Integration Services, Oracle 11g, SQL Server Reporting Services, PL/SQL, Microsoft Visual Studio 2010.

Contact this candidate