Siba Prasad  Mishra

Siba Prasad Mishra

Data analyst @ Intercontinental Exchange

Hyderabad, IN • Joined Jun 2023


About

A highly skilled and experienced data professional with over 3 years of experience in SQL data extraction and transformation, along with more than 1.5 year of experience in Power BI. Seeking a challenging role where I can utilize my expertise in data analysis, data visualization, and problem-solving to drive actionable insights and deliver valuable solutions.

Work experience

6 years 6 months

Org Logo

Intercontinental Exchange

4 years

Data analyst

November 2019 - Present

Full-time

• Gathering requirements from Business users by conducting data analysis and creating business metrics. • Experience in translating business needs into analytics solutions to drive better data-driven decisions. • Proficient in SQL for data extraction, transformation, and analysis. • Expertise in Power BI for report development and data visualization. • Excellence in analytical and problem-solving with a strong eye for detail. • Outstanding communication and presentation skills for conveying complex data insights to stakeholders. • Capable of working independently or collaboratively in a team-oriented environment. • Proven success in developing complex SQL queries and stored procedures to extract data from varied databases and generate reports. • Accomplished in designing and creating dashboards on Power BI by ingesting the data from g-sheet, MS-Excel. • In-depth knowledge in data pull, Data Blending, join by using Custom SQL within same data source. • Ability to gather business requirements from users by conducting data analysis and creating business metrics. • Experience in translating business needs into analytics solutions to drive better data-driven decisions.

Genpact India Pvt Ltd

2 years

Process Associate

November 2017 - October 2019

- Extracted the data from different data sources like Excel, Oracle and developed reports by using Power BI Desktop. - Created new calculated column and measure using DAX. - Having strong knowledge in writing SQL Queries to validate reports with the database. - Integrated Custom Visuals based on business requirements using Power BI desktop. - Done the data combining operations using UNION, INTERSECT, APPEND, etc. - Built advanced chart types and visualizations such as bars in Bar Charts, Bullet Graphs, Box plot, and involved in Dashboard development & Testing. - Comfortable with various DAX functions like Calculate, Filter, And, Or, Related, Rank, Summarize, etc. And aggregation functions like Sum, Average, Max, Min, Count, etc.

Education

Central University of Odisha

2015 - 2017

Master of Business Administration - MBA in Finance and marketing

June 2015 - June 2017

My MBA in finance has supplied me with a thorough comprehension of financial handling, such as monetary analysis, investment practices, and risk-assessment. This program has presented me with tangible skills in financial modeling, budgeting, and forecasting, giving me the ability to make prudent decisions and maximize economic performance. I have also obtained strong analytical capabilities, permitting me to review intricate financial data and detect trends, patterns, and potential chances. Additionally, I have built a robust base in corporate finance rules, empowering me to successfully control capital, measure investment projects, and calculate ideal funding sources. Further, I am adept in financial markets and instruments, comprising stocks, bonds, derivatives, and foreign exchange, enabling me to make well-informed investment proposals and administer portfolios capably.

Awards & achievements

Certificate from PWC on power bi

Jun 2023