SEARCH

Sr. Consultant Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
SR. CONSULTANT
Career Overview
Over 7 years of Software Development Lifecycle (SDLC) experience in Application Software Design, Development, Documentation, Maintenance, Debugging, Business analysis, system analysis, requirement gathering and project team management. Has extensive domain knowledge in Commercial Banking, retail and health care. Expertise in development, testing & customization of Mainframe business applications. Experience in testing on enterprise wide applications with databases like DB2, IDMS. Experienced in onsite/offshore model, team lead activities. Worked in JCL, VS-COBOL, VSAM, DB2, IDMS, CICS, API interfaces to Mainframes using . Java scripts and Net, NDM, CA-7, Zeke and MQ series. Experienced in Analysis, Design, Coding, Testing and on call 24/7 Support. Experienced in all the phases of the Software Development Life Cycle (SDLC). Created design data sets for database modifications according to SDLC processes. Developed and documented system designs and program/job flowcharts. Designed programming specifications and supported system enhancement activities. Maintaining Traceability Matrix and Status report related to project. Highly proficient in working with users to gather requirements, analyze them and subsequently use the Microsoft Visio and design tools to model the requirements. Excellent skills in gathering requirements and creating Functional Requirements Document (FRD), participating Joint Application Development (JAD) sessions, Disaster Recovery Plan (DRP), developing Test Approach, User Acceptance Testing (UAT). Experience in test management and defect tracking tools like Quality Center. Expert in Using Quality Center as repository for maintaining test cases, execution and tracking the defects. Ability to work well in a team environment and work towards completion of targets and deliverables. Self-motivated and quick learner of new concepts and technologies. I Possess excellent client-interaction skills and have experience communicating at all levels within an organization.
Qualifications
  • Operating System:
  • OS/390, z/OS, Windows XP, Windows 7, Unix/AIX.
  • Languages:
  • COBOL, JCL, Easytrieve, HTML, XML, Shell script, SQL, Java scripts
  • Database:
  • DB2, IDMS, SQL Server.
  • Tools/Utilities/Others:
  • SAS, Java, File-Aid, File-Manager, Expeditor, IBM Debugger, STROBE, APA, Spufi, SQLEASE, DB2 Admin, OLQ, Endevor, STROBE, Panvalet, Abend-Aid, Fault Analyzer, Eclipse, Web services, MS Office, HP Quality Center, HP service manager, Dataquant, IBM Rational developer, Rational Suite (Rose, Requisite Pro, ClearCase, ClearQuest).
Accomplishments

Appreciated for leading the technical team and successfully implementing CGI phase 1 project with zero defects by handling from the development phase till implementation including Unit test, SIT (including 800 jobs), UAT (more than 900 jobs and including all the business partners and customers), implementation and post-implementation tasks.


Appreciated for developing code for one-time conversion of existing VSAM data to DB2 table data from the Lease and Retail customers to CACS system.


Appreciated for the primary analysis report submitted for the migration of IDMS data to DB2 on WLI application. The initial report included the primary outlook for the restructure of hierarchical database to the relational database in sync with the CDW database and other systems interacting with WLI system. It also included the analysis of system and its sub systems, the important programs and tables which affect the major functionality and stores the critical data.

Appreciated for the successful migration of Mainframe server in US, coordinated with all the systems linked to CDW, gathered their server details, file details, physical location details of the teams for their support in Migration.


Did an independent impact analysis for a project spanning around 20 DB2 tables, 20 Online Maps, 96 Batch programs.


Received Spot award for successfully completing BRRS task having complete SYNCSORT utilities which was new to me.


Did performance improvements for 2 long running jobs by changing Cobol DB2 programs and thus reducing the Maintenance costs by 60% for those jobs to the Client.


Appreciated for the production Support done for a week continuously to avoid the severe impact of Data Centre down on CDW jobs. Responded as soon as the back-up Data Centre was up and made the system stable within a week.

