SUMMARY:

• Solution driven Data Architect / Data Warehouse Architect, with over 15 years of experience in leveraging IT driven solutionsto meet business needs. Ability to think out - of-box and has achieved 100% on-time delivery of projects and business goals. Seeking opportunities to transform business needs to cost-effective solutions. Successfully delivered defect free code across projects.
• Experienced Data Architect : 15+ years of experience data analysis, data profiling, design of dimensional data model for data warehouse, and demonstrated ability to design e-r model for user interface application.
• Data warehouse strategist : Demonstrated ability in conceptualization, design, and development of data warehouse solutions. Expertise in architecture, design, development of ETL processes using Informatica and pl/sql procedures and unix script. Designed and developed reusable components to reduce code redundancy. Successfully optimized pl/sql scripts and Informatica mappings by reducing the cycle time by over 50%. Implemented best practices and standards.
• Managing and delivery of projects : 10+ years of experience in Project planning and budgeting, Effort estimation, resource estimation, planning and scheduling, Project Lifecycle management, scope control and successfully delivered on time and budget. Successfully managed team across multiple locations.
• Expert in agile, waterfall and six sigma project management methodologies . Over 10 years experience in planning, budgeting, scheduling, resource planning, and life cycle management of projects. Successfully delivered 100% projects on time and budget. Followed Agile methodology to plan sprints, and handled the role of scrum master.
• Excellent communicator : Quick learner and demonstrated ability to understand and meet business needs and provide solutions, work independently and initiate techno-functional communication to meet project requirements.

TECHNICAL SKILLS:

DATA MODELLING: Dimensional Data Models / Star and Snowflake schema design, E-R modeling, Data Governance, Logical and Physical database design using ERwin, UML modeling

ETL: Informatica Power Center 9.1

REPORTING TOOLS: Cognos Power Play 7.0, Business Objects XI, Crystal Reports 8.5/7.0

PROGRAMMING: SQL, PL/SQL, Unix

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

PROFESSIONAL EXPERIENCE:

Confidential, PA

Data Architect / Data Warehouse Architect

Responsibilities:

• Business requirement analysis, source system data analysis and profiling, gap analysis and documentation of specs
• Effort estimation for the project, resource estimation, task scheduling, dependency scheduling, project tracking and delivery
• Responsible for the logical and physical data model, definition of the entity and attributes, deployed the data model to the database
• Design and development of data warehouse, defining and developing the data transformation rules and develop process using Informatica and Oracle. Created mappings, reusable components, and workflows, extracting data from SAP
• Achieved over 40% efficiency in optimization of existing PL/SQL scripts, query optimization
• Design of tables and indexes, partitioning strategy
• Optimization of Informatica mappings and workflows
• Designed and developed a scalable architecture for data loads to the warehouse, automated the consumption process
• Developed unix scripts and used Control-M scheduler

Environment: Oracle 11g, Unix OS, Informatica Power Center 9.1

Confidential, New Jersey

Data Architect / Data Warehouse Architect

Responsibilities:

• Responsible for requirement analysis, data analysis and profiling, functional and technical specs by partnering with BA and SME
• Project effort estimation, delivery scheduling, resource loading and tracking, on-site / offshore delivery model
• Define the entities and attributes for the logical data model, design of dimensional data model for the data warehouse, deployed the data model to the database
• Architect, design and development of data warehouse, data extraction, validation and loading process using Informatica and Oracle. Created mappings, reusable components, and workflows
• Responsible for standardization and best practice implementation of data load framework across the systems
• Developed unix scripts and scheduled using cron

Environment: Oracle 11g, Unix OS, Informatica Power Center 9.1, DB2

Confidential, New York

Data Architect / Data Tech Lead

Responsibilities:

• Business requirement analysis, data analysis and gap analysis, preparation of specs and review with business group
• Project task dependency scheduling, effort estimation, costing, resource planning, delivery scheduling, managing the project between on-site / offshore teams
• Design of dimensional data model for the data warehouse, defined the e-r model, deployed the data model to the database
• Architected the framework for the data warehouse, design and development of data extraction, validation and loading process using Informatica and Oracle. Created reusable components thereby leading to reduction of code
• Responsible for standardization and best practice implementation of data load framework across the systems
• Optimization of PL/SQL scripts, query optimization, and indexing strategy
• Optimization of Informatica mappings and workflows, successfully reduced the execution time by over 60%, thereby ensuring data availability on time
• Lead the data governance day to day operations to standardize, protect, deliver on information quality and build standardized data quality and audit reports
• Developed unix scripts and used cron and autosys scheduler to schedule jobs

Environment: Oracle Exadata, Unix OS, Informatica Power Center 9.1

Confidential, Georgia

Data Architect / Data Warehouse Architect

Responsibilities:

• Requirement analysis, data analysis and profiling, functional and technical specs
• Project effort estimation, delivery scheduling, resource loading and tracking, on-site / offshore delivery model
• Define the entities and attributes and their relationships for the logical data model, design of dimensional data model for the data warehouse, deployed the data model to the database
• Define the architect, design and development of data warehouse, and created mappings, reusable components, and workflows in Informatica
• Responsible for standardization and best practice implementation of data load framework across the systems
• Pl/SQL scripting, optimization of PL/SQL scripts, query optimization, and indexing strategy
• Optimization of Informatica mappings and workflows, successfully reduced the execution time by over 60%, thereby ensuring data availability on time
• Designed and developed a scalable architecture for data loads to the warehouse, automated the consumption process
• Developed unix scripts and used cron and autosys scheduler to schedule jobs

Environment: Oracle 8.1.7, Sun Solaris, Informatica 5.1/6.2, Cognos