Harshitha T Email & Phone Number

Minneapolis, Mn, Us

Minneapolis, Minnesota, United States

• Worked closely with Business Analyst, Data Modeller and all team within the organization to understand business processes.• Read source data from Azure SQL DB, CSV, ORACLE, and SQL Server through Power BI.• Read different formats of Source data from hive like JSON, ORC, and TXT.• Generated context filters and data source filters while handling large volume of data. • Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.• Used Z-order to overlap the reports on each other using Power BI.• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.• Created multiple data model and used as a common data source for the reporting purpose.• Used Power BI Gateways to keep the dashboards and reports up to date.• In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.• Involved with ETL team on transformation logic in the ELT (Azure) and migrating the SSIS packages to Azure Data factory (V2).• Closely worked with ETL to implement Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ELT processing

Chicago, Illinois, United States

• Requirement’s analysis and detailed functional design for the various blocks identified within the Perform data modelling using Star Schema to meet customer business and technical requirements. • Designed, developed reports and Dashboard Reports in Power BI Desktop and published to Power BI Web and working Power BI Pro.• Solid experience in building interactive reports, dashboards, and/or integrating modelling results and have strong Data Visualization design skills and analytic background by using POWER BI• Used Power BI tool to perform previously Excel done reporting to save time and energy.• Worked on various types of DAX functions like Date and time functions, Time-intelligence functions, Filter functions, Information functions, Logical functions Math and Trig functions, Parent and Child functions, Statistical functions and text functions.• Created graphical dashboards and reports in Power BI.

Chicago, Illinois, United States

• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Power BI.• Building Ad-Hoc reports in Power BI depending on Business requirements is one of the major responsibilities.• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (MDX Query), Web Trends to Power BI and generate reports with different visualizations.• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.• Created bottom count, top count, cross join, non-ascendants, log MDX queries for creating Calculations and KPI’s on a cube.• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.• Designed a Data Model with multiple Fact Tables and Dimensions depending on the business requirements.• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.• Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.

Jacksonville, Florida, United States

• Responsible for gathering/refining requirements from the customer for developing reports in Power BI.• Built Data Analytics or visualization using Power BI (Power View integrated with Share Point).• Worked with DAX/MDX queries in building expressions for various business calculations.• Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.• Involved in Developing Power BI visualizations and dashboards using Power BI Desktop.• Created Grouping, sorting columns and writing expressions according to the business requirements.• Transferred the data using SSIS packages.• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.• Created SSIS packages to Export data from text file to SQL Server Database.• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.

Bloomington, Illinois, United States

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.• Involved in Normalization of the database and bringing it to 3NF.• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.• Created ER diagrams using Visio.• Created Non-Clustered indexes to improve query performance and query optimization.• Involved in the performance tuning and optimization of T-SQL queries.• Responsible for Data migration from SQL Server 7.0 to SQL Server 2000 Databases.• Developed user requested reports using Crystal Reports and Excel.• Created Drill down and Drill through reports using Crystal Reports.• Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.• Involved in creating, deploying and configuring reports according to the requirements.• Involved in writing scripts for the client’s requirements for generating reports.• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers. Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.• Involved in creating, deploying and configuring reports according to the requirements.• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.

Hyderabad, Telangana, India

• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes• Installed and configure servers and clients using SQL Server 2008, Upgraded SQL databases• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards• Knowledge of Database Performance monitoring tools• Created packages in SSIS with error handling and worked with different methods of logging in SSIS• Created ETL SSIS packages both design and code to process data to target databases• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.• Implement automated Index Maintenance strategy run as SQL Job on a daily basis.• Resolving any dead locks issues with the Databases/Servers on a real-time basis.