SUMMARY:

• 22 years of experience including extensive of Cloud, Ab Initio, Datastage, Informatica, Talend, Teradata, Redshift and Snowflake data warehousing/Data modeling experience in the areas of data administration, physical database design, system architecture, database performance tuning, and ETL design and development.
• I am also skilled in the implementation of end user data access tools and client - server reporting applications.
• 2 years of experience with Hadoop Technologies like HDFS, Hive, Pig, Impala, YARN, Spark, NoSQL, Python and Sqoop. We implemented two of the applications on Hadoop successfully.
• 2 years Hands on experience with AWS S3, EC2, IAM and Redshift services.
• 13 years of experience with creating logical and physical data model and converting logical data models into Teradata/Redshift/Snowflake physical database designs using Erwin, system implementation, performance tuning, and support.
• Hands on experience with Confidential MVS mainframe environment using JCL, TSO, ISPF, Confidential utilities and DB2.
• Proven record of success in design, development and implementation of software applications using object oriented technology.
• Excellent communication and interpersonal skills and adept in working with team’s offsite.

TECHNICAL SKILLS:

Hardware: Pentium V Workstations, NCRS Unix Servers 4400, Confidential Windows 2000 servers 4850 & 447

Operating Systems: Unix, Windows XP, Windows 2000, Windows NT 4.0 and MVS Application

Servers: IIS, Web logic, Web sphere, ATG Dynamo

Databases: TeradataV2R2/3/4/5/5.1/6.x/ 12/13/13.10/14.10 , Oracle, Sql Server

Teradata Tools & Utilities: Query Man / SQL Assistant, WinDdi, Teradata Query Manager, Bteq, BteqWin, FastLoad, MultiLoad, Arc, Asf2, Teradata Administrator, Teradata Performance Monitor, NetBackup and NetVault.

Reporting Tools: Crystal Reports, Tableau

Business intelligence: Micro Strategy, Business Objects, COGNOS, Informatica (5.0/6.0/7.1/8.0/8.5 ), Datastage (7.x/8.x) and Ab Initio.Hadoop, HDFS, Sqoop, Impala, Python, Spark, Hive, Pig AWS S3, PostgreSQL, DynamoDB, Redshift, Snowflake, Azure

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Enterprise Data Architect

Responsibilities:

• Creating conceptual, logical & physical data models and assists the DBA in developing the physical data model (PDM).
• Involving in meetings to gather information and requirements from the business.
• Provides naming standards and conventions and ensures that data dictionaries are maintained across multiple database environments
• Ability to select correct tier for Azure SQL Databases and Azure SQL Date warehouses.
• Experience working with Performance Metrics and Plan Management
• Working with Cosmos DB Integration and using SQL Server Data Explorer Tools
• Working with Azure SQL Databases for Excel and Power BI Reporting Tools
• Detailed understanding of Azure database offerings Relational, NoSQL, Datawarehouse
• Deep familiarity with Azure Security Services Azure Active Directory, RBAC, KeyVault, ADFS
• Architecture and Implementation experience with medium to complex on-prem to Azure migrations

Confidential, Chicago, IL

Data Architect

Responsibilities:

• Involved in meetings to gather information and requirements from the business analytics.
• Created conceptual, logical & physical data models and assists the DBA in developing the physical data model (PDM) on Redshift.
• Provides naming standards and conventions and ensures that data dictionaries are maintained across multiple database environments.
• Worked on AWS Data Pipeline to configure data loads from S3 to into Redshift
• Used JSON schema to define table and column mapping from S3 data to Redshift
• Doing a POC on snowflake database on AWS.
• Experience with Agile tools like Jira, Confluence.
• Optimizing and tuning the Redshift environment for Tableau Visual Analytics
• Wrote various data normalization jobs for new data ingested into Redshift
• Involved in migrating data from Teradata to Redshift database.
• Created tables to load large sets of structured, semi-structured and unstructured data.
• Designing data structures and creating an ERD, work with standards & Full system development life cycle.
• Created data models of the following subject areas: Supply chain, POS, UberEats, Customer and labor
• Designed and created Master data for Supply chain

Confidential, Chicago, IL

Sr. Data Architect/ETL Architect

Responsibilities:

