SUMMARY:

• 9+ years of experience in IT Industry that involves Software Analysis, Design, Development, Maintenance and Testing in various enterprise applications.
• Experienced in Development and Implementation of various applications in big data environment using Hadoop, Hive, Sqoop, Oozie, Yarn, Pig, TPT, TDCH and Shell Scripts.
• Experienced in reengineering, building and implementing big data solutions.
• Worked on data quality check automation using big data tools.
• Have hands on experience in Spark with Scala and aware of the concepts of Java.
• Strong experience in IVR (interactive voice response) and voice recognition testing techniques.
• Have done automation using Hammer tool to rapidly test and optimize quality for voice applications.
• Proficient in application migration from Mainframe and Teradata based systems to big data environment.
• Experienced in Development and Implementation of various applications in Mainframes using COBOL, JCL, DB2, CICS and Web services.
• Have experience in development using tools like Endevor, File - Aid, Xpeditor, SPUFI, Inter-Test, QMF, CORPCAL, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2, OPC/A, CA7 and Librarian.
• Have experience in developing Teradata based applications using SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP and Teracopy.
• Have hands on experience to IC+ systems, Promise Systems, Avaya, Bar code Scanner, POS and Pin Pads.
• Developed and implemented solutions related to Asset Management and Financial Services, GWIM testing Technology, Sams’s Membership Reporting, Store Number Expansion, Data Fabric Balancing and Customer Engagement Technology.
• Strong experience on Database, Query Optimizations and Performance tuning for better response.
• Focused is in extensive coding, design, Architecture level changes, implementation, testing, and deployment of enterprise level applications.
• Have worked with international clients like Merrill Lynch, Confidential, Confidential -Mart Corporations and Confidential .
• Have adhered to application support life cycle and ALM management process and worked on integrated tools, having experience on problem/incident and Change management process.

TECHNICAL SKILLS:

Big Data: Hadoop, Hive, HDFS, Oozie, TPT, TDCH, Scoop, TEZ, Spark with Scala, Java (Basic), Shell Scripting

Mainframes: COBOL, JCL, SQL, Teradata, VSAM DB2, IMS, CICS, Endevor, File-Aid, Xpeditor, SPUFI, Inter-Test, QMF, CORPCAL, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2, OPC/A, CA7,Librian

Database/ Languages: DB2,Teradata, Hadoop(Hive), Unix, Oracle

Tool: /Libraries: BMC Remedy, Jira, Leankit, HPALM

Teradata: SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP, Teracopy.

Hardware: POS, Pin Pad, Bar Code Scanner, IC+, Promise

IVR: Hammer, Avaya, Genesys, CSG

PROFESSIONAL EXPERIENCE:

Confidential, Deerfield, IL

Developer and Quality Analyst

Responsibilities:

• Performed design, application development and deployment within the Hadoop architecture based on programming guidelines/standards.
• Responsible for writing and building code in Unix, Hive QL, Pig and Teradata.
• Responsible for designing Database Table structure, procedure, Functions and Query Optimizations.
• Involved in data quality check to ensure the correctness of huge amount of data.
• Involved in automation process for data quality check between Teradata and Hive tables data.
• Experienced in performing testing for the application to satisfy all the business cases provided.
• Involved in understanding Complex IVR flow, analyzing the testing requirements and automate the testing process using Hammer tool.
• Prepared test stagey, test plan, use cases, test cases, test scripts and supported UAT.
• Ran various queries in Oracle database for analysis of pharmacy data.
• Used various hardware like POS, Pin Pad, Bar Code Scanner, IC+, Promise and Avaya used to create pharmacy data.
• Performed activities for knowledge transition to support teams for the applications developed.
• Responsible for translating business requirements into systems qualities and Involved in requirement gathering, interaction with clients, managing offshore developments.

Environment: Hadoop, Hive, Sqoop, Yarn, Pig, Unix, Shell Scripts, SQL, Teradata, SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP, Teracopy, Jera, HPALM, Hammer, Avaya, Genesys, CSG, POS, Pin Pad, Bar Code Scanner, IC+, Promise.

Confidential

Developer

Responsibilities:

• Performed design, application development and deployment within the Hadoop architecture based on programming guidelines/standards.
• Responsible for writing and building code in Unix, Hive QL, Pig, Oozie, Cobol, Jcl and Teradata.
• Analyzed of existing process and data flow in mainframe and Teradata based applications.
• Reengineered the same flow using Hadoop based environment.
• Responsible for designing Database Table structure, procedure, Functions and Query Optimizations.
• Designed the database to store data from different sources which includes Walmart sales data best fitting the requirement need.
• Involved in performing ETL using TPT and TDCH functionality.
• Experienced in setting up the load back process to Teradata for seamless user access.
• Involved in performance optimization of the applications and long running SQL queries.
• Experienced in performing testing for the application to satisfy all the business cases provided.
• Involved in data quality check to ensure the correctness of huge amount of data produced by the reengineered applications.
• Created CA7-Oozie handshake mechanism which can send back job status back to CA7 and Oozie poling mechanism to monitor the status of a job at equal interval of time.
• Performed activities for knowledge transition to support teams for the applications developed.
• Responsible for translating business requirements into systems qualities and Involved in requirement gathering, interaction with clients, managing offshore developments

