SNEHA REDDY

973-***-**** adgp5u@r.postjobfree.com *550 St Patrick way #521, Dublin, CA 94568

SUMMARY

oA dynamic and enthusiast IT professional with around 6 years of experience in Data Analysis / Business Analysis with proficiency in appropriate data controls and ability to use breed BI tools for managing complex data, reporting and analysis.

oStrong background with SQL and various RDBMS like SQL Server, Amazon Redshift, Oracle, PostgreSQL etc.

oExcellent T-SQL development skills in writing complex queries involving multiple tables, temporary tables, user defined functions, sub-queries and multi-step queries.

oAbility to implement business needs into technology and familiarity with collecting, and compiling business data, and drafting reports according to business objectives.

oExperience in analysis, modeling, design and development of reports and dashboards for analytics and reporting applications.

oExtensive knowledge in designing and developing customer & stakeholder visualizations using various reporting objects like Table Calculations, Hierarchies, Filters, Calculated Fields, Sets, Groups, Parameters, LOD etc. in Tableau.

oExperience in demonstrating Analytical ability in a results-oriented environment with external customer interaction.

oPossess an Entrepreneurial drive and ability to achieve stretch goals in an innovative and fast-paced environment.

oProficiency creating process documentation, ability to work under pressure while managing competing demands and tight deadlines and well organized with meticulous attention to detail

oStrong interpersonal skills and recognized agile management skills with excellent analytical and problem-solving attitude and an ability to work independently and deliver multiple tasks / projects within a period.

oExperience and expertise in Maintaining User roles, User groups, interactivity permissions, data refresh schedules, workspaces and access in Tableau Server environments.

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

oExperience in building dashboards equipped with Advanced Analytics that can be consumed by both Technical and Non-Technical Users.

oAdept at charting the path from strategy to action, relentlessly curious about cause and effect and have an insatiable appetite for learning that fuels my imagination and passion for delivering business value.

oEquipped with an aptitude for art of problem solving and a structured approach towards Exploratory Data Analysis.

oEvery ready to expose myself to new challenges and diverse roles as I have worked in various departments in Data and Business Analysis, Web development and Project Management.

oSelf-learning ability, Leadership Quality, good team player and determination to learn new technologies and maintain positive relationships at all business levels.

TECHNICAL SKILLS

Reporting

SQL, Tableau, Excel, SSRS, Alteryx, Statistical Techniques, Tableau Prep/Conductor, TabPy, Google Charts

Programming Languages

SQL, Python, HTML5, CSS3, Tabcmd

Databases

MS SQL Server 12/14/17, PostgreSQL, Amazon Redshift, Oracle, MongoDB, My SQL

Methodologies

Agile, Waterfall, Kanban, Sprint Planning

Domain

Automotive, Retail, University, Engineering & Technology, Consumer Services

Interpersonal Skills

Business Requirements Gathering, Good Listener, Presentation skills, Stakeholder Management, Documentation, Time Management and Excellent Communication

Tools

DataGrip, JIRA, Confluence, GitKraken, Git Bash, JetBrains Upsource, Salesforce, MS PowerPoint, Advanced Excel, MS Office, MS Visio, MS Project, Prezi, Outlook, ZOHO One, Trello, AWS Code Commit, Appian

EDUCATION

Southern Methodist University, (M.S. Information Engineering & Management) Dallas, TX

Visvesvaraya Technological University, (Bachelor of Engineering, Electronics), Bangalore, India

GRADUATE COURSEWORK

Analytics for Decision Support, Info System Design Strategies, Information System Architecture, Info Eng. & Global Perspectives, Project Management, Enterprise Fundamentals, Operations Research, Engineering Economics.

ACHIEVEMENTS AND AFFILIATIONS

oParticipated in Data Analytics Competition 2017 hosted by Informs at UT Dallas.

oCertification in Tableau, Data Science and Python Bootcamp.

oWon 2nd place in SAP Techniversity, India’s largest technology event in association with State Government of Karnataka.

EXPERIENCE

CSC ServiceWorks (Tableau Developer/Consultant), Irving, TX Feb 2020 – May 2020

oWorked with the directors and stakeholders to lead the Client Experience Web Portal Project that included integration of Tableau and Appian Technologies. Used methods like Trusted Authentication and Row Level User Security to develop the integration. Built Audit tables and Security Data Role tables to implement user security based on Web Portal User Login.

oRestricted Data for users on Dashboards using Row-level security and User Filters. Generated Context Filters and Data Source Filters to handle huge volumes of data.

oConducted Agile Activities like Daily stand up’s, Sprint Planning, Sprint review, Sprint Retrospective and Poker Planning Sessions.

oAbility to communicate and work effectively with business managers and diverse cross-functional groups.

oCreated and delivered presentations to various business teams regarding the current status and key decisions pertaining to business issues.

oUsed Alteryx for preparing data coming from various flat file sources. Processed the transactions and daily machine utilization for the history data in Alteryx to make it suitable for reporting and performed data cleansing and standardization for adhoc reporting.

