We provide IT Staff Augmentation Services!

Data Architect / Data Tech Lead Resume

5.00/5 (Submit Your Rating)

New, YorK

SUMMARY

  • Experienced Data Architect; 15+ years of experience in successfully building data warehouse solutions, using best practices across diverse technologies and domains
  • Data warehouse strategist; conceptualization, system design, development, dimensional data modeling and implementation of enterprise data warehouse solutions. Expertise in design, development and tuning of ETL processes using Informatica and pl/sql procedures
  • Excellent communicator; leverage technical, business acumen to communicate effectively wif business sponsors and product managers
  • Expert in agile and waterfall project management methodologies. Able to manage large project teams and non for high - quality deliverables that meet or exceed timeline and budgetary targets

TECHNICAL SKILLS

Data Modeling: Dimensional Data Models / Star-Schema Design, 3rd NF, Data Governance, Logical and Physical database design, UML modeling

ETL: Informatica PowerCenter 9.1

Reporting Tools: Cognos PowerPlay 7.0, Business Objects XI, Crystal Reports 8.5/7.0

Programming: SQL, PL/SQL, Unix

RDBMS: Exadata / Oracle 11g / 10g / 9i, SQL Server 2000, Sybase

PROFESSIONAL EXPERIENCE

Confidential, New York

Data Architect / Data Tech Lead

Responsibilities:

  • Responsible for business requirement documentation, and functional and technical specs by partnering wif various Business groups and products.
  • Responsible for project effort estimate, risk analysis and mitigation, time-line management, resource loading
  • Responsible for architecture of teh system, design and development of data warehouse, data extraction, validation and loading process
  • Lead teh data governance day to day operations to deliver on information quality and build standardized data quality and audit reports
  • Responsible for logical and physical design of data model, e-r model
  • Optimization of existing Informatica mappings and workflows, PL/SQL scripts, query optimization, and indexing strategy successfully reduced teh execution time by over 60%, theirby ensuring data availability on time
  • Responsible for standardization and representation of data loads across teh systems and ensured that all team members follow teh best practices
  • Designed and developed a scalable architecture for data loads to teh warehouse, automated teh consumption process
  • Designed and developed mechanism to trap data issues and notify DSO’s
  • Standardized data templates for 3rd Party data ingestion.

Environment: Oracle 11g, Unix OS, Informatica 9.1

Confidential, New Jersey

Data Architect / Data Warehouse Architect

Responsibilities:

  • Responsible for project effort estimate, resource loading, risk analysis and mitigation, time-line management
  • Responsible for optimization of PL/SQL procedures
  • Responsible for identification of entities and attributes and developing logical model
  • Responsible for redesign of teh data model for load optimization, optimized performance and reducing data redundancy, query optimization
  • Optimization of PL/SQL scripts and BO universe and reports
  • Responsible for standardization and representation of data across teh systems
  • Designed teh data extraction, transformation, validation and loading process

Environment: Oracle 10g, Sun Solaris, ErWin 4.1, Informatica 8.1, BO XI

Confidential, New Jersey

Data Architect / Data Warehouse Architect

Responsibilities:

  • Responsible for project effort estimate, resource loading, risk analysis and mitigation, time-line management
  • Responsible for analysis of data and data profiling and identification of entities and attributes and developing data model
  • Responsible for design of teh logical and physical data model for migration of data to SingleStack
  • Designed teh logical and physical star-schema model for Customer reporting
  • Responsible for standardization and representation of data across teh systems
  • Designed teh data extraction, transformation, validation and loading process
  • Design of security requirements for teh data warehouse
  • Query optimization and indexing strategy

Environment: Oracle 9i, Sun Solaris, ErWin 4.1, Informatica 7.1

Confidential, New York

Data Warehouse Architect

Responsibilities:

  • Responsible for requirement gathering from Business Users
  • Responsible for identification of entities and attributes and logical and physical design of star schema model
  • Data profiling, data analysis and integration of data into teh warehouse
  • Used UML for conceptual modeling
  • Design of teh E-R and Dimensional data model for teh data marts
  • Administered teh data model in ErWin Modelmart
  • Responsible for standardization and representation of data across teh organization
  • Designed teh data extraction, validation and loading process
  • Review of data models and E-R models as part of teh Architecture team
  • Design of ETL load process

Environment: Oracle 9i, Sun Solaris, ErWin 4.1, Informatica 7.1, Cognos 7.0

Confidential, New York

Data Warehouse Architect / ETL Lead

Responsibilities:

  • Responsible for project effort estimate, resource loading, risk analysis and mitigation, time-line management
  • Responsible for modeling of star schema data mart
  • Designed teh data extraction, validation and loading process using Informatica 6.3 / 7.1
  • Optimizing of Informatica sessions and mappings
  • Responsible for data profiling and analysis
  • Responsible for optimization of Oracle code for upgrade of IE application (this involved study of interdependency of different data warehouse, database migration, removal of redundant code, optimizing teh data load by running multiple upgrades simultaneously, etc.)
  • Optimizing of PL/SQL queries and designing indexes for data warehouse
  • Responsible for upgrade of Informatica from 6.2 to 7.1
  • Extensively worked on Unix environment

Environment: Oracle 9i, Sun Solaris, Informatica 7.1 / 6.2, Business Objects

We'd love your feedback!