SUMMARY

• Over 10+ years of IT experience in Requirement Analysis, Design, Build, Testing, Implementation, Maintenance and Production Support of software application projects preferably with an emphasis on Databases/Data warehousing/Data Marts/Business Intelligence.
• Experienced with different MPP or SMP database technologies or Relational databases (RDBMS) like Teradata, Oracle.
• Experienced in complex SQL queries, Macros, Procedures, Functions, Tables (Perm/Global Temp/ Volatile/ Derived), Views, Compression, Indexes (UPI, NUPI, USI, NUSI, NoPI), Join Indexes, Partitions (PPI) etc.
• Extensive experience in Designing and Development of enterprise solutions using Oracle PL/SQL and SQL. Extensively worked on DDLs, DMLs, Functions, Procedures, Packages, Cursors, Triggers, Sequences, Exceptions, Records, Tables, Views, Materialized Views, DBMS packages, Dynamic SQL.
• Proficiency with Teradata Tools Utilities (TTU) like BTEQs, FastLoad, MultiLoad, FastExport, TPump, TPT.
• Fair experience in Teradata Architecture, Join strategies, Locking mechanism, Analytical functions, Hashing, Hash map, Hash buckets and Teradata System tables (DBC Tables).
• Proficiency with EXPLAIN Plan Analysis, Skew Analysis, Index and partition analysis, Statistics collection, Database Query Log (DBQL), Access Logging, Journals, ResUsage/AmpUsage Analysis, Query Band, PDCR, Query Tuning for Performance Optimization, database IO performance tuning.
• Have fair experience in Teradata DBA activities like: Migration (data/objects) to DEV/QA/UAT/PROD, Creating Teradata Databases/Users/Roles/profiles, Access Rights, Lock Management, Space Management, Performance Management, Security Administration, ARCMAIN, Backup Archive Recovery (BAR), NetBackUp, NetVault, Viewpoint, TASM, Workloads, Schedulers, Teradata Manager, PMON, Teradata Administrator, Visual Explain, Index Wizard, Statistics Wizard, TSET, Pack Disk, Scan Diskand Unity Data Mover etc.
• Experienced with Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor) and ETL Best practices.
• Experienced with Source Qualifier, Router, Aggregator, Joiner, Expression, Lookup, Filter, Sorter, Rank, Union, SQL, XML, Update strategy, Sequence generator, Stored Procedure Transformations in Informatica.
• Experienced with Push down optimization (PDO), Partitions, File Lists, Tasks, Sessions, Workflows, Mapplets, Target Loan Plans, Debugger, Scheduler, Identify bottlenecks, Data Profiling, Optimization and Performance Tuning in Informatica.
• Experienced with DWH/BI concepts, OLTP/OLAP, E - R model&Dimensional modeling, Facts, Dimensions, Star/Snowflake/Galaxy Schemas, SCD Type 1/2/3.
• Fair experience on Linux/Unix Commands, KSH (Korn Shell), Unix Shell Scripting, Batch jobs, Crontab and Automation and Perl Scripting.
• Fair knowledge on BigData, Hadoop, HDFS, Hive, PIG, HBase, SQOOP, Tableau Desktop & Server.
• Fair experience in Data Analysis, Data Governance, Normalization/De-Normalization (1NF, 2NF, 3NF), data cleansing, Data movement, Root Cause Analysis (RCA).
• Fair experience in EDW/DW Architecture, Bill Inmon and Ralph Kimball’sApproaches, Conceptual, Logical and Physical Data Modeling (LDM-PDM) and ERwin Data Modeling, Forward and Reverse engineering, implementation of ODS layer,Atomic, Access layers and Semantic layers and TERADATA FSLDM model.
• Very good exposure to all phases of SDLC/Agile Methodology and well versed with Daily Standup, Scrum, Sprint, Burn down charts, Backlogs, User stories, Lean, Retrospective, Planning Poker, Iterations, Extreme Programming (XP) etc.
• Well versed with ITIL® processes of Incident/Problem/Change/Access/Knowledge/Service Management.
• Have successfully delivered various sizes of projects, primarily in the domain of Banking, Financial Services, Insurance, Mortgage Banking, Warehouse Management, Manufacturing, Healthcare and Telecom.
• Experienced with onsite-offshore environments and worked as Individual Contributor and as a Team Lead and supported/guided team members or less experienced staff whenever required.
• Experienced in Interacting with Users, Analyzing client business processes, Documenting business requirements (BRD), Performing Design Analysis, Developing Design Specifications, Work Estimation, Preparation of Test plans and Test Data, RTM (Requirements Traceability Matrix),Preparation of standard check lists and Best practices/guidelines (Teradata/ETL) etc.
• Experience in Team Handling, Defect Tracking, Risk identification and Mitigation, Communication Management, BAU support, Stake Holder engagement, Conflict Recognition and Resolution, Gap Analysis, Process improvement, Project Documentation, Client reporting, Release Manager, Account Level Initiatives.

