SUMMARY

• Skilled professional with proven track record of over 7+ years as a Sr. Business Analyst in the financial and insurance industry.
• Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications. Developing functional specifications for business process refinement and automation, data modeling, system Architecture, conducting feasibility studies, scope.
• Proficient with methodologies like Software Development Life Cycle (SDLC), Project Management Methodology (PMM), iterative Rational Unified Process (RUP), and Rational Tools used in different projects.
• Proficiency with Rational Enterprise Suite (RequisitePro, Rational Rose, ClearCase, ClearQuest) in support of the RUP methodology.
• Experience in Web technologies using HTML 4.01/5, CSS, XHTML, and Java script, JQuery and AJAX.
• Experienced working with Service Oriented Architecture (SOA), Software development life cycle (SDLC) and agile methodology.
• Experience in Maintaining Reference Data Management System and Master Data Management System with Service Oriented Architecture (SOA).
• Strengths include big picture focus while developing strategic business solutions which can include: BRD, FRD, Test Plans.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Drill Through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Good understanding of different business processes used by credit card companies including but not limited to developing offer population, soliciting customer, defining and building product, accepting and processing payment, servicing customer.
• Good understanding of web and mobile interactive design and development principles and best practice to effectively guide/advise stakeholders and technical team on project conceptualization, strategy design and functional requirements.
• Well versed with writing PL/SQL functions and procedures.
• Expert with Oracle Business Intelligence Enterprise Edition (OBIEE), Data Quality Management tools, Siebel Analytics, Oracle application development tool (Oracle Application Express) and MS Excel.
• Strong project management skills including planning, scheduling, monitoring and budgeting with experience in requirement gathering, gap analysis, risk analysis, effort estimation etc.
• Have good Agile methodology experience (Scrum, RUP, XP, i.e. Iterative Development and Project Management). Used User Stories in agile testing. Familiarity with UML and Use Cases.
• Good knowledge of debugging JavaScript and html code with Firefox Firebug and Google chrome JavaScript debugger.
• Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
• Involved in the development of Services using ALSB, WSDL and XSD.
• Experience in Banking, Financial, Information Technology, and Manufacturing environment.
• Successfully defined and implemented Project Management processes and procedures based on BABOK, and PMBOK for multiple groups.
• ALSB to OSB upgrade and proficient in testing SOA WebServices using SOAP UI Tool
• Strong Knowledge of UML, RUP, Rational Suite including Rational Rose, RequisitePro etc.
• Familiarity with Borland caliber suit.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• In - depth knowledge of creating Use Case, Activity, logical, component and deployment views with Rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
• Understanding of Treasury data needs and reporting for Asset Liability Management (ALM), Liquidity, Basel III, Capital Forecasting, Cash flow analysis, FTP etc.
• Detail oriented, quick learner, good listener with strong problem solving skills.
• Good knowledge of Web Services, SOAP programming, WSDL, XML technologies DTD, SAX and XSLT
• Team player with Project Management and Leadership skills. Enjoy working in a team environment and accomplishing goals as a team while meeting deadlines.

TECHNICAL SKILLS

Databases: MS Access, MS SQL Server 7.0, My SQL, Teradata.

Automation tools: WinRunner, LoadRunner, and Rational Suite.

Defect Tracking tools: Rational Clear Quest, Test Director and Mercury Quality Center

Modeling tools: UML, Rational Rose, MS Visio, Rational RequisitePro

BI Tools: Crystal Reports, Business Objects.

Programming: C, SQL, Java, VB, TSL, SQABasic, PL/SQL, HTML, CSS.

Operating Systems: UNIX, Windows NT/95/98/2000 & XP

MS Office Tools: Ms-Excel, Power Point, Word, MS-Access

Database Tools: DB Visualizer, TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Sr. Business /Data Analyst

Responsibilities:

• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Created SISD (Small Initiative Specification Document) for the EMM project.
• Set up securities (T-Bonds, IR Futures, Eurodollar and futures, IRS, CDS, commodity futures and options, etc) in Front Arena for trading.
• Bank Integration requirements gathering and elicitation process for integrating various Bank web-forms to allow provisioning of accesses via Access Central - a Sun based Identity Management (IdM) Java product.
• Prepared data dictionary stating what data elements are involved, what is the business definition, format and possible values for all data elements involved with in various systems and documented data mapping documents for various systems. Documented and gathered roles based access rules and security rules.
• Assisted the Identity and Access management team (IAM) in collecting the business requirements to onboard new applications to the IAM platform.
• Execute two week iteration and worked with the cross-functional mobile application team to ensure that all the requirements were compliant with overall project goal and scope for mobile and web based products. responsible for monitoring and governing business unit compliance with CoB planning and testing requirements for the denial of access, denial of service, call tree, tabletop, end user computing and crisis management programs.
• Translated high level requirements in Vision Document into detailed requirements in Business Requirement Document (BRD) and Use Case Documents (UCD) and Conducted User Acceptance.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
• Created Complex Teradata scripts to generate ad-hoc reports that supported and monitored Day to Day Branch Operations as well as Sales and Services.
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Created a Branch Operations specific data-mart as part of a Business Objects Universe which replaced the existing system of reporting that was based on exporting data sets from Teradata to Excel spreadsheets.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
• Prepared Functional Specification Documentation (FSD) and communicated these to the stakeholders.
• Responsible to fix any kind of bugs in CSS and HTML in order to meet the exact functionality requirement.
• Developed PL/SQL procedures and functions using Toad for Oracle.
• As member of project team, developed requirements, participated in design sessions, guided UAT, and developed training for Hyperion Planning, Hyperion DRM, Hyperion Reporting, and Oracle Business Intelligence Suite Enterprise Edition Plus (OBIEE)
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executedduring testing process.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Conducted Business Requirements, Functional and Technical meetings with Business groups.
• Used MS Visio for Process modeling and Business Process flow diagrams.
• Extensively involved in regression testing during various phases of the application.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Troubleshot the designed jobs using the Data Stage Debugger.
• Tuned Data Stage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Environment: Business Objects6.5.1,XI R2 (CMC, CMS, CCM), Designer, Desk I, WebI XI R2/6x, Supervisor, Crystal Reports XI/XI R2, Oracle 10g, Toad, SQL Server 2000, Teradata SQL Assistant, Rational Suite, XML, Windows, HL7 v2.X,Crystal Reports, Oracle, UML, UAT, MS Office, PL/SQL, MS Excel, MS Visio

Confidential, Charlotte, NC

Business Systems Analyst

Responsibilities:

• Financial products involved: Fixed Income, Equities, Bonds, Mutual Funds, Fund of Funds, Insurance, Retirement Planning, Generation Planning and complete Financial Planning.
• Involved in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Created various reports to source data for the DFA165e (Single Counterparty Limit) and CCAR mainly for Derivatives and SFT (Security Financing Transaction)
• Prepared material to enable the IDAM platform to access certification.
• Provided all aspects of SharePoint administrative support, access control and content management.
• Leverage strong business knowledge of the investment banking sector to help design viable solutions.
• Responsible for interacting with business heads for designing integrated accounting and business processes.
• Solely responsible for carrying out several enhancements to the Billing work flow.
• Received appreciation from very senior management for the insights provided for designing innovative business solutions.
• Created .NET Reports which are used to present the data in different views and are effectively consumed using Crystal Reports.
• Performed data analysis and Data mapping from source system to target system.
• Supported the back-office settlements / clearing and supported KYC/AML to manage reference data using data modeling, database schema, entity relationship diagrams and SQL queries, stored procedures for reference data modules and risk modules.
• Involved in Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams.
• Write user stories using JIRA for web, Android, and IOS mobile applications for Contact Solution’s, customer engagement platform for new and existing products.
• Authored Requirements documentation (BRD, FRD); workflow design and analysis.
• Assisted the PM on various projects throughout the Project Management Life Cycle (PMLC) including Project Charter, Project Plan and Resource allocation.
• Maintenance of ALSB Administration & WLI Administration & OSB & SOA Administration.
• Participated in designing and coding for web forms of the application with ASP.NET.
• Was responsible for indexing of the tables in that data warehouse.
• Worked in close collaboration with SME's and Data Modelers and MDM Architects to devise RDM solutions
• Developed a thorough knowledge and maturity in all the phases of SDLC and familiar with industry standard best practices & frameworks such as RUP (Rational Unified Process), AGILE & Lean. Designed, developed, maintained and executed automated and manual test scripts for the IVR platform
• Used MicroStrategy Web tooffer interactive reporting to the end users through a web browser.
• Administered object migration using MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Used SQL in both embedded code (RPG AS/400) and in report gathering for managers & auditors
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Support the development of a data warehouse olap and reporting solution to provide necessary information to various business areas and executive management of actuarial data for auditing / business forecasting.
• Built ad hoc query reports for the Mortgage Department using SQL backend.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Involved in project management using MS Project
• Involved in creating logical and physical model of the database using MS Visio, MS SQL Server 2000.
• Involved in creating Data Flow Diagrams for Database of the Investment Portfolios
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Create complex reports using SQL Server Reporting Services (SSRS).
• Used Agile methodology of development to improve customer satisfaction by rapid & continuous delivery of S/W
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.

