SUMMERY EXPERIENCE:

• Offering proven expertise in Teradata, Mainframe & Big Data technology and have 14 yrs of experience in enhancement, maintenance, production support and testing of applications; currently working at Confidential.
• Understand the scope of project, customer expectations leading to conceptualization of the solution
• Latest 5 years of experience comprises Teradata & Hadoop experiences.
• Teradata development includes BTEQ, MLOAD, FASTLOAD, FXPORT, TPUMP, TPT, Teradata SQL Assistant, UNIX, Shell Scripting.
• Extensive experience in Mainframe development includes VS COBOL II, VSAM, MVS/ZOS, JCL/PROC, CICS, TSO, ISPF, DB2, BMS, SPUFI, StarTool, Expeditor, ChangeMan, QMF, FILEAID, ENDEVOR, OPC/TWS, FTP/SFTP, Scheduler ZEKE.
• Hadoop architecture includes Hive SQL, HDFS, Map Reduce, Sqoop, Hue, Pig Scripts, Spark etc.
• Understanding business requirements, analyzing the functionality and the changes required
• Understanding on data warehousing concepts.
• Preparation of technical design document, Low level design & high level design document
• Coding & Unit testing
• Reviewing coding & unit test cases
• Integration testing support
• User acceptance testing support
• Defect logging management
• In - depth application discovery for an application for sources dependencies.
• Monitor process compliance, through sample checks, and take corrective action in case of non-compliance.
• Ensure timely delivery of the project.
• Manage quality management activities, and contributes to process improvements over time.
• Have experience of estimation & managing tasks from the project plan and regular updates on them.
• Strong knowledge of Software Development Life Cycle (SDLC).

TECHNICAL SKILLS:

Languages: VS COBOL II, JCL

Operating system: Windows, Unix

DBMS / RDBMS: DB2,Teradata, SQL Server, Oracle

Tools: SPUFI, StarTool, Expeditor, QMF, FILEAID, Teradata SQL Assistant, FTP, SFTP

Scheduler: Control - M, OPC/ TWS, ZEKE

Version Control: SVN, Endevor, Changeman

Tools: FileZilla, Putty, Squirrel SQL

Teradata Utilities/Tool: BTEQ, MLOAD, FAST EXPORT, FASTLOAD, TPUMP, Teradata SQL assistant

Scripting Languages=: Pig Script, Shell Scripts

Big Data Eco System: HDFS, Map Reduce, Hive, Pig, Sqoop, Hue and Spark, Junit

OLTP: CICS, CICS Transaction gateway

PROFESSIONAL EXPERIENCE:

Confidential, Mooresville NC

Sr. Teradata Developer

Responsibilities:

• Understand the business requirements, scope of project, customer expectations leading to conceptualization of the solution.
• Teradata development includes BTEQ, MLOAD, FASTLOAD, FXPORT, TPUMP, Teradata SQL Assistant, UNIX, Scripting.
• Extensive experience in Mainframe development includes VS COBOL II, VSAM, MVS/ZOS, JCL/PROC, CICS, TSO, ISPF, DB2, Oracle, BMS, SPUFI, StarTool, Expeditor, ChangeMan, QMF, FILEAID, ENDEVOR, OPC/TWS, ZEKE Scheduler.
• Development in Hadoop architecture includes Hive SQL, HDFS, Map Reduce, Sqoop, Hue, Pig Scripts, Spark with exposure on Oracle database etc.
• Responsible and took ownership for signing-off on the mapping document for all metrics, Confidential ributes and filters required for Data processing.
• Performed efficiently in converting mapping document to respective transformations by creating complex SQL logics.
• Worked End-to-end from Collecting requirements, Analyzing the data, Involving in business meetings, Creating mapping documents, converting mapping document into complex SQL transformations, unit testing and pushing data sets to production etc.,
• Extensively worked with large Databases in Production environments.
• Extensive experience in performance tuning of the Database, SQL and writing efficient and complex queries on huge volumes of data.
• Expert in writing complex SQL’s in Teradata.
• Performed UNIX shell script and BTEQ Scripts for wrapping highly tuned complex SQL logics which loads tables both for history and Ongoing daily ETL process.
• Built very good communication with the team and got extensive knowledge and requirements of the applications. To ensure code quality standards, UT,CIT and SIT environment set up, guidelines and procedures are met
• Analyzing the functionality and the changes required
• Coding & Unit testing
• Reviewing coding & unit test cases
• Integration testing support
• User acceptance testing support
• Monitor process compliance, through sample checks, and take corrective action in case of non-compliance.
• Ensure timely delivery of the project.
• Manage quality management activities, and contributes to process improvements over time.

