Ritu Aroskar

• Collaborated with Business Analysts team on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Contributed to internal activities for overall process improvements, efficiencies and innovation.
• Communicated new or updated data requirements to Business Analysts.
• Explained data results clearly and discussed how it can be utilized to support project objectives.
• Prepared documentation and analytic reports effectively and efficiently delivering summarized results, analysis, Use cases and conclusions to stakeholders.
• Built databases and table structures following "Waterfall" methodology for integration of Unsupported & Current Systems.
• Created and implemented database designs and data models.
• Implemented BI solution framework for end-to-end business intelligence projects.

• Worked as a Team member for development of Custom ERP solution for "Shared Services"
• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
• Improved application performance by determining root cause of issues and resolving.
• Generated, debugged and enhanced existing reports with introduction of new system features.
• Analyzed existing SQL queries to identify opportunities for improvements.
• Reviewed and interpreted business report requirements to address user needs.
• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
• Designed packages in SSIS and scheduled jobs to migrate Financial data from Oracle sources into SQL Sever.
• Created optimal technical solutions to user needs through research and in-depth system analysis.

Created a Custom Solution for Finance to process their monthly AR invoices. The automated process grabbed Professional Time, Expenses & Milestones from the ERP Sql database and generated invoices for them to send to their clients. It reduced the latency of the web site and made the overall process efficient.

• Analyzed client business processes to propose optimal software applications for unique requirements.
• Developed flowcharts and diagrams to describe and lay out logical operational steps.
• Designed automated testing parameters to achieve ongoing system compliance with selected performance metrics.
• Developed technical requirement documentation for new software products compatible with .Net platform.
• Collaborated with client and interdepartmental peers to transform client requirements into turnkey solutions.