PROFESSIONAL SUMMARY:

• Over 16 (Sixteen years) of experience in Information Technology (IT) in Analysis, Design and Development of software applications.
• Over 10 years of experience in Data Warehousing and BI applications development for Retail, Banking, Airlines, Telecommunication and Manufacturing industries
• Over 1 year of BIG DATA ARCHITECT experience with HP Vertica
• Over 10 years of experience in development of data warehousing/Business Intellegence(BI) applications using Teradata TD13/TD12/TD5/TD4, Informatica Power Center 8.6.1/8.1.1/7.1.2/6.2.1 , Unix, DB2, Oracle, PL/1 technologies.
• Over 10 years of experience as a ETL Lead/Technical Lead/BI Lead
• Experienced in development of data warehousing applications using Teradata BTEQ, Bteq Import and Export, Fastload, Multiload, Fastexport, TPUMP and TPT utilities
• Experienced in building ETL Architecture, which includes surrogate keys management, building stage area, Change Data Capture (CDC) management, Data Archival, Data File Management, Data and Files Purging, Data reconciliation.
• Experienced in data extraction from Flat files, Oracle and Teradata sources using Unix Shell programs and Teradata utilities
• Experienced in writing intensive Teradata SQL Queries
• Experienced in tuning Teradata Applications for performance through horizontal and vertical table partitioning, indexes, Statistics, best coding practices, data compression, parallel processing techniques.
• Experienced in developing Teradata Macros, Triggers, Stored Procedures, Views, Indexes
• Experienced in development of Data Quality Monitoring Tool using Unix shell and Teradata
• Experienced in project DBA work, which includes Logical Data Modelling, Physical Data Modelling (3NF and Dimensional), Implementation of objects, access management, application performance monitoring, capacity planning etc.
• Experienced in ETL Data warehousing using Informatica PowerCenter 6.x/7.x/8.x tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Experienced in Informatica Power Center Tansformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Experienced in data extraction from Flat files, Oracle, and Teradata sources using Informatica
• Experienced in data loading into Flat files, Oracle and Teradata targets using Informatica
• Experienced in data loading into Teradata using Informatica Power Center and Fastload and Multiload Teradata Utilities
• Experienced in data loading using Relational and Teradata Loader Connections
• Experienced in ETL Performance Tuning of mappings and sessions in Informatica
• Experienced in creating BI reports for data consumers using Business Objects and Excel
• Experienced in Master Data Management(MDM), Data Quality Management (DQM), Business Intelligence (BI), Data Integration (DI), Metadata Management (MM),.
• Experienced in Project Planning, Project Estimation, Team Building and Team Management, Communication Management, Quality Management, Risk Management, working with multiple teams and multiple vendors, working with onsite and offshore model.
• Experienced in Software Development Life Cycle (SDLC), which includes Requirements collection, Design, Development, Testing, Deployment, Post Deployment Support
• Experienced in Data Quality Management, Master Data Management and Metadata Management
• Experienced in software development using Waterfall and Agile software development methodologies
• Experienced in Data Warehouse Application Maintenance, which includes operational excellence, change management, application performance management, data privacy management
• Experienced in ETL design and development of Operational Data Stores (ODS) and Enterprise Data Warehouse (EDW)
• Experienced in application development using Informatica Power Center tools
• Experienced in Application Performance Management
• Star Schema dimensional modeling, which include understanding business processes, modeling dimensions, hierarchies and facts
• Experienced in development and testing of slowly changing dimensions (SCD) using Informatica Power Center tools
• Good experience in business requirements collection, analysis and converting the same into data warehousing applications
• Developed and Deployed Data Quality Monitoring Tool using Unix, Teradata and Control M technologies.
• Experienced in Pre - sales, which include Proposal writing, Proposal estimation, Proposal presentation
• Strong communication, managerial and leadership skills
• Experienced in Banking, Airlines and Retail domains

SKILL:

Databases: Teradata 12/13, DB2, ORACLE, HP Vertica

Languages: PL/1, COBOL, JCL, K Shell, Awk

Operating Systems: IBM 3090/ES 9000, AMADHL, SunOS 5.8, Windows 2000, Windows NT

BI Tools: Business Objects XI R2, Cognos 8

ETL Tools: Informatica Power Center 8.6.1

Other Tools: Erwin 7.3, Quality Center, ControlM, WinCVS

PROFESSIONAL EXPERIENCE:

Confidential

DATA ARCHITECT

Responsibilities:

• Analyze applications running on Teradata and create documentation for the applications
• Apply Big Data Columnar concepts to Logical and Physical Data Models using Erwin tool.
• Work with Vertica DBA to create Vertica projections and Customer projections.
• Apply Big Data Columnar concepts to ETL design to migrate applications running on Teradata to HP Vertica, using Vertica VSQL.
• Develop Vertica scripts using Unix and Vertica VSQL.
• Convert Teradata script to Vertica scripts.
• Perform testing to make sure that data on the Vertica platform matches with that of Teradata
• Analyze downstream applications and user queries, and provide solutions to migrate them on to Vertica.
• Work with DBA, Data Strategists, Operations, Downstream app teams, Testing team, Reporting Team, DVT team etc
• Monitor performance of queries on Vertica and work with DBA team to tune them.
• Create metadata documentation and share it with the project teams.
• Support deployment and testing activities.
• Follow the modelling process to make changes to the Erwin models
• Work with Teradata and Vertica DBA to materialize the objects on Teradata and Vertica

Environment: HP Vertica, Teradata 13, Erwin 7.3, Control-M, SQL Assistant, Unix

Confidential

DATA ARCHITECT

Responsibilities:

• Understand the enterprise data house requirements for Sales and Orders data
• Capture source system metadata, which includes entities, fields and descriptions
• Perform Data Profiling on the source system
• Create Conceptual and Physical Data Models for the source system using Erwin 7
• Understand the EDW architecture and the existing entities
• Create EDW conceptual, logical and physical data model for the source system
• Create mapping document between source system and EDW showing the business rules, which is one of the key input to the ETL development
• Create Metadata for the EDW
• Work with project stakeholders, who include SMEs, ETL development team, Test Team, Quality Control Team, Data Strategists
• Provide physical table definitions to DBA for implementation
• Contribute to Requirements gathering, Solution Approach, High and Low Level Design, Data Reconciliation process, Development and Implementation effort

Environment: Teradata 13, Erwin 7.3, In house metadata tool, Oracle 11g

Confidential

ETL Lead/Data Analyst/Application DBA

Responsibilities:

• Create ETL architecture using Unix shell scripts and Teradata Utilities
• Lead and Guide the development team responsible for delivering Bank Account subject area, which is a biggest module in BDW.
• Write Technical Design for Incremental/Delta loads and Historical data loads
• Create ETL scripts to source data from disparate systems
• Create ETL scripts to transform and load data into BDW
• Tune complex scripts for performance.
• Write Unit Test Plans, System Test Plans, User Test Plans
• Schedule ControlM jobs
• Create Handover documentation for Support Team
• Provide project DBA support
• Write mapping/cross walk documents and scripts to remediate scripts from the old system to the new system.
• Create data model for monitoring data quality in BDW - 2500 data quality checks along 6 data quality dimensions
• Develop and deploy data quality monitoring tool
• Build Data Quality Dashboard for Confidential
• Understand complex data structures and create processes to meet business needs
• Remediate processes running on old analytical platforms to the new BDW analytical platform
• Facilitate Knowledge sharing sessions for data analyst group
• Write Training Material for data analysts new to the team
• Create a new database/container for Data Analyst(DA) processes automation
• Create database objects for DA processes and maintain them
• Grant access on the database objects to DA group members
• Automate DA processes using Unix, Teradata and ControlM technologies and main them.
• Create Teradata Macros to manage reference data
• Tune DA Teradata scripts for performance
• Create dashboard showing load status of DA processes

Environment: Teradata 13, Unix, Control-M, K-Shell, BOXI R2, Teradata SQL Assistant, Erwin 7.3

Confidential

ETL Lead

Responsibilities:

• Make sure the application delivers the expected data within SLA time
• Manage Application Changes, which include understanding the changes, plan the changes and delivering them
• Synchronize the HR application with upstream applications
• Coordinate with support teams (Production support team, Migration team, test team etc)
• Work with data architect team to improve application performance and to come out with a solution for any new changes
• Execute HR data privacy requirements
• Execute Standard Extracts project to simplify the ETL processing

Environment: Teradata V2R12, Informatica PowerCenter 8.6.1, CVS, Cronacle, K-Shell, BOXI R2

Confidential

ETL Lead

Responsibilities:

• Project Manager and ETL Lead for the team responsible for building Proof of Concept (PoC) for Orders, Sales and Backlog data for two sources, using Informatica, Teradata and Business Objects
• Create ETL strategy for the PoC and assign the related activities to the team
• Showcase the GOSB PoC to the business users and collect their feedback
• Create plan to formalize the GOSB tool
• Understand AS-IS BI reporting of different GEHC businesses, on Orders, Sales and Backlog data
• Engage Architect team for building Logical and Physical data model
• Design ETL strategy using Informatica and Teradata, to load data from different source systems/BI applications to GOSB tool
• Create Project Plan, which includes Activities Planning, Work Assignment to team, Resource Planning, Project Scheduling, Major Deliverables for different sources
• Execute the project in Agile mode, which include scrum planning, organize scrum meetings, organize showcase meetings, organize retrospective meetings
• Showcase the tool to the stake holders and Collect feedback
• Engage Business Analyst or Users for User Acceptance Testing, and get sign-off
• Track any issues or changes found Confidential any time during the project and close them in time
• Co-ordinate with different teams (Informatica, DBA, BI tools team, Migration Team, Production Support Team, Test Team) to get sign-off for software migration into different development environments.
• Create User Training Plan, Arrange User Training, Collect User feedback
• Make sure the team follows all the applicable processes, which include client specific Software Development Life Cycle (SDLC)
• Manage Project Knowledge and re-use it wherever required

Environment: Teradata V2R12, Informatica PowerCenter 8.1, CVS, Cronacle, K-Shell, BOXI R2

Confidential

ETL Lead

Responsibilities:

• As part of Database platform evaluation, create test plan to test Oracle and Teradata database with respect to ETL operations. Get the test plan executed by the team. Review the test results. Present the results to the DBA teams and management team.
• Part of the ETL team responsible for creating various assets for the project, which include ETL standards, Teradata standards, ETL Specification template, CDC approach
• Understand requirements to populate ODS database and EDW database
• Re-design the existing General Ledger application for new functionality and performance
• Create Project Plan, which includes Activities Planning, Work Assignment to team, Resource Planning, Project Scheduling, Major Deliverables for different sources
• Engage Business Analyst or Users for User Acceptance Testing, and get sign-off
• Track any issues or changes found Confidential any time and close them in time
• Co-ordinate with different teams (Informatica, DBA, BI tools team, Migration Team, Production Support Team, Test Team) to get sign-off for software migration into different development environments.
• Create User Training Plan, Arrange User Training, Collect User feedback
• Make sure the team follows all the applicable processes, which include client specific Software Development Life Cycle (SDLC)
• Manage Project Knowledge and re-use it wherever required
• Plan Knowledge transition to Production Team and Maintenance Team and execute the same

Environment: Teradata VR6, Informatica 7.1.2, CVS, Cronacle, K-Shell, BOXI R2

Confidential

Technical Lead

Responsibilities:

• Write Technical Design and ETL mapping documents
• Create test plans and perform various tests like Unit testing, System Testing, Load testing, User Acceptance testing
• Perform Teradata upgrade testing
• Tune Applications for performance
• Guide the team to troubleshoot technical challenges
• Create documentation for implementation and provide post implementation support
• Work with project teams like DBA, Change management team etc. to complete day to day activities
• Make sure transition of new applications happens smoothly and the maintenance team is competent enough to maintain the applications

Environment: Teradata V2R5, Control-M, K-Shell

Confidential

Project Manager

Responsibilities:

• Create project plan, which includes Resource Planning, Activity Planning, Defining Deliverables and Timelines, Quality Control, Team Building
• Create ETL design strategy for loading data from different sources, using Informatica and Teradata
• Develop and test all code related to mainframe, which use JCL, PL/1
• Change Management and Defect Management
• Help the team to resolve any technical issues
• Project Tracking through meetings and status reports
• Project Knowledge Management, which includes documenting best practices, lessons learnt, creation of functional and technical assets

Environment: Teradata V2R5, Informatica 6, CVS, Control-M, K-Shell, DB2, JCL, AMADHL Mainframe

Confidential

ETL Developer

Responsibilities:

• Develop Forward Bookings Summary using Teradata BTEQ and K Shell scripts
• Develop Corporate Customer Rating application using Teradata BTEQ
• Re-wire Campaign data feed from Customer database to Teradata CRM tool
• Design and Develop Flight Operations database and Customer Campaign application using FASTEXPORT, FASTLOAD, FASTEXPORT, BTEQ and UNIX.
• Teradata Queries Performance tuning
• Develop ETL scripts using K-shell, Oracle Sql and Teradata utilities FASTLOAD and BTEQ
• Load data from different source systems, which include oracle and flat files
• Develop code for transferring files using XCOM and FTP
• Create technical documentation, which include ETL design documentation, migration documentation, Unit Test Plan and System Test Plan, Unit Test Results and System Test Results
• Follow the client specific Software Development Life Cycle process

Environment: Teradata V2R4, Control-M, K-Shell, Queryman