Sowmya Kothapalli

719-***-****)

ac36bj@r.postjobfree.com

https://www.linkedin.com/in/sowmya-kothapalli-31774752/

EXECUTIVE SUMMARY

Around8 years of experience in Software Design, Development, Integration. Implementation and Maintenance of Business Intelligence and Database Platforms.

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator. Worked extensively on data visualizations by designing, developing and deploying of Tableau dashboards on Tableau server.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau/Qlikview and SSRS. Proficient with Microsoft BI stack (SSRS,SSAS, SSIS).

Proficient in design and development of various dashboards, reports utilizing Tableau visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.

Extensive experience working as a Business Intelligence Analyst with specialization in Cognos, SSRS.

Extensive experience working in Windows, UNIX, LINUX environments.

Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.

Extensive experience in PL/SQL and SQL. Strong working knowledge of SQL including the ability to write complex SQL queries.

Worked extensively on Erwin in several projects in both OLAP and OLTP applications.

Working experience inAgile and Waterfall Methodologies preferred.

Good working knowledge on Power BI.

Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.

Experience in understanding existing business processes, gathering business systems requirements analysis and design; thereby converting requirements into detailed reports for strategic decision making.

Implemented Web Technologies to customize the reporting environment in order to organize and visualize Business Metrics and KPIs into logical sets of dashboards and data visualizations.

Good knowledge on PHP, Java and Python.Hands on Microsoft Azure Application and Web Development.

Effective in working independently and collaboratively in teams with excellent communication and written skills with exemplary analytical and problem solving skills.

TECHNICAL SKILLS

Scripting Languages : HTML5, CSS3, JavaScript

Databases : MS SQL server 2008/2012, PL/SQL, Oracle.

Development Tools : Visual Studio 2010/2012/2013, Eclipse, Notepad++.

Editing Tools : Adobe Photoshop, Adobe Muse/Illustrator, WordPress, Azure

Programming Languages :C++, C, Java, PL/SQL

BI/Visualization Tools : Tableau Desktop 8.1/9/10, Tableau Server 9.x/10,SQL BI SSAS, SSRS, Cognos(EDW)

PROFESSIONAL SUMMARY

inDinero, San Diego, CA Oct 2017- Present

Data Analyst

inDinero’s founder-friendly software brings your finances together so their client can manage them from anywhere via a web-based interface. They can get a snapshot of their company’s financial health, review key financials, and see value & cost centers at a glance.

Responsibilities:

Understand the Requirements and Functionality of the application from specifications.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.

Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

Converted existing BO reports to tableau dashboards

Created different KPI using calculated key figures and parameters

Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's

Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

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

Utilized Tableau server to publish and share the reports with the business users.

Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.

Environment: Excel/Tableau 9/10, Oracle SQL developer 4.1.5, MS SQL Server 2008, IBM Cognos

Thermo Fisher Scientifc, Carlsbad, CA Mar 2017-Aug 2017

Marketing Automation developer

Thermo Fisher Scientific is an American multinational, biotechnology product development company, created in 2006 by the merger of Thermo Electron and Fisher Scientific. Thermo Fisher Scientific is dedicated to improving the human condition through systems, consumables, and services for researchers.

Responsibilities:

Involved in reviewing business requirements and analyzing data sources form Excel/Oracle Server for design, development, testing of reporting and analysis projects within Tableau Desktop.

Development of ad-hoc data visualizations for analytical efforts for the marketing and predictive anlytics team.

Worked with Business users, Analysts, Team Lead and Functional Analysts to identify process improving opportunities in data analytics and data modeling.

Implementing new advancements and enhancements to translate data into visualizations.

Developed multiple SQL statements for exceptions management to exclude accounts based on complex business logic. The SQL statements were run in a batch using UNIX scripts.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.

Developed complex SQL queries with multiple tables for database solutions.

Prepared sample code and applications for displaying various outcomes of API applications using PHP. Resolved technical problems relating to API application by identification and fixing bugs with adobe API explorer.

Have working knowledge on HTML and JavaScript and ability to implement those technologies in Cognosreports. Worked on Report studio, Cognos Connection.

Extracted data using python from files with different formats depending on the source origin when required. Used python was incombination with data mining for further analysis

Had hands-on experience with Informatica ETL tools.Used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup.

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

Effectively used data blending feature in tableau.

Imported and exported data from saved queries; used automatic outlining, inserted subtotals, created advanced filters, and used database functions. Created pivot tables and Vlookupcharts using excel, modified pivot tables, and refreshed and formatted pivot tables for Marketing and Predictive teams.

Utilized Jira bug tracking system to keep track of any defect, report to developer team and perform Regression Testing

Environment:HTML/CSS, JS, Photoshop, Bootstrap, CodeIgniter 3.1.4, Excel/Tableau 9/10, Oracle SQL developer 4.1.5, IBM Cognos

Solar Turbines, San Diego, CA June 2016 – Feb 2017

