Profile

I'm a senior level, Mainframe/SAS Analys certified in SAS with over 10

progressive years of experience delivering mission critical Mainframe & SAS

business applications for enterprise level clients. For the past five

years I have been working as a senior technical analyst within an on-shore

and offshore enterprise environment. As a Senior analyst/ Lead, I led the

development and maintenance efforts of Mainframe and SAS applications. I'm

experienced in conceptualizing software solutions at both the unit level

and at the system level. I demonstrate a thorough understanding of the

latest development techniques including development standards,

philosophies, tools and applications. My communication skills coupled with

my technical skills in both Mainframe and SAS systems will quickly provide

value to your organization.

professional Summary

. 10 Years of industry experience in Mainframe and SAS.

. 5 Years of experience in Team/Tech Lead capacity on the Onshore-

Offshore model.

. Extensive working knowledge in COBOL, JCL, VSAM, DB2, SAS

. 3 weeks of training in Core Method.

. 3 Months of Intensive training on CICS at Maples, Chennai with

reasonable working knowledge.

. Certified Insurance domain expert

. Certified Advanced SAS professional.

. Strong Analytical, Programming and Effective Communication Skills.

Skill set application

Technical knowledge and Data Application

. Maintained and developed SAS/COBOL programs in Mainframe and SAS

programs in Windows environments.

. Used SAS for designing front ends.

. Used SAS access / COBOL to access various databases.

. Used SAS to import from various file systems.

. Integrated SAS with Java and used remote sign on using SAS.

. Maintained and developed programs using SAS MDDBs.

. Done extensive reporting using SAS.

. Maintained and developed SAS programs involving DB2 and MS Access.

. Maintained and developed SAS programs interacting with Java, AIX,

Unix, Mainframe and Windows .

. Interfaced with Data Power and IMS Queues.

. Interfaced with MQ series

. Converted Eztrieve / DB2 programs to SAS/DB2.

. Handled VSAM file systems through SAS.

. Written Test JCLs for testing the complicated SAS job streams.

. Handled parameter passing to SAS programs through JCL.

. Used JCL and SAS for Data manipulations like concatenation and

organizing.

. Performed limited SAS admin activities including granting access and

revoking access and implementing PC SAS config files.

. Used JCL for job scheduling and monitoring.

. Maintained and developed DB2 stored procedures.

. Participated in production Implementation using Endevor.

. Worked with various schedulers Zeke, Endevor etc.

. Worked with various incident and change management tools such as

Assyst and Managenow.

. Worked on DB2 Performance Improvements .

. Experienced in fabricating test data in secure data environments.

. Used limited Data ware housing concepts.

. Written programs for Data cleansing and Manipulations using COBOL and

SAS.

General and Project Management

. Participated in full software life cycle tasks in every project.

. Participated in Effort estimation, Allocation and Tracking.

. Participated in Design Decision Making with tier 1 Managers.

. Participated in Requirement Gathering and drafted complete

requirements for other teams to work with.

. Drafted Functional designs and Detailed designs for new developments

. Been a system test co coordinator and point of contact for various co

ordination points such as Application/Data Power, Mainframe/Java,

Application/ IBUS etc.

. Performed Job monitoring

. Performed On call support

. Actively involved in root cause analysis.

. Used Agile and Water fall methodologies.

. Have a very good understanding of Core Method technology.

. Participated in PMR reviews, CMMI audits.

. Have experience working with teams involving multiple technologies and

co ordination points.

. Actively participated in user acceptance testing as a lead

coordinator of the application team.

. Extensive domain knowledge in Auto insurance

. Have in depth experience in State Medicare rules and auto insurance

policies.

. Have been a team/tech lead for complete Rewrite projects and new

developments.

. Led Offshore and Onsite teams and involved in offshore co ordination .

. Handled team size of 4 to 18.

. Done Resource Planning .

professional experience

Axiom Technologies May 2012 -

Till date

Client : State Farm Insurance

Tech Lead- Mainframe/SAS, Auto Insurance

Project : Consumer Reporting - Integrated customer Platform

The project involved a complete rewrite of the existing system. The

intention of the rewrite was to provide an integrated platform for

customers to shop State Farm's insurance products to improve customer

experience. The consumer reporting involves generation of various

reports from a third party vendor in order to determine the

performance of a driver which in turn played a crucial role in

determining the pricing of the policy and Quote. Consumer Reporting

was originally written in Mainframe was moved to Java based

