Name: Kiran Somwanshi

E-mail: adcibi@r.postjobfree.com Mobile No.: +44-742*******

Summary:

Data Analyst with 11+ years of experience in interpreting and analyzing data for driving business solutions. Proficient knowledge in cloud technologies, statistics, mathematics, and analytics. Expertise in relational database, data architecture and T-SQL. Excellent understanding of business operations and analytics tools for effective analyses of data. Good knowledge of machine learning techniques. Skill Sets:

Google Cloud Platform:

BigQuery and Cloud Datalab to carry out interactive data analysis

Cloud SQL, BigTable and Datastore

Data processing on the Google Cloud Platform

Analytics functions in BigQuery

Data Analytics :

The ability to analyse, model and interpret data

Problem-solving skills.

A methodical and logical approach.

Accuracy and attention to detail.

Advanced excel techniques like writing macro and VBA lookup etc.

Business intelligence and ETL process

Programming - VBA, R, Python, C#, VB, Javascript

Expertise in database normalization, indexing, query optimization, performance tuning, views, stored procedures, user defined functions and triggers.

Strategic thinking and project management.

Data Visualization:

Google Data Studio (community connector), Tableau, Power BI Data Architecture: :

Data modelling - Produces data models and understands where to use different types of data models. Reverse engineer a data model from a live system.

Data standards - Develops and sets data standards for an organisation. Communicates the business benefit of data standards, championing and governing those standards across the organisation.

Turning business problems into data design - Works with business and technology stakeholders to translate business problems into data designs.

Metadata management - Designs and maintains the appropriate metadata repositories to enable the organization to understand data assets.

Communicating between the technical and the non-technical - to communicate effectively across organizational and technical boundaries, understanding the context. Machine Learning :

Supervised and Unsupervised learning techniques

Classification – Logistic regression, KNN, Decision trees, Random forests and SVM

Clustering – K means clustering, Hierarchical clustering Working Experience :

Current Organization: Tata Consultancy Services, UK Domain: Manufacturing

Designation: Assistant Consultant

Role: Senior Data Analyst

Experience: October 2013 to Till date

Previous Organization: iGATE, Pune

Domain: Insurance

Designation: Senior Software Engineer

Role: SQL Developer

Experience: From February 2011 to October 2013

Previous Organization: FinIQ Consulting Pvt Ltd., Pune Domain: Finance

Designation: Technical Consultant

Role: Application and SQL Developer

Relevant Experience: From January 2008 to February 2011 Educational Qualification &

Certifications

Certification: Introduction to Data Studio, Google Analytics Academy

Certification: Google Cloud Platform Big Data and Machine Learning Fundamentals by Google Cloud, July 2019, Coursera.

Certification: Certified Scrum Master, Nov 2017, Scrum Alliance, London.

Certification: Data Science and Analytics, Jan 2017, Marsian Technologies, Pune

M.Sc.(Computer Science), June 2008, Pune University.

B.Sc. (Computer Science), June 2006, Pune University. Projects:

#1.

Retailer Scorecard

Technologies used: Google Could Platform, Cloud SQL, Big Query, SAP ETL, Anaplan, Google Data Studio Organization: TCS

Customer: Jaguar Land Rover

Role:

Senior Data Analyst

Responsibilities:

Manage the planning and development of design and procedures for metrics reports

Develop new reports and delegated tasks to team members

Perform market analysis to efficiently achieve objectives

Investigate and conducted study on forecasts, demand, and capital for products

Successfully interpreted data to draw conclusions for managerial action and strategy

Understand the multiple source systems and relate the data with requirement.

Utilized Google BigQuery, Data warehousing programs, Google Data Studio, Tableau toolsets for data intelligence and analysis.

Work on data input for ANAPLAN and work with ANAPLAN model builder.

Communicate with different retailer market stakeholders to understand their requirement for market level KPIs.

#2.

COMPASS

Technologies used: Google Could Platform, Cloud SQL, Big Query, SAP ETL, SQL Server, Oracle, Anaplan Organization: TCS

Customer: Jaguar Land Rover

Role:

Data Analyst

Responsibilities:

Converted data into actionable insights by predicting and modeling future outcome

Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis

Successfully interpreted data in order to draw conclusions for managerial action and strategy

Proposed solutions to improve system efficiencies and reduce total expenses.

Presented data and conclusions to team in order to improve strategies and operations

Understand the multiple source systems and different technologies to pull the data.

Defined the data model in Anaplan to get expected outcome.

Supported planning system manager throughout planning cycle.

Communicated with different market stakeholders to understand their requirement and implement in COMPASS.

#3.

Enterprise Data Mapping

Technologies used: VBA, Macro, Oracle, Google App script, MQ Organization: TCS

Customer: Jaguar Land Rover

Role:

Data Architect

Responsibility:

Get involved in the requirements and design data model for application.

Prepared technical design document, perform code reviews.

Worked on SQL procedures, triggers, functions to support programme to fulfil the business requirement.

Implemented the business logic layer in database.

Application development.

#4

Supplier Sequencing Validation (SSVA)

Technologies used: ASP.Net 4.5, C# .NET, SQL server 2012, AJAX, jQuery, OPC Server, IIS Organization: TCS

Customer: Jaguar and Land Rover

Team Size: 4

Role:

Business Data Analyst

Responsibility:

Involved in requirement analysis.

Defined complete system flow and documented.

Convert business requirement in technical specification.

Configure Kepware OPC server

Designed application database.

Mentoring team members.

Documenting modules.

Personal Information:

Name: Kiran Anandrao Somwanshi

Passport No: S0446134

Current Address: Royal Leamington Spa, Warwickshire, England. Languages: English, Hindi, Marathi

Contact this candidate