Kavya Sri Email & Phone Number

Winter Garden, Fl, Us

Sunnyvale, Ca, Us

New York, Ny, Us

• Only Alteryx developer in the team to automate Revenue and Expense teams manual process in calculating accrue amount, preparing journal entry.• Collaborating with Organizational Finance strategic teams and managers to automate their existing manual processes by building workflows using Alteryx tool.• Worked directly with Vice President and Director of Reporting and Analytics at S& P.• Worked with the team to automate the manual process with various excel worksheets through Alteryx by improving their work efficiency and optimization.• The automated workflow is presented to the respective team member for their approval and testing.• Creating and publishing Alteryx workflows, Apps, macros to automate data processing tasks and improve efficiency in Alteryx server.• Write monthly data from various sources like Zinvoice, Revenue Report for different vendors to database through ODBC connection.• Write and read data from database tables through ODBC connection by writing queries on tables using join.• Use Alteryx Server to publish, share, schedule and execute the workflows.• Identify the changes to be done to existing Alteryx workflows and modify it as per the Financial Accounting team need.• Use the Alteryx output as input for creating Tableau dashboards by connecting to SQL to demonstrate the QOQ and YOY changes for the Revenue, expenses.• Perform rigorous data quality checks and validation to ensure data accuracy and consistency in Alteryx workflows.• Maintain detailed documentation of advanced Alteryx workflows, processes, and best practices.• Provide advanced training and support to Finance team on using Alteryx for data analysis and reporting in month-end financial closure.

Denver, Co, Us

• Worked in all phases of Data workflow life cycles including analysis, design and development. • Worked as a team lead and helped team to understand business processes, technical and business requirements.• Hands-on skills and experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Predictive, Parsing, and Transforms• Imported data from multiple sources by writing SQL queries to fetch the required data from the source.• The SQL queried data is used for Alteryx workflows as input. • Developed Tableau reports for Davita Clinics on the patient in-flow, lab results, treatment details and created different Dashboards which are used by different users on Daily, Weekly and Monthly basis.• Worked on highlight tables, maps, pie-charts indicating the Reporting Rate, visit duration, waiting time, Average visits by day and month.• Worked on multiple projects in Alteryx by creating workflows, Report design & development.• Have experience on usage of different Tools like In/output tools, Preparation, Parse, Join, Transform, Reporting, Spatial and Predictive R tools while creating workflow and publishing to Alteryx Gallery.• Experience in building Analytic App using interface tools with Check box, Text box, List box, Radio button, Drop Down, File browse and Action tool.• Export the workflow as a Package to be used for downstream applications.• Expert in scheduling and monitoring workflows to push to Alteryx Gallery.• Have hands-on knowledge on Macros used as a tool in another workflow process.• Provide the Alteryx workflow to Tableau Data Extract file (.TDE) as a source for tableau reporting.• Hands on Experience in development of Reports and Dashboard in Tableau.• Experience in creating Tableau dashboards & maintain, enhance, and modify existing reports and dashboards based on business requirements.• Merge multiple data sources by joining multiple tables and using Data Blending

New York, New York, Us

• Involved in end-to-end implementation and enhancements on Mobile Banking App data starting from requirement gathering to dashboards development in Tableau Desktop.• Tableau dashboard development with knowledge on parameters, actions, filters, LOD and complex calculations.• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.• Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel ,CSV files and Oracle Database.• Developed Geo/Area maps to show details on which states are most connected using the App vs the least states.• Created Bar Charts which is compiled with data sets ,added trend lines and forecasting on future usage of the Mobile App.• Created Cross tabs to display underlying data based on various graphs and charts created for further data analysis.• Compiled interactive dashboards in Tableau desktop and published them to Tableau server which allows story telling behind the Mobile app usage with quick filters for on demand needed information.• Performed data analysis on daily, weekly, monthly scheduled refresh of data based on the business that has happened to ensure that the developed dashboards are displaying accurate and up-to-date data. • Participated in weekly meetings, reviews, user group meetings.• Excellent in communicating with stakeholders and business groups.

Us

• Excellent hands-on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using Alteryx.• Experience in developing pie-chart, heat-map, scatter plots, highlight tables on distribution of member BMI data, age brackets, relation of different variables.• Developed interactive dashboards using filters, highlighters.• Combined reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users. • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information. • Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives using advance Tableau functionalities like Actions, Parameters, Groups, Background Images, Context filters. • Experience in dealing with various databases like Oracle, SAS datasets, MS Access, and Flat files.• Experience to Create workflow for Data Extraction, Transformation and Data Transfer to SAS team.• Experience in filtering age, plan, state, BMI, insurance data based on SAS team daily request.• Experience in generating daily reports showing the number of members, risk category, biometrics.• Researched data discrepancies and took corrective action hence improving performance and decision making.• Experience in generating warning email to upstream when huge erroneous data is received.• Expert in generating on-demand and scheduled reports in Alteryx for business analysis or management decision. • Ensure application stability and performance by monitoring existing workflows to ensure they are working correctly and that they reconcile with the source.• Worked in partnership with stakeholders and other IT teams concerning the accuracy of data and efficiency of processes.

Detroit, Michigan, Us

• Gathering, Understanding and documenting business requirements.• Conducted Requirements walk-through session to the team.• Designing, developing workflows in Alteryx and preparing report of the distance to be travelled from warehouse, how many products can be fulfilled in different retail locations.• Developed story telling dashboards in Tableau Desktop and published them to Tableau Server which allowed end users to understand the data using interactive features.• Experience in calculating distances showing the Cardinal Direction, Direction in Degrees and Drivetime from given Spatial points.• Experience in finding nearest destination from the warehouse.• Designing, developing dashboards in identifying warehouses based on monthly turnovers to find the prime warehouses.• Experience in creating parameters, groups and sets in identifying warehouses with high revenue and less expenses.• Designing, developing dashboards in identifying warehouses based on monthly turnovers to find the prime warehouses.• Experience in creating parameters, groups and sets in identifying warehouses with high revenue and less expenses.• Experience in using Spatial Match, Spatial Process tools.• Experience in rendering the Report including Report Map.• Have hands-on knowledge on Generalize, Smooth, Poly-Build, Poly-Split tools.• Mentoring junior developers and collaborating with peers with a goal of continuous improvement.• Responsible for management of change requests, updates to rule logic and release management.• Provided project report to business users and top management.

Meridian, Id, Us

Wilmington, De, Us

Bangalore, In

Masters, M.B.A

B.Tech, Electronics And Communications Engineering