Sapna Patra

WORK HISTORY

EDUCATION

ABOUT SAPNA PATRA

Results-driven Business Analyst with experience in collecting, transforming, organizing, analyzing, and visualizing complex data to help make informed decisions and providing detailed documentation and presentation to the clients. Skilled in SQL, Python, Numpy, Pandas, Tableau, Power BI and Advance Excel.• Created database and database objects like tables, complex stored procedures, CTE, indexes, views, user-defined functions, cursors, triggers, temp table, SQL joins, subqueries, ranking functions and dynamic SQL and responsible for performing t- SQL tuning, multi-tasking and optimizing queries which takes longer time in execution with MS SQL server. Excellent analytical, problem solving and SQL debugging skills.• Developed ecient Python programs to satisfy the demands of the user and worked with various python modules like pandas, NumPy and matplotlib.• Enhanced the existing applications for all the data requests from the client based on business logic using Python Technology.• Proficient in Advanced Excel on conditional formatting, count, data validation, index, match, sum, pivot table, VLOOKUP, and data table.• Extensive knowledge in data visualization using BI tools such as Tableau, Power BI, and Excel.• Skilled in design and development of various dashboards, reports utilizing Tableau and Power BI Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.• Excellent interpersonal communication, problem solving, documentation, presentation and business analytical skills to implement best practices.