LiveCareer
LiveCareer
  • Dashboard
  • Jobs
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Education
      • Administrative
      • Medical
      • Human Resources
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Nursing
      • Education
      • Medical
      • Human Resources
      • Customer Service
      • View All
    • Resume Services
    • Resume Formats
    • Resume Review
    • How to Write a Resume
    • CV Examples
    • CV Formats
    • CV Templates
    • Resume Objectives
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Education
      • Medical
      • Human Resources
      • Customer Service
      • Business Operations
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Jobs
    • Mobile App
    • Job Search
    • Job Apply Tool
    • Salary Calculator
    • Business Letters
    • Job Descriptions
  • Questions
  • Resources
  • About
  • Contact
  • 0Notifications
    • Notifications

      0 New
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • Sr. Datastage and Mainframe project Lead.
Please provide a type of job or location to search!
SEARCH

Sr. Datastage and Mainframe project Lead. Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
SR. DATASTAGE AND MAINFRAME PROJECT LEAD.
Professional Summary

A qualified Graduate (in Information Technology) and a dynamic IT professional with 8+ years of experience in IT Industry as a SR. Datastage and Mainframe Developer.


  • Over 8 years of Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Data Warehousing Systems and software programs using blend of IBM Data Stage 9.1,8.7,8.1,8.0.1(InfoSphere Information Server for data quality, Web Sphere) and Mainframes(COBOL, JCL, DB2 and VSAM) technologies.
  • Worked as Architect in configuring the new environments for ETL and Mainframe projects.
  • Works closely with customers, business analysts and team members to understand business requirements that drive the analysis and design of quality technical solutions.
  • Extensive experience in all phases of the Software Development Life Cycle, and responsible for designing, coding, testing, implementing, maintaining and supporting applications software.
  • Decision making towards the development of new code or reuse of existing code.
  • Participation in component and data architecture design, performance monitoring, product evaluation.
  • Shares relevant technical, business knowledge and expertise to team members.
  • Experienced in developing and testing Batch applications. Involved in test and production support activities as well.
  • Experienced in designing and developing test strategy, test plan, test cases and generating test reports, defect reports and product quality assurance documentation.
  • Similar experience of Application Support Services Delivery including Change Review, Impact Analysis, Change Management, Testing and Implementation as well as Incident/Problem management.
  • Proficient in Change Management involving Review of Change Requests (CR), Study & Impact Analysis of CR on present system, Finalization of enhancement, enhancement Design & Development, Testing and Implementation.
  • Strong Technical Knowledge on Both Datastage and Mainframe Technologies including Platform (OS), Languages, Databases and Tools with special expertise in Unix, Unix shell scripting, IBM InfoSphere Datastage and Quality stage V9.1, V8.5, V8.1 and IBM Web Sphere Datastage V8.0.1, and COBOL, JCL, DB2, PL/SQL,
  • Involved in debugging both Datastage and Mainframe Batch programs to resolve the issues.
  • Root Cause Analysys(RCA) done for Datastage and Mainframe Batch abends and suggested to the developers with the possible solutions.
  • Worked with utilities and software like TSO/ISPF, SPUFI, QMF, SQL, SYNCSORT, REXX, Quality Center, FTP, NDM, Control-M, Rational Concert(RTC), SQL Developer, Endeavor, IBM-File-Manager, IBM-Debugger, IBM-performance Analyzer, CA7.
  • Having good Experience in Technical Writing and Documentation includes Design documenting and System documenting.
  • Adept at Team Management & Leadership skill like tasking, delegation, monitoring, feedback, skill upgrade, competence management, career planning, motivation & mentoring of the team
  • Cohesive Team Player with Fast Learning Curve along with strong estimation skill, analytical, problem solving, innovation, planning, organizational, communication & interpersonal skills.
  • Able to work under pressure, use own initiative and motivation to meet deadlines and set priorities without close supervision.
  • Pro- active, flexible, enthusiastic, and results driven.
  • Having good experience on MS Office products like Word, Excel, and Outlook
Education
Bachelors of Technology : Information TechnologyJNT UniversityINDIAInformation Technology
Skills
  • ETL : IBM Infosphere DataStage V9.1 & V8.5, IBM Infosphere DataStage 8.1 (Parallel & Server), IBM Websphere DataStage 8.0.1 (Designer, Director, Administrator)
  • Mainframes: COBOL, JCL, REXX
  • Databases: Oracle 10g/9i/8i, IBM DB2/UDB, RDB and VSAM.
  • Operating Systems: Windows 7x/NT/XP, UNIX, LINUX, Solaris, MS-DOS,MS Access, MVS, OS/390, Z/OS and Windows.
  • Languages: C, C++, Java, PL/SQL, Unix Shell scripts and SQL.

  • Defect tracking: Quality Center(QC)
  • Schedulers: Control-M and CA7.
  • Tools: Toad,QMF, SPUFI, Rational Concert(RTC), SQL Developer, Endeavor, IBM-File-Manager, IBM-Debugger, IBM-performance Analyzer.
  • Learning's: Hadoop MapReduce, Hive
