Tata Consultancy Services is working with Sony Pictures Entertainment, specializing in ETL processes using IBM DataStage, Teradata, and Snowflake as our database, and data visualization with Business Objects & Tableau. Recognized for enhancing reporting capabilities and driving cloud migration initiatives. Strong problem-solving and collaboration skills ensure successful project outcomes and user satisfaction.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data,BI Engineer
Sony Pictures Entertainment
07.2022 - Current
Company Overview: Domain - Media & Entertainment
Effective resolution of job aborts and reconciliation queries using Teradata and IBM Data-stage
Ensuring prompt resolution of production issues in alignment with user requests via ServiceNow.
Implementing data warehousing solutions with seamless integrations across platforms like Teradata and Snowflake, utilizing IBM DataStage as the ETL tool.
Enhancing and maintaining interactive reports and dashboards using Tableau and SAP BusinessObjects.
Contributing to client-assigned enhancements and ongoing project improvement.
Collaborating with business analysts, data engineers, and other team members on on-premises to cloud migration initiatives.
Worked on migration: Business Objects universe migration, version upgrade migration.
D-series to Control-M migration.
Developed ETL processes to extract data from multiple sources and load into the Data Warehouse.
Developed custom reports based on user specifications using SQL Server Reporting Services.
Created complex SQL queries to support reporting needs.
Applied security measures into systems development, supporting final products' resistance to intrusion and exploitation.
Migrated existing database objects from development environment to production environment.
Monitored system performance metrics and identified areas of improvement in the architecture design.
Recommended improvements to facilitate team and project workflow.
Modified existing software to correct errors, adapt to newly implemented hardware or upgrade interfaces.
Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
Documented application designs, test cases and release notes for each project.
Reviewed project requirements to identify customer expectations and resources needed to meet goals.
Analyzed code and corrected errors to optimize output.
Collaborated with other teams such as software engineering, operations, testing and customer service on developing solutions that meet their requirements.
Content Writer, Social Media Management Intern
Tavishi (Social Vanture)
05.2021 - 01.2022
Collaborated with the team to ideate, research, and create engaging and simplified content for Tavishi's Instagram page
Intern
PING NETWORK
06.2019 - 07.2019
Developed and maintained both front-end and back-end functionalities using WordPress, effectively resolving errors on facetchecker.com
Additionally, validated data for various company websites, including IndiaSpend.com and BoomLive.in
Education
SSC -
St Coumba High School
01-2016
Skills
ETL - IBM DataStage 117
Teradata 1620
Business Objects
Snowflake
Tableau
Unix
Airflow
Problem solving
Collaboration skills
User requirements analysis
Effective communication
Content creation
Social media management
Data analysis
Accomplishments
Star of the Month - March 2024
SPE Encore - Excellence - March 2024
Star of the Month - Nov 2024
Hosted multiple townhall events
Certification
SQL Bootcamp by Udemy
Udemy Excel Beginners by Udemy
Excel for Beginners by Udemy
User Experience Course by Accenture
Figma UI UX Design Essentials by Udemy
User Experience Design & User Interface Design Fundamrntals by Udemy
Languages
Marathi
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Timeline
Data,BI Engineer
Sony Pictures Entertainment
07.2022 - Current
Content Writer, Social Media Management Intern
Tavishi (Social Vanture)
05.2021 - 01.2022
Intern
PING NETWORK
06.2019 - 07.2019
SSC -
St Coumba High School
Similar Profiles
Ximena Salazar HannaXimena Salazar Hanna
VP, Finance (Crunchyroll, LLC) at Sony Pictures EntertainmentVP, Finance (Crunchyroll, LLC) at Sony Pictures Entertainment