PROFESSIONAL SUMMARY:

• 15 years of experience in the area of Information Technology with experience in requirement analysis, architecture & design, development, testing and implementation of database applications on Teradata / Oracle / SQL Server / Windows / Unix based platforms.
• Experience in Relational Data Modeling, Data Warehouse Design, Dimensional Modeling, Extract/Transform/Load (ETL) Design, Data Marts, Meta Data Repository, Data Governance, Data Quality, and Client - server applications.
• Expert level Data architecture, Database design, Data analysis, Business Intelligence-Analytics-SQL skills
• Excellent programming skills in Teradata, Oracle SQL & PL/SQL
• Teradata and Oracle Certified
• Excellent analytical, problem solving, communication and interpersonal skills with ability to master new concepts, ideas and practices
• Technical Management: Lead initiatives with complete autonomy and accountability for results. Provide direction and guidance to assigned project personnel

TECHNICAL SKILLS:

Databases: NCR Teradata V2 R13 / V2 R6 / V2 R5 / V2 R4.1Oracle 10g/9i/8i/8.x/7.xMicrosoft SQL Server 2000

Design Tools: ERWIN 7.3.10, ERWIN 3.5.2, Oracle Designer/2000 ( Ver. 1.x, 2.x )Microsoft Visio

Development Tools: Teradata SQL Assistant, SQL*PLUS, TOADQueryMan 6.0, BTEQ 6.0, BTEQ 8.02,WINDDI 5.0Teradata Administrator 6.0, Teradata Multi Load, Fast Load, Fast ExportTeradata Parallel Transporter (TPT), Developer/2000 ( Ver. 1.x, 2.x, 6.x )Metadata Management: MIRW ( Meta Integration Repository Works ) from MITI

ETL Tools: Informatica 8.5.1, Microsoft SQL Server DTS

OLAP Tools: Microsoft Analysis Server

Source Control Tool: PVCS, Harvest

Languages: SQL, PL/SQL, C, Pascal, Fortran, Cobol

Operating Systems: Windows 2000/NT/98/95, UNIX

Office Tools: Microsoft Word, Microsoft Excel, Microsoft Project, Microsoft Power Point

PROFESSIONAL EXPERIENCE:

Data Architect

Confidential, Dallas, TX

Environment: Teradata V2 R14.0, Erwin 9.0

Responsibilities:

• Designed Semantic Layer for PBM Data Warehouse
• Provide best practices for data warehouse design approach
• Analyze business requirements and produce technical design documents and table level design specifications
• Requirement Analysis, Data Elements Analysis, Data Analysis, Data Mapping, Logical and Physical Data Modeling, Technical design documents, Solution Architecture are the key tasks
• Performance improvement analysis and provide solution
• Review Physical Design of tables and recommend proper Primary Indexes and Secondary Indexes
• Perform design review and data model reviews
• Perform code review, data analysis, data quality, data validation and data integrity checks
• Support developers and QA during development and testing phases
• Support business users, reporting users
• Defined data model standards. Key point of contact for Data Model related tasks
• Data Model owner. Manage data model version control
• Develop SQL code in Teradata SQL Assistant, assist developers.
• Performance analysis, break down of the code into smaller logical steps, proper Primary index for the intermediate volatile tables, STATS on joining columns etc

Senior Data Warehouse Consultant / Data Architect

Confidential, Dallas, TX

Environment: NCR Teradata V2 R13.0, Teradata Tools and Utilities, Erwin 7.0

Responsibilities:

• Work on requirements, design, architecture for integrating new data sources into BIDW
• Identify gaps, perform gap analysis between source system and data warehouse
• Prepare high level design documents ( HLD ), Data Model, Application Interface documents ( AID ), Application Design Documents ( ADD ), DA Table level Specs.
• Co-ordinate with various teams involved in the project
• Provide SQL code to developers
• Support developers and QA during development and testing phases
• Perform code review
• Support business users

Senior Data Warehouse Consultant

Confidential, Southlake, TX

Environment: NCR Teradata V2 R12.0, Teradata Tools and Utilities, Erwin

Responsibilities:

• Participate in requirements gathering
• Prepare Functional requirement documents ( FRD), Technical design documents - High level design ( HLD )
• Define Application Design methodology
• Design process flows, data flows, architectural diagrams
• Provide project estimates, level of effort (LOE)
• Design logical, physical data models
• Perform data analysis, write table level specifications
• Analyze reporting requirements with various business units and prepare reporting specifications
• Provide SQL Code to developers
• Support developers in development. Perform code review
• Lead development, implementation phases
• Support adhoc reporting needs
• Evaluate new work requests

Senior Data Warehouse Consultant/Technical Lead

Confidential, Dallas, TX

Environment: NCR Teradata V2R12.0, Teradata Tools and Utilities

Responsibilities:

• Lead UAT test efforts
• Perform Data Validation and Integrity tests
• Assist Marketing Users with Queries and Reports development
• Support Metrics Reporting

Senior Technical Architect / Lead Data Analyst

Confidential, Dallas, TX

Environment: NCR Teradata V2 R12.0, Teradata Tools and Utilities, Oracle 10g, Informatica 8.5.1Unix-Sun Solaris, Erwin 3.5.2, Visio

