SUMMARY

• 11 + years of IT Experience in Software Development and Implementation of business applications.
• 8 + years of ETL experience in Teradata and its Utilities.
• 3 + years of experience in Mainframe and its Utilities.
• Sound knowledge in Data Warehousing concepts. Dimensional data modeling, Relational data modeling, Data Aggregation, Star and snow flake schemas.
• Good Knowledge in UNIX shell scripting.
• Good knowledge on CA7 schedulers, CRON, Endevor sub - systems and One Automation schedulers.
• Excellent Team Player and Onsite coordinator for a team of 8 offshore resources.
• Possess strong analytical and problem solving skills. Fast learner.
• Possess sound knowledge in Source to Target transformation mapping document.
• Have excellent knowledge understanding different source systems and different data formats.
• Have adequate knowledge in preserving the data quality while moving from Source to target.
• Possess sound knowledge in Incident Management, change management and Release management.
• Have excellent knowledge in application support activities.

TECHNICAL SKILLS

Languages: COBOL, JCL and SQL

Scheduling Tool: CA7, AUTOSYS, One Automation and CRON

Version Control Tool: Endevor, SVN Subversion, Change man and VSS

Other Client Tools: Visio, Mainframe- File Aid & File Manager, Network Data Mover NDM, JIRA, REXX, WinSCP

Database and ETL systems : Teradata and Informix SQL

Data Management / Analysis tools: Teradata Sql Assistant, Toad for Data analysts and Teradata Studio

Teradata Utilities: TPT, Mload, Fast Load, BTEQ, Fast Export, Tpump and ARCMain (Archive and Restore).

Operating Systems: Windows, UNIX, Z/OS

PROFESSIONAL EXPERIENCE

Confidential

Teradata Developer

Responsibilities:

• Performed Development activities to map and load data from different Line of Business and Consolidate them to Teradata tables and views.
• Worked on converting mapping logics into Sql queries with different Teradata utilities.
• Involved in analysis and enhancements in UNIX shell scripts which are used as framework for Teradata Sql.
• Extensively used CRON schedulers for scheduling the Batch jobs.
• Extensively used JIRA to create and work on stories in agile methodology.
• Involved in Impact Analysis, Unit Testing/SIT and suggestions for lineage/mapping documents to Business Analysts.
• Worked in other adhoc projects belonging to Marketing area which required analysis and development activities.
• Worked on Sql Analysis, data model review, gathering business rules for transformations.
• Extensively worked on query performance tuning for better resource utilization and faster execution time.

Confidential

Technology Analyst

Responsibilities:

• Performed Development activities to consolidate different source systems and on going maintenance/BAU activities to support the application.
• Worked on Data pulls from different source systems including third party vendors like VANTAGE and ICOMS billing systems and loading into target tables with Teradata utilities like Multi load (Mload), BTEQ and TPT by applying different transformations and aggregating based on different factors.
• Extensively used One Automation schedulers for scheduling the Batch jobs.
• Extensively used SVN Subversion for Version Control.
• Extensively used JIRA for Project Management activities.
• Involved in Unit Testing, preparing the Design documents and other lineage/mapping documents.
• Worked on data model review, gathering business rules for transformations, created high level and low-level design documents.
• Extensively worked on query performance tuning for better resource utilization and faster execution time.
• Provided support during the weekends for any issues related to the daily batch jobs.

Confidential

Technology Analyst

Responsibilities:

• Performed Development activities to provide maintenance to the Tax reporting application.
• Worked in several COBOL programs on year end enhancements for Tax year’2016.
• Worked on Cobol programs, Copybooks, online programs for the Vendor (stoneriver) code changes.
• Extensively used CA7 schedulers for scheduling the Batch programs.
• Extensively used Endevor for the components involved in the application.
• Worked on different SORT utilities.
• Involved in Unit Testing, preparing the Design documents and other lineage/mapping documents.

Confidential

Technology Analyst

Responsibilities:

• Performed Development activities to provide maintenance to the Consolidation data mart.
• Worked in Agile methodology to carry out the development activities.
• Worked on Data pulls from different work streams and loading into target tables by applying different transformations and aggregating based on different factors.
• Worked on Reconciliation across source and target data, carried out analysis on complex data to perform reconciliation
• Worked on UNIX platform to develop shell scripts which in turn triggers Consolidation queries (BTEQ)
• Generated Space Reports on weekly basis for model environments and estimated the space needs for the application to run smoothly.
• Extensively used SVN Subversion for Version Control.
• Extensively used JIRA for Project Management activities.
• Performed Rock and Rolls for biggest model tables using different approaches to avoid the space requirement.
• Providing warranty production support and working on enhancements.
• Actively participated in the Requirement analysis discussions with Business to trace each requirement into design modules.
• Performed Environment Management activities for numerous model environments such as creating new databases/tables, allocation of space and granting necessary access,Test data setup for different testing routines.

Confidential

Senior Software Engineer

Responsibilities:

• Worked on loading the data from mainframe PS files by applying necessary transformations into Teradata staging tables with Teradata utilities Multi load (Mload) and Tpump. Performed post load data quality checks
• Worked on implementing the value added processes (VAP) using BTEQ.
• Worked on data import and export using ARCMAIN (Archive and Restore) utility.
• Worked on SCD(Slowly Changing Dimensions) and HCD(Highly changing dimensions) concepts
• Worked on data model review, gathering business rules for transformations, created high level and low-level design documents.
• Used Volatile and Global temporary tables while implementing complex transformations..
• Worked on model changes to make our users queries perform better. Vertical and Horizontal partitioning improved the performance of queries and removed the space requirements for Model changes (Rock and Roll).
• Created views on top of Teradata tables based on business needs. Good in implementing privacy views for any requirements.
• Implemented Change data capture ( Confidential ) for the slowly changing dimensions (SCD) and reduced the 35% of space usage.
• Parameterized the SQL components using mainframe SYNCSORT to use it across environments with minimal changes.
• Extensively used change man for versioning the components.
• Generated space reports on weekly basis to analyze/manage the space across all the Teradata environments.
• Implemented Compression on Teradata tables and saved 17% of total operational cost ($ 1,100,000) for Confidential 's - Retail Enterprise credit information system portfolio.
• Replaced full table statistics with Sample statistics and reduced the usage of Teradata resources. 24% of system resources are saved for Confidential 's - Retail Enterprise credit information system portfolio.
• Performed Rock and Rolls for biggest model tables using different approaches to avoid the space requirement.
• Extensively used DBC Tables for the performance measurement, Space calculations, Teradata objects analysis and usage reports on attributes.
• Providing warranty production support and working on enhancements.
• Worked on query performance tuning to meet the standards set by Confidential - Teradata Architecture review team.

Confidential

Software Engineer

Responsibilities:

• Worked on gathering requirements and creating Impact analysis documents for the changes to be implemented
• Invloved in Component Design
• Unit Test Plans Design
• Coding & Unit Testing