BI developer

Solar Turbines Incorporated, a wholly owned subsidiary of Caterpillar Inc., designs and manufactures industrial gas turbines for onshore and offshore electrical power generation, for marine propulsion.

Responsibilities:

Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop..

Converted charts into Crosstabs for further underlying data analysis in MS Excel.

Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Performed analytical procedures on expected or unexpected variances in account balances or classes of transactions.

Worked at conceptual/logical/physical data model level using Erwin according to requirements. Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.

Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, charts, master-detail, maps, various calculations and joins using tabular sets and models. Involved in writing Complex SQL queries to improve the performance of the report.

Experience in writing SQL, PL/SQL, Stored procedures, Functions, Triggers as per the business needs.

Created queries in Oracle SQL developer data source for use in Report studio and Query Studio.

Created pivot tables and Vlookupcharts using excel, modified pivot tables, and refreshed and formatted pivot tables for Marketing and Predictive teams.

Utilized Jira bug tracking system to keep track of any defect, report to developer team and perform Regression Testing

Environment:Adobe Photoshop, Excel/Tableau 9.1, Oracle SQL developer 4.1.5, IBM Cognos

Earth7 Consulting, IN Feb 2015- May 2016

Data Analyst

Earth7 consulting helps small businesses with marketing and website modification. Earth7 consulting is one-stop shop all for small business needs.

Responsibilities:

Performed daily checks on file deliverables to the clients, investigate discrepancies and ensure daily resolution of identified queries

Presenting accounts receivable payment and trend analysis to management committee to recommend strategic plans to increase revenue.Streamlined billing and operations processes to increase payment efficiency.

Created physical and logical models using Erwin to effectively translate conceptual model into logical and physical models conforming to the business and data requirements.

Gathered user requirements, analyzed and designed software solution based on the requirements.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created worksheets and dashboards by using custom queries and multiple tables.

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

Effectively used data blending feature in tableau.

Defined best practices for Tableau report development.

Administered user, user groups, and scheduled instances for reports in Tableau.

Executed and tested required queries and reports before publishing.

Developed complex queries using Oracle SQL developer.

Gathered information and requirements and converted them to User/Functional Requirement Specifications for the designers and developers to understand.

Worked extensively with Microsoft Office Suite (Word, Excel, PowerPoint and Outlook)

Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio

Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

Environment:HTML/CSS, JS, Bootstrap, Excel/Tableau 8.1, Oracle SQL developer 4.1.5, MS Office Suite

Avea Solutions Jan 2013 – Nov 2014

Portland, Or

BI developer

Description: AveaOffice tracks revenue, optimizes performance, and manages operations like no other software platform on the market, allowing staff to spend less time on billing issues and more growing your business.

Responsibilities:

Analyzed contracts to ensure contract and invoicing are in compliance with appropriate guidelines, and regulations.

Identified any issues that may affect billing and determined the proper course of action.

Followed up with internal and external personnel regarding outstanding issues.

Completed monthly reconciliation analysis to report income projections to management.

Performed general administrative duties including filing, photocopying, typing and maintaining databases.

Converted and tested three separate billing systems

Developed Quantity and Quality Access Database check system that reduced the error rate from 10% to less than 1%

Assisted Accounting with month end reports

Environment: SSRS, SSAS, Teradata, MS SQL Server 2012, SAS, Javascript API, Agile/ Scrum, UNIX / Linux.

Anglian Waters / Capgemini India Pvt. Ltd June 2010- Dec 2012

Bangalore, India

Software Developer

Description: AWS supply water and water recycling services to more than six million domestic and business customers in the east of England. They borrow water from the environment, store it and treat it to world-class standards to supply safe drinking water.

Responsibilities:

Involved in Creation of Cognos 8 Reports, Dashboard Reports.

Created Complex Reports using Report studio, Plugged Prompts, Drill through Master- Detail Reports.

Built Framework Manager Models and published the various packages to the Report net server.

Created DMR data models and Published Packages using Framework Manager according to needs.

Created Cognos Cubes and use it in Framework Packages.

Experienced with trouble shooting and optimizing Report performance.

Customized data by adding filters at both the Framework level and Report level.

Created organized and formatted reports, folders and other contents on Cognos Connection Portal.

Involved in part of ETL Process for loading the data and by designing catalogs and supporting ETL Process

Customized data by adding Filters Calculations, Prompts, Summaries and Functions.

Applied three levels of security to the model (Data, Object and Package).

Applying Row and Object level security to Reports.

Performed Admin task for user permissions, scheduling the reports.

Performed Report Administrator to give set of permissions to the end user.

Environment: Tableau 8.1, Oracle, Teradata, MS SQL Server, SAS, Javascript API, Tableau Server, Agile/ Scrum, UNIX / Linux.

EDUCATION

Master’s in Computer science, Indiana State University, Indiana, USA.

Bachelor of Technology in Information Technology, J.N.T.University, India.

Contact this candidate