Sruthi Chandrupatla
adie5j@r.postjobfree.com
Over 2 years of experience as a Data Analyst, Administration and Support in production environment.
Hands on experience in all phases of Software Development Life Cycle (SDLC) including requirement gathering, specification Analysis/Design, implementation, and testing.
Strong experience in translating business requirements to database design & exceptionally good grasp of business-critical operations for Mid-Large databases.
Good at BI Data Warehouse concepts including Metadata and Datamart functionalities.
Extensively worked in OLTP & OLAP Prod and Pre-Prod environments in SQL Server.
Performed custom dashboards & reports on Power BI.
Experience in writing/performing Stored Procedures, Functions, Triggers, and Packages using T-SQL.
Experience
MAY 2017 – JUN 2018
SQL Data Analyst/ The Management Trust, Kirkland, WA
The Management Trust provide custom HOA and maintenance provisions for small to medium scale communities, business, and real estate agencies. As part of this project, I have provided assistance on work orders and vendors provisioning systems through our legacy custom dashboards and backend data warehouse processing to comply with our end customers by preparing workorders ready for a day-to-day activity between vendor supply chain and the HOA/agencies.
Responsibilities:
Analyzed customers appointments, cancellations, and weekly change in schedules data as part of HOA maintenance using Power BI. From the analysis, prime hours during different months were identified based on which vendors sessions were scheduled for the duration of past 5 years which helped improve appointment conversation rate to 90% between vendor supply and end customer agencies.
Created an interactive dashboard using Power BI for budgeting team to make informative decisions about number of sub-vendors needed for each quarter to meet the customers demand during this session and to effectively use the allocated budgets in HOA vendor hiring process.
Gathered requirements from the end customers and elaborated the requirements by holding meetings.
Followed up with work orders and communicated vendors to get the status of the work progress.
MAY 2014 – MAY 2015
SQL Data Analyst/ Snigdha Infotech, Hyderabad, India
Snigdha Infotech provides software solutions and training for a wide array of industries. While working as a SQL data analyst for traffic analytics part of a state road transportation authority, I was involved providing data trends and bottlenecks to help create a comprehensive solution for avoiding breakdowns in traffics in peak and non-peak times. Part of this solution I created trend dashboards for technical and non-technical organizations.
Responsibilities:
Involved in defining the source to target data mappings, rules, and data definitions according to the software development life cycle.
Worked closely with development team to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs
Gathered new requirements based on the traffic datapoints from dept of transportation to defined/elaborate the requirement
Created datasets/dashboards for reporting, visualization and analysis using Power BI for non-technical organizations to help ease the traffic visualization.
Involved in providing KB articles to help improve the operations standards for troubleshooting
Provided 24/7 SQL production support, problem management support to the development/client teams
Skills
MS SQL Server • OLAP/Data warehousing • SQL • T-SQL • C++ • HTML 4.01 • Java • SSMS • SSRS • SSIS • Power BI • Visio • MS Office • Team player • Excellent time management skills • Conflict Management
Education
MAY 2012
Bachelor’s in computer science engineering from Jawaharlal Nehru Technological University
MAY 2014
Master’s in computer science engineering from Jawaharlal Nehru Technological University