Summary
Overview
Work History
Education
Skills
Websites
Courses/certifications
Languages
Awards
Projects
Timeline
Generic

Sarvina Sawant

Summary

11.1 years of experience in the field of IT Industry. Good technical expertise in Power BI, SQL, Snowflake ,Cognos, Spotfire, Microstrategy and Python. Have good exposure of operational work like process management. Strong analytical and development skills in DW

Overview

6
6
years of professional experience

Work History

Power Bi Developer

Atos India
12.2018 - Current
  • Created Power BI dashboard from various data source like SQL server database, Excel, CSV data, Sharepoint, snowflake.
  • Designed and developed SQL queries and views necessary to support SSRS and Power BI reports.
  • Analyzed data models, data relationships, and dependencies for greatest optimization.
  • Implemented various DAX logics (columns and measure) and calculation to display KPIs and summarized data in a dynamic and interactive way.
  • Involved in Power BI administrative task like publishing reports, manage workspace, RLS, OLS, scheduling, sharing reports with users/groups etc.
  • Microstrategy: Worked as MSTR developer to build new report/document from SQL source , or else modifying existing report as per user requirement.
  • Worked on minor enhancements and new development with agile methodology.
  • Maximized development efficiency using version control systems like Git Extension, Bit Bucket, Git hub to manage source code effectively.
  • Deployed applications efficiently using CI/CD tools like Jenkins, streamlining release management processes across multiple environments.
  • Implemented continuous delivery pipelines using Jenkins, enabling faster release cycles and improved software quality.
  • Engineered an SQL query optimization project that accelerated report generation speed significantly benefiting Financial Analysis.
  • Worked on semi structured data(tables/views) in snowflake warehouse.

Cognos | Spotfire Developer

Cognizant Technology Solutions
6 2013 - 12.2018
  • Worked as Support analyst which performed task as Changes in existing reports, Troubleshooting Data issues, User Management, Deployment of code to Prod/Test, Data Source Creation, Implementation of Cube Refresh,New Cognos report creation using Cognos framework manager and Cognos report studio.
  • Streamlined reporting processes by creating efficient Cognos Framework Models to support end-user requirements.
  • Improved decision-making capabilities for management with the creation of customized, interactive Cognos dashboards.
  • Expedited report generation times with the implementation of advanced techniques like burst reporting, drill-throughs, and prompts in Cognos reports.
  • Enhanced data visualization by designing and implementing Spotfire applications for various business units.

Education

Bachelor Of Technology (B.Tech/B.E) - Information Technology

Dr Babasaheb Ambedkar Technological University, Lonere

Skills

Power BI

Cognos Reporting

Snowflake

Spotfire

Sql Server

Microstrategy

Excel

Python Programming

CI/CD Jenkins Pipeline

Problem Solving

Analytical Thinking

Courses/certifications

Python for Data Science

Languages

English
Hindi
Marathi

Awards

Above and Beyond Award, 03/01/17, Received "Above and Beyond Award" for best performance in supporting critical applications in North America region for Cognos and Spotfire application.

Projects

Client : Merck
Project Name : AWS Lights on DWBI Cognos and Spotfire application support
Cognos :This Project is basically to provide application support for All 360 Cognos Applications in Merck Environment in Life science domain which is spread globally across NA, EMEA & APAC regions.
Spotfire :This project is built to generate monthly KPI metrics for Indirect Supplier Scorecards from raw data files using ETL and BI tools provided by Indirect owners for different countries in North America region of Merck.

Client : Starr Insurance company
Project Name : Cashflow
This project is built to generate monthly, weekly and Yearly Cash Inflow and Cash Outflow for Starr Insurance company from raw data files using ETL (SSIS Package)and BI tools (SSRS, Power BI). The metrics will be calculated and displayed with the ability to drill down to policy and insured name details.

Client : Manulife
Project Name : Resource Capacity Planning
This project is use to manage resources according to role, their allocation in different projects, their monthly capacity project wise, hiring, off-boarded details, Budget and revenue details from sharepoint excel file.
Project Name : GO GA decommission archival projects
This project is used to provide financial advice, insurance as well as wealth and asset management through various division like EAGL , MAXIMUS and SLAS.
Project Name : GWAM(Retirement Plan Services)
This project is use to provide financial advice, insurance as well as wealth and asset management through Retirement plan services. Various reports and Dashboards are built in MicroStrategy and Powebi.

Client : Morgan Stanley
Project Name : Cloud BI project
Morgan Stanley is multinational investment bank and financial services company. This project is used to provide financial advice through various division like Institutional securities, Wealth and Investment Management and Enterprise & Tech services.

Timeline

Power Bi Developer

Atos India
12.2018 - Current

Cognos | Spotfire Developer

Cognizant Technology Solutions
6 2013 - 12.2018

Bachelor Of Technology (B.Tech/B.E) - Information Technology

Dr Babasaheb Ambedkar Technological University, Lonere

Similar Profiles

CREATE PROFILE
Sarvina Sawant