Project Maintenance
Resume:
Archana
***********@*****.***
SUMMARY
. Over 8 + years experience as Business Analyst in Banking and Insurance
domains.
. Experience in all phases of System Development Life Cycle (SDLC): from
inception through implementation and experience in handling multiple
projects concurrently and following Business Process Flows thoroughly.
. Strong analytical abilities, attention to detail and astute problem
solving skills.
. Experience in developing Business requirement document (BRD), Functional
Requirement Specification (FRS), Software Requirement Specification (SRS)
and Use Case Specification.
. Expert using Microsoft Access (design and build), Excel (formulas and
macros), PowerPoint, Project, Visio, and Word.
. Working experience in Database technologies like Microsoft SQL Server
2008, 2005 & 2000, SQL Server Integration Services, Sybase 11, 12.5,
Oracle 9i.
. Working experience in Cognos 8.4.1, VB, Java, UNIX, Autosys and VB.NET.
. Migrated critical MS Access applications from 2000 to 2007 version.
. Involved in analysis and migration of MS Access 2007 to MS SQL Server
2008.
. Responsible for generating critical and time-bound month end reports from
MS Access and SQL that are sent to Federal Government on a monthly basis.
. Enhanced Report Builder application that generates critical reports to
support all versions of MS Excel.
. Worked on report configuration, scheduling and modifying existing reports
on user requests.
. Used JIRA (Issue and Bug Tracking System) to address all maintenance
tasks.
. Coordinated and participated in review, revisions, changes, enhancements,
testing, and documentation of system enhancements and/or business
opportunities.
. Proficient in writing Test Plans, Test Scenarios, Test Cases and
documentation of test results. Also involved in maintaining Test Matrix
and Traceability Matrix
. Extensive knowledge of QA methodology, issue prioritization, bug tracking
and reporting testing status process.
. Extensive knowledge of IT service management utilized in Asset Management
(Maximo) Change management, problem management and many other processes
of system development.
. Excellent communication skills, clear and concise documentation skills
and highly dedicated towards delivering the appropriate solution for the
customer.
. Strong Technical and Analytical skills with good knowledge of CMM
procedures.
. Strong teamwork skills and the ability to communicate with all management
levels.
. Involved in regular reports, feedback and communication with the
management, coordinating the team members, delivery and documentation of
project.
. Good team player, result oriented, quick learner, highly motivated and
perseverance to undertake challenging jobs with positive attitude.
Technical Experience
PROGRAMMING LANGUAGES : VB 5.0, VB 6.0, JAVA, VB.NET
RDBMS/DBMS : SQL 2008, SQL 2005, SQL 2000, PL/SQL, Sybase 11, Sybase
12.5
ETL : Informatica 9.1
Reporting Tools : Cognos 8.4.1, Qlikview
Operating Systems : Windows, UNIX
Domain Knowledge : Banking, Insurance
Certifications
INS 21 : PROPERTY AND LIABILITY INSURANCE PRINCIPLES FROM AICPCU.
SQL 70-229 : SQL Server 2000 from Microsoft technologies.
ITIL : ITIL v3 Foundation Exam
NCFM : Financial Markets: A Beginners' Module
PMP : Attended 35 person days PMP workshops and trainings in Bank of
America
Education
MASTERS IN MECHANICAL ENGINEERING FROM BIRLA INSTITUTE OF TECHNOLOGY AND
SCIENCE, 2006.
Professional Experience
BANK OF AMERICA
Jersey City, NJ
Application Support Analyst
June2010 -Present
Project Description
Onyx Docs Reporting is a reporting application which provides business
critical reports to the back office on a daily basis. The application is
sourced with equities and derivatives trading data from various interface
and source systems like DTCC, LCH, ORCA. Data is enriched and provided to
the back office business users located globally in the form of excel
reports. These reports assist them in handling the confirmation and
settlement of Derivative trades.
Responsibilities
. End to end maintenance and support of application.
. Used JIRA extensively for maintenance ticket management.
. Involved in monthly production releases and CNR testing.
. Provided weekly and monthly status reports
. Participated in various bulk trade migration dress rehearsal testing
conducted by Back office operations teams in UAT. Also ensured
successful production move of the bulk trades.
. Extensive knowledge of application helped in raising bugs and working
on development tasks.
. Migrated around 10+ MS Access applications from 2000 to 2007 version.
. Involved in analysis and migration of MS Access applications to MS
SQL Server.
. Provided data fixes within required time span to maintain customer
satisfaction.
. Generated critical ad-hoc reports for global users.
. Generated time bound and critical reports from archive database (MS
Access and MS SQL) for Audit purpose on higher management request.
. Liaised with vendor teams (Infosys, Accenture) to get the required
information and reviewed the same. Also assisted them in providing ad-
hoc reports for business use.
. Analyzed several Enhancement requests from business users and
developed Business Analysis document.
. Analyzing different Database sources for reporting requirement.
. Provided clear and concise analysis to users for the business queries
reported.
. Single Point of contact for critical production issues.
. Interacted with external vendors like DTCC, LCH to resolve issues
with data provided by them.
. Enhanced Report Builder application (.NET) to support latest version
of MS Excel.
. On boarded existing user access to Security and Access Management
(SAM) tool using SSIS package. This eliminated the manual
intervention in generation of user access reports.
. Assisted users in timely delivery of several critical reports on
Audit request.
. Gathered inputs from users and developed new reports.
. Provided in-depth analysis to resolve production and application
issues.
. Provided a concrete explanation of resolutions to issues, inquiries
and requests.
. Created Knowledge base for the application.
. Attended and conducted Domain trainings.
. Worked with application developers, DBAs, QA Testers and User
Acceptance Testers.
. Actively participated in cross functional trainings and other team
building activities.
American International Group, Inc
Edison, NJ
Production Support Analyst / Developer Sep2006
to May2010
Project: AIU A/EGIS-EUROPE Production Support
Nov2008 to May2010
Project Description
A/EGIS (Adjuster Examiner General Information System) is a claims
processing system for American International Underwriters (AIU), division
of American International Group of Companies. It involves customization and
production support of the A/EGIS product for AIU. A/EGIS has a set of
applications that pertain to various insurance business functions like
Claims Processing, FDP interface for migrating claims, Billing,
Reinsurance, Coinsurance, Financial & Accounting, Client maintenance,
Producer maintenance, Reporting, Printing.
Responsibilities
. Requirement gathering from clients for enhancement tickets for
various countries.
. Provided optimal Estimation and Planning for the requirements
gathered.
. Developed stored procedures in Sybase for enhancements.
. Tested the application to be effective and compliant to requirement.
. Provided data fixes within required time span to maintain customer
satisfaction.
. Solved mission critical tickets.
. Involved in application fixes for major country releases.
. Have done the root cause analysis for various issues in AEGIS and
worked on code fix.
. Done the performance tuning for Data Loading activities and various
screens in frontend application.
. Maintaining the TEST environment.
Project: AIG-AIWCS CAPRI Changes May2008
to Oct2008
Project Description
American International Worker's Compensation System ("AIWCS") is a workers
compensation policy issuance system which is designed to perform quoting,
issuance, renewal, endorsement and auditing of policies.
AIWCS is validating the State, Major class and Company combination present
on the policy against the existing MIS104 table (Licensing table).CAPRI
licensing team has come up with more accurate and licensed combinations
along with certificate effective and expiration dates. Effective 05/01/08,
AIWCS should validate the State, Major class and Company combination
present on the policy against the new CAPRI Licensing table (MIS104C) along
with certificate effective and expiration dates. In addition, Major Class
Codes for TRIA and DTEC Plans will be changed effective 07/01/08 for
Monopolistic States with Stop Gap Coverage.
Responsibilities
. Involved in preparation of Project Plan.
. Trained the team members as per the Requirements.
. Involved in Requirement Analysis and also prepared the Approach
document.
. Involved in preparation of Impact Analysis Document.
. Assisted in preparing Unit test plan and System test plan.
. Involved and Assisted team members in Coding.
. Performed reviews and the review comments will be captured in the QA
Status Card.
. Weekly project status meeting with Onsite Co-ordinates and
maintaining MOM on every call.
. Involved in Unit testing and System testing.
. Support during User-acceptance testing.
. Provided Production Support.
. Provided Post Implementation Support
Project: AIG-AIWCS 999 Split Changes
Dec2007 to May2008
Project Description
AIWCS compiles all the policy transactions booked and loads the data into
the GREEN Database ("GDB") on a daily basis through a nightly batch
process. Other Customer applications such as Workers Compensation Bureau
Reporting and Compliance ("WCBRC"), Specially Workers Compensation and
Premium Audit fetch data from the GDB for reporting, claims processing and
auditing purposes.
During the audit process in AIWCS, splits are generated. 999 is one of the
splits and it contains summary transactional data. Currently, 999 split
data is maintained in AIWCS and is passed to Central Reporting System
("CRS") for booking purposes to ensure proper state allocation of premium
for tax and assessment purposes. 999 split data is not currently being sent
to the GDB, as they are not required for Workers Comp. Policy
administration ("WCPOL") or unit statistical reporting. WCBRC requires the
999 split data also in the GDB as part of the AIWCS GDB nightly batch
process for financial reporting purposes
Responsibilities
. Involved in preparation of Estimates and Project Plan.
. Involved in Project Initiation and trained the team members.
. Involved in Requirement Analysis and also prepared the Approach
document.
. Assisted in preparation of Impact Analysis Document, Unit test plan
and System test plan.
. Involved and Assisted team members in Coding.
. Performed reviews and the review comments will be captured in the QA
Status Card.
. Weekly project status meeting with Onsite Co-ordinates and
maintaining MOM on every call.
. Involved in Unit testing and System testing.
. Undergone PL's training.
. Presented Project management Review (PMR), Audit and Project Wind-up.
. Maintaining the TEST environment.
Project: AIG-AIWCS NY General Outstanding Changes
July2007 to Dec2007
Project Description
American International Workers Compensation System ("AIWCS") is a policy
issuing system. It supports issuance of policies for both Voluntary and
Assigned Risk Market Types in Worker's Compensation and Ocean Marine Lines
of Business ("LOB").
In AIWCS the premium calculation is determined by the process of Rating.
During rating many Rating plans get applied on the policy resulting in an
increase /decrease in the premium. One of such rating plans is the General
Outstanding Rating Plan. This plan is applicable for many states currently
including the state of New York ("NY"). NY State Bureau has mandated
certain changes to the current behavior of the General Outstanding Rating
Plan. AIWCS application needs to be modified for these changes to take
effect.
Responsibilities
. Involved in Project Initiation and trained the team members.
. Involved in Requirement Analysis and also prepared the Technical
Approach document.
. Prepared Impact Analysis Document, Unit test plan and System test
plan.
. Involved in Database changes of NY State Algorithm and Exclusions.
. Performed reviews and prepared Internal Metrics.
. Weekly project status meeting with Onsite Co-ordinates and maintaining
MOM on every call.
. Involved in Unit testing and System testing.
. Prepared SPC Charts, Product Delivery Notes, and Move Sheet for final
delivery.
. Support during User-acceptance testing.
. Provided Production Support.
. Provided Post Implementation Support
. Presented Project Management Review (PMR).
AIG-AIWCS Maintenance Sep2006
to July2007
Project Description
American International Workers Compensation (AIWCS) Maintenance is
Functionally divided into three modules: Rates Maintenance, Production
Tickets and Maintenance Release. In Rates Maintenance, business requests
like changing the Rates for class codes, discontinuing and adding
Phraseologies of class codes, discontinuing and adding the Forms,
discontinuing and adding the Plans, changing the exclusions and inclusions
for Plans will be processed.
Production tickets team will handle the requests that are sent by end-
users. Maintenance Release team will analyse and provide estimates for
upcoming enhancements. In addition, minor code changes are also handled as
part of Maintenance Releases.
Responsibilities
. Processed the Rates, Phraseology, Forms and Plans Requests provided by
NCCI State Bureaus.
. Solved the Production Tickets and prepared many adhoc Reports.
. Provided Transition to the new comers.
. Involved in analysis of various Maintenance Release items.
. Suggested the improvements in AIWCS and BSS tool.
. Maintaining the TEST environment.
1
Contact this candidate