SUMMARY:

• Over 12 years of progressive IT experience and Technical proficiency in Business Requirement Analysis, Application Design, Development, Testing and Deployment.
• 7 years of experience in Teradata Database and Application Design, Development, Implementation and Performance Tuning and optimization of High volume and complex databases.
• Extensive experience in Design and Development of Business Intelligence (BI) solutions using Data Warehouse, Data Mart, OLAP, OLTP, 3 Tier/Client Server Architecture on UNIX and Windows platform in various verticals such as Retail, Telecom and Healthcare.
• Technical proficiency in Designing and Developing ETL Applications using Teradata & IBM utilities such as BTEQ, FastLoad, MultiLoad, FastExport, and IBM Tivoli.
• Proficient in Performance Tuning and Optimization of High volume Databases, ETL applications, SPOOL space issues, Complex Queries using functional and technical approach such as enforcing Parallel Job Steam, applying PPIs, PIs, DBQL, Volatile/Global Temporary Tables, EXPLAIN PLAN, ViewPoint and Collect Statistics.
• Basic understanding of Informatica PowerCenter client tool to analyze source mapping and loader connections.
• Extensive Database experience with writing complex SQL Queries in various RDBMS such as Teradata, MS SQL Server, MySQL and MS Access.
• Experienced in OLTP/OLAP System design, Analysis and Design Database Schemas such as Star and Snowflake (Fact and Dimension), Data Modeling of large data sets, normalization process, writing source - to-target mapping documents, Dimensional and Multi-dimensional modeling.
• Experience in writing UNIX shell scripts to support and automate the ETL process.
• Involved in Full Lifecycle of various projects, including requirement gathering, System Designing, Architectural decision making, application development, enhancement, deployment, maintenance and Post-Production Support.
• Strong commitment towards quality, experience in ensuring experience in ensuring compliance to coding standards and review process.

TECHNICAL SKILLS:

RDBMS/Databases: Teradata 12/13/14, SQL Server 2000, MySQL, MS-Access, FoxPro, dBASE-III+.

Languages: C, C#.Net, Visual Basic 6.0, VB.Net

Tools: & Utilities: BTEQ, FastLoad, MultiLoad, TPump, FastExport, SQL Server DTS Packages, IBM Tivoli, Informatica PowerCenter 9.6.1

Internet Technologies: PHP, JavaScript, VB Script, HTML, JSON.

OS: UNIX, DOS, Windows 98/2000/XP/7.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond VA

Technical Lead/Analyst/Developer

Responsibilities:

• As a Technical Lead/Analyst/Developer involved in End2End solution design such as requirement analysis, understand business requirement, prepare Technical Design, define ETL strategy, development, prepare test cases, data validation and solution implementation.
• Currently working on AGP FACETS NY BRANDING project. The purpose this effort is to eliminate data integrity issue which was caused by commissioning new branding prefix criteria in AGP data source system. Involved in design and development of ETL scripts using Teradata utilities such as BTEQ and MultiLoad. Working on multiple BTEQ components to modify complex queries, with data validation and data flow design to fix/load existing membership tables.
• Worked on multiple decommission projects such as Dental DeCare, ZIP CODE, CMS NPPES which are developed using Teradata Load utilities such as BTEQs, MultiLoad FastLoad and Informatica ETL tool.
• Involved in Performance Tuning activities, ad-hoc tuning of complex queries to reduce response time, spool space utilization, identify skew factor and suggest solution.
• Worked on analysis and discovery phase to build a new Dependent Data Mart (set of 146 facts) from FDS to Clinical Program (CP). Involved in impact and risk analysis, development, back-tracking Informatica workflow/Teradata components to understand transformation and business logic to replicate solution into EDWard.
• Worked on CMS NPPES project to design and development of an ETL program using Teradata/Informatica tool to automate receive and process monthly data feed from CMS Gov. website.
• Developed/design Teradata scripts using BTEQ, MultiLoad, FastLoad to source data from csv and fixed length delimited files.
• Co-ordination with various distributed team to discuss proposed solution, ETL strategy, impact assessment, risk assessment etc.
• Developed/procedures to ensure conformity, compliance with Anthem EDWard standards.

Environment: Teradata 14.10, UNIX, Informatica Power Center 9.6.1, BTEQ, MultiLoad, FastLoad, WLM, ClearCase

Teradata Analyst/ Developer /Architect

Responsibilities:

• Analyze business requirement, design, development, testing and solution deployment.
• Prepare and analyze data flow diagram (DFD) for existing Margin Minder application.
• Prepare Architectural Diagram, discuss and seek approvals from the stake holders.
• Impact analysis, risk assessment, technical document design and Low Level document design.
• Data validation and comparison with legacy Margin Minder process.
• Daily status discussion and task allocation with off-shore team.
• Develop/Modify numerous Teradata Load Scripts such as BTEQs, MultiLoad.
• Develop ad-hoc FastExport and FastLoad scripts to transfer production data to Test environment.
• Write FastExport scripts to fetch historical data for initial load of Margin Minder application.
• Creation of numerous Tables, Views and Macros as per new Margin Minder requirement.
• Responsible for performance tuning and optimization of existing Views, Queries and base Tables.
• Write numerous complex queries consisting various base tables and assists MicroStrategy developer to generate business reports.
• Prepare and execute system and integration test plans which integrates Data Services Jobs, FTP file watcher, CONA ftp servers and Margin Minder ftp servers.
• Responsible for follow and enforce Architectural Review Board (ARB) and Coca-Cola EDW coding standards.
• Prepare detailed pre and post deployment checklist and ensure to meet all Change Management Requirements.
• Detailed Post-production validation such as data validation, proper execution of deployed scripts and monitor jobs.

