We provide IT Staff Augmentation Services!

Etl Developer And Project Lead Resume

Jacksonville, FL

Experience Summary

  • Over 9 Years of extensive experience in SDLC (Software Development Life Cycle) of Mainframe business applications.
  • Worked primarily in design, development and maintenance of complex multi-user online & batch business applications, developed in CICS, COBOL, DB2, SQL and Stored Procedures, Triggers, MQ Series, JCL, VSAM, IDMS, etc. on IBM mainframes for large-shop clients.
  • Worked extensively on systems related to Credit reporting and Health Insurance domain.
  • Have extensive knowledge in analysis, design, code build, testing, problem solving and data processing.
  • Excellent communication skills.
  • Excellent Problem Solving skills and ability to understand and analyze the Application System.
  • Worked closely with IT Managers/Business Analysts and major IT and Business stakeholders for smooth and seamless execution of the Projects.
  • Thorough ability to understand the Business Problems and translate them in Technical Requirements.
  • Worked in the capacity of team leader, onsite coordinator and team player.
  • Possess strong knowledge of Credit reporting domain.
  • Possess strong knowledge of healthcare terminology and working on healthcare projects.
  • ITIL v3 Foundation certified professional.

Technology

Software: zOS, Enterprise COBOL, VS COBOL/COBOL- II, CICS, MQ Series, DB2 Stored Procedures (COBOL) and SQL, TSO/ISPF, JCL, VSAM, SAS, EASYTRIEVE, SQL, XML, HTML, ETL(Informatica V09), C++

Databases: ZOS - IBM DB2, Oracle, IBM Data Studio

Operating System: IBM OS/390 MVS/ESA, MVS/XA, WIN NT/95/98, UNIX and DOS

Tools: FILEAID, FILEMANAGER, IBM Data Studio, IBM DB2 Platinum tools, XPEDITOR(online and batch), ENDEVOR, SAR, CA7/CA11, DB2,File Aid, Abend Aid, QMF, SPUFI, Sysview, REXX, iPMS, SFTP, Express Delivery, iQMS, MQmessenger, ChangeManager, SRT,OLTP

Professional Experience

Confidential

Jacksonville, FL

Role: Mainframe Developer

Environment: IBM-3290 & z/OS, Enterprise COBOL, DB2 v10.1, Stored Procedures (COBOL ), SQL, DB2 Triggers, CICS, MQ, Series, XML, TSO/ISPF, JCL, VSAM

Responsibilities :
  • Designed and developed highly efficient online and batch systems using the latest technologies like XML parsing, HTTP, MQ Series, complex SQLs, DB2 Stored Procedures to modularize highly complex CIP Server design into granular functionality levels to achieve optimum efficiency and ease in maintenance.
  • Extensively involved in Requirements analysis, Design, Code build, testing and implementation of the projects adhering to the Quality Assurance standards of Florida Blue.
  • Proficient in all phases of Software Development Life Cycle (SDLC)
  • Perform integration testing, system testing, performance testing and UA testing with IT business owners and end-users.
  • Involved in work effort sizing, setting up time-lines and scheduling of projects.
  • Performed code review, document process flows and built design documents
  • Coordinated with testing teams in test case reviews and defects fixing
  • Involved in production support
  • Fine tune CIP Server services, and performance tuning complicated SQL queries for best performance and optimum resource utilization.

Confidential

Alpharetta,GA

Role : ETL Developer and Project lead

Environment: IBM-3290 & z/OS, COBOL, DB2 v10.1, Stored Procedures (COBOL ), SQL, DB2 Triggers, CICS, ORACLE

Responsibilities :

  • Analyze the modules to identify the requirements for the migration
  • Converting the client’s Business requirements into technical requirements
  • Preparation of the Functional and Technical specifications, test scripts, UAT scripts for the project
  • To understand all the different fulfillment systems interacting with Equifax’s primary billing system CIS to minimize the risk
  • Design and develop the technical strategy to migrate the tables and data from mainframe to oracle
  • To analyze, design, develop, test and implement projects involving COBOL/DB2 programming handling millions of data with perfection
  • Extensive use of complex SQLs for data extractions and processing
  • Develop modules/process for Data extraction from mainframe
  • Design and Develop scripts for table definitions in oracle
  • Develop various transformations in Informatica for data loading in Oracle
  • Perform integration testing, system testing, performance testing and UA testing with IT business owners and end-users.
  • To ensure the data extracted and loaded is correct
  • To ensure that Equifax’s Deployment process is followed in every production install
  • To ensure that the endevor life cycle is properly completed before the production install
  • To ensure that the tools used in Equifax such as Managenow, Maximo, Inav and Identity Manage are efficiently used in life cycle of the project.
  • Prepare Maintenance Manual, Operations Manual, System Description Document and other technical and functional documents

