SRUTHIKA GADHARI

Overall 6+ years of experience in IT Industry, from that carrying experience in Data Engineering, Data Visualization, Reporting Tools, Data Design and Development in domains like banking and Insurance, involved in requirements gathering, analysis, design, development and maintenance of various database and data warehouse software applications. Looking for early professional roles in a growth-oriented organization where I can leverage my experience, skills.

Have earned 3 badges on LinkedIn and cleared the test for Google Cloud, Microsoft Excel and Microsoft Powerpoint.

• SLA IT Solutions, 03/2023, 08/2023, Wells Fargo, Servicing Data and Analytics, Architected and implemented a scalable microservices architecture, reducing application response times by 40% and enabling the platform to handle 3x the concurrent users during peak hours. Engineered and deployed a custom CRM system for managing client interactions, resulting in a 25% increase in customer retention and a 20% boost in cross-selling opportunities within the first quarter., Creating the required DB objects like landing tables, creating the stored procedures and building the ETL’s. Understanding the different Sources and pulling data as per the requirements. Creating the Azure Analysis Cubes to pull the new data for the new report requirements as needed. Designing PowerBI reports based as per the design using the created measures. Using SSAS Tabular model and create DAX measures. Creation of SSIS packages to process partitions of cubes as required. Creating Power BI reports and dashboards. Creating SSAS tabular models to use as a source in Power BI to load the data. Worked with Pages and Page Visualizations in Power Bi Desktop. Created Dashboards style of reports using Power Bi Desktop Visualizations like Matrix, Bar Chart, Line Chart, Area Chart and Slicer etc. Created the reports using charts like Pie, Bar, Line, KPI Visuals, Custom visuals, etc. Charts are used in making reports more user-friendly in analysis purposes. Created Calculated Table using DAX expressions for Dynamic column and conditional columns. Migrating the SSAS cubes from 1200 to 1400 compatibility level, whenever we see server upgrade in respective plat forms. Develop power bi dash board based on need. Writing tuned SQL queries using indexes, views, stored procedures and user defined functions based on client requirement. Creating, scheduling and automating regular SQL jobs and have hands-on experience in analyzing & troubleshooting SQL server processes and jobs. Created, Configured and deployed the SSIS packages. Also scheduled jobs through SQL Server Agent to run automatically. Creating and enhancing existing SSRS and Power BI reports.
• VSA Technologies, 09/2019, 12/2020, Citi Bank, Transaction Management, Worked as a Senior Associative Consultant for Citibank Client in Infosys. The main objective is to monitor the live transactions and pulling the transaction reports, then migrating that data into Power BI to create reports & dashboards on daily, weekly, monthly based transactions and publish it to end users., Imported data from SQL Server DB to Power BI, created DAX Queries to generated computed columns in Power BI and generated reports. Improved overall decision-making 60% by designing and developing BI reports and providing valuable insights. Comprehend business requirements in a BI context and developed 15+ data models to convert raw data into actionable insights. Created new stored procedures and optimizing existing queries and stored procedures. Identified 5 KPIs with outlined objectives and consistently monitored them. Developed 30+ reports by utilizing knowledge of SQL queries and SQL Server Integration Services (SSIS). Created Database objects – tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement. Used Power BI, Power Pivot to develop data analysis, used Power View, Power Map to visualize reports. Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps. Responsible for Performance Tuning, Query Optimization. Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All. Expertise in enhancing and deploying the SSIS Packages from development server to production server. Strong Knowledge in dimensional Star Schema, Snowflakes Schema worked in Agile-Scrum process. Responsible for documentation of each report and dashboards, overseeing knowledge transfer sessions.
• VSA Technologies, 10/2018, 07/2019, Mercedes Benz, Revenue Management, Spearheaded the initiative to develop and publish 5-6 Power BI dashboards summarizing weekly, monthly, quarterly, and yearly business performance, driving enhanced decision-making and visibility across Line of Businesses. Led the migration project to transition Daimler Benz's Sales, Inventory, and Revenue Management from Excel to Power BI, resulting in a 40% increase in data accuracy and a 25% reduction in reporting time., Developed various PBI Models used for financial reporting as well as daily monitoring of servers and tools. Used various sources to pull data into Power BI such as SQL Server, SharePoint online, Excel, CSV etc. Participated in planning sessions with project managers, business analysts and team members to analyses business requirements and outline the proposed solution. Implemented 3 fully functional data schemes and 10+ data flow optimization processes for reporting performance and enhancements. Generated and delivered quality reports to customers by conducting quality assurance checks and recorded a 65% increase in customer satisfaction.
• CH Excellency, 02/2014, 10/2018, EasyJet Plc, Ticketing Data, EasyJet is a British airline, operating under the low-cost carrier model, based at London Luton Airport. It operates domestic and international scheduled services on over 820 routes in more than 30 countries in EU. The company's mission is to provide their customers with safe, good value, point to point air services. To effect and to offer a consistent and reliable product and fares appealing to leisure and business markets on a range of European routes. As part of this project, we monitor the existing ETL process for all the flights info and crew info including the bookings data and built some SSIS packages for ad-hoc data needs from the users for their analysis, monitoring the SSAS cubes and creating the partitions to make the cubes perform more effectively in terms of performance and processing. Also, we built some paginated reports using SSAS cubes as source., Implementation of data extraction, transformation, and loading (ETL) processes. Monitoring the environment using Monitoring tools like Nimbus, OEM, Savvies and NEWS tool and responded quickly to incidents. Performed Operational checks, monitoring/restart batch jobs. Deployment of Application files on Tomcat, ACS & Apache using instructions. Performed restarts on ACS, Tomcat, and Apache services. Analyzing logs if any application issues are noticed in the system. Monitoring transaction at Issuer and Silo leave using NEWS tool. Analyzing Transaction reports for finding any abnormal transactions. Configured services, ports through Nimbus Dashboard for monitoring services and ports. Developed scripts using Shell and Ansible to reduce day to day tasks. Troubleshooting in case of application failure or any related problems on servers. Handled DES & DUT Job’s, used Splunk & Elk for log search analysis. Deployed applications using REL Auto tool. Responsible handling first level troubleshooting issues and applying patch upgrade. Manage communications to IT System Managers regarding patching. Handling various types of incident cases raised by Cross Functional Teams and customers. Involved in weekly and Monthly scheduled maintenance activities. Developing and Reporting on Key Performance Indicator (KPI) metrics. Finding out Root cause for reported major incidents/issues and preparing Incident Reports.

1. Certification in Python from Codefinity

2. AWS Cloudformation

3. AWS Well-Architected Considerations for Financial Services

4. AWS Cloud Quest: Cloud Practitioner

5. AWS Cloud practitioner essentials: Cloud Concepts