environment as part of this project. This effort involved extensive

analysis of the existing system and coding. Testing of the same.

Technologies Used: TSO, ISPF, JCL, COBOL, SAS Macros, SAS Access, DB2, IMS,

VSAM, ENDEVOR, File Aid

Responsibilities:

. Requirement gathering and in depth analysis of existing system.

. Technical Leadership for Onsite TCS Team including task allocation and

tracking.

. Functional and Detail Designing of the new COBOL/DB2 programs

. Problem investigation and defect fixing of the existing system.

. Preparation of Functional test cases

. Code and testing reviews

. Quality Management within the Team

. Implementation and monitoring of New programs.

. Third Party Vendor Handling

. Project Planning

Achievements:

. Exceeded customer expectation by providing value adds through optimal

design tuning.

. Actively participated in the architectural decision making process

which helped in design efficiency.

. Provided out of the box solutions to complicated issues surfaced

during the project.

IBM India Pvt. Ltd Sep

2008 - May 2012

Client : HCSC-Formerly, Blue Cross Blue Shield

Senior System Engineer- Mainframe, Membership Eligibility Systems

Project: Reverse Eligibility - BlueStar

The project involves the adding and removing the eligibilities to and

of the healthcare accounts. Also involves determining /adding/removing

the eligibilities of Medicare accounts depending on the State Medicare

criteria. Releasing the confirmation of eligibility for Patients

waiting out there for their Medical insurance to be used.

Technologies Used: TSO, ISPF, JCL, COBOL, DB2, Stored procedure, VSAM,

BCBS custom tools,

IBM Debugger, Endevor, File Aid

Responsibilities:

. Eligibility requirement gathering for adding of new Eligibility to an

healthcare account

. Analysis of existing eligibilities and criteria which involves

extensive analysis of the existing accounts.

. Technical Leadership and Offshore Team Management including task

allocation and tracking. Team consisted of 4 Onsite resources and 8

offshore resources.

. Functional and Detail Designing of the new accounts

. Test Plan and Test case preparation

. Coding, testing and implementation of new codes

. Enhancements to the existing codes

. Code and Testing reviews

. Problem investigation and analysis for the existing accounts

. Daily job monitoring and On call Production support

Client: Nationwide Insurance

Senior Systems Engineer- SAS/Mainframe

Project: DE Output

The project involves addition of new features to the existing

Nationwide Insurance portal. Involved extraction and storing of data

from and to mainframe Databases through COBOL/JCL programs from the

front end which is a Java interface.

Technologies Used: TSO, ISPF, JCL, COBOL, SAS Access, SAS Macros, DB2,

VSAM, ENDEVOR, File Aid, IBM Debugger

Responsibilities:

. New Requirements analysis.

. Critical design decision making

. Functional and Detail designing for the same.

. Test Plan and test case preparation

. Coding and testing of the new programs and the changes to the existing

programs

. Quality and Work Product re-views.

. Problem investigation and analysis.

. Co ordination with Java and Testing team

. Offshore Team Management.( Team consisted for 5 members)

Client: Aviva Insurance

Senior Systems Engineer/ SAS Mainframe

Project: EDI Data warehouse

EPI is a huge DB2 based Data store . The project primarily involved

Maintenance and data warehousing of the EPI Database. Enhancements to

the Database and accessing programs. Data Cleansing and Reporting

depending on on-the fly requirements.

Technologies Used: TSO, ISPF, JCL, COBOL, DB2, SAS, Macros, SAS Connect,

SAS Access, MS Access, Changeman, File Aid, IBM Debugger, Assyst

Responsibilities:

. Enhancements to the existing Data store.

. Maintenance and enhancement of the existing programs

. Design, Coding and testing of the enhancements

. Conducting technical reviews and testing reviews.

. Perform Functional testing and regression testing.

. Task allocation for the team.

. Quality Management.

Achievements:

. Identified problems and Root causes by job monitoring and came up with

preventive maintenance measures which were greatly appreciated by the

clients.

. Refined the Risk tracking strategies and established the Risk-Root

cause relationship to reduce the defect rate by 50%.

. Led all 5 stages of testing (Unit, System, Integration, Regression and

user Acceptance)

. Actively involved in performance tuning of the data stores and

achieved 20% cost saving,

. Developed a dashboard tool which was widely appreciated and used at

the organizational level for project health checks.

. Improved customer satisfaction by resolving the long pending Medicare

Eligibility issues.

