Venkat Praneeth

Responsibilities:

• Gathered report requirements and determined the best solution to provide the results in the Reporting Services report or Power BI.
• Created reports using stored procedures and was involved in scheduling and creating snapshots and subscriptions for the reports (SSRS 2019).
• Extensive experience in configuring and managing gateways in Power BI to establish secure and reliable connections between on-premises data sources and the Power BI service, enabling real-time data access and updates.
• Implemented Direct Query solutions in Power BI, and configured Dataflows to automate data preparation, transformation, and enrichment processes, streamlining data integration.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2019, and Flat files.
• Wrote complex SQL Queries, Dynamics, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Indexes, Views, and Cursors to implement the business logic.
• Leveraged dbt(data build tool) to define and execute data transformation pipelines in SQL.
• Experience in various Extracting, Transforming, and Loading (ETL) processes using SQL Server Integration Services (SSIS), including designing, and implementing SSIS data flow tasks.
• Leveraged Python in conducting performance tuning and optimization activities to enhance ETL process efficiency and minimize processing times.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Designed and developed complex reports such as Drill down, Drill Through, and Cross Tabbed using MS Reporting Services.
• Utilized GitLab for version control of Power BI reports, SQL scripts, and data transformation pipelines built with dbt ensuring data consistency and quality.
• Established continuous integration/continuous deployment (CI/CD) pipelines in GitLab to automate the deployment of dbt models and Power BI reports.
• Worked on POC to migrate existing on-premises BI platform to Azure Cloud
• Created technical documentation of various staging area operations for future guidance.
  

Responsibilities:

• Analyzed pharmacy data, including patient outcomes and medication adherence, to identify trends, challenges, and opportunities for improvement.
• Contributed to the development of predictive models and analytics to improve patient care and business outcomes, leveraging Python and other tools as needed.
• Capable of handling ad hoc requests for pharmacy, medical expenses, and enrollment data by leveraging SQL queries and Power BI capabilities.
• Published Power BI Reports and made Power BI Dashboards available to web clients.
• Gathered report requirements, connected with business, and conducted brainstorming sessions.
• Involved in creating data visualizations like Clustered Column charts, Line charts, Slicer, Gauge visualizations, etc. with Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to date with on-premises data.
• Extracted data from the internal data warehouse system to SSRS, Designed SNOWFLAKE Schemas
• Integrate Power App with Power BI to enable the write-back feature from Power BI.
• Worked on DAX query to create calculated columns and measures based on Requirements.
• Involved in System Integration Testing, UAT testing, bug fixing, and documentation of the project.
• Building the pipelines to copy the data from source to destination in Azure data factory (ADF V1)
• Creating multiple data sets in Azure worked in the migration of SQL Server to SQL Server 2019.

Responsibilities:

● The project is designed in two-phase data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS), and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms.

● Part of cross-functional Agile and SDLCproject teams, influencing project scope to deliver effective and efficient solutions promptly.

● Responsible for Data Modeling based on the client requirements, daily maintenance, and performance tuning.

● Developed Tabular Reports, Matrix Reports parameterized Reports Sub reports, Snapshots, and Adhoc reports (SSRS).

● Developed physical data models using ERWIN/ ER Studio and created DDL scripts for database schema and objects.

● Design and implementation of SSIS/ETL process for the system.

● Data conversion from mainframe system and Oracle databases to SQL server.

● Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing, and Production Environments.

● Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

● Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

● Scheduled Jobs for executing the stored SSIS packages which were developed to update the database daily.

● Designed and developed different types of reports including Tabular forms, Dashboards, Matrix (cross Tab report) forms, Conditional, List items, Charts and Sub reports, custom reports, and drill-down reports using SSRS.

● Developed Key Performance Indicators with SQL Server Reporting Services (SSRS) and Power BI

● Responsible for Deployment of the report to the report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

● Uses of power pivot, and red gate tools for different purposes.

● Leveraged Aurora's compatibility with MS SQL to migrate existing SQL applications to the cloud.

● Integrated S3 with SQL tools and applications for data ingestion, export, or archival purposes

Maintain security, assign logins, permissions, and support problems related to Active Directory