SUMMARY:

• Over 9+ years of strong working experience in designing, developing and maintaining of Extract transform and Load (ETL) processes on Teradata using UNIX, Mainframes, with a hands on Experian on Oracle, Sybase, Shell scripting.
• And have around 3 years domain experience on Airlines, 2+ years’ experience Telecom domain and 3+years of domain expertise in Banking & Finance.
• End - to-End implementation and integration projects to successful completion under tight deadlines
• Strong working experience on Data Warehousing applications, directly responsible for the Transformation, Extraction and Loading data of multiple formats into Data Warehouse.
• Worked on all critical aspects of database/integration concerns in terms of capacity planning, database performance tuning and object movement between environments.
• Has experience as Data Analyst/Data Architect.
• Worked on End to End Migration of Sybase to Teradata and DB2 to Teradata Migration Projects
• Hands-on experience in documenting and supporting Business Intelligence systems.
• Leading Team, Project planning, forecasting, Resource management and billing.
• Participating in Organizational level Technical interviews and Teradata Training
• Good knowledge on DBA activates
• Developing Stored Procedures, Macros, TPT, Mload, Fast-load, Fast-export, Bteq and Tpump Scripts.
• Developing SQL Quires and Shell Scripts for Data acquisition as per the client requirement.
• Hands on ETL Development experience with ODI (Sunopsis).
• Experienced in Adhoc reporting and acting as a bridge between the Business and the IT.
• Client calls coordination, requirement gathering and Communicate/Guide team in deliverables.
• Job flows Designing, Developing scripts/SQLs, Testing, UAT, SAT and Implementing in production in Unix/Mainframes
• Identify pain areas, Suggest and implementing better approach for a given process.
• Providing Warranty maintenance/support for delivered application
• Planning and Creating Roles, Profiles, Users /Databases, handling access rights.
• Designing, Creating and Maintenance of Tables, Views, macros and Stored Procedures.
• BAR - Archive/Backup and Restore using Net-vault and Capacity Planning, Space monitoring.
• Hands on experience of Teradata Viewpoint
• Identify, Optimized and implementing the Process (SQL, Scripts) for better Performance of the system using SQL Tuning using Visual Explain, Stats, Indexing, SQL Trace, Explain Plan, Partitioning and Materialized Views/Snapshots. And Data profiling.
• Using PDCR performance Reports for understanding and managing system workload.
• Managed scheduling of ETL systems using different scheduling tools like JSC, ODI scheduler and Customized scheduler.
• Schedule/ Managed and Monitoring Jobs via TWS, JSC, Control M, EE and Version controlling via SCCS, CVS, SVM.
• Investigate, Mitigate the Jobs abends and resolve Data discrepancy with in SLA.
• System monitoring via Viewpoint and Alerting DBA Team and Users wrt Query blocking, delay in processing time and unplanned outages and controlling Schedulers
• Support Adhoc user query requests via tickets within SLA
• Resting and rescheduling the jobs during high load, upgradation or maintenance activities
• Performing health and Data Quality check before and after upgrades and outages.
• Publishing dashboards wrt System states on daily basis

TECHNICAL SKILLS:

Operating systems: IBM MVS/TSO, Windows, UNIX

Programming Languages: PL/SQL, JCL

Databases: Teradata, Sybase, Oracle, DB2

Domain Knowledge: Telecom, Airlines and Banking

Tools: & Utilities: Teradata Utilities (BTEQ, Fast Load, Multi Load, Fast Export, TPUMP), Teradata SQL Assistant, Teradata Administrator, PMON, TQS, Viewpoint,BAR -Net vault, TDM

Schedulers: (SCCS, JSC, Control M), Erwin, LDM, FSLDM,CLDM,MLDM, ELT/ ETL, SUNOPSIS 4.1

PROFESSIONAL EXPERIENCE:

Confidential, CT

Responsibilities:

• DBO Migration & Development is an IDN Transformation project to migrate the existing Abinitio-Sybase and develop new process to fit into MDF + Teradata process.
• Developed/Migrated 1000+ Store procedures and its related database objects (Tables, Views, Macros, Functions) from Sybase to Teradata.
• Develop BTEQs Scripts for control and Alert process
• Generated Test file and Testing End to End loaded process in Teradata using Confidential customized frame work (MDF).
• Parallel Data Testing (Sybase v/s Teradata), data discrepancy back tracking and providing fix for warranty period agreed as per SLA.
• Identify and performance tuning of skewed SQL across the system
• Understand the data flow from source to downstream users
• Analyze Overall IDN process (Critical Jobs, High Skewed Stored Procedures)
• Provide recommendations for modernization opportunities and solution to pain points in IDN/GDAC as experienced by Business Users
• Provide steps to align with the road as decided by Confidential IDN/GDAC leadership.
• IDN Support - Maintenance and Support of 3000 feeds (Around 50K load jobs) and Defect fixing.
• System performance management and alerting DBA wrt System status and unplanned outages
• Creating Dashboards for Business to provide the status of warehouse
• Responsible for timely delivery of reports to downstream applications
• Back tracking and Resolving queried raised by Users

Confidential

Sr. Teradata Developer and DBA

• Responsible for overseeing the Quality procedures related to the project.
• Involved in Development of Sharestakes application process change as per now file formats
• Involved in Database Capacity planning for implementation of Sharestakes application
• Testing - UAT and SAT
• Identify limitation in the process and Provide optimized solution
• Database management activities like SQL Tuning, Space management and BAR activities.
• Responsible for smooth flow of business,
• Responsible for timely delivery of reports to downstream applications
• Back tracking and Resolving queried raised by Users

Confidential

Sr. Teradata Analyst and Teradata DBA

• Responsible for overseeing the Quality procedures related to the project.
• Datacenter Movement and Database Upgrade from V2R6.2 to TD12 activity
• Involved in Project Development activity of lunching new Network Circles
• Testing - UAT and SAT
• Identify limitation in the process Provide optimized solution
• Database management activities like SQL Tuning, Space management, user Id and profile creation and Monitoring jobs via PMON, prioritizing the blocking jobs and responsible for smooth flow of business, BAR activities
• Creating Dashboards for Business to provide the status of warehouse
• Responsible for timely delivery of reports to downstream applications
• Back tracking and Resolving queried raised by Users

Confidential

Teradata Analyst

Responsibilities:

• Developing and modifying changes in mappings & Workflows according to business logic.
• Creating and Executing Unit Test cases.
• Creating the Detail Design Document.
• Coding using Teradata SQL and Teradata Utilities and JCLs and Shell Scripts
• Testing - UAT, SAT
• Database management like space management, Creating DDLs, Performance Tuning and Deployment of scripts.
• Responsible for overseeing the Data Quality procedures related to the project.
• Monitoring scheduler, Debugging for Mapping and resolving failures.
• Analyzing the tickets and providing solutions.
• Working on Adhoc request requested by Application users and providing Reports
• Prioritizing the jobs and responsible for smooth flow of business

Confidential

ELT Developer

Responsibilities:

• Involvement in the project from the initial stages starting from designing, data validation, development, to testing.
• Design and Development of interfaces, Packages, Scenarios and SQLs
• Database management, JDBC connectivity, managing Sessions
• Testing - UAT and SAT
• Responsible for overseeing the Quality procedures related to the project.
• As a Data Mapper, was responsible for Data profiling
• To analyze the user requirements thoroughly and map the respective information from the source into EDW- FSLDM.
• Presentation on the mapping documents to extended teams (source systems, FS-LDM team and business users)
• Creating Migration check list and KT document.