Environment: Agile Process, RUP, Virtual Change Control system, Lotus notes, MS- Project, MS- Visio, MS-Office, Windows NT/2000/Vista, Rational Clear Quest, ALM, Teradata, Crystal Reports, SQL.

Confidential, NJ

Business System Analyst

Responsibilities:

• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test.
• Worked on Property and Casualty insurance, and provided organizational services to various companies.
• Identified risks involved for the desire project such as market risk, inflation risk, credit risk, and default risk.
• Provided analysis for an existing Commercial Lines Property & Casualty Legacy system, identified data elements, and mapped to XML Schema using XML.
• Wrote Requirements for a Financial product - Property & Casualty Valuation.
• Policy Insurance system mapping data to an Accord form for Property and Casualty and Workers Compensation.
• Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Collated and gathered requirements; prepared business requirement documents (BRD)
• Analyze the source code used by the ERP system in UNIX environment and create a SQL query to generate report that matches user’s need.
• Monitored Portal transports, daily Monitoring of the production systems and portal systems, workload analysis, performance tuning, change management in MDM systems and Portal webpage development, using Netweaver Developer Studio.
• Created Functional Requirement Specification Document which included UML, Use case diagrams, Scenarios, activity, work Flow diagrams and data mapping, and Data modeling with MS VISIO.
• Business owner at the data mart and OLAP level for an in house variable profitability analytical tool.
• Responsible for creating and submitting weekly progress reports to the project management.
• Involved in testing web services (between Siebel and ALSB and Mainframe) using SoapUI
• Used MS SharePoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
• Provide ad-hoc analysis for situations that go beyond the scope of the OLAP cubes.
• Created business requirement documents and integrated the requirements and underlying platform functionality. Strong understanding of rating in Property and Causality.
• Developed and maintained Service Oriented Architecture (SOA) governance process costing models and metrics ensuring architecture compliance.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions and worked with SME’s in Europe, to finalize the layout of the new Work-flow diagram. Also, the design (wire frames) was re-formulated
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Traced test cases and functional specifications to SSRs
• Worked with Scrum Project Management and Agile Methodologies for Software Development Life Cycle.
• Involved in Service Oriented Architecture (SOA) of the claims processing system
• Planned and documented procedures for data processing and prepared data flow diagrams for the application and establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: Agile Process, RUP, Virtual Change Control system, Lotus notes, MS- Project, ALM, MS- Visio, MS-Office, Windows NT/2000/Vista, Rational Clear Quest, Crystal Reports, SQL.

Confidential, St. Louis, MO

Business Analyst/Systems Analyst

Responsibilities:

• Analyzed user requirement documents (URD), software requirement specification document (SRS) and prepared System test plan by dividing the application into manageable units.
• Involved in writing Detailed Test Plan for the Application under Test (AUT).
• Succeeded in implementing a Pharmacy Benefits management (PBM) program using encrypted FTP data feeds.
• Generated Reports on AE and SAE as a part of clinical data management process.
• Developed, implemented and executed test methodologies and plans to ensure software product quality as per the RUP methodology.
• Test some of the Extensions in Facets application manually.
• Developed reports based on the Clinical Trial protocol
• Developed UID Documents, FRD and other SDLC Artifacts.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Perform Gap Analysis of the processes to identify and validate requirements.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Translated high level business / data requirements into Process, Workflow, and Data Flow Diagrams using Rational Rose / MS Visio / BPMN towards facilitating clear understanding of the business process.
• Prepared spreadsheets with the help of MS Office to show like specific geographic regions etc.
• Conducted several demos driven by MS PowerPoint Presentations.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Defining test cases, creating test scripts, analyzing bugs, interacting with QA / dev teams in fixing errors, SIT and (UAT)
• Was responsible for indexing of the tables in that data warehouse.
• Documented existing applications with the creation of UML sequence diagram and class diagram to document.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Drafted a Traceability Matrix in Excel and imported it into Rational RequisitePro
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Involved in the User Acceptance Testing to make sure the defects raised by the business users were resolved up to the Management Expectation by the developer group.
• Prepared documentation using MS Word.
• Created reports in MS Word for account processing of each client group.
• Worked with the quality assurance group through out the company identifying the major changes with the greatest opportunity for cost reduction.
• Involved in generating Test Plans, Test Scripts and Test Cases manually in MS Excel.

Environment: Oracle, Windows, Pl/SQL, Rational Enterprise suite, Enterprise Architect, RUP, UML, COBOL, Data Stage, Microsoft Word, Excel, Visio, MS Project.