Technical Skills and Capabilities:

• 12 years of extensive experience with enterprise software applications. 9 years with Data Warehouse and Business Intelligence applications. Expertise in Data Modeling, Data integration,MDM,ODS, Dimensional Modeling Star-Schemas, ETL process and frameworks. Deep understanding of Big Data analytic theory practices.
• Expertise's with programming languages: SQL, Oracle 10g , PL/SQL, Teradata, C/C , Java, UNIX Shell Scripts, Perl, .NET,ASP, PHP.
• Experts of Unix system architecture Solaris 10, AIX 6.x, RedHat Enterprise Linux , Oracle Enterprise Linux and Win 2003/2008 R2 servers
• Extensive Experiences with business intelligence tools, including Siebel Analytics 7, OBIEE 10g/11g, SAP BusinessObject, IBM Infosphere 8.5, DataStage/QualityStage and BEA WebLogic server 9.x. ERWin, Toad, Teradata SQL Assistant. Informatica 8.6 9.1 PowerCenter, DataTransformation. DataMirror CDC.
• expertise in areas of ETL Architecture, Database Architecture, Performance Architecture, Data Security Architecture, Logical and Physical Data Modeling, Project Management, Building, Mentoring and Training Onshore as well as Offshore Technical Team.
• Certified TeradataMaster in Teradata V2R5 database.
• Oracle, SQL, PL/SQL, SQLLOADER
• Teradata Bteq,Mload,FastExport,FastLoad,Tpump
• IBM DB2 Informatica DataStage
• Business Objects ERWIN SAS
• ETL, Data Modeling, Data Warehousing
• C,C ,PROC,JAVA,UNIX
• Perl, Maestro, Syncsort, Cron

PROFESSIONAL EXPERIENCE

Confidential

Lead Architect

Responsiblities:

• Creating ETL Architecture to bring healthcare data into TeradataEDW
• Design of Error Control Frame Work Process Architecture
• Design of Data Security Architecture for HIPPA compliant
• Design of Database Architecture Database Hierarchy Users and privileges on different databases Space requirements Views
• Design of Reporting Architecture involving Teradata, UNIX and Microstrategy
• Design of UNIX directory structure ,Design of Code Deployment Process
• Design of ETL-MDM Master Data Management -ETL handshaking process
• Design of Client Attribution ETL Process ,Design of Healthcare Data Archival Process
• Design of Backup Schedule of ETL and Database process
• Working closely with Project Manager in defining Tasks and Schedule for Requirements, LDM, PDM, ETL, Testing, Code Deployment and Reporting
• Working closely with Project Manager in defining resource requirements
• Travel to Manilla, Philippines to Build offshore development Team consisting of Architects, Data Modelers, Designers, Developers and Testers for the Project
• Leading a Team of Architects, Data Modelers, Designers, Developers and Testers both offshore and onshore
• Training and Mentoring offshore Team from India and Philippines in deployment and production support of ETL process
• Review of PDM, Table DDL, Design of ETL Specs, ETL Code and Testing results
• Working closely with DBAs in the design of views performance tuning of sql querries
• Design of Tables for MVCs, PPIs, and BLCs
• Involved in PDM issue resolution ETL issue resolution on-site client's issue resolution training and mentoring the Team members and the client
• Provide Technical solution to complex ETL problems,Review and Presentation on Teradata Temporal features.
• Presentation and Training on Teradata Architecture UPIs, NUPIs, USIs, NUSIs, PPIs, NPPIs, JIs, AJIs, MLPPIs, MVCs,TASM, TeradataManager, Teradata ViewPoint
• Presentation on Teradata fallback, transient journals, Locks, Views, Backup and Recovery strategy, Perm Space, Spool Space, Temp Space, Volatile Tables, Derrived Tables, Temporary Tables, Database design phases and bteq
• Presentation and Training on Performance tuning techniques onTeradata.
• Working with 3rd party to define data requirements
• Create ETL Architecture Document,ETL Operational Document
• Train MS offshore Team in ETL Architecture and ETL Operational Process

