RAMYA KRISHNA ATLURI

Data Engineer/Power BI Developer

ad1j8k@r.postjobfree.com +1-940-***-****

www.linkedin.com/in/ramya-krishna-atluri-413a45109

Professional Summary:

●Overall 8+ years of professional software development experience in the areas of Microsoft Business Intelligence (MSBI) and Having Knowledge in Data Warehousing (DW) applications primarily using Microsoft SQL Server.

●8+ years of experience in Power BI reporting which includes DAX and Data Models.

●Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.

●Experience in building SSIS Packages and ADF Pipelines and scheduling them.

●Part of Project Automation & Data Architecture teams with Knowledge on multiple technologies and strategies used to Extract and Export the data.

●Created Chatbots and Copilot by Microsoft Power Virtual Agent to answer the Q&A on the existing dashboards/reports and Apps in the Team.

●Experience connecting to and extracting data from multiple data sources like Azure Data Lake Store, SSAS, Azure SQL DB, SharePoint and PowerApps.

●Experienced in using Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.

●Having good Experience in Designing and Developing the SQL Server Integration Services - SSIS Packages with different Control Flow Tasks and Data Flow Transformations, Securing Packages and Deploying the Packages.

●Experience with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.

●Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for on-cloud ETL Processing.

●Experienced in Data Warehouse concepts. Having knowledge on SQL Server Analysis Services – SSAS and Azure Analysis Services - AAS.

●Equal competence Integration Services, Reporting Services and Analysis Services.

●Hands-on experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).

●Experience working with SSIS Catalog Database and Data Mapping Environments.

●Experience in scheduling and deploying reports on Report Manager.

●Knowledge of Data Warehouse concepts like Star Schema, Snowflake, Dimension and Fact Tables.

●Highly motivated, quick learner and extremely versatile. Accepts responsibilities and job duties eagerly with minimal supervision required.

●Implementing and maintaining existing Reports and Dashboards.

●Good knowledge of Subqueries, Joins, Views, and Sub Queries.

●Hands of experience in creating Jobs, Alerts and Scheduled SSIS Packages from SSIS Catalog Database.

●Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing, and maintenance) using Waterfall and Agile methodologies.

Technical Skills:

●Database Tools: SQL Server Integration Services SQL Server Analysis Services (Tabular Model, DAX, MDX OLAP Cubes), SQL Server Reporting Services, PgAdmin, Azure Database, Azure Data Lake Store.

●Development skills: T-SQL, PL/SQL, PostgreSQL, SSIS, Power BI, PowerApps, Power Virtual Agents, Power Automate, Power Flow, ADF

●Languages: DAX, M Query’s, R

●Reporting Packages: Power BI, SQL Server Reporting Services, PostgreSQL, MS Excel.

Professional Experience:

Microsoft, TX March 2021 - Present

Sr Power BI Developer

Responsibilities:

Comprehend business requirements in a BI context and developed 23+ data models to convert raw data into actionable insights.

Expertise in creating and developing Power BI dashboards into rich look.

Expertise in OLAP and OLAP Cubes in SSAS.

Developed KPI Score cards using Power BI to various dashboard’s and presented to stakeholders.

Developed 40+ reports by utilizing knowledge of SQL Queries, Azure Data Lake, SSIS, SSAS Subes, Power BI data sets, SharePoint, Dataverse and various other sources.

Customized Power BI dashboards upon business requirement to enable round trip from Power BI to Power App (to submit an input) and pull that submission to the BI Dashboards instantly.

Collaborated with business users, collected requests, and updated the set of existing BI Reports to accommodate business needs.

Used Advanced DAX. M Query to build custom measures to satisfy the user requirements.

Built Various Power Apps and Power Automate flows that act as an automated email process to the users and collaborated the data to visualize in the Power BI Dashboards.

Also developed Chatbots and Copilots by Microsoft Power Virtual Agents to answer the basic Q&A about the existing dashboards/reports and Apps to the user group.

Added the Bots to Teams, Teams Channels and embedded to SharePoint Site for better collaboration and user friendly.

Maintained and administrated all the existing dashboards/reports.

Built RLS based on Microsoft User Geo Access for all the reports.

Worked with Azure Data Lake Store to capture data of any size, type, and ingestion in one single place for different operations.

Worked on all types of transformations that are available in Power BI Query Editor.

Created Stored Procedures and SQL Queries to pull data into Power Pivot Model.

Scheduled Automatic refresh in Power BI Service using API.

Highly responsible for Data transformations from various formats to company formats.

Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.

Tested Reports and fixed bugs on weekly basis.

Analysis and improvement of Reports Performance.

Optimized various Dashboards and Data Models to reduce the refresh time from 2 hours to 7 minutes.

Environment: MS Power BI, Power Automate, Azure Data Lake, Power Apps, Power Flow, Microsoft Power Virtual Agents, SharePoint, SQL, SSAS, Dataverse

PwC, TX Feb 2020 - Feb 2021

Technology Lead

Responsibilities:

Created Row level and High-Level Security for the data and reports on Power BI.

Importing data from multiple Sources to Power BI using SSIS, PostgreSQL Database, SharePoint, Power Apps, Azure Data Factory (ADF) with Sources

Scheduling Pipelines and Packages in ADF and SSIS.

Knowledge leveraging Common Data Service for scalable and secure data stores with a common yet extensible schema as part of the Business Application Platform, for PowerApps, Power Automate Flow and Power BI.

Created Custom Measures, Columns and Tables using DAX and R in Power BI

Optimized Various Dashboards to cut down the Refreshing time, Query tuning with the real time data capture.

Part of the PowerApps and Power Flow team, building a family of applications that aim to dramatically simplify the creation and consumption of visually stunning, behavior-rich apps for clouds and any device.

Designed dynamic row level security with different levels of users utilizing complex DAX functions.

Used M Query and DAX for creating custom measures, columns, and tables in Power BI.

Manages Interactions and Relationships between the tables extracted from source data in Power BI.

Maintained, Troubleshoot and fixed day to day bugs.

Works on Drill Down and Drill though for the Reports created.

Created Extensive User-friendly reports using Bookmarks.

Schedules Refreshes and creates notifications, Alerts for the Reports once published into the Power BI Service.

Extensively used PostgreSQL scripting to prepare the data as per the requirement for Business needs.

Optimized Old Dashboards with PostgreSQL scripts for faster refreshes.

Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split and transform.

data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task in SSIS.

Actively participated in meetings with multiple business units and end users from many disciplines to ensure that developed and integrated systems meet their needs.

Creating complex queries for report development against relational and multidimensional database systems using PostgreSQL and MDX for SQL Server Analysis Services.

Designed and Maintained SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.

Environment: MS Power BI, SQL Server 2012, SSMS, SSIS, Visual Studio, Windows 10, PostgreSQL, PgAdmin, Power Apps, Power Flow.

Concentrix, Hyderabad July 2017 – Jan 2019 Sr. BI Analyst/Data Engineer

Responsibilities:

●Imported data from Excel, SQL Server DB to Power BI to generate reports.

●Created Dax Queries to generate computed columns in Power BI.

●Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

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

●Creating Row level security with Power BI and integration with power bi service portal.

●Developed profit analysis reports and dashboards by products and customers.

●Developed by implementing new emerging Microsoft-related technologies like PowerApps, Flow, and Power BI.

●Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.

●Worked on all types of transformations that are available in Power BI query editor.

●Scheduled Automatic refresh and scheduling refresh in Power BI service.

●Developed dashboards, analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions for Data Manipulation.

●Manages Interactions and Relationships between the tables extracted from source data in Power BI.

●Used M Query and DAX for creating custom measures, columns, and tables in Power BI.

●Created Drill Down Reports, Drill Through Report by Region.

●Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

●Created SSIS packages to import data from Excel, OLE DB Source and Flat Files.

●Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.

●Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.

Environment: MS Power BI, SQL Server 2012, SSMS, SSIS, SSRS, SSAS, Visual Studio, Windows 7, MS Word, MS Excel.

Wipro, Hyderabad Aug 2014 – July 2017

Data Engineer

Responsibilities:

●Highly responsible for data transformation from various formats to company’s formats on a weekly basis. Managed external client project contracts from technical consultation to delivery of projects.

●Involved in Planning, Defining and Designing database based on business requirements and provided documentation.

●Implementation, Requirements gathering and understanding the business flow.

●Designed the Functional Requirements and Mapping Technical Specifications based on Functional Requirements.

●Creating Index, Views, Complex Stored Procedures, Triggers, Cursors, and appropriate User defined functions to implement the business logic.

●Creation of database tables and procedures to update and clean the old data.

●Transferred data from flat files, Excel spreadsheets, and XML Source data to SQL Server using SSIS.

●Designed dashboards, including scorecards, and reporting with the Dashboard Designer.

●Involved in data modeling for the application and created an ER diagram using Erwin.

●Created, Maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports, Drill Down Report, Drill Through Report using SQL Server Reporting Services SSIS.

●Designed, managed, and published various reports using SQL Server Reporting Services 2012 and Power BI.

●Extract datasets from different data sources including SQL Server, excel and flat file prepare datasets for Power BI.

●Proficient in and designing Data Mart and Data Warehouse using Erwin in Star and Snowflake Schemas.

●Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server.

●Developed and managed dashboards using Power BI.

●Used M Query and DAX for creating custom measures, columns, and tables in Power BI.

●Manages Interactions and Relationships between the tables extracted from source data in Power BI.

●Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

●Installed MS SQL Server and Management tools using SQL Server Setup Program.

●Coordinated with DBA in creating and managing tables, indexes, triggers, DB links and privileges.

●Designed, created, and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.

●Created document for Self-Service Deployment and Execution process for SSIS packages.

●Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.

●Responsible to tune ETL procedures and schemas to optimize load and query Performance.

Environment: Microsoft SQL Server Management Studio, SSIS, SSAS, SQL Server, MS Word, MS Excel, MS Power Point, Visual Studio, MS Power BI.

S&P Capital IQ, Hyderabad May 2014 - Aug 2014

Software Developer

Responsibilities:

●Enhanced ERMS which is used to automate the recruitment process in the company.

●Gathered requirements from business users.

●Wrote user requirement documents based on functional specification.

●Designed software architecture using .NET and C#.

●Responsible for backup and restoring databases.

●Simple SQL Queries to extract the data from the database and use it for software development.

Environment: .NET, C#, Microsoft SQL Server and Windows.

Educational Qualification: Bachelor of Technology in Information Technology, Hyderabad - 2014. (Scored 75%)

References: Available upon Request.

Contact this candidate