Darshika Mehta Email & Phone Number

Seattle, Washington, United States

• Identify production issues by investigation, debugging and work with team to deliver fixes in timely manner
• Gathering requirements for new feature requests from clients and working with team on design and implementation and managing project timelines
• Wrote Shell script to gather data model, normalize and consolidate selected ones by SQL query on database
• Generated new reports by fetching data from various data sources using SQL, writing code and scripts in proprietary language
• Worked close to customer and understand open issues and new feature requests, identify root cause and address them by fixing code
• Gather requirements and wrote use cases and respective technical specification to build user interface to generate reports

Greater New York City Area

• Migrated all the jobs from legacy system to ActiveBatch to make it a centralized system with monitoring and dependency graph
• Refactored existing stored SQL procedures to take various input as parameters to be able run via schedule and ad-hoc manner
• Wrote scripts in Python to fetch data from excel and call a stored procedure to insert the data in database

Mumbai Area, India

• Implemented major high traffic flows of the application in load balance mode using SOAP based Web services; thereby reducing the load on a particular server by 50%.
• Optimized long running SQL queries to load daily pricing data by using joins, aggregation and adding correct indices to improve ETL performance execution.
• Automated identification of spectrum downtime and business impact of network outages for UK based telecommunications provider using AppDynamics
• Corrected voluminous datasets in the cache after detecting erroneous data pertinent to pricing and inventory using TIBCO.
• Modified code to prevent processing of duplicate inventory messages to third party vendors during network glitches and outages.
• Designed and implemented fix for critical redundancy issue across multiple load balancers to generate unique warranty Ids using TIBCO EMS

Master'S Degree, Management Information Systems, General, 3.75

Bachelor Of Engineering (B.E.), Computer Engineering