PROFESSIONAL SUMMARY:

• IT Professional with 9 years & 9 Months of proven experience with strong technical expertise that includes Source Data Analysis, Source to Target Mapping, Design, Development, Testing and Support.
• Extensive Project Lead experience in Data Warehouse environments like estimating the LOEs for each Service Request, Managing Project Rosters & vendor logs, Assigning tasks and keeping track of Project Deliverables, Project SLA & KPI, Maintaining the Communication log, Issue log, Release FPC, Senior Management Review deck & lessons learnt document with timely update to Senior Leadership on Identified Risks with Mitigation Plans.
• Instrumental in preparing the Project Plan for each release with detailed breakdown of tasks to sub tasks for each SDLC phases.
• Expert Level performer in Teradata.
• Very Good Domain knowledge and experience in Banking & Health Care Industry.
• Expertise in Party, Product, Agreement and Event Subject areas of Teradata FSLDM.
• Good Knowledge on Claim & Product Subject Area of HealthCare Industry.
• Successfully delivered & implemented complex project using the SCRUM SDLC model
• Strong Design, Problem solving, Code optimization and troubleshooting capabilities in Large Scale Teradata warehouse Environment.
• Excellent client interactive skills and has worked extensively on Customer facing roles across diverse cultures and geography locations that includes India, United Kingdom (19 months), Singapore (36 months) & USA (7 Months).
• Highly dedicated, Committed, Customer - Focused performer who is committed to quality in every task.
• Motivated achiever who guides organization in applying technology to business settings, provides added value, and creates project deliverable in a timely manner.
• Enthusiastic learner who quickly grasps new concepts.
• Excellent communicator and good listener.

TECHNICAL SKILLS:

Teradata V14 / V13.10 / V12 / V2R6.2 / V2R5.0

Oracle 9i

Windows 7

Windows 2000/XP

Unix AIX

ZOS

MVS JCL

UNIX

Teradata Parallel Transporter

Teradata Utilities

TD Stored Procedures

Informatica Power Center V 9.1.1 / 9.6.1

Sunopsis 3.0.0

Teradata PMON

Peregrine Service Centre

Tivoli scheduler

Control - M

Serena Dimension

Work Load Manager

Putty

Clear Quest

Service NOW TSRM

MS Excel, Word, Power Point

Microsoft Visio

Microsoft Project Plan

FUNCTIONAL AREAS:

IT Finance Management

Teradata FSLDM

Healthcare - Medicare

RELEVANT PROJECT EXPERIENCE:

Confidential

Project Lead / Technical Lead

Technology & Tools: Teradata 14, Informatica Power Centre 9.6.1, Unix AIX, Work Load Manager, Service NOW, TSRM & Clear quest

Responsibilities:

• Prepared Project Estimates LOEs ( Level Of Efforts) for Projects / Group of SRs
• Prepared the Project Plan for each release with detailed breakdown of tasks and sub tasks for each SDLC phases with appropriate task ownership and task dependencies
• Managed Project Rosters, Vendor Logs, Project SLA & Project KPI
• Performed daily task allocation to team members, provided opportunities on Cross skilling and kept track of deliverables.
• Frequently updated the Offshore Onshore Communication log, Issue Tracker, Release FPC Document & Lessons Learnt document.
• Generated weekly project status report with accomplished Key Milestone highlighted, Tasks on Hand for next week, Risks & Dependencies.
• Generated monthly project deck and had them reviewed with Senior Management.
• Co-coordinated meetings with Business and Confidential Tech Leads and other Project stake holders on Design APPROACH walkthrough, Test Results Walkthrough and other Show stopper that were encountered during the project life cycle.
• Conducted Knowledge sharing sessions on project theme, Lessons learnt and provided training on writing Complex SQL.
• Worked extensively and closely with Business in understanding the Business Requirement with example
• Worked extensively with Confidential Tech Leads in understanding Project Architecture, Upstream & Downstream dependencies, understanding the Business Requirement and translating the Business requirement to technical requirements
• Designed blue prints and provided solution's for complex business needs from Response files sequencing to Pre Submission Error Correction processing
• Performed walkthrough with the client on the Design approach and incorporated feedback review
• Developed complex SQLs to process provider data, maintain life cycle of traffic cop table and developed complex Bteq scripts that included Dynamic SQL generator for Pre Submission Error Correction process
• Designed sub applications that reduced the Claims processing timelines from WEEKS to DAYS by processing the EDI / CMS response files In Parallel rather than sequential.
• Reviewed codes developed by other team members and provided appropriate feedback.
• Validated and provided Signoff of the Test Results performed in Development and SIT Test environments.
• Performed Troubleshoot on unknown issues and fine tuning long running, High PJI Queries.
• Permanently resolved recurring Incidents