Experience
Sr. Datastage and Mainframe project Lead.
August 2014 to March 2016
HSBC Technology and Services - Buffalo, NY.

GreenField: 

  • HSBC USA initiated a biggest transformation program called "Greenfield" and its mission is to bring the full capability of the HSBC group to the US bank.
  • In practice, That means switching off the old legacy systems and streamline the processes to align with group standards and replace local enhancement with group systems.
  • In CDW, This Project have been designed to build on Datastage and mainframes technologies to accomplish the business requirements and develop enterprise data warehouse.
  • Responsibilities: Involved as primary on-site ETL and Mainframe Development lead during the analysis, planning, design and development stages of projects using IBM Datastage (Datastage and Quality Stage v9.1) and Mainframe.
  • Gather and analyze the requirements and preparing technical documentation.
  • Preparing impact analysis document before changing the existing programs.
  • Preparation of High level and Detail Design documentation based on Business requirement.
  • Provides application software development services or technical support.
  • Develops program logic for new applications and analyzes and modifies logic in existing applications.
  • Design Data integration/ETL jobs using Datastage and its foundation tools.
  • Used DataStage as an ETL tool to extract data from sources systems, loaded the data into staging database ORACLE.
  • Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
  • Participated in weekly status meetings.
  • Analyze, Design, Optimize and implement Oracle PL/SQL stored procedures Program development using COBOL, JCL, VSAM and DB2 in Mainframe environment.
  • Created Jcls to run Cobol-DB2 programs and Scheduled the jobs using CA7 scheduling tool in production environment.
  • Generated the reports and sent them to Ondemand for user verification Preparing Unit test cases and test results as per the new code.
  • Comparing the test results for before changes and after changes.
  • Involving in code review, Unit testing, capturing test results and documentation.
  • Involving in System Testing (SIT) and User acceptance Testing (UAT) and provided solutions to issues raised in testing.
  • Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
  • Creation of Job sequences.
  • Maintained Data Warehouse by loading dimensions and facts as part of project.
  • Also worked for different enhancements in FACT tables.
  • Created shell script to run data stage jobs from UNIX and then schedule this script to run datastage jobs through Control M scheduling tool.
  • Coordinate with team members and administer all onsite and offshore work packages.
  • Analyze performance and monitor work with capacity planning.
  • Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.

Environment: 

  • Staging : Datastage v9.1, Oracle 10g, Linux, Unix scripting, RTC for version control, Control-M v7.0 for DS jobs scheduling.
  • Reporting : COBOL, DB2, JCL, Endevor, IBM-File manager, IBM-Debug tool, SQL, SPUFI, QMF, IDCAMS, NDM, SYNCSORT and CA7.
Datastage and Mainframe System Analyst
April 2012 to June 2014
HSBC Technology and Services - Buffalo, NY