• Created logical and physical data model for Party using Teradata rLDM.
• Implemented Teradata temporal data type for time dimension. Supporting ETL and BI teams to create SLV and SLT.
• Integrate data from multiple database sources to Hadoop.
• Perform ETL, ELT using Pig, Hive and MapReduce as per requirements.
• Import the data from Teradata database using Fast Export scripts and loading the data into HDFS.
• Designed to extract data from current data warehouse to load in to data lakes to use for reporting.
• Processed data into HDFS by developing solutions, analyzed the data using Map Reduce, Pig, Hive and produce summary results from Hadoop to downstream systems.
• Used Sqoop to import the data from Hadoop Distributed File System (HDFS) to RDBMS.
• Experience with Agile tools like Jira, Confluence.
• Experience in Agile development processes and familiar with methodologies.
• Worked on Microsoft projects Flow, PowerBi, SSIS.
• Wrote and executed various Teradata queries using Teradata Python module.
• Created Tableau worksheet, which involves Schema Import, Implementing the business logic by customization.
• Designed and converted Teradata schema to Redshift. Extracted and loaded the existing warehouse data to Redshift.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Performance tuning of new or existing SQL and assisted users on performance tuning queries at application level.
• Created LDM and PDM for member analytics data.

Confidential, Milwaukee, WI

Sr. Teradata Data Architect

Responsibilities:

• Involved in meetings to gather requirements from the Business Analysts.
• Created logical and physical data model for Purchase Order Agreements using Teradata rLDM.
• Implemented Teradata temporal data type for time dimension.
• Supporting ETL and BI teams to create SLV and SLT.

Confidential, Cincinnati, OH

Sr. Data Architect

Responsibilities:

• Involved in meetings to gather requirements from the Business Analysts.
• Analyze the existing data and designs logical and physical data models.
• Created logical and physical data models using Teradata mLDM.
• Implemented Teradata temporal data type for time dimension.
• Provides naming standards and conventions and ensures that data dictionaries are maintained across multiple database environments.
• Performance tuning of new or existing SQL and assisted users on performance tuning queries at application level.
• Performance tuning designed best use of secondary joined and hash indexes.
• Created data models of the following subject areas: Party, Organization, Geo Graphic Location, Item, Sales Order/Return, Contract and Invoice.

Confidential, Milwaukee, WI

Sr. Data Architect

Responsibilities:

• Involved in meetings to gather requirements from the Business Analysts.
• Analyze the existing data and designs logical and physical data models.
• Created logical and physical data models using Teradata mLDM.
• Provides naming standards and conventions and ensures that data dictionaries are maintained across multiple database environments
• Implemented Teradata temporal data type for time dimension.
• Map logical and technical requirements to the ODS model.
• Created data models of the following subject areas: Party, Organization, Geo Graphic Location, Item, Sales Order/Return, Contract and Adjustment.

Confidential, Lisle, IL

Sr. Data Architect

Responsibilities:

• Involved in meetings to gather requirements from the Business Analysts.
• Created logical and physical data models using Teradata mLDM.
• Created conceptual, logical & physical data models and assists the DBA in developing the physical data model (PDM).
• Analyze the existing data and designs logical and physical data models.
• Provides naming standards and conventions and ensures that data dictionaries are maintained across multiple database environments.
• Performance tuning of new or existing SQL and assisted users on performance tuning queries at application level.
• Performance tuning designed best use of secondary joined and hash indexes.
• Created & maintained metadata related to the model
• Created data models of the following subject areas: Party (Dealer, Customer, Supplier and Organization), General Ledger, Sub Ledger, Journal Entry, Chart of Accounts Balance, Geo Graphic Location, Invoice, Item, Cost, Contract and Adjustment.

Confidential, Winston-Salem, NC

Sr. Data Architect/ETL Architect

Responsibilities:

• Involved in meetings to gather information and requirements from the business.
• Created conceptual, logical & physical data models and assists the DBA in developing the physical data model (PDM).
• Analyze the existing data and designs logical and physical data models
• Provides naming standards and conventions and ensures that data dictionaries are maintained across multiple database environments
• Created & maintained metadata related to the model
• Designing data structures and creating an ERD, work with standards & Full system development life cycle.
• Created data models of the following subject areas: Customer, Job & Call, PRP Payments and Contracts. Designed new database structures for Customer, Job & Call and Contracts.
• Performance tuning of new or existing SQL and assisted users on performance tuning queries at application level.
• Performance tuning designed best use of secondary joined and hash indexes.
• Created logical and physical data models using Teradata mLDM.

Confidential, San Bruno, CA

Teradata DBA/ Architect

Responsibilities:

• Involved in meetings to gather information and requirements from the clients.
• Monitor and maintain a production Teradata database environment, including runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities.
• Technical expert in the areas of relational database logical design, physical design, and performance tuning of the RDBMS.
• Maintain and Tune Teradata Production and Development systems. Supported application development time lines by implementing designs as well as incremental changes to database definition in a timely manner into production and non-production Teradata systems.
• Performance tuning of new or existing SQL and assisted users on performance tuning queries at application level.
• Perform tuning and optimization of database configuration and application SQL Define database backup & recovery strategies, implement and administer. Create and Maintain users for Production/Development Teradata Systems.
• Performance tuning designed best use of secondary joined and hash indexes.
• Involved in data encryption (Protegrity) installation.
• Completed the physical database design and administered the production objects in a change control environment.
• Expanding the data warehouse to meet new business initiatives, logical data model design, physical data model design enhancing performance, and constructing a data mart.
• Involved in database upgradation from V2R5.1 to V2R6.2.