Confidential

Lead Architect

Responsiblities:

• Analysis of current Datamarts and existing reporting systems and understanding the requirements for a world class Enterprise Data Warehouse
• Presenting a design solution to address the requirements for a world class EDW and reporting system
• Scoping the hardware and software requirements space requirements costs needed to build EDW
• Working closely with Teradata Sales Team in selling of TeradataNode for Development and Production Communication Logical Data Model Teradata Viewpoint and Training needs of WIND
• Design of ETL Architecture
• Design of Error Control Frame Work Architecture
• Design of Database Architecture Database Hierarchy Users and privileges on different databases Space requirements Views
• Design of Reporting Architecture involving Teradata, UNIX and Microstrategy
• Design of Informatica Folders Informatica Users Permissions
• Design of UNIX directory structure
• Design of Code Deployment Process
• Design of Informatica Code Standards, Unix Code Standards, Bteq code standards Setting up Naming standards
• Working closely with Project Manager in defining Tasks and Schedule for Requirements, LDM, PDM, ETL, Testing, Code Deployment and Reporting
• Working closely with Project Manager in defining resource requirements
• Leading a Team of Designers, off-shore Developers and Testers in the deployment of Ist release of the project
• Review of PDM, Design Specs, ETL Code and Testing results
• Involved in PDM issue resolution ETL issue resolution on-site client's issue resolution training and mentoring the Team members and the client
• Working with 3rd party Scorecard involved in project
• Presentation on partitions in Informatica-TPT, parameters usage and parallel processing, parsing of td error logs, debugging techniques
• Presentation on the best design in Informatica 9.1 with and without PDO option.
• Presentation and Training on Teradata Architecture UPIs, NUPIs, USIs, NUSIs, PPIs, NPPIs, JIs, AJIs, MLPPIs, MVCs.
• Presentation on Teradata fallback, transient journals, Locks, Views, Backup and Recovery strategy, Perm Space, Spool Space, Temp Space, Volatile Tables, Derrived Tables, Temporary Tables, Database design phases and bteq
• Presentation and Training on Performance tuning techniques onTeradata.
• Presentation on the optimal design of Tables for least Skewness, good distribution, better access and optimal space usage Design of views for access on Tables.
• Presentation on Teradata Temporal features

Confidential

Responsiblities:

• Provide consulting services in the design of ETL Architecture using best practices in Informatica, Teradata, UNIX, Bteq and TPT.
• Design ETL prototypes using Informatica-TPT API, Bteq, UNIX
• Presentation on partitions in Informatica-TPT, parameters usage and parallel processing, parsing of td error logs, debugging techniques Presentation on the best design in Informatica 9.1 with and without PDO option.
• Implementation strategy discussion on Folder Design, Repository Design, Source/Target Connections, Workflow Design, Worklet, Parallel and Partitions in Informatica.
• Presentation and Training on Teradata Architecture UPIs, NUPIs, USIs, NUSIs, PPIs, NPPIs, JIs, AJIs, MLPPIs, MVCs.
• Review of Physical Data Model. Presentation on Teradata fallback, transient journals, Locks, Views, Backup and Recovery strategy, Perm Space, Spool Space, Temp Space, Volatile Tables, Derrived Tables, Temporary Tables, Database design phases.
• Presentation on the optimal design of Tables for least Skewness, good distribution, better access and optimal space usage Design of views for access on Tables.
• Involved in the design discussion of surrogate keys, pre-stage file load, loading of data from pre-stage to stage, stage to edw production, and to DR system
• Design a prototype on the usage of PERIOD data type in Teradata13.10 without Teradata temporal features and presentation of the prototype to the client.

Confidential

Sr. Datawarehouse Architect

Responsiblities:

