SUMMARY

• Nine (9) years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Teradata across Banking Domain.
• Over 7+ years of experience inTeradata 12/13.10/15/16 (Teradata SQL Assistant, BTEQ, Fast Load, Multi Load, TPump, TPT (Teradata Parallel Transporter) and Fast Export.
• Over 5+ years of experience inData Stage ETL tool, Mainframe and TWS Scheduler and 4 years of experience in Informatica ETL tool, 1 year in OFSAA mechanism, UNIX and Autosys scripting.
• Over 1.5 years of work experience as Business Intelligence Senior Analyst in UK and US.
• Worked in several areas of Data Warehouse including Analysis, Requirement Gathering, Design, Development, Testing and Implementation.
• Expertise in Teradata Performance Tuning and Error Handling.
• Extensively worked on Mainframe, Unix and ETL environments to invoke Teradata Utilities and File handlings
• Strong knowledge on Slowly Changing Dimensions, Facts and Dimension Tables and Dimension Modeling (Star Schema and Snow Flake Schema)
• Extensive knowledge on data marts, data warehouse and dimensional modeling
• Good Knowledge on Teradata Parallel Architecture and its physical implementation
• Experience with unit testing and integration testing
• Knowledge on Schedulers like Tivoli Work Scheduler and Autosys.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, excellent interpersonal and communication skills combined with self - motivation, initiative and the ability to think outside the box

TECHNICAL SKILLS

Database management system: Teradata Database, Oracle DBMS, Microsoft SQL Server, OFSAA mechanism

ETL Tool: Informatica Workflow Designer and Monitor, Datastage

Process methodologies: Waterfall, V- process, Agile methodology

Teradata Tools/Utilities: Teradata SQL Assistant 12.0/13.10/16 , BTEQ, Fast Load, Multi Load, Fast Export

Operating System: Windows 7/10, UNIX, IBM Mainframe

Configuration management software: IBM UDeploy, Mainframe Endevor

Script Language: UNIX Shell script, Oracle PL/SQL, Teradata SQL, OFSAA XML language

Content workflow tool: Atlassian JIRA

Defect tracker tool: QC(Quality Center), HP ALM (Application Lifecycle Management)

Job Scheduler: Autosys, Tivoli Work Scheduler

Code Repository Maintenance: DCM, Sharepoint

Data base reporting tool: Microsoft SSRS(SQL Server Reporting Services), Tableau

Data base user interface: Oracle JDBC

Change Management tool: Pac2000, SM7

PROFESSIONAL EXPERIENCE

Software Development Senior Analyst

Confidential, Charlotte, NC

Responsibilities:

• Analyzing customer requirements to create a high level architecture design for the application.
• Determining how an application should work and how changes in conditions, operations, and the environment will affect outcomes.
• Judgment and Decision Making skill considering the relative costs and benefits of potential actions to choose the most appropriate Teradata functions, procedures or Informatica transformations.
• Participating in the requirement gathering sessions with the business users regarding User stories and evaluate and estimate the story points needed for new process development or enhancements using JIRA tool during Sprint Planning sessions
• During refinement sessions, she will analyze the requirements by understanding the Acceptance criteria and the Source to Target mapping documents.
• Implementing the WFCRC DataMart in WDM to provide Holistic View of Customer Due Diligence Data
• Extensively working in data Extraction, Transformation and Loading from Source to Target systems using Informatica and Teradata utilities like Fast Load, Multi Load, BTEQ and TPT.
• Automating the code to integrate data from different WDM source systems and load it into the DataMart
• Preparing test data like valid, invalid data, illegal format data, boundary condition dataset, no data etc. for executing “Performance Tests” and for “Manual Tests” across various environments like SIT and UAT.
• Producing test plan and test result from UAT environment for Business sign-off and fixing the defects in case of issues and redeploying the code
• Deploying quality code to Production and performing routine maintenance on the application and determining when and what kind of maintenance is needed.
• Troubleshooting and fixing defects in case the delivery from the team does not fit the customer’s specifications
• Keeping the team and stakeholders synced up and informed about the project development status, issues or changes through documentation
• Maintaining Issue Tracker to document the issues or the potential impact on the application to fix it in the next release cycle

Senior Consultant

Confidential

Responsibilities:

• Participated in the requirement gathering sessions with the business users regarding the project
• Created design documents and specifications for the project and work with the team to develop Teradata code, stored procedures and utilities like Fast Load, Multi Load, BTEQ and TPT.
• Created OFSAA - FSDF (Oracle Financial Services Analytical Applications - Financial Services Data Foundation) application for WRAP to identify the risk compliance of each customer
• Created ETL framework for the project to invoke jobs which handles Teradata Utilities.
• Schedule the daily and monthly jobs and job streams using Autosys scheduler
• Produced Online Report for the aggregation exposure using .NET framework.
• Monitor and analyze the daily production issues and provide solution to the users.
• Lead the team in offshore to take care of the various ad hoc requirements and enhancements
• Extensively used UNIX shell scripts for ETL framework.
• Extensively worked in data Extraction, Transformation and Loading from Source to Target systems using Informatica and Teradata utilities like Fast Load, Multi Load, BTEQ and TPT.
• Document the existing and new processes for the audit purposes.

Analyst Programmer

Confidential

Responsibilities:

• Involved in the requirement gathering sessions with the business users regarding the project
• Created Mid-Level Platform design documents and specifications for the project and work with the team to develop Teradata code, stored procedures and utilities like Fast Load, Multi Load, BTEQ and Fast Export.
• The project uses Teradata and Data Stage tools to extract customer daily retail and commercial transactions.
• Created ETL framework for the project to invoke jobs which handles Teradata Utilities.
• Schedule the daily and monthly jobs and job streams using Tivoli Workload scheduler
• Monitor and analyze the daily production issues and provide solution to the users.
• Lead the team in offshore to take care of the various ad hoc requirements and enhancements
• Extensively used Mainframe scripts as the Job Control Language.
• Performed Query Tuning by creating Teradata Join Indexes and reduced the Job performance timing which involves millions of transactions per day.
• Extensively worked in data Extraction, Transformation and Loading from Source to Target systems using Data Stage and Teradata utilities like Fast Load, Multi Load, BTEQ and TPT.
• Document the existing and new processes for the audit purposes.

Project Designer

Confidential

Responsibilities:

• Participated in the requirement gathering sessions with the business users regarding the project
• Created design documents and specifications for the project and work with the team to develop Teradata code, stored procedures and utilities like Fast Load, Multi Load, BTEQ and TPT.
• The project uses Teradata and Data Stage tools to extract customer daily and monthly commercial transactions.
• Schedule the daily and monthly jobs and job streams using Tivoli Workload scheduler
• Monitor and analyze the daily production issues and provide solution to the users.
• Prepared Data Stage mapping and Teradata jobs for extracting and loading data into the Warehouse.
• Performed Query Tuning using Teradata Join Indexes and reduced the Job performance timing.
• Extensively used Mainframe scripts as the Job Control Language.
• Extensively worked in data Extraction, Transformation and Loading from Source to Target systems using Data Stage and Teradata utilities like Fast Load, Multi Load, BTEQ and TPT.
• Document the existing and new processes for the audit purposes.

Teradata and ETL Developer

Confidential

Responsibilities:

• Actively involved in the requirement gathering sessions with the business users regarding the project
• Involved in complete Software Development lifecycle Experience(SDLC) from Business Analytics to Development, Testing, Deployment and Documentation
• Created design documents and specifications for the project and work with the team to develop Teradata code, stored procedures and utilities like Fast Load, Multi Load, BTEQ and TPT.
• The project uses Teradata and Data Stage tools to extract customer daily and monthly commercial transactions.
• Schedule the daily and monthly jobs and job streams using Tivoli Workload scheduler
• Monitor and analyze the daily production issues and provide solution to the users.
• Worked on Teradata BTEQ scripts and Utilities to create Teradata jobs and Data Stage mapping
• Extensively used Mainframe scripts as the Job Control Language.
• Extensively worked in data Extraction, Transformation and Loading from Source to Target systems using Data Stage and Teradata utilities like Fast Load, Multi Load, BTEQ and TPT.
• Document the existing and new processes for the audit purposes.