PROFESSIONAL SUMMARY

• Solution oriented Business Analyst/Project Lead with 9 years of experience in IT industry.
• Extensive experience in Business Requirement Gathering, Functional Requirement Gathering and Gap Analysis in various projects with strong domain expertise in Insurance, Banking and Financial services, Shipping industry.
• In depth knowledge of Wynsure, Bancs and EDI applications.
• Strong understanding of Insurance life cycle Product definition, Distribution, Issuance, Billing, UW, Service Claims , Predictive Analytics, Asset Management, Decision Management Predictive Models, Risk Selection, Pricing Rules, Knowledge content and Data warehouse .
• Excellent knowledge of Health Insurance Portability and Accountability Act HIPAA transaction and code set rules.
• Experienced in Risk Management using VaR, Basel 2 and Basel 3, Regulatory Reporting Practices and Risk Measurement
• Good understanding of Trade life cycle, Trade Order generation, Trade order execution, Trade settlement process and Reconciliation.
• Experienced in documenting the complete process for Announcement Capture, Corporate Action, Lending and Borrowing, Security Processing, Security Trading, Cash Securities Reconciliation, Trade affirmation and pre-matching services, contractual as well as actual settlements.
• Worked extensively on B2B applications and B2C applications in transaction processing and E-commerce applications.
• Successful and progressive record of managing, evaluating and defining requirements with senior management to come up with Standards and procedures for IT Standard Business document templates for analysis .
• Experienced in business analysis activities with the objective of new business identification, proposals, SOW's and Functional documents.
• Strong knowledge of Software Development Life Cycle SDLC methodologies like Agile, Waterfall and Rational Unified Process RUP
• Expertise in performing Business Process Analysis, BPR- Business Process Re-engineering, involved in application redesigning and enhancements/Gap analysis.
• Successfully coordinated JAD/RAD sessions between business stakeholders, SME's and technical team-including PM, Data Modeler, DBA, Developers and QA teams.
• Proficient in developing Use Case Diagrams, Flowcharts Behavior Diagrams sequence diagrams and activity diagrams based on UML methodology using Rational Rose and MS Visio.
• Expertise in Business Process Re-engineering BPR , Business process streamlining, Process optimization, Process mapping, Resource allocation and utilization.
• Extensive experience is creating, filling/completing compliance documents and reporting compliance failures by generating reports. SOX, JSOX, Fed Readiness, Dodd Frank, ISO etc.
• Proficient in User Acceptance Test UAT by working with internal and external users/customers and obtained delivery approval of the project.
• Expertise in writing and implementing Test scenarios, Test cases, System testing, Regression testing and maintaining Traceability Matrix for baseline documents.
• Expertise in creating and executing ORACLE, SQL and UNIX scripts.
• Proficient in developing Reports Charts in Excel, Access and PowerPoint.
• Ability to inculcate new relevant skills with ease in a time sensitive frame.
• Excellent interpersonal and communication skills with an ability to build professional relationships with peers/superiors, and work comfortably with both business and technical professionals.

TECHNICAL SKILLS: Worked on/with applications and software's listed below

WORK PROFILE

Confidential

Sr. Business Analyst/Project Lead

Description:

The Confidential Project is the consolidation of multiple admin systems and platforms into a single solution for all products and business lines. Currently, AIG Benefit Solutions operates in an environment that encompasses 13 separate administrative platforms. This complexity results in an inefficient and redundant operational environment which does not allow AIGBS to compete effectively in the marketplace. Deployment of the Confidential policy administration solution will allow AIG Benefit Solutions to grow sales, improve earnings and significantly improve efficiency to effectively compete in the marketplace.

Responsibilities:

• Understanding functionality of Wynsure Application- analysing business requirements and creating Requirement Documentation BRD , Data Mapping document, Work flow diagrams and Technical requirements for interface workstream.
• Organized and coordinated various project meetings such as JAD sessions, user meetings, walkthrough sessions and Change Request Analysis.
• Worked with business users to understand the real time business need and criticality behind any implementation.
• Analysing product configurations and functionality to create upstream and downstream feeds from Wynsure system.
• Create Road map for future implementation with the goal of establishing synergies between existing system using new platforms ESB Enterprise service bus / Datapower .
• Designed prototypes, wireframes, storyboards, screen mock-ups using MS Visio and MS Excel.
• Performed gap analysis and documentation of functional requirements for commercial reports and Business Objects following Agile Methodology Scrum Framework
• Performed requirement gathering with SME's to create interfaces for new Admin system to interact with internal/external applications like Producer Licensing system, Enrolment system, Eloquence Content Management system , OFAC, Sales, Commissions, General Ledger, Payrite and CDS.
• Created interfaces with the banks to send/receive Lockbox and ACH payments.
• Extensively worked on creating data mapping documents using Accord, NACHA, XML, CSV, TSV and Flat file formats.
• Reviewing test cases created by QA/UAT teams and providing sign off to their test cases with suggestions if any.
• Created error handling and error reporting document for various interface. Setup archival and retention process for incoming and outgoing communication.
• Introduced Quality improvement processes, design walkthroughs, internal and external code reviews and other quality related procedures as per CMM level 5 requirements.
• Supported Pre- Production and Post-production activities like creating checklist, setting up alerts, user contacts and conducting Disaster recovery and backup continuity drills.
• Created Resource bandwidth sheet showing the current assignments with offshore and onsite team member with their bandwidth.
• Created Fed Readiness documents for multiple projects as per AIG policies for compliance and audit.
• Created Weekly/Monthly Status Report showing the major projects, Achievement, areas of improvement, status/ deployed to env, Upcoming / ongoing Milestones.

