Summary
Overview
Work History
Education
Skills
Education Certifications
Core Technical Competencies
Professional Development
Timeline
Generic

Tanushree Paul

Irving

Summary

Banking (Global Funding) - Utilities – Retail Energy – Telecomm - Retail & Distribution – Pharmaceuticals Results-driven Data & Information Management professional with 19+ years of experience delivering large-scale data warehouse, business intelligence, and analytics solutions across Banking, Energy, Telecom, Retail, and Pharmaceuticals. Over the past several years at Bank of America, I’ve led complex ETL (Informatica) development, data architecture, and strategic reporting initiatives that directly supported Global Banking, Compliance, and Investment business lines. Recognized for bridging business needs with technology through data-driven insights, automation, and process optimization.

Overview

20
20
years of professional experience

Work History

Senior Informatica Developer

Bank of America
Dallas
06.2017 - Current
  • End-to-End ETL Ownership: Designed, developed, and deployed complex Informatica PowerCenter and IDMC workflows for multi-terabyte data pipelines, improving data processing efficiency by 30–40% across platforms.
  • Data Architecture & Modeling: Developed and maintained dimensional and relational data models supporting profitability, compliance, and client intelligence analytics; ensured 100% alignment with enterprise data standards.
  • Performance Optimization: Tuned Oracle PL/SQL and Informatica mappings to enhance ETL job performance and minimize data latency, reducing nightly batch runtimes by 35%.
  • Data Governance & Quality: Implemented robust validation, transformation, and audit controls to ensure complete traceability, reconciliation accuracy, and compliance with internal regulatory standards.
  • Cross-Functional Collaboration: Partnered with Quantitative Finance, Risk, Compliance, and Global Banking teams to align data architecture with business KPIs and regulatory objectives.
  • Automation & Efficiency: Automated scheduling and monitoring using Autosys and Quartz, reducing manual interventions by 40% and increasing operational reliability.
  • Agile Leadership: Actively participated in Agile ceremonies (story grooming, sprint planning, retrospectives) and led cross-shore coordination for seamless delivery across global teams.
  • Production Stability: Provided L3 production support for multiple mission-critical data platforms, ensuring 24×7 data availability and uninterrupted reporting continuity.
  • Strategic Business Enablement: Delivered curated datasets for Salesforce CRMA, Regulatory Reporting, and Profitability Dashboards, directly supporting executive decision-making and client engagement analytics.
  • The Corporate Investment Data Warehouse (CIDW) is the centralized data backbone for the Corporate Investments Group at Bank of America, supporting global operations across Americas, EMEA, and APAC. The platform integrates data from 50+ upstream systems into a dimensional data warehouse, enabling seamless access to accurate, reconciled information for Front Office, Middle Office, Quantitative Finance, and Risk Management functions.
  • Environment: Informatica Power Center (9.6.1 / 10.2 / 10.5.6 / CDIPC / IDMC (Intelligent Data Management Cloud) Oracle Exadata (sql/pl-sql), Unix shell scripting, Toad, TeraData, WinSCP, Putty, Perforce, Version one, Jira, BitBucket, Quartz, Scheduler- Autosys
  • Team Size: 7

Lead ETL Architect / Developer

Verizon / Infosys
Dallas
01.2016 - 05.2017
  • Led Informatica PowerCenter–based ETL design, managing extraction and transformation for customer and order data across 10+ legacy systems.
  • Automated validation, reconciliation, and load processes, reducing manual intervention by 40%.
  • Partnered with business and technical teams to define transformation logic and ensure successful data cutover.
  • Ensured adherence to agile delivery and quality control standards across development and testing cycles.
  • Technology Environment: Informatica PowerCenter 9.6.1, Oracle 11g, Unix, Autosys, LSA Framework
  • Team Size: 6

Lead ETL Developer

Oncor / IBM
Dallas
01.2010 - 12.2015
  • Designed and optimized ETL jobs to process high-volume smart meter data from MDMS, LCIS, and Maximo systems.
  • Improved operational data availability, supporting real-time forecasting and regulatory audit readiness.
  • Enhanced system reliability by implementing query tuning and workflow redesign, reducing job failures by 25%.
  • Collaborated with cross-functional teams to support IBM’s Smart Grid initiative for Oncor’s advanced metering rollout.
  • Technology Environment: Informatica PowerCenter 9.6.1, Oracle 10g, IBM Informix, Unix, Cognos, Sun Solaris
  • Team Size: 8 to 10

Senior ETL Developer

Pfizer / IBM
New York
11.2009 - 01.2010
  • Developed complex Informatica mappings for multi-source data extraction and transformation into Pfizer’s centralized data warehouse.
  • Streamlined data delivery and validation cycles, enhancing reporting accuracy for global sales teams.
  • Coordinated with offshore QA teams to implement standardized testing and validation scripts.
  • Technology Environment: Informatica PowerCenter 8.6.1, Oracle 10g, Unix, Autosys
  • Team Size: 5 to 8

Senior ETL Developer (COMET Project)

Merck & Co. / IBM
NJ
06.2009 - 11.2009
  • Designed and implemented ETL workflows to integrate finance and product master data into Merck’s ERP data hub.
  • Created reusable ETL templates and optimized transformation logic, reducing data load time by 30%.
  • Supported global data validation, ensuring alignment with enterprise master data standards.
  • Technology Environment: Informatica PowerCenter 8.6.1, SQL Server 2000, Unix, Cranberry
  • Team Size: 2 to 4

ETL Developer

TELUS / IBM
Kolkata
06.2008 - 06.2009
  • Designed and built Informatica mappings and PL/SQL scripts to integrate data from multiple operational systems.
  • Automated Control-M job scheduling to ensure stable batch execution and reliable data loads.
  • Collaborated with onsite stakeholders in Canada to validate end-to-end DWH operations.
  • Technology Environment: Informatica PowerCenter 8.6.1, Oracle 10g, Control-M, Toad, Unix
  • Team Size: 10 to 15

ETL Developer

ConvaTec / IBM
Kolkata
03.2008 - 06.2008
  • Developed and enhanced DataStage jobs and sequencers to migrate legacy data into SAP targets.
  • Validated migrated datasets for completeness and accuracy, enabling on-time ERP go-live.
  • Technology Environment: IBM DataStage v8.1, DB2 v9.5, SAP, Unix

ETL Developer

Nestlé Global / IBM
India
11.2006 - 03.2008
  • Designed ETL mappings in Informatica to extract and load data from regional legacy systems to global SAP databases.
  • Improved reusability by developing parametric ETL templates, reducing configuration effort across new market rollouts.
  • Supported data validation, cleansing, and user acceptance testing during country migrations.
  • Technology Environment: Informatica PowerCenter 6.2, Oracle 9i, IBM DB2, Unix
  • Team Size: 8 to 10

Education

Master of Computer Applications -

Vellore Institute of Technology
01.2006

Bachelor of Computer Applications -

St. Xavier’s College
Ranchi
01.2003

Skills

  • ETL / BI Tools: Informatica PowerCenter (6x–10x), IDMC, DataStage, Business Objects, Cognos
  • ETL development
  • Data architecture
  • Performance tuning
  • Data governance
  • Data analysis
  • Agile project management
  • Cross-functional collaboration
  • Problem solving
  • Microsoft SQL server
  • SQL development
  • API integration
  • UNIX shell scripting
  • Informatica cloud
  • Data validation
  • Business intelligence
  • Data modeling
  • Data migration
  • Informatica MDM
  • Risk mitigation
  • Data profiling
  • Data cleansing
  • Informatica powercenter proficiency
  • Design development
  • Data warehousing concepts
  • Version control systems
  • Data cleansing techniques
  • Informatica cloud services
  • Mapping skills
  • Data migration strategies
  • Software deployment
  • Design and development
  • Agile methodologies
  • Databases: Oracle (9i–11g, Exadata), SQL Server, DB2, Teradata
  • Languages / OS: SQL, PL/SQL, Java, UNIX/Linux, Windows
  • Scheduling / SCM: Autosys, Cybernation, Quartz, Perforce, Bitbucket, Jira
  • Processes / Frameworks: Agile (SAFE), IBM QMS, RUP, OPAL, SDLC / QA best practices

Education Certifications

  • Master of Computer Applications, Vellore Institute of Technology, 06/2006
  • Bachelor of Computer Applications, St. Xavier’s College, Ranchi, 06/2003
  • DB2 Universal Database V8.1 Family Fundamentals (701)

Core Technical Competencies

Informatica PowerCenter (6.x–10.x), IDMC, DataStage, Business Objects, Cognos, Oracle (9i–11g, Exadata), SQL Server, DB2, Teradata, SQL, PL/SQL, Java, UNIX/Linux, Windows, Autosys, Cybernation, Quartz, Perforce, Bitbucket, Jira, Agile (SAFE), IBM QMS, RUP, OPAL, SDLC / QA best practices

Professional Development

  • SAFE Agile & PMPO Training
  • IBM DataStage, Business Objects, DB2, and BI Certifications
  • Advanced Unix Shell Scripting & Risk Management
  • Energy & Telecom Industry Domain Training

Timeline

Senior Informatica Developer

Bank of America
06.2017 - Current

Lead ETL Architect / Developer

Verizon / Infosys
01.2016 - 05.2017

Lead ETL Developer

Oncor / IBM
01.2010 - 12.2015

Senior ETL Developer

Pfizer / IBM
11.2009 - 01.2010

Senior ETL Developer (COMET Project)

Merck & Co. / IBM
06.2009 - 11.2009

ETL Developer

TELUS / IBM
06.2008 - 06.2009

ETL Developer

ConvaTec / IBM
03.2008 - 06.2008

ETL Developer

Nestlé Global / IBM
11.2006 - 03.2008

Master of Computer Applications -

Vellore Institute of Technology

Bachelor of Computer Applications -

St. Xavier’s College
Tanushree Paul