Assistant Consultant Resume

SUMMARY

Working as Assistant Consultant with Confidential.
Having 8.4 Years of experience in Software development functions including Requirement Analysis, Development and Enhancement, Testing, Implementation, Reviews and Production support activities.
Extensive experience in IBM Infosphere information server suite.
Good experience in Mainframe application programming.
Hands on experience in Apache Hive and Sqoop for Hadoop.
Extensively worked on both Waterfall and Agile methodologies for project implementations.
Having extensive knowledge on Consumer Banking domain and Cards domain.
Having good experience in test data provisioning for various stakeholders.
Having good knowledge in various channel testing (Customer channel and Associate channel).

TECHNICAL SKILLS

ETL Tools: IBM Infosphere Datastage V9.1/8.5, Apache Hive and Sqoop in Hadoop.

Operating systems: Windows, Unix/Linux, Mainframe ZOS

Databases: DB2 and Oracle

Special Software: Autosys, Putty, SSH Tectia terminal, Toad, File - Aid, BMC, Endeavour

Scripting: Unix Shell Scripting

Programming Languages: Cobol, JCL, Easytrieve

Scheduling tools: Autosys, CA7

Defect Tracking: HP Application Lifecycle Management

PROFESSIONAL EXPERIENCE

Confidential

Assistant Consultant

Responsibilities:

Senior selection lead in large test data repository management team.
Participating in end customer calls to understand their functional test data requirements.
Analyze the source systems and draft the methodologies to extract the required data from production tables.
Design and develop of the Datastage jobs for pulling the production data during off business hours.
Identify the Non-Public information (NPI elements) present in the production data and sanitize it using the Datastage data masking stage.
Identify the purged account numbers and replace the production account number with the purged account numbers.
Load the sanitized data into various test regions as per the testing team requirements.
Ensure that the data is working flawless through all channels (Online Banking, Mobile applications, and Associate applications).
Follow all the protocols mandated by the GIS (Global Information Systems) Governance team.

Confidential

Assistant Consultant

Responsibilities:

Functional ETL lead for large Data warehouse team which stores Consumer Retail services card customer details.
Identify, define, and model the application requirements into detailed design documents for all the retail store cards serviced by Confidential .
Work with onshore and offshore teams in creating the required Datastage jobs as per the design documents and standards set by clients and test it effectively.
Work with performance testing teams and made required performance tunings to ensure that the jobs are efficient.
Involved in code review meetings with multiple teams and ensure that all the requirements are covered in jobs.
Strict adherence to the client quality processes and TCS mandated quality processes.
Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.