oBuilt a Stored Procedure that loaded data into a table which included all the transactions, Commissions, Service Cases and Cycles for the last 13 years and used Full Refresh and Incremental Load Techniques using parameters to improve the performance of the Stored Procedure.

oBuilt Daily Revenue Tracker Dashboard that compares the daily revenue to a projected lift for the FY 21. The report was built to analyze and show revenue lifts based on several user input parameters and LOD which helped in tracking the FY expenses.

oBuilt a SQL Job that loaded all the User Refunds from production tables into Job tables every day, to track the daily User refunds.

oBuilt a Data Validation Report in Tableau that checks Revenue discrepancies for 4 different data feed platforms. This greatly helped in rectifying the underlying logic on base tables and reducing double payments on machines by 10%.

oDeveloped Route Optimization Maps in Tableau to show the source and destination routes taken by each collector in a single day with, different shapes representing people on the map and color-coded paths taken in real-time based on the time and the day.

AutoAlert (Business Intelligence Analyst I), Kansas City, MO Jun 2018 – Feb 2020

oRetrieved and manipulated large datasets through ad hoc requests utilizing Views, CTE’s, Stored Procedures, Functions etc. Extensively built data sources in SQL that could be utilized for developing Business Dashboards in various departments.

oUsed Git Bash and Git Kraken to push final SQL queries into Master Branch for Code Reviews and merge them into the Repository.

oConducted Code Reviews in JetBrains Upsource for the team on SQL Data Sources, to identify potential defects, coordinate system requirements and provide feedback and recommendation to ensure Code Usability and Efficiency.

oDeveloped various Drill-Down Reports, Charts, Salesforce Reports and Interactive Dashboards using Tableau for Data Analysis and developed numerous KPIs resulting in process Improvements and significant business impact generation.

oBuilt Stakeholder Dashboards for our Client Ford and other OEM’s like Honda, Acura and Toyota to conduct Trends and Forecasting analysis on Campaigns, Sales, Operation and Product metrics enhancing Sales Revenue, Customer Retention and Salesperson Productivity.

oDeveloped a Heat Map Calendar for one of our top Dealerships to visualize the highest to the least car sales that happened every day in a month. Also built a drilldown functionality for each day to see what models were sold the most. This analysis paved a way to improve car sales on the least number of days by at least 10%. Extensive Knowledge on reporting concepts like Attributes, Parameters, Hierarchies, Filters, Dropdowns, Viz in Tooltip, LOD, Sets, Groups etc.

oDeveloped Automated processes such as Batch files using Tabcmd to manage data and greatly improve efficiency for non-technical users.

oCollaborated with Senior Management, SME and IT teams to define reporting requirements and designed Project Roadmaps.

oDesigned and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.

oPerformed Tableau Admin duties that comprised configuration, adding users, groups, data connections, scheduling tasks, embedding views in Tableau Server

oBuilt a User-Friendly Tableau Dashboard for the implementation team which showed all the projects deploying at any point of time where each project includes around 200 individual product settings. The goal was to find the projects with non-enabled settings. Worked on Requirements Gathering, conducted meetings with Directors, VP & Executives, built a Project Roadmap and Designed Mockup Sketch which was built into a dashboard, with cell parameter actions and Hamburger menu for dropdowns. This project decreased the Customer Cancellations by 5% within 3 months.

oBuilt Sankey Models to visualize the movement of customers from Used cars to New cars with different Ford models. The Sankey model became the company’s theme to show the movement of customers from one sale type to other like Cash, Retail, Lease cars etc. Developed Dashboards from multiple data sources using Data Blending and fulfilled all the Business requirements despite Secondary Data source restrictions in Tableau.

oImported Data from .rdr file to SQL Server to match sales from the file to the sales in the database and built a complex sales match back model in SQL that accounted for any type of scenarios and combinations.

oMonitoring existing metrics and partnering with internal teams to identify process and system improvement opportunities.

oDesigned and Implemented self-service reporting solutions that enable stakeholders to manage the business and make effective decisions. Produced product and model validations reports to measure the product success, the model soundness, accuracy, and ongoing model performances to the Product Manager as well as both internal and external regulators and auditors.

oBuilt a front-end Sales Commission Model with flexible input capabilities using parameters that can quickly modify calculations and test different scenarios using What-If analysis. It helped the non-technical and non-experts to ask questions and test their own scenarios with the wide effect of quotas, commissions and salaries. Built a Visualization for Dealer Model Acquisition by Market using nested aggregations, LOD functions (to ensure not to count repeat customers as new customers), quick table calculations and Statistical functions like Std, mode, skewness, correlation and covariance.

Affine Labs (Business Intelligence Analyst), Houston, TX Aug 2016 - Apr 2018

oDeveloped and designed various Drill-through, Drill-down, parameterized, linked and sub reports using SSRS, Tableau and created dashboards in HTML and CSS.

