Tejaswini D
Business Intelligence Developer @CGI
Signup · Get unlimited contacts
WORK HISTORY
Business Intelligence Developer @CGI
ON, CA
Collaborated closely with business stakeholders to identify and document user requirements, ensuring the development of Power BI solutions aligned with their needs and goals.•Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.•Involved in data mapping sessions to identify data sources and created source codes in SQL server to feed the data visualizations in Power BI. •Effectively used data blending, filters, actions, and hierarchies feature in Power BI.•Analyzed the data using Statistical features in Power BI to develop trend analysis.•Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.•Successfully integrated custom visuals based on business requirements in Power BI desktop.•Created complicated reports such as parameter-based reports, graphical reports, excel reports, drill-down chart and tabular reports using SSRS.•Administrated and scheduled data-driven mailing subscriptions on SSRS Reporting Server.•Generated and scheduled on-demand reports for business analyses and management decisions with SSRS•Automating the database maintenance tasks by creating Jobs through SQL server agent.•Utilized Power BI to create various analytical dashboards that depict critical internal KPIs such as billing accounts receivable and payable, customer retention and, vouchering with slicers and dicers enabling end-user to make filters for sales, marketing, finance including top executives.•Expertise in writing complex DAX functions, measures, calculated columns, aggregations in Power BI.•Scheduling tasks on windows task scheduler to run the Python scripts to generate reports for frequent interval of times and send email alerts. •Designed, developed, and Implemented code in Python to retrieve and manipulate data.•Transformed raw data into MySQL with custom-made ETL application to prepare unruly data for machine learning.
EDUCATION
JNTUH College of Engineering Hyderabad
Bachelor's degree
ABOUT TEJASWINI D
Over 4 years of IT experience with expertise in analysis, design, development and implementation of data warehouses, data marts using Power BI, SSRS, ETL Tool (SSIS) and RDBMS like MS SQL Server 2014/16/19, Azure SQL, MySQL Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps. Expert in Data Preparation and Data Modeling. Skilled in performing data parsing, data manipulation and data preparation with methods including describing data contents, compute descriptive statistics of data, regex, split and combine, Remap, merge, subset, reindex, melt and reshape. Worked under Agile Methodology throughout the project, performed decisive role in developing & planning as well as coordinating with assigned sprints. Experience in writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as tables, views, indexes, complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs). Extensive knowledge of data warehouse methodologies Proficiency in Database design, Coding, unit testing and Implementation. Hands on Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views. Hands on Experience working with Azure Data Lake Analytics to analyze the structured, non-structured data from various sources. Involved in creating Jobs, SQL Mail Agent, Alerts and Scheduled DTS/SSIS Packages. Adept in creating Ad-hoc, Crosstab, Drill-down and Sub-Report using RDL in SSRS Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS). Extensive experience writing SQL queries, stored procedures, triggers views and programs. Expertise in Power BI Desktop, Power BI Service with Pro and Premium capacities. Experience in ETL processes involving migrations and in sync processes between two databases. Strong experience in creating advanced chart types, visualizations. Experience in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports. Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL Query/ T-SQL /MS Excel. Experience in utilizing Tableau visual analytics and generating reports using Tableau visualizations like bars, lines, pies, scatter plots, heat maps, bubbles etc. Good experience with Oracle, MS SQL Server, MS Access.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.