Experience

AIM Specialty Health

• United States
• Hospitals and Health Care
• 500 - 600 Employee

• Sr. Data Analyst

  • Sep 2019 - Present

  • Collaborate with the Development team to support release planning, estimation, and delivery processes using Agile methodologies. • Clean data and processed third-party spending data into maneuverable deliverables within a specific format with Excel macros and python libraries such as NumPy, SciPy, and Matplotlib. • Worked on data that was a combination of unstructured and structured data from multiple sources and automated the cleaning using Python scripts. • Worked in using collections in Python for manipulating and looping through different user-defined objects. • Design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau. • Administered user, user groups, and scheduled instances for reports in Tableau. • Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau. • Written complex SQL queries using joins and OLAP functions like CSUM, Count and Rank, etc. • Used Hadoop, Hive, Pig, and Spark to manage data processing and storage for big data applications running in the clustered system. • Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results. Show less



WiseDesign, Inc.

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Data Warehousing Analyst

  • Nov 2018 - Aug 2019

  • Designed and implemented multiple dashboards using customized Style Intelligence tool for in-house metrics. • Involved in preparing the data and perform the visualizations and monitor the performance and publish the most effective dashboard. • Handled loading, extracting, and validating of client data; write SQL queries to clean and manipulate data for further analysis. • Worked with Clinical datasets and logistics industry data sets and financial datasets to show case and help to users in specific industry. • I created effective dashboards by using the KPI's and charts important to users. • Performed NLP, Machine Learning (Scikit-learn, Pandas), sentiment analysis to improve marketing. • Worked on predictive analytics use-cases using Python language. • Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic. • Drilled down into data to find root causes of trends, identify the KPIs, etc. used to drive strategic improvements. • Closely worked with Data Scientist to write Python script for data wrangling with visualization (Used python libraries: Numpy, Pandas, Seaborn, Scikit, Matplotlib). Show less



Charter Communications

• United States
• Telecommunications
• 700 & Above Employee

• Data Analyst

  • Aug 2017 - Oct 2018

  • Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity. • Collecting the data from Low-level management by using the CRM tool and analyze the data, transformed into actionable insights by predicting the future outcome, and send the final report to higher officials to make the business decisions. • Successfully interpreted data to draw conclusions for managerial actions. • Able to created ETL pipelines using SSIS. • Involved in Data extraction, Data transformation, Data cleansing, Data loading activities. • Used statistical techniques for hypothesis testing to validate data and interpretations. • Presented data and conclusions to the team for improving operations. • Proposed solutions to improve system efficiencies and reduce total expenses. • Analyzed credit appraisal memo eligibility and LTV calculations. Show less



Matrix Healthcare Solutions

• United Kingdom
• Pharmaceutical Manufacturing
• 1 - 100 Employee

• Data Analyst

  • Nov 2016 - Jul 2017

  • Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity. • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center. • Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications. • Tested Complex ETLMappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables. • Responsible for different Data mapping activities from Source systems to Teradata • Created the test environment for Staging area, loading the Staging area with data from multiple sources. • Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources. • Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.) Show less



Infolab Technologies

• India

• Data Analyst

  • May 2015 - Jun 2016

  • Developed business process models in Waterfall to document existing and future business processes. • Imported the claims data into Python using Pandas libraries and performed various data analyses. • Programmed a utility in Python that used multiple packages like NumPy, and pandas. • Perform troubleshooting, fixed, and deployed many Python bug fixes of the two main applications that were the main source of data for both customers and the internal customer service team. • Responsible to design, develop, and test the software to maintain the data marts (Load data, analyzed using OLAP tools). • Built data pipelines to aggregate and clean data by PySpark (Filter, group By, Split). • Installed and configured on-premises gateway in Power BI services. Show less



Mac Dye Chemindustries

• India
• Chemical Manufacturing

• Data Analyst

  • Mar 2013 - Apr 2015

  • Extracted, compiled, and tracked data using SQL and applied Machine Learning Algorithms in Python and R. • Analyzed data to generate visual reports using Tableau to interpret consumer behavior, manufacturing of raw products, import/export business and market current trends . • Executed dashboards using Tableau and Power BI tools for board members to monitor yearly savings and profit. • Collaborated with data engineers to develop a statistical model. • Prepares and submit the summarized audit reports and taking corrective actions. • Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing. • Document and publish test results, troubleshoot and escalate issues. Show less