Sashi Rekha Kasiviswanathan Phone No: +1-303-***-****
Team Lead- Systems Analyst Email :
abg4p9@r.postjobfree.com
SUMMARY
. Close to 7 years of IT experience as Lead Business and System
architect, Testing Analyst and Application Development for various
domains like Healthcare(3 yrs HIPAA trained -Blue Cross Blue Shield of
Illinois), Banking and Leasing.
. Experience and thorough understanding in complete SDLC for
modernization, renewal, development, maintenance and performance
tuning & functional testing projects.
. Experience includes wide areas of abilities ranging from analysis,
design, development, testing, release, scheduling, onshore-offshore
coordination roles, metrics reporting, tech lead and project
estimations & planning.
. Experienced in interacting with multiple clients/ customers in
requirements collection, Test planning, business presentations,
implementing functional and technical skills in business analysis and
system design.
. Strong presentation skills and the ability to communicate at different
levels within the organization with exceptional problem-solving and
analytical skills and excellent attention to detail.
. Certified Accenture-Mainframe Developer and IBM-DB2Ver9 and Sun Java
Certified
EDUCATION:
DEGREE CGPA/ INSTITUTION YEAR
PERCENTAGE
Bachelor of 81.5% Amrita Vishwa Vidhya Peetham 2004
Engineering - Bharathiar University
(B.E)
SKILLS
Languages COBOL II, COBOL I, Micro focus - COBOL,
JCL, JAVA(trained and certified),
Assembler, XML
Database IBM-DB2, IMS DB, SQL, Oracle SQL
File management VSAM
OLTP CICS, MANTIS
Reporting Earl, Eztrieve
Debugging tools CA-Intertest, Expediter, SPUFI, QMF
Configuration Management ChangeMan, Endevor
and Versioning tools
OS MVS, TPS /3270, Windows, MS-Dos
Bug tracking tools Test director
Other Tools Microsoft Office (Word, Excel, PowerPoint,
Access, and Visio) DB2 V8 query optimizer,
Oracle SQL Developer.
XML understanding, Telnet, Teleview, TPX
Emulators, MS outlook, TSO/ISPF,MQ
understanding, IBM utilities- Syncsort
CERTIFICATIONS
Professional Society Member Since
IBM-DB2 Version 9 Certified Database Associate 6/2008
Accenture Mainframe Certification COBOL/JCL/VSAM 11/2007
Sun Certified Java Professional - SCJP 11/2004
PROFESSIONAL EXPERIENCE:
1 Employer 2: Accenture (Feb 2007 - Till
Date)
Client : BCBS(Blue cross Blue shield) Illinois
(HCSC) USA
Project 6 : ICD-10 Business/Impact Analysis
Project Duration : Sep 2010 - Present
Client: Health Care Service Corporation (HCSC) is a non-investor-owned
mutual insurance company that operates through its Blue Cross and Blue
Shield divisions in Illinois, New Mexico, Oklahoma, and Texas, and several
subsidiaries to offer a variety of health and life insurance products and
related services to employers and individuals. It is an Independent
Licensee of the Blue Cross and Blue Shield Association.
HCSC products include PPO, HMO, POS, traditional indemnity and Medicare
Supplemental health plans. They also offer products through some employer-
sponsored health plans i.e., vision, dental, managed mental health and
prescription drug coverage. In addition, through subsidiaries they offer
life insurance products and an array of fixed annuities.
As a Lead Techno Functional Analyst, I have managed 6 member offshore team
as with the below activities and Ability to prioritize, organize, and
accomplish multiple tasks, both as part of a team and independently and
Ability to manage time while working on multiple projects.
ICD-10 - Currently the industry uses ICD-9(International Classification of
Diseases Version 9) diagnosis and procedure codes. All claims with
discharge dates on or after October 1, 2013 must use ICD-10 codes. Code
impact analysis and remediation has to be performed for implementing the
new ICD Version 10 before October 2013 as mandated by WHO.
Modules: Blue Chip core adjudication, EOB, COB, Claim lock, Claims inquiry,
Super handler, notify, Eligibility, Blue Chip Enterprise Front End, Claim
processing Manager, E claims etc..,
Technologies: COBOL, CICS, DB2, JCL, VSAM, EZTRIVE, Assembler, Relativity
and SEEC tools,JAVA, SQL, ORACLE,Data ware house extracts, Pearl
scripts, Java scripts, VB scripts and HIPAA Trained
Responsibilities:
. Onshore Technical lead, Onshore-Offshore coordinator for a team size
of 6.
. Architecture and application assessments as a combined effort with
Client team.
. Process establishment for implementing ICD-10 codes for equivalent ICD-
9 codes in use.
. Defining SOW for ICD-10
. Impact analysis on various applications on different platforms of
ICD9/ ICD10 / procedure/ diagnosis/ DRG/ MORBIDITY and CPT codes.
. Usage of Relativity and SEEC and an in house developed tools to
identify impacts
. Categorizing impacts based on complexity and architecture and
producing roll up reports
. Extraction of business logic related to ICD-9 & ICD 10 codes
. Preparing remediation steps for implementation of 1CD-10 codes as
mandated by WHO.
. Code remediation, Testing and Implementation.
. Co-ordinate work on onshore offshore model.
. Client liaising with 40 different application teams to find impact
across all applications within the organization.
Client : BCBS(Blue cross Blue shield)
Illinois (HCSC) USA
Project 5 : BRM- Business rule mining
Project Duration : Sep 2008 - August 2010
BRM project aims to extract core business functionality from legacy
customer claims processing system with the help of defined process, tools,
technical and business analysis. System based candidate rules are obtained
and they serve as input for the future Re-engineering project.
As a Lead Systems Analyst Onshore/Offshore coordinator, I have managed 30
member offshore team and 4- 8 onshore team with the below activities.
Modules: Durable Medical Equipment/ Accums/ Claims lock/ Patient select/
Contacts and Benefits
Technologies: COBOL, CICS, DB2, JCL, VSAM, EZTRIVE, Assembler, Relativity
and SEEC tools HIPAA Trained
Responsibilities:
. Onshore Technical lead, Onshore-Offshore coordinator for a team size
of 30 at India & Business rule mining techno-functional analysis lead.
. Process establishment, define candidate and functional rules by
extraction from legacy systems.
. Tool based extractions - using relativity and SEEC for extracting
business rich Health care applications.
. Analyze applications, creating technical & business analysis
descriptions, establish guidelines
. Interact with Business SME (Subject Matter Experts) and
ITG(Information technology group)
. Project estimations, tracking, query handling, lead reviews and
delivery management of work products and training resources.
. Achieved Technical process Automation using VBA macros
. Generating weekly statistical and department performance reports for
senior management review.
. Building repository with source code using Relativity/ SEEC tools.
o Creation of different kinds of reports like
Inventory/complexity/dead code cross reference reports etc.,
using Relativity tool.
o Generation of Structure charts, Program Control Flow diagrams
etc., using Relativity.
o Creation of summary analysis report using statistics from
different reports generated.
. Business Rule mining process concepts building.
. Automation of rule mining using VB scripting. It is used a global rule
mining product.
. Adding rules to rule engines and assisting cross project teams for new
application development related queries.
Client/Company : Lloyd's Bank UK
Project : LTSB-OCIS
Project Duration : Feb 2007 - July 2008
Client: OCIS (Operational Customer Information System) is a prime source of
core customer information (e.g. Name, Address etc) of the Lloyds TSB Bank
Group application set. This application merges data to provide a group wide
view of a Customer's relationship with us (e.g. a single customer record
comprising of all relationships held - Banking, Insurance, Mortgage, Credit
Card etc). It aims to provide a consistent view of a Customer record and
improve data quality to consistent level of service to be applied. Accepts
updates to customer information from anywhere within the group and inform
all related business areas of the applied change.
OCIS system is a backend COBOL with a front end Java. Designed and
developed Application Program Interfaces (APIs) which allow external
applications access to and update of OCIS data via batch or online
functions. Had been involved in end to end application design &
development:
As a Senior Analyst, I have managed 10 member offshore team with regular
client interactions on Onshore-Offshore model.
Technologies: COBOL, CICS, DB2, JCL, HTML, IBM Query optimizer v8,
CA - Intertest, Endeavor, Expeditor, IMS-DB, IBM Query optimizer v8
Responsibilities:
. Analyze client Techno-functional Design document.
. Preparation of Detailed HLD and LLD (High and Low Level Design).
. Code development, Test scenario, Test data, Test case and Test plan
preparation.
. Unit testing, system integration testing support.
. Peer Review - Code review, test plan review, delivery notes Review,
defect fixing and post production support.
SQL/DB2 Query Optimization:
o Identifying Queries that perform slower and on cost basis.
o Incorporated IBM's Query Optimizer Cost based tool version 8.
o Rewriting the existing queries for optimized performance.
o Testing of new queries vs. old queries in IBM Query optimizer
tool and in TSO-QMF to verify and validate the performance.
o Recording performance and documentation.
o Developed Presentation material on Optimization and Query
performance.
IMS-DB2 conversion
o Analyzing existing IMS programs and database design.
o Creation of design documents for conversion.
o Creating new DB2 database design document and creation of
database.
o Coding of new COBOL-DB2 programs in more optimized way.
o Unit testing of modules.
o Validation of results and peer review.
o Creation of process document for conversion from IMS-DB to DB2
platform.
2 Employer2: Hexaware Technologies (August2004 to February 2007)
Client : Deutsche Leasing - Germany
Project : ABS (Asset based securities)
Project Duration : Aug 2006 - Feb. 2007
Client: Deutsche Leasing AG is Germany's largest leasing company in
automotive, energy systems, office equipments and IT leasing. The business
consists of leasing objects based on contract agreements.
DL Host system consisting of Contract management, Customer management,
Asset management, and Finance management related to contracts. It would
support the business activities throughout the life cycle of a contract or
life of an asset.
Asset backed securities (ABS) project: DL wants to sell certain contracts
to an external bank which in turn sells them as notes/bonds and pools
investors from market. The advantage being excess spread, predictable cash
flow and lesser event risks.
This project involves various tasks like understanding the finance system,
Identifying and bundling of contracts that need to be sent to external
banks, sending data to interface for external banks, handling feedbacks
from external bank, financing such contracts and handling interface for
booking information to external SAP R3 system, updating treasury department
with the cash flows.
As a Senior Systems Analyst & Onshore-Offshore coordinator, I have managed
3 member offshore team and performed the below activities.
Technologies: COBOL, CICS, DB2, JCL, MANTIS, Change man, EARL, Expeditor
Responsibilities:
. Requirement collection from IT group and Business users.
. Analysis of techno-functional document provided by clients.
. Thorough study & understanding existing application with direct
interaction with business users.
. Reverse presentation of application functionality to client team.
. Impact analysis on existing programs.
. Preparation of detailed design documents and Low level design document.
. Code development and changes using COBOL/ CICS/ DB2/ VSAM/ CICS/ EARL
. Interaction with Business leads for the preparation of test scenarios,
wrote test case, test data & test plan.
. Assisted offshore team by handling technical queries and testing,
production environment issues.
. Peer review done son new modules, code changes and test case results.
. Unit testing and system integration testing (SI& T), user acceptance
testing(UAT) support and management of test director tickets and change
requests
. Implementation of all new & impacted modules
. Documentation of Program functionality and JOB flows, scheduling and post
production support.
. Played Defect prevention quality analyst role and handled version
management responsibility.
Client : Deutsche Leasing - Germany
Project : VAT (Value Added Tax)
Project Duration : Jan 2006 - Aug 2006
Value Added tax project: DL Business had a requirement of change of VAT
(Value Added Tax) percentage from 16% to 19% to be implemented across
Germany. This project involves various tasks like splitting the contracts
into two segments, one with 16% and other with 19%. Creating bookings for
accounting departments, data transfer to external interfaces, finance
relevant changes to treasury department and creating remainders for
additional VAT charges to customers.
As a Analyst programmer and Onshore/Offshore coordinator the below
activities were performed.
Technologies: COBOL, CICS, DB2, JCL, MANTIS, Change man, EARL, Expeditor
Responsibilities:
. Requirement collection from business users & client technical group
through interactions.
. Identifying impacted COBOL-I programs.
. Technical Analysis of existing programs.
. COBOL-I to COBOL-II Conversion. Code changes for version compatibility.
. Testing of converted modules for version compatibility.
. Validation of results between COBOL I vs. COBOL II versions.
. Documentation of code changes.
. Requirement collection from business users for new/ additional
functionality for splitting contracts and new tax calculations to arrive
at EMI's and accumulators.
. Code changes, code development, unit testing and SI&T.
. UAT-support and defect fixing.
. Review and Release notes preparation.
. Documentation of incorporated functionality and scheduling detail
. Played Defect prevention quality analyst role and handled version
management responsibility.
Client : Deustche Leasing Gmbh Germany
Project : App Maintenance & Business rule mining
Project Duration : Sept. 2004 - Dec 2005
The maintenance of DL Host system involves understanding of the business
process and expertise to handle defects and to do enhancements. It requires
IT support to perform all the activities for the leasing contract of an
asset. This includes management of the following applications contract
management, customer management, asset management, fleet management, dealer
management, service, Insurance and Finance management
As a Analyst programmer and as a part of 15 member team the below
responsibilities were performed diligently
Technologies: COBOL, CICS, DB2, JCL, MANTIS, Change man, EARL, Expeditor.
Responsibilities:
. Application Maintenance
o Requirement analysis.
o Tracing the defects in case of defect fixing.
o Code development and enhancements using COBOL, DB2, CICS, JCL VSAM, flat
files, MANTIS and Earl additional debugging tools.
o Test case & test data preparation, unit testing & System Integration
testing (SI& T).
o Preparation of release notes and schedule details.
o Jobs and programs code promotion to production system.
Sashi Rekha M K