Shivani Agarwal

• Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
• Created and automated data visualizations to present insights and tell compelling stories.
• Leveraged text, charts and graphs to communicate findings in understandable format.
• Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms.

• Developed and implemented Power BI reports utilizing advanced features to enable Judges and internal teams to track case performance; reduced average case resolution time by 10% and increased team productivity about 15%

• Added Buttons to provide a pop-up security message to the users for additional security.

• Using Python, captured data from various county Jail data websites and loaded it into the data mart.

• Created ETL process in Visio studio and then used SSIS packages to load data from excel files to the SQL server.

• Identified, analyzed and interpreted trends or patterns in complex data sets.
• Utilized data visualization tools to effectively communicate business insights.
• Participated in requirements meetings to understand business needs.
• Recommended new strategies based on data-driven analysis resulting in saving $12,000 from a single grant.

• Participated in requirements meetings and data mapping sessions to understand the business needs of clients.

• Developed database objects, including tables, views and materialized views using PLSQL.

• Prepared reports in SQL as per client’s needs using Views, Joins, complex SQL queries, and Aggregate functions.

• Extensively used Table Functions & Partitioning, Collections, Analytical functions, and Cursors for better code quality.

• Improved query performances by 10% using views, indexes, bulk collects, and bulk variables.

• Developed PL/SQL Stored procedures and packages for implementation of business logic.

• Generating reports using complex queries as per the client’s requests.

• Created manual staging (ETL) for exporting the data from a data mart to the data warehouse.

• Used cast collect function to solve production issue in 3 lines instead of 150 lines of code.