Ananya Basu

Ananya Basu

Software Engineer

Followers of Ananya Basu274 followers
location of Ananya BasuDelhi, India

Connect with Ananya Basu to Send Message

Connect

Connect with Ananya Basu to Send Message

Connect
  • Timeline

  • About me

    SAS Developer

  • Education

    • National Gems Higher Secondary School

      2005 - 2012

      Activities and Societies: Dance competitions

    • West Bengal University of Technology, Kolkata

      2012 - 2015
      Bachelor of Computer Application Computer Science
  • 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
  • Licenses & Certifications