SUMMARY

• Over 12 years of experience with a proven track record in System Analysis, Design, Development and Delivery.
• Expertise and Vast knowledge in Enterprise Data Warehousing including Data Modeling, Data Architecture, Data Integration (ETL/ELT) and Business Intelligence.
• Well versed in 3NF and Star Schema(Dimensional) Data Modeling techniques.
• Skilled in implementing SQL tuning techniques such as Join Indexes(JI), Aggregate Join Indexes(AJI's), Statistics and Table changes including Index.
• Experienced in using various Teradata Utilities like Teradata Parallel Transporter (TPT), Mload, BTEQ, FastExport and Fastload.
• Experienced in Creating and Maintaining documentation such as Data Architecture/Technical/ETL Specifications.
• Comfortable Working in both Waterfall and Agile Methodologies.
• Ability to lead and mentor in a team - oriented environment.
• Excellent Communication, analytical, problem solving, time management skills.
• Detail-oriented hands-on inquisitive team player with initiative and reliability.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x/6.x, PowerExchange 8.1.1

RDBMS: Teradata V2R5/V2R6/R12/14, Oracle 11g, i/10g/9i/8iMS SQL Server 7.0/2000 and MS Access.

Languages: UNIX Shell scripting, PL/SQL, SQL

Operating Systems: SUN Solaris 5.8/5.9, HP-UX B.11.11Windows NT and Windows 95/98/2000/XP

Scheduling Tools: Tivoli 8.x Maestro Scheduler

Design Applications: ERwin Data Modeler 4.x/7.x/9.x, Sybase/SAP Power Designer 16.x

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

Sr. Teradata Developer

Responsibilities:

• Design the Physical Data Model for Self-Service Reporting Platform.
• Perform Design and Code reviews.
• Develop SQL’s to support risk assessment reporting.
• Write BTEQ’s to process customer data from various lines of business to derive the risk rating.
• Enforce and Implement standards and best practices.

Environment: SAP PowerDesigner 16.x, Informatica Power Center 9.6.1, Teradata 14.x, CA Autosys

Confidential, Englewood

Sr. Data Modeler

Responsibilities:

• Perform physical and/or logical data modeling and analysis.
• Review and approve the Logical Data Model proposed by the Business Systems Analysts (BSA).
• Develop the Physical Data Model and Design (the table DDLs).
• Enforce and Implement IDW modeling standards.

Environment: CA ERwin Data Modeler 9.x, Teradata 14.x

Confidential, Atlanta

Sr. Architect

Responsibilities:

• Designed and implemented Dimensional model using Star Schema.
• Designed and implemented a Performance Layer of Views for reporting purposes.
• Created and maintained Technical Architecture Specifications, Source to Confidential Mapping and ETL Design Documents.
• Profile source data to assess it has required data and can be integrated.

Environment: CA ERwin Data Modeler 9.x/7.3, Informatica Power Center 8.6/9.x, Oracle 11g

Confidential, Minneapolis

Sr. Data Modeler

Responsibilities:

• Create Physical Data Model(PDM) including indices and partitions per requirements.
• Convert an existing Dimensional Model(DB2) to 3NF model(Teradata).
• Collaborate with DBA team to instantiate the data model in various environments.
• Perform Data Profiling to determine best approach for Data Integration.
• Design and Develop Semantic layer for cost optimization of supply chain, and pricing audits for stores consisting of multiple views.
• Performance Tuned the views by implementing statistics, join indexes, addressing data type inconsistencies and table modifications for Indexes.

Environment: CA ERwin Data Modeler 7.3, Teradata Version 14.01

Confidential, Alpharetta, GA

Sr. Architect

Responsibilities:

• Participated in gathering Reporting and Application development requirements.
• Designed and Implemented a Star Schema Dimensional Model for reporting data mart using Power Designer.
• Profiled Data to ensure all the requirements are fulfilled per the project charter.
• Designed and Implemented an ETL strategy to integrate data from Operational Data Source (ODS) in to the Enterprise Data Warehouse (EDW) and from EDW to the iKnow Application for real time decision Management (RTDM).
• Developed and Tested Informatica code to support the iKnow application’s data requirements and iKnow's data in to EDW for use in reporting using OBIEE.

Environment: Informatica Power Center 9.1, Oracle 11g/Exadata, TOAD 8.6.1, UNIX, MS Visio 2010, Sybase Power Designer 16.x

Confidential, Atlanta, GA

Sr. Data Analyst

Responsibilities:

• Participate in gathering reporting requirements.
• Designed Logical and Physical Data Models to integrate the business requirements in to the Data Mart.
• Worked on ETL strategy to integrate data from various sources like Aprimo, Unica, eCDW (Enterprise Consolidated Data Warehouse) and other external vendors.

Environment: ERwin 7.3, Informatica Power Center 8.6.1, Oracle 11g, Teradata R12, TOAD 8.6.1, Maestro (CONMAN 8.5), UNIX, Teradata SQL Assistant 13.1

Confidential, Atlanta, GA

Sr. ETL Architect

Responsibilities:

• Developed Scripts to process data from the Golden Gate (GG) tables to Collapse the transactional data to create Journals for batch processing.
• Developed and unit tested Informatica code and validated the Confidential data.
• Extracted data from source's like Oracle, Golden Gate, Flat and XML Files.
• Authored and modified shell scripts for parameter files and ETL processes.
• Created and Implemented Maestro Schedules.

Environment: Informatica Power Center 8.5.1, Oracle 10g, Teradata R12, TOAD 8.6.1, Maestro (CONMAN 8.5), UNIX, Golden Gate

Confidential, Atlanta, GA

Data Architect

Responsibilities:

• Led and implemented CRM Enhancement project successfully.
• Worked with Business Users to gather functional and technical requirements.
• Performed Data Analysis to meet the business requirements.
• Created Logical and Physical Data Models to integrate the business requirements.
• Created design documents like High Level Design and Data Specifications based on business requirements.

Environment: AllFusion ERwin Data Modeler 4.1.4/r7 -7.2.5, Teradata V2R6/R12

Confidential, Atlanta, GA

Sr. ETL Architect

Responsibilities:

• Led the project team in successful integration of the new LMS data in to EDW.
• Developed and Unit Tested Informatica code and validated the Confidential data.
• Resolved Data Quality and Performance issues.
• Supported prod ops team in resolving code failures and operational issues.

Environment: Informatica Power Center 8.x/7.x, Oracle 10g/11i, Teradata V2R6/R12, TOAD 8.6.1, CONMAN 8.2, AS/400, Syncsort 3.7.0, Connect Direct

Confidential, Germantown, MD

Sr. ETL Developer

Responsibilities:

• Developed and Unit Tested Informatica code and validated the Confidential data.
• Wrote Datamaps in PowerExchange to process the variable record length EBCDIC source files to generate normalized ASCII files.
• Developed mappings for RI checks and implement business rules to Generate and Assign Surrogate Keys and their Effective Versioning.
• Implemented the Push Down Optimization to improve the performance of ETL jobs (Informatica).
• Created Maestro Jobs to schedule ETL jobs based on their order of execution.

Environment: Informatica PowerCenter 8.1.1, Informatica PowerExchange 8.1.1, Teradata V2R6, Sun Solaris 9.0, NDM Connect Direct

Confidential, Atlanta, GA

ETL Architect

Responsibilities:

• Involved in gathering functional and technical requirements.
• Wrote ETL Specifications based on the Technical Specs.
• Defined Transformation and loading rules for data sourced from systems like AS400, Oracle, Teradata and Flat Files.
• Collaborated with application DBA’s to design and implement performance enhancing strategies for ETL processes.

Environment: Informatica Power Center 7.x, Oracle 9i/10g/11i, Teradata V2R5, TOAD 7.0, CONMAN 8.2, AS/400, Syncsort 3.7, Connect Direct

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Developed and Unit Tested Informatica code and validated the Confidential data.
• Processed data from source systems like AS400, Oracle and Flat Files.
• Worked extensively with Teradata Utilities.
• Authored and modified shell scripts to generate parameter files, automate ETL process and running audits after to determine success or failure of a process.
• Converted Cron jobs to Maestro Schedules and Jobs.
• Worked in Production Support. Was responsible for execution, Code migrations, Scheduling Maestro Jobs, Maintaining the server for optimum performance.

Environment: Informatica Power Center 7.x, Oracle 9i/10g/11i, Teradata V2R5, TOAD 7.0, Maestro, AS/400, Syncsort 3.7.0, Sun Solaris 8.0, HP UX5.7.8