SARADA PRASANNA NATH

Tetra Pak India Private Limited, Pune

Senior Analyst

Product

Name : Telemetry and Analytics

Role : Data Analyst

Tools/Technology : PowerBI, SSIS, SSAS, MS VISIO, Python, SQL Server, Git, ServiceNow

Description:

Telemetry and Analytics is governing all data requirement of Technical Infrastructureaccross all other products of TI. The team is responsible for delivering the data/ report need usecases provided by all the products. Extracting data, transforming data and creating dataware house to do data analysisand provide proactice measures by decreasing the incidents.

Roles & Responsibilities:

• Extracting large datasets using SQL queries and Python scripts to identify trends, patterns, and correlations.
• Developed and maintained PowerBI dashboards and reports to provide actionable insights to key stakeholders.
• Designed and implemented ETL processes using SSIS to extract, transform, and load data from various sources into the data warehouse.
• Utilized SSAS to create tabular data models for business analysis and reporting purposes.
• Collaborated with cross-functional teams to gather business requirements and translate them into technical solutions.
• Conducted statistical analysis to uncover business insights and improve decision-making processes.
• Participated in data quality assurance efforts to ensure accuracy and reliability of data.

Capgemini Technology Services India Limited, Pune

Nov2016- Dec2019

Senior Consultant

Project

Name : Valkyrie

Role : Technical Analyst

Tools/Technology : C#, Angular JS, WCF, SQL Server, SSAS, UML, MS VISIO, Perforce & Rally,Autosys, Powershell.

Description:

Valkyrie is the new version of independent price valuation (IPV) system. Valkyrie is an application that present the data to the user and provides reporting, price testing, adjustment for the various products like Cash/Credit/FX/Equities/commodities.

Valkyrie Interfaces with Barclays which provides the enrich data from the bank’s front office systems and extend markets, and extracts the data to its own database and data warehouse.

Roles & Responsibilities:

• Involved in Development and Enhancement.
• Involved in Requirement gathering.

· Implementation of the CR(s) of various module of application which involve developing WCF service, database design, sp creation etc.

· Analyzing and fixing production defect

· Creation of Powershell scripts for automation

• Creation and deployment of autosys jobs.
• Solving issue related to server, sanity check, deployment etc.
• Development of cube and it’s deployment in SSAS db.

SenecaGlobal IT Services Pvt Ltd, Hyderabad

Sep 2015- Oct 2016

Technical Analyst

Project

Name : Unidos Financial Service

Role : Technical Analyst

Tools/Technology : MVC, WCF, SQL Server, UML, MS VISIO, TFS & JIRA.

Description:

Unidos Financial Service application is a money transfer application used to send money across various countries in USA.

Roles & Responsibilities:

• Involved in Development and Enhancement.
• Involved in Requirement gathering.
• Created on Usecase, System UseCase documentation.
• Developed design models such as sequence diagram, activity diagram and Class Diagram.
• Done analysis and impact analysis of the assigned task before coding.
• Prepared Analysis Documents and Effort Details of the assigned task.
• Implemented PCI Compliance Coding based on approved Analysis documents.
• Implemented Data Driven Testing.
• Prepared QA Documents and executed Unit Test cases for the assigned task.