Sapana Yadav
Email: *********@*****.*** Cell: (**4) -800-7081
VISA : EAD (L2) till June 25th 2015 (VISA Sponsorship is NOT required)
Summary:
** ***** ** **** ********** as a IT Professional with Project Management, Business
•
Analysis, System Analysis, Design Architecture, Development/Coding, Testing, Maintenance
(Enhancements & CRs) in Telecom(3 years), Insurance(5 years) and Banking(2 years) domains.
4 years of Technical Lead experience in leading, mentoring & coordinating with teams
•
in an Onsite-Offshore model.
Proficient Onsite Coordinator (1.5 years in UK) in requirement gathering from
•
business users, translating user requirements into technical/system specifications, writing
design specifications and tracking project progress following SDLC (Software Development
Life Cycle) phases.
Proven System Analyst for ‘ Telecom Usage Processing & Billing’ applications, ‘New
•
Business & Underwriting’ applications of Life Insurance & Pension systems and Credit Card
applications.
Extensively worked on IBM Mainframe technologies using COBOL, PL1, JCL, IMS
•
DB/DC DB2, VSAM, CICS and various IBM Tools and utilities.
Developed various process automation tools, optimized codes using REXX, M/F &
•
EXCEL based macros resulting in improved efficiency of application and $ savings for client.
Sound knowledge on middleware applications in Coldfusion with ORACLE, SQL as
•
database. Developed web interfaces, reporting applications in Coldfusion using FTP to connect and
extract data from Mainframe environment.
Certified LEAN, ITIL Foundation in IT Service Management V3, Six Sigma Green
•
Belt professional
Expertise in handling clients, business, external vendors & product support groups.
•
Proficient in Stakeholder Expectation Management, Scheduling, Prioritizing, Decision Making,
Problem Solving, Time Management, Process Improvement & Negotiation.
IT Industry Experience:
Amdocs ( May’10 – Apr’13): Client - AT&T (USA)
•
Wipro Technologies (Aug’05 – Apr’10): Client - Friends Life (UK)
•
Patni Computer Systems (Jun’03 – Jul’05): Client – Statefarm(USA), GE(USA)
•
Education:
Qualification University/Board Year % Marks – Class Remarks
10th Rank in
Bachelors of Engineering Pune University, May 2003 66% - Distinction
in Computer Maharashtra, Class
Science (4 years course) India
H.S.C. (12th grade) 3rd Rank in
Maharashtra, Mar 1999 96.80% -
India Distinction Merit List
S.S.C. (10th grade) 9th Rank in
Maharashtra, Mar 1997 89.30% -
India Distinction Merit List
Software Skills:
Languages: PL/1, COBOL, JCL, REXX, SQL, SAS, Cold Fusion
Front End/GUI: IMS DC, CICS, HPS
Databases: IMS DB, DB2, VSAM, IDMS, MS SQL Server, MS ACESS
Operating Systems: MVS, Z/OS, UNIX.
Tools/Others: CHANGEMAN, QMF, SPUFI, TSO/ISPF, ESP, SSO, RACF, DFSORT, SYNCSORT,
IBM Utilities, ICETOOL, TOAD, SQL Developer, Filezilla, Dreamweaver 4.0, MS Visio, MS Excel
2010, MS Project 2010, FILE-AID for IMS (IMS-XPERT), FILE-AID for DB2, ABEND-AID, X-
PEDITOR, NDM Connect–direct.
Professional Experience:
Project: Carrier Access Billing System (CABS)
General Electric Card Services (USA), Statefarm Life (USA)
Client
Environment
Team Size
Work Location
The Carrier
Access Billing System
(CABS) generates
monthly billing for
Access, Local and
Wireless Carriers for
the SBC West and
Southwest Regions.
This billing equates to
$6.6 billion for AT&T
per year. The project
involved providing
development support
for the AT&T CABS
application in the
Southwest, West and
SBCT regions. Sub-
modules of the
application were:
Service
Order & Usage
Processing
Payment
(cash) Processing
& Posting
Bill
Processing &
Generation
Bill
Distribution &
Accounting
Responsibilities:
• Responsibl
e
for Develo
pment,
Maintenan
ce &
Support
(24X7) of
Telecom
billing
application
s to
achieve the
highest
level of
customer
(end user)
acceptance
&
satisfaction
within
Service
Level
Agreement
s (SLA).
• Designed
&
Developed
‘FCC
Regulated
Project’
to enhance
the
Wholesale
Billing &
Usage
Processing
applicatio
ns. This
was a
complex
project of
7500 man
Hrs.
Identified
•
&
Implement
ed
Automatio
n Ideas like
service
order edit
utility,
legal hold
datasets
deletion
process,
billing
reports
automatio
n, bill
recreate
automatio
n, release
manageme
nt tool
using
REXX,
Coldfusion
& SQL
server.
Implement
•
ed
solutions
to optimize
production
nightly
mainfram
e
batch cycl
es.
Arranged
•
SAS
sessions,
served as
technical
mentor &
lead for big
size &
complex
conversion
project -
SAS to
COBOL
conversion.
Coordinate
•
d with
various
stakeholder
s
to docume
nt business
&
functional
requireme
nt, created
functional,
design and
technical
artifacts.
Created pr
•
oject plans
&
schedules,
identified
&
mitigated
risks,
tracked &
resolved te
chnical
issues -
ensuring
solution
was in
scope, on
time and
within
budget.
Managed
•
stakeholder
s through e
ffectively
communica
ting project
plans,
expectation
s, progress,
assumption
s & depend
encies in a
timely
manner
throughout
the project.
Lead &
•
managed a
team of 8
associates.
Worked on
•
Effort
estimation
& Schedule
planning
for
enhanceme
nts.
Key
•
member of
various
organizatio
nal
initiatives
of
Knowledge
Developme
nt retention
forum,
Quality
Metrics
improveme
nt and
dashboard
generation,
Technical
certificatio
n and
expert
forum,
LEAN
Kaizen
Club.
Project: SLA
Based
Application
Support Program
Client
Environment
Team Size
Role Played
Work Location
The scope of
this project was to
implement Request
For Changes (RFCs),
Minor Work Items
(MWIs) and
Maintenance Requests
(MRs), resolve
Incidents affecting
Life Insurance,
Pension Processing
systems on Mainframe
platform at Friends
Life. Sub Modules of
applications were:
New
Business of Life, Unit
Linked, Investment &
Pension Policies
Underwriting
and Quote processing
Policy
Administration -
surrender/renewal
processing
Responsibilities
• Designed
&
developed
batch
programs
in COBOL, PL1, IMS
DB/DC
and DB2.
• Developed
programs
to extract
data from
IMS DB &
created
online
screens
using IMS
DC.
Identified
•
opportuniti
es for
improveme
nt in
efficiency
&
responsive
ness
activities
for both
batch and
online
modules.
Implement
ed
initiatives
which
resulted in
$ savings.
Optimized
•
jobs using
utilities
like SYNC
SORT,
ICETOOL,
FILE-AID
&
IDCAMS
Created
•
Stored
Procedures
in
COBOL-
DB2 to
link the
new Web
Interface
with the
Mainframe
programs
executing
at the
backend.
Extensive
•
involveme
nt in
understandi
ng the
Business
Requireme
nts &
suggesting
Design of
the new
DB2 tables
created for
this
project.
Implement
•
ed
resolutions
to
production
problems
&
improved
reliability
of
application
s.
Interacted
•
with
clients,
identified
key
challenges
& defined
project
scope and
deliverable
s.
Created
•
Functional
and
Technical
Specificati
ons (FS
and TS).
Played
•
role of a
release
manager
in
deploymen
t of
applicatio
n,
managing
the work
allocation,
assessment
s, reviews,
document
ation &
release
plans,
coordinati
on for
successful
release &
deploymen
t of the
applicatio
n.
Served as
•
application
& technical
SME of
New
Business,
Underwriti
ng &
Quote
processing
application
s.
Analyzed
•
common
defect
trends as
part of the
Defect
Prevention
Group
(DPG) &
suggested c
orrective
action &
code
review
checklists
to reduce
defects.
Project:
Sapphire
(Knowledge
Transition)
Client
Environment
Team Size
Role Played
Work Location
The scope of
this project was to get
application specific
transition of FP
systems from FP
SMEs in KAP phase at
client site, preparing
System Maintenance
Technical Document
(SMTD) & Execution
Process Document
(EPD), providing
Shadow Support and
then taking complete
ownership in Steady
State.
Responsibilities:
Proactive
ly planned &
executed
knowledge
transition of New
Business and
Quotes systems.
Prepared
Data Flow
Diagrams using
VISIO to
understand the
system flow and
provided guidance
for the technical
changes to
offshore team.
Prepared
& reviewed
SMTDs, EPDs.
Automated
customer’s pain
points and
repeated works
Used to
lead the bug triage
meetings for
bug/ticket
resolutions.
Evaluate
d the
specifications
provided by the
client/onsite team
while managing
design &
development
Prepared
high-level
requirements
report and gap
analysis during the
development
phase.
Liaising
with Business and
Technical expert
for initial
investigations &
requirement
gathering
Coordina
ted efforts for
System/Acceptanc
e testing and
implementation of
work requests
Project: Credit
Card Application
System, Life
Insurance
Application
System
Client
Environment IBM Mainframe, JCL, COBOL, CICS, DB2, VSAM
Team Size 10
Role Played Software developer, Senior Software Developer
Work Location Patni Computer Systems Private Ltd, India
The project involved in providing development and support services to GE–Credit Card Industry
in USA. The application dealt with Private Label credit card which was processing customers such as
Consumer, Revolving Credit, and Commercial Accounts. The other project aimed at handling
enhancement requests for Statefarm Life Insurance System. SF-LIFE system was developed at all
locations of the Statefarm to automate the process of issuing a Life Insurance Policy to an individual.
Responsibilities:
• Modified and extended functionality of existing systems using Cobol, CICS and DB2
• Provided solutions to production problems
• Prepared the test data and performed unit testing, integration testing and system functional
testing based on business requirements, technical specifications and/or product knowledge.
Key Accolades Across Career Path:
Received Reward &Recognition, Special Award, Client Recognition for the initiatives taken in
•
Amdocs.
Received STAR Performer Award as a Project leader of the team in Wipro.
•
Received Feather In My Cap (FIMC) award from Project Manager for excellent performance
•
as Onsite Coordinator in Wipro.
Received Client (Friends Life) Appreciation for timely delivery of project which helped client
•
in successful launch of new product in international market.
Received Recognition Award for excellent performance in assigned tasks and dedication &
•
sincerity in the work from Patni in 2004.