• Design of EDW and Marketing Data Mart within EnterpriseData Warehouse.
• Participate in the Logical Modelling sessions with the business users.
• Design Tables for fallback or no fallback, for least Skewness, good distribution, better access and optimal space usage Design of views for access on Tables.
• Design of dependent data marts, semantic views, Join Indexes, Denormalized tables and semantic layers onTeradata for reporting requirements.
• Design of Physical data models in 3NF on Teradata Perform demographics analysis and design ELDMs Design UPIs, NUPIs, USIs, NUSIs on Teradata tables and Identify tables for compression values Design PPIs, Compression values on columns in Teradata tables for least Skewness, good distribution, better access and optimal space usage for Engine DataMart.
• Design of aggregate structures, denormalised tables and views on Teradata for reporting solutions. Performance tuning of SQL queries for better performance on Teradata.

Confidential

Teradata Consultant

Responsiblities:

• Design of ELDMs on Teradata from existing Oracle and DB2 systems LDMs.
• Perform demographics analysis on tables for data distribution, sizing, access and compression values
• Design PDM on Teradata from ELDMs Identify and Design UPIs, NUPIs, USIs, NUSIs, PPIs, and Compression values for columns using ERWIN Design and implementation of multi level partitioning PPIs and multi value compression in PDMs on some Teradata tables.
• Design Tables for fallback or no fallback, for least Skewness, good distribution, better access and optimal space usage Design of views for access on Tables.Replace several dependent data mart physical tables by the design of semantic views on Teradata.Design of complex bteq scripts to replace the logic in DB2 triggers.
• Redesign of several complex DB2 and Oracle SQL code to Teradata.Performance tuning of Teradata bteq and sql code.Performance Tuning of Microstrategy queries.Loading of data into Teradata through TPT scripts using DataStage.
• Redesigned a very complex system on Teradata to run in 30 minutes. The same process on DB2 used to take weeks for BJS. Redesigned campaingn mart scripts on Teradata.Involved in the design of System and ETL architecture on Teradata.

Confidential

Data Architect

Responsiblities:

• Mapping existing Teradata objects to Teradata MLDM.Participate in the Logical Modelling Session and understanding business models in the design of Extended LDMs and PDMs in alignment with Teradata MLDM using ERWIN.
• Close interaction with the Engine group of Navistar and design of ETL and Reporting architecture for the group.
• Design of recursive SQL queries, complex BTEQ code, performance tuning of sql code on Teradata. Design of Physical data models in 3NF on Teradata Perform demographics analysis and design ELDMs Design UPIs, NUPIs, USIs, NUSIs on Teradata tables and Identify tables for compression values Design PPIs, Compression values on columns in Teradatatables for least Skewness, good distribution, better access and optimal space usage for Engine DataMart.
• Design of aggregate structures, denormalised tables and views onTeradata for reporting solutions. Performance tuning of SQL queries for better performance onTeradata.
• Analysis of existing DB2 and Oracle SQL code and redesigning the code to run on Teradata.

Confidential

Application DBA

Responsibilities:

• Teradata Application DBA. Lead project of converting wireline/wireless Oracle 10g data marts to Teradata V2R6. Create physical model db,tables,views,Store Procedures based on previous Oracle schemas. Created ETL scripts for ELT process, using BTEQ, MLOAD, TPT scripts. Created all needed UNIX shell/PERL scripts.
• Provide BI/DW application architecture design and roadmap for AT T's corporate Data Warehouse projects. Design implement clustering for high-availability and high performance. Design implement system outage/performance degradation alert tools/scripts. Providedetailed infrastructure solution hardware platform, selection of software packages ,etc for such data warehouse projects/environments. Lead in Data Warehouse application upgrade design implementation.
• Production/QA/ST administrator for OBIEE 10g , BusinessObject , IBM Infosphere 8.x. and Informatica 8.6.Support on-call and outage emergencies. Debug performance issues with DBA. Lead a team of offshore engineers for 24/7 coverage of all environments.
• Upgrade of afore mentioned BI/DW tools. Work with vendors to resolve upgrade issues. Work with PM closely to guarantee project success.
• OBIEE business repots development for Siebel marketing and Sales cubes.
• Worked on developing production ETL workflows/mappings, OBIEE repository development. Lead code migrations and code deployments