Dipali Sabale
Ashburn,Virginia
Summary
Motivational leader and organizational problem-solver with advanced supervisory, team building and customer service skills. Experience stepping into roles and quickly making positive changes to drive company success. Focused on using training, monitoring and morale-building techniques to maximize employee engagement and performance.
Overview
13
13
years of professional experience
Work History
Sr. Manager (Software Engineer 4)
Asurion
STERLING, VA
04.2018 - Current
- Analyze data sets from different sources; identify data relationships, business rules, data characteristics and business process gaps
- Worked on assigned incidents and provided Data fixes for the same until permanent fix is deployed for the issue
- Experience writing complex SQL Queries across multiple tables and databases
- Provide scripts using Sql, Pl/Sql which are built in such a way that they will not require any downtime and execute in minimal time
- Responsible for creating ad-hoc reports using Pl/sql that are useful to pro-actively identify issues and to monitor the system health
- Provide root-cause analysis and preliminary problem diagnosis for claims that are stuck in Production, works with business and technical staff to perform effective root-cause analysis and resolution
- Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
- Worked with other teams to understand the gaps and issues they are facing to improve the business and automate the manual work
- Created many database structures like tables, sequences and procedures as per the requirement for solving the issues
- Worked on node JS and React to create different utilities for the internal team to automate the manual work
- Created Procedures and functions for the automation tools
- Mentored new joiners, provided knowledge transfer sessions to get them started
- Helped them to get up to speed
- Facilitated 1:1 meeting with direct reports, providing guidance and support in their career growth and development paths
- Leads internal projects dedicated to assisting product and finance teams in developing a variety of tools
- Used JIRA as a change management tool to deploy the code from Lower environments to Production
- I am actively engaged in utilizing Node.js and React technologies, complemented by Oracle as the backend infrastructure.
Database Developer
ComScore Inc.
Reston, VA
01.2017 - 12.2017
- Gather business requirements from client team, transform them to technical requirements
- Plan, design, develop, and implement requirements to support custom analytics operations
- Perform scalability analysis and performance monitoring, read through a query plan, optimize code and database structures accordingly by applying proper indexing, table partitioning
- Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction
- Experience in Custom Logging for SSIS Packages to track errors and to load accurate data into destination
- Work directly with various businesses users to design and implement Ad-hoc queries and reports, create and provide system support as needed
- Used Jira to log tickets and story tracking and updates
- Attended training sessions for AWS.
Associate
Cognizant technology solutions
Powai, Mumbai, India
12.2010 - 02.2016
- PNM Resources (Sept 2015 – Feb 2016): Designed and developed Queries, Stored procedures, functions, Views, Materialized Views and triggers
- Involved in preparing Logical Data Models/Physical Data Models using Erwin
- Combine and analyze data across multiple Excel spread sheets and worksheets
- Analyzes data for accuracy and notify management of inconsistencies in reporting based on department trends
- Defined tasks associated with the user stories, Test Cases using Atlassian JIRA., and linked test cases with the user stories
- Performed string manipulation using various string functions like charindex, substr
- Coordination with onsite counterpart as well as client
- Actively involved in efforts estimation, unit test-case preparation and release activities
- GMA Vision (Nov 2014 - Sept 2015): Developed procedures, functions and packages also wrote complex queries
- Evaluated, analyzed, researched and processed incoming data to provide the inputs to the customer
- Contacted and interacted with others to acquire source documentation, rectify discrepancies in the data, and responded verbally and through written means to inquiries/special requests
- Used data analysis techniques to validate business rules and identify low quality missing data
- Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL
- Optimize queries using Execution plans and other techniques like Indexing, partitioning etc
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
- Used GIT and Source Tree for the Code repository
- Created impact analysis tool to help developers and BA’s to understand the impact of new requirements and to estimate the total time to work on them
- This too helped them to provide the proper impact analysis to the client in less time
- FastTrack Claim Management System (Nov 2010 - Nov 2014): Designed Views, Tables, Procedures and Functions also processed various sources of data and reports
- Created complex queries to handle the business validations
- Created and Backed up Database populating with corresponding data for different stages of Testing
- Extracted, compiled and tracked data and analyzed data to generate reports
- Created different reports as per customer request using SSRS
- Improved the performance of the queries by tuning the queries using indexing, partitioning etc
- Extracted, compiled and tracked data and analyzed data to generate reports
- Used Microsoft Team Foundation Server for code repository
- Knowledge in Oracle utilities like SQL
- Loader, Export/Import
- Extensively involved in developing PL/SQL packages that includes advanced PL/SQL concepts like REF_CURSOR, BULK COLLECTS, for all, etc
- Daily status sharing with the customer
- Maintained the track if the patches sent on production from Production Support as well as Change Request team
- Used BugZilla to keep track of bugs raised during testing
- Developed Ticket tracking tool which team used for preparing daily status report and implemented email functionality
- Created Patch tracking system to maintain the production patch details and to provide the reports to the management team and client whenever required.
Education
MS in Information systems -
Stratford University
PGDM in E-Business -
Welingkar Institute of Management Development & Research
B.Tech in Information Technology -
S.N.D.T University, Mumbai
Skills
- Microsoft Visio, Excel, Word, Microsoft Project, DOORS, JIRA, Notepad, Visual studio 2008, BugZilla, ErWin, Microsoft Business Intelligence Studio (SSRS and SSIS), Visual studio code, Postman
- PL/SQL, c#Net, SQL server, Javascript, node JS, React
- Oracle 10g, SQL Server 2008,2012
- Windows Server 2003/2008, Windows 7/Vista/XP
- HTML, CSS, JavaScript, XML
- Data Analytics
- Database Development
- Cross-Functional Communication
Additional Experience And Awards
- Received Quarterly award in insurance domain from cognizant.
- Received PAT ON THE BACK award from cognizant.
- Received Performance award in ComScore.
Timeline
Sr. Manager (Software Engineer 4)
Asurion
04.2018 - Current
Database Developer
ComScore Inc.
01.2017 - 12.2017
Associate
Cognizant technology solutions
12.2010 - 02.2016
MS in Information systems -
Stratford University
PGDM in E-Business -
Welingkar Institute of Management Development & Research
B.Tech in Information Technology -
S.N.D.T University, Mumbai