Tejaswi . Email & Phone Number

United States

• Designed, developed, and maintained ETL processes using T-SQL and SSIS for data extraction and loading into the data warehouse.• Created efficient Stored Procedures, Functions, Indexes, Tables, and Views, establishing T-SQL scripting standards.• Implemented Tableau BI Dashboard reporting solution and administered an enterprise-wide Tableau application.• Integrated Python scripts for data preprocessing in Power BI, enhancing data quality.• Built Pipelines in Azure Data Factory and utilized Azure Databricks for unstructured data transformation.• Developed SQL queries, stored procedures, and triggers for data retrieval, manipulation, and reporting.• Configured and maintained connections between Power BI and Apache Databricks data lakes, ensuring seamless data retrieval and synchronization for up-to-date reporting.• Led the design and implementation of T-SQL and SSIS ETL pipelines for financial data.• Optimized Power Query processes by minimizing data load times and enhancing query efficiency through meticulous management of query steps and data source settings.• Designed and implemented custom functions within Power Query to automate complex data processing tasks, increasing reusability and reducing manual effort across multiple reports.• Implemented version control for Power BI reports, SSIS packages, and SSAS models.• Designed interactive reports for common contact center processes, such as agent scheduling, adherence tracking, and call center quality assurance (QA) metrics, enhancing the visibility of operational KPIs.• Developed and maintained complex Crystal Reports for financial, operational, and performance analysis, ensuring data accuracy and integrity.• Integrated external APIs with Power BI using JavaScript to bring in real-time data from various web services and third-party applications.• Implemented real-time data updates in Power BI dashboards using JavaScript, ensuring that users always have access to the most current data.

United States

• Developed Tableau dashboards and visualizations, optimizing reports for better load times.• Collaborated with IT to enhance data warehouse capabilities and maintain data quality.• Developed SQL Server Stored Procedures, tuned SQL Queries using Indexes.• Created custom Python visuals in Power BI using Plotly and D3.js for interactive charts.• Built automated ETL processes using Pandas to handle data extraction, cleaning, and loading, ensuring consistent and accurate data for Power BI reports.• Integrated Pandas scripts into scheduled data workflows, preparing data feeds for Power BI without manual intervention.• Wrote complex SQL queries, views, and stored procedures for data retrieval and manipulation in SSRS reports.• Developed, designed, and deployed complex SQL Server Reporting Services (SSRS) reports. Created tabular, matrix, graphical, and free-form reports tailored to business needs.• Connected Power BI to Microsoft Dynamics ERP systems for real-time reporting.• Developed custom dashboards using Epic Radar, Epic's data visualization tool, and integrating them with Power BI for comprehensive healthcare performance monitoring, quality improvement, and strategic decision-making.• Utilized Alteryx to apply advanced analytics techniques like clustering, segmentation, and regression analysis before visualizing the outcomes in Power BI, enabling more sophisticated, data-driven business strategies.• Leveraged Power Query to integrate external data sources into Power BI, enabling comprehensive data analysis and insight generation from combined data streams.• Automated scheduled data refreshes in Power BI and paginated reports, ensuring reports are updated regularly without manual intervention.• Developed drill through actions in paginated reports, enabling detailed data exploration by linking summary views to detailed records.• Implemented complex DAX calculations for advanced data analysis in Power BI.

United States

• Implemented core business processes using T-SQL, Stored Procedures, and Functions.• Developed complex T-SQL code, including Stored Procedures, Triggers, Functions, Indexes, Tables, and Views.• Debugged T-SQL queries for performance tuning and ensured timely completion of ETL processes.• Created and modified T-SQL stored procedures/triggers for data integrity validation.• Developed SAS Business Intelligence reports and dashboards for critical business insights.• Created pipelines using Azure Data Factory and Azure App Services for data retrieval.• Designed ETL packages with SSIS, handling various data sources and transformations.• Developed interactive Power BI reports and dashboards for Microsoft Dynamics ERP data.• Modeled and transformed data from Microsoft Dynamics ERP for effective Power BI use.• Integrated diverse data sources into Power BI, including Dynamics ERP, SQL databases, Excel, and external APIs.• Integrated Power Apps with external systems using C# for seamless data exchange.• Integrated Azure Analysis Services (AAS) with Power Platform components.• Developed ETL processes for extracting and transforming data from Epic systems.• Developed and maintained scheduled jobs and batch processes using Oracle Scheduler and cron jobs, automating routine tasks and improving operational efficiency.• Integrated Oracle PL/SQL solutions with external APIs and web services using technologies such as Oracle REST Data Services (ORDS) and Oracle Database Gateways to enable seamless data exchange.• Created custom reports and dashboards using Epic Reporting Workbench and other tools.• Integrated Epic data with other healthcare sources for comprehensive insights.• Utilized Tableau, Power BI, or QlikView to create user-friendly healthcare analytics dashboards.• Implemented data governance practices to ensure healthcare data quality and security.• Employed Python for in-depth analysis of healthcare datasets and trend identification.

United States

• Involved in gathering the requirements and conducting meetings with clients. And documented the requirements and ITIL assessment & implementation of the project• Created new database objects like Stored Procedures, Functions, Packages, Triggers, Indexes, and Views using T- SQL in the Development and Production environment for SQL Server.• Created and Rebuilt the Clustered & non-Clustered indexes at regular intervals for better performance.• Expertise in designing, developing, and implementing mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETL development standards and conventions• Designed Data Mart using Star Schema. Reviewed the Current Data Mart and OLAP Cubes and Implemented Corrections and enhancements.• Developed interactive Power BI dashboards and reports that provide real-time insights into HR metrics, enabling informed decision-making for HR leaders and executives.• Collaborated with HR teams to understand project requirements and transform complex HR data into user-friendly visualizations.• Automated data extraction and transformation processes, reducing manual effort and ensuring data accuracy in HR reports.• Created and optimized SQL queries to extract and manipulate HR data from HRIS and other data sources.• ETL document developed for best practices and Reporting systems.• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from different data sources.• Used different data Transformations like Lookup, Derived columns, Conditional Split, and data conversion while creating the SSIS Packages.• Created several types of reports such as tabular, matrix, drill down, and sub reports using SSRS and sent the information to different clients, vendors and managers.• Created groups, roles, and users and assigned access privileges to users. Created various visualizations and reports in Power BI.

India

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, involved in Design,Development and testing of the system.• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.• Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.• Created SSIS packages to automate the ETL process included meta data on record count, file size and run time.• Wrote and edit SQL Queries for data base testing and report verification.• Developed SQL Server reports (SSRS) on daily performance of databases using SQL Server Reporting Services.• Worked on client requirement and wrote Complex SQL Queries to generate Reports.• Used DDL and DML for writing triggers, stored procedures, and data manipulation.• Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler.Skills: Windows Server, SQL Server 2010, SSIS, SSRS-2008, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler, MS Excel.