Description
Summary of Qualifications: * Highly motivated, self-driven, result-oriented, customer focused and capable of working in line with organizational objectives. * Excellent at problem solving - identifying and researching errors or data issue, performing root cause analysis and in developing robust solution framework. * Very strong hands on experience in COBOL, CICS, JCL. * Developed front end CICS Screens using BMS (maps). * Proficient in SQL, DB2, VSAM, QMF, SPUFI with day-to-day work involving hands-on on these skills * Extensively worked on Easytrieve to create new reports and enhancements to the existing reports. * Created new Production & Test JCL's, modified existing JCL's. * Effectively Used File Aid to create and manipulate flat files and VSAM files. * Very well versed and experience with using ENDEVOR, PANVALET, HP Service Manager, CHANGEMAN, Microsoft Share Point * Strong expertise with debugging tools including but not limited to XPEDITER, INTERTEST, ABENDAID * Involved in developing various SAS reports. * Well versed with ZEKE, CA7, CA11, SAR, HP Quality Center, HP Open View Service Center * Operating system expertise includes Z/OS, OS/390, MVS, UNIX, Windows NT/2000, Windows XP, Windows 7 * Good working knowledge of batch FTP processing and the use of CA-7 for job scheduling * Business Expertise in Banking and wealth management as well Travel & Hospitality * Expertise in Software Development Life Cycle (SDLC) Methodologies & Validations to ensure the Quality Assurance Control. * Implementation of ISO standards for documentation of Defect Logs, Test Plans, Activity Documents, Timesheet entries and Reviews. * Sound knowledge on different point of sales (POS) data. * Good exposure in implementing an application/product in international markets. * End to end DataStage 8.5 warehousing experience in the areas of ETL design and development. Involved in complete Software Development life-cycle (SDLC) of various projects, including requirement gathering, system designing, data modeling, application development, enhancement development, maintenance and support. * Extensively used DataStage Client components like DataStage Designer and Director, Administrator and Manager in Data Warehouse ETL development. * Strong understanding of the principles of DW using fact tables, dimension tables and Star and snowflake schema modeling. * Experience with Star and Snowflake Schema, Data Modeling, Fact and Dimensional Tables and Slowly Changing Dimensions. Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies. * Experienced in scheduling sequence, parallel and server jobs using Data Stage Director, UNIX scripts and CA7 scheduling tools. * Strong SQL and Oracle database knowledge. * Created Functional, Technical, and Mapping specifications and documentation. * Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter. * Extensively involved in the development of DataStage ETL process for extracting data from different data sources, data transformation and loading the data into Data Warehouse. * Expertise in using Microsoft SQL server management studio. * Experience in new enhancements in the IBM WebSphere DataStage - Multiple Job Compile, Surrogate key generator Stage, Job Report, Message handler options. * Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Accomplishments
Highlights:
Job Skills
Keywords