. Identified significant gaps in the Medicare eligibility systems and

provided enhancements to address them.

Infosys Technologies Apr

2008 - Aug 2008

Client: Victoria's secret Direct

Programmer Analyst

Project: VD - Conversion

Victoria's Direct was converting their entire system from EZtrive/DB2

to COBOL/DB2. The project primarily involved conversion of all the

EZtrieve programs to COBOL programs.

Technologies Used: TSO, ISPF, JCL, COBOL, DB2, File Aid, IBM Debugger,

EZtrieve

Responsibilities:

. In depth analysis of the existing EZtrieve programs

. COBOL/DB2 Designing for every group of EZtrieve programs.

. Coding and Testing of the Cobol/DB2 codes.

. Code and Testing reviews.

. Providing technical assistance to the team in terms of testing and

conversion.

. Onsite-Offshore coordination.

. Project health tracking.

IBM India Pvt Ltd

Jun 2005 - Apr 2008

Client: Fireman's Fund Insurance

SAS Technical

Project: Receivables Transfer Facility and PLP Rewrite

Project involves maintaining of 250 FFIC applications. RTF and PLP are

major and complicated application of the system and involved daily

maintenance, support, enhancements and development of RTF and PLP

entirely. Involved a complete rewrite of PLP application which was a

major development work.

Technologies Used: TSO, ISPF, JCL, COBOL, DB2, VSAM, ENDEVOR, File Aid, IBM

Debugger, SAS BASE, SAS MDDB, SAS Access, SAS/Macros, SAS CONNECT,

ManageNow, MS Focus

Responsibilities:

. Day to day Maintenance and Job monitoring .

. Extensive analysis, Design, Coding and testing of enhancements,

development of these applications.

. Providing Technical and Non-Technical Leadership to-wards all the 82

applications that fall under Management Information.

. Handling project risks, client service requests and change requests.

. Problem investigation and analysis.

. Production Support.

. SAS Mentoring

. Onsite-Offshore coordination.

. Quality Management.

Achievements:

. Led a team of 7 people to rewrite a complicated mainframe legacy

application and was given BRAVO award by IBM for efficient technical

leadership

. Went above and beyond client's expecting in providing multiple design

options

. Gained proficiency in SAS programming and admin abilities which were "

then new" technology for the company and served as a SAS mentor for

the team.

. Co ordinated and streamlined offshore Onsite collaboration through

effective communication.

. Led the team to achieve the 98.9 % defect free deliverable standard of

IBM.

. Represented the team in FIC, and ISO audits and was selected as one of

the cross project process reviewers for IBM internal audits.

. Represented the organization in CMMI level 5 appraisal.

. Led the project level Disaster Recovery rehearsals.

. Was a member of the Mainframe technical interview Panel.

Banyan Consultants

Sep 2004 - Jan 2005

Client: Deutsche Bank

Associate Consultant - Mainframe

Project: D&B portal enhancement

The project dealt with enhancing the existing Bank's portal to add a

Dun and Bradstreet score which can help Deutsche Bank to better

understand their stands in the market.

Technologies Used: TSO, ISPF, JCL, COBOL, DB2, ENDEVOR, File Aid

Responsibilities:

. Analysis of existing programs and requirement analysis of the score

calculation and derivation.

. Test Plans and test case preparation.

. Design,coding and testing of the same.

. Production Support.

Supreme & Co Electrical ENEL, Italy Jun

2002 - Jun 2003

Research Consultant

Project: Connector Testing

Involved performance testing of Insulation piercing connectors used in

Transmission lines. Load and parameter testing using MATLAB and C++

programs.

Technologies Used: MATLAB, C, C++

Responsibilities:

. Analysis of existing Test Requirements.

. Functional testing Document Preparation.

. Detailed Test Specification Preparation.

. Characteristics graphs Preparation.

. Testing the different net-work conditions with various switching

calculations.

. Performance Testing.

Education, certifications and professional achievements

June 1998 - May 2002

BE Electrical _University topper in Computer methods in Power System,

National Institute of Technology (Formerly REC ), Nagpur, Maharastra.

Percentage-78.3

. Domain Expert certification in Insurance Domain (INS21, INS22 and

INS23) on General Insurance from American Institute of Insurance.

. BASE SAS and Advanced SAS certification from SAS Institute

Certification

. Advanced SAS Certified professional from SAS Institute

. Domain Expert certified from American Institute of Insurance

Contact this candidate