EXPERIENCE SUMMARY:

• A vibrant, dynamic person post graduated in Power System Engineering, moulded professionally with 7 years of corporate experience.
• Having spearheaded some of the critical projects of Confidential, in the Consumer and Small Business Banking Domain.
• Wide experience in overall project execution in the retail banking sector.
• Good technical expertise in Hadoop, Teradata, SAS, DATASTAGE, Mainframe IMS, DB2, Hogan CIS.
• My project experience includes executing project activities on and off client location.
• Having successfully coordinated projects from offshore, exposed to the overall project execution from analyzing requirements to implementation and post production from client location.
• Analyze and understand new test data requirements.
• Maintain synchronized data between Consumer, Card, and Confidential .
• Minimize the need for data conditioning and to provide up - to-date test data which mirrors production data.
• Develop necessary components for the requirements identified for reducing the Source foot print in consumer domain.
• Carry out unit testing for the components prepared. Run scan jobs to make sure impacted elements for cleanup are nowhere used.
• Providing selected data to sanitize by pulling production data as part of Test Data Automation under Data Protection Solution.
• Seed the lower test environments with new sanitized data from production and provide necessary support if there is an issue related to data.
• Continuous monitoring of the existing process and provide optimized solutions to improve the performance and decrease the timelines of the process.
• Extensive exposure to all the phases of SDLC ranging from Design to the Implementation & Production support activities.
• Expert knowledge in Hadoop, SAS, Datastage, COBOL, HOGAN CIS, IMS DB, VERTICA, DB2.
• Experience in handling OAG and SOAP XML message in online IMS environment through MQ.
• Expert knowledge in Developed windowing functions of Hive to run data analytics.
• Expert in Created Hive scripts and ingest the data into Hive.
• Good understanding on MapReduce concepts, HDFS Framework.
• Knowledge in Inquiry and monitoring of CA7 scheduling, Autosys
• Programming experience in COBOL, JCL, Ezytrieve, SQL, CICS, VSAM, ENDEVOR, Shell scripting (LINUX), Perl, Base SAS, Hadoop.
• Hands on experience with Map Reduce, HIVE, ISPF, MVS, Datastage, SAS EG & SAS PC

PROFESSIONAL EXPERIENCE:

Confidential

Developer

Responsibilities:

• Establish an always available, sanitized, in-sync and current RPG test environment
• Enhance toolset to improve data mining capabilities, automate test data population and assist with data generation and conditioning
• Automate, standardize and enhance batch processing
• Perform impact analysis for the new business requirements.
• Review new test data requirements.
• Build centralized sanitized data and mask the production data coming in from various applications.
• Carry out unit testing for the components prepared.
• Run jobs during data refresh process to capture subset and sanitize data.
• Seed the lower test environments with new sanitized data from production.
• Provide support to all test platforms when and where there is an issue related to data.
• Installed and configured Hadoop, MapReduce, HDFS (Hadoop Distributed File System), developed multiple MapReduce jobs in java for data cleaning and processing.
• Applied MapReduce framework jobs for data processing by installing and configuring Hadoop, HDFS.
• Created Hive External tables and loaded the data in to tables and query data using HQL.
• Performing data analysis in Hive by creating tables, loading it with data and writing hive queries which will run internally in a MapReduce way.
• Performed performance tuning and troubleshooting of Map Reduce jobs by analyzing and reviewing Hadoop log files.
• Evaluate current or emerging technologies to consider factors such as cost, portability, usability.
• Ensure the compatibility of system components.
• Creation of WBS (work break-down) structure for the project.
• Collaborate with engineers or software developers to select appropriate design solutions or ensure the compatibility of system components.
• Doing a continuous monitoring of the existing process and provide optimized solutions to improve the performance and decrease the timelines of the process.

Languages: SQL/Unix Schell scripting, Hadoop - Map Reduce, HDFS, Pig, Hive.

Tools: IBM InfoSphereDatastage, Autosys.

Confidential

Developer

Responsibilities:

• Requirement analysis by understanding the functionality in mainframe and creating requirements document.
• Created Design document with flow charts for table loading processes and sharing with clients.
• Identifying the tables which are not being used by the end users and scanning the production libraries to make sure table is nowhere referred.
• Analyzing the impacts in deleting the related elements of table which is good for decommission.
• Sending email notification to end users on table decommission dates and when the data will be cleaned.
• Taking our analysis to L2 team and getting approval for implementing the same in production.
• Identifying the gaps with other applications and doing code changes as requested by them to get easy approvals for production implementation.
• Cleaning the tables and files in lower level environment once we deleted from production.
• Interaction with the clients and passing the requirements to offshore.

Languages: COBOL, JCL, Easytrieve, REXX, SQL server, BMC.

Tools: File-Aid, NDM, Endevor CA7, TSO/ISPF, JIRA, BMC Remedy Tool.

Confidential

Developer

Responsibilities:

• Requirement analysis by understanding the functionality in mainframe and creating requirements document.
• Created Design document with flow charts for converting into ETL in Pseudo format and shared with onsite.
• Converted the ETL pseudo flow into actual Datastage job flows, Job sequences, using Datasets, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign DataStage jobs for performing the required integration.
• Used DataStage Designer tools for creating Parallel jobs and importing and exporting the jobs.
• Created DataStage Jobs to build business rules to load data.
• Development of Unix shell scripts.
• Used DataStage Director to run and monitor status of the jobs.

Languages: JIL, UNIX Shell Scripting, SAS, Mainframe

Tools: Datastage 8.5, Autosys, SAS EG and SAS PC

Confidential

Developer

Responsibilities:

• Working on business and system impact analysis and provide optimal solution by having recursive meetings with the Bank architects
• Modifications, enhancements and bug fixes to the existing code and Review and validate the development process and suggest any performance improvements.
• Involved in implementation activities like package creation, getting required approvals, code migration and post install verification and approvals.
• Addressing post implementation production issues and resolving them within SLA
• Analyzing the existing code for the real time queries raised by the Line of Business and providing the required justification.
• Interaction with the clients and onsite coordinators
• Responsible for the Disaster recovery exercises and Business continuity plan testing.

Languages: COBOL, JCL, Easytrieve, Hogan CIS, CICS

Tools: File-Aid, NDM, ChangeMan, CA7, TSO/ISPF, Expediter, Abend-Aid