Pavan Kumar Kodati
For 7.5 years, I participated on teams doing analysis, design, development, implementations, enhancements and testing of applications in these areas: Healthcare, Entertainment, Internal corporate Applications, Financial, Geotechnical and Marketing and Sales.
Associate Technical Consultant
Business Systems Analyst
Hadoop, Hive, Python 3.6, Impala, Oracle, DB2, SQL, Tableau, Excel
Other Technologies and skills
Microsoft Silverlight, Microsoft expression Blend
Microsoft Project Management, Stata 15, Wireshark
Software documentation, Software development process, Analyzing Information
Healthcare, Entertainment, Corporate applications, Finance, Geotechnical, Marketing and Sales
Blue Cross Blue Shield of Massachusetts
Proactively spearheaded the launch of Provider Connect website that has multiple applications. Developed a portal with the new healthcare system by migrating an old system to new system (website) and created reports using Tableau for stake holders.
Developed Common Ingestion Framework that moves the source raw files to the HDFS server and uses various services to move the data to meaningful entities using Hive.
Haley and Aldrich
Developed Dashboards for Financial information provided data in multiple formats using Tableau and Python.
Utilized MySQL and Tableau to interpret marketing and sales information to create reports and dashboards.
Cognizant Technology Solutions Pvt Ltd
Augmented and developed a website to create real-time, operational, collaborative, and business performance dashboards using .Net.
MSIT, University of Massachusetts Boston 2018
MBA, University of Massachusetts Boston 2017
PROFESSIONAL AND BUSINESS EXPERIENCE
Perficient, Inc. 3/2019 – 2/2020
Associate Technical Consultant
CLIENT: Florida Blue
Developed a website for Florida Blue by migrating old system (SIEBEL and PIMS) to the new system by creating a Provider Connect portal. I was responsible for gathering business requirements, functional requirements, creating crosswalks, dashboards and user stories for the developers and testing the portal. Also provided solutions to complex technical issues and writing SQL queries to create a service at the back end for crosswalk document.
Participated in technical research and development to innovate within the system’s domain and CRM application.
Experienced with middleware tools and proficient with administration systems, software, and hardware in simple to moderate environments.
Determined operational objectives by studying business functions; gathering information; evaluating output requirements and formats
Prepared technical reports by collecting, analyzing, and summarizing information and trends.
Executed SQL queries to test back end data validation of DB2 database tables based on business requirement
Recommended controls by identifying problems; writing improved procedures for the portal
Translated technical applications specification into functional and nonfunctional business requirements and created user stories based on those requirements in Rally.
Participated in or driven data governance across an enterprise.
Developed report and dashboards using data visualization tools like Tableau and business objects to analyze provider performance, user performance which facilitate effective business analysis.
Overture Partners, Massachusetts 7/2018 – 3/2019
Business Systems Analyst
CLIENT: Blue Cross Blue Shield
Participated in a 11 person team doing analysis, design, development, implementation, enhancements and testing of a Data Lake Analytics Platform Project, which is designed to migrate all forms of data and provide Analytics, AI, Machine Learning capabilities for internal and external applications via multiple channels utilizing Hive, Impala, Spark and HBase.
Developed Complex Hive QL, Impala queries to store raw NASCO files in the HDFS staging platform using Hadoop platform.
Reported detailed data analysis of providers performance to the product owner every day.
Created python scripts to run complex ingestion framework modules to manage data from multiple resources.
Performed complex queries to create a combined model, which contains 1800 columns utilizing common ingestion framework.
Used Camel Service to move the source files sent by NASCO to the HDFS Server for processing the data.
Created Metadata workbooks to curate and publish multiple healthcare related data.
Developed a process called onboarding that moves curates the HBase tables along with Hive tables based on the workbook.
Created Hive QL queries for Publish workbooks to create Publish tables utilized by business enterprise and other downstream applications.
University of Massachusetts Boston, Massachusetts 08/2016 – 06/2017
Analyzed labor data using Python from 10-K forms between 1996 and 2016 and predicted whether consensus between labor and management were successful, if successful we have predicted the wages for the labor unions.
Became familiar in implementing machine learning and analyzed financial health of computer industry between 2010 and 2016 and traced the impact of the financial crisis and recession on the industry’s health by accessing balance sheet and income statement data items using Python and My SQL.
Presented reports using Python to a project that conceptualizes correlation statistics and regressions to a recent litigation involved certain manufacturers of tobacco products and Attorney generals of the various U.S states to examine the differences in the average cigarette prices and excise taxes across United States.
Presented reports on Boston Housing Data Project and I found out that clean air influenced the value of houses in Boston using historical data using Python.
Haley and Aldrich, Boston, Massachusetts 06/2016 –08/2016
Business Analyst Intern,
Participated in a 5-person team doing analysis, design, development, implementation, enhancements and testing of a Spend Analysis Project, which is designed to migrate all forms of financial and geotechnical data to a website and generate reports utilizing Tableau and Python
Presented reports on Spend Analysis for the organization using Tableau and Python that provides information about expenses and our finding from the historical data says that this organization spends more on insurance which is about 33%
I was responsible for development, analysis, and production of reports, queries and data extracts from multiple data sources and conduct a variety of data validation activities.
Became proficient at classification of raw data based on tags or labels and my goal was to categorize the data across various departments and report that information to the BA team.
Used statistical techniques for hypothesis testing to validate data and interpretations.
Sree Venkateshwara Power Controls, India 01/2013 –08/2015
Participated in a 7-person team doing analysis, design, development, implementation, enhancements and testing of a Marketing and Sales Project (MSFD), which is designed to utilize all forms of financial and sales to generate dashboards and reports using Tableau and SQL.
Interpreted and analyzed client information data for marketing purposes using Tableau and provided dashboard reports to the management.
Introduced Tableau in the organization to approach fast analytical business intelligence to improve decision making capabilities. The data we used has approximately 1 million records.
Improved database (My SQL), by introducing employee management system in addition to the human resource management database. I was responsible for providing technical details such as conceptualizing ER-Diagram, creating variable relationships and queries.
Acquired data from various sources to develop and import to database that optimized statistical efficiency and quality of interpretation.
Facilitated in increasing the profits by 12% as I was responsible for introducing two modern technologies such as Tableau and Python.
Became expert in excel and reviewed expense and sales data, which helped us increase our sales by 27% and profits by 12%.
Cognizant Technology Solutions Pvt Ltd, India 02/2011 –12/2012
Participated in a 9-person team doing analysis, design, development, implementation, enhancements and testing of an Application Value Management Center of Excellence (AVM CoE), which is designed to migrate all forms organizational data utilizing .Net and Silverlight.
Augmented and developed a website that has various dashboards such as forecasting/planning, revenue positions, cost estimation as corporate dashboards and knowledge transition, resource utilization, grouping as service dashboards.
Developed dashboards using technologies such as .Net, Microsoft Silverlight and Expression Blend 4 and provided expertise in developing visual transitions (GUI) and relational databases using SQL Server.
As a team we streamlined four types of real-time management dashboards operational control dashboards, business process dashboards, collaborative dashboard, and business performance dashboard.
Analyzed raw data from customers, managers, team leads, test data, build data used as a feed transaction system to provide high performance intelligence to the high-level management.
Improved functional applications such as portfolio analysis, due diligence, transition planning, knowledge acquisition, guided support, reporting, risk/issue management, collaboration, tools and feedback.