SWATI SHEKHAR
Oerlikon,Zurich 8050
Email: **********@*****.*** Phone:
WORK SUMMARY Skills
Over 8 years of experience in Finance,
Banking Credit Risk, Pharmacy and o Data warehousing development
Telecom Domain with various technologies
and process methodologies o ETL, Testing QA and Support
International Work exposure, enriching o Business Intelligence and reporting
cross cultural experience in different
working environments including USA, UK o Production Support Incident Management
and India
Excellent exposure to Production Support, o ITIL/Lean Six Sigma
Data warehousing-ETL-Informatica.
o Transition and Project Management
Much appreciated in my last role as
Project Leader and Sr. IT system Analyst o Change and Release Management
for Genworth Financials, USA.
Excelled in implementing the real-time
reporting model aligning to Business for
accurate and effective decision making
reporting on an interface as well as
supporting interface to Internal
accounting system and Blackrock to help
and effectively function Accounting and
trading system interface.
Before Genworth, while working for IBM in
India excelled as a QA lead and reporting
analyst for data warehousing with
Informatica and oracle. ETL Lead in TELUS
BI IBM project, led and coordinated
projects to minimal defect releases and
smooth production handover, improved
quality of QA and Development process in
onsite-offshore model.
While working for various clients in
Infosys, Excelled as an application
manager and Team lead, major
contribution to the additional roles as
Transition Manager for ETL application
suite along with roles of ETL Team lead Trainings
and Developer working for AstraZeneca in
Manchester UK o ITIL Foundation V2 2006 -V3 2009 Dec
o Informatica DEV by Informatica
While working for Credit risk support o Cognos Reporting
Analyst provided IT Solutions aligned to
business requirements as Senior Support o Lean Six Sigma (IBM)
Analyst for corporate data warehouse,
credit risk applications for UBS, in
London UK.
Appreciated and recognized by business
users and Client manager for diligence
and dexterity especially during software
releases, contingency and BCM exercises.
Was highest incident resolving support
analyst throughout my tenure.
WORK HISTORY
Nov 2011 to Sep 2012
Genworth Financial
Role: Sr. IT System Analyst
Location: Stamford, CT, USA
Domain : Finance
Release and change management planning,
executing, testing and sign off
co-ordination to keep current data
warehouse accommodate changing business
needs
Assisting business with required reports
and data for testing process and new code
and releases
Increased reporting efficiency by
reducing nightly job processing time in
2011 by almost 4 hours for data warehouse
with Informatica tuning, Oracle 11g
database upgrades.
Business solutions support and IT vendors
- offshore and Software provider
Blackrock- interface management and
communicating with IT providers and
Business to ensure full availability of
trading data for business
User assistance and front end magament
for trading platform as well as other
critical web application Achievements and Awards
Incident and problem management interface
with third party software provider Quarterly Excellence Award and
Blackrock and offshore services Certification for contribution and
Led and worked hands on for Business quality work in British telecom during
Intelligence and Data Warehouse solutions Infosys occupation
for Monthly, Daily reporting in an ETL,
Business Objects environment, with Nominated for Star Performer award and
Blackrock Aladdin as primary fixed income Customer delight award during Transition
Trade platform and data source along of AstraZeneca During Infosys occupation
with other parts of integrated data
warehouse systems
Document creation for disaster recovery Implemented Lean Six Sigma in telecom
and business contingency Project for Billing and Allocation
Help introduce new practices of Data during IBM Employment
warehouse and reporting component
availability maintenance
Application support for regional and high
risk application limited to single
support person
Technology: Power Center Informatica 8.x,
Apprworx., Windows, XP, Oracle PL/SQL,
Jan 2010 - Feb 2011
IBM
Project Canadian Telecom Company, TELUS
Role: Sr. Consultant
Location: Pune,INDIA
Domain : Telecom
Implemented proactive working methods and
automations
Provided quality supervision to various
programs to ensure process
QA activities hands on and supervision,
including releases and activities such as
designing test plans,execution and
defect management
Developed processes and procedures for
continuous process improvement efforts
with better schedules and resource
estimates Education
Ensured that all projects meet stringent Bachelor of Computer Application (year
timeline goals with zero defects with 2003) from Shreemati Nathibai Damodar
help of organized cross team reviews Thackersey Women's University, Mumbai,
Resource allocation and efforts India. NAAC Accredited
estimation
Excelled in Informatica Code reviews and Certifications
Test case Reviews, Test Strategies o Informatica Developer by Informatica
Chaired business calls, coordinated year 2010
release sign offs for releases
Implemented Lean Six Sigma in telecom
Project for Billing and allocation, it
helped project save cost for the
allocation and billing process
Successfully Delivered Cognos Development
/QA projects and report development
Improved quality of QA and Development
process
Short term Projects- included BSS,
hardware performance management, various
telecom provider plans
Hands on Cognos Report studio and
framework manager exposure
Best Practices and Compliance adherence
Led the automations drive for redundant
tasks
Client and Global team co-ordination
Technology: Power Center Informatica
8.x,Cognos, UNIX, Windows, XP, Oracle
PL/SQL, Mercury Quality Center
Oct 2008 - Jan 2010
Infosys Technologies Ltd.
Project Pharmaceutical company,
ASTRAZENECA
Role: Sr. Support Analyst
Location: Macclesfiled,UK
Domain : Pharmaceuticals
Excelled as a Data ware housing and
Business intelligence IT Production
support Analyst for reporting enterprise
performance in AstraZeneca Currently Learning German
As a team lead Setting up Guideline
documents for set of applications and
resources to follow
Transition management,Resources
allocation and effort estimation,
assignments
Client interfacing for all transition
stages KT state, Shadow state, live state
and Steady state
Transition for close to 45+ applications
in two groups and 3 waves
Applications included enterprise
performance with Master Data management
Contributed in setting up the Quality
Process model for Software development
and Lifecycle as well as ITIL for Managed
services
Knowledge sharing and learning management
for team members
SOX training, SLA briefing and
understanding for offshore
Building up a very strong customer
support and communication structure
Testing and release management for a
group of web applications based on
documentum
Technology Documentum, OWB,ETL
Informatica,Oracle
Jun 2007 - Sep 2008
Infosys Technologies Ltd.
Project UBS,credit risk
Role : Credit Risk Support Analyst
Location: London,UK
Domain : Finance
Professional References will be furnished
upon request
Incident Management with application
support and ownership, managed 3
critical trading applications for London
Time zone
Reviews of solutions provided by team
members in L1 and prepare
checklists/Report for future incident
occurrences
Releases Management, from signoff
meeting, actual execution and
communication to defect reporting and
resolution
Providing users with day today adhoc
reports, was appreciated time to time by
Credit officers for providing accurate
and timely reports
Resolving critical issue, business/User
interfacing, high risk incident
communication through calls, meetings and
emails.
Release Management and Production
support for the Corporate Reporting
warehouse for the credit Risk
Feeds, master data management for global
ratings tools, credit risk trading
applications
Minor Automation to remove manual
interventions wherever possible
especially during configuration changes
and other repetitive setup for
applications.
Automations for feed generations and
monitoring alerts for Production support.
Technology: Power center Informatics
7.5.1, Oracle 10g, PL/SQL, UNIX, Sybase,
Business Objects XIR2, Java, Autosys
May 2006 - May 2007
Infosys Technologies Ltd.
Project British Telecom
Role: Production support Analyst and
release manager
Location: Pune,India
Domain : Telecom
Resource allocation and calculation of
efforts estimation activities,tickets
mapping and reporting's
Incident and change management
Allocation of task to team for the new
Projects and daily tracking of task
allocated
Preparation & maintenance of training
plan of team members
Review of development test cases
developed by team
Review of the release notes, Knowledge
sharing session with team members
Set up the release management process,
Reviewing and editing requirements,
specifications, business processes
Providing inputs to project estimates and
test plans, Client Interfacing for
requirement gathering and high priority
issues
Monthly/Quarterly reports preparation and
presentation
Technology: Oracle 9i, PL/SQL, UNIX, .net
for web front end application
Jul 2004 - Apr 2006
Infosys Technologies Ltd.
Project BNY Mellon
Role: Production Support Analyst
Location: Bangalore,India
Domain : Finance
ETL application specialist and lead in 5
months of time
Deliverable tracking
Mentoring for health and welfare stream
of Mellon on ETL for new team members
Troubleshooting, testing for the given
changes in Change request for code
Anchored Transition to another Vendor for
2 months at the project handover phase
which gave me excellent opportunity to
excel in business interactions transition
management and learning management
Technology: Oracle 9i, PL/SQL, Power
Center Informatica 6.5.1, UNIX
Activities and Awards
Quarterly Excellence Award and
Certification for contribution and
quality work
Nominated for Star Performer award and
Customer delight award during Transition
Implemented Lean Six Sigma in telecom
Project for Billing and
Education
Bachelor of computer application
S.N.D.T. University, Mumbai, India
(2003)
Higher secondary School and Secondary
school from Pune University (2000)
Specialized in Computer application
Design and Computer Networking
Areas. Contributed to team projects,
Served as Teaching assistant selected
classes,
lab programming class, responsible
for assignment grading, class review
sessions, and student meetings