Data Analyst Engineer

Sanjeev Ranjan

Nyati Elan, WAGHOLI, Pune - ******

+91-772******* **********@*****.*** Sanjeev Ranjan(LinkedIn)

Professional Summary

Strong analytical & quantitative skills, Research professional and skilled in analyzing patterns & trends in large data sets, requirement gathering and project management and exposure in Data Mining, Exploratory Data Analysis, ML, SQL, Requirement discussion and DWH. Strong Knowledge of Retail, eCom and BFSI(Loans) domain.

Skill Sets

Business Analyst Skills

• BRD, SAD, RTM, GAP Analysis

• AS-IS TO-BE process, UAT

• Use case, User Story

Machine learning Skills

• Regression Techniques, Predictive Analysis

• Exploratory Data Analysis

Domain Knowledge

• Retail and eCommerce

• BFSI (Loans)- HL, AL, PL, EL

Programming Skills

• Python

• PHP

• MySQL and MSSQL

• AWS, Azure

Big Data and Business Intelligence (Visualization)

• ETL process, Dataware house, Data Ingestion, Hue, Hive

• Data acquisition, data lake creation, data migration

• PowerBI, Tableau, Datameer

Employment History

June 2018 – Present

(1 year 10 Months)

BigData – Lead Business Analyst at Exadatum Software Services Pvt Ltd

Requirement discussion, scope finalization and create BRD and SAD documentation

Data Analysis and generate insights / EDA for data science and BigData related projects like creating data lake, Database migration, External data source ingestion, Business analytic etc.

Lead and manage Data Science and Big Data Projects and participate in architecture and solution discussion. Responsible for end to end delivery

Manage tasks in JIRA and maintain project health

Undertake POCs and its implementation

Create business Dashboards in PowerBI and Tableau using various data sources

Data testing and UAT

June 2016 – June 2018

(2 Years 1 Month)

Senior Business Analyst at Tetramedia Pvt. Ltd. (At State Bank of India, GITC)

Requirement discussion with Bank's business team and officials and create Business

Conduct demo with Bank Officials at corporate center

Create BRD and process flow and get approval on the same

Managing onsite team and coordinating with offshore team

Create work breakdown structure after approval on BRD

Technical discussions with other teams and Bank's department

Gap Analysis and AS-IS To- BE Analysis

Participating in getting security approval from Bank's security department

Integration testing and User Acceptance Testing

Worked on all major loans like Home Loan, Auto Loan, Personal loan, Education Loan and Agri Loans

Integration with Finn One LOS (Loan Originating System) systems and its different phases like DDE, QDE, CBS, CIBIL, eKYC, de-dup checks, property verifications, R/O verifications, legal etc and loan account creations after sanctioning the loan

May 2015 – June 2016

(1 Year 1 Month)

Senior Business Analyst at Datametica Solutions Pvt. Ltd.

Requirement discussion with client and onsite Business Analyst

Data analysis from heterogeneous sources using sql queries and hive queries on Hadoop platform

Data Analysis and work on KPIs and create STM (Source Target Mapping) for data acquisition and strategy for storing data in Work, Raw and Insight layers and transformations at each layer

Data validation, writing test case and UAT

Create visualization dashboards on datameer

Lead the data acquisition track

Jan 2013 – APR 2015

(2 Years 3 Months)

Senior Business Analyst at Talentelgia Technologies Pvt. Ltd.

Requirement discussion and work on Business Requirement Documentation

Requirement analysis and conduct POC as required

Create work breakdown structure and create project plan

Act as a project manager and ensure end to end delivery of projects

User Acceptance Testing before handing over to the client

Participate and sales closure and negations

Oct 2011 – Dec 2012

(1 Year 3 Months)

Business Analyst at Zapbuild Technologies Pvt. Ltd.

Communication with client and requirement discussion

Project scope finalization

Create WBS and project plans

Team handling and ensure end to end delivery

Assist organization in sales closures and technical discussions

Jun 2005 – Oct 2011

(6 Years 4 Months)

Business Development Manager at smartData Enterprises(I) Ltd.

Worked a software engineer and developed web applications in PHP

Application development in several domains like eCommerce, social networking, marketplace etc.

Worked as PHP Team Lead and handling multiple projects

Assist organization in pre-sales activities and created work break down structure and business proposals

Worked as Business Analyst in requirement analysis and scope finalization

Assisted organization in sales closures

Education

Executive MBA From IIM Lucknow (2011 – 2012)

Master of Computer Application (MCA) From UP Technical University (2002 – 2005)

Bachelor of Science from Ranchi University (2001)

Senior Secondary from BIEC (1997)

High School form BSEB (1995)

Extra-Curricular Activities

• Took ETL and PowerBI hands on session in MIT, Pune

• Represented my college at university level sports and cultural activities

Languages

• Hindi

• English

Declaration

I hereby declare that all the information mentioned above is true as far as my best knowledge is concerned

Contact this candidate