PROFESSIONAL SUMMARY:

• 5 Years of Confidential Information server tools and 4 year of ZOS Mainframe application design/development expertise associated with Confidential relationship from the year of 2007
• Very good hands - on experience on IBM IIS tools as listed below
• Confidential Datastage 8.5 / 9.1
• Confidential Information Analyzer
• Confidential Confidential
• Confidential Metadata workbench
• Confidential Quality Stage
• Confidential Administrator
• Confidential Operations Console, Data quality console
• Experience in Version Control / Migration tools as listed below
• Clearcase
• Subversion (SVN)
• Experience in scheduling Data Jobs / Unix scripts using scheduling tool - Autosys
• Expertise in creating reusable Datastage components for quality analysis, Validation and Extract process using Containers and common routines
• Experience in Unix Shell Scripting
• Strong DataStage implementation skill to complete implementation even within tight project schedule.
• Proven track record in troubleshooting of DataStage jobs and addressing production issues like performance tuning, bug fixes and enhancements
• Hands-on experience with proof of concepts on data lineage, Java module integration & Discovery studio
• Extensive experience in creating deployment plan, roll back plan and post deployment plan
• Experience in using and writing query in Oracle and DB2 database stages
• Experience on developing programs using technologies such as COBOL/DB2/JCL/EAZYTRIEVES in mainframes platform
• Working experience in interacting with IBM Specialist to resolves platform and development issues.
• Quick learner with excellent analytical and problem solving skills.

TECHNICAL SKILL SET:

ETL Tool: Datastage V8.5 & V9.1, Information Analyzer

RDBMS(Database): DB2, Oracle

Operation System: Unix, Linux, Windows, OS 390, Z/OS

Scripting: Unix Shell Scripting & Microsoft Excel scripting

Scheduling Tool: Autosys 4.5 / 11 & CA7

Other Tool: Tectia Terminal, Toad for DataAnalyst & Oracle,FILE-AID, FILD, QMF, BMC, PLAT, TSO / ISPF, CHANGEMANDB2I, DFSORT, ND, PDSM, QC & TBSM

PROFESSIONAL EXPERIENCE

Confidential

Lead Developer & Team Lead

Responsibility:

• Analyze the RRS DB2 Tables and build the Information Analyzer module to run the various data analysis
• Build the Datastage job module to invoke the rules using “Data Rule” stage for Quality analysis and scheduling for periodic analysis reports
• Publish the Column analysis, Key analysis along with Various Quality rules results using Operational Web console
• Conduct Design and Operational review with Client, Supplier and Architect team
• Perform Functionality and Performance testing and publish the results with details fix and analysis

Environment: IBM Information Analyzer V9.1.2, Datastage Designer V9.1, Operational console

Confidential

Lead Developer & Team Lead

Responsibility:

• Processing Input files from various Sources (Platform) & Performing Inbound Validation, Quality Check using reusable module, Extract process to build and transmit the processed files to W
• Extract data from Sequential file & CFF files and perform the transformation
• Build the supplier required extract file and transmit to both Mainframe and Unix platforms
• Perform the Quality check using Shared container to evaluate ECBD Standards
• Extensively used different stages both on Job Sequence and Parallel jobs like - Transformer, CFF, Sequential file, Sor, Aggregator, Filter, Funnel, Copy, DB2, External filter, Change Capture, Look up, Merge, Join, Job activity, Email notification, Sequencer, Routine activity and Exec command
• Handled the Huge volume of data from Mainframe source and transmitted after the process completed at DHUB end
• Implemented more than 6K+ Scheduled jobs with over 100 re-useable Datastage modules
• Built the New wrapper scripts and Archival scripts using Unix to invoke the Datastage module and storage management
• Conducted KT on Production support team and gave the Zero defect code delivery as a “Onsite team Lead”

Environment: Confidential Suite 9.1, Unix, Autosys & SVN

Confidential

Senior Developer

Responsibility:

• Processing different input files from various sources & performing few checks & loading them into an Oracle database using ETL tool DATASTAGE 8.5
• Extracting data from DB2, applying transformation & finally loading into Oracle
• Extensively used different stages like Source Oracle database connector, Copy, DB2, Filter, Join, Dataset, Sequential File, Transformer
• Build the View / MView on top of Oracle DB for various interface services
• Developed Datastage process for Recon functionality
• As part of this effort, more than 100 process built to consume and process the inputs from various files and 50 process built to deliver the expected feed to downstream other than updating Confidential Database
• Involved on Business Glossary, Metadata repository and Data Lineage activities
• Interacted with IBM Team directly to resolve few Oracle connector issues due to load and internal datastage processing issues
• Working on the solutions and proposals with the prevailing trends in technology and solution fronts to meet client’s expectation

Environment: Confidential Suite 8.5, Metadata workbench, Business glossary, Unix, Autosys & Clearcase, DB2 & Oracle

Confidential

Lead Developer, Charlotte, NC

Responsibility:

• Design and Implement the Batch flow on ETL as a replacement for legacy Mainframe batch process
• Develop ETL process for complex business flow logic
• Develop the Initial load ETL Module to extract and load the legacy data from existing DB2 Tables
• Implemented more than 3K+ scheduled flows with 200+ reusable jobs
• Improved the performance more than 30% both on DB2 Batch process and DB2 Data refresh phase in addition with cost-savings
• Perform the functional and Performance testing for Initial load and Batch process
• Build NDM module on Mainframe to transmit the SOR file to Midrange servers
• Design New Recon process on Midrange to compare the new feed against existing feed
• Environment: Confidential Suite 8.5, Metadata workbench, Business glossary, Unix, Autosys & Clearcase, DB2, Mainframe Utilities and JCL.

Confidential

Mainframe Lead Developer

Responsibility:

• Design and Implement the Online profile conversion process for Northwest and California conversion projects
• Develop and deploy the new Bill pay, Service Charge & Third party for converted customers
• Worked on Batch Enhancement process for Combine statements, Company Number Expansion, Relationship pricing initiative
• Data seeding Initiative for Functionality and Performance testing environment
• Built the reusable COBOL module for Initial load process
• Performed Mainframe coding using COBOL/DB2, JCL and Eazytrieve.
• Involved in Performance Tuning and Enhancement.

Environment: Mainframe & DB2.