SUMMARY

• Over 11 years of IT experience and extensive experience on Teradata spanning a number of roles with varying skills including Developer, Logical Data Modeler, Teradata Physical Data Modeler, Teradata Semantic Data Modeler, Teradata DBA, and Teradata Solution Architect.
• Responsible for aligning Data warehousing technology solutions with business requirements also responsible for the creation and execution of the data strategy and architecture such that it meets the needs for various business functions across its transactional, operational & analytical data warehouse application.
• Experience working on Big Data stack like Hadoop, HDFS, Hive, Sqoop, TDCH, querygrid & presto.
• Designed the real time analytics and ingestion platform using Storm and kafka. Hands on experience with multiple NOSQL databases including HBase and Cassandra.
• Creating Proof of Concepts from scratch illustrating how these data integration techniques can meet specific business requirements reducing cost and time to market.
• Expertise in Administrator for Database management, User Management, managing permissions (Roles & Profiles), Backup and Restore architecture, Viewpoint, Using PDCR, Datalabs, Performance tuning, Compression analysis, system management (TASM, Capacity Planning, etc), Disaster Recovery Solutions, Unity Datamover.
• Experience working on Big Data stack like Hadoop, HDFS, Hive, Sqoop, TDCH, querygrid & presto.
• Very good understanding of Teradata Architecture, its components and their functionality and Extensive experience on Query performance tuning on analyzing and understanding the Explain plan and based on the optimizer plan tuning the SQL, check the Primary Index, Data distribution, data access paths, skew analysis, defining Partition Primary Index (PPI) to avoid full table scans on large tables, Implemented Secondary Index, Join Index, Aggregate Join Index, Collecting statistics, Compression, SQL change (re - writes) recommendations to use Volatile table to further improve the performance of the SQLs.
• Analyzes transactions and data volumes, designs and develops complex databases and applications, assists in developing system requirements, participates in large-scale software development initiatives including product selection and implementation.
• As a principal advisor was responsible for establishing standards best practices in data warehouse/architecture, data management, analytics, and business intelligence.
• Understanding, documenting and articulating the customer’s current data warehouse/data mart architecture. This includes a complete inventory of the customer’s data warehouses and datamarts as well as their respective business functions.
• Proficient in creating ETL design for integration of new/modified data streams into the data warehouse/data marts also work on Platform hardware sizing / estimation of work for new initiatives.
• Understanding and development of application development frameworks and standardization of design patterns
• Lead efforts to evaluate new vendor software or existing system and make recommendations
• Ability to translate technical concepts into business level language and effectively communicate ideas and direction with all levels of business management and staff
• ETL architecture and design, data architecture and modeling, data governance and stewardship, business intelligence tools (such as Tableau, Cognos, Business Objects, etc.) and reporting and analysis
• Experience on Data Profiling Tools like Informatica IDE/IDQ, Data Flux etc.
• Hands on with Dimensional Modelling and Proficiency in modeling tools like ERWIN
• Expert Knowledge in creating source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts
• Proficient in creating Process Flows using Visio
• Expertise on performance tuning of complex SQLs on large Teradata databases
• Participate as Subject Matter Expert (SME) as required for design reviews and technology and tool selection
• Keep current on database systems and features, 3rd party tools, and industry standards
• Perform capacity planning including allocating system storage and planning future storage requirements
• Providing high quality system functionality with vague or general guidelines from clients.
• And provide "mock-ups" of the deliverables for client sign-off, and use probing questions to gather necessary details for design.
• Analyze business requirements in various business functional areas and translate them into conceptual, logical and physical data models.
• Design datamarts using knowledge of data warehouse principles, architectures and technologies.
• Ability to create and maintain positive and professional business relationships with both internal associates and external customers.

PROFESSIONAL EXPERIENCE

Confidential, PA

Principal DBA/Architect

Responsibilities:

• Analyzes transactions and data volumes, designs and develops complex databases and applications, assists in developing system requirements, participates in large-scale software development initiatives including product selection and implementation
• Researches and recommends optimal design criteria and best utilization of resources
• Expertise in Administrator for Database management, User Management, managing permissions (Roles & Profiles), Backup and Restore architecture, Viewpoint, Using PDCR, Datalabs, Performance tuning, Compression analysis, system management (TASM, Capacity Planning, etc).
• Very good understanding of Teradata Architecture, its components and their functionality and Extensive experience on Query performance tuning on analyzing and understanding the Explain plan and based on the optimizer plan tuning the SQL, check the Primary Index, Data distribution, data access paths, skew analysis, defining Partition Primary Index (PPI) to avoid full table scans on large tables, Implemented Secondary Index, Join Index, Aggregate Join Index, Collecting statistics, Compression, SQL change (re-writes) recommendations to use Volatile table to further improve the performance of the SQLs.
• Performance tuning of complex SQLs on large Teradata databases
• Steward of Enterprise Metadata Architecture & Standards, Enterprise Data Lifecycle Management including data quality, data conversion, and data security technologies
• Providing optimal solution for data warehouse and BI systems performance and integrity and provide corrective actions and preventative maintenance.
• Collaborate with the DBA and System Administrator to ensure the data warehouse and BI systems adhere to Customer IT security best practices, protocols and standards.
• Proactively perform data analysis by comparing multiple external source systems datasets and identify data inaccuracies and anomalies.
• Investigate root cause and work together with DBA to develop remediation steps.
• Develop, design and maintain Star, Snowflake, Hybrid Schemes and Cubes to meet organizational reporting needs.
• Partner with the Project Manager and DBA to coordinate Application and Reporting releases.
• Participate in all phases of the SDLC including requirements gathering, design, development, testing, deployment and maintenance.
• Facilitate technical discussion and serve as one of the technical authorities/experts in the team to anticipate risks and problems and remove roadblocks.
• Contribute to the technical user support by assessing customer requests/issues and provide timely resolutions.
• Responsible for creating and maintaining all database related documentation.
• Work with minimal supervision on assigned projects. Manage time and tasks independently.
• Work as an individual contributor as well as in a collaborative work environment.
• Estimation of resources and budget planning
• Teradata Capacity Planning
• Disaster Recovery System setup & Management
• Planning the scope, design and implementation of a new Teradata database and migration of the existing database/data warehouse from existing platforms to Teradata warehouse
• Review and sign off on performance scores of projects before production implementation
• Experience working on Big Data stack like Hadoop, HDFS, Hive, Sqoop, TDCH, querygrid & presto.

Confidential

Principal DBA/Architect

Responsibilities:

• Assist with data models & data volumes to determine best possible Business solution.
• Facilitate understanding, document and articulate the customer’s current data warehouse/data mart strategic architecture.
• This includes a complete inventory of the customer’s data environment, data warehouses and DataMart’s as well as their respective business functions.
• Analyze, understand and effectively communicate information regarding Analytics and Data Warehouse competitive products
• Articulate and align Teradata’s solutions to the business problems mentioned above using Teradata RDBMS, Teradata Financial Management, Teradata Master Data Management, Teradata CRM, Data Mart consolidation, Active Data Warehouse, Dual Active, Professional Services and related solution offerings.
• Worked as a trusted advisor to the customer’s decision-makers by establishing credibility and expertise in data technology/architecture, and other areas related to Teradata’s Data and Analytic solution offerings.
• Identifying new application opportunities that will lead to additional data being added to the customer’s data warehouse as well as business value.
• Overseeing the overall Data warehouse performance staring data sourcing, staging, journaling, schematic, Reporting and Extraction also ETL tuning and Report performance tuning.
• Provide timely, accurate administration & reporting.
• SLES 11 TASM setup, Maintain and change TASM rulesets to tune the database further
• Extensive use of Viewpoint to monitoring the System health and using various portlets of Viewpoint for various task like data labs, Auto stats, Data Mover, query monitor, remove console (DBS Control, Ferret, Lock Display, Show locks, etc.).

Confidential

Associate Project Manager (DBA)

Responsibilities:

• Proven ability to lead projects across multi-departmental teams
• Collaborate with business owners and teammates to solve business problems, which may include standard tool or custom algorithm development
• Experience with Teradata, big data analytics and the ability to understand, manage, and maintain large data sets environments.
• Work closely with data warehouse architects and software developers to generate seamless business intelligence solutions for business partners
• Establishing roadmaps and providing stepwise instructions to follow the roadmaps
• Planning all associated work to meet project goals
• Estimation of resources and budget planning
• Develop project estimates for activities and Serves as escalation point for project related issues
• Strong working experience on software development life cycle
• Experienced working on Agile Development methodology.
• Providing guidelines for development and production implementations
• Ability to lead and mentor others, communicate to a wide variety of technical audiences
• Ensuring all project team members have the tools and training necessary to perform effectively
• Design and Architect Data Warehouse applications and systems
• Design and provide solutions on various data integration requirements involving systems like Teradata, Hadoop, Aster
• Participate as Subject Matter Expert (SME) as required for design reviews and technology and tool selection
• Attend Data Modeling review meetings and provide sign off on physical aspects of the model
• Review and sign off on performance scores of projects before production implementation

Confidential

Teradata DBA

Responsibilities:

• Actively participate in all phases of project development life cycle (SDLC) including database policies, procedures, standards and supporting documentation, database design, process flow analysis, development, benchmark analysis, performance/tuning, capacity planning, and production implementation
• Working on Various PDCR reports, capacity planning etc.
• Implementing retention and archival (BAR) policies using Netbackup and monitoring and managing the BAR jobs using TARA for archive and restore.
• Create users, establish roles, create database structures and understand how to get Teradata database to perform well.
• Involved in Logical Data Modeling (LDM), Extended Logical Data Modeling (ELDM) and Physical Data Modeling (PDM), tables, indexes and views.
• Monitoring database space, Identifying tables with high Skew, working with data modelling team to change the Primary Index on tables with High skew
• Addressing user issues such as resetting passwords, unlocking user id’s, working on permission issues.
• Monitoring Teradata system using PMON and Teradata Manager.
• Coordinating with Teradata GSC for any outstanding DB issues.
• Raising incidents to Teradata using TAYS and following up with them, Used TSET to send required information to Teradata GSC to analyze the issue reported
• Closely working with all the teams and get things done on time.
• Monitoring database space, Identifying tables with high Skew, working with data modelling team to change the Primary Index on tables with High skew
• Expertise is selecting Primary Index (UPI, NUPI) for a table for uniform data distribution across the AMP’s and Compressing Columns for efficient utilization of available disk space.
• Very strong on Teradata SQL query optimization techniques like: EXPLAIN feature, COLLECT STATISTICS option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile and global temporary tables.
• Written scripts for loading data using Multiload, Fastload, Tpt, Fastexport, BTEQ scripts.