Senior Software Developer - Fidelity Investments/Compunnel, Inc. - Westlake
(2024-05)
- Partnered with business users and stakeholders to gather and document functional requirements for multiple data conversion projects within Retirement, 401k, and Contribution funds.
- Engineered and delivered a proof of concept (PoC) that enhanced legacy SAS processes by integrating Python, significantly reducing manual intervention.
- Spearheading the modernization and migration of process workflows to Python and opensource solutions to optimize performance and reduce costs.
- Conducted data modeling and data analytics using SQL to design optimized database structures, identify trends, and generate actionable insights for business stakeholders.
- Authored functional specifications, defined project scope and objectives, and ensured alignment with technical architecture standards.
- Gathered, analyzed, and validated requirements from business documents, user inputs, and functional specifications.
- Developed and updated data using Oracle, SQL, and SAS, integrating with Enterprise Data Warehouse (EDW) to produce conversion files and reporting datasets.
- Coordinated with Fidelity Data Conversion teams to build new source datasets, generate permanent data files, and deliver critical business reports.
- Constructed SQL scripts and SAS programs for efficient data migration across RDBMS systems, utilizing advanced SAS Macros for automation and process enhancement.
- Evaluated and tested data security, data conversion quality, query generation, and reporting processes.
- Documented complex legacy system process flows, improving transparency and knowledge sharing.
Software Developer - United Health Group
(2023-07 - 2024-05)
- Served as the Onshore Lead for the project, managing end-to-end project delivery, resource coordination, and ensuring adherence to timelines and quality standards.
- Interacted closely with business analysts and project managers to gather data requirements, understand complex business logic, and translate them into robust data-driven application modules.
- Developed and optimized data pipelines to extract, transform, and analyze datasets from diverse sources, ensuring data integrity and delivering actionable insights to drive strategic business decisions.
- Led SQL and SAS-based process migration initiatives, successfully migrating critical workflows and datasets from Oracle databases to Snowflake, leveraging advanced SQL optimization techniques.
- Applied strong Data Analytics and SQL skills to design and implement scalable data models, create complex queries, and build analytical datasets supporting business intelligence and reporting needs.
- Provided expert consultation on SAS process migration best practices, assisting the team in assessing existing environments, identifying gaps, and recommending SQL-based modernization strategies.
- Leveraged SAS tools to seamlessly migrate legacy DB2/Mainframe and Hive processes to Teradata, optimizing efficiency by redesigning outdated SAS programs into streamlined Teradata-based implementations.
- Developed detailed migration strategies, executed migration plans, and optimized data pipelines to enhance performance, data quality, and system reliability.
- Partnered with cross-functional business teams to identify migration challenges, proactively mitigate risks, and continuously improve data processes through advanced analytics and SQL automation.
Senior Lead Analyst - Wells Fargo
(2022-03 - 2023-06)
- Delivered data analytics solutions by extracting, transforming, and analyzing data using SQL, Python, and SAS for employee surveillance in home lending originations.
- Conducted business analysis to understand data requirements, risk factors, and sales practices, enabling the design of effective monitoring frameworks.
- Developed fraud detection strategies to identify improper sales activities, reducing false positives and improving risk analysis accuracy.
- Built automated workflows and dashboards to enhance reporting efficiency, utilizing Power BI and advanced SQL optimization techniques.
- Migrated and modernized legacy processes by converting existing SAS processes to Python.
- Collaborated closely with business teams to enhance risk reporting frameworks and deliver actionable insights for decision-making.
- Designed and implemented scalable data integration and cleansing strategies, supporting the development of data marts and metadata repositories.
- Led process improvements, reporting automation, and standardization initiatives to optimize overall analytics operations.
Senior Manager - Standard Chartered Bank
(2019-12 - 2022-02)
- Supported MIS reporting for Retail Banking Products, encompassing monthly, weekly, and quarterly reports.
- Converted business rules into logical and physical models, translating them into technical specifications for the ETL process.
- Monitored system performance and resolved bottlenecks, thereby improving operational efficiency.
- Conducted business analysis to gather requirements, define reporting needs, and translate business rules into logical data models and ETL specifications.
- Supported MIS reporting for Retail Banking Products, delivering key business metrics through monthly, weekly, and quarterly performance dashboards.
- Developed and automated reporting solutions using SQL, enhancing the accuracy and timeliness of business insights.
- Constructed centralized KPI dashboards and decommissioned redundant reports, improving operational efficiency and stakeholder visibility.
- Performed ad-hoc data analysis and generated reports using SQL to support product and segment teams with actionable insights.
- Utilized SQL & SAS for data extraction, transformation, and validation, and created reports for business performance monitoring.
- Enhanced reporting frameworks to monitor product performance, customer behavior, and strategic KPIs, aligning analytics with business goals.
- Collaborated with global business teams to optimize reporting processes, streamline data flows, and drive continuous improvements.
- Oversaw the translation of SAS/SQL queries to Python using libraries such as Pandas.
Senior Associate - JP Morgan Chase
(2018-07 - 2019-11)
As a Senior Associate, contributed to data strategy and execution for the Home Lending Risk team.
- Supported loss forecasting, capital model, and mortgage modeling teams with their data requirements for Comprehensive Capital Analysis and Review (CCAR) and for the Internal Capital Adequacy Assessment Process (ICAAP).
- Engaged in developing logical and physical data modeling, data flow processing, and database design.
- Created data visualizations and dashboards from legacy reports using Power BI.
- Executed process enhancements on Business As Usual (BAU) operations and performed various ad-hoc analyses on a day-to-day basis.
- Developed a new process to identify accurate losses for closed loans based on severity by integrating several data sources.
Assistant Manager - Tata Consultancy Services
(2013-10 - 2018-06)
- Delivered data-driven business solutions by addressing complex challenges through advanced analytics and strategic insights.
- Partnered with cross-functional teams to execute strategic analytics initiatives, resulting in enhanced decision-making capabilities.
- Conducted root cause analyses to address system inefficiencies and provided corrective action plans.
- Automated data pipelines and reporting workflows using SAS and SQL, streamlining processes and reducing manual errors.
- Designed and converted SAS Campaign programs from traditional SAS/AF programming to stored processes on SAS 9.4, thereby improving scalability.
- Provided SME-level support to business users, optimizing SAS performance and implementing SAS-Hadoop integration for better data accessibility.
- Identified performance bottlenecks in processes and implemented optimization techniques for improved efficiency.
- Contributed to data modeling and data analysis, and participated in user requirement gathering meetings.
- Employed data steps and conditional-based SAS/SQL joins, unions, and SAS/MACRO to manipulate existing data and display results per requirements.
- Supported team members in programming, review, and coding of ETL applications.
- Performed data cleansing, transformation, and validation, ensuring data accuracy and consistency.
- Facilitated internal team communication to effectively provide customer support.
Senior Analyst - Suncorp / WNS Global Services
(2011-12 - 2013-09)
- Leveraged SQL and SAS to perform data analytics and generate MIS reports (monthly, weekly, and quarterly), providing actionable insights to stakeholders.
- Conducted renewal, retention rate, and strike rate analysis, providing strategic business recommendations based on observed trends.
- Utilized SQL and SAS programming to extract, transform, and analyze data from diverse sources, ensuring high-quality datasets to support informed decision-making.
- Worked on the enhancement and generation of business-as-usual reports.
- Developed macros and stored processes for reusability, data analysis, reporting, and summation.
- Trained and mentored associates on process-related activities.
- Prepared ad-hoc analysis reports as required by management.
- Identified opportunities to improve SAS codes and SQL queries, and developed them to enhance code efficiency.
- Updated process-level documents monthly to reflect any changes made and interacted with business customers regarding their queries.
- Participated in discussions with stakeholders regarding additions and modifications to project outputs.
Engineering Analyst - Barclays Finance/Qualtech Consultants
(2010-10 - 2011-11)
- Streamlined the generation of key MIS reports, automating the analysis of critical metrics such as portfolio quality indicators, vintage indicators, and leading indicators, along with additional performance metrics to support business decision-making.
- Automated the entire reporting workflow using Dynamic Data Exchange (DDE) and macros, eliminating manual tasks and significantly enhancing efficiency and accuracy.
- Conducted ad-hoc reports and analyses to support credit policy and risk analytics, delivering insights into critical business areas.
- Performed WAS-IS analysis, deviation tracking for the loan booking process, and bounce rate analysis, along with other ad-hoc assessments to identify trends and process improvements.
- Automated CRM, UW, and Branch-wise performance reporting workflows, streamlining processes for monthly updates and analysis by summarizing, compiling, and storing data in permanent locations for efficient reporting.
- Provided assistance to team members in writing SAS codes, SQL, and Excel for ad-hoc reports.
Assistant Professor - St. Ann's College of Engineering and Technology
(2009-07 - 2010-05)
- Trained and mentored students in Core JAVA, C Programming, and SQL, fostering foundational skills in programming and database management.
- Designed and implemented innovative instructional methods to enhance learning outcomes and engagement.
- Evaluated and monitored student progress, providing guidance to support academic and professional growth.
- Actively participated in departmental initiatives, contributing to curriculum development and committee functions.
- Demonstrated adaptability and a passion for technology by staying updated on industry trends and integrating them into training programs.
