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
Intercontinental Exchange
5 years 1 month
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