• Successfully designed, developed, and maintained a variety of paginated reports using SSRS.• Seamlessly integrated paginated reports within Power BI dashboards, enhancing the overall data visualization experience.• Contributed to the creation of comprehensive reports that provide users with a holistic view of business insights.• Proficiently composed DAX queries to customize and enhance imported datasets within Power BI.• Effectively employed DevOps tools to track and manage reported issues, resulting in improved efficiency and reduced rework.• Developing and managing AWS Glue jobs to ensure efficient data migration, transformation, and loading processes.• Utilizing AWS Crawler to maintain an accurate and up-to-date data catalog, enhancing overall data management.• Creating and optimizing PySpark scripts for extracting, transforming, and loading data into S3, which improves data quality and supports smooth visualization in QuickSight.• Developing Infrastructure as Code using AWS CDK, leading to reliable and reproducible deployment of AWS resources.• Effectively utilizing GitHub for version control, ensuring a structured and collaborative development process.• Leveraging Jira as a tracking tool to manage tasks, track progress, and efficiently prioritize work items.• Conducting rigorous data analysis to validate data integrity and quality, ensuring accurate outcomes.• Using boto3 to interact with AWS resources, automating and managing various tasks.• Managing file storage and interactions in AWS S3 with Lambda, streamlining data processing tasks.• Using Jenkins as a CI/CD tool to automate build, test, and deployment processes.• Working with Data Vault architecture to create scalable and flexible data models.• Using Glue interactive sessions for development and PyCharm as my development environment.• Storing data in AWS Redshift and querying S3 data using AWS Athena.• Orchestrating AWS Glue jobs with AWS Step Functions

• Developed and maintained data transformation pipelines using Pyspark, Databricks, Boto3, Spark SQL that are able load data from AWS S3 to Snowflake, Orchestrated data load on schedule with help of Apache Airflow• Collaborated with Data Owners to extract data from web pages, APIs with help of Beautiful soup, scrapy, requests, selenium, chrome drivers and format to post to FTP server post which with help of AWS transfer family files are transferred to S3.• Implemented new features in Python, AWS Lambda, AWS CloudWatch, AWS SNS to deliver reliable source of data to downstream for further analysis and notify support or dev team in case of any production failures.• Built restful APIs utilizing Fast API framework, postgres to build an interactive web-based solution to onboard data source which is containerized using docker and deployed to AWS ECS instances with help of Stash, Terraform and Jenkins• Involved in peer reviews, mentoring team members, agile process using JIRA as tracking tool for sprint cycles and tasks assigned, writing unit tests with help of pytest, unit test, automation of regression testing with Behave framework in python to reduce manual effort in performing repetitive tasks.• Participated in bug thrashing sessions with SQA team to discuss and resolve bugs reported in JIRA. Participated in daily stand-up meetings and provided status on work progress.• Implemented SCD type 2 while loading data to data warehouse. Scripted store procedures to get best views of data loaded and to assign unique parameters to data loaded.

• Created Chatbot API to answer end user questions for quick resolution with help of python, Rasa framework for NLU, Mongo DB, Flask, Reinforcement learning techniques.• Involved in Data acquisition using big data technologies like Spark, PySpark, Spark SQL, Databricks. Analysed the SQL scripts and designed the solution to Develop a custom ETL pipeline by using Python. Accomplished Business Intelligence activities like generating reports, building dashboards, refreshing data on schedule, triggering alerts on data acquired for further insights.• Developed and test many features in agile environment using python, Django, HTML5, CSS, JavaScript, Bootstrap, MySQL to create web interface which provides data insights to members and different services to end users. Used AWS Elastic Container service for deploying and scaling web applications and services developed in Python using Docker• Developed internal tools for text mining (sentimental analysis), web crawler for collecting data by Python, SQL. Managed code with unit tests implemented using unit test, Pytest frameworks and maintained in GitHub which are run in Jenkins pipelines to ensure proper functioning code in higher environments• Developed tools using python, shell scripting, SQL, PL/SQL for automating repeated and manual tasks. Standalone desktop applications are developed with help of Tkinter and shared across the team.• Migrated the application running on mainframes to Linux server with business logic implemented in Python, application servers like Gunicorn to have seamless process flow with better and faster performance. Developed APIs to interact with data storage in backend database, storing session history, tracking history in Mongo DB.• Involved in development of web application for UHC Insights to visualise different metrics pertaining to claims using React.

 Participated in more than 4 projects per year from initial research and conceptual design through testing and implementation phases using ETL tools like informatica, Talend. Developed web based ETL platform with help of Django, Django ORM includes HTML, CSS experience in coding, designing, deploying, and debugging development back-end projects utilizing python language to load data to Data warehouse and coding skills to write scripts in shell, Python, PowerShell Developed module to build Django ORM queries that can preload data to greatly reduce number of database queries needed to retrieve same amount of data. Used packages such as mock, patch to perform unit testing Developed data quality portal using Python scripting, Django, increasing data quality by 70%. Communicated and coordinated with the project manager and co-workers to resolve 30+ build breaks a month. Accomplished Job scheduling and process control, forking and cloning of jobs and checking the status of the jobs using shell scripting. Utilized AWS services like S3, Lambda, SNS, CloudWatch, EC2, ECS instances for computing and storage purpose. Accomplished data movement from one source to other source using Apache Kafka. Researched, designed, tested, and evaluated technologies for building systems. Manage and resolve any production issues to minimize the impact Involved in automations using C#.net, Robot Framework, Flask based single page application, Tox to comply with PEP8 coding standards thereby increasing productivity of workforce by 30%. Developed UI for configuration of ETL transformations to generate config files which in turn used in python-based Pandas framework for transformation activities. Involved in migration of Django based framework to React framework for enhanced performance and maintained standalone application for internal users.