PROFESSIONAL EXPERIENCE:

• A qualified Graduate (in Information Technology) and a dynamic IT professional with almost 7 years of experience in IT Industry as a Datastage and Mainframe Sr. Developer.
• Almost 7 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.

TECHNICAL 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.

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Datastage and Mainframe Development Lead

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 therequirementsand preparing technicaldocumentation.
• 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.

Confidential, Buffalo, NY

Datastage and Mainframe System Analyst

Responsibilities:

• 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 in corporate 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.
• 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.

Confidential, Buffalo, NY

Mainframe Programmer Analyst

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.

Confidential

Mainframe Developer

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.