Asritha Bhagavathi

• Design scalable and efficient BI solutions, including data warehouses, data lakes, and visualization tools.
• Developed scalable ETL pipelines using SSIS, Informatica- to reduce data processing
• Created intuitive dashboards and reports using Power BI, Tableau, Looker Studio and Qlikview depicting KPI's and increasing visibility to stakeholders using visualization dashboards.
• Led a team of BI developers, ensuring timely delivery of BI projects and adherence to best practices in data modeling and visualization.
• Implemented advanced analytics solutions- like predictive modeling and trend analysis
• Collaborated with stakeholders to gather requirements and improve decision-making
• Developed and maintained logical and dimensional data models, supporting efficient data extraction and ad-hoc analysis for stakeholders.

Tech Stack: Power BI, Tableau, QlikView, Looker, AWS, Azure, Google Cloud (GCP), SQL , SQL Server

• SQL: be able to write queries from scratch, Data validation, Querying the Database
• Understanding financial data within the DB
• Worked on SQL Querying -data discovery for the BI Intelligent Reporting team.
• Experience in Google cloud platform, Hadoop clusters and Hive, SSMS ,Power BI and Tableau
• Data analysis on Power BI, Tableau dashboards
• Monitoring BigQuery, Dataproc and cloud Data flow jobs for all environments.
• Synthesizing data into analytics datasets to support project goals; developing statistical models and computational algorithms to analyze and describe the data and its characteristics
• Involved in development of Web Services using REST API’s for sending and getting data from the external interface in the JSON format.
• Analyzing data based on identified variables; reviewing data results with team members to ensure accuracy and communicating results and insights to the project team and business partners.

• Understand business requirements in BI context and design data models to transform raw energy data into meaningful insights
• Create Power BI dashboards and dashboarding system using Google Cloud Platform (GCP) technologies - App Engine, DataStore and BigQuery
• Identify key performance indicators (KPIs), analyze data and present data through reports that aid decision-making
• Chart creation and data documentation explaining algorithms, parameters, models, and relations
• Design star schema in BigQuery ; Design, develop, test, and deploy Power BI scripts and perform detailed analytics
• Perform DAX queries and functions in Power BI; Create customize charts and custom calculations as per requirements
• Involved in development of Web Services using SOAP for sending and getting data from the external interface in the XML format.
• Design and engineer REST APIs and/or packages that abstract feature extraction and complex prediction/forecasting algorithms on time series data

Tech stack: PowerBI, Dashboarding and reporting, Python, ETL, AWS (S3, Athena, Redshift, Glue,EMR), SQL/Oracle, Big data – Hive, Data lakes. +, Collibra-Power BI Connector

[Same as Insight Global work experience]

• Involved in business requirement gathering from the end users and convert into Technical aspects by providing optimal solutions and technical specifications
• Using G-Cloud function with Python to load Data into BigQuery for on arrival csv files in GCS bucket.
• Involved in the P2P- Data gathering, data cleansing, data transformation and data integration developing data models.
• Develop data mappings using Informatica PowerCenter for various sources and target tables
• Development of high level data dictionary of ETL data mappings and transformations from a series of complex Talend data integration jobs.
• Implemented custom error handling in Talend jobs and worked on different methods of logging.
• Schedule Talend Jobs using Job Conductor (Scheduling Tool in Talend) - available in TAC
• Responsible for ETL activities, handling data using Toad, Master Data Governance and Oracle
• Extract heterogeneous data from Birch street and Sysco Catalogs and transform to data required by customer
• Develop Shell and Python Scripts for master data files archiving
• MS Excel for data analysis, MS Visio, Draw-IO for workflow of diagrams

• Involved in business requirements gathering from the end users and converting into Technical aspects by providing optimal solutions.
• Performed GAP analysis for building data mart, involving into housing goal scoring and reporting projects.
• Responsible for database, ETL development activities and handling production support for the operational data loads utilizing SQL Server, Oracle, SSIS and SQL Agent.
• Created Qlikview dashboards and reports for sales group by connecting Oracle database
• Responsible for creating and maintaining various database objects like Stored Procedures, Views, functions, Triggers and Constraints etc. to meet the needs.
• Responsible for implementing Unit testing and performance improvement purposes.
• Used Hibernate, object/relational-mapping (ORM) solution, technique of mapping data representation from MVC model to Oracle Relational data model with SQL-based schema

• Implement technical solutions into design, development, deploy, Test into different environments by utilizing SQL Server and Visual studio and excel.
• Responsible for performing Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS and load the data into target table by using Data Stage
• Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports using SSRS.
• Designed Report Templates, Bar Graphs and Pie Charts based on data.
• Experience in querying data for Creating On-demand Reports using Report Builder in SSRS and send the reports via email.

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in the Development and Production environment for SQL Server.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and maintaining logs.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.