Reena Tiwari

Reena is a seasoned Data Analytics leader with over 14 years of experience delivering large-scale solutions across Life Sciences, Health Care, Finance, Consumer Products, and Retail sectors. She specializes in Data Warehousing, Data Management, and Analytics, with proven expertise in optimizing processes, reducing maintenance overhead, and driving cost savings for clients. Reena excels at managing cross-functional teams and leading enterprise integration projects, particularly in healthcare applications. Skilled in Azure, Oracle Cloud, AWS, Informatica Cloud, Python, Tableau, and Power BI, Reena has managed global teams and complex projects, particularly in healthcare. She has extensive client-facing experience, excels in both Agile and Waterfall methodologies, and has led strategic initiatives and RFP responses at Deloitte. Reena is committed to helping organizations achieve data modernization and analytics/AI goals through innovative, scalable solutions.

Title: Manager, Strategy & Analytics

• Generative AI
• AWS Certified Cloud Practitioner
• Informatica Certified Consultant
• Hands On Essential - Snowflake
• Teradata Certified Professional
• Oracle Certified developer- SQL and PL/SQL
• Agile SAFe Certified

• Retail & Consumer Products, Data and Analytics Project Manager, Deloitte Consulting, Microsoft Azure data Analytics, MDM, PIM, OneStream, Sazerac Inc, Louisville, KY, 03/01/24, Present, Managed and lead five critical projects as part of DevOps for Azure DevOps, MDM DevOps, PIM, OneStream and Oracle Integration along with ServiceNow Automations., Led team of data engineers and DevOps to design, build and operate modern data platform on Azure for a greenfield implementation., Implemented a data quality framework along with actionable dashboards to capture late-arriving dimensions for business users and improve data accuracy by 25%, enhancing decision-making capabilities., Developed comprehensive points-of-view on data lineage and business glossary tools, leveraging platforms such as Azure Purview, Open Metadata and Collibra., Identified areas to reduce storage and data warehouse processing costs by 15% by implementing archiving and partitioning policies., Mentored team of 10 members on development and CICD best practices and increased team productivity., Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure Databricks, Azure SQL Database, Azure DevOps, Azure Cosmos NoSQL database, PostgreSQL, Azure Key Vault, MDM, e360 provisioning, ActiveVOS, Informatica Power Center, Informatica Data Director 10.2HF1, Data Quality 10.1, Oracle, PL/SQL, PowerBI, Jira Agile tool, ServiceNow
• Life Sciences and Health Care, Data & Analytics – Technical Project Manager, Deloitte Consulting, AWS Cloud & Informatica, Fresenius Medical Care – North America (FMCNA), Boston, MA, 01/01/22, 01/01/24, As a technical manager, I serve as a reliable point of reference for clients, adeptly navigating ambiguous situations., Overseeing strategic and data analytics workstreams, I manage a variety of large, complex projects, such as KCNG + AWS Data Analytics, iHUB Data Integration, BI Reporting, Government Reporting, and Nephrologixx., Quickly built trust with team and clients, impressing Account leadership with smooth application management., Focused on framing challenges and options to enhance project schedule and quality management., Coached team members to deliver error-free results within timelines, excelling at managing upwards by raising risks and monitoring tasks., Found creative solutions to ensure timely project launches, resulting in satisfied clients and strengthened alliances., Conducted regular reviews of data architecture, ETL processes, and data models to ensure scalability and performance., Troubleshot and resolved technical issues to uphold data warehouse system integrity., Collaborate with clients to understand their unique challenges, industry dynamics, and competitive landscapes., AWS Services (Glue jobs, S3, EC2, Lambda function, RDS, Athena, Data Pipeline, CLI process etc), Informatica Power Center, Informatica Data Director 10.2HF1, Data Quality 10.1, Oracle, PL/SQL, DB2, UNIX Shell scripting, Jira Agile tool, Autosys scheduler
• Finance (Banking), Data & Analytics – Technical Project Lead, Deloitte Consulting, EPH & PUB Conversion, M&T Bank, Buffalo, NY, 01/01/21, 12/31/22, Providing technical leadership in selecting and implementing data warehousing technologies and tools, ensuring scalability and performance., Leading the EPH team, prioritizing tasks, and motivating members for timely project completion., Integrating new source systems into EPH seamlessly, providing knowledge transfer for enterprise architecture., Delivering status reports for each source integration, participating in meetings to guide team according to requirements., Creating ETL mappings, sessions, and workflows, processing 280 ETL codes, and generating reports., Developing complex stored procedures and views to meet EPH standards at the database level., Implementing Unix shell scripting for dynamic batch processing., Conducting data profiling to identify anomalies, using Analyst tool for value, frequency, pattern, and data type analysis, and generating Scorecards for reporting., Informatica MDM 10.2HF1, Informatica Data Director 10.2HF1, Data Quality 10.1, SOAP UI, ActiveVOS, Informatica PowerCenter 10.1, Oracle 12cR2, SQL Developer 4.x, DB2, Teradata, UNIX Shell scripting, Eclipse, Jira Agile tool
• Life Sciences and Health Care, Data & Analytics – Technical Project Lead, Deloitte Consulting, Customer MDMD, Pfizer Inc., NJ, 01/01/20, 12/31/21, As part of Digital for Growth initiative to become a digital enterprise, Pfizer has been on the journey of establishing an integrated Modern US Customer Information Repository to provide accurate and up-to- date customer information across markets and engagement channels., Implement all the business rules within the MDM solution providing single version of truth across the enterprise., Extracted data from sources like fixed width and Delimited Flat files transformed the data according to the business requirement and then loaded into Target database., Worked on the architecture, standard inbound interface format, Initial and general data load strategy., Defined standard inbound interface based on the attributes and entities that need to be in Reltio MDM., Collaborated with client on functional requirement (FRD) to plan for MDM customer implementation., Reviewed multiple use cases to ensure that the entities and attributes modelled will supported based on FRD., Defined, review and finalize LOVs in RDM with source and target list of values for each source attribute identified to be part of LOV list., Informatica Power Center 10.1, Reltio MDM, IDQ Process, JDE, Oracle, Teradata, UNIX, Confluence, JIRA Agile tool, Informatica Cloud, MDM Workflows, ActiveVOS
• Life Sciences and Health Care, Data & Analytics – Project Delivery Lead, Deloitte Consulting, Legal Hold Application Project, Johnson & Johnson, 02/01/19, 10/31/20, Providing functional and technical leadership in a complex technical environment, designing efficient ETL systems for data migration and integration., Acting as the onsite test data management lead, coordinating test data prep activities and data loads for the enterprise data warehouse., Participating in all phases of the project SDLC, including planning, design, documentation, configuration, testing, and code migration., Collaborating with Business Users & Enterprise Data Architects to analyze and design conceptual and logical data models for solid MDM implementation., Working with Data Profiling Team to analyze source system data for duplicative and quality issues and performing data profiling using Informatica Data Analyst tool., Estimating project timelines based on business specifications, overseeing offshore team activities related to test planning and execution, and performing testing onshore as needed., Facilitating daily triage calls between Deloitte test team, client, and third-party consultant development team, and communicating status updates to senior project management and release team., Coordinating monthly production go-live activities among onshore and offshore resources., Utilizing Informatica ETL tool for loading data from source tables (SQL Server) to Staging and Core tables (Teradata) and running shell scripts through Informatica command tasks using Unix., Oracle, DB2, Informatica Power Center 10.1, Informatica Application Integration/ICRT, Teradata, SQL Server, UNIX, Confluence, JIRA Agile tool, Testing Automation tool
• Life Sciences and Health Care, Data & Analytics – Technical Project Lead, Deloitte Consulting, SPS Data Integration, Anthem Inc., Atlanta, GA, 01/01/17, 01/31/19, Providing advisory support for executive stakeholder communications on Data Compatibility., Creating stored procedures and running compatibility reports for CPF and GBD markets., Collaborating with the Enterprise Dashboarding Team on leading practices for SPS dashboards., Proactively identifying and addressing roadblocks hindering data compatibility tasks., Ensuring quality-focused MDM implementations align with client vision and goals., Creating reference data and mapplets in IDQ, importing them into Informatica., Developing high/low-level technical design documents and source-to-target mapping documents., Configuring MDM staging tables, foreign key lookups, and loading data using ETL Batch process., Addressing job failures, supporting testing phases, and validating environments., Participating in Daily standup, sprint refinement, and retrospective sessions., Proficiently mapping business processes and documenting AS-IS and TO-BE states using various process modeling tools., Oracle SQL Developer, Oracle PL/SQL, AWS, Informatica Power Center, Informatica MDM Hub Console, Informatica IDQ, Informatica Data Director, Confluence, Jira agile tool, Automation tools
• Life Sciences and Health Care, Data Migration -Tech Lead, Anthem Inc., WGS Pricing, 01/01/19, 12/31/19, Leading data migration efforts for SPS, identifying data quality issues, and designing ETL solutions for migrating data from legacy provider systems to SPS., Translating business requirements into technical specifications and gaining understanding of the healthcare provider domain., Collaborating with client product owners and legacy source SMEs to analyze data and devise migration strategies., Determining provider fee schedules and final allowable amounts for services rendered, returning pricing information to WGS Claims and TPAs., Designing data warehouses and preparing technical specification documents, ensuring adherence to enterprise standards., Conducting regular status meetings with customers and providing technical and functional leadership to the team., Participating in walkthroughs, reviews, and sign-off requests with client teams for implementations in various environments., Creating and scheduling batches, sessions, and workflows to facilitate end-to-end data processing from source to target., Oracle, PL/SQL, DB2, Informatica Application Integration/ICRT, Informatica Power Center 10.1, UNIX, Confluence, JIRA Agile tool, Service Now, Mainframe, Bit bucket
• Life Sciences and Health Care, Data Migration -Technical Lead, Deloitte Consulting, ABBI, Bayer Pharmaceuticals, NJ, 03/01/16, 12/31/16, Serving as a technical/functional lead for major sales reporting project development and Change Request Team, collaborating closely with client data stewards and business teams to gather requirements and write BRDs., Acting as a Solution Architect for sales reports across markets, responsible for design and TDD documentation, and inventorying existing reporting solutions., Collaborating with client leadership for regular status updates, scoping, reviewing deployments, and process improvement initiatives., Providing critical Sales – Account Hierarchy data to various stakeholders from Business Insights and Commercial Analytics teams., Managing day-to-day operations for business units (Neurology, Hematology, Radiology, and Intervention), overseeing multiple teams to ensure timely deliverables., Developing Informatica mappings and workflows using Teradata and conducting regular status meetings with customers., Demonstrating strong experience in Data Warehousing, Application development, and Quality Assurance testing using Informatica Power Center., Informatica Power Center 10.1, Oracle, MDM Hub Console, Teradata, Tableau, MDM, Veeva CRM, Microsoft Project, UNIX, JIRA, WinSCP