Data Architect / Data Tech Lead Resume
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