Confidential

Alpharetta, GA

Role: MainframeDeveloper and Project lead

Environment : IBM-3290 & z/OS, COBOL, DB2 v10.1, Stored Procedures (COBOL ), SQL, DB2 Triggers, CICS, TSO/ISPF, JCL, VSAM

Responsibilities

  • Identification of revenue opportunities/revenue leakage in the system
  • Discussion with Business on the revenue opportunities and converting it to Business case(Project proposals) for Sales/Pricing stakeholders
  • Creation of Business requirement document, Technical design document
  • To understand all the different fulfillment systems interacting with Equifax’s primary billing system CIS for revenue recognition
  • Contractual analysis, Defect prevention and causal analysis activities
  • Performing data query, extraction, compilation, and reporting tasks
  • Manage, update and manipulate report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
  • Generate weekly, monthly, and quarterly reports necessary in maintaining a good and balanced revenue dashboards
  • Handle data collection, analysis, interpretation and presentation to management and other team members gathered via a wide range of available means and methods from users and business partners associated with Pricing, Sales and Revenue.
  • Research for new means of qualifying and obtaining data and methods of utilizing analytical tools effectively to be used for identification of revenue opportunities.
  • Statistical study for identified revenue opportunities.
  • To help Equifax to meet all the Audit Requirements and remain green in all Audits concerned with the billing system.
  • Unit, integration and system testing
  • Developing the software to fix the identified revenue leakages in the existing system
  • Using Xpeditor, Debug to verify the program logic in Mainframe and Window system respectively.
  • Prepare Maintenance Manual, Operations Manual, System Description Document and other technical and functional documents

Confidential

Alpharetta, GA

Role : MainframeDeveloper and Team lead

Environment : IBM-3290 & z/OS, COBOL, DB2 v10.1, Stored Procedures (COBOL ), SQL, DB2 Triggers, CICS, TSO/ISPF, JCL, VSAM

Responsibilities :

  • Analysing requirements and Functionality.
  • Converting the client’s Business requirements into technical requirements
  • To meet the SLA with the client
  • To analyze, design, develop, test and implement projects involving COBOL/DB2 programming handling millions of data with perfection
  • Extensive use of complex SQLs for data extractions and processing
  • To help Equifax to meet all the Audit Requirements and remain green in all Audits concerned with the billing system
  • To ensure that Equifax’s Deployment process is followed in every production install
  • To ensure that the endevor life cycle is properly completed before the production install
  • To ensure that the tools used in Equifax such as Managenow, Maximo, Inav and Identity Manage are efficiently used in life cycle of the project.
  • Using Xpeditor, Debug to verify the program logic in Mainframe and Window system respectively.
  • Prepare Maintenance Manual, Operations Manual, System Description Document and other technical and functional documents
  • Enhancement in mainframe applications
  • Maintenance of the existing system
  • Perform integration testing, system testing, performance testing and UA testing with IT business owners and end-users. Interacting with clients for requirement gathering
  • Defect prevention and causal analysis activities
  • To carry out Disaster Recovery Tests
  • To provide technical and production support and business solutions on daily basis

Confidential

Role : Mainframe Developer

Environment : IBM-3290 & z/OS, COBOL, DB2, SQL, TSO/ISPF, JCL, VSAM,MS VISIO

Responsibilities :

  • Leading the engagements for credit modeling implementation modules.
  • Analyzing requirements and Functionality.
  • Interacting with clients for requirements gathering.
  • Development and Testing, certifying the applications developed on install platforms, fixing the portability issues, Maintenance.
  • Using Debug on Solaris and windows systems and Xpeditoron Mainframe system to analyze the program logic.
  • Prepare Maintenance Manual, System Description Document and other technical and function documents.
  • Enhancement in mainframe applications.
  • Maintenance of the existing system.
  • Thorough System Testing
  • Unit, integration and system testing.
  • System and business knowledge build.
  • Converting the client’s Business requirements into technical requirements
  • To meet the SLA with the client
  • To help client to meet all the Audit Requirements and remain green in all Audits concerned with the models
  • To ensure that the defined Deployment process is followed in every production install
  • To ensure that the endevor life cycle is properly completed before the production install.
  • Defect prevention and causal analysis activities

Hire Now