Confidential

Sr. ETL/Datastage Consultant

Responsibilities:

• Involved in meetings to gather information and requirements from the clients.
• Design and Develop ETL processes using DataStage, PL/SQL, Oracle, Perl and Unix shell programming for FDW data warehouse.
• Develop complex ETLs by using DataStage parallel extender parallel processing capabilities.
• Help team members in tuning and improve performance for handling high-volume ETL jobs.
• Resolve technical and functional issues with the design through test phase of development.
• Implemented data staging, cleansing and transformation mechanisms, normalized databases, Star/ Snowflake schemas, and Business Intelligence delivery mechanisms as required, including loading of data marts.
• Developed Unix shell scripts to automate the Data Load processes to the target Data warehouse.
• Developed migration strategy and implemented DataStage 7.1 to 7.5 version upgrade.
• Involved in maintenance and ongoing production support for the current system including ON-CALL rotation 24X7.
• Assist the business analyst in mapping the data from source to target and prepare prototype models to support the development efforts.
• Design and develop reusable components for data sourcing, cleansing, and integration.
• Define programming standards, procedures and best practices in support of ETL processes.
• Develop and implement a standard approach for ETL error processing, audits, and controls and development of communication and resolution procedures.
• Successful project and team leadership including but not limited to: daily task assignments, issue resolution, status reporting and resource allocation along with Onshore - Offshore Experience.

Confidential, KS

Sr. Ab Initio/Teradata Consultant

Responsibilities:

• Involved in meetings to gather information and requirements from the clients.
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Teradata datawarehouse.
• Technical expert in the areas of relational database logical design, physical design, and performance tuning of the RDBMS.
• Performance tuning of new or existing SQL and assisted users on performance tuning queries at application level.
• Maintain and Tune Teradata Production and Development systems. Supported application development time lines by implementing designs as well as incremental changes to database definition in a timely manner into production and non-production Teradata systems.
• Creating Mainframe datasets, submitting JCL, check the dataset files using File-Aid Using 3278 Terminal.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.
• Developed Ab Initio graphs based on Detailed Design documents and Reviewed High Level Design document for data movement.
• Involved in creating Flat files using dataset components like Input file, Output file, Intermediate file in Ab Initio graphs.
• Extensively Used Transform Components Aggregator, Match sorted Join, Denormalize sorted, Reformat, Rollup and Scan Components.
• Implemented the component level, pipeline and Data parallelism in Ab Initio for ETL process for Data warehouse
• Extensively used Partitioning Components Broad Cast, partition by key, partition by Range, partition by round robin and Deportation components like Concatenate, Gather and Merge in Ab Initio.
• Export Amdocs/LittleBillers files to Teradata using Fast load, Fast Export, Multiload, TPump.
• Developed Maplets using corresponding Source, Targets and Transformations.
• Designed and documented the validation rules, error handling and test strategy of the mapping.
• Involved in Query Analyzing, performance tuning and testing.

Confidential, Dayton, OH

Sr Teradata Developer

Responsibilities:

• Designed and developed Teradata load scripts on a Teradata V2R5/5.1 platform in a UNIX environment. Performed DBA functions and data validation.
• Created the table views, stored procedures and macros for CPP.
• Created tables, views, macros, stored procedures for ERR, Event Plus page.
• Monitored and tuned the Teradata Database and ETL scripts written in Teradata SQL, for performance. Developed download the reports in Excel formats.
• Imported Sources and Targets to create Mappings based on business logic and developed Transformations using Power center Designer. Used Informatica Workflow Manager, Workflow Monitor to create sessions and batches.
• Worked on all the transformations like Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Stored Procedure and Sequence Generator.
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Teradata datawarehouse.
• Extensively involved in the design of data extraction, Transformation and migration.
• Designed and implemented an automated system for ongoing ETL job performance and Report creation, logging start and end time of each step in each ETL Job and each Report.
• Involved in Query Analyzing, performance tuning and testing.

Confidential, San Diego, CA

Java Developer

Responsibilities:

• Database design for creating defects in the Database.
• Developed defect-reporting system to enter the defects in the database using JFC Swings.
• Developed to track the information like IP Address, hostname, login when it was choking and tracking.
• Developed SMI Filter monitoring system for online tracking.
• Developed IP Filter monitoring for display the online tracking and choking information when Sleuth9 running.
• Developed a web site for Confidential .
• Developed a send mailing System when DDoS attacks was happened using sockets.