Bhavya Challa Email & Phone Number

Toronto, Ontario, Canada

• Analyze, design and build modern data solutions using Azure PaaS service to support visualization of data. Understand current Production state of application and determine the impact of new implementation on existing business processes. • Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks. • Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards. • Outguessed the data from HDFS to Azure SQL data warehouse by building ETL pipelines using S worked on various methods including data fusion, machine learning and improved the accuracy of distinguished the right rules from potential rules. • Extensive Knowledge and hands-on experience implementing PaaS, IaaS, SaaS style delivery models inside the Enterprise (Data center) and in Public Clouds using like Azure, Google Cloud, and Kubernetes etc. • Extensively worked on making REST API (application program interface) calls to get the data as JSON response and parse it. • Experience in analyzing and writing SQL queries to extract the data in Json format through Rest API calls with API Keys, ADMIN Keys and Query Keys and load the data into Data warehouse. • Designed and developed Security Framework to provide fine grained access to objects in AWS S3 using AWS Lambda, Dynamo DB.• Creating lambda functions with Boto3 to deregister unused AMIs in all application regions to reduce the cost for EC2 resources.• Develop Databricks Python notebooks to Join, filter, pre-aggregate, and process the files stored in Azure data lake storage.

Princeton, New Jersey, United States

• Hands-on experience ingesting data from various sources, including Azure Data Lake Storage, Azure SQL Database, external databases, and streaming sources.• Design & implement migration strategies for traditional systems on Azure Lift and shift/Azure Migrate, other third-party tools. • Created ETL (Extract, Transform, Load) processes using Databricks to transform raw data into structured and usable formats for analytics and reporting.• Responsible for creating, scheduling, and monitoring Azure Data Factory pipelines to facilitate efficient data movement, transformation, and integration across diverse data sources, ensuring data reliability and availability for analytics and reporting.• Used Pandas, Opencv, NumPy in Python for developing data pipelines. • Perform Data Cleaning, features scaling, features engineering using Pandas and NumPy packages in python. • Created several Databricks Spark jobs with PySpark to perform several tables to table operations. • Engage with business users to gather requirements, design visualizations and provide training to use self-service BI tools. • Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc. • Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure. • Develop conceptual solutions & create proof-of-concepts to demonstrate viability of solutions. • Technically guide projects through to completion within target timeframes. • Collaborate with application architects and DevOps. • Identify and implement best practices, tools and standards. • Design Setup maintain Administrator the Azure SQL Database, Azure Analysis Service, Azure SQL Data warehouse, Azure Data Factory, Azure SQL Data warehouse. • Build Complex distributed systems involving huge amount data handling, collecting metrics building data pipeline, and Analytics.

Dallas, Texas, United States

• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, and performance tuning. • Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications. • Created various types of reports such as complex drill-down reports, drill through reports, parameterized reports, matrix reports, Sub reports, non-parameterized reports and charts using reporting services based on relational and OLAP databases. • Extracted data from various sources like SQL Server 2016, CSV, Microsoft Excel and Text file from Client servers. • Developed and executed a migration strategy to move Data Warehouse from an Oracle platform to AWS Redshift. • Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process. • Developed ETL pipelines in and out of data warehouse using combination of python and snowflakes, SnowSQL writingSQL queries against Snowflake• Developed and executed a migration strategy to move Data Warehouse from Greenplum to Oracle platform. • Responsible for building Confidential data cube using SPARK framework by writing Spark SQL queries in Python to improve efficiency of data processing and reporting query response time. • Developed spark programming code in Python Data bricks workbooks. • Expertise in creating PL/ SQL Procedures, Functions, Triggers and cursors. • Expert level knowledge of complex SQL using Teradata functions, macros and stored procedures. • Developing under scrum methodology and in a CI/CD environment using Jenkins.

Hyderabad, Telangana, India

• Worked with the Architects on SDLC process being the owner of post development environments. • Developed and supported the Software Release Management and procedures. • Deployed and configured Chef Server including bootstrapping of Chef Client nodes for provisioning. Created roles, recipes, cookbooks and data bags for server configuration. • Creating S3 buckets and maintained and utilized the policy management of S3 buckets and Glacier for storage and backup on AWS. • Maintained build related scripts developed in Maven, Python and Shell, modified build configuration files including Ant's build.XML based on the new requirements. • Built deployment pipelines using Jenkins as a frontend for Continuous Deployment to local staging, test and production environments on demand, using the Shell scripting. • Developed automation scripting in Python to deploy some applications, also developed Perl and Shell scripts for automation of the build and release process. • Responsible for design and maintenance of the GIT repositories and the access control strategies. • Merged release branches to the trunk after the production release and resolved the conflicts rose during the merge in GIT. • Managed Docker orchestration and Docker containerization using Kubernetes.

Bachelor Of Technology - Btech, Computer Science

Master'S Degree, Computer And Information Sciences