Omkar Deshpande
Mumbai
Summary
Experienced data professional with a Master's degree in Information Design and over 8+ years of related work experience, seeking a challenging position in BI Development where can leverage expertise in database technologies, data warehousing, data modeling, programming, and team leadership to deliver innovative solutions and drive business success for clients. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Senior Consultant
STAPLES
09.2023 - 02.2024
- Provided mentorship to junior consultants, enabling them to enhance project contributions through improved skills.
- Delivered high-quality solutions for clients by conducting thorough research and analysis on industry trends.
- Developed and implemented regional pricing schemes for daily/weekly tactical activities, while assisting in development of long-term strategies.
- Responded promptly to data requests, providing accurate information in timely manner.
- Communicates and develops good rapport with sales professionals and management across functions.
- Contributed to enhancement of tools and processes through collaboration with Pricing Manager and Pricing Officer, allowing for improved response to customer demands
Applicaon Analyst
STATE STREET
11.2022 - 08.2023
- Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
- Improved internal knowledge sharing by developing comprehensive documentation outlining standard operating procedures for various tasks.
- Responsibility to support both U.S. and “offshore” team resources in testing, application, integration, product, regression and user acceptance.
- To provide link between customer, development team and any third party regarding software functionality, throughout development lifecycle.
- Create test plans and test scripts for features and/or regression testing. Run tests on multiple environments to ensure full, complete testing cycle.
- Manage product documentation and provide training to client service teams
Data Analyst II
FREDDIE MAC
06.2022 - 10.2022
- Utilized data visualization tools to effectively communicate business insights.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Implemented an advanced quantitative analysis model using Python that boosted prediction accuracy by 25% as opposed to conventional methods.
- Diversified and managed $50M investment portfolio with less than 2% default rate through rigorous credit analysis protocols
- Worked closely with the asset management team to enhance investment strategies, resulting in a 10% decrease in risk-adjusted return volatility.
Data Analyst
JPMORGAN CHASE & CO
01.2022 - 05.2022
- Generated monthly reports utilizing advanced Excel spreadsheet functions.
- Utilized data visualization tools for clear communication of business insights.
- Developed predictive model using Python and SQL to identify under-performing assets, resulting in $1M increase in annual revenue through portfolio adjustments.
- Utilized Tableau to automate financial report generation, saving the department roughly 10 hours weekly on manual data entry.
- Assisted in developing a tailored analytics dashboard alongside the IT department to optimize real-time performance metric monitoring for enhanced stakeholder reporting.
- Enhanced corporate visibility through creation of data insights report, recognized for uncovering untapped revenue opportunities and influencing investment strategies.
Business Analyst
CHARTER COMMUNICTIONS
02.2021 - 11.2021
- Monitored and evaluated key performance indicators for Mobile Apps and Omni-channel products
- Worked closely with cross-functional areas (IT, Design, UX, Merchandising, Finance, Marketing) and third-party vendors on project definition and execution.
- Stay updated on th evolving mobile space and latest best practices within product area, including competitor offerings.
- Executed A/B test optimizations by identifying areas of improvement.
- Tracked, prioritized, and successfully executed product backlog.
- Actively contributed in team meetings by sharing knowledge, exchanging ideas, addressing challenges, and collaborating on potential solutions.
- Developed high-quality training documentation to enhance understanding of new systems and procedures.
Business Analyst
SHARP INFOTECH
04.2020 - 01.2021
- Led team in implementation of data warehouse solutions, resulting in improved data accessibility and analytical capabilities for clients.
- Developed ETL processes to extract, transform, and load data from various sources into data warehouse, ensuring data integrity and consistency.
- Designed and implemented logical and physical data models to support business requirements and optimize database performance.
- Collaborated with cross-functional teams to develop and maintain SQL queries, stored procedures, and scripts for data analysis and reporting.
- Provided technical expertise and guidance to team members, ensuring project deliverables were completed on me and within budget
Data/Business Analyst
BUAUT TECHNOLOGIES
06.2019 - 03.2020
- Contributed to design and execution of test scenarios and scripts.
- Succeeded in effectively utilizing SQL queries to retrieve data from relational databases.
- Coordinated and executed software testing by developing QA test cases, creating test scripts, release notes, and verifying user requirements.
- Skilled with content management tools like HTML and XML.
- Identified and resolved software issues, including SQL troubleshooting
Manager
KOTAK MAHINDRA BANK
04.2014 - 01.2017
- In-depth knowledge of international rules and practices , governing Standby Letters of Credits, Guarantees and Documentary Letters of Credit
- Accomplished multiple tasks within established timeframes.
- Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.
- Letters of Credit, especially Trade, Performance, Advance Payment, Bid SBLCs, Bank Guarantees, and other Contract Bonds
- Front Office experience interfacing with Corporate Clients
Senior Execuve
IBM INDIA PVT LTD
02.2012 - 02.2012
- Enhanced mission success rates by diligently monitoring sensor activity in critical operations.
- Checked trade documents under Letter of Credit in accordance with ICC Rules, including UCP 600.
- Assisted in the execution of Trade Finance operations, including Letter of Credit issuance, export documentation management, and payment processing.
- Worked closely with AML/KYC Document Control and GTB Compliance departments in TS&FI to track and communicate progress on compliance issues.
- Assisted in backup for manager trade.
Associate
TATA CONSULATANCY SERVICES
03.2008 - 07.2010
- Sound knowledge of Uniform Customs and Practice for Documentary Credits (UCPDC 600), ISBP 645, URC 522, URR 725, URDG 758, INCOTERMS 2010, SWIFT messages.
- Provided authorizations for trade instruments and verified and/or released transactions through T360 system.
- Processing of Letter of Credit transactions (Issuance, Advising, Document Examination, Discounting, Payment and Settlement) and Documentary Collections.
- Effectively contributed to Trade Services client experience by ensuring that established Service Level Agreements are consistently met.
Education
Master of Science - Data Analytics
NORTHEASTERN UNIVERSITY
Boston,Massachusetts01.2019
MBA - Finance
ATHARVA SCHOOL OF BUSINESS
Malad, Mumbai01.2012
Bachelor of Commerce - Commerce
DALMIA COLLEGE
Malad, Mumbai01.2007
Skills
- Data Visualization and Presentations
- POWER BI
- Excel Functions
- TABLEAU
- Statistical Analysis
- Tableau
- Technical Analysis
- Software Development Life Cycle (SDLC)
- A/B Testing
- Sentiment Analysis
- SQL and Databases
- Python Programming
Languages
ENGLISH
Certification
- Certified ScrumMaster (CSM)
- BLOOMBERG FINANCE FUNDAMENTALS CERTIFICATE
- ENVIRONMENTAL SOCIAL GOVERNANCE
- BLOOMBERG MARKET CONCEPTS
Timeline
Senior Consultant
STAPLES
09.2023 - 02.2024
Applicaon Analyst
STATE STREET
11.2022 - 08.2023
Data Analyst II
FREDDIE MAC
06.2022 - 10.2022
Data Analyst
JPMORGAN CHASE & CO
01.2022 - 05.2022
Business Analyst
CHARTER COMMUNICTIONS
02.2021 - 11.2021
Business Analyst
SHARP INFOTECH
04.2020 - 01.2021
Data/Business Analyst
BUAUT TECHNOLOGIES
06.2019 - 03.2020
Manager
KOTAK MAHINDRA BANK
04.2014 - 01.2017
Senior Execuve
IBM INDIA PVT LTD
02.2012 - 02.2012
Associate
TATA CONSULATANCY SERVICES
03.2008 - 07.2010
Master of Science - Data Analytics
NORTHEASTERN UNIVERSITY
MBA - Finance
ATHARVA SCHOOL OF BUSINESS
Bachelor of Commerce - Commerce
DALMIA COLLEGE
Similar Profiles
Liam HronisLiam Hronis
Tech Sales Associate at StaplesTech Sales Associate at Staples
Maxwell SartorMaxwell Sartor
Sales Associate at StaplesSales Associate at Staples
Wilson MosqueraWilson Mosquera
Warehouse Laborer at StaplesWarehouse Laborer at Staples