KOMAL AHIRE

Email : ad1bec@r.postjobfree.com Visa: L2 Passport: M5241833 Contact: +1-732-***-**** Address: Edison, NJ 08817 Profile Summary

• SAS Developer with 9 years of experience primarily in Banking domain with specialization in data analytics, reporting & visualization.

• Expertise in Base SAS, Advance SAS, Hive & SQL Programming to design, develop & automate dashboards.

• Well versed in Tableau, PySpark & basics of Python.

• Experience in managing data integration development tasks in collaboration with other technical teams, data analysis & interpretation.

• An effective communicator and team player with excellent problem solving & analytical skills. Technical Competencies

Tools & Software : Base SAS 9.4, SAS Enterprise Guide, SQL, HIVE, PySpark, Tableau, Python, Unix Database : Hive, Oracle, MS SQL Server

Other Tools : WinScp, Filezilla

Professional Experience

EXL Services Pvt Ltd as SAS Developer (From May’22) Project: Experian (USA)

Key Roles:

• Design & develop industry benchmark reports for key US banking clients to analyse performance vs. peer group across portfolios and different credit risk metrics.

• Creation of end-to-end logic for data preparation via. SAS, PySpark & Hive, and report interface in Tableau.

• Generation heat maps report in Python for low income and marginalized communities.

• Performing data analytics leveraging PySpark and presented insights to product team to develop mortgage pricing strategy.

• Automation of monthly reports along with configuration and scheduling them on airflow.

• Design and develop Tableau dashboard for a leading US credit rating agency to facilitate in depth understanding of Economic & Credit Trends metrics of US customers.

• Design and develop Tableau dashboard SAS dashboard for Credit Union client. Tata Consultancy Services Ltd as Base SAS Developer (Aug’18 – May’22) Project: Axis Bank (India)

Key Roles:

• Design and develop SAS dashboards for Cros sell project.

• Automation of reports handled by client for saving FTEs.

• Creating auto mailers for generated dashboards as per the client requirement.

• Handling around 2-3 ad-hoc requests on daily basis.

• Analyse transactions to build logical business.

• Migration of reports into Mart to create new reporting layer.

• Execution of reports on daily basis and weekly/monthly reports.

• Handling huge transaction level datasets.

• Explicitly connecting to Oracle database using SAS EG for query building.

• Creating data objects for reports using SQL and auditing for accurate delivery.

• Handling Team (Managing workload, Assigning Backups, Monthly Tracker updating etc.) and working as a mid-layer between Client and them.

Capgemini India Pvt. Ltd as SAS Programmer (Aug’14 – Aug’18) Project: Matalan (UK)

Key Roles:

• Preparation of new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions and conditional statements.

• Identification, analysis & resolution of development issues.

• Creation Macros and extensively used existing macros in developing SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.

• Creation of SAS programs for ad-hoc jobs using Base SAS and SAS/Macros.

• Technical support to end users on SAS, SAS Enterprise Guide, SAS Data Integration Studio and SAS BI Suite.

• Explicitly connecting to Oracle database using SAS EG for query building.

• Exposure to ETL process.

• Developing Oracle reports using procedures.

• Creating Service Request and co-ordinating with Oracle Corporation for financial issues.

• Involvement in the System Improvement Plans (SIP) and had proposed many new ideas related to SIP.

• Practiced LEAN methodology to achieve better results and conducted FMA, RCA as a part of project. Education

• Post-Graduation Diploma in Advanced Computing, C-DAC, 2014

• B.E in Electronics & Telecommunication, Mumbai University, 2012 Achievements

• Received TCS Star of the month award thrice in for successfully delivering multiple Projects.

• Top performer in TCS for the consecutive years.

• Multiple Client appreciations in TCS, Capgemini over the years for work implementation and project delivery.

• Won the “H1 23 Ace” award in EXL Services.

I hereby declare that the above information is true to the best of my knowledge. Place: Edison, New Jersey

Komal Ahire

Contact this candidate