Data Analyst Senior
Resume:
Turlapati A
Senior Data Analyst
*******************@*****.***/********@******.***
SUMMARY:
Over 8 years of IT experience working as a Data Analyst/Engineer. Experience in interpreting and analyzing data.
Experience in ETL’S using Spark- in memory processing, Spark streaming using Kafka distributed messaging system, and Spark SQL.
Good understanding of various Hadoop distribution platforms like Cloudera, Hortonworks, and cloud platforms like Amazon AWS.
Proficient in Job Orchestration tools like Airflow, Oozie, & Zookeeper.
Knowledge of structured data sets, ETL tools, data pipelines/reduction, transformation, and aggregation technique.
Very capable at using Amazon Web Services utilities such as EMR, S3 and CloudWatch to run and monitor Hadoop/Spark jobs on AWS.
Written Py Spark jobs in AWS Glue to merge data from multiple tables and in Utilizing Crawler to populate AWS Glue data Catalog with metadata table definitions.
Generated a script in AWS Glue to transfer the data and utilized AWS Glue to run ETL jobs and run aggregation on PySpark code.
Excellent understanding of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX/ LINUX command line.
Experience in preparing ETL design documentation. Experience of working on onsite – offshore modules.
I have experience in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau.
Developed reports and ad-hoc reports using SSRS and Excel.
Experience in Data Modeling & Data Analysis, Data Mapping, Logical Modeling, As-Is, and To-Be Mapping, Feasibility- studies, vision-scope documents.
Experience in aggregating data and configuring reports from different data sources using data blending.
Proficient in creating various data visualization techniques such as: Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps, and Highlight tables.
Experience in designing and deploying rich Graphic visualizations with Drill Down and Drop-down menu options and Parameterized using Tableau.
Utilized Snowflake’s capabilities for real-time data analysis, which supported timely decision-making regarding network performance and customer service operations.
Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
Created and customized Dashboards using Tableau.
Advanced knowledge of Tableau BI application creation and server-side functionalities.
Analyzed and Generated reports and dashboards for various management and business unit personnel to provide detail information on key performance indicators.
Knowledge of various python libraries such as NumPy, SciPy for mathematical calculations, Pandas for data processing/wrangling.
Proven ability to understand business problems and able to apply technologies to formulate workable solutions with an excellent
Interpersonal and communication skills.
Good knowledge on Standard object, Sales process, Validations, Workflows, Process Builders, Reports and Dashboard.
A quick learner who can absorb new ideas and can communicate clearly and effectively.
TECHNICAL SKILLS:
Programming
Python, PySpark, Scala, Java, C, C++, Shell script, .NET, Perl script, SQL
Cloud Technologies
AWS, Azure Data Factory
Frameworks
Django REST framework, MVC, Hortonworks
Tools
PyCharm, Eclipse, Visual Studio, SQL*Plus, SQL Developer, TOAD, SQL Navigator, Query Analyzer, PL/SQL,SQL Server Management Studio, SQL Assistance,CI/CD, Eclipse, Postman Automation.
Versioning tools
SVN, Git, GitHub
Operating Systems
Windows 7/8/XP/2008/2012, Ubuntu Linux, MacOS
Network Security
Kerbero
Database Modeling
Dimension Modeling, ER Modeling, Star Schema Modeling, Snowflake Modeling
Monitoring Tool
Apache Airflow
Visualization/ Reporting
Tableau, ggplot2, MatPlotLib, SSRS and Power BI
Machine Learning Techniques
Linear & Logistic Regression, Classification and Regression Trees, Random Forest, Associative rules, NLP and Clustering
PROFESSIONAL EXPERIENCE:
Prime Therapeutics, PA Aug-2023- Present
Sr. Data Analyst/Data Engineer
Responsibilities:
Created interactive dashboards using tools like Tableau and Power BI to visualize key performance indicators (KPIs) related to medication adherence, cost savings, and patient outcomes.
Results-driven data analyst with extensive experience in the healthcare sector, specializing in patient demographics and treatment outcome analysis.
Developed interactive dashboards in Tableau and Power BI, reducing reporting time.
Designed, developed, and implemented data marts tailored to specific business units, streamlining access to relevant data for improved decision-making.
Proficient in SQL and Python for data extraction and transformation, and skilled in statistical analysis using R and SAS.
Expert knowledge of healthcare data (e.g., claims, eligibility & EMR).
Familiar with healthcare claims and CPT/HCPCS/ICD/DRG/Revenue Codes, Medical Claims,
Provider reimbursement & HEDIS performance requirements.
Developed and documents system procedures and workflows.
Membership Reports imported across all payers to generate a list of attributed Patients.
Tracked Monthly attribution count by payer for BOD and Executive team Reporting.
Tracked out of Network or termed Providers that are currently being attributed to our Membership lists across payers.
Imported Data from a variety of outside source in to the data repository.
Import / Export Claim files, Eligibility files & Enrollment files monthly basis & Upload to Third Party Vendor.
Developed and generated Production Reports listed on the Production Calendar & Responded other departments request timely manner.
Successfully completed GPRO, Shared Saving & Patient Ping Projects.
Data extraction and manipulation for use in SFHCP systems
Implemented data validation scripts in Python, ensuring clean and enriched datasets before they were moved to production environments. This helped maintain high levels of data accuracy and integrity.
Utilizing SQL for data extraction and Python for cleaning and analysis
Reorganized data, turned unique identification keys from claim ID to individual patients using SQL
Analyzed demographic and geographic data of patients, removed duplicated/redundant records, transformed variables according to algorithm needs using R
Mapped ICD-9 code (International Classification of Disease) to CC code, and then to HCC code (Hierarchical condition category ) to obtain risk coefficients in R
Applied Medicare risk adjustment model, calculated individual risk scores by applying sum of weights that reflects the health risk posed by different diagnoses
Implemented Medicare Shared Saving Algorithm and calculated savings to ACO in Excel and R
Simulated performance year data (2014) by multiplying a trend factor to existing data and generating necessary components in Excel and R
Calculated number of assigned beneficiaries, per capita expenditure, and average risk score of beneficiaries in each benchmark year and performance year using R
K-Servicing, GA Jan-2023- July 2023
Sr. Data Analyst/Data Engineer
Responsibilities:
As a data analyst in the financial services industry, I focused on leveraging data to drive strategic decision-making and optimize financial performance.
Involved in defining the source to target data mappings, business rules, and business and data definitions.
Developed Project Plan with Project manager’s assistance for the first two phases of the Project.
Worked with DBAs to recreate the best fit physical data model from the logical data model.
Performed Data modeling using Erwin, maintaining the database schema.
Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch.
Developed and maintained complex financial models in Python, performing variance analysis, regression modeling, and forecasting. These models were used by the finance department to predict future financial trends and make more accurate budget decisions.
Created detailed documentation of data flows within Snowflake, outlining the lineage of key metrics and KPIs to improve understanding across cross-functional teams.
Developed and implemented a data lineage framework in Snowflake to trace data flow from source systems to final reporting, enhancing transparency and trust in analytics.
Worked on complex financial models using Excel, SQL, and Python to predict financial outcomes and provide actionable insights.
Involved in variance analysis to compare actual financial results with forecasts and budgets, identifying key drivers of discrepancies.
Maintained complex financial databases, ensuring data consistency and accessibility for ongoing analysis.
Utilized regression analysis (linear, logistic, and multiple regression) to model relationships between variables and predict future trends.
Prepared Dashboards using calculations, parameters in Tableau.
Worked with Data Management team to analyze Reinsurance Data using tools like SQL, Access, Excel (Lookups, Pivot tables) and predicting any future impacts on business.
Prepared financial analysis reports with Data Management team to assist senior management.
Worked in collaboration with Actuary team to improve predictive models.
Worked on internal projects to improve the standards of routine data processing.
Analyzed panel data to study the impact of time on financial indicators across different entities, providing insights for policy formulation.
Research and problem solving pending and denied encounters.
Used Terra grunt to run Terraform scripts to automate instances for EC2 instances that were launched manually before.
Involved in using Sqoop for importing and exporting data between RDBMS and HDFS.
Environment: AWS, ETL, SQL, PYTHON, Snowflake, Data bricks, UI.
VERIZON - San Jose, California Jan-2022-Dec 2022
Data Analyst/Data Engineer
Responsibilities:
Worked on the Data Warehouse team analyzing data files that had to be compiled from disparate non-production sources and readied them for production. Tasks included: comparing data to requirements documentation, creation of data layouts and data dictionary.
Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
Delivered Enterprise Data Governance, Data Quality, Metadata, and ETL Informatica solution
Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.
Researched and fixed data issues pointed out by QA team during regression tests.
Interfaced with business users to verify business rules and communicated changes to ETL development team.
Created Tableau views with complex calculations and hierarchies making it possible to analyze and obtain insights into large data sets.
Creating and executing SQL queries to perform Data Integrity testing on a Teradata Database to validate and test data using TOAD.
Worked with data architects team to make appropriate changes to the data models.
Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse)
Participated as member of a project team performing various lifecycle tasks for an intranet application with SQL Server 2012 database. Developed logical and physical database models and data dictionary documentation.
Created Stored Procedure and Views, Indexes, SQL joins and Sub queries
Worked with integration services for transferring and reviewing data from different sources like (Flat file, Excel, CSV)
Generated Daily, Weekly, Monthly reports for the analysis of managers and end users by using SQL Server Reporting Services.
Data visualization using Charts in Think-cell/Excel/Tableau (column chart, pie chart, stacked chart, waterfall chart, bubble chart, scatter chart, line chart, pareto chart etc.)
Co-ordinate with different application team to develop and standardize enterprise wide data model, created dimensional data model using Agile Methodology, Designed and developed dimension tables, fact tables, conformed fact and dimension tables.
Analyzed the member eligibility, plans including Medicaid/Medicare, refill, pricing and drug edits.
Participate in weekly data analyst meeting and submit weekly data governance status
Data profiling and Data quality checks along with integration rules determination and documentation.
Experience with data mining, data cleansing, data modeling, data manipulation, record matching, table linking, table structures, importing and exporting.
Used shell commands to create serialized C# class files from XML based schemas Involved in performing the unit testing, Regression and User Acceptance Testing.
Environment: AWS, ETL, SQL, PYTHON, Snowflake, Data bricks, UI
TANZANITE SOFTWARE TECHNOLOGIES PVT LTD, Hyderabad, India Jun 2016 - May 2021
Data Analyst
Responsibilities:
Worked as a team member providing advanced business solutions to the company.
Gathered business requirements and designed technical requirements documentation.
Designed, developed, and implemented new functionality to analyze large amounts of data and wrote SQL scripts to manipulate data.
Performed data queries to develop reports on a daily, weekly, monthly, and quarterly basis to support management decisions.
Performed data acquisition, mapping, integration, and transformation.
Worked on the ETL Informatica mappings and other ETL processes.
Identified, analyzed, and interpreted trends using data analysis techniques.
Developed visualized data outputs using R, Tableau, and Excel. Interpreted data and analyzed results using statistical techniques.
Was responsible for event discovery, event management, incident resolution and automating routine tasks.
Ad-hoc Reporting based on user requirements and creating data model for tableau.
Delivered Enterprise Data Governance, Data Quality, Metadata, and ETL informatica solution.
Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.
Performed extensive Gap analysis to determine the risks and assist the PM in budget and resource planning.
Created Work Breakdown Structure (WBS), Business Process Workflows, GUIs, Use Cases, and UML diagrams, and created Swim Lane process flow diagram for various cargo business processes.
Conducted walkthroughs with the different department heads to have a deeper understanding of the requirements.
Developed flow diagrams for the Business process of the company, UI Wireframes, and Mockups using MS Visio.
Created and maintained data mapping documents.
Follow up with the end-users and developers for user satisfaction and change management if necessary.
Helped in writing training manuals, scheduled, and trained junior BA’s using PowerPoint, got it reviewed and approved by the project team and clients.
Assisted offshore team in understanding requirements through daily scrum calls as per customers’ needs.
GAP analysis by identifying existing technologies, documenting the enhancements.
Used MS Visio to develop Use Cases to meet the end state requirements.
Performed extensive data analysis using SQL in both Oracle and SQL Server databases.
Environment: IBM Data Studio, DB2, SQL, Informatics, Cognos, MS Office, Agile Methodology
Education Details:
Bachelor’s - JNTUH in CSE – 2017
Master’s - Kennesaw State University, GA - 2022
Contact this candidate