Confidential

Senior Developer

Technology: Teradata 14, V13.10, Business Objects & Mainframe JCL

• Analyzed different objects that resided in the Old reporting box like finding Current Data Volume, Frequency of Table Loads, Indexes, Existing Collect stats & Object Constraints.
• Analyzed different External entities that interacted with Reporting Box like Business Objects, Informatica, and Mainframe etc.
• Identified different business users who interacted with the Reporting box and identifying their Frequency of usage.
• Interacted with source SMEs to Understand the Functionality and Business Purpose of the Different tables available in the reporting Box
• Developed SQL that could performed analysis on the SKU units and generate storewide inventory reports

Confidential, Denver

Senior Developer

Technology: Teradata V13.10, Informatica Power Centre 9.0, Unix AIX, Autosys, PVCS (Version Manager)

• Developed Optimized transformation scripts using Teradata Transformation Views.
• Interacted with source SMEs to Understand the Functionality and Business Purpose of the Different columns available from Source for above refereed systems.
• Interacted with the Warehouse analysts to understand the Business Logic S2T mapping from Source to Various Subject area related to DNS( Confidential Services)
• Analyzed and validated the Data Profiling results of Source Data.
• Validated the Test Results in Development and Testing environments.

Confidential

Senior Developer cum Warehouse Analyst

Technology: Teradata V2R12, IT Banking & Finance, Unix, Informatica Power Centre 7.1.3, Teradata FSLDM

• Developed Optimized transformation scripts using optimized Teradata Transformation Views.
• Interacted with source SMEs to Understand the Functionality and Business Purpose of the Different columns available from Source for above refereed systems.
• Interacted with the Warehouse analysts to understand the Business Logic S2T mapping from Source to Various Subject area related tables of Teradata FSLDM of Private Banking Customers.
• Analyzed and validated the Data Profiling results of Source Data.
• Validated the Test Results in Development and Testing environments.
• Developed the OIA & CDM Scheduling Draft for referred systems.
• Facilitated the Users to validate the UAT data through Custom SQLs.
• Fixed Pre Live & Post Live Production Issues and Validated the Production Data.

Confidential

Senior Developer cum Warehouse Analyst.

Technology: Teradata Parallel Transporter, Teradata tools & Utilities, Unix AIX, Informatica Power Center 7.1.3, Teradata V2R6.2/12.0

• Developed Informatica Mappings for Extraction.
• Developed Loading Jobs using the Teradata Parallel Transporter.
• Developed Optimized transformation scripts using optimized Teradata Transformation Views.
• Developed Teradata procedures to automatically identify the values to be compressed.
• Developed Custom SQL to generate the Transformation View definition from the S2T Mapping Document.
• Interacted with source SMEs to Understand the Functionality and Business Purpose of the Different columns available from Source for above refereed systems.
• Interacted with the Warehouse analyst to understand the Business Logic S2T mapping from Source to Various Subject area related tables of Teradata FSLDM.
• Analyzed and validated the Data Profiling results of Source Data.
• Validated the Test Results in Development and Testing environments.
• Developed the OIA & CDM Scheduling Draft for referred systems.
• Facilitated the Users to validate the UAT data through Custom SQLs.
• Fixing Pre Live & Post Live Production Issues and Validated the Production Data.

Confidential

Senior Developer

Technology: Teradata Utilities, Unix, Sunopsis, Datastage, Control - M

• Developed, Tested & Implemented Sunopsis POC components into the Project
• Optimized Teradata Transformation Views for faster response time
• Developed Sunopsis Packages and the Scheduling Drafts (10 Overseas Countries)
• Validated Test Results in Development and Testing environments
• Facilitated the Users in validating the UAT data through Custom SQLs.
• Fixing Pre Live & Post Live Production Issues and validated the Production Data.
• Prepared the Regression / Production Rollout documents & Technical specification Document.

Confidential

Senior Developer

Technology: Teradata Utilities, Unix, Sunopsis, Datastage, Control - M

• Analyzed and understood the current SIBS (Silver Lake) Loan system which covered two Instruments namely (Commercial Loans & Mortgages).
• Developed Teradata Views based on the T2S documents provided by Mapper.
• Validated the T2S against the existing system and identified Columns being missed in T2S mapping.
• Developed the Teradata BTEQ / Utility scripts to load the Source Reference Data for downstream processing.
• Fine-tuned Teradata queries to Optimize the performance
• Created the Control - M draft
• Created custom SQL for MIS users to validate the Data
• Spot fixed Issues that were identified during Test and Production cycles.