Rajat Tyagi

About Rajat Tyagi

I\'m a resourceful professional with a comprehensive skill set, proficient in Microsoft Office, Excel, and Power BI. I can also use AI applications to Orchestrate the optimization of business processes by utilizing AI applications like Chat GPT and Copilot, leading to a 25% increase in workflow efficiency and a 20% reduction in manual tasks. My cognitive capacity helps me to examine complicated problems, while my communication abilities enable efficient teamwork. I am eager to contribute knowledge to grow in a forward-thinking firm dedicated to progress.

Experience

1. Data Analyst

   Megaserve Technologies

   Sep 2024 — Present · Jaipur, IN

   Industry: Algorithmic Trading | FinTech | Data Analytics1. Power BI Dashboard Development - Designed and deployed a comprehensive Power BI dashboard visualizing key performance indicators (KPIs) across three dimensions — Algo, Server, and User. Implemented complex P&L calculations enabling real-time insights and strategic decision-making across departments.2. Data Handling & Organization - Maintained a structured approach to storing and organizing Excel files, ensuring consistency in formatting, naming conventions, and data cleanliness. Compiled daily files in a uniform and ready-to-use format to enable quicker analysis without additional preprocessing.3. Process Automation & Reporting - Automated recurring daily/weekly reporting tasks using Python, DAX, and Excel (Using Pivot, Power Query or advance formulas) — saving hours of manual effort and ensuring accuracy in time-sensitive environments. Delivering critical daily reports including MTM (Mark-to-Market), loss analysis, fallback summaries, and rejection logs.4. Team Leadership - Leading a small data team of 4 members. Delegated routine tasks to enable a focus on high-impact analysis and exploratory data insights. Fostered a collaborative environment to promote continuous improvement and knowledge sharing.5. API System Monitoring & Issue Diagnosis - Monitoring API-based squaring-off system by accessing SSH servers via PowerShell, checking logs, and diagnosing errors for smooth operations.6. Ad-Hoc Operations Support - Provided backup operational support during team absences, demonstrating agility and cross-functional capabilities in a fast-paced trading environment.

Education

• Baba Farid Institute of Technology, Dehradun

  Bachelor of Science - BS

• Baba Farid Institute of Technology, Dehradun

  Master of Science - M.SC.