Environment: Wynsure, Web services, Oracle 11g, SQL server, MS Project, MS Visio, MS Office, Service now, Toad, Team pulse, SQL Loader, Java, Datapower, ESB, Hyperion, Autosys, Windows 7, Agile.

Description:

Salesforce.com The project was to remove redundant databases and create a common repository for all data. Implement star architecture by creating one database for storing all quoting, Sales and producer Licensing/appointment data. Allow multiple systems to access/utilize that data. Also create a direct feed from this new database tables to Salesforce.com using Ab-Initio ETL tool.

Responsibilities:

• Interacted with various business team members to gather the requirements and documented the requirements for creating the new database.
• Developed the scope and vision documents that defined the primary goals, objectives and scope of the project.
• Analyzed redundancy in databases, worked in collaboration with DBA and system architects to design/create new database to implement star architecture.
• Closely worked with Salesforce.com consultants to implement solution needs for AIG.
• Created BRD's, data mapping documents, technical/functional specification documents and data flow diagram.
• Responsible for all activities related to configuring Data Loader, uploading data in CSV files into salesforce.com, checking for integrity of the data.
• Developed business documents for Salesforce.com Custom objects.
• Created documentation for workflow rules and define related tasks, time triggered tasks, email alerts, field updates to implement the business logic.
• Provided support for ongoing Salesforce.com maintenance and administration services including periodic Data cleansing, Custom objects, Workflows and Triggers
• Maintained project plans, task and defect lists, lead meetings to discuss all aspects of the project's execution. Developed test scripts and participated in the QA testing.
• Created training materials and system documentation.
• Used MS Visio to carry out business modeling, data modeling ER Diagrams , Screen Prototype, Object modeling use case .
• Identified various business processes and developed process flow diagrams. Developed prototypes for UI and also assisted in development of screen navigation flows
• Worked with various Salesforce.com objects like Accounts, Contacts, Leads, Opportunities, Quotes, Sales, Reports and Dashboards
• Created Page layouts, Search layouts to organize fields, custom links, related lists and other components on a record detail and edit pages.
• Coordinated UAT testing for the business users.

Environment: Salesforce.com, Ab-Initio, Unix, HP quality center, Service now, SQL server, Oracle 11g, Toad, data loader, Autosys, MS Project, MS Visio, MS office, Windows XP, Waterfall.

Confidential

Business Analyst / Team Lead

Description:

Confidential enables transformation in financial services through a superior and holistic suite of solutions for banks, capital market firms, insurance companies and diversified financial institutions. Each solution in the Confidential family has been designed to run as a scalable and robust service, fully integrated with existing business models, enterprise infrastructures and technology architectures. Confidential is accredited with Confidential Certification for Corporate Actions, Payments and Securities Settlement.

Responsibilities:

• Understanding functionality of Bancs application to make customization for RBCD client.
• Gathering customer requirement, analysis and communicating the appropriate action to onsite - offshore counterparts.
• Understanding and documenting complete process of Announcement Capture, Corporate Action, Lending and Borrowing, Security Processing, Security Trading, Trade affirmation and pre-matching services, contractual as well as actual settlements.
• Position keeping that supports multi-asset class, multi-market position types including equities, fixed income, funds, derivatives, foreign exchange, and money market instruments
• Drafted Concept Notes on functionality enhancements Fixed Income products, Collateral Management for upcoming versions of BaNCS.
• Understanding and defining requirements for End-to-end Corporate Actions processing for a wide range of events covering 70 event types.
• Analyze risks such as Total risk common market and industry/asset specific , Active risk, allocation/selection risk , etc, associated with instruments in various market.
• Functional Specifications Analysis for customization of the application to support Banking and custodian services.
• Dashboard customization - Comprehensive operations dashboard presenting metrics and alerts for critical events and breaks. Ability to view Agent Instructions from the dashboard on the basis of deadline dates
• Understand and document requirements for Event Processing, Validate and sanitize event announcement, reconciliation of internal Holding, Entitlements and Payments with paying agent on Acknowledgement Processing Swift 567 Manual
• Record accounting entries for tolerance amount applicable during cash payment reconciliation. Process complete and partial reversal of payment.
• Risk Management using VaR, Basel 2 and Basel 3, Regulatory Reporting Practices, Risk Measurement, Trade life cycle, Trade settlement process and Reconciliation.
• Conducted GAP analysis between Basel II and Basel III for Securitization exposures and analyzed them to for changes in data sourcing
• Meeting SME's to document and setup Notifications. Create Event Chaser Notifications to Agents who have not provided complete information based on a configurable date. Generate Instruction to Custodian/Counterparty/Lending Agent Rule Based for Chasers, Claims and Elections.
• Performed impact analysis and Performance Testing for the changes done in the application.
• Providing guidance to end users to understand the existing system and underlying logic.
• Creating and tracking defects in HP quality center for issue encountered in the application.
• Prioritizing and tagging defects to different release versions. Coordinating work with various module leads to make sure the fix is packaged and delivered.
• Preparing Shell scripts to integrate all the modules and create installation package JAR .
• Preparing Installation documents, Configuration files, Creating property files and Project Documents.
• Setting up MQ's and FTP's for new services and also supporting/resolving issues with the existing one's.
• Code source and version control using Visual source safe and Clearcase tools.
• Administering the IBM Websphere application, source code version control, base lining various code versions, environment support and setup.

