Vikrant Purohit
Mumbai
Summary
Qualified Business Intelligence Analyst versed in data mapping and user acceptance testing to solve complex problems in high-pressure environments. Activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings.
Overview
3
3
years of professional experience
Work History
Data Analyst
Quantafic Business Solutions
Mumbai
2023.06 - 2024.04
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Created predictive models to forecast customer behavior.
- Provided data-driven solutions to support decision making.
- Gathered requirements from stakeholders to design data models and reports.
- Leveraged SQL queries to extract, transform and load data into databases.
- Translated raw data into meaningful information using statistical techniques.
- Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.
- Collaborated with stakeholders across the organization to understand their needs from a data perspective.
- Maintained documentation of all the processes related to Data Analysis.
- Utilized advanced analytics tools such as SAS, SPSS, Excel PowerPivot, to manipulate large volumes of data sets.
- Interacted with non-technical stakeholders to deliver analyses and answer questions on deliverables.
- Collected business intelligence data from industry reports, public information or purchased sources.
Software Developer
triumph system and solutions
Mumbai
2021.09 - 2023.05
- Developed programs to automate processes and improve user experience.
- Integrated innovative development techniques to shorten turnaround times and spur code running process.
- Identified and communicated potential risks and roadblocks to properly execute projects.
- HIghlighting of potential borrowers and identify customers who are at risk of defaulting on loans.
- strategies to reduce the risk or minimize its impact.
- A significant focus area is evaluating the creditworthiness of loan applicants. This involves analyzing financial statements, credit scores, and other data to determine the likelihood of loan defaults.
- Accumulating data from different sources to create base and shared it with CIBIL team. Creating data validation logic's as per RBI guidelines. Highlighting issues related to data discrepancy, duplicacy. Based on customers credit worthiness per-approved offers were provided.
- Extracting incorrect data related to customers personal information. Data was shared with product team to check and rectify incorrect flow of data. Developing reports.
Education
Bachelor of Science - Statistics
K.C. College
Mumbai, India2021-05
Skills
- Writing queries for data requirements , molding unique requirements into logical querying execution format and fetching data. (SQL)
- Designed data marts which were used for analysis. (SQL)
- Handling Triggers. (SAS & SQL).
- Generating reports. (SAS)
- Automating data deliveries. (SAS)
- Handling urgent requirements and punctual delivery of data was add on.(SQL&SAS)
Timeline
Data Analyst
Quantafic Business Solutions
2023.06 - 2024.04
Software Developer
triumph system and solutions
2021.09 - 2023.05
Bachelor of Science - Statistics
K.C. College
Similar Profiles
Abhilash MudpeAbhilash Mudpe
Business Analyst & QA Analyst at Quantafic Business Solutions PVT.LTDBusiness Analyst & QA Analyst at Quantafic Business Solutions PVT.LTD
PRAVEEN KUMARPRAVEEN KUMAR
Senior Technology Manager at Business Consulting and Solutions, RXG Business Consulting and SolutionsSenior Technology Manager at Business Consulting and Solutions, RXG Business Consulting and Solutions
Prasanna Dhanasekaran (9003154363)Prasanna Dhanasekaran (9003154363)
Senior Subject Matter Expert at Connect Business solutions (formerly TATA Business Support solutions)Senior Subject Matter Expert at Connect Business solutions (formerly TATA Business Support solutions)