Dodd Frank 14Q:

  • The Federal Reserve is collecting information for purposes of Capital Assessments and Stress Testing information, various data which is stored within our source systems: CDW, FTP, MCC, and CARM are known as FR Y-14Qs (Quarterly's).
  • CDW (Credit Data Warehouse) will implement a systematic process to create the quarterly FRY 14Q Commercial Real Estate and Corporate Loan Data Collection schedules.
  • To accomplish this, additional fields from various data sources will be sent to and stored in CDW.
  • Dodd Frank 14Q wall street reform is a consumer protection act which was signed in response is to late 2000 recession to bring more stability in financial systems.
  • The Federal Reserve is collecting information for purposes of Capital Assessments and Stress Testing information, various data which is stored within source systems: CDW, FTP, MCC, and CARM are known as FR Y-14Qs (Quarterly's).

Responsibilities:  

  • Involved in analysis, planning, design, development, and implementation phases of projects using Infosphere datastage and Quality Stage v9.1 and Mainframes.
  • ETL Process: Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables.
  • Developed complex ETL jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Complex Flat File(CFF), Datasets, Sequential File, Aggregator and Modify Stages.
  • Created queries to compare data between two databases to make sure data is matched.
  • Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
  • Created shared container to incorporate complex business logic in job.
  • Scheduling and monitoring the ETL jobs using Control M in UAT and production environments.
  • Created and modified batch scripts to Connect Direct(CDT) the files from ETL server to mainframe server.
  • Created Job Sequencers to automate the job.
  • Created new and modified existing UNIX shell scripts to run Datastage jobs and necessary scripts for datastage project.
  • Created parameter set to assign a value to job at run time.
  • Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources.
  • Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.
  • Providing the logical data model design, generating database, resolving technical issues, and loading data into multiple instances.
  • Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
  • Mainframe Process : Developed JCL to perform first pass logic that validates the source system files to makes sure that input files are complete and valid.
  • Developing the COBOL-DB2 programs to load input files from ETL and other loan systems.
  • Prepared the jobs using JCL to run COBOL-DB2 programs and Scheduled them in production using CA7.
  • Generate quarterly reports using Commercial Real Estate and Corporate Loan Data and sends them Federal Government.

Environment:

  • Staging: Datastage v8.1, Oracle 10g, Unix scripting, RTC for version control, Control M for DS jobs scheduling.
  • Mainframes: COBOL, JCL, DB2, SPUFI, IBM-File Manager, IBM-Debug tool, Endevor for version control, CA7 for mainframe jobs scheduling.
Mainframe Programmer Analyst
June 2011 to August 2013
HSBC Technology and Services - Buffalo, NY

Corep(Common Reporting):

  • The European Banking Authority (EBA) is mandated the adoption of the revised Common Reporting (COREP) framework across all European entities beginning December 31, 2011.
  • HSBC was required to report group results on this basis starting with the quarter ending 31st December 2011.
  • The key impacts of COREP are that it requires additional granularity in reporting, additional reports, and the requirement that summary results be supported by granular underlying detail.
  • Responsibilities: Analyzes requirements, and translates business requirements into product designs.
  • Documented technical specifications and functional specifications.
  • Designing the work flow or job flow for the new requirements.
  • Coding, Unit testing and production implementation of Datastage and mainframe batch jobs.
  • Carrying out Impact analysis and research on the affected system In charge of having the cycle completed within the specified SLA.
  • Ensure the problem get fixed and enhanced of the system based on the business needs.
  • Have good experience using DOS commands in file transfer and interacting to other systems.
  • Good coordination with onsite and offshore team members.
  • Involved in data conversion that includes extracting full data from system.
  • Batch Cycle monitoring and supporting Production Batch.
  • Creating and delivering the adhoc reports based on user requirements.

Environment:

  • Staging: Datastage v8.1, Oracle 10g, Unix scripting, RTC for version control, Control M for DS jobs scheduling.
  • Mainframes: COBOL, JCL, DB2, SPUFI, IBM-File Manager, IBM-Debug tool, Endevor for version control, CA7 for mainframe jobs scheduling.
Mainframe Developer
March 2008 to June 2011
HSBC Software Development Pvt Ltd, INDIA

Credit Data Warehouse(CDW):

  • Credit Data Mart design is intended to store data to meet reporting requirements for Assessing Capital Adequacy in Relation to Risk.
  • It will satisfy requirements set forth by the USA Federal Reserve letter SR 99-18, by the New Basel Capital Accord for both the Standard and IRB approach, as well as internal area, entity and group reporting.
  • The Data Mart will store Credit data for Commercial products at a detailed level, Retail products at a "rolled up" portfolio level, as well as Treasury and Factoring Credit data.
  • Credit Data Warehouse (CDW) is one of the project having complex Risk Weighted Asset (RWA) calculations that aid business in calculating Wholesale credit risk.
  • As a part of risk calculations HSBC uses internally formulated RWA calculation logic that is specifically designed for risk calculations in HSBC US Bank.
  • Credit Data Warehouse (CDW) stores the information about Commercial Credit Customers, their Facilities, Credit Instruments and Collateral.
  • This data is feed for many regulatory projects including Common reporting (COREP), Dodd Frank(The Dodd Frank Wall street Reform and Consumer protection Act is a regulatory act that was signed in response to the late 2000 recession to bring more financial stability).
  • Responsibilities: Coordinating to Test Support Activities and involving in 24/7 Production Support.
  • Preparing Batch scripts and running Batch jobs intended for different Test scenarios.
  • Resolving different type of issues interrelated to test support and production support.
  • Refreshment of data in test regions with production data.
  • Day-To-Day operational activities support in a Test Environment.
  • Setting up the test environment for major enhancements.
  • That includes refreshing /loading test environment with production data.
  • Involved in resolving the issues related data loading, running Runstats and Reorgs against data in test environment.
  • Make sure all DB2 tables, VSAM files and all other required files available for testing.
  • Responsible for providing support and maintenance of the Application in and Test Environments.
  • Preparing jobs in Test environment and running in CA7 scheduler as per the production script.
  • Coordinating with development team to make sure all test results verified and passed in the test environment.
  • Familiar with all IBM utilities File Manager, Debug, Performance analyzer, Endevor, QMF and SPUFI).
  • Working on enhancements to fix the production problems.
  • Understanding the new requirements.
  • Analyzing the impact of the existing system for the new requirement.
  • Coding, Unit testing and production implementation of the project in Mainframe environment.

Environment:  

  • COBOL, JCL, VSAM, DB2, SAS, REXX, and CA7.
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • HSBC Technology and Services
  • HSBC Software Development Pvt Ltd, INDIA

School Attended

  • JNT University

Job Titles Held:

  • Sr. Datastage and Mainframe project Lead.
  • Datastage and Mainframe System Analyst
  • Mainframe Programmer Analyst
  • Mainframe Developer

Degrees

  • Bachelors of Technology : Information Technology

Create a job alert for [job role title] at [location].

×

Advertisement

About
  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
Help & Support
  • Work Here
  • Contact Us
  • FAQs
Languages
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
Customer Service
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2021, Bold Limited. All rights reserved.