TECHNICAL SKILLS

Languages: Oracle PL/SQL, D2K, Oracle Forms, Unix Shell Scripting, Perl, Teradata SQL, Pro*C, core JAVA, ANSI-SQL, XML, HTML, Java Script

ERP Package: Oracle Apps 12R

Databases/DW: Oracle 10gR2, TERADATA 13/14/15

Data Modeling: ERwin, Visio

Reporting Tools: BRIO SQR, Oracle Reports, SQL Reports, MicroStrategy (Web)

Teradata Utilities: Export/Import, BTEQ, FastLoad, MultiLoad, FastExport, TPump, TPT

Teradata Tools: Teradata SQL Assistant, Query man, Viewpoint, Unity Data Mover

Backup & Recovery: ARCMAIN, NetVault, NetBackup

ETL/DWH Tool: Informatica Power Center 9.6.x

Scheduling Tools: ESP, Maestro, Crontab

Other Tools/Utilities: TOAD, SQL*Loader, SQL Plus, Clear Case, VSS, Putty, Telnet, FTP, Forms Migration Assistance, SQL Developer, TortoiseSVN, WinScp, HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential

Team Lead, Teradata/ETL Developer

Environment: Teradata SQL, SQL Assistant, UNIX, ETL Informatica, Erwin

Responsibilities:

• Interacted with Business Analysts/Sr.Architects/Product Owners to understand the functional specifications and requirements and prepared technical and mapping documentation.
• Analyzed source system data, existing data models, and profiling data (using SQL)
• Maintained the data integrity during extraction, manipulation, processing, analysis and storage.
• Architected and developed the pipe cleaning activity tasks.
• Involved in Logical data modeling. Created standardized Physical data model using ERwin Data modeler
• Contributed to the proper selection of Primary,Secondary, PPI and Join Indexes takinginto consideration of both planned access of data and even distribution of dataacross all the available AMPs.
• Developed Teradata Objects like Macros and Stored Procedures as per the Business Logic.
• Created complex views like Detica, Hunter, LexisNexis, IntelliMatch, FircoSoft and other views as per the Business need. Also created semantic layer views to support specific data users.
• Extensively used Teradata Utilities scripts like Import/Export, BTEQs, FastLoad, MultiLoad, FastExport and TPT.
• Worked with On-Shore DBAs for transition from Development to QA/UAT and QA/UAT to Production.
• Participated in Explain Plan Analysis, Skew Analysis, Index and partition analysis, Stats collection and Query Tuning for Performance Optimization.
• Enforced Naming standards and created standard check list for Teradata Objects.
• Involved in different phases of Testing like Unit Testing, Integration Testing and System Testing.
• Involved in Teradata/Informatica mapping level Defect Fixing.
• Responsible for prototyping solutions, preparing test data, and conducting tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, XML and Union to develop robust mappings in the Informatica Designer.
• Worked with Architects to keep in sync with Application Enhancements to plan for Model/Schema Changes
• Designed and developed automation scripts to reduce overall effort and increase the efficiency in delivery.
• Responsible for managing a team of Teradata DBAs, Teradata Developers, ETL developers and ETL Testers.
• Worked with Release Management/DBAs to promote changes to diff environments.
• Managed Data Integration Development Team deliverables in order to successfully deliver end-to-end projects n schedule
• Participated in regular Joint Application Development (JAD) sessions.

Confidential

Team Lead, Teradata/ETL Developer

Environment: Teradata, BTEQs, FastLoad, MultiLoad, Export/Imports, Oracle, TOAD, ETL Informatica, Erwin

Responsibilities:

• Involved in requirements gathering and data gathering to support developers in handling the design specification.
• Analyzed source system data, existing data models, and profiling data (using SQL)
• Maintained the data integrity during extraction, manipulation, processing, analysis and storage.
• Wrote numerous DDL scripts to create tables, views and indexes in the TERADATA Data Warehouse.
• Created properPrimary Index (PI)taking into consideration of both planned access of data and even distribution f data across all the available AMPS.
• Reduced Teradataspaceused by optimizing tables - adding compression where appropriate and ensuring ptimum column definitions.
• Validated the data with respect to the Target CDM (Change Data Management) process. Also validated the data for accurate load into target databases.
• Involved in loading of data into Teradata from legacy systems and flat files using complexMLOAD scriptsandFASTLOAD scripts.
• Created Teradata External loader connections such asMLoad, Upsert and Update, Fastloadwhile loading data into the target tables in Teradata Database.
• Loading data by using the Teradata loader connection, writing Teradata utilities scripts (Fastload, Multiload)
• Write numerousBTEQ scriptsto run complex queries on theTeradata DW.
• Created semantic layer views to support AML Users. Also created reports based on these views.
• Extracted data from various source systems like Oracle, SQL Server, xml files and flat files as per the requirements.
• Assisted in Data Cleanup and Data profiling during the application implementation
• Performance tunedthe workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Responsible for object migration to QA/UAT/PROD and post-implementation support.
• Managed Data Integration Development Team deliverables in order to successfully deliver end-to-end projects n schedule
• Responsible for managing a team of Teradata DBAs and Teradata developers.

Confidential, Columbus, OH

Teradata/ETL Developer, Data Specialist, Teradata DBA

Environment: Teradata, BTEQs, SQL Assistant, UNIX, Perl, Teradata Viewpoint, ETL Informatica

Responsibilities:

• Worked on ad-hoc report requests from Customer and supported the clients for User Queries and Data Analysis by analyzing data from multiple data sources.
• Worked with multiple groups to define key reporting metrics, identified current database sources, assess the status of existing reporting capabilities and work with teams on go forward solution
• Analyzes complex business requirements, designs and writes technical specifications to design or redesign reports and applications
• Created semantic views to support DDG group Users. Also created daily/weekly/Monthly/reports based on these views. These are automated through Maestro Automation tool.
• Leveraged the semantic/Data Access layer for multiple types of applications and purposes.
• Coordinate the production and distribution of reports for a wide variety of end-users
• Managed small/medium tasks for process improvements of data management, data collection, reporting, or QA/QC
• Identified areas for improvement and implemented process change; worked with other technical Architects/BA to prioritize requirements
• Involved in Query Tuning for Performance Optimization for slow running reports/queries/applications.
• Handle Monthly/Weekly/Daily Jobs and also support/maintain Automation Process.
• Designed and developed automation scripts to reduce overall effort and increase the efficiency in delivery.
• Monitor and provide support to workflows and provide expert knowledge on all workflow designs.
• Involved in solving incidents, problems and business queries under the Application/Production support f the project. Solved critical/Long pending issues in less time.
• Created BTEQ scripts to transform data, FastExport scripts to export data and MicroStrategy (Web) reports.
• Used Teradata Data Moverto copy data and objects such as tables and statistics from one system to another.
• Performed Teradata DBA activities like Migration (data/objects), Archive/ Recovery, Creating Teradata
• Databases/Users/Roles/profiles, Access Rights, Workloads, Schedulers, Lock/space/ Performance ManagementSecurity Administration, Viewpoint monitoring and Data copy using Data Mover etc.
• Provides technical consulting to users of the various data warehouses and advises users on conflicts and Inappropriate data usage
• Involved in modification of existing Unix Shell scripts/Perl Scripts in Automation of ETL Teradata processes.
• Involved in Production Support for Daily loads and Monthly loads on an ongoing basis.
• Updated the business continuation plan (BCP) on weekly basis and reported to Lead.
• Created CATGEN script to automatically create DDLs which reduced the manual intervention and saves 6-8 man hours.
• This was well appreciated by Nationwide Top level management
• Attending project meetings and work with teams, Project managers, team members associates, business Analysts and internal customers/end users working with multiple tasks.
• Performed duties as Account SPOC for Software License management.
• Worked on POC (Sending Automatic Notifications to Insurance customers) in Bluemix platform.
• Worked on PoCs for production related queries and solutions.
• Participated in regular Joint Application Development (JAD) sessions.

Confidential

Sr. Teradata Developer

Environment: Teradata, BTEQs, FASTLOAD, MULTILOAD, SQL Assistant, UNIX, ERwin

Responsibilities:

• Worked with technical SME's and BI tech lead to understand requirements and designs.
• Developed Physical data model in which defining the Tables, Views, Indexes (UPI, NUPI, USI,NUSI, NoPI), Partitions (Range, List) and Compressions.
• Contributed in Unit testing and worked on Production bug fixes as and when required.
• Involved in Optimization for various business queries and scripts.
• Analysis of Explain Plan, Stats collection and Query Tuning for Performance Optimization.
• Seamlessly migrated the Tested code from DEV to QA to UAT and Production.
• Involved in writing scripts for loading data to target data warehouse using BTEQ, Fast Load and Multi Load.
• Involved in the Analysis and design of mapping.
• Carrying out data reconciliation through queries in various source systems.
• Selection of appropriate indexes by considering various factors by doing impact analysis.
• Involved in unit testing Involved and Preparing test cases.
• Developed Teradata macros to implement business requirement.

