AASTHA KHARE

Client: CISCO (USA)

• Generated reports, large data extractions and performed analysis based on a SQL back-end data store by implementing strong understanding of database structures, theories, principles, and practices.
• Developed and maintained SQL queries with the use of multiple joins, CASE Statement, Index, PIVOT, stored procedures, and views to support business logic and optimized queries for performance improvements.
• Performed data quality measurements like data cleaning, validation and modeling to ensure critical data elements meet data standards and escalated data quality issues to vendor.
• Efficiently used Microsoft Excel to analyze, summarize and deliver data driven insights using VLOOKUP, and other advanced functions.
• Worked closely with auditors to provide exception analysis reports.
• As a scrum lead worked as a Liaison with project stakeholders, vendors and teams responsible to duly define the scope and documenting requirements of the project and follow the scrum framework to ensure business goals are achieved.

Client: TOSHIBA (USA)

• Specialized expertise as an Oracle application technical developer in implementation, and customization of Oracle e-Business Suite (11i, R12) applications.
• Technically proficient in (modules like SCM and Finance) reports, forms customization, email alerts, data migration, workflow, and development of interface programs to integrate modules to import data from various sources into Oracle applications using PL/SQL, SQL* Loader.
• Modified custom Oracle Forms and Reports, resulting in a 30% reduction in user errors and faster data entry.
• Developed and maintained technical documentation, including data models, data flow diagrams and system architecture.
• Produced ad hoc analysis on data and maintained documentation (technical design document MD070), which was used to fill the monthly financial stats.
• Provided support to onsite team and played a key role in resolving critical incident.

Client: Sybron Dental Specialties/Danaher (USA)

• Analyzed and optimized SQL queries using explain plans, indexes, identifying bottlenecks and implementing changes that improved query performance and reduced execution times.
• Created and maintained ETL packages using SSIS to automate the data integration process and improve data quality and consistency.
• Supported client data to identify primary keys, indexing needs, key data elements, linkage from one table/system to another.
• Leveraged advanced SQL skills to enhance complex queries (Hadoop, Oracle and MS SQL Server) and data transformations, resulting in streamline reporting and improvement in database performance.
• Extensively involved in debugging and fixing the code and made the changes according to the new business requirements.
• Created weekly, monthly and quarterly reporting packages for senior leadership.