Summary
Overview
Work History
Education
Skills
Internships
Personal Information
Domain / Functional and Soft Skills
Languages
Accomplishments
CSR activities
Work Availability
Timeline
Generic

Rohan Kolpek

Mumbai

Summary

  • An experienced system analyst with over six years of experience in the finance and insurance industry.
  • He excels at translating business requirements into detailed technical specifications for system development, meticulously analyzing and documenting every aspect to ensure high-quality software solutions that meet or exceed customer expectations.
  • He is a strategist with exceptional problem-solving abilities and the ability to form robust client relationships.
  • He has a proven track record of performing consulting and business analysis in complex projects.
  • Good project management capabilities, as well as good communication and outstanding feedback from client & senior management.

Overview

6
6
years of professional experience

Work History

Systems & Business Analyst (Claims)

TATA AIG General Insurance Company Ltd.
Mumbai
06.2017 - Current
  • Collaborated with business stakeholders to understand business needs and analyze requirements, identify opportunities for process improvement, and translate them into technical requirements
  • Designed and implemented technical solutions to improve business processes and operations, resulting in a whopping 25% increase in productivity and a 90% reduction in processing times
  • Collaborated extensively with stakeholders and Business Analysts to ensure that technical solutions fulfilled business requirements and regulatory compliance and that solution were also accurately and effectively implemented
  • Created and maintained technical documentation for applications and processes that included functional specifications, business requirements documents, UI/UX design documents, and test plans
  • Experience working with QA team in area of preparing test cases, defect tracking, UAT and documentation of test cases
  • Participated and conducted system integration testing and user acceptance testing, debugging of software applications to ensure accuracy and functionality vis a vis the BRDs
  • Interacted and coordinated between end users, expert team, UX team, development and QA team and suggested key enhancements and changes to business flows
  • Performed technical support and troubleshooting for production systems
  • Conducted system training, prepared training documents for end-users and provide ongoing support
  • Development of Regulatory, MIS reports for internal management using qliksense, cognitive tools and Data Lake
  • Conducted extensive testing and debugging to ensure the accuracy and consistency of data mapping and extraction processes
  • Worked closely with the front-end development team to ensure seamless integration between front-end data input and backend data mapping and extraction
  • Carrying out analysis with claims data, preparing various weekly, monthly, quarterly and yearly reports for Claims
  • Handled audit queries and informed the corrective action plans to the committee
  • Identified discrepancies that may point to legitimate accounting errors or fraudulent records

Education

PGDM - Finance

Chetana’s Institute of Management And Research
Mumbai, India
05.2017

Bachelors of Management Studies - Management

S. K. Somaiya College of Science, Arts & Commerce
Mumbai, India
05.2013

H.S.C -

K. J. Somaiya College of Science & Commerce
Mumbai, India
05.2010

S.S.C. -

Holy Cross High School
Mumbai, India
06.2008

Skills

  • Microsoft Office: MS Excel and VBA, MS Word, Power point and Outlook
  • Databases: SQL, Excel, Data Lake
  • Data Analytics Tool: Qliksense
  • Quality Assurance / Defect Tracking Tools: JIRA

Internships

  

ICICI Securities Ltd.     Winter Intern (Oct 2015 to Jan 2016)

  • Spearheaded a winter research project analyzing ICFL's virtual stock platform; developed and implemented a user survey that increased survey participation by almost by 50% and provided valuable insights into user preferences

  

J. M. Financial Ltd.  Winter Intern (Jan 2016 to Mar 2016)

  • Analyzed pair trading strategy and Nifty short strangle performance using advanced statistical modeling techniques in Excel, leveraging MACD and RSI indicators, which resulted in a 20% increase in the team's trade recommendations. Took initiative in leading the development and implementation of statistical models and mentored strategic recommendations to enhance the overall trading strategy."

CRISIL Risk & Infrastructure Solution’s Ltd.  Winter Intern (Sept 2016 to Oct 2016)

  • Performed extensive fundamental research on the financial performance and growth prospects of 150+ listed Indian companies, resulting in accurately rating the high-potential investment opportunities, rating was completely based on the credit rating standards as provided by CRISIL

Personal Information

Hobbies and Interest: Cricket, Traveling 

Date of Birth: 01st September 1992

Domain / Functional and Soft Skills

Extensive experience in business analysis, systems analysis, and software development in the Insurance and Finance Domain

Strong knowledge of insurance products, business processes, and regulatory requirements

Excellent communication, problem-solving, and analytical skills

Solution Development

Product and Project Management

In-depth Analysis

Teamwork

Communication

Analytical thinking

Communication

Excellent analytical and critical thinking skills

Capable of determining risks, and suggesting appropriate measures to mitigate the same

Languages

English
Advanced (C1)
Hindi
Advanced (C1)
Marathi
Advanced (C1)

Accomplishments

  • Earned Tata AIG's Best Performer Award of Champion of Champions for the year 2020
  • Gold Medalist in the Final Year of Graduation
  • Worked on a research project titled "Creating a Successful Business Plan for an Entrepreneur."

CSR activities

  • Volunteered regularly with Sparsha Charitable Trust to mentor and support 2 groups of 5 impoverished children resulting in significant improvements in academic performance and their personal development.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Systems & Business Analyst (Claims)

TATA AIG General Insurance Company Ltd.
06.2017 - Current

PGDM - Finance

Chetana’s Institute of Management And Research

Bachelors of Management Studies - Management

S. K. Somaiya College of Science, Arts & Commerce

H.S.C -

K. J. Somaiya College of Science & Commerce

S.S.C. -

Holy Cross High School
Rohan Kolpek