Aaradhana Raghunathan

Business Systems Analyst

MD Clarity•  May 2020 - Present

Analyze client's business requirements and processes through document analysis, interviews and workflow analysis. Design and develop fully automated ETL process to streamline the on-boarding process for new clients. Partnered with developers to automate manual processes, saving time and money while decreasing errors. Credited as primary driving force behind 3% increase in margins for the fiscal year. Document client's requirements by constructing easy-to-understand data and process models. Research emerging technologies and recommended solutions aligned with business goals. Conduct root cause analysis to identify development opportunities and recommend business solutions. Remove processing bottlenecks to increase efficiency in the overnight daily processing jobs. Completed in-depth analysis and created reports to enhance data quality and monitor overall performance.

ETL Developer

Freedom Mortgage•  June 2016 - April 2020

Compile and define business requirements gathered from cross functional teams and users to understand database needs and establish design scope. Enforce database development standards, offering top-notch support with quality-driven approach. Develop specifications to standardize database development and use, reducing costly errors. Design and develop SSIS packages, stored procedures, configuration files, tables, views and functions for data warehouse and data mart projects. Implement CDC process to cut the run time of daily ETL jobs by about 50%. Create processes to effectively balance process loads and minimize downtime during database backups.

Program Analyst

Cognizant Technology Solutions•  July 2014 - July 2015

Monitor market trends and presented data in charts, graphs, and presentations utilizing excellent analytical techniques. Wrote Unix shell scripts to facilitate Informatica workflows. Identify multiple data sources and operational data for reviewing or improving processes and workflow by analyzing various techniques or methods. Efficiently streamlined business process re-engineering and structured documentation methodology.