Confidential

Sr.Teradata Developer/ ETL Developer

Environment: Teradata, BTEQs, SQL Assistant, UNIX

Responsibilities:

• Preparation of the Technical Specifications based on the functional specifications received from Client
• Development of Code based on the approved Technical Specifications
• Developed Physical data model in which defining the Tables, Views, Indexes (UPI, NUPI, USI,NUSI, NoPI), Partitions (Range, List) and Compressions.
• Developed/Modified and Supported Extraction Transformation and Load (ETL) Processes usingInformaticaPower Center for data migration from source systems into Data Warehouse
• Validation of the data with respect to the Target CDM (Change Data Management) process. Also validate the data for accurate load into target databases.
• Created/Modified the Macros, BTEQ scripts and Stored Procedures as per the Business Logic.
• Involved in performance tuning of Database and Informatica ETL jobs.

Confidential, GA

Sr.Teradata Developer /TERADATA DBA/ Team Lead

Environment: Teradata, SQL Assistant, UNIX

Responsibilities:

• Involved in Multiple Development Initiatives e.g. Change Requests as part of Code Fix and Small Development Projects as part of New Requirements from the customer.
• Responsible for proper and efficient stats collection.
• Responsible for Optimization & Performance Tuning of various applications.
• Responsible for Data Analysis, Data Recovery, Purging and Archiving, Data Migration & Data Cleanup.
• Participated in DBA on call rotation to support production system during off hours.
• Moved DDL from DEV to QA and then from QA to PROD based on Service Requests and Change Management Requests using Migration tool.
• Extensively worked with DBQL data to identify high usage tables and columns.
• Created Users, database structures, established Roles, Profiles, addressing the user issues such as resetting passwords, unlocking user ID’s.
• Monitoring database, Identifying highly skewed tables, managing space.
• DevelopedUNIX shell scriptsto run batch jobs in production.
• Monitoring bad queries, aborting bad queries using Teradata Viewpoint, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Maintained batch processing jobs and respond to critical production issues
• Responsible for Backup and Recovery using Teradata ARCMAIN
• Monitoring of activities with Viewpoint and help DBA architects implement TASM rules on workloads.
• Responsible for managing a team of Teradata DBAs, Teradata Developers

Confidential

Sr.Teradata Developer /TERADATA DBA/ Team Lead

Environment: Teradata SQL, SQL Assistant, ERwin

Responsibilities:

• Gathered requirements from Business users/Architects and created a technical design documents.
• Created Tables, Views, Indexes, BTEQs, Macros and Stored Procedures as per the Business Logic.
• Validation of the data with respect to the Target CDM (Change Data Management) process.
• Also validate the Data for accurate load into target databases.
• Analysis of Explain Plan, Stats collection and Query Tuning for Performance Optimization.
• Provided support during various phases of Testing like System/User Acceptance Testing and part of Implementation and post implementation support team.
• Responsible for peer reviews, Code Review, TD Review
• Prepared Documentation, UTPs, Integration Test Plan and Presentation Material.
• Drive the day-day team meetings, team handling/assign work to team members
• Creation and managing Users, Databases, Roles, Profiles and Accounts.
• Granting and Revoking Access Rights on different database objects.
• Data Archives, Restores and Recovery, ARC Utility and Permanent Journals.
• Handling logon and logoff rules for Users.
• Resource Monitoring using Database Query Log(DBQL) and Access Logging
• Assigning Permanent Space, Spool Space and Temporary Space.

Confidential, Milwaukee, WI

Sr.Teradata Developer/ETL Developer

Environment: Teradata SQL, SQL Assistant, ETL Informatica

Responsibilities:

• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
• Worked closely with analysts to come up with detailed solution approach design documents.
• Worked with complexSQL queriesto test the data generated bythe ETL processagainst the target database.
• Provided quick production fixes and proactively involved in fixing production support issues.
• Created TD Utilities like BTEQ, MLOAD, FLOAD and Fast Export for importing and exporting of data.
• Involved inAnalyzing / buildingTeradata EDWusingTeradata ETL utilitiesandInformatica.
• Extensively used transformations inInformatica Power Center,ETL Environmentsto move data.
• Coordinate with Configuration management team in code deployments.
• Performed duties as a Release Manager.

