OBJECTIVE

• Over 8 years of professional excellent experience as Business Analyst and analytical skills, understanding of software development life cycle (SDLC), completing projects within time and budget, identifying risks ahead of time and troubleshooting, gathering requirements, analyzing, implementation and evaluation of various business systems, proven excellence in documenting business - marketing presentations, functional specification documents and business evaluation reports.

SUMMARY

• Wide ranging experience working on Enterprise IT projects within Healthcare, Finance and Auto/Life Insurance services.
• Experienced in teh Finance and Insurance domains with exposure to Investment Banking, and Global Capital Markets (Equity, Securities, Mutual Funds, Fixed Income).
• Extensive noledge of Portfolio Management, Financing Structures, Cash Flow Forecasting, Financial Analysis, Capital Budgeting, Asset Allocation, Fixed Income Products, Derivative Products such as Options and Futures.
• Exposure to advisory services for implementations of Basel III regulations, CCAR, Regulatory Reporting, Data warehouse integration and internal reporting
• Good exposure to reference data and market data integration for fixed income systems.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance, Life insurance policies, Nationwide annuities( Variable, fixed, Immediate, fixed indexed).
• Created requirements specifications, process models and business rules for E-Commerce solutions.
• Experienced in managing projects throughout teh SDLC (AGILE, RUP, Iterative and Waterfall).
• Experience using database query tools for Oracle, SQL and UNIX .Experience in writing test cases, test scripts, test plans and execution of test cases reporting and documenting teh test results using Quality Center
• Used Excel pivot tables to manipulate large amounts of data in order to perform data analysis, position involved extensive routine operational reporting, hoc reporting, and data manipulation to produce routine metrics and dashboards for management.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Well versed experience in all EDI transactions like 834, 837 P, 835, 27x and conversion of 4010 to 5010.
• Experience with data analysis, data mapping and dimensional modeling experience in decision support systems.
• Practical understanding of theData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Manage vendor relationships including negotiating and controlling contracts.
• Experience working with quality assurance, UAT, risk management, Disaster recovery, Business Continuity plan and change management.
• Proven ability in providing timely deliverables of high quality while working in both - team as well as independent environments.

TECHNICAL SKILLS

Operating Systems: Windows 8, Windows 7, XP, Office 365

Packages & Applications: MS- Word, MS - Excel, MS-Power Point, MS-Project, SharePoint

Multimedia Tools: Adobe Photoshop, Picasa

UI Mockup Tools/Applications: Balsamiq, MS Visio

Bug/defects tracking Tools: JIRA, TFS, HP ALM, ServiceNow

Reporting/Data modeling: Tableau, Cognos 8 Suite, Star Schema, Snowflake- Schema, Fact dimension tables, Pivot tables, Erwin

Database/Language: SQL, Oracle, PL SQL

Methodologies: Waterfall, Agile (Scrum, Kanban and XP)

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Business Analyst

Responsibilities:

• Responsible for status reports to PMO, senior executives and stakeholder/end user expectations.
• Created Business Requirement document (BRD) & (FRD) and maintaining teh Requirement Traceability Matrix (RTM) related document.
• Contracted to conduct business process analysis and identify key issues, gaps and needs for an established multi-divisions. Performed business process GAP analysis and identified teh areas to improve teh efficiency of teh business process. Created business process mapping document, analyzed teh as-is business processes and created a to-be process using MS Visio.
• Generated documents supporting accounting/ financial current and potential reports (e.g. Acquisitions, production support, change management etc.), as per teh business requirements.
• Have provided E-commerce solutions for Confidential connect application used Google analytics.
• Daily use of complex Excel formulas and pivot tables to manipulate large datasets.
• Involved in Data Migration from legacy systems to SQL Server. Prepared project initiation plan documents, Design and Deployment documents and involved in UAT testing and maintenance.
• Fine-tuned teh stored procedures in PL/SQL for optimum performance dat saved teh users alot of delay time in accessing data from teh front end.
• Conducted working sessions with various client Lines of Business to identify potential data sources and assess data availability for report Submission.
• Coordinated with QA and UAT testing for Stakeholders to have demo and trail of end product before release.
• Report metrics for all reports related to project process, strategies. Worked on gap analysis and SWOT analysis report.
• Completed call tracking metrics through Track IT and Service Now.

Environment: Agile, SQL, SharePoint, MS Office, PL SQL,JIRA,, Service Now.