Environment: Teradata 14, UNIX, BTEQ, MultiLoad, FastLoad, FastExport, SAP BW, Data Services, IBM Tivoli,MicroStrategy.

Teradata Analyst/ Developer /Architect IBM Global Business Services

Responsibilities:

• Analyze problems, design solution document, discuss with Team of Architects, stakeholders and take approvals.
• Analyze upstream and downstream applications, job logs, DBQLs and do the impact analysis of change.
• Prepare detailed step-by-step Low Level Design (LLD) document for implementing Performance Tuning and Optimization approach.
• Responsible for replicating Teradata, UNIX and Ab Initio test environments for development and testing purposes.
• Developed, modified numerous Teradata Scripts such as BTEQ, MultiLoad, FastLoad, FastExport.
• Developed numerous new Wrappers, Jobs and Schedules in UNIX for IBM Tivoli scheduler.
• Identify and optimized unusual long running queries by scanning monthly queries with help of DBQL queries, ViewPoint and Production logs.
• Optimized long running and complex queries by various optimization techniques such as Explain Plan, Visual Plan and Collect Stats.
• Performance tuning, monitoring and index selection while using ViewPoint statistics wizard and Index wizard and Teradata Visual Explain to see the flow of SQL queries in the form of Icons to make the join plans more effective and fast.
• Pre and Post data validation to ensure proper implementation of Optimized solution.
• Analyze sequential running jobs and optimize to run parallel to make optimum use of Teradata resources.
• Optimized numerous skewed high volume LIVE base tables containing 2-3 billion records by analyzing skew factor and applying proper PIs to enforce uniqueness.
• Optimized tables for various applications by applying optimization techniques such as changing SET to MULTISET, PI to enforce uniqueness, Multi-value Compression (MVC), remove unused columns, change data types to save space etc.
• Resolved SPOOL space issues of various queries by breaking up complex queries, utilizing Volatile and Global Temporary Tables.
• Optimized Presentation Layer (PL) by introducing a process to eliminate 30% i.e. 23 million disconnected registrations to process in daily job stream.
• Utilized Teradata Monitoring tools ViewPoint, PMON to analyze query execution steps and priorities Queries.
• End to end impact analysis, risks analysis of upstream and downstream applications to avoid any failure.
• Prepare detailed integration and system test plans.
• Prepare deployment checklist, regression plan, review checklist, post deployment activities.
• Post-production validation such as data validation, job monitoring and log analysis using ETLREAD.

Environment: Teradata 13/14, Ab Initio, Siebel, Dice, UNIX, BTEQ, MultiLoad, FastLoad, FastExport, IBM Tivoli, ViewPoint, PMON, ETLREAD.

BAG SIP

Responsibilities:

• Identify, prepare list of BAGs long running queries by scanning monthly queries with the help of DBQL queries, ViewPoint and logs.
• Optimized at least 50-55 long running complex queries for BAG application.
• Identified and resolved SPOOL space issues for various queries by splitting, utilizing Volatile and Global Temporary Tables.
• Track down each query to find all source temporary and base tables.
• Setup test environment such as replication of Teradata and UNIX environment, brining and loading sample data from production to test environment.
• Analyze, design document, discuss optimization approach with team.
• Impact analysis of applications, job logs, DBQLs for the targeted queries.
• Prepare detailed step-by-step Low Level Design (LLD) document for implementing Performance Tuning and Optimization approach.
• Developed, modified Teradata Scripts - BTEQ, MultiLoad, FastLoad, FastExport.
• Developed Jobs and Schedules in UNIX for IBM Tivoli scheduler.
• Optimized queries by optimization techniques such as Explain Plan, Visual Plan and Collect Stats.
• Performance tuning, monitoring and index selection while using ViewPoint statistics wizard and Index wizard and Teradata Visual Explain to see the flow of SQL queries in the form of Icons to make the join plans more effective and fast.
• Pre and Post data validation to ensure proper implementation of Optimized solution.
• Optimized jobs to run parallel to make optimum use of Teradata resources.
• Utilized Teradata Monitoring tools ViewPoint, PMON to analyze query execution steps.
• Prepare deployment checklist, regression plan, review checklist, post deployment activities.
• Successfully deployed fix for critical LIVE data stream applications with high volume of data.
• Post-production validation such as data validation, job monitoring and log analysis using ETLREAD.

Environment: Teradata 13/14, Ab-Initio, Siebel, Dice, UNIX, BTEQ, MultiLoad, FastLoad, FastExport, IBM Tivoli, ViewPoint, PMON, ETLREAD.