Responsibilities:

• Gather requirements and prepare Functional requirement documents ( FRD)
• Prepare technical design documents - High level design ( HLD ), Application design
• Design process flows, data flows, architectural diagrams
• Provide project estimates,level of effort (LOE) and work with program managers in creating project plans based on approved charters and track key milestones
• Design logical, physical data model
• Write table level specifications
• Author system interface agreements ( SIA ) for interfaces involved connecting BID to various other applications within the organization
• Perform data analysis, data quality, data validation and data integrity tests
• Design data audit methodologies
• Lead data analyst in the AT&T Mobility data quality program supporting data quality audit processes and data quality s for AT&T Mobility Data Warehouse.
• Manage a team of data analysts, provide direction and assistance
• Manage production incident report issues
• Monitor Audit dashboard
• Responsible for definition, development, monitoring, troubleshooting, root cause analysis and support of data quality management processes
• Worked with operations team and developers to resolve data/audit issues
• Worked with project teams to define and validate data quality plans for several downstream/upstream applications covering key areas of 132 TB of EDW data
• Support Infrastructure related projects

Senior Data Warehouse - Business Intelligence Lead Architect

Confidential, Dallas, TX

Environment: NCR Teradata V2R 5.0, Teradata Tools and Utilities, Microsoft SQL Server 2000Microsoft Analysis Services, Erwin 3.5.1, Visio.

Responsibilities:

• Technical lead of Data delivery projects
• Involved in JAD sessions with the Marketing Information team. Identify business questions (BQ’s) and participate in preparing General Design Specification (GD)
• Involved in the design of Data Model titled EDGE ( Enterprise Data Gathering Engine ) for EDW ( Enterprise Data Warehouse )
• Involved in the design and development of several data marts like RCAD ( Residential Customers Analytical Design), BCAD ( Business Customers Analytical Design), Encore which were part of the ongoing development for aEDW.
• Architect of Meta Data Repository ( MDR ) using MetaIntegration (MITI) toolset, and designed a Common Warehouse Metamodel on top of the data warehouse. MDR supports multiple data model versions and mapping info from legacy systems.
• Design Star Schemas; Design Fact table and Dimension tables
• Design and Code ETL processes to load data into OLAP models
• Introduced analytics to user community as opposed to flat reporting
• Create Dimensions and build Cubes using Microsoft Analysis Server
• Develop Analysis, Canned and Adhoc reports
• Perform code review with the developers and fine-tune the code for performance improvement. Mentoring and Managing junior staff.
• Lead end-to-end implementation of several Analytical Applications
• Perform data validation and Integrity tests
• Assist users with queries and report development
• Performance tuning of user queries
• Analyzed the risks & scope of the project, acted as a bridge between the upper management and the development teams
• Estimate size of projects and provide level of effort ( LOE )
• Coordinated UAT testing efforts. Wrote traceability & testing plans.
• Interacted with clients on a regular basis with project updates and concerns.

Software Engineer

Confidential

Environment: Designer/2000 Ver. 2.x, Developer/2000 ( Ver. 2.x, 6.x ), Oracle 8.x

Responsibilities:

• Involved in the analysis, design, development and implementation of Automated Bidding System ( ABS), Vehicle accident monitoring system (VAMS), Bus Rodeo System (BRS), Attendance Interface, Payroll Interface, KIOSK, System-wide Manpower Planning, Notification subsystems
• Designed process models, function hierarchy diagrams, entity-relationship models, Data flow diagrams
• Designed and developed template setting user interface standards
• Designed and developed application security
• Authored general validation routines
• Designed and developed various forms and reports
• Developed PL/SQL libraries and Object libraries
• Designed and developed several API’s
• Developed numerous procedures, functions, packages, and database triggers
• Managed testing of new developments and interaction with other groups to ensure synchronization and accuracy
• Developed and tested installation scripts
• Planned and executed the implementation phases
• Developed utilities for production support
• Analyzed the system as a part of maintenance work to ensure efficiency
• Identified the changes to be affected following a series of walkthroughs with the users
• Updated technical documentation, reviewed and ensured its accuracy
• Supported End-users

Software Engineer

Confidential

Environment: Designer/2000, Developer/2000 Ver. 2.x, Oracle 7.x Windows 95 clients talking to Windows NT 4.0

Responsibilities:

• Involved in analysis, design, coding, testing, and implementation phases.
• Designed and developed numerous forms and reports
• Developed numerous procedures, functions, packages, and database triggers
• Wrote PL/SQL libraries that facilitated easier development and implementation of security across applications
• Monitored relationship and dependencies of related transactions across all modules
• Controlled and Updated source code for all shared Pl/SQL libraries and Object Libraries and Stored Procedures
• Performed migration of applications from Developer/2000 Ver. 1.x to 2.x, midway through the project because of the availability of Developer/2000 Ver. 2.0, which had many new features required by the applications
• Performed partial administration of both Production and Development Database Servers (Oracle 7.3.4). Tasks include Tablespace management, User Management, Schema Objects Creation, Application Optimization, Creation of database triggers and general Procedures
• Assisted group members in resolving issues and provided solutions for difficult and/or complicated programs