Work Experience
Sr. Consultant07/2011 to CurrentCompany NameState
  • Application Development Project: JM Family - Wofco JM Family is one of the largest, most innovative and diversified companies in the automotive industry.
  • Its principal businesses focus on vehicle distribution and processing, finance and insurance, retail vehicle sales, and dealer technology services.
  • The Collections, Recovery and Recovery Accounting systems are replaced with the new/updated CGI systems due to the inherent business risks.
  • The changes provide a sustainable long-term maintenance and support solutions for these applications.
  • This is a three phased project; first phase is to upgrade the Collections Decisions and Collections system followed by the Lease accounts Recovery Collections system and Repo-Charge Off accounting (Recovery Accounting system).
  • The third phase to replace the Recovery Collections system and Repo-Charge Off accounting for the Retail accounts is currently in progress.
  • Responsibilities: Participate in the requirement gathering sessions and give the technical input for the desired changes.
  • Responsible for creating the High Level and Low Level Design Documents based on the requirements provided.
  • Estimation for the project, projection of the resources required to complete the task within the time frame given.
  • Co-ordination of efforts in completing the tasks which include the complete project life cycle like design, estimation, coding, unit testing, SIT, UAT and Implementation.
  • End-end responsibility to deliver the project as the technical lead for the project.
  • Perform Unit testing and supporting system testing issues.
  • Interact with the business analysts, customers to resolve pending queries and status update.
  • Analysis, Coding, Unit Testing of Changes as per the high level and low level design documents created.
  • Construct programs based on program specifications, as per applicable language standards.
  • Maintain Java scripts to the CICS interface programs.
  • Use HPQC to create the test cases and test plans for the projects and log the defects occurring in the SIT, UAT test phases and track them using the traceability matrix to closure as per the severity of the defects.
  • Achievements: Appreciated for leading the technical team and successfully implementing CGI phase 1 project with zero defects by handling from the development phase till implementation including Unit test, SIT (including 800 jobs), UAT (more than 900 jobs and including all the business partners and customers), implementation and post-implementation tasks.
  • Appreciated for developing code for one-time conversion of existing VSAM data to DB2 table data from the Lease and Retail customers to CACS system.
Sr. Software Engineer06/2008 to 07/2011Company NameCity
  • Project: Credit Dataware house and Wholesale Liability Information CDW system is a Data Ware house of Commercial Credit Risk data.
  • This system interacts with 56 sub systems of the Credit Risk Unit.
  • CDW keeps the latest information posted into data mart so that at any point of time we can get the updated information from data mart.
  • This system helps to generate reports on credit risk associated to commercial institutional banking.
  • The Tables in the CDW/R is DB2 Credit Data Mart (CDM) primarily created for BASEL II compliance requirements and used to represent the information extracted from various systems.
  • Provide feeds to different systems and creating reports for compliance and decision-making.
  • CDW team supports an IDMS Database WLI (Wholesale Liability Index) having the Customer and Liability Information for its maintenance tasks whenever applicable.
  • WLI sends this information to the CDW Data Ware house.
  • It has a Development Team of 12 Associates, comprising 1 at On Site, and 11 at Offshore in India, Hyderabad.
  • Responsibilities: Participate in therequirement gathering and analysis discussions and understand the requirements of the client and act as a functional resource to convert the requirements into high level documents.
  • Analyzed the IDMS and DB2 tables to form a relational schema and normalize the database structure to create future usable relational tables with correct identification of primary key, foreign key, create views for the required reports of Credit risk business.
  • Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality, UAT strategies, expected output etc.
  • Analysis, Coding, Unit Testing of Change request/enhancement received from the Client.
  • Construct programs based on program specifications, as per applicable language standards.
  • Design, implement and test fixes (for bug reports) and changes (for Change Requests) to programs.
  • Maintain the minor enhancements in the java scripts on R2 framework specific to HSBC standards and pass the data from Java to Mainframe using XML/MQ Series/CICS.
  • Doing oncall support for CDW and WLI.
  • Supporting weekend Mainframe Migration activities.
  • Performing Reviews at various stages of the SDLC task.
  • Create and execute unit test plans.
  • Handled Quality processes SCM, Defect Prevention Champion and Quality Analyst for this project.
  • Achievements: Appreciated for the primary analysis report submitted for the migration of IDMS data to DB2 on WLI application.
  • The initial report included the primary outlook for the restructure of hierarchical database to the relational database in sync with the CDW database and other systems interacting with WLI system.
  • It also included the analysis of system and its sub systems, the important programs and tables which affect the major functionality and stores the critical data.
  • Appreciated for the successful migration of Mainframe server in US, coordinated with all the systems linked to CDW, gathered their server details, file details, physical location details of the teams for their support in Migration.
  • Did an independent impact analysis for a project spanning around 20 DB2 tables, 20 Online Maps, 96 Batch programs.
  • Received Spot award for successfully completing BRRS task having complete SYNCSORT utilities which was new to me.
  • Did performance improvements for 2 long running jobs by changing Cobol DB2 programs and thus reducing the Maintenance costs by 60% for those jobs to the Client.
  • Appreciated for the production Support done for a week continuously to avoid the severe impact of Data Centre down on CDW jobs.
  • Responded as soon as the back-up Data Centre was up and made the system stable within a week.