Environment: Bancs, IBM websphere, MQ, Unix, shell scripting, Pearl, python, Oracle 10g, SQL plus, PLSQL, Java, JSP, JavaScript, HPQC, Citrix, Clearcase, Visual source safe, MS Project, MS Visio, MS Office.

Confidential

Business/System Analyst

Description:

The project includes understanding the existing system for ConfidentialLogistics, major shipping company, by which equipment can be tracked, customer information, booking data can be stored and retrieved, handling the new enhancements to the existing system and quality tracking of the process.

Responsibilities:

Business Analyst/Manager

• Understanding business functionality of EDI Applications- AI, GIS.
• Analyzing the technical feasibility of the business requirements, understanding the functional specifications to estimating effort required, proposing design solutions and coordinating with business groups to finalize and obtain sign-off for design.
• Completing/Reviewing Technical Assessment, Design, and Development following SDLC cycle. Providing sign-offs after every process.
• Handling the administrative part of the application GIS in order to enhance the performance of the GIS System and resolve the connectivity issues.
• Setting up the new work-flows by creating new business processes in Graphical Process Modeler GPM and modify the existing business processes.
• Developing the new translation and typing maps for various transaction sets and fixing/modifying the existing maps using Sterling Map Editor.
• Setting up the communication profiles FTP,SFTP,AS2,VAN in order to connect to the partner's server.
• Creating trading partners setup in GIS.
• Restoring the production environment in case of system failure. Worked as production support specialist.
• Review Test outputs and providing sign-offs. Pre-production and Post-production verification and sign-off.
• Creating/Modifying the XML schema to incorporate additional elements required to satisfy the business needs.
• Quality improvement processes like conducting requirement and design walkthroughs, internal and external code reviews and other quality related procedures as per CMM level 5 requirements. These are carried out by using proprietary tools iQMS, iPMS
• Created Root Cause Analysis documents for frequent and critical production Failures.
• Created Weekly/Monthly Status Report for highlighting accomplishments, issues are risks in the project.
• Creating and Categorizing SCs/ tickets as enhancement, Mandatory maintenance, Discretionary maintenance and assigning priorities to meet deadlines.
• Organizing and leading process improvement sessions to enhance productivity and throughput.

Environment: Gentran Integration suite, Unix, Oracle 9i 10g, SQL plus, BPML, ETL, MQ, HP Service Desk, Mercury Quality center, HP quality center, Altova XML, Ultra Edit, Trade guide, Pegasus, Java, Clearcase, MS Excel, MS Word and MS PowerPoint.

Confidential

Analyst/Developer

Description: As an Analyst responsibility was to work on Global Trust Bank's online banking application. The application enables the bank's customers and account holders to access and manages their personal or business accounts including checking, savings, money market and credit information through the internet

Responsibilities:

• Responsible for designing, developing, and testing of the application.
• Meeting with project members and developers to come up with functional requirements.
• Created Stored Procedures, Triggers using SQL in SQL Server 2003.
• Performed and documented detailed Gap Analysis for communicating with the Focus group, Operations group, and Technology Infrastructure group for developing a application development strategy.
• Gathered detailed functional requirements, prepared end-to-end data flow model, and created test cases during the SDLC and developed an interface to extract data from multiple operational systems.
• Collaborated with Change Management Group and IT to prepare a detailed infrastructure for implementing the online banking application a diagrammatic flow of process, data transaction between applications, analytics, database, data feeds, back-end integration accounting.
• Documented System Specifications Document and maintain / manage the enhancements and version tracking.
• Developed Cascading Style Sheets CSS for User Interface uniformity throughout the application.
• Used HTML, JavaScript for developing Controls and web forms.
• Developed User Documents for the user training and help.
• Conducted Team Meetings and technical discussions.
• Involved in development, Bugs fixing, deployment and hosting.

Environment: Windows, HTML, CSS, Java script, HPQC, ORACLE 9i, SQL Plus, PLSQL, Visual source safe, MS Office suite.