SUMMARY

• Accomplished software engineer with 10+ years of experience in Information Technology with complete SDLC exposure and expertise in requirement analysis, application design, development, reviews and testing, using Oracle, Teradata, UNIX and ETL tools.
• Worked with end users and development staff to ensure that Design, Develop and deliver great software solutions in agile framework.
• Extract, transform and load systems to move data from the various operational systems in which it is collected to a cleansed, consolidated DW.
• Involved in design, enhancement, and development of applications for OLTP, OLAP using dimension modelling with Teradata and Oracle.
• Vast experience in creating database objects like tables, views, stored procedures, indexes, cursors, functions, triggers and queries and in managing user permissions and grants.
• Excellent scripting knowledge in developing databases using Teradata SQL.
• Extensively worked with Teradata utilities like Basic Teradata Query (BTEQ), Fast Export, Fast Load, Multi Load and Teradata Parallel Transport (TPT) to export and load data to/from different source systems including flat files.
• Good experience in Data warehousing this includes data analysis, data manipulation, and programming, testing, implementation and report generation.
• Proficient working in Oracle, Vertica, Teradata and Informix databases using SQL & PL/SQL.
• Worked as Data Warehouse developer with strong experience in fulfilling many Data Warehouse project tasks, such as Analysis, Design, and ETL (Extract, Transform and Load) process using Informatica, Teradata and UNIX
• Proficient in creating, monitoring and performance tuning of ETL jobs.
• Have experience in data modelling using Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Worked on data visualization using Tableau and analyzing the data using Statistical features in Tableau to develop trend analysis.
• Good experience with logical data models, schemas and physical database design and development.
• Expertise in UNIX shell scripting and AWK Scripting, Hands on experience in C programming
• Proficient in preparing high/low level documents like design and functional.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data.
• Analyzing raw data, drawing conclusions & developing recommendations
• Experience in working with Data profiling process of examining data available in an existing source.
• Experience in Business Requirement document and Functional Requirement document (BRD & FSD).
• Experienced in fast paced Agile Development Environment and methodologies including Scrum.
• Experience in trouble shooting and resolving data issues.
• Hands on experience developing dashboards on Tableau Desktop version 2018.3, prepared user stories to create compelling dashboards to deliver actionable insights
• Hands - on development assisting users in creating and modifying worksheets and visualization dashboards.
• Responsible for ad-Hoc Reporting, defining best practices in SQL, provided Production support to Tableau users and Wrote Custom SQL to support business requirements
• Excellent team player with good communication, problem solving and interpersonal skills.

TECHNICAL SKILLS

• SQL, PL/SQL (Structured Query Language)
• Shell Scripting
• AWK Scripting
• C/C++ Programming
• Oracle
• Teradata
• Vertica
• Informix
• UNIX/LINUX
• Windows
• WinSCP, Putty, SSH Tectia, Autosys, Teradata SQL Assistant, Toad SQL Assistant, Informatica Power Center 9.5/8.x, Tableau 9,10,2018.1
• FastLoad, MultiLoad, FastExport, BTEQ
• CVS
• SVN
• Banking and Financial services
• Telecommunications

PROFESSIONAL EXPERIENCE

Confidential

Teradata Developer/BACoE

Responsibilities:

• Working with various business stakeholders on requirements gathering for application development.
• Working with various teams on ongoing activities to complete the project requirements as per BRD and time lines.
• Handling multiple meetings with business users, Reporting teams and other stakeholders to clarify the requirements.
• Designing and developing the ETL processes from different source systems to transform the data as per the business requirements to be used by the reporting teams and other business teams for further analysis to improve customer value services.
• Generating the required data for direct marketing teams on daily basis for the implementation of their promotional plans to consumer & business.
• Working with architect and Functional teams/users to define and requirements/specs for the enhancements/new deliverables along with other client teams.
• Expertise in importing/exporting large amounts of data from files to Teradata and vice versa.
• Analysis the existing source tables and created facts, dimensions and star schema representation for the data marts.
• Delivering BTEQ scripts to extract, transform and load data into target Fact tables.
• Delivering MLOAD scripts to load data in the Stage/Target tables from source feeds.
• By utilizing FEXP Utilities, transferring the data from diff data bases to target client server systems.
• Performing the code reviews of the scripts delivered by the off-shore and on-site teams to ensure the correctness of functionality and performance.
• Handling the Performance Tuning by collecting statistics, analyzing explains, choosing appropriate indexes.
• Involving in System Integrating testing for developed modules and create defects.
• Hands on experience developing dashboards on Tableau Desktop versions 2018.3, prepared user stories to create compelling dashboards to deliver actionable insights
• Experience in gathering Requirements, Analysis, Design, Development, Deployment, Testing and Support of rich Interactive Dashboards and Workbooks using Tableau Desktop
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Geographic Visualizations, side by side bars, Stacked Bars, Filled Maps.
• Hands-on development assisting users in creating and modifying worksheets and visualization dashboards.
• Responsible for Developing Dashboard, ad-Hoc Reporting and defining best practices in SQL
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Confidential

Architect / SQL Developer

Responsibilities:

• Participated in architecture discussion with clients and was involved in finalizing the application design.
• Involved in requirements gathering and data gathering to support developers in handling the design specification.
• Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements.
• Worked on creating stored procedures, cursors, functions & triggers
• Extensive experience in writing and executing SQL scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
• Involved in SQL Tuning, Optimization, Indexes and Table partitions
• Written several PL/SQL scripts to implement the business logic.
• Interacting with Business Analysts for clarifications.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Done Query optimization explain plans, collect statistics, Primary and Secondary indexes Used volatile table and derived queries for breaking up complex queries into simpler queries. Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
• Involved in physical and logical design of the applications.
• Worked with DBA’s for transition from Development to Testing and Testing to Production.

Confidential

Technical Lead / Teradata Developer

Responsibilities:

• Participated in architecture discussion with clients and was involved in finalizing the application design.
• Involved in requirements gathering and data gathering to support developers in handling the design specification.
• Successfully migrated the application servers from AIX to Linux with minimal business impact.
• Involved in server configuration, installation of packages and migration of scripts and components to new server across all five environments including Dev, SIT, UAT, Contingency and Production.
• Created Autosys jobs for the new server and ensured defect free run by thorough testing and comparing outputs and runtimes.
• Created Teradata BTEQ scripts to implement the business logic.
• Worked on creating stored procedures, cursors, functions & triggers
• Worked on extracting data from Teradata database through CLI from the application.
• Implemented Connection to Teradata though CLI to archive data and objects Archived/extracted can be inserted, deleted and loaded into target databases such as Teradata, Oracle and SQL Server
• Used TPT, FastLoad, MultiLoad and FastExport Utilities in Teradata to load data from flat files and to export data.
• Created ETL jobs using Shell and BTEQ Scripting.
• Automated the manual application process by developing UNIX scripts.
• Revamped job execution logic from sequential to parallel processing resulting in cost savings for customer.
• Identified security gaps and established SFTP and NDM setup with the upstream/downstream from new servers.
• Performed onshore-offshore co-ordination, work packets assignment, defect tracking and resolution.
• Testing and co-ordination efforts for hardware upgrades.
• Root Cause analysis for Severity 1 and 2 issues in the production environment

Confidential

Technical Lead / UNIX, C++ Developer

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation
• Preparing High Level Design document (HLD) and Low-Level Design document (LLD)
• Developed application using C, C++ and Oracle SQL scripts
• Worked extensively on the CSQL (embedded SQL on C program) scripts
• Good knowledge on Object oriented concepts
• Build and test script execution
• Perform various testing i.e. Unit Testing, System Integration Testing and User Acceptance Testing
• Validating test data after each level of testing
• Onsite Offshore Coordination