Hari Priya Email & Phone Number

Parsippany-Troy Hills, Nj, Us

Ohio, United States

Developed SSIS Templates that can be used to develop SSIS Packages in such a way that they can be dynamicallydeployed into Dev, Test, and Production Environments. Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables. Used recently introduced Power BI to create self-service BI capabilities and use tabular models. Responsible for building reports in Power BI from Scratch. Established and managed a data lake infrastructure to store and analyze large volumes of structured andunstructured data from diverse sources, facilitating comprehensive BI insights. Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests. Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries. Experience in publishing Power BI reports on dashboards in the Power BI server. Created hierarchies in Power BI reports using visualizations like Bar charts, Line charts, etc.

Morris Plains, New Jersey, United States

Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures, and triggers. Generated periodic reports based on the statistical analysis of the data from various time frames and divisions using power pivot, power query, and power view. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards. Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI with the decision-makers for strategic planning. Gathering the requirements and writing the ad-hoc SQL query batches to update the data and metadata for delta and history loads. Utilized (Power BI, Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.

Schaumburg, Illinois, United States

Participated in daily scrum meetings with the team to discuss the challenges and development of the project. Involved in requirement gathering from business users and IT teams to understand and express business processes and business logic. Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc. Extracted data from the data warehouse server by developing complex SQL statements using stored procedures and common table expressions (CTEs) to support report-building. Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.

Hyderabad, Telangana, India

Extensively used Informatica Power Center 10.X/9.X for transforming and loading data from various sources involving flat files and relational databases.Developed, modified, and optimized SQL Plus, PL/SQL, and SQL Loader scripts for data conversions, ensuring data quality and efficiency.Developed SQL, PL/SQL, and SQL Plus programs required to retrieve data using cursors and exception handling.Involved in the development of Informatic mappings and tuned for better performance.

Hyderabad, Telangana, India

Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting, and scorecard/dashboards on SQL Server 2008 using SSAS, SSIS/DTS, and SSRS. Migration of DTS packages to SSIS packages. Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports, and parameterized reports to provide visible data for data analysts and businesses using SSRS. Built daily, weekly, and monthly graphs and charts of loan data using R and Stored Procedures. Involved in designing, developing, and testing the ETL strategy to populate the data from various source systems using SSIS.