Confidential, Stamford, CT

Sr. Business Analyst

Responsibilities:

• Managed end-to-end application - planning, development, testing & support in complete Software Development Life Cycle.
• Analyzing, interpreting, updating & maintaining various asset class i.e. Equity, fixed income, Funds, Derivatives, Money markets, Corporate Action events, etc and effectively communicating with internal and external clients to deliver functional requirements like GUI, screens and interface designs
• Analyzed and BRD’s, Functional specification and reporting data specification documents and converted them into technical design and data mapping specification.
• Worked on teh presentations for teh workflow diagrams using Visio and PowerPoint
• Publishing financial reports to Cognos system and review and develop of various advanced excel based spreadsheets.
• Managed processes required to ensure timely and appropriate generation, collection, distribution, storage, retrieval, and ultimate deployment of project information and documentation necessary for successful communications across teh organization.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Maintained and modified reporting module documentation and SQL for teh Oracle Views, ensured integration with client reporting tools like Business Objects, Cognos and Crystal Reports.
• Created manual calculators for teh risk models & developed loss sensitivity analysis calculators for treasury risk management to be implemented in teh application.
• Guided QA team in creating and updating test ware automation repository using PL/SQL tool for future use (applicable to all data warehousing projects in Confidential ).
• Conducted periodic risk management training sessions for all teams to keep them updated with teh functional noledge required for developing & testing treasury risk management applications.

Environment: UML diagrams, Agile Scrum, HP Quality Center, SQL, Cognos, Microsoft Office (Project, Excel, PowerPoint, Word, Visio, and Outlook) Informatica, Oracle DBMS

Confidential, MINNEAPOLIS, MN

Business Analyst

Responsibilities:

• Responsible for gathering business requirements by conducting interviews with mid and senior management, documenting business process flows and creating detailed functional/technical specifications.
• Conducted JAD sessions, communicated and maintained strong working relationship with various business groups.
• Planned and monitored project budget/spending.
• Created requirements specifications, process models and business rules for E-Commerce solutions.
• Created and designed wireframes, using user-centric design techniques.
• Partnered with business users in identifying, prioritizing & resolving numerous functional issues by end users
• Proficient with Microsoft Suite and Mapping Tools. Managed documents in SharePoint 2007.
• Worked on requirements of teh 835 276/277, 278, 837 HIPAA EDI Transactions across enterprise.
• Involved in moving teh projects to completion on time, within scope, and on budget.
• Implemented migration from ICD-9- ICD-10 conversion.
• Managed project scope to ensure delivery was compliant to scope commitment.
• Tracked and managed product backlog, burn-down metrics, velocity, and task break-down.
• Developed Use Case, Activity and flow charts, wireframes with tools like Balsamiq.
• Writing complex workflows to help understand teh requirement for developers and act as first point of contact for any queries for stakeholders.
• Strong hands on following up with Business Analyst team, QA/UAT team and stakeholders.
• Prepared project status reports for technical team and Business. Facilitated project demos for business.
• Coordinated with Change board, approval process for all requirements to have timely releases.
• Raise tickets/issues with respective teams in teh event of production failures and get in touch teh respective teams to get teh issues fixed as earliest as possible.
• Monitor and stand for offshore follow-ups to make sure every job runs successfully and gets completed within allotted timeframe.
• Worked closely with Administrator for creating new users and to manage security.

Environment: SharePoint 2007, Microsoft Suite, MS Visio, Balsamiq, TFS.

Confidential, Des Moines, IA

Business Analyst

Responsibilities:

• Gathered Business Requirements, created Functional Requirements Document (FRD) and analyzed data workflows.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance, Life insurance policies, Nationwide annuities( Variable, fixed, Immediate, fixed indexed).
• Identified and developed Use Cases from teh business and systems requirements. Documented high level and detailed Use Cases to include all teh functionalities of teh new system.
• I worked with Policy center module, Claims center module and associated with Billing Center modules as well.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensured teh critical requirements were not missed.
• Provide customer service and support for Property & Casualty risk management needs.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Involved in generation of test data inputs for both positive and negative data to enhance Recovery/ Fail-over testing.
• Performed extensive Gap Analysis between teh Company's Legacy System and Policy Center System.
• Responsible for testing teh Quote & Online Purchase for both Auto and Home Property Insurance of teh customers.

Environment: Microsoft Suite, MS Visio, SharePoint 2007, Internal Project tracking tools, JIRA