Datta Sai Jonnadula

Datta Sai Jonnadula

Software Engineer
Canada

About Me

Innovative Software Engineer with about 4 years of experience in the information technology and services industry. Have a deep understanding of Salesforce, Python, SQL, other ETL, and BI tools, and delivered more than fi…

Experience

Analytics and Reporting Specialist

TELUS Health, Toronto, Canada
Jun 2023 - Present · 3 years 1 month

Rebranded 20+ IBM Cognos and SSRS reports from Lifeworks to TELUS Health by gathering data from multiple sources and UX designs.
Designed, developed, tested, and maintained reports according to improving requirements to fulfill the measures according to TELUS Health.
Worked in an Agile environment by using Microsoft Azure DevOps and JIRA for tracking sprints, tasks, and work items.
Worked around in SQL Server Management Studio (SSMS) to make changes in tables and views by writing DML and DDL commands.
Developed and designed complex reports using SSRS, leveraging various data sources and datasets to meet business requirements and provide actionable insights.
Collaborated with cross-functional teams to gather report requirements, translating complex business needs into functional and user-friendly reports using SSRS.

Analytics and Reporting Specialist

TELUS
Jun 2023 - Present · 3 years 1 month

• Rebranded 20+ IBM Cognos and SSRS reports from Lifeworks to TELUS Health by gathering data from multiple sources and UX designs.
• Designed, Developed, Tested and Maintained reports accordingly with the improving requirements to fulfill the measures according to TELUS Health.
• Worked in an Agile Environment by using Microsoft Azure DevOps and JIRA for tracking sprints, tasks and work items.
• Worked around in SQL Server Management Studio (SSMS) to make changes in the tables, views by writing DML and DDL Commands.
• Developed and designed complex reports using SSRS, leveraging various data sources and datasets to meet business requirements and provide actionable insights.
• Collaborated with cross-functional teams to gather report requirements, translating complex business needs into functional and user-friendly reports using SSRS.

Salesforce Administrator/Quality Assurance Specialist Intern

Soti Inc, Mississauga, Canada
Sep 2022 - Apr 2023 · 7 months

Developed 15+ automation testing classes in C# to test 10-15 objects in Salesforce to identify or fix issues quickly and improve the quality of the application.
Customized existing Salesforce standard objects, fields, reports, dashboards, and page layouts to meet determined user requirements and improve the overall user experience.
Documented 100+ test cases in more than 10 projects in Salesforce by creating a test plan including testing schedule, objectives, resources, and results for future reference.
Managed user accounts and profiles, modified the Salesforce platform to meet the needs of the organization, troubleshot issues, and provided technical support to end users.

Business Intelligence Analyst

Freelance, Ontario, Canada
Nov 2021 - Apr 2022 · 5 months

Developed 3+ interactive dashboards and reports using Power BI by understanding business users’ requirements, gaining insights, making data-driven decisions, and exceeding stakeholders’ expectations.
Managed data sources and performed data cleansing and transformation on 40,000+ records using Power Query to ensure accuracy and consistency.

Senior Data Analyst

Capgemini, Chennai, India
Jun 2020 - Jul 2021 · 1 year 1 month

Generated custom Dag’s (Directed Acyclic Graphs) using Airflow to automate and schedule data pipelines by integrating with AWS S3 to fetch and store data using EC2 setup for Airflow.
Implemented complex SQL queries to extract 100,000+ records from snowflake data warehouse.
Designed Pl/SQL procedures in snowflake to perform slowly changing dimension type 2 operation which processes ETL by extracting data stored in AWS S3 to snowflake.
Built 5+ interactive dashboards and reports by connecting to a wide range of data sources and shared the insights to the customer in Power Bi visualization tool.

Data Analyst

Capgemini, Chennai, India
Jun 2019 - May 2020 · 11 months

Analyzed data sources, data mapping documents, and validated mappings to ensure the data was being stored as expected by comparing the data sources and increased 5% of efficiency.
Prepared and executed 50+ test cases to validate the ETL process to check the quality and reliability of data being loaded into the target system.
Collaborated with developers to create custom tables, views, and procedures in snowflake to adjoin specific business requirements and wrote 70+ SQL queries to review the results.
Produced 50% impact using Tableau for visualization and Informatica PowerCenter to gather data from Oracle, SQL server and flat files.

Skills

Cognos SQL Database SQL Server Reporting Services (SSRS) Power BI Snowflake GCP BigQuery Informatica PowerCenter Oracle MySQL MS SQL T-SQL Python SQL MongoDB C# Java C++ AWS S3 AWS EC2 AWS Lambda Apache Airflow Playwright Microsoft Power BI Tableau IBM Cognos Salesforce Sales Cloud Salesforce Service Cloud Salesforce Administration Jira ServiceNow Azure DevOps Microsoft Excel Microsoft PowerPoint Microsoft Word HTML CSS JavaScript XML SSRS SSMS Pl/SQL Power Query Agile ETL Data Warehousing Data Visualization Data Pipelines Automation Testing Quality Assurance Test Planning Data Cleansing Data Transformation Data Analysis
Report this Profile?