Ayan Chakraborty

I worked as an on-site coordinator and offshore developer at a US-based education startup. The company is responsible for undergraduate admission processing for students from all over the world at numerous US universities.

I developed and led a team of four to build a pipeline for a data flow in SSIS. We were also responsible for more than 60 stored procedures that handled data processing. I also built the EDW architecture for reporting purposes and designed the Tableau dashboards; we integrated them with the platform so that the end-users could obtain insights.

The client is a major educational software provider based in the US. They automate all the application process over a large number of US universities and educational organizations.

More than 7,000 programs rely on them for help identifying, engaging, and enrolling prospective students. They needed a data warehouse and dashboards for the university management to understand the applicant's details in a more meaningful way which would drive the future admission process to be better and smoother.

My Responsibilities:
• Understood the requirements from the users and the existing system.
• Designed and deployed the SSIS package for the data warehouse.
• Created critical T-SQL procedures to meet facts and dimensions needed.
• Designed cycle-wise application status and the application number heat map in Tableau Desktop.
• Implemented security-based user access organization-wise.
• Scheduled tasks for incremental data loads.

The client is a major transportation provider based in the US and responsible for running trains all over the Bay Area. They needed to issue records, calculations, and reports to the MBTA concerning the mean miles between failures (MMBF) of all trains for each route they cover.

The app provides an analysis of MMBF of all trips for all routes, service type, peak type, and other parameters as well as to assess fleet performance—reliability and availability. Users will be able to analyze the data presented in detail at various levels through visualizations.

My Responsibilities:
• Thoroughly comprehended the requirements from the users and the existing system.
• Worked in Tableau, Python, and SSRS
• Created a complex Python script to build the data model for having rolling rank and
expected visualization.
• Designed fleet performance, rank, and locomotive geographical visualizations.
• Implemented security-based user access location-wise.
• Scheduled tasks for incremental data loads.

ERO Data Migration came in to picture when some of the marketing companies under the AZ client agreed to move their business application from Siebel to Oracle CRM on Demand.

The data related to demographics, objective, activity, and product was migrated from the Siebel database to their respective systems and then once the data was validated and irrelevant data was filtered out, the required data was migrated to the CRMOD system.

My Responsibilities:
• Helped with an in-depth analysis of the business requirements.
• Used my complete understanding of the SIEBEL data model (party model, activity, meeting, product, and samples).
• Drew extracts from the Siebel database and in a particular model as it can be loaded to the OCOD database.
• Designed and implemented critical business requirements for the interface design
using Informatica.
• Developed Informatica mappings, workflows, and worklets (a group of tasks) for the implementation of critical business requirements of integrating multiple systems.
• Unit-tested the app in various modes and with various types of users.
• Involved in the system-integration testing of the app with the owner teams of the
aligned systems.
• Helped with market engagement from off-shore.