Ananya Basu

Experience

• 

  Tech Mahindra

  Aug 2015 - now

  Software Engineer

  •Proficient in ETL process design, Automation, Monitoring, and Scheduling of the jobs on SAS Platform.•Performed complex report conversions, mapping and critical data analysis and founded key performance indicators and drivers using analytics tools.•Worked ion a SAS GRID environment and followed SDLC lifecycle from requirement gathering, analysis, planning, designing, coding, unit testing & implementation and prepared the relevant documents.•Extensively used SAS SQL procedures, SAS Macros and Unix Shell Scripting for automation.•Developed Reports on Adhoc request from clients and performed analysis and provied results to the clients. •Integrated data from various system sources like (flat files, CSV, text form etc.) using different SAS EBI tools.•Created analytical dashboards and published reports on Client’s SAS Portal.•Maintained a huge data warehouse and performed optimization for faster data retrieval by using indexing and clustering techniques.•Designed and deployed jobs and codes and scheduled them using crontab and AutoSys.•Experience in having direct interaction with the clients and understanding Business problems and provided solutions to the clients in a given time frame.•Extracted data from different sources (Flat files, Teradata, oracle DB, SPDS) then transformed and restructured data and loaded it into data warehouses for reporting and analysis purposes.•Worked on SAS Macros extensively to eliminate code redundancy and improve SAS program performance.•Performed User Acceptance testing(UAT) and resolved the Production issues.•Worked on advanced Microsoft Excel to create pivot tables, used HLOOKUP, VLOOKUP, and other Excel functions.•Good Data Warehousing concepts, troubleshooting and customer service skills to quickly meet their needs.•Strong problem solving and technical skills and managed multiple projects in a fast-paced environment. Show less

• 

  EXL

  Feb 2019 - now

  Business Analyst