Environment: Teradata Utilities: BTEQ, MLOAD, FASTLOAD, FXPORT,TPUMP, TPT, Teradata SQL Assistant, UNIX, Scripting, Oracle.

Mainframe: VS COBOL II, VSAM, MVS/ZOS, JCL/PROC, CICS, TSO, ISPF, DB2, BMS, SPUFI, StarTool, Expeditor

Confidential, Chicago IL

Sr. Teradata Developer

Responsibilities:

• Understand the scope of project, customer expectations leading to conceptualization of the solution.
• Analyzing the functionality and the changes required
• Ensure timely delivery of the project.
• Integration testing support
• User acceptance testing support
• Handled Kmart & Sears Mainframe-Tera Data enhancement for project deliveries.
• Worked on end-to-end migration/modernization of legacy applications into distributed environment and enhancements.
• Worked with different team in Data warehousing/ ETL, Data Integration and Migration to Hadoop
• Experience in running Pig and Hive scripts.
• Performed Importing and exporting data into HDFS and Hive using Sqoop.
• Worked on the creation of business rules in Pig.
• Assisting Hadoop team for better PiGs coding in context of COBOL’s procedural context.
• Migrated Data Stage scripts to Pig Scripts.
• Imported data from legacy systems to Hadoop using Sqoop.
• Used Pig for data transformation.
• Experience in writing shell scripts to dump the Sharded data from Landing Zones to HDFS.
• Successfully migrated legacy applications Return Goods, DCPO, Open Item and de-commissioned legacy server.
• Possess expertise to train entire team for Microfocus Workbench Analyzer / Enterprise tool.
• In-depth application discovery for an application for sources dependencies.
• Preparation of Low Level Design of Cobol and Vision programs for distributed environment team.
• Manage quality management activities, and contributes to process improvements over time.

Environment: Teradata Utilities: BTEQ, MLOAD, FASTLOAD, TPUMP, Teradata SQL Assistant, UNIX, Scripting.

Mainframe: VS COBOL II, VSAM, MVS/ZOS, JCL/PROC, CICS, TSO, ISPF, DB2, Oracle, BMS, SPUFI, StarTool, Expeditor,ChangeMan, QMF, FILEAID, ENDEVOR, TWS Scheduler, ZEKE, FTP / SFTP.

Hadoop Architecture - PiGs, Hive, Sqoop, Hue, HDFS, MapReduce, Unix, Microfocus Workbench Enterprise and Analyzer, Eclipse, Data stage-Citrix, FileZilla, Python UDB, Putty, Squirrel SQL Client, Junit, SFTP.

Confidential

Delivery Module Lead

Responsibilities:

• Co-coordinating offshore team for deliverables and regular incidents assignment and tracking
• Tracking and escalating the issues.
• Escalation Management as per the shift cycle and handing over application to next shift.
• Responsible for the monitoring incidents and meeting SLA’ related to the processes.
• Defect logging management
• Resource Portfolio Management for incident’s resolution repository
• Responsible for the monitoring incidents and meeting SLA related to the processes.
• Responsible for assisting customer on a daily basis to report daily application status
• Mentor and guide the existing team and assist the new hires
• Analyzing the functionality and the changes required as specified in service requests
• Coding & Unit testing for service requests
• Reviewing coding & unit test cases

Environment: Mainframe: VS COBOL II, VSAM, MVS, JCL/PROC, CICS, DB2, BMS, SPUFI, StarTool, Expeditor, ChangeMan, UNIX, VS COBOL II, VSAM, MVS, JCL/PROC, DB2, BMS, SPUFI.

Teradata Utilities: BTEQ, MLOAD, FASTLOAD, TPUMP, Teradata SQL Assistant, UNIX, Scripting.