Project Manager Insurance
Resume:
Raj MULLAPUDI
Summary:
. Business Analyst with over 12 years of experience in the fields of
business analysis, project management, object oriented analysis,
software validation and process re-engineering of web-based and Client-
Server applications.
. Experience in providing the management with solutions for enterprise
data integration for a consolidated view of business by closely
studying the process models.
. Hands on experience as an acting project manager in resource
allocation, schedule time-boxing and complete end to end activity
planning.
. Good understanding about Trading Lifecycle, fixed income, equities and
derivatives.
. Experience in financial service domains such as investment banking and
commercial lending.
. Experience in insurance domain such as P&C auto and HO as well as
reinsurance.
. Excellent in Data Analysis, Data Modeling, BI reporting aspects as a
business analyst
. Expert in Software process reengineering cycle including reverse
engineering, code restructuring, data restructuring.
. Expert in designing conceptual and logical data models as a part of
process reengineering representing various segments of business.
. Extensive knowledge of Asset Based Lending, Leasing and Asset
Management applications
. Experience in dealing with large scale projects which deals with
thirty two source systems for commercial lending, leasing and
investments.
. Expert in executing various process models: Incremental process Models
(incremental, RAD), Evolutionary Process Models (Prototyping, spiral),
Specialized process models (Component based, aspect oriented) and
Unified Process.
. Practical knowledge of rational unified process (RUP) as an iterative
SDLC with implementation of all four phases: inception, elaboration,
construction and transition.
. Strong understanding of principles of DW using Fact tables, Dimensions
tables, Star Schema and Snowflake Schema.
. Excellent understanding of reverse and forward engineering, logical
and physical models.
. Experience with full life cycle and methodology for implementing data
warehouse and business intelligence reporting system.
. In depth knowledge of SDLC (software development life cycle) having
through understanding of various phases such as requirements,
analysis/design, development and testing.
. Expert in UML, Rational Rose, Requisite Pro, Erwin, MS suite, and
Rational testing tools.
. Experience in conducting joint application development (JAD) sessions
with end user, expert team, and QA team for project meetings, walk
through and all stakeholders.
. Excellent analytical skills on open systems architecture, SOA,
distributed systems architecture, thick client. Legacy main frames
. Excellent in developing Use Cases.
. Hands on experience with content Management tools like MS Sharepoint
and Plainview.
. Experience with GUI specification of web-based application.
. Worked with writing and executing SQL commands.
. Experience with Data Migration, Data conversion, Data profiling, and
data analsys.Good knowledge on working with application servers like
WebLogic and apache tomcat.
. Strong project management skills including planning, scheduling,
monitoring and budgeting with experience in requirement gathering, gap
analysis, effort estimation etc.
. Efficient in executing multiple tasks and assignments ahead of
schedule.
. Self motivated and possess ability for critical thinking, analysis,
superb interpersonal skills, team oriented technically motivated and
creative, user oriented with the desire to learn clients business
requirements.
Education:
. MS in Computer Science - Farleigh Dickinson University
. Bachelors in Electronics and Communication - Andhra University, India
. Currently pursuing PMP certification
Software/Hardware:
Rational Rose, UML, ERwin, MS Visio, Visual Basic, SQL,C, TeraData,
Kornshell Scripting, C++, ER Win 4, 3.5.2,Star-Schema Modeling, Snowflake
Modeling, Windows 95/98/2000/ NT, MSDOS, LoadRunner, WinRunner, MS Project,
MS Office, Windows NT, Windows 2000, Rational Unified Process (RUP), HTML,
MS PowerPoint, Business, ABINETIO, Loan IQ, Stucky, Infolease.
Experience:
Feb 2006 - Current
CIT Financials
Lead Business Analyst/Project Manager
CIT Financials has had an unyielding focus on financial solutions for
nearly 100 years. As a Fortune 500 company and member of the S&P 500, CIT
provides financial solutions for more than 80 percent of the Fortune 1000
with offices in more than 30 countries, including Canada, Europe, Latin
America, Asia and Australia & New Zealand.
Project: Data Management Program/ Corporate Data Warehouse Implementation
Responsibilities:
. Defined the process and guidelines for a successful implementation of the
program along with allocation of resources and responsibilities for the
deliverables.
. Assisted the management in designing a Data Governance model for the Data
Management program.
. Created a consolidated conceptual model of Lending (Cash flow and Asset
based Lending) and leasing information which involves Loan IQ, Stucky and
Infolease.
. Integrated Capital markets data which includes primary and secondary
market securities
. Developed a consolidated business process model for corporate finance
which includes various products for lending and leasing information and
investment banking services using EMBARCARDERO.
. Executed the project utilizing the best practices of iterative
methodology.
. Created the data model and business process models utilizing the
standards of IE and OMG.
. Extensively worked on source target mappings and performing Gap Analysis
for the Customer and Contract data.
. Successfully captured and documented functional, data requirements and
Business intelligence requirements.
. Designed prototypes for information required by business by modeling it
with the corporate hierarchies.
. Successfully implemented drill down and roll up functionality for
corporate finance along with slice and dice of data to facilitate
business decisions through Hyperion Suite
. Extensively analyzed GL data like GL balances and GL transactions and
linkages from the disparate sources which feed the GL.
. Build requirement traceability matrix in HPQC as a project deliverable.
. Executed ad-hoc SQL statements to for data analysis.
. Designed interfaces for manual adjustments to corporate data warehouse
and performed detail analysis on auto reconciliation from GL to corporate
data warehouse and corporate date warehouse to data mart.
. Implemented customer profitability and product profitability solutions.
. Analyzed the Accounts Receivable source systems and identified the data
that roll up to the reporting attributes for P&L reporting.
. Decomposed high level requirements and defined detail requirements for
asset level analysis and P&L and Shadow P&L reporting.
. Facilitated brainstorming session with business for defining the business
rules that govern the fields.
. Designed program level test plans and assisted testing team to develop
test cases and also involved in defect analysis with onsite offshore co-
ordination.
. Effectively communicated the transformation logic and developed test
cases to test the ETL logic.
. Implemented Hybrid Analysis in Hyperion environment by successful
identifying the low level members and tag them with the reporting
attributes available in Essbase.
. Prepared training manuals and successfully completed UAT and UET.
Environment:
AGILE,RAD, Mercury Test Director Rational Clear Quest, Windows, HTML, XML,
J2EE, MS Access, Data stage, Version Controls, Windows NT,UML,SQL Server,
Legacy Mainframe, MS suite, Hyperion, Hybrid Analysis. EMBARCARDERO
Experience:
May 2005 - Feb 2006
NJM Insurance Group West Trenton NJ
Sr.Business Analyst
New Jersey Manufacturers Insurance Company (NJM) operates in a mutual
fashion for the exclusive benefit of policyholders. The financial benefits
of Company operations go only to policyholders and dividends have been
returned to policyholders each year. NJM owns three insurance subsidiaries:
New Jersey Re-Insurance Company (NJRe), New Jersey Casualty Insurance
Company and New Jersey Indemnity Insurance Company. The Project involves in
Claim Center, a Guidewire Product implementation and integrates it to
Legacy Mainframe. The final goal is to turn off Legacy Mainframe.
Responsibilities:
. Performed the role of business process administrator by defining the
business process and co coordinating with various teams.
. Process reengineered the claims life cycle.
. Interacted with the Technical team and architects to identify the Java
Messages that need to be created and also categorized the data
attributes.
. Interacted with developers to configure the Java bean which acts a mode
of communication between the web and the legacy database.
. Involved in management of various documents like Change Controls, Risk
Management, Requirements and identifying User access controls for content
across the enterprise for various initiatives.
. Implemented Agile Methodology and created Templates for requirement
Gathering and Metrics for quantitative Analysis.
. Facilitated JAD sessions efficiently by introducing Pre JAD and JAD Prep
for efficient capturing of requirements.
. Understanding the business rules which has to be configured into he rules
engine
. Reverse engineered the Legacy Business rules and facilitated
brainstorming sessions with Business Analysts users, Testers and
Development for which needs to be configured in Claim Center.
. Used UML extensively for Use Cases, state chart and context diagrams that
need to be captured in SRS.
. Created architectural models to support recommended solutions provided
for higher management for reports and workers compensation.
. Assisted the Development team in construction of Java Messages that needs
to be synced.
. Complete support for construction of middle tier and facilitated sessions
with various teams to understand the object behavior and assisted the
architects for generations of events messages.
. Verified Data Mapping and defined the filter criteria in both G script
and SQL styles for each of the data elements that are present in the
standard data model and newly added extensions.
. Involved in complete claims cycle for General claims Auto and HO
including financials, reserve amounts, subrogation, Arbitration and
litigation for claims.
. Involved in complete data migrations and conversion from Legacy to open
systems.
. Performed analysis for web services that are required or not required for
SOA based construction
. Assisted the Testing team with resolution of queries and designing of
test scripts for scenario based testing, smoke testing, integration
testing regression testing and testing of business rules, end to end
testing.
. Effectively resolved conflicts and clearly communicated the requirements
with development team by writing down the Pseudo code.
. Understanding the data model changes with new releases and finding the
discrepancies and mapping elements with the new data model.
. Performed Gap Analysis to analyze the Gaps between the existing Legacy
and the to -be model.
Environment:
AGILE,RAD, Plainview, GuideWire, Mercury Test Director WinRunner, Rational
Clear Quest, Windows, HTML, XML, J2EE,Struts, MS Access, IIS Server
Informatica., Version Controls, Windows NT,UML,SQL Server, Legacy
Mainframe, MS suite .
Experience:
Feb 2004 - May 2005
St Paul travelers insurance Hartford CT
Sr.Business/Data Warehousing Analyst
St. Paul Travelers are a leading provider of property casualty insurance,
surety products and of risk management services to a wide variety of
businesses, organizations and to individuals. The project involves
implementing of PLW (personal lines warehouse).by collapsing auto and
property warehouses.
Responsibilities:
. Involved in refining the existing data marts by thoroughly understanding
the reverse engineering documents.
. Facilitated JAD joint application design sessions.
. Redesigned a more logically structured GUI for better navigation.
. Involved in setting up environments of some of the data marts.
. Interacted with group to facilitate for timely and effective requirement
translation.
. Assisted the project manger in estimating, resource allocation and
binging out ROM (Range of magnitude) and ROI (Return on investment).
. Wrote specifications for the movement of code and data through the
environments, for the subsets of data.
. Designed use cases for applications that need to be added to the new
warehouse.
. Involved in writing the master test plan and writing test cases for a
strategic QALC (Quality Assurance Life Cycle).
. Wrote requirements for several applications by creating the requirements
tractability matrix and requirements itemization matrix.
. Participated in all phases of SDLC including UAT (User acceptance
testing) UET (User end Training) and production support.
. Secured timely approval for the stakeholders by bringing out the
prototypes.
. Implemented RUP (rational unified process) methodology.
. Interacted with client and the Technical Team for requirement gathering
and translation of Business Requirement to Technical specifications.
. Created user access controls by identifying the user groups.
. Wrote SQL and T-SQL scripts to reduce the discrepancy within the data
marts.
. Made visual presentations in use cases, state charts, sequence diagrams,
deployment diagrams, and securing timely approval.
. Created guidelines for writing use cases and designed the standard
templates for documenting the process.
Environment:
Rational Unified Process (RUP), Rational Test Manager, WinRunner, Rational
Clear Quest, Windows, HTML, XML, ASP, Teradata, T-SQL, AbInitio, Kornshell,
Windows NT, WEBLOGIC.
Ameriquest Mortgage Company, Mays Landing, NJ Apr 2003 -
Jan 2004
ASAP! and Data Warehousing
Sr.Business Analyst
Ameriquest Mortgage Company is one of the oldest and largest home-equity
lenders. ASAP! Is a web-based application that is designed to replace the
current loan processing system at Ameriquest. ASAP! System gathers the lead
information and processes the credit, appraisal and title stipulations.
Responsibilities:
. Created a gap analysis report on the testing practices and
procedures implemented within Ameriquest.
. Involved in establishing/implementing best practices and procedures
as per Rational Unified Process (RUP).
. Involved in creating the scope document for the ASAP! Project.
. Processed reengineering home loan approval to bring down process time-
secured approval from stakeholders in record time.
. Studied ODS and reverse engineered to Erwin.
. Verified artifacts at each phase to be completed and corrected.
. Interacted with group to facilitate for timely and effective requirement
translation.
. Analyzed test requirements and module specific functionalities to
identify test requirements.
. Worked closely with the team to understand new business and technical
potential.
. Made visual presentations in use cases, state charts, sequence diagrams,
deployment diagrams, and securing timely approval.
. Conducted user acceptance testing.
. Data retrieval multidimensional analysis.
. Helped build the data warehouse services for the company. Tasks included
conducting requirement analysis; the design and development of data model
(star schema); the creation of database, in both oracle 9i and SQL server
2000.
. Wrote complex SQL statements and compared it with the ones that are
generated by the software.
. Mapped the requirements of the data warehouse conceptual level such as
aggregations, partitions.
. Led JAD sessions with managers, subject experts, vendors and other
stakeholders.
. Developed Test Cases in ETL.
. Performed feasibility study and risk analysis to identify the business
critical area from user perspective.
. Compared the loan documents and generated ASAP! System with those of the
current system.
Environment:
Rational Unified Process (RUP), Rational Test Manager, WinRunner, Rational
Clear Quest, Windows, HTML, XML, ASP, MS Access, IIS Server Ascential
DataStage 7.5 (Server Edition), Version Controls, Windows NT, and SQL
Wachovia Bank, Charlotte, NC
May 2002 - Mar 2003
Business Analyst
Wachovia Corporation is one of the largest providers of financial
transaction processing services. It was the Global Exposure System project
.The aim of the project was to implement a centralized Global Exposure
system that maximizes automation. The system will serve the corporate
credit community with exposure and losses and complete credit tracking for
decision support.
Responsibilities:
. Requirement gathering and documentation of critical business processes.
Wrote Use Cases using MS Visio, functional specifications and business
rules.
. Conducted Use Case walkthroughs in an effort to identify and realize the
processes and flows involved in the new system.
. Analyzed and prioritized user and business requirements as system
requirements that must be included while developing the software.
. Interacted with members of the development team along with potential
system users and domain experts.
. Involved in conducting JAD sessions with various stakeholders like users,
business experts and management staff for understanding requirements,
vision, scope and highly critical areas of the application.
. Responsible for facilitating a healthy communication between client and
IT people and clearly understanding business rules and effectively
implementing them in business process flow.
. Involved in analysis of the functional requirements and designing the
System Structure.
. Conducted the data analysis for the data warehouse.
. Developed overall project plan using MS Visio for designing and
developing the system. Also involved in interviewing business area
expert, asking detailed questions and carefully recording the
requirements in the format so that it can be reviewed and understood by
both business people and technical people.
. Followed RUP's iterative development approach and was involved with all
iterations of the development life cycle.
. Created business and functional requirement documentation and used MS
Word for documentation generation.
. Conducted Gap analysis and developed Systems Specifications document to
define the impact of the new requirements on the existing system.
. Used MS Visio to model activities and work flow process in the business
and make them more understandable to developers and system analyst.
. Responsible for meetings with users and stakeholders to identify
problems, resolve issues and to improve the process to ensure a stable
and accurate solution.
. Advised on capturing the additional data requests from the ODS Performed
business process mapping for new requirements.
. Worked with the data modelers, DBA's and QA teams to resolve issues.
. Facilitated user acceptance testing and test strategies with Information
Systems Group.
. Performed manual front-end testing to check all functionalities of
different modules.
. Suggested measures and recommendations to improve the current application
performance with the aid of SCR's (Small Change Requests).
Environment:
J2EE Technology, UNIX / Oracle Platform, MS Visio, MS Word, SQL Server2000,
Microsoft Office Share point Portal Server2003, Windows NT, Mercury Test
Director.
State Farm Auto Insurance Company, Los Angeles, CA Jul 2001 -
Apr 2002
Business Analyst
One of the US's largest personal lines property & casualty companies, State
Farm Mutual Automobile Insurance Company provides auto insurance, as well
as homeowners, non-medical health, and life insurance through some 17,000
agents. Project was related to a comprehensive online request for auto
insurance quote processing. The system runs on Mainframe and has a Web-
integrated front end that provides free auto insurance quotes to
individuals and for families.
Responsibilities:
. Conducted interviews with the "Users" by preparing questionnaire and
getting the feedback.
. Analysis of new Business Requirements and preparation of the Functional
Design Specifications employing use case scenarios, sequence diagrams,
ERD's, DFD's and class diagrams.
. Analyzed and translated business requirements into system specifications
utilizing UML and RUP methodology.
. Created project plans, detailing projects' mission, process flow,
timelines, requirements and any risks.
. Conducted iterations and communicated results and milestone achievements
to the stakeholders while keeping the developers closely updated on all
documented refinements.
. Identified and clearly defined functional issues and support IT
development staff throughout the design, development, unit testing, and
implementation phases of the software development life cycle.
. Successfully implemented the change request and defect tracking Using
Rational Clear Quest for utilization by the developers and the QA Team.
. Created timely reports using Test Manager, Rational Clear Quest and Log
Viewer.
. Expertise in executing and analyzing the various queries and creating
reports depending on the user.
. Created test cases to check the functionality of Application.
Environment:
Proprietary multi-tiered client-server architecture for transaction
processing called Stateless Architecture (SM), Java, Oracle, Unix Operating
Systems, and Rational Test Suite.
Massachusetts Mutual Life Insurance, Springfield, MA Dec
2000 - Jun 2001
Business Analyst
Massachusetts Mutual Life Insurance, (MMLI) is a holding company that,
through its subsidiaries, is engaged in a range of insurance and insurance-
related activities in the United States and abroad. Project was related to
a comprehensive online auto insurance application processing. It also
provides free insurance quotes to individuals and for families.
Responsibilities:
. Interacted with client and the Technical Team for requirement gathering
and translation of Business Requirement to Technical specifications.
. Analysis of new Business Requirements and preparation of the Functional
Design Specifications employing used case scenarios, sequence diagrams,
ERD's, DFD's and class diagrams.
. Analyzed the new requests specified by the end users for the future
releases and discussion with the functional and technical teams.
. Communicated changes to requirements promptly and precisely to all
personnel involved.
. Identified and clearly defined functional issues and support IT
development staff throughout the design, development, unit testing, and
implementation phases of the software development life cycle.
. Analyzed and translated business requirements into system specifications
utilizing UML and RUP methodology.
. Developed tables, queries and reports gathered from system models based
on the functional requirements.
. Expertise in executing and analyzing the various queries and creating
reports depending on the user.
. Created test cases to check the functionality of Application.
. Successfully implemented the change request and defect tracking Using
Rational Clear Quest for utilization by the developers and the QA Team.
. Created timely reports using Test Manager, Rational Clear Quest and Log
Viewer.
Environment:
Proprietary multi-tiered client-server architecture for transaction
processing called Stateless Architecture (SM), Java, Oracle, Unix Operating
Systems, and Rational Test Suite.
Fleet Bank, New York, NY
Nov 1999 - Dec 2000
Business Analyst
Fleet Boston Investments has been addressing the needs of institutional and
individual investors to access information about the availability of fixed
income securities in the market, calculating the prices of customers fixed
securities/bonds and generating reports about what credit reports agencies
have to say about these assets. It also provides facilities to its
customers to trade online. As a Business Analyst, was involved in the
development of Bond Search/quote center, which is a module that allows
customers to search for bonds online and also calculate the price of the
bonds. These may include corporate, treasury, municipal or savings bonds.
Responsibilities
. Interacted with fixed income business heads to finalize the Business
Requirements for the application.
. Involved in GAP analysis around the identification of business rules,
business and system process flows, user administration, requirements and
assumptions.
. Performed requirement analysis, went through all the use cases and issue
logs.
. Conducted User interviews, gathered and analyzed the business
requirements using Rational Rose requisite pro - RUP.
. Participated in the identification, understanding, and documentation of
business requirements, including the applications capable of supporting
those requirements.
. Collected and documented business processes as well as business rules.
. Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams
using rational rose.
. Analyzed the DW project database requirements from the users in terms of
the dimensions they want to measure and the facts for which the
dimensions need to be analyzed
. Conducted workflow and process diagram to derive requirements for
existing systems enhancement
. Conducted JAD sessions to identify the flows and processes involved in
the content.
. Assisted the PM in setting realistic project expectations and in
evaluating the impact of changes on plans in the organization accordingly
and conducted project related presentations.
. Assisted with user testing of systems, developing and maintaining quality
procedures, and ensuring that appropriate documentation is in place.
. Provided technical assistance in identifying, evaluating, and developing
systems and procedures that are cost effective and meet business
requirements.
. Developed the test plan, test conditions and test cases to be used in
testing based on business requirements, technical specifications and/or
product knowledge.
Environment:
Rational RequisitePro, Rational Rose, Business Objects 6.5, Oracle 9i,
Windows NT Server, MS Visio, UML, MS Project 2000, MS Excel.
Contact this candidate