Tanya Sinha Data Analyst

Phone: 206-***-****

Email: adg5rj@r.postjobfree.com

PROFESSIONAL SUMMARY:

1. 5 years of experience in Data Warehousing and design, analysis and development of jobs, dashboards and scenario in ETL and reporting tools. 2. Extensively worked in developing applications using Oracle DB and proficient in query languages SQL, MySQL, Teradata and Redshift

3. Had experience in designing and developing Cognos and Tableau reports, dashboards. 4. Experience in designing parallel, sequential DataStage jobs using multiple stages. 5. Performance tuning in DataStage, Cognos and also knowledge in unit testing. 6. Experience in using Director for validation, running and monitoring of jobs and view logs. 7. Have knowledge in Master Data Management (Category, File feeds, Workflow, Context, Kalido server) and MDM admin.

TECHNICAL SKILLS:

1. Tools: Cognos 10 Report studio, Tableau Desktop, DataStage 9.1 &11.7(ETL), Master Data Management, Python for Data Analysis.

2. Databases: Redshift, SQL,Oracle, Teradata, Netezza, Basic Unix. EDUCATION:

Bachelor of Technology: Bhilai Institute of Technology in Electronics and Telecommunication (2014) WORK EXPERIENCE:

PROJECT #1:

Title: Anheuser-Busch, InBev

Duration: June 2019-Oct 2019

Project Description:

This project gave an opportunity to develop my skill sets in DataStage(ETL). Teradata and Oracle, Redshift DB’s. Also, learnt Master data management & Bteq scripts. There were many enhancement and development requirements from user side handled Role and Responsibilities

• Hands on in fixing DataStage (ETL) job problems as well as development from scratch.

• YBPA application development which involved learning the Bteq scripts. Scripts running Aster database was converted to Bteq. DataStage and Tivoli jobs were created from scratch to load source table required for script. Also, reduction in objects and removing redundant data from existing script to reduce the time and effort.

• Hands on in creating Tivoli jobs i.e. IBM workload scheduler.

• Job level enhancements as and when required and implementation of the same using version control process.

• Defect fixing and backtracking to fix the issues

• Preparation of root cause analysis documents and SOP’s for any critical problem fix. PROJECT #2:

Title: Cognizant Internal Heathcare

Duration: May 2017-Oct 2019

Project description

Analyzing the Health of a Country's economy with the GDP, malnutrition and population. Analyzing how education changes the rate of unemployment and creating awareness of the malnutrition and creating dashboards.

Roles and Responsibilities:

• Understanding requirements and Functionality of the application from specification, Designing and maintaining the Tableau function Reports based on user requirement.

• Work closely with Business users.

• Utilizing the Tableau server to publish and share the reports with the business users.

• Hands on building groups, hierarchies, sets to create detail level summary reports and Dashboard using PI's Experience in Marks, Publisher and Security concepts and used multiple measures like Individual Axes, Blended Axes and Dual Axes.

PROJECT #3:

Title: TJX GPS SS

Duration: Nov 2015-May 2017

Project description

It was a support and enhancement project. Continuous maintenance and enhancement ticket for all production applications, doing root cause analysis and fixing production issues within the SLA, implementing change requests and maintaining consistency across environments. Role and Responsibilities

• Supporting the applications pertaining to retail industry and fixing the ETL load issues within predefined SLA’s.

• Job level enhancements as and when required and implementation of the same using version control process.

• Defect fixing and backtracking to fix the issues at report level.

• Preparation of Business Understanding Technical Documents, test cases, root cause analysis documents etc.

• Perform Unit, Assembly and System testing for the change requests proposed and providing KT sessions to team members.

PROJECT #4:

Title: TJX GPS SS

Duration: Jan 2015-Nov-2015

Project Description:

The purpose of Crystal to Cognos Conversion was to implement enhanced features of Cognos into already existing crystal reports by re-creating report studio reports in Cognos 10. Role and Responsibilities

• Analysis of existing reports and requirement gathering.

• Rationalizing the reports to reduce the existing count of reports.

• Providing Demo’s to the client with various options to go along.

• Development of new report studio reports in C10 with additional requirements and enhancements.

• Unit testing of reports, defect fixing.

• Following up for migration of reports from Dev to QA and QA to PROD.

• Preparing UTC, TDD etc.., on the same.

• Providing warranty support until project closure

Contact this candidate