KASHISH KHANDELWAL

Phone number: +91-829*******, 827*******

Email: ac9rhn@r.postjobfree.com

Career Objective :

To make a sound position in the corporate world and work enthusiastically in a team to achieve organizational and personal goals.

Work Experience:

Business Technology Analyst – ZS Associates India Pvt. Ltd. – Pune, MH (April,2018 – April,2019). Projects Handled :

1.OE-PA.

Roles and Responsibilities:

Planning and estimation of development modules and business logic with the raw data. Involved in technical design and flows for the project which is built on ZS internal tool- Orchestration Engine (OE) where a medical rep gets the suggestions for a particular HCP as well as for an area that has HCPs that require similar type of action, so as to increase their sales.

Developed the Extract-Transformation-Load mapping designs and flows in Flow builder (Informatica based tool) using SQL.

Worked on AWS environment (S3 and EMR), Hive, Putty and Spark to run the customized steps which are used to create the final output file.

Tested the application (front-end and ETL designs) end-to-end with proper Documentation.

Coordinated with the other team to sync the outputs and match the granularity to bring them at a level where they could be consolidated.

2.BMS.

Roles and Responsibilities:

Analyzed the raw data to build the mappings for the ETL Transformation. Worked on ZS internal tool- Orchestration Engine (OE), which is based on NBA (Next Best Action) type suggestions.

Worked on the business logic for the development so that medical reps get the suggestions for their next activity based on their previous interaction with HCPs and hence increase their sales.

Developed the transformation in Flow builder (Informatica based tool), using SQL, Spark, Hive, Putty along with UI configurations to get the output files which is required in OE for further process. 3.GSK.

Roles and Responsibilities:

Planning and estimation of development modules by analyzing the raw data. Involved in technical design and business logic manipulation. Built on ZS internal tool - Orchestration Engine (OE) which is based on FS (Field Suggestions) where medical reps get the suggestions based on the current activity with the HCPs and their interaction data.

Performed Smoke Testing, Unit Testing end-to-end, tested the Veeva application system where the medical reps get the suggestions for their interaction with the HCPs, with proper documentation.

Created the mappings for the ETL Designs and flows. Developed the Extract-Transformation-Load process in Flow builder (Informatica based tool) using SQL, to get the output files.

Worked on Hive, Spark, Putty, Salesforce, AWS environment. Configured the Veeva UI app (CLM) on back end. 4. Sage Therapeutics.

Roles and Responsibilities:

Analyzed the raw data to build the database and flow of the application which is built by a ZS internal tool- Javelin Application Catalyst (JAC) that allows the medical Reps to fill in the details and feedbacks after their interaction with a HCP and hence increase their sales by getting the target HCPs.

Developed the front-end part which has all the questionnaires and functionalities.

Worked on SQL and Iron python scripts on back-end.

Tested the application from end-to-end – Unit testing, Regression testing with proper documentations.

Software Developer Trainee- iNautix Technology ( BNY Mellon) – Pune, MH (June,2017 – August,2017)

Designed, developed and tested a software application on online website in Dot Net framework using C#, Asp.Net, WCF, MVC and SQL.

Software Skills:

SQL, ETL flow (Informatica), Salesforce and AWS environment.

Data Analysis and Data Warehousing.

Hive, Putty, Spark.

UnitTesting, Smoke Testing, System Testing, Regression Testing.

Basics in C, C#, HTML, Python.

Project Management and team leadership.

Excel, Microsoft Word and Power Point Presentation. Education :

S. No University/School Degree Field Percentage

/CGPA

Year of passing

1 KIIT UNIVERSITY,

Bhubaneswar

B. Tech Electronics and

Telecommunication

7.3 2017

2 NALANDA ACADEMY,

Kota

XII CBSE 77% 2013

About Me:

Good at socializing and interacting with people.

Keen listener and quick learner.

Good at managing people and likes to work in a team.

Fond of travelling and watching movies.

Active in sports.

Contact this candidate