Srinivasarao Achanta

Email: ad4wft@r.postjobfree.com Tel: 901-***-****

SUMMARY

• Having 8+ years of experience in Development, Client Analysis, Database Design, Reporting, and Presentation using SQL Server 2008R2/2012/2014, SSIS, SSAS, SSRS, and Power BI.

• Experience developing Dashboard, Ad-hoc, and Parameterized Reports, creating complex reports (ex: drill- down reports using different objects) using SSRS.

• Experienced in Reporting tools SSRS, Crystal Reports, Business Object, and Visualization tools Power BI and Tableau.

• Good Experience in creating reports & dashboards with different types of tables, charts & graphs via Power BI Desktop

• Experience in designing, developing, and deploying Business Intelligence solutions using SSIS, SSRS, SSAS, and Power BI.

• Experienced designing Customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and Variables.

• Worked in the Agile Methodology using Microsoft VSTS leveraging the Scrum process to finish the tasks in the sprint time frame.

• Worked extensively on TIBCO Spotfire, Tableau, and Power BI Reports.

• Experience in developing BI applications using Power BI as a reporting tool.

• Experience in Power BI Report and Dashboard development.

• Expert in involving a variety of features using complex expressions to Calculate, Group, and Filter data in the report using SQL SSRS.

• Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Stored Procedures, UDFs, and Triggers using Microsoft SQL Server Management Studio.

• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

• Hands-on experience in creating cubes, perspectives, and deploying using SQL Server Analytical Services (SSAS).

• Expertise in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS) in Business Intelligence (BI).

• Good experience in creating OLAP cubes using SQL Server Analysis Services (SSAS).

• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snowflake modeling, FACT, and Dimensions Tables using MS Analysis Services.

• Experience in using ETL methodology for performing Data Migration, Extraction, Transformation, and Loading using SSIS and designed data conversions from a wide variety of source systems.

• Proficient in extracting, transforming, and Loading processes using SQL Server Integration Services (SSIS).

• Proficient in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS packages.

• Proficient in performing various SSIS data transformation tasks such as Look-ups, Fuzzy Lookups, Aggregate Functions, Merge Join, Conditional Split, Data Conversion, Derived Columns, Event Handlers, Error Handlers, etc.

• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources

(Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, and Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.

• Good understanding of Normalization, De-normalization, Normal Form, and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for the logical and physical design of databases.

TECHNICAL SKILLS

State Farm - Richardson, TX Jul 2023 to Present

Role: Sr Power BI Developer

• Creates reports using Power BI for SharePoint list items.

• Utilized Power BI (Power View) to create various analytical dashboards that depict critical KPIs along with slicers and dicers enabling end-users to make filters.

• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI with the decision-makers for strategic planning.

• Strong experience in Data Analytics tools such as Power BI, Tableau, Spotfire, QlikView, etc.

• Implemented automated report distribution through Power BI Reporting Services, enabling stakeholders to receive relevant reports regularly via email or other channels.

• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

• Created Power BI dashboard and generated reports.

• Assist in developing ITSM roadmap. Analyze and recommend emerging ITSM technologies that can provide benefits while reducing risk.

• Giving access to new users and maintaining Spotfire’s Servers

• Used Imports sets and Transform Maps to import data into Service Now.

• Performed Power BI Desktop Data modeling, which cleans, transforms, and mash-up Data from multiple sources.

• Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.

• Created reports on Power BI Desktop and published them on Power BI Report Server.

• Involved in Building Multi-Dimensional Cubes, Data Modeling, and OLAP Cubes using SSAS.

• Devises data verification methods and standard system procedures.

• Involved in the development and implementation of SSIS and SSRS application solutions for various business units across the organization.

• Developed effective data mapping and SQL scripts using Spotfire for efficient data extraction.

• Providing Data integration and data ingestion for the use cases required for the Palantir analytics.

• Used TFS ( Team Foundation Server) and visual studio team services ( VSTS) to share all the work, and code, to sort out the exceptions raised during work.

• Working on Palantir foundry tool to create contract entity modeling and design patterns for the automation of development and production environments.

• Used data transformation capabilities, allowing users to clean, filter, and reshape the data from Snowflake to suit their reporting needs.

• Utilized multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transforming it, and finally loading it into the staging database.

• Utilized TFS for version control and change management for cross-functional team communication.

• Implemented SSIS packages utilizing checkpoint, logging, breakpoint, and transaction options.

• Involved in creating Sub-Reports, Drill down reports, and Drill through reports and Tabular reports using SSRS.

• Involves in configuring and maintaining Report Manager and Report Server for SSRS.

• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs.

Data Handling Data wrangling, Data cleaning, Data mining, Data visualization, Data Governance, Master data management, ETL transformations, Model building, Big data, DBMS, BI, and Data Warehousing.

Databases SQL, MySQL, MS SQL Server, SQL Server 2016 PostgreSQL. Visualization tools Power BI, Tableau, MS Excel, Python-Matplotlib, and Seaborn libraries. Programming Languages Python (Numpy, Pandas, Seaborn, Scikit-learn), PySpark Machine Learning Regression, Clustering, Classification and Regression Trees, and Natural Language Processing.

Others SAP MM, SSRS, SAP

• Expert in creating and developing Power BI Dashboards with a rich look and configuring data gateways to have an automatic refresh of the data set.

• Data validation and quality check for data consumed by Palantir use cases.

• Created VSTS user stories using the INVEST model and led user story estimation efforts.

• Widely used SQL Profiler for investigating, checking, and enhancement of SQL Server and non-creation database code and in addition T-SQL code from engineers and QA.

• Developed Server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.

• Responsible for Migrating data from Multifarious Data Sources and legacy systems (Oracle DBS, Flat file, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS).

• Expertise in using ETL to implement the Slowly Changing Transformation, to maintain Historical Data in the Data warehouse.

UPMC, Pittsburg PA Aug 2022 – Jun 2023

Role: Sr. Power BI Developer

• Interface with users and project manager to ensure that implemented solutions satisfy business requirements and are delivered on time.

• Created SQL queries, and stored procedures, views, and functions as per requirements.

• Designed SSIS Packages in SQL Server 2016 to handle data migration (ETL Processes) from transaction System to Dimensional Model.

• Power BI experience in Designing interactive reports using Power Query, Power Pivot, and Power View.

• Created Power BI Dashboards using Different types of Slicers and different visualizations like Bar Charts Line charts, Scatter plots, clustered charts, and pie charts, etc.

• Verified back-end processing of the claims between Analysis Advance and McKesson total payment integration system audit tool.

• Implemented copy activity, Dataflow, and Trigger in Azure Data Factory pipeline activities for On-cloud ETL Processing.

• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files to SQL Server Database.

• Extensively worked on Dimensional modeling, Data cleansing, and Data Staging of operational sources using ETL processes.

• Involved in ETL processes, Data warehousing methodologies, and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Mart, and OLAP technologies.

• Build and deploy end-to-end ETL Process to load data into Data warehouse from flat files and source SQL databases using SSIS.

• Deployed web-embedded Power BI dashboards refreshed using gateways by using workspace and data source.

• Worked on performing incremental loads while transferring data from OLTP to the data warehouse using different data flow and control flow tasks in SSIS.

• Worked on creating dashboard and tabular reports using SSRS.

• Developed various reports using SSRS, which included writing complex stored procedures for datasets.

• Involved in planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.

• Involved in working with SSAS in creating data sources, data source views, named queries, cubes, roles, calculated columns, dimensions, and deploying analysis services projects.

• Used Power BI, and Power Pivot to develop data analysis prototypes, and used Power View and Power Map to visualize reports.

• Performed data modeling and analysis to identify key performance indicators (KPIs) and data relationships, ensuring accurate and efficient reporting.

• Designed and developed interactive Power BI reports and dashboards using Power BI Reporting Services to meet business requirements and provide actionable insights.

• Used Microsoft Power BI, and Power Query to extract data from external sources and modify data to certain formats as required in Excel and created SSIS packages to load Excel sheets from PC to database.

• Created basic reports using confidential files as a source to fetch the data in Power BI. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

• Used SSRS reports are used for creating Dashboards, drill-down reports, and Scorecards.

• Scheduled and monitored SSRS report subscription and deliveries such as Email Delivery and File Share Delivery as required.

• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

• Created various Excel reports using dropdowns and v-lookups connected to the SQL server.

• Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.

• Involved in Setting up new MS SQL Server instances and databases.

• Involved in Capacity planning of MS SQL Servers. Implemented and maintained database security.

• Going through the clients' requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.

• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.

• Wrote many stored procedures and Triggers as per client’s requirements.

• Ran DBCC consistency checks, and fixed data corruption in application databases. Environment: SQL Server, T-SQL, SQL Profiler, Azure, SSIS, SSRS, SSAS, Oracle, Query Analyzer, Power BI, Power Pivot, Windows, MS Excel.

Mindtree - Hyderabad, India Oct 2021 – Sep 2022

Lead Power BI Developer

• Analyzed batch processing performance and suggested improvements where appropriate.

• Involved in the development and implementation of SSIS and SSRS application solutions for various business units across the organization.

• Developed dashboards using Power BI.

• Used SSAS tabular Model for Power BI and Excel reporting applications.

• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI with the internal teams for strategic planning.

• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density charts.

• Created SSIS Packages to load data from sources like Flat files, Excel, OLEDB, and Oracle DBS to SQL Server.

• Scheduled jobs for executing the stored SSIS packages, which were developed to update the database daily using SQL Server Agent.

• Improved the performance of SSRS reports by tuning the Stored Procedures and T-SQL queries and created XML, PDF, and EXCEL files using SSRS.

• Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all Derived Column, etc.

• Created indexed views and worked on slow-running SQL queries to improve performance.

• Translated the Business requirements into workable functional and non-functional requirements at a detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams, and Use Case Modeling.

• Developed various reports like Charts, Tables, Matrix, Sub reports, and reports using single-value parameters, and multi-value parameters with Queried and Non-Queried parameters.

• Developed stored procedures using T-SQL to retrieve data and used it to generate ad-hoc reports.

• Created SSRS report templates for report development and mentored others in my team for complex SSRS reports.

• Created Clustered and Non-Clustered Index on tables for performance optimization of complex stored procedures.

• Created scheduled maintenance and backup procedures for the database as a disaster recovery method. Monitor failed and long-running MS SQL Server jobs.

• Data conversions and data loads from various databases and file structures.

• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

• Designed and created various business reports using SSRS 2012 versions.

• Created reports with stored procedures and involved scheduling and creating snapshots and subscriptions for the reports in SSRS.

• Designed and created various business reports using SSRS 2012 versions.

• Created reports with stored procedures and involved scheduling and creating snapshots and subscriptions for the reports in SSRS.

• Collaborate with stakeholders to gather requirements and ensure that the dashboards effectively meet the needs of end-users.

• Designed dashboards and reports using the live connection (PBI Datasets) for Baby care, hair care, and grooming care segments.

• Utilize live connections from the service to access real-time data sources and perform data modeling within Power BI.

• Provide actionable insights to stakeholders through data-driven storytelling and visualizations.

• Provide training and support to end-users on how to effectively use Power BI dashboards and reports to drive decision-making and monitor application performance.

• Conduct advanced analytics within Power BI using DAX (Data Analysis Expressions) and other analytical techniques to uncover insights and trends in the data.

• Develop and implement predictive analytics models to forecast future performance and identify potential issues before they occur.

• Collaborate with cross-functional teams including IT, operations, and business units to understand requirements and priorities for reporting and analytics.

• Communicate effectively with stakeholders to gather feedback, address concerns, and ensure alignment between business objectives and analytics solutions.

• Document data sources, data models, and dashboard designs to ensure clarity and maintainability of Power BI solutions.

Open Systems - Hyderabad, India April’2019 to Sept 2021 Microsoft Power BI Developer

• Developed and delivered 10 reports, while also managing the main dashboards that needed daily updates.

• Developed KQL queries in Azure Log Analytics to import data into Power BI.

• Written Complex KQL Queries with Join Conditions to get the data and use it as a source.

• Migrating old reports and automating the process with new designs and modeling in Power BI.

• Data transformations (Pivot, Unpivot, Filters, Handling Duplicates, Add Custom column, Split column, changing data types, Merge & Append Queries, Reference & Duplicate table. etc.) using power Query Editor.

• Based on the requirement various conditions in Power Query and Power Pivot.

• Designed interactive dashboards with drill-down, drill-through, page navigation, Sync slicer, Tooltip, and Bookmarks.

• Developed analysis reports and visualizations using DAX Functions.

• Implemented row-level security and data refresh strategies.

• Worked on On-Premises Gateway to refresh the data sources and schedule the data refresh as per business needs.

• Used Power BI Gateways to keep the dashboards and reports up to date.

• Published Power BI Reports from Power BI Desktop to Power BI Service/Workspace

• Embed report in the workspace to share Online portals Like SharePoint, website, and Teams.

• Documenting end-to-end process of report building along with business KPIs. Environment: Power BI, Azure SQL Server, Azure Active Directory, MDATP, MCAS, KQL, Azure Sentinel. Linkup Manpower – Hyderabad, India Jun 2016 to Mar 2019 Role: Power BI Developer

• SSIS (ETL) packages to validate, extract, transform, and load data from the OLTP system to the Data Warehouse.

• Designed and created MDX Queries to retrieve data from cubes using SSIS.

• Created Drill-through reports, parameterized reports, and linked reports using SSRS which were integrated with the Performance point server.

• Working knowledge in Dimensional Data Modeling and analyzing data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).

• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes, and dimension members using SQL Server Analysis Services (SSAS).

• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including status.

• Worked with the QA team on the reports documented all test procedures and worked closely with End users.

• packages to load data from the source system to the data warehouse.

• Built SSIS packages for dimensions and fact tables.

• Involved in scheduling and creating snapshots and subscriptions for the reports using SSRS.

• Scheduled the reports to run on a daily, and weekly basis in the report manager.

• Created Workspace and content packs for business users to view the developed reports. Environment: Power BI, MS SQL Server, SSIS, SSRS, T-SQL, Tableau, SQL Server Management Studio, Oracle, Windows.

Contact this candidate