Jan 2020 – Jan 2022 · 2 yrs · Virginia, United States

Aug 2018 – Jan 2020 · 1 yr 5 mos · Charlotte Metro

Jun 2017 – Jul 2018 · 1 yr 1 mo · Omaha, Nebraska

• Gathering and documenting the requirements that are critical to business mission. Translating business requirements into report visualization specification design document
• Performing quality check on data, identifying outliers, normality and standardizing the data
• Designing and creation of tables, stored procedures, views, triggers, and user-defined functions
• Generating Risk Stratification reports using Tableau to manage high cost treatment plans, improve the quality by highlighting the risk summary and impact ability by chronic conditions
• Developing linear regression predictive risk model to predict the members with high risk using Python
• Using SQL Server Integration Services(SSIS) as an ETL Tool, the data has been Extracted, Transformed and Loaded from Excel and Flat file to MS SQL Server
• Designing and developing database management systems using ETL (SSIS) and also maintaining the database using stored procedures (SQL, PL/SQL) to fulfill the technical and business requirements of clients
• Writing T- SQL statements, Stored procedures for retrieval of data and performance tuning
• Developing various views in Tableau such as Tree maps, Heat maps, Scatter plots, Geographic maps, Line chart, etc.
• Using forecast feature in R and Tableau to provide predictive information of the historic data
• Creating aggregate data extracts for larger tables and configuring schedulers on the server to refresh data
• Projecting future growth in terms of number of subscribers, providing details at the county level
• Building predictive models for various researches using R and Python, which includes trend analysis, linear regression and logistic regression

Jan 2017 – May 2017 · 4 mos · Omaha, Nebraska

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle/ SQL Server for design, development, testing, and production rollover
• Assisted with annual budget process, reporting and analysis of performance against historical, budgeted, and forecasted data
• Principal Analyst on several major division projects requiring integration of financial and program data from multiple sources to create a cohesive dashboard for decision making
• Participated in multiple strategic planning efforts and development of metrics for executive level reporting
• Involved in ETL (Extract, Tailor, and Load), EDA (Exploratory Data Analysis) and profiling for project analytics
• Conducted data cleansing, data selection, required field identification, review methodologies for secondary source data
• Discovered problematic areas using data analysis (overrun, misdistribution of hours, trend analysis)
• Created numerous ad hoc reports, and also assisted in data gathering, testing subjective theories quantitatively for cost consumption issues
• Scheduled weekly and monthly increments of data refresh on Tableau Server based on business logic to ensure data accuracy on Dashboards
• Prepared and presented reports on the analytical findings of the tools developed in support of accurate program costs. Coordinated with other business departments to tailor reports and analysis as required

Apr 2016 – Dec 2016 · 8 mos

May 2013 – Jan 2016 · 2 yrs 8 mos · Greater Hyderabad Area

• Worked on Alteryx using SQL to extract data and develop POCs (Proof of Concepts)
• Involved in writing the SQL Scripts for report development, Dashboards, Scorecards and also handling the performance issues effectively
• Developed T- SQL statements, Stored procedures for retrieval of data and performance tuning
• Assisted in Statistical modelling and data mining techniques using SAS for segmenting customers and better targeting
• Extracted data from Teradata using SAS/Access, SAS SQL procedures and created SAS data sets
• Blended data from multiple sources to develop complex custom SQL scripts which are to be used as Tableau data sources
• Designed and deployed rich graphic visualizations with Drill-down and Drop-down menu options using Tableau
• Developed various analytical reports by blending data from multiple data sources (SQL Server, Oracle, Excel, Flat files) on a single worksheet using Tableau Desktop
• Extensively used advance chart visualizations such as Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts etc., to assist business users in solving complex issues
• Utilized advanced features of Tableau software to link data from different sources presenting on a Dashboard and to filter data in multiple views simultaneously
• Created Prompts, Customized Calculations, Conditions, Filters (Local & Global), Parameters, Groups and Sets for various analytical reports
• Assisted senior analysts in improving the delivery process through continuous integration