Pavithra Shetty Summary Customer-oriented Principal Consultant knowledgeable developing implementing successful business solutions drive productivity growth. Offering expertise SQL, Data Visualization, Scripting language 6 years experience software industry. Experience Principal Consultant Company Name City State June 2018 Current Design, Develop, Test Document Business Intelligence reports: Gather Business needs develop interactive dashboards BI reports. Work Data warehouse data sources get data Data Visualization Using Business Intelligence Tool. Write SQL Queries Stored procedures pull data Visualization Tool. Modeling data efficiently pull data visualization Design Dashboard Provide insights management departments make Data driven decisions. Embed BI reports Customer Application using .NET Framework, JavaScript. Which uses Web APIs access BI reports. Create Peer review SQL queries ad hoc data reporting. Managed junior developer delivering consistent coaching constructive feedback. Design, Develop, Test Document SQL Queries, Stored Procedures, .NET Codes order maintain add features Student Information System. Communicate clients gather requirement new data collection change request. Design data model web interface collecting new data improve existing system. Peer review codes validate correctness integrity system. Perform Unit test, Integration test Regression test Development QA environment Build Release. Follow Agile Methodology software development using Azure DevOps better utilization time resources. Create SQL queries ad hoc data reporting. Support end users resolving technical issues. Business Intelligence Developer Company Name City State September 2015 May 2018 Designing, developing, validating, documenting SQL queries, graphical reports, dashboards, data warehouse applications support strategic initiatives. Reviewed project requirements identify customer expectations resources needed meet goals. Conceived, developed implemented wide range BI solutions. Optimized data gathering processes, analysis procedures visualization strategies. Created oversaw dashboards QlikView. Create maintain SSIS packages using Microsoft Visual Studio. Extract data files received SFTP upload data-to-data warehouse required form. Using given technical specs create flat files send data files clients using SSIS package. Also, automate maintenance SQL Server databases updates. Analyzed code corrected errors optimize output. Resolved customer issues establishing workarounds solutions debug create defect fixes. Wrote user manuals documentation roll-out customer training sessions. Established maintained key relationships business stakeholders promote future opportunities. Managed 2 junior developers delivering consistent coaching constructive feedback. College Student Company Name City State January 2015 May 2016 Most accomplished College Projects: Predicting Breast Cancer: Create machine learning model predict malignant tumors. Used Python "Random Forest Classifier" predict malignant tumors breast tissue. Here, main idea building multiple models different sample different initial variables train data set. Goal determine attributes provide information used predict malignancy. My model tested “test data set” accuracy 96% successful predicting whether tumor malignant benign. Data Mining- Image Classification: It process categorize images one several categories. Classification requires training image category. Constructed Training Test data given image data using Java programming. Constructed five different classifier models using training data file. Tested classifiers using test data compared prediction accuracies among five different classifiers. Achieved 95% accuracy. Software Engineer Company Name City State October 2013 January 2014 Develop code java document artifacts including unit test plans ensure output per specifications: Execute tasks procedural OOP development techniques. Best practices efficient easier maintain code. Best practices securing web applications. Inserting, querying managing data stored databases files. Skills SQL Server/MySQL Data Analysis Visualization C#/.NET framework Python JavaScript Azure DevOps Education Master Science Computer Science University Illinois At Springfield City State Completed coursework Data Science, C# Programming .NET Data Mining. 3.95/4.0 GPA May 2016 Bachelor Engineering Information Science P.A College Engineering (VTU) City "Best Outgoing Student" Recipient Honor Roll 2010-2011 May 2013