Environment: Hadoop, Hive, Sqoop, Oozie, Yarn, Pig, TPT, TDCH, Unix, Shell Scripts, Mainframes, COBOL, JCL, SQL, DB2, File-Aid, QMF, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2, CA7, SFTP, NFS, Teradata, SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP, Teracopy, Jera, Leankit, BMC Remedy.

Confidential

Tech Lead

Responsibilities:

• Performed design, application development and deployment within the mainframe and Teradata architecture based on programming guidelines/standards.
• Built extensive analysis procedures for impact analysis to mitigate risk.
• Prepared software requirement documents, test plans, high level design document, technical design document and support document.
• Worked with DBA for the database changes to be performed without any business impact.
• Involved in requirement gathering, effort estimation, client interaction and managing offshore developments.
• Involved in maintenance of existing modules, incident resolution, root cause analysis, problem management and implementation using Remedy.
• Providing/proposing optimum solutions based on the problem statement.
• Developed Teradata solutions using SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP and Teracopy.
• Involved in writing SQL Queries for data quality check and query optimization for long running query.
• Developed mainframe solutions using COBOL, JCL, DB2, CICS, File-Aid, QMF, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2 and CA7.
• Worked on web services which interacted with java as front end.
• Prepared systematic phase wise implementation plan for large applications.
• Involved in code review, integration testing, regression testing, user acceptance testing, implementation and post production support.
• Performed activities for knowledge transition to support teams for the applications.

Environment: Mainframes, COBOL, JCL, SQL, DB2, File-Aid, QMF, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2, CA7, SFTP, Librian, Xpeditor, Teradata, SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP, Teracopy, BMC Remedy.

Confidential

Team Lead

Responsibilities:

• Performed design, application development and deployment within the mainframe and Teradata architecture based on programming guidelines/standards.
• Prepared software requirement documents, test plans, high level design document, technical design document and support document.
• Worked with DBA for the database changes to be performed without any business impact.
• Involved in requirement gathering, effort estimation, client interaction and managing offshore developments.
• Involved in maintenance of existing modules, incident resolution, root cause analysis, problem management and implementation using Remedy.
• Providing/proposing optimum solutions based on the problem statement.
• Developed Teradata solutions using SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP and Teracopy.
• Involved in writing SQL Queries for data quality check and query optimization for long running query.
• Developed mainframe solutions using COBOL, JCL, DB2, CICS, File-Aid, QMF, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2 and CA7.
• Worked on web services which interacted with java as front end for promotions and marketing programs.
• Prepared result set to feed BI systems to create various dash board for the business users.
• Worked in critical reports such as top300, email capture, PMP, operator report.
• Prepared systematic phase wise implementation plan for large applications.
• Involved in code review, integration testing, regression testing, user acceptance testing, implementation and post production support.
• Performed activities for knowledge transition to support teams for the applications developed.

Environment: Mainframes, COBOL, JCL, SQL, DB2, File-Aid, QMF, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2, CA7, SFTP, Librian, Xpeditor, Teradata, SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP, Teracopy, BMC Remedy.

Confidential

Developer

Responsibilities:

• Performed design, application development and deployment within the mainframe architecture based on programming guidelines/standards.
• Prepared test plans, technical design document and unit test results.
• Involved in requirement gathering, effort estimation and client interaction.
• Involved in maintenance of existing modules, incident resolution, root cause analysis, problem management and implementation.
• Providing/proposing optimum solutions based on the problem statement.
• Involved in query optimization for long running query to cut down cost.
• Developed mainframe solutions using COBOL, JCL, DB2, CICS, File-Aid, QMF, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2 and OPC/A.
• Worked in customized data provisioning for client and account data.
• Performed test region refresh, QAPLEX (pre prod environment) refresh and file refresh.
• Performed analysis to save cost on storage.
• Involved in code review, integration testing, regression testing, implementation and post production support.

Environment: COBOL, JCL, SQL, VSAM, DB2, IMS, CICS, Endevor, File-Aid, Xpeditor, SPUFI, Inter-Test, QMF, CORPCAL, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2.

Confidential

Developer

Responsibilities:

• Performed design, application development and deployment within the mainframe architecture based on programming guidelines/standards.
• Prepared test plans, technical design document and unit test results.
• Involved in effort estimation and client interaction.
• Involved in maintenance of existing modules, incident resolution, root cause analysis, problem management and implementation.
• Providing/proposing optimum solutions based on the problem statement.
• Worked on adhoc query execution for business users to provide account and customer data needed to take various decisions.
• Developed mainframe solutions using COBOL, JCL, DB2, CICS, File-Aid, QMF, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2 and OPC/A.
• Worked to set up purge process for housekeeping activity.
• Worked on projects like Mellon NOC and visa mandatory changes.
• Involved in running batch in controlled environment for regression and integration testing for various applications.
• Involved in integration testing, regression testing, implementation and post production support.

Environment: COBOL, JCL, SQL, VSAM, DB2, IMS, CICS, Endevor, File-Aid, Xpeditor, SPUFI, Inter-Test, QMF, CORPCAL, DF-Sort, ICETOOL, Ezytrieve, Super C, BMCDB2.