VSight

Responsibilities:

• Leading team and provide technical assistant to the development team.
• Understand requirement and document business rules/derivations as per the HLD and other technical documents.
• Conduct proof of concept and system analysis.
• Impact analysis and risk assessment.
• Provide technical assistant on tactical (Teradata) solutions in all areas.
• Designed Technical Design Document as per the Scope document HLD.
• LLD designing and task allocation to the development team.
• Explain solution approach with Architectural Board and take approvals.
• Interacted with Business System Analyst to gather information as per changes to be made on Business Data Model.
• Responsible for preparing source/target mapping documents for incremental and initial load.
• Performance tuning and trouble shooting.
• Planned, initiated and enforcing Confidential EDW standards.
• Prepare integrated deployment plan, review checklist, post deployment activities.
• Drive daily status meeting with team to discuss the status, risks and challenges.

Environment: Teradata 13/14, Ab Initio, Siebel, Dice, UNIX, BTEQ, MultiLoad, FastLoad, FastExport, IBM Tivoli, ViewPoint, PMON, ETLREAD.

Sr. System Analyst

Responsibilities:

• Analyze business requirement and provide conceptual design.
• Design Low Level Document (LLD) and programming specifications.
• Developed various Teradata Load Scripts for initial and incremental load using BTEQ, FastLoad, MultiLoad, FastExport.
• Developed numerous ad-hoc FastExport, MultiLoad and FastLoad scripts to fetch historical data from Production to Business.
• Created numerous INSERT and UPDATE Macros to trigger data load from JAVA environment.
• Responsible for providing daily and weekly and on-demand CSA extracts to the business users.
• Developed and configured many jobs for Global Command Center project (GCC) and Capacity Management Planning (CMP) project thru Control M.
• Performance tuning and optimization of queries and tables thru the entire development cycle.
• Database design and data modeling in initial phase of the project.
• Developed Disaster Recovery (DR) module for routine backup of daily snapshots.
• Involved in developing UNIX shell script to send auto emails to users if threshold meets.
• Responsible for post-production validation, trouble shooting and fixing issues.
• Provide technical assistant to team.

Environment: Teradata 13, UNIX, BTEQ, MultiLoad, FastLoad, FastExport, Control M, D1, CSA, ES (Oracle)

Technical Lead Software IBM Global Business Services

Responsibilities:

• Analyze Business Analyst and client requirement.
• Responsible for interface design, process design and functional specification.
• Conduct proof of concept and system analysis.
• Impact analysis and risk assessment.
• Explain solution approach with Architectural Board and take approvals.
• Develop solution using Teradata Load utilities such as BTEQ, FastLoad and MultiLoad.
• Writing load processes using Teradata tools like BTEQ, MLoad, TPump,
• Writing new and changing exiting stored procedures to implement new price features.
• Prepare and execute integration and system test plans.
• Performance tuning and trouble shooting.
• Prepare, execute deployment checklist.
• Post-production validation.

Environment: Teradata, UNIX, BTEQ, MultiLoad, FastLoad, FastExport, MS-ACCESS.

Technical Lead Software Lester Infoservices

Responsibilities:

• Analyze business requirement, design, development, testing and solution deployment.
• Impact analysis, risk assessment, technical document design and Low Level Design (LLD) document.
• Developed numerous tools and utilities using Microsoft Technologies such as Visual Basic 6, SQL Server 2000, VB.Net and MS-Access.
• Developed a web crawling tool to validate Corporate URLs as part of WALKERS Corporate Search Engine.
• Architected, Designed and developed multi-user Scripting Tool to design camp Confidential ns for BPA Surveys.
• Designed and developed multi-user Script View module ingenerated with Concerto and Small Wonder dialer COM, DCOM components.
• Designed and developed Data Transformation Tool to automate database replication process (as part of Scripting Tool)
• Responsible for writing ETL processes as per the business need using Teradata Load utilities BTEQ and MultiLoad.
• Database and architectural design for Scripting Tool, Script View and QC Module.
• Architected, designed and developed numerous data cleansing tools for MS-Access and SQL Server 2000 using VB Scripts and Windows APIs.
• Added functionality in Scripting Tool to auto send emails using Outlook APIs.
• Designed and developed Time Tracker application for Connecticut and Kentucky facilities.
• Developed stored procedures lead processing and validating business rules.
• Performance tuning, troubleshooting and provide production support.

Environment: Visual Basic 6, VB.Net, C#, Teradata, UNIX, BTEQ, MultiLoad, FastLoad, FastExport, MS-ACCESS, SQL Server, DTS Package, Concerto, Small Wonder, Windows APIs.

Software Developer Human Infosoft Technologies

Responsibilities:

• Requirement gathering, Analysis & Design and development.
• Developed, modified, and debugged old application.
• Developed various School Management System (SMS) module.
• Worked on database Designing and Normalization process for School Management System (SMS) project.
• Developed dynamic Mark Sheets and various academic reports using Crystal Reports.
• Developed multiple COM, DCOM for the application as per the requirement.
• Deployment of the application at client site and post-deployment validation.

Environment: Visual Basic 6, SQL Server 2000, Crystal Report.