Analyst Programmer12/2005 to 02/2007Company NameCity
  • CI Medicare 2007 The Medicare Prescription Drug, Improvement, and Modernization Act of 2003 went into effect January 1, 2006.
  • The changes extend new benefits and options to everyone who has Medicare coverage, including prescription drug benefits.
  • This prescription drug benefit is known as "Medicare Part D." Medicare Advantage plans feature prescription drug benefits, fixed costs, limits on out-of-pocket expenses, and worldwide coverage for emergency and urgent care.
  • The work here involved modifying the existing programs to support the changes and developing new programs as demanded by C.I Medicare.
  • Responsibilities: Executing Work requests, which involve requirements analysis, coding, testing, implementation and documentation.
  • Develop and test the API interface online programs interfaced with .Net.
  • Ensure the CI Medicare application changes are according to the client specified standards.
  • Interacted with on site coordinator to gather the requirements and prepare technical documents.
  • Prepared test data for positive and negative test scenarios as per application specifications and application requirements and wrote test plans.
  • Create/Enhance the COBOL - DB2 programs, JCL's and Procedures to add new business functionality to the system as per the Technical Design.
  • Developed CICS screens and COBOL programs to invoke by transactions.
  • Developed COBOL programs to read data from IMS DB and DB2 databases to process and generate reports.
  • Used CA7 scheduler to monitor current running jobs, Long term plan jobs.
  • Involved in the unit testing, regression testing and documentation.
  • Create consolidated documents of program and job changes.
  • Responsible for defect tracking and reporting.
  • Participated in the bug review meetings.
  • Achievements: Automated manual TRR process using Catalogued PROCs, JCL and new COBOL programs required for Medicare reporting.
  • Reduced the processing of a job by 90% using split command in SORT JCL for a large file, running jobs in parallel and join the final output into one file which was very much appreciated by the Client and the Senior Management.
Education and Training
B.E: Civil Engineeringin University College of Engineering - Osmania UniversityCity, State, India
Skills

.Net, Abend-Aid, Accounting, Accounting systems, AIX, Analyst, API, Application Development, automotive, back-up, banking, benefits, C, CA7, CGI, CICS, clarify, ClearCase, COBOL, conversion, Credit, Credit Risk, Client, databases, Database, decision-making, documentation, Easytrieve, Eclipse, Endevor, Senior Management, File-Aid, finance, focus, frame, functional, HP, HTML, IBM, DB2, IDMS, IMS DB, insurance, Java, Java scripts, JCL, Languages, Mainframe, meetings, MS Office, outlook, Windows 7, Windows XP, Migration, MQ Series, OS, Operating System, developer, OS/390, Panvalet, processes, Coding, progress, Quality, read, relational database, reporting, requirement, requirements analysis, Retail, R is, sales, SAS, SDLC, Shell script, Spufi, SQL Server, SQL, SYNCSORT, Tables, Unix, upgrade, Utilities, VSAM, XML

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

School Attended

  • in University College of Engineering - Osmania University

Job Titles Held:

  • Sr. Consultant
  • Sr. Software Engineer
  • Analyst Programmer

Degrees

  • B.E : Civil Engineering

Similar Resumes

View All
Sr.-Consultant-resume-sample

Sr. Consultant

Dallas, North Carolina