Chandar Reddy

Experience

• 

  Techgene Solutions

  Dec 2016 - Jun 2017

  Data Analyst / Bi Developer

  Gathered requirements from the business users, created technical specification documents.• Used Power BI to develop data analysis prototype and used Power View and Power Map to visualize reports.• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients andmobile.• Oversee and support the design, development, and implementation of data warehousing, reporting, and analytics.Solutions that deliver information efficiently, with the end goal to solve business challenges and achieve.• business objectives• Architect and develop data models and reports utilizing Power BI applying best practices to the developmentlifecycle.• Used Python scripts to update content in the database and manipulate files.• Involved in gathering, analyzing, and documenting business requirements, functional requirements, and data.• Specifications for reports interacted with the users to analyze the changes for improvement they need in the• Existing reports and developed the reports to satisfy their business needs.• Expertise in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat• Maps, Tree maps, etc.• Developed custom report Tooltips for different Reports and Dashboards in Power BI.• Created various customized and interactive Reports and Dashboards in power BI.• Involved in creating Filters, quick filters, table calculations, calculated measures, and parameters in Power BI.• Publishing reports to Power BI Service and providing access to required users.• Created Table, Matrix, trend lines, bar, card, gauge, slicer etc. and Custom visuals using Power Bi.• Developed and rendered monthly, weekly, and daily reports as per the requirement and gave roles, user access withrespect to security in Report Manager. Show less

• 

  PowerSchool

  Dec 2017 - Jun 2021

  Business Intelligence Developer

  • Analyze, develop, and build modern data solutions with the Azure PaaS service to enable data visualization. Understand the application's current Production state and the impact of new installation on existing business processes.• Full Data Pipeline (FDPL) -Building frameworks that are configurable, metadata-driven & customized. Developed ETL pipeline using Databricks to build SILVER/GOLD layer tables using PySpark.• Experience sizing clusters for development and GIT integration with Azure DevOps. Data Ingestion to ingest data from various data sources using Data Factory and Azure web apps.• Migrated the Databricks ETL jobs to Azure Synapse Spark pools. The ETL deals with structured data coming from the Oracle source system and will be ingested through Synapse pipelines using the Oracle SQL connector.• Built Synapse spark ETL notebooks to standardize the data coming from vendor specific SFTP accounts and write the resultant data into Azure blob storage.• Used Azure Synapse for a dedicated SQL database to build a data model using Fact and dimensional tables for KPI using 24-hour delta records.• Integrated the Google AdWords API (campaign data) into the data lake (ADLS Gen2) using Data Factory and built external tables on top of them. Built ETL scripts to extract the campaign conversion statistics using PySpark.• Executed end-to-end SAP HANA migration project (ETL processes, data modeling, system optimization)• Leveraged SAP Data Services (BODS), SAP Landscape Transformation (SLT) for data synchronization and replication.• Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.• Worked one Teradata Store procedures and functions to conform the data and load it on the table.• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table. Show less

• 

  Principal Financial Group

  Feb 2023 - now

  Data Analyst/Bi Developer

  • Participated in designing and developing ETL pipelines using tools such as Apache Beam and cloud data flow to extract data from various sources and load it into BigQuery. Wrote a Python scripts in GCS bucket to maintain raw file archival. • Designed and implemented cloud data design using the AWS tools. Built AWS data pipeline using Dynamo DB, AWS glue and Amazon Athena.• Implemented continuous integration and continuous delivery (CI/CD) pipelines using Cloud Build, Jenkins, and GitLab CI/CD to automate the deployment of data pipelines and ensure data quality.• Designed and developed Cloud Build pipelines for building, testing, and deploying ETL workflows using BigQuery, Cloud Storage, Cloud Dataflow, and Cloud Pub/Sub. Built and maintained CI/CD pipelines using Cloud Build and Cloud Run to automate the deployment of data processing workflows and ensure data quality.• With Terraform, I have implemented security best practices for AWS resources. This includes defining IAM roles and policies for fine-grained access control, enabling encryption at rest and in transit, and implementing compliance standards such as PCI-DSS or HIPAA.• I have integrated Terraform with AWS Code Pipeline and AWS Code Commit to enable automated infrastructure deployments. This ensures that infrastructure changes go through a controlled CI/CD process, allowing for faster and more reliable deployments.• • Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.• Used Teradata Data Mover for overall data management capabilities for copying indexes, global temporary tables.• Used Azure DevOps for CICD deployment of the scripts to DEV, QA, and Prod during Snowflake migration. Used AWS DMS service to pull the data from Teradata and land into S3 data lake for all historical data and then used COPY INTO command to load into the stage tables. Implemented External storage integration to connect S3 Data lake and Snowflake stage. Show less

• 

  Spectra Laboratories

  Sept 2024 - now

  Senior Data Analyst

  • Conducted advanced analytics in the life sciences sector, focusing on bringing new drugs to market, analyzing biologic drugs, Hepatitis C treatments, STARS measures, and commercial formulary development. Supported pharmacy departments with informatics-driven insights.• Created detailed reports using R Studio to monitor and address drug overdosage or abuse, including opioid/narcotics control initiatives.• Led the Clinical Care Transformation (CCT) project to raise awareness among providers and specialists about significant increases in drug costs. Delivered quarterly reports and tracked the impact of corrective actions taken to improve patient health outcomes and reduce copays.• Analyzed high-cost drug therapeutic classes, such as Dermatologics and Cardiac drugs, and collaborated with specialists to enhance awareness. Identified the top 50 drugs by utilization across Commercial, Medicare, Fully Insured, and Self-Funded populations.• Supported data migration projects, including transferring FDA drug lists from Medispan to internal database systems. Coordinated with clients to gather requirements, defined data file formats, and collaborated with ETL and SDLC teams to implement seamless integration and validation.• Conducted predictive analyses to assess potential side effects from prolonged medication usage, particularly for chronic conditions like diabetes, CKD, CHF, and AMI. Show less