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