Objective

I bring over 8 years of industry experience as Data Warehouse Architect, Data Analyst, Data Warehouse Designer and Data Modeler with a focus on Oracle, Teradata and DB2 database implementations. I offer exceptional skills in Data Warehouse Design, Data Integration, Data Quality, Metadata Management, Business Intelligence, Logical Data Modeling and Dimensional Modeling,

PROFILE SUMMARY

• Currently working as Technical Lead Data Architect with Wipro for a US based retail giant.
• Prior to Wipro, employed as Technical Architect in Target Corporation Ltd responsible for implementing a BI Enterprise Data Warehouse.
• Proficient in standardizing design approaches through standard principles and guidelines, design templates and best practices.
• Proficient in providing technical expertise throughout the life-cycle of a project.
• Experienced in designing Technical Architecture and solutions with an Enterprise vision.
• Experienced in gathering business requirements from clients and converting them to technical specifications.
• Experienced in designing Testing strategy and test plans, as per business process.
• Experienced in designing BI applications from a technical perspective, identifying and resolving design flaws early in design life cycle.
• Proficient in performing problem analysis, root-cause analysis, and outlining resolution options for business critical issues.
• Experienced in application development and system testing to meet client's business needs.
• Experienced in automating business process and designing scalable and repeatable processes.
• Experienced in project estimation and product evaluations.
• Extensive experience with co-ordination with offshore team and user community and able to work as part of a large, multi-vendor client team.
• Highly motivated self-starter, independent, highly adaptable and excellent interpersonal skills.

SKILLS/TOOLS:

DataStage 8.5 / 7.5 Informatica PowerCenter UNIX Shell Scripts

Control M Oracle Database PL/SQL

DB2 UDB Teradata Database Quality Center

Erwin SQL Developer Advance Query Tool

Item Management System Microstrategy Perl Scripts

Swiss Log WM Tool Cognos 3D WM Tool

MAJOR ASSIGNMENTS:

Technical Project Lead

Confidential

Roles and Responsibilities:

• Retail Domain Expert.
• Reverse Data Modeling existing BI solutions and optimize the existing BI architecture.
• Data Modeling new BI applications.
• Simplifying existing Data Architecture.
• Act as single point of contact to consult on application technical architecture.
• Design solutions that meet development and infrastructure requirements.
• Gather business requirements from clients and converted them to technical specifications.
• Coordinate data modeling effort with Enterprise Data Warehouse Architects and Modelers.
• Responsible for integration with other applications.
• Responsible for ensuring high quality deliverables by following standards and best practices.
• Design high performing, and scalable repeatable processes.
• Leading resolution of large and complex production system issues.
• Co-ordinate with support partners, knowledge transitioning of architecture and design of this application.
• Participate in project estimation and evaluation.

Skills:

DWH Architect Designing, BI Designing, SQL, Teradata, Erwin, DataStage, Oracle, UNIX, CDC 7.0, Quality Center,Control M, Retail Domain, DB2.

Technical Architect/Project Manager

Confidential

Roles and Responsibilities:

• Domain Consultant for Distribution Subject Area.
• Lead application designer and system architect.
• Conducted Resource Planning Project Effort estimation.
• Onshore Project Manager for Project execution.
• Created Project Execution Plans and Risk Mitigation Plan.
• Onshore Technical Lead for Data Integration team.
• Acted as single point of contact to consult on application technical architecture.
• Designed solutions that meet development and infrastructure requirements.
• Coordinated data modeling effort with Enterprise Data Warehouse Architects and Modelers.
• Responsible for integration with other applications.
• Responsible for ensuring high quality deliverables by following standards and best practices.
• Design high performing, and scalable repeatable processes.
• Leading resolution of large and complex production system issues.
• Co-ordination with support partners, knowledge transitioning of architecture and design of this application.
• Participated in project estimation and evaluation.

Environment:

Teradata 13 Teradata Utilities, Erwin, DataStage 8.5, Oracle, Swiss-Log Warehouse Management, 3D Warehouse Management, Microstrategy, UNIX, CDC 7.0, Quality Center, Control M.

Technical Architect

Confidential

Roles and Responsibilities:

• Domain Consultant/Subject Matter Expert for Vendor Income Processing project.
• Lead application designer and Architect.
• Onshore Technical Lead for Data Integration team.
• Participated in data modeling for foundation and semantic layer.
• Gathered requirements from the business and converted them to Technical design.
• Provided High Level design to the team, and reviewed the low level design.
• Ensure application design standards and integrates with enterprise data warehouse.
• Acted as single point of contact to advise on application technical architecture.
• Involved in semantic design and coding of complex semantic objects.
• Led testing effort ensuring business approves reports generated on VIP warehouse.
• Review test cases, ensuring all business scenarios are verified and tested.
• Participated in project estimation and evaluations.

Environment:

DataStage 8.5, UNIX, Teradata 13, Microstrategy, Web Focus, CDC 7.0, Quality Center, Control M

Tech Lead/Project Lead

Confidential

Roles and Responsibilities:

• Onshore Technical and Project Lead.
• Designed solutions that meet development and infrastructure requirements
• System designer - designed the application at a high level and provided inputs to team to perform low level design.
• Technical Delivery owner for 7 of 14 projects in PARS.
• Involved in data modeling of 7 projects.
• Ensure data quality is accurate of enterprise data warehouse and as per business requirements.
• Innovated Junk Char solution for Target Corporation.
• Lead a peak team size of 70 developers and testers.
• Led team in resolution of large, complex production system issues.
• Performance tuned the projects to meet business expectations.

Environment:

DataStage 8.5, UNIX, Teradata 13, UDB, Microstrategy, Quality Center, Control M

Module Lead

Confidential

Roles and Responsibilities:

• SME for Item Management Currently Pursuing this role .
• Module Lead Led the development and implementation of Item module in MBI.
• Designed, coded, tested and implemented item module in production.
• Led a team of 8 developers and offered them technical suggestions and helped in defect fixes.
• Developed test cases/plans to ensure successful implementation of technical solution.
• Fixed defects and code bugs identified during testing.
• Performed unit, component, and integration testing for Item module.
• Performed problem analysis, identifies root causes, and outlines resolution options for business critical issues.
• PL/SQL codes to support data warehouse structure.
• Set up Control M to schedule jobs in production and ensured data flow integrity.

Environment:

DataStage 7.5 Parallel, UNIX, UDB Db2 9 database and utilities, Control M, Quality Center, Microstrategy, Item Management system knowledge.

Module Lead

Confidential

Roles and Responsibilities:

• Software Developer / Module Lead.
• Low level design and coding of small module in production.
• Performed unit, system, integration and component testing.
• Supported user acceptance testing for that module.
• Analyzed interrelationships and impacts of various systems and applications upon the Client technical environment.
• Control M set up for that module to ensure hierarchical data flow.
• Implemented the module in production and supported till it became stable.

Environment:

DataStage 7.5 Parallel, UNIX, UDB Db2 9 database and utilities, Control M, Quality Center, Microstrategy.