Tanusri Mishra
Pune,India
Summary
Data architect with over 12 years of experience. Expert in setting up the data pipelines/ELT for migrating large scale data into cloud-based data lake or data warehouse. I have a great understanding of data used in the financial industry and have deep experience in creating data models and have worked with various data modelling tools. I am also very well versed in data products from AWS specifically AWS Data Brew, Glue, S3 based data lake, AWS data lake formation as well as Snowflake.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
Work history
IT Chapter Manager
Siemens Energy
Pune, India
06.2023 - Current
- Effectively manage and support migration of legacy applications and assure data acquisition.
- Manage strong operational working relations with internal and external key stakeholders.
- Manage and lead an integrated team of internal and contract staff to execute projects.
- Requirement grooming for Data Analytics & Data Engineering.
- Develop communication and reporting matrix and ensure consistent use across enterprise.
- Develop data governance and standards, assure usage of correct software tools with security.
- Ensure support for developing operating models and appropriate delivery methodology for all the opportunities within Siemens Energy.
- Ensure selecting the correct team with skills, experience and know-how for any open requirement or issue.
Manager Technology
Stratacent
Delhi, National Capital Territory of Delhi
12.2018 - 06.2023
- Client: Invesco/Bancorp/Moody's
- Setting up the data pipelines/ELT for migrating large scale data into cloud-based data lake or data warehouse.
- Development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms
- Cleanse, transform, reconcile, and standardize data by creating new or modifying existing scripts/automation as needed to ensure high quality data is available to meet business requirements.
- Architected new databases, tables and dictionaries for project-specific requirements.
- Trained and mentored junior database personnel to share best practices and standardize strategies.
- Wrote queries using SQL to retrieve, build, delete or update information in database.
- Maintained legacy databases and assisted with migrations to new systems.
- Devised processes to handle ETL needs and eliminate bottlenecks.
- Make recommendations for ETL/ELT design and performance enhancements for large data volume loads and processing.
- Worked successfully under Agile methodologies to deliver on-time projects.
Senior Software Engineer
Marlabs Software Private Ltd.
Gurgaon, India
11.2017 - 02.2018
- Client: ZS Associates
- Development of Informatica mappings and complex PL/SQL code.
- Perform data analysis and database management.
- Design and implement technology best practices, guidelines, and repeatable processes.
- Database performance tuning.
Module Lead
Persistent System
Hyderabad, India
06.2017 - 09.2017
- Client: Wells Fargo
- Develop high-quality database solutions.
- Develop, implement and optimize functions and procedures using T-SQL.
- Review and analyze ongoing business requirements.
- Build useful and efficient reporting for deliverables.
- Analyze existing SQL queries and suggest new ones for performance improvements.
- Create scripts and procedures for data migration and offer timely scheduled reporting.
Senior Software Engineer
Tech Mahindra
Hyderabad, India
05.2015 - 02.2017
- Client: GSK
- Handle proper data storage for a company or organization.
- Use Informatica software to design and maintain data storage systems.
- Assess the data requirements that a company may have.
- Load and test available data.
- Analyze data warehousing systems.
- Resolve and provide solutions to any issues that may arrive.
- Create proper technical documentation outlining the entire process.
- Develop data warehousing systems by using Informatica tools.
- Integrate warehousing systems with an organization or company’s existing systems.
- Troubleshoot and debug any issues while integrating.
- Conduct quality checks on the stored data on a regular basis
Systems Engineer
TCS
Hyderabad, India
02.2011 - 04.2015
- Client: JPMC
- Development experience in delivering ETL/database/programming solution.
- Good hands-on experience in below informatica concepts
o Performance tuning
o Data modeling and data ware housing concepts
o Reusable transformations
o Partition techniques - Strong database knowledge Oracle PL/SQL, tuning.
- Good knowledge on UNIX scripting
- Able to write complex relational Oracle/SQL server queries to help with data validation.
- Expert in writing Oracle procedures, functions, packages and debugging the code.
Education
Bachelor of Technology - Information Technology
JNTU
India 06.2006 - 05.2010
Skills
- Agile project management
- ETL
- Data warehouse
- Informatica Power center
- SQL (Oracle/T-SQL/SQL Server)
- PL/SQL
- AWS
- Snowflake
- Data modelling
- Performance tuning
- Query optimization
- Python
- Git
- Qlik Replicate
Languages
English
Fluent
Hindi
Fluent
Bengali
Native
Telugu
Intermediate
Timeline
IT Chapter Manager
Siemens Energy
06.2023 - Current
Manager Technology
Stratacent
12.2018 - 06.2023
Senior Software Engineer
Marlabs Software Private Ltd.
11.2017 - 02.2018
Module Lead
Persistent System
06.2017 - 09.2017
Senior Software Engineer
Tech Mahindra
05.2015 - 02.2017
Systems Engineer
TCS
02.2011 - 04.2015
Bachelor of Technology - Information Technology
JNTU
06.2006 - 05.2010
Similar Profiles
Eric HoambreckerEric Hoambrecker
Application Specialist at Siemens Energy (formerly Siemens AG)Application Specialist at Siemens Energy (formerly Siemens AG)
IMRAN SIDDIQUIIMRAN SIDDIQUI
Senior Associate Consultant at INFOSYS PVT LTD, CLIENTS- Siemens Gamesa and Siemens EnergySenior Associate Consultant at INFOSYS PVT LTD, CLIENTS- Siemens Gamesa and Siemens Energy
Aileen Sue Ping LeeAileen Sue Ping Lee
Regional Service Manager at SIEMENS MALAYSIA SDN BHD/SIEMENS ENERGY SDN BHDRegional Service Manager at SIEMENS MALAYSIA SDN BHD/SIEMENS ENERGY SDN BHD
Jenna Clare PowellJenna Clare Powell
Maintainability Administrator at Siemens EnergyMaintainability Administrator at Siemens Energy
Uday AgrawalUday Agrawal
Splunk Consultant at BirlaSoft Limited & Cummins GlobalSplunk Consultant at BirlaSoft Limited & Cummins Global