oBuilt Monthly Executive Reports in Tableau with Navigating actions and Parameterized Filters.

oWorked closely with the team in meeting the deadlines pertaining to design and development deliverables and created Gantt Charts to manage Milestone Progress. Trained and Mentored other Data Analysts to familiarize the concepts of Database and Reporting.

oOptimized data collection procedures and generated reports on a weekly, monthly and quarterly basis of sales throughout United States.

oBuilt a Campaign Performance Report in Tableau using Maps, Scatter Plots, Tree maps and Box & Whisker plots to measure the success of our Marketing Campaign Engine and conducted forecasting analysis using (Naïve, Linear regression, Time Series & Seasonal Forecasting).

oManaged Portfolio of consultant for Marketing Team by pulling data from various systems, analyzing and delivering data driven opportunities which helped in targeting the right customer and increased the sales by 15%.

oBuilt a dashboard to keep track of the E-mail Marketing Campaigns regularly, monitored customer feedbacks on a weekly basis to provide solutions on improvisation.

oBuilt a Conditionally Color-Coded Chart on Dimensions in Tableau for the Multiple customer answers from survey Monkey for various products.

oBuilt Network Graphs in Tableau to show the hierarchies in Product Purchasing plans. Analyzed Customer Behaviors and patterns for a timeframe by conducting Segmentation and Cohort Analysis using Calculated Fields, Clustering, Groups and Set Actions. This helped in spotting difficult-to-see customer patterns with a high dimensionality.

oExperienced in developing dashboard wireframes and design requirements based on discussions with an understanding of technical and visual design considerations.

oRebuilt, expanded and improved all legacy reports on new reporting platform using Tableau. Replaced data from Excel, CSV and RDR files with optimized and efficient Redshift SQL Queries.

oAnalyzed complex datasets, performed ad-hoc analysis and data manipulation using SQL in stored procedures, views, dynamic SQL, CTEs etc. Created effective Functions, Triggers, Distkeys to facilitate efficient data manipulation and data consistency.

oBuilt a complex logic and Efficient query in SQL that utilized data from around 100 products and was deployed into a Table for the BI system reporting.

oDeveloped DML scripts to Insert, Update and Delete data in SQL Server Management Studio.

oDesigned and built the Investor month-to-date Dashboard on the BI system to provide the status of investor performance in real time. Processed large data sets of portfolios, analyzed the portfolio’s profitability, stability, projection and sensitivity using Excel (PivotTable, VLOOKUP, formulas, Index and Match) and Amazon Redshift (SQL Query) for the Implementation Team.

Southern Methodist University (Technical Analyst), Dallas, TX Jan 2016 - July 2016

oDesigned and developed high level interactive dashboards on Parking Management to monitor the Key performance indicators for operation with real-time parking in the college premises.

oUpdated and Optimized Blackboard Dashboards to display the right metrics for student semester courses.

oExamined International student’s data to provide recommendations for improved Retention rate and Graduation rates. Performed Statistical Analysis in tableau to generate weekly and monthly stats with increased retention rate monthly.

oInterpreted and analyzed data to identify key metrics and transformed raw data into meaningful actionable information.

oCreated Tableau Scorecards, dashboards using stacked charts, bar graphs, scattered plots and geographical maps for analysis.

oAssisted in creating a database management system for the student database. Specified the business rules for the requirement and designed the ER model using MS Visio. Developed ideas and social media content to promote interaction among current and prospective Master students and to encourage involvement on campus.

L&T (Business/Reporting Analyst Intern), Bangalore, India Jan 2014 – June 2015

oWorked with project managers and senior business analysts to determine their needs, gathered and documented requirements using Visio flows, UML designs etc. to build an IoT application.

oModeled a real-life system using Object Oriented Analysis & Design methodology for developing the IoT application. Analyzed the process, data, and behavior models and identified new processes and data flows for the new system that were written into a series of Use Cases, UML, Database designs, ERD & Activity diagrams and Sequence models using VISIO for transforming the logical models into detailed designs.

oDesigned and demonstrated Project Scheduling using MS Project for a Software Application development. Demonstrated Crashing principle for multiple scenarios and varying requirements, implemented Fast tracking scheduling techniques like slack times, early start, critical paths to shorten and optimize the project schedule and, constructed PDM Network Diagrams to define Critical Path and Total Project duration for the plan.

oDeveloped various complex SQL scripts used in PostgreSQL database for data retrieval from various database objects including tables and views. Performed analysis of the given data using SQL / Excel to draw accurate inferences, in accordance with the objectives.

oCollaborated with stakeholder groups across the organization to ensure business and technology alignment, and Proposed solution meeting for defined specification and needs. Used Confluence for Product Life Cycle documentation and JIRA to define daily and weekly tasks for Team Collaboration.

oDeveloped KPIs and various metrics via reporting in SSRS and Excel to allow management to measure and monitor operational performance. Worked with end users and created various test cases and scenarios, generated test plans and test scripts for system and UAT testing.

Contact this candidate