Project Quality Assurance
Resume:
SRIDEVI MAGESH KARTHIK
********@*****.***
PROFESSIONAL SUMMARY
> Have 4 plus years of experience in the Information Technology industry
as an Oracle PL/SQL developer and Informatica developer
> Have good years of experience in Healthcare domain and in
Finance/Investment Banking domain
> Have total exposure in full Software Development Life Cycle (SDLC)
including analyzing, designing, developing and testing
> Proficient and certified in Oracle PL/SQL
> Good experience in data modeling, database design and SQL performance
tuning tasks
> Good Knowledge in Data Warehousing Tools like Informatica 8
> Have working knowledge in .net applications
> Proficient in translating complex business specifications into PL/SQL
codes
> Highly-motivated, creative and very organized
> Strong analytical, problem solving and communication skills
> Quick learner and a good team player
____________________________________________________________________________
__________________
EDUCATION
Anna University
Chennai, India
Bachelor of Engineering
2001 - 2005
____________________________________________________________________________
__________________
EXPERIENCE SUMMARY
> Bank of America - Merrill Lynch
Chennai, India
Associate Consultant
Apr 2008 - Apr 2010
> Cognizant Technology Solutions
Chennai, India
Programmer Analyst
Aug 2005 - Mar 2008
____________________________________________________________________________
__________________
CERTIFICATIONS
> Certified in Oracle SQL and PL/SQL
> Certified in Introduction to Healthcare Management
> Certified with course completion in Data Warehousing
____________________________________________________________________________
__________________
ON SITE EXPERIENCE
Merrill Lynch Bank Suisse (MLBS)
Geneva, Switzerland
Obtained extensive training on different systems of Swiss Asset
Management and Banking Application (SAMBA). Also, exposed to various
standards, tools and processes at Merrill Lynch Bank Suisse (MLBS)
____________________________________________________________________________
__________________
SKILL SET
> Oracle, TOAD, SQL Plus, PL/SQL Developer
> C#, Asp.net and Ado.net - 3.5
> Informatica, Cognos
> XML, XSD, SWIFT Messaging
> Visual Source Safe, SVN (Subversion)
____________________________________________________________________________
__________________
ACHIEVEMENTS/ INITIATIVES:
> Won the BACS ZEAL award for the consistent performance and
commitment towards the work
> Developed and supported the implementation of various
applications in cross-locations i.e. UKP (United Kingdom
Platform), UKJ (United Kingdom - Jersey platform) and MLBS
____________________________________________________________________________
__________________
PROJECT SUMMARY
RECENT PROJECT (Merrill Lynch (India) Technology Services):
Project: SAMBA COE DEVELOPMENT and MAINTENANCE
Role: Team Member
Apr 2008 - Apr 2010
SAMBA (Swiss Asset Management and Banking Applications) is a
technology platform for significant portion of the non-US Merrill Lynch
Wealth Management business. It is an Order and Portfolio Management System
which serves Trade Entry, Valuation, Reporting, Client Enquiries, Client
Interest, Credit Decision, Corporate Actions, Matching SWIFT Advices, Fees
Calculation, Invoicing and Workflow Management.
Most of the SAMBA applications are built on Oracle Database. In the
development phase, developed and deployed the interface between various
systems using Oracle 11i and Oracle 10g. In the maintenance phase, we
implemented the enhancements or change requests using Oracle 11i. Also, the
project involved developing some internal dashboards using the .Net 3.5
framework.
Technologies: Oracle 10g and 11i, XML, XSD, SWIFT messaging, Advanced
Queuing, .Net 3.5 Framework
Responsibilities:
. Initiated a process to track the issues to get the faster resolution
and documentation for the future reference
. Well connected with the client managers through effective
communication
. Involved in planning the time estimates of projects/tasks
. Had worked on parallel tasks/projects with proven ability to meet
deadlines
. Supported various projects in cross-locations (i.e. Spain, MLBS,
Jersey and UK) and cross-functional teams (Development team, Testing
team and Business Users)
. Dealt with constantly changing requirements and re-factored the codes
accordingly
. Involved in exception handling and Logging using custom inbuilt
packages and functions
. Developed test scripts to implement new functionality/enhancements to
the existing code
. Developed, delivered and maintained the technical documentation
including design specifications, architectural diagrams, user guide
for the support team, etc
. Developed a page on .net framework 3.5 for an internal dashboard
application
. Performed data modeling, design and development for the backend of the
dashboard application
. Elected to meet the Director of the group for the high performance in
the project
____________________________________________________________________________
__________________
PREVIOUS PROJECTS (Cognizant Technology Solutions):
Project: CDO (Collateralized debt obligation) Interface Phase II -
Development
Client: Standard and Poor's
Role: Team Member
Aug 2007 - Mar 2008
The objective of this project is to develop a single global platform to
deliver CDO data, publications and analytical products to its customers.
Also make the CDO Interface to handle all types of investment deals from
US, Europe and Asia as well as with multi currency and language support.
The front end of the Interface was built using J2EE whereas the business
logic was implemented in the Database layer using Oracle 10g.
Technologies: Oracle 10g
Tools: Toad
Responsibilities:
. Created Oracle package to extract the holding assets of an individual
or an organization or any entity, to update or delete the data in the
tables if any changes has been made to the assets in the front end
screen and to report data based on the Business requirement
. Implemented Data encapsulation using Oracle views for the data
security
. Coordinated with front end development team of 30 people
. Worked on multiple tasks in parallel to support the various modules of
the front end
. Worked on a large and complex database to implement the business
requirements
. Had been recognized and rated as an exceptional performer from the
Database team
____________________________________________________________________________
__________________
Project: CAQH feed to CACTUS - Development
Client: WellPoint Inc., U.S.A
Role: Team Member, SCM Coordinator
Oct 2006 - Jul 2007
CAQH is an exclusive provider Database which holds all the personal and
professional information about the providers of WellPoint. CACTUS is the
working database in which the data for the front end application is stored.
The objective of this project is to get the provider information from the
CAQH repository and update the data into CACTUS database daily so as to
keep both the databases in sync.
Technologies: Oracle 10g, VB.net
Tools: Toad, Informatica 8, ClearQuest
Responsibilities:
. Created the Oracle package which will pull the necessary data from the
CAQH database using Database Link to the CACTUS Database
. Created Oracle Triggers to track the changes (updates or inserts) made
in the pre-identified tables of the CACTUS database
. Created a .net exe to create a report on the changes done to the
CACTUS tables, mail them to the users and save a copy of the report in
a central location
. Used Informatica to transform and load data from the working Database
to the Data warehouse DB
. Involved in code reviews as a part of Quality Assurance work
. Involved in system testing and unit testing
. Worked on a critical enhancement single handedly
. Created the Technical Design Document to record the business logic
translation to technical specification
. Created the Unit Test case document to record the testing of business
requirements and unit testing outcome
. Worked on the workflow automation tool like ClearQuest to track the
bugs reported in the application
. Cleared the external certification (AHM) on Healthcare domain
. Involved in co-ordination with on-site team in understanding the
business requirements
. Created the Maintenance Process Handbook (MPH) document, an in-house
documenting practice to record the steps/process to maintain the
application/interface developed
. Involved actively in all the stages of software development life cycle
____________________________________________________________________________
__________________
Project: Cactus Interface for Bridger - Development
Client: WellPoint Inc., U.S.A
Role: Team Member, SCM Coordinator
May 2006 - Sep 2006
The objective of this project is to extract provider information from the
CACTUS database and feed the data to CAQH system for further processing.
Technologies: Oracle 9i, VB
Tools: Toad
Responsibilities:
. Created VB exe to invoke the Oracle procedure which in turn will
extract the provider information from CACTUS Database
. Optimized the SQL query to reduce the time for data extraction
. Created the Technical Design Document to record the business logic
translation to technical specification
. Created the Test case document to record the testing of business
requirements
. Involved in all the SDLC process like planning, analysis, design,
coding and unit testing
. Mentored ELTs (Entry Level Trainees) to clear the domain certification
. Took up additional responsibilities like code reviews, VSS
maintenance, documentation reviews as a part of Quality Assurance work
____________________________________________________________________________
__________________
Project: eBizLOQ - Team Site and MO - Maintenance
Client: WellPoint Inc., U.S.A
Role: Team Member
Aug 2005 - Apr 2006
eBizLOQ stands for e-business Lights-on and Queue. The key objective of
this project is to provide Lights-on (production support) and Queue
(enhancements to the applications) services for the Missouri applications
of WellPoint Inc.
Team Site is a tool which is used to maintain the static contents of most
of the e-business applications of WellPoint Inc
Technologies: ASP, MS SQL, VB.net
Tools: Team Site, Bugzilla
Responsibilities:
. Had worked on production support for the Missouri application
. Worked in the Team site tool for the static content management of
the Missouri applications
. Used Bugzilla to track and report the changes/enhancements and the
bugs/errors in the application
. Automated an onerous manual process using VB.net exe to extract the
data from the database and mailing the reports to Business users
____________________________________________________________________________
__________________
REFERENCE
Alexandra Alexeeva
Vice President, Swiss Banking Systems
Bank of America - Merrill Lynch Bank (Suisse)
Contact Information available upon request
[pic]
EAD STATUS: ACTIVE
Contact this candidate