Confidential, Carrollton, TX

Oracle Developer

Environment: Oracle PL/SQL, Oracle Forms, Oracle Reports

Responsibilities:

• Involved in Application migration from 6i to 10gR2. Replaced obsolete features with new functionality.
• Beautified the code by removing the dead code. Done rigorous impact analysis.
• Used the Forms Migration Assistant to upgrade the Forms Application Modules (.fmbfiles).
• Modified Packages, Procedures, Functions and Triggers as per forms navigation logic.
• Designed Oracle Reports 10g2 for complex projects.
• Actively involved inProduction SupportbyPerforming Tests, Trouble ShootingandBug Fixing.
• Involved in formulating general methodologies, naming conventions and coding standards for various proceduresand packages
• Designedforms using, complex logic and formula calculations, as well as the rendering of multi-stacked and multi-canvas forms.
• Development of screens in forms using oracle at backend according to the requirements of Clients.
• Developed Database Triggers for audit and validation purpose.
• Involved in CodeStandardizationandDocumentation.
• Tuned several Oracle SQL statements using Explain Plan, Auto Trace utilities.
• Coordinated between management, users and technical teams forRequirement Gathering
• Involved in various activities like preparation ofTechnical Documentation, Client Discussionsfor purposed Solution andUser Acceptance Testing

Confidential, Pittsburgh, PA

Oracle Apps Technical Developer

Environment: Oracle Apps R12, Oracle PL/SQL, Oracle Forms, UNIX

Responsibilities:

• Involved in the customization of reports as per the clients requirement.
• Created various (Back-end) PL/SQL code to implement business rules through procedures, Triggers, functions and packages.
• Fixing Bugs in Oracle ERP Forms and Reports.
• ProactivelytunedSQL queries & Views usingExplain Plan, Hints and indexes, SQL trace.
• DevelopedPL/SQLprocedures, functions, packages, triggersto validate the data and insert the validate data into Oracle Standard interface tables.
• Experienced in Customizing Oracle Forms withForms PersonalizationusingCustom.pllandZoom functionality.
• Dexterous in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g andXML Publisher(BI Publisher).
• Developed new Concurrent Programs, Custom Forms, Reports andFlex Field Customizations.
• Created and implemented Oracle AlertsandLookups.
• Developed variousRICEW components (Reports, Interfaces, Conversions, Extensions and Workflows).

Confidential, Rowlett, TX

Oracle Developer

Environment: Oracle PL/SQL, Oracle Forms, Oracle Reports, UNIX, Pro*C

Responsibilities:

• Involved in Application migration from 9i to 10gR2. Replaced obsolete features with new functionality.
• Beautified the code by removing the dead code. Involved in rigorous impact analysis.
• Used Forms Migration Assistant to upgrade the Forms Application Modules (.fmbfiles).
• Modified Packages, Procedures, Functions and Triggers as per forms navigation logic.
• Designed and developed Oracle Reports 10gR2 using complex logic and formula calculations as per the requirements.
• Actively involved inProduction SupportbyPerforming Tests, Trouble ShootingandBug Fixing.
• Involved in formulating general methodologies, naming conventions and coding standards for various proceduresand packages
• Development of D2K screens as per the users requirement.
• Developed Database Triggers for audit and validation purpose.
• Involved in CodeStandardizationandDocumentation.
• Involved in databasePerformance Tuningand Optimization.
• Coordinated between management, users and technical teams forRequirement Gathering
• Involved in preparation ofTechnical Documentation, Client DiscussionsandUser Acceptance Testing
• Conducted KT sessions on Migration Assistant tool, D2K forms and Application flow process to newcomers.

Confidential, Chicago, IL

Oracle Developer

Environment: Oracle PL/SQL, SQR Reports, HTML, Oracle Reports, Oracle Forms

Responsibilities:

• Gathered requirements from On-Shore leads on Reporting module.
• Wrote DDL scripts to create tables, views, triggers, sequences and indexes.
• Wrote PL/SQL code as per the technical and functional specifications.
• Created Oracle objects like packages, procedures and functions.
• Designed and Created reports using SQR reporting tool
• Created new D2K Oracle forms and updated existing forms as per the requirement.
• Optimized the queries to improve the performance of the application.
• DevelopedUnix Shell scriptsfor Automated Code deployment.
• PreparedUnit TestSpecification Requirements/Plan.
• Involved in Integration, System Testing and Post implementation support.
• Worked on troubleshooting defects in timely manner.
• Conducted KT sessions on Mortgage Banking Domain and SQR Tool/D2K to newcomers