Developer Data

Amoolya Buneti

Cell: 908-***-****

E-mail: ******.*@*****.***

Skype Id: amoolyabunetig

SUMMARY

Over 9 years of experience in IT industry as a Tableau developer with extensive knowledge in functional and technical domain of Business Intelligence, creating reports, dashboards through Tableau, identifying trends and processing mapping with strong background in Databases and Data Warehousing concepts.

• Extensive experience of 6 years in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6 through 10.5. Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Development, Testing, Reporting, Go-live/Production and Reconciliation.

• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 10.5.

• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

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

• Experienced in developing rich interactive report, dashboards and other user interface elements integrating various reporting components from multiple sources.

• Created a wide variety of critical analyses including comparisons, trending, forecasting and what-if analysis.

• Exposure to Client Interaction, User requirement Analysis and Support.

• Experience in documenting the whole life cycle of implementation including Development, version control, UAT and Production process using MS-Office 2016 tools including MS-Word, MS Power Point and MS Visio.

• Have been working with various data sources such as Oracle, SQL Server, ODBC and flat file sources.

• Strong SQL Skills related to information retrieval and analysis.

• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.

• Profound knowledge of Data modeling including Star Schema and Snow Flake Dimensional Data modeling, 3NF Normalized Data Modeling. Very good understanding of Logical Modeling and Fine-tuned Physical Data Modeling. TECHNICAL SKILLS

Tools Tableau Desktop 10.1, 9.X/ 8.X/7.X/6.X & 10.5 Tableau Server. Operating Systems Windows XP/2003/2007, Windows Server 2003/2008, UNIX. RDBMS Oracle, SQL Server, Teradata, MS Access.

Languages SQL, PL/SQL, HTML, C, JAVA, VBA.

Productivity Tools MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Jira. Methodologies Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum. EDUCATION: Bachelors in Physical Therapy, 2000-2005 from T.N. M.G.R. Medical University, India. Amoolya Buneti

Cell: 908-***-****

E-mail: ******.*@*****.***

Skype Id: amoolyabunetig

PROFESSIONAL EXPERIENCE

Medaffect. LLC Ft Lauderdale, FL June’ 17-Feb’19

Financial Report writer & Tableau developer

Medaffect is one of the many subsidiaries of Potentis Group, specializing in providing administration and full-service in business management and advisory platforms.

Role and Responsibilities:

• Designed financial statement dashboards-Income statement and Balance sheet dashboard with parameters, sets, complex calculations using “nested LOD expressions”.

• Made two tier drill-down dashboards for the whole enterprise and standalone dashboard under Potentis.

• Built visuals like jitter plots, spark lines, trend charts, with forecasting among others.

• Developed organized version controlling guidelines to be used by the team.

• Dug into interfacing systems and third-party data sources to find hidden flaws, which fixed a lot of data mix-ups.

• Met deadlines beforehand with more than promised features and ease of use.

• Ensured proper root cause analysis is done to fix issues in dashboards.

• Presented an introductory workshop to help new Tableau users with navigation, filters, subscription, bookmarking, downloading data or dashboards.

• Performed data performance checks and worked based on the report generate to reduce laoding time.

• Built a work around to be able to download data from multi-worksheet dashboard and still get all the data in excel. Environment: Tableau server 10.5, Desktop 10.1-10.5, SQL server14, MS Office 2016, One Note. Nationwide Insurance, Columbus, OH Oct ’16-May ‘17 Tableau Developer

Information Risk Management, the Cybersecurity management wing of Nationwide with big team with more than 60 team members with many Lines of business and business solution areas. Role & Responsibilities:

• Designed dashboards from scratch, with quality control metrics, using parameter, calculations and filters.

• Earned a reputation of doing solid ad hoc dashboards and providing them long before the dead line.

• Optimized Risk management dashboards and published onto the Tableau server and share point.

• Designed work flow life cycle of Tableau dashboards (from development to testing production with version control) for the team to use and follow.

• Connected Tableau server and Share point with proper permissions and web connectors.

• Wrote SQL queries and custom SQL queries to deliver data as desired for tableau.

• Good understanding of data warehousing concepts, used efficient functionalities to pull the precise data needed.

• Built neat dashboards on Life cycle, Risk Management using complex calculations.

• Connected to Netezza database to make some ad hoc Dashboards.

• Gathered requirements from LOB leaders, cross functional teams and developed dashboard with ongoing development and support.

• Presented the work books that I build, also the team’s work books to the group of 30 attendees including LOB leaders, end users.

Environment: Tableau server and desktop 9.2, 9.3 and10.1, Netezza, My SQL Server, DBeaver, Aginity, MS Office 2016, MS Visio, One note.

Miami Children’s Hospital, Miami, FL Aug-Oct’16

Amoolya Buneti

Cell: 908-***-****

E-mail: ******.*@*****.***

Skype Id: amoolyabunetig

Data Analyst / Tableau developer

Miami Children’s hospital is a world leader in Pediatric health care. A non-profit organization with 289-bed facility exclusively for children, is considered one of the best in the nation. Role & Responsibilities:

• Worked with interfacing applications to identify changes to the systems and communicate impact of the change to development and support teams.

• Designed and built dashboards and stories using scatterplots, pies, bubbles chart, heat maps, histograms, bullets, Geographical maps, Gantt charts etc.

• Worked extensively with advance analysis actions, trend lines, reference lines, hierarchies, parameters, sets and calculations to create detailed level summary reports and dashboards using KPI.

• Created incremental refreshes for data sources on tableau server.

• Duplicated SAP BO reports to tableau reports.

• Coordinated test environments and test data availability between the systems.

• Created dashboards to communicate test results and monitor key metrics. Teach teams and management how best to understand and use these tools in their daily activities.

• Involved in troubleshooting performance-tuning reports and resolving tableau server and tableau desktop.

• Used functionalities like data extracts, data blending, forecasting, dashboard actions, and table calculations.

• Leveraged data to perform intensive analysis across all areas of our business to drive product development, marketing efficiencies, and growth.

• Presented findings to senior management to drive business decisions. Environment: Tableau server and desktop 9.3, Oracle 11g, Toad, MS office 2013, Jira. PNC Financial Services, Pittsburgh, PA Oct ‘15 – April ‘16 Data Analyst / SQL Developer/Tableau Developer

CCAR (Comprehensive Capital Analysis & Review) and DFAST (Dodd-Frank Act Stress Testing) are regulatory tools the Federal Reserve uses to ensure that financial Institutions have robust capital planning processes and adequate capital. Role & Responsibilities:

• Involved in creation of database schema and maintaining the database.

• Extensively involved in data extraction, loading and cleansing.

• Developed Stored Procedure, functions and Views in SQL Server.

• Designed & created objects in SQL server for aggregated tables which can have great performance with Tableau.

• Performed in depth data analysis to highlight causation of technical problems and incidents created by key customers.

• Handled dimension change requests on Ad-hoc basis.

• Performed in depth data analysis on large volume of structured and unstructured data to find meaningful insights and make process change recommendations.

• Executed all the projects through AGILE methodology.

• Involved in migration of Database from SQL Server to Oracle.

• Worked on schema migrations between Production, Development and UAT environments.

• Provided technical support to business team 24/7. Tableau Developer Responsibilities:

Amoolya Buneti

Cell: 908-***-****

E-mail: ******.*@*****.***

Skype Id: amoolyabunetig

• Involved in building, publishing customized Interactive reports and dashboards, report scheduling using Tableau server.

• Defined relationships, created actions, filters, parameters, data blending, hierarchies, calculated fields, sortings, groupings, live connections, in-memory in both tableau and excel.

• Created database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently.

• Administered user, user groups, workbooks, projects for reports in Tableau.

• Re-created all excel reports to tableau also imported excel data to create reports in tableau.

• Used Advanced Excel analytical functions, e.g., Pivot tables, VLookUp, HLookUp, MATCH, INDEX; tabulating information using multiple criteria such as, COUNTIFs, SUMIF, AVERAGEIF functions.

• Involved in created stored procedures, views, custom SQL queries to import data from SQL server to tableau. Environment: SQL Server 2008, Oracle 11g, Tableau 9.0, Tableau 9.0.3, Microsoft SQL Server Management Studio, Informatica, SSIS, Toad, Windows Server 2008, Unix AIX 7.x Hilton Worldwide, Tysons, VA. Aug’14 – May ’15

Tableau Developer/Data Analyst

Hilton Worldwide has 13 brands across different market segments including Conrad Hotels & Resorts, Canopy by Hilton, Curio – A Collection by Hilton, Hilton Hotels & Resorts, Double Tree by Hilton, Embassy Suites Hotels, Hilton Garden Inn, Hampton Inn, Homewood Suites by Hilton, Home2 Suites by Hilton, Hilton Grand Vacations and Waldorf Astoria Hotels

& Resorts.

Role & Responsibilities:

• Created & modified database functions, procedures for project enhancement & consolidate all into a package.

• Extensively involved in analyzing and implementing the change requests.

• Coordinated with the front-end design team to provide them with the necessary stored package and procedures, and gave necessary insight into the data.

• Worked on several Hilton Finance month end processes.

• Involved in dimension change requests on Ad-hoc basis.

• Updated Entity, Products and Accounts Hierarchies during Month-end close.

• Developed SQL queries using ROW, RANK and DENSE_RANK functions, ANSI SQL for join statements.

• Used TOAD extensively to create and modify procedures, packages, tables, indexes etc. Also used for session info, schema browsing, data importing and exporting from excel files or text files to database.

• Created Accounts dimension hierarchy – dimension change request validation query for verifying the old & new hierarchy data.

• Review/fine tune/re-write SQL queries developed by other team members

• Prepared Test Cases & testing of different pages of financial analysis management system website. Tableau Developer Responsibilities:

• Defined key metrics for executive dashboards and daily stats sheet.

• Embedded Tableau Dashboards on internal sites for corporate display.

• Mentored analytics team on Tableau basics and had sessions with managers on Tableau presentation FAQs with a walkthrough of Executive and Daily Stats dashboards.

• Tested reports and uploaded tableau dashboards on to server.

• Provided production support for tableau users worldwide on 24/7 basis. Environment: Oracle 10g, SQL & PLSQL, Tableau 8.0, Tableau 8.0.13, Tableau 9.0, TOAD 11.1, SQL Developer, Tortoise SVN, EPV Break glass, Subversion., MS Office 2010, 2013. Winn-Marion Inc., Denver, CO

Tableau Developer/Data Analyst Oct ’13 – July ’14

Amoolya Buneti

Cell: 908-***-****

E-mail: ******.*@*****.***

Skype Id: amoolyabunetig

Winn-Marion provides the customers with quality products and innovative solutions properly selected to fit each application every time. The goal of the project was to provide visualization reports to the management for analyzing key performance indicators based on different market segments such as electrical power utilities, oil production and refining indicators, food processing units.

Role & Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.

• Analysed the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.

• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.

• Scheduled the published dashboards from Tableau Server on weekly basis.

• Sending the dashboards to users by emails with the help of admin team with subscriptions.

• Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.

• Built complex formulas in Tableau for various business calculations.

• Resolved various performance issues and analyzed the best process distribution for different projects. Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, UNIX, Toad, MS Office, Visual Studio 2010.

Roho Group, Belleville, IL Oct’12 - Aug ‘13

Tableau Developer

Project was to help the Sales and Marketing Department to make business-related decisions. The project involved developing sales reports and statistics to cover weekly, monthly, quarterly and annual historic information for the sales department.

Role & Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

• Mentored business power users to create reports/dashboards using tableau desktop.

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

• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

• Involved in new KPI generation.

• Data collection and leveraging on data manipulation teams for required data.

• Identify new metrics and enhance the existing KPI's.

• Dashboard Visualization through Tableau BI application.

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

• Created actions, data blending, Hierarchies, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

• Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same using Tableau desktop server. Amoolya Buneti

Cell: 908-***-****

E-mail: ******.*@*****.***

Skype Id: amoolyabunetig

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

• Executed and tested required queries and reports before publishing.

• Converted metric insight reports to tableau reports.

• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.

• Design and development of various reports and dashboards that can be easily accessible through Environment: Tableau (Desktop, Server), Teradata, Sharepoint, Windows, ETL, SQL, PL/SQL, MS Project, MS Office Suite

(Word, Excel, PowerPoint)

Softtech Career Infosystems, Hyderabad, India May ‘11-Sept’12 SQL Server SSRS Developer

Reports involved expenses such as underwriting department, claims department, business department, HR department etc. The reports allowed managers to understand the expenses & help prevent loss by monitoring unnecessary expenditure. Role & Responsibilities:

• Performed Report Testing and Verification as per Internal Reporting system requirements.

• Created calculated member for complex calculation in reports using Business Intelligence.

• Created matrix reports and table formatted reports.

• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.

• Experience in writing custom code expressions in SSRS.

• Used conditional formatting to change the behavior of the report depending upon the requirement.

• Work closely with management and end-users to create and evaluate business requirements.

• Experience in Error handling and debugging coding issues and troubleshoot production problems.

• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level

• Managed off shore team in Report migration project.

• Created Report Models for Business Users to create their own reports.

• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.

• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or other ETL jobs didn’t interfere with each other. Environment: SSRS, Excel, SQL server 2000, T-SQL., Windows Server 2008, MS Excel, VBA. Mindtree, Hyderabad, India

SQL Developer Jan ’10 – Apr ‘11

Mindtree is a global information technology consulting firm specializing in corporate IT services and solutions. The project is to be part of Business intelligence team for the client - Silicon Valley Bank Financial Group and work closely with the Loans/Deposits Operations, Capital Markets, and Trade Finance, Credit reporting business Groups to identify and fulfill their reporting needs.

Role & Responsibilities:

• Involved in analyzing Excel data and creating data model for the application. Amoolya Buneti

Cell: 908-***-****

E-mail: ******.*@*****.***

Skype Id: amoolyabunetig

• Managed a team of 5 members for the development of the project assigned to my team. Used the Waterfall model software development model for the project.

• Created unit test plans to unit test the code prior to the handover process to QA.

• Involved in troubleshooting the production issues and providing production support.

• Involved heavily in writing complex SQL queries based on the given requirements.

• Created new tables and designed the databases. Created new indexes on tables to fasten the database.

• Project life cycle maintenance using ALM tool to track the progress.

• Created Ad-Hoc queries on daily basis to get the data needed by the Management.

• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Environment: SQL Server 2000, SQL Server 2005, Import& Export Data, ER-Win, T-SQL, Excel, Access and Windows 2003, ALM, SSRS.

Contact this candidate