Prema V Email & Phone Number

Pleasanton, California, United States

• Created a report in Power BI using import mode and pre cleanse the date using power query editor, published in Power BI Service. • Leveraged API integrations to automate data retrieval from different data sources, ensuring real-time data updates.• Created custom KPI scorecards to help end users visualize metrics according to their preference.• Responsible for building reports in Power BI from Scratch by pulling data from different sources.• Creating Row level securities and integrating with Power BI service portal.• Worked on analyzing existing Tableau reports where data is retrieved from MySQL.• Worked closely with data analysts to understand data requirements for API integrations.• Worked on migrating Tableau reports to Power BI reports that are needed to create from scratch• Responsible creating general SOP for best practices of Power BI and uploaded in SharePoint • Involved in creating the SharePoint site for IMOP (Incident Management Operations Portal) for capturing key incident details and SharePoint site design for Daily Health Check for KPI status.• Created data modeling star schema in Power BI desktop after loading data table from SQL database• Used Power BI to extract data from different sources such as SQL Server, Excel, CSV files, load cleaned the data and loaded it into the Power BI canvas for visualization and analysis.

New York City Metropolitan Area

• Gather requirements from the user and find those required tables, data elements from the data source SAP by Design.• Analyze and mapped the required data element from data source SAP by design with the SQL database • Used Power BI desktop to directly connect to database tables (Direct Query Mode) or import the files into Power BI (Import Mode)• Deployed report into Power BI service from Power BI desktop in to UAT workspace and into the Production workspace and created APP as well.• Collaborated with IT and software development teams to design and implement API solutions.• Responsible as Power BI administrator in granting access to the user to the required report in Power BI service, creating Workspace, creating Workspace APP for distributing report to large number of users.• Documented BRDs, SOP, Mapping documents and User Guide as well.• Worked on retrieving data from Google Analytics to Power BI through import mode and created a report• Worked on testing the reports and debugging and analysis the data as well• Used Power Automate for automating excel data files receiving via outlook email to SQL server.• Used Power BI to extract data from different sources such as SQL Server, Excel, CSV files, load cleaned the data and loaded it into the Power BI canvas for visualization and analysis.• Responsible for building reports in Power BI from Scratch.• Created data modeling star schema in Power BI desktop after loading data table from SQL database • Extracted required data tables, data elements from SAP by design into excel and analyzed the data• Created views in SQL and connected to Power BI desktop using Import Mode• Worked on creating view overview for few customized reports and visualized.• Using office 365 application prepared presentation in power point, documents using word and excel as data source.

New York, New York, United States

• Used Power BI desktop to directly connect to database tables (Direct Query Mode) or import the files into Power BI (Import Mode)• Developed documentation for business requirements, functional and technical specifications, and development standards for assigned projects and applications.• Used Power BI to extract data from different sources such as SQL Server, Excel, CSV files, load cleaned the data and loaded it into the Power BI canvas for visualization and analysis.• Involved in creating notebooks for moving data from raw to stage and then to curated zones using Azure Databricks.• Analyzed the Business Requirement Document (BRD) to design a conceptual model, participate in all phases of SDLC process to implement T-SQL, SSIS, SSAS and SSRS to develop a solution.• Designed reports utilizing custom filters and DAX expressions with Power BI, and written DAX Expressions, Power Query and Functions in Power BI• Created database links and accessed the data through SQL statements.• Analyzed source system data to assess data quality, worked with technical and business representatives to determine strategies for handling data anomalies that are identified.• Carried out administrative tasks on DOMO like adding/maintaining users and groups, scheduling reports, setting up presentations directly on Microsoft Excel and PowerPoint using DOMO plugins.• Designing current databases by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries.• Created hierarchies in Power BI to help end users make accurate decisions based on the visualizations.• Assigning Power BI Pro license to the users, configuring role base security by creating different roles in Azure Analysis services and providing access to app workspaces and apps.• Created custom KPI scorecards to help end users visualize metrics according to their preference.

Dover, New Hampshire, United States

• Developed Power BI reports and dashboards from multiple sources using data blending.• Explored data in a variety of ways and across multiple visualizations using power BI.• Performed and worked with dimensions, measures, DAX and, MDX queries.• Designed attractive dashboards with visualizations such as maps, funnel chart, waterfall charts and word cloud in Power BI.• Assisted in production and non-production OLAP cubes, wrote queries to produce reports using SQL server, SSAS.• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.• Creating gateways in power BI.• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.• Enhance and modify Power BI dashboard to make it understandable for different audiences.• Implemented Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.• Designed, developed, deployed and processed Tabular Models using Azure Analysis Service, MS Excel for less than one million Journal Entries.• Designed and created data extracts, supporting SSRS, Power BI or other visualization tools and reporting applications (Power BI).• Developed SQL queries to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.• Developed complex SQL Views, Common Table Expressions, and Temporary Tables• Created & maintained data sources in Cognos connection and used Framework manager's best practices to create models, publish packages, designed several reports using Cognos Report Studio on EDW environment.• Provided maintenance and development of bug fixes for the existing and new Power BI Reports.• Involved in generating and maintaining SQL scripts.

, New York City, Ny

• Coordinating with business users in analyzing business requirements and translating them to technical specifications.• Discussion with team to come up with the best possible visuals to show the requirements.• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.• Used Set Analysis and various QlikView and Qlik Sense functions in writing expressions for sheet objects.• Published Power BI Desktop to the cloud.• Involved in ETL processes and develop source-to-target data mappings, integration workflows, and load processes.• Created logging to check the status of each pipeline and Data is moved to Azure Data Warehouse from azure storage.• Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.• Utilized Power BI Gateway to keep the dashboards and reports up to date.• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.• Created many complex Query's and used them in Power BI Reports directly to generate reports on the fly.• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.• Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.• Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.• Implement the SAP Business Objects reporting requirement.

Radnor,Pa

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.• Utilized the Agile Scrum methodology to analyze the requirements to create stories.• Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently.• Extracted data from excel and created reports using SSRS.• Involved in developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure and scheduling the cube through Azure Automation Runbook.• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.• Developed Reports with Excel, SQL Server, SharePoint List and Report Server data sources using tableau.• Experience in Data Analysis, understanding trends and patterns in data.• Transformed and combined the data using tableau prep builder and created dashboards using tableau Desktop.• Published dashboards on an intranet site using SharePoint Server.