We provide IT Staff Augmentation Services!

Technical Architect Resume

SUMMARY

  • More than 14 years of IT industry experience encompassing a wide range of skill sets, roles and industries
  • 10+ years of experience in BI and Data Warehousing, specialized in Data Warehouse Architecture, Data Modeling, ETL Architecture and OLAP design.
  • Proficient in analyzing and translating business requirements to technical requirements, overall architecture and design
  • Experience of working with Enterprise Data Warehouse environment
  • Experience of working on BI Strategies and Roadmap for clients
  • Played role of a Data Architect from onsite as well as offshore
  • Extensive experience in design, delivery, deployment and management of BI and Legacy Application
  • Experience in Project Initiation, Planning, Executing, Monitoring, Controlling and Product Implementation Activities
  • Experience of working on proposals, proof of concepts and customer presentations
  • Experience of working in Insurance, Telecom and BNFS domains
  • Strong Analytical Skills, Self - motivated and Team oriented
  • Long experience of working at onsite (United Kingdom)

TECHNICAL SKILLS

Datawarehousing: ER Win, Datastage

RDBMS: DB2 UDB 8.1, Oracle, SQL Server

Languages: SQL, C, VB.

O/S: Windows NT/2000 Server, AIX

PROFESSIONAL EXPERIENCE

Technical Architect

Confidential

Responsibilities:

  • Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents
  • Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization, Analyze impact on Enterprise DWH
  • Transform Requirements into Logical / Physical Data Models
  • Develop new Data Model / Update the existing Models as needed
  • Creation of Physical Database Design and Database Architecture
  • Prepare Detail Estimates and Planning. Estimation for new Development after analyzing the changes
  • Present and defend product designs and architecture to clients
  • Utilize in-depth knowledge of functional and Technical experience in Data warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer

Environment: SSRS, SSIS, SQL Server

Enterprise Data Architect

Confidential

Responsibilities:

  • Responsible for leading a project team in delivering and maintaining DWH applications to our customer in the Automotive sector
  • Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents
  • Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization, Analyze product impact on overall enterprise DWH
  • Transform Requirements into Logical / Physical Data Models. Develop new Data Model / Update the existing Models. Create / Amend Data Marts
  • Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results
  • Creation of Physical Database Design and Database Architecture
  • Deliver new and complex high quality solutions to clients in response to varying business requirements
  • Responsible for managing scope, planning, tracking, change control, aspects of the project.
  • Responsible for capacity and hardware planning
  • Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
  • Utilize in-depth knowledge of functional and Technical experience in Data warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
  • Manage People, mentor them to manage their career goals
  • Manage Project by preparing estimates, Cost Case, project plan
  • Participate and preset project in various Delivery Excellence Audits

Environment: DB2 8.1, Datastage, AIX, Oracle

Data Architect / Data Modeling Team Lead

Confidential

Responsibilities:

  • Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents
  • Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact
  • Transform Requirements into Logical / Physical Data Models. Develop new Data Model / Update the existing Models. Create / Amend Data Marts as per the need
  • Creation of Physical Database Design and Database Architecture
  • Prepare Detail Estimates and Planning. Estimation for new Development after analyzing the changes
  • Present and defend product designs and architecture to clients
  • Coordinate and communicate tasks with developers
  • Ensure that development is performed as per requirements
  • Work with QA to create test scripts and scenarios for enhancements and customizations to the core product
  • Communicate activities/progress to project managers, business development, business analysts and clients
  • Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process

Environment: ER Win, DB2 8.1, Datastage

Product developer

Confidential

Responsibilities:

  • Key project implementations as Team Lead
  • Physical Database Design and Database Architecture, Team Leader, Data Modeling
  • Functional Design and Physical Database Design.
  • Develop, Design, Implementation and Administration of the Database
  • Continued support for production issues as third level production support specialist
  • Supported user community in defining Service Level Agreements (SLA)
  • Performance tuning, SQL query enhancements, code enhancements to achieve performance targets

Hire Now