SUMMARY

• Result oriented professional with 15+ years experience in IT projects spanning Financial, Healthcare, Annuities Insurance, Consumer Products industry verticals of which 8+ years as Business Analyst in Business Problem Definition and Reduction, Business Process and Data Modeling, Project Scoping Techniques, Cost/Benefit Analysis, Requirements Capture, User Story Definition, Requirements Clarification and Requirements Confirmation.
• Excellent facilitation skills in conducting JAR, JAD, walkthroughs, brainstorming, surveys, questionnaires, Prototyping sessions with business stake holders, SMEs, development team, QA and upper project management.
• Excellent skills in eliciting, analyzing, and documenting requirements on business needs, processes and policies for Enterprise Data Warehousing, designing Business Intelligence applications on tools like MicroStrategy, Tableau, COGNOS.
• Quick in familiarizing custom built legacy applications and new technology applications and excellent analytical ability to articulate enhancements functionalities in existing systems to meet changing business processes and requirements.
• Expertise in liaison among business stakeholders, technical and analyst groups to take business challenges and opportunities in the context of requirements and recommend solutions that enable the organization to achieve its goals and help increase its productivity, cost efficiencies etc.
• Adept in designing business models from user requirements and analyzing legacy applications systems for rewriting or enhancing custom applications or integrating them with the latest technologies.
• Expertise in prioritization of business requirements while factoring in technical feasibility, resource estimates for result oriented solutions.
• Strong analytical skills for creating and maintaining relationships between business objectives & requirements with solution components by identifying and documenting the lineage of each requirement including backward/forward traceability.
• Facilitate impact analysis process to evaluate proposed requirement changes to business stake holders.
• Strong business acumen, strategic thinker with good interpersonal and presentation communication skills clients,external vendors and internal business partners
• Strong work ethics and adherence to business protocols and guidelines.

TECHNICAL SKILLS

Business Intelligence Tools: COGNOS report tools, MicroStrategy, Tableau

ERP & Databases: SAP R/3, MS - SQL SERVER Oracle, IBM DB2

Languages: SQL, PL/SQL, MFCOBOL, Pro*Cobol, Visual Basic.

Office Management Tools: MS Office Suite, MS Project, MS SharePoint. MS Visio

Other Tools: SQL*PLUS, MF Net Express 3.1, VISIO, Quest TOAD, Unix Vi Editor, SPF editors

Quality Tools: Informatica Data Analyst, HP ALM & Quality Center.

Methodology: SDLC (Waterfall, Iterative), Agile (SCRUM), BEAM methodology

Project Tools: Rally, IBM Rational RequisitePro

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst

Responsibilities:

• As a Sr. Business Analyst conducted JAR & JAD sessions with the finance, operations, marketing line of business to define and document business requirements for a new data warehouse initiative called Insurance Solution Data Warehouse (ISDW) with BI Dashboard capabilities in Scrum Agile methodology.
• As a member of Business Architecture and Analyst group was instrumental in identifying and defining business processes at conceptual and logical levels depicting current and future states.
• Was responsible for generating various business analysis related documents like business requirements, functional specifications, business rules for source to target data mapping, enterprise business data dictionary and requirement traceabilty matrix resulting in precise definition of business needs and its traceability with the solution implementation.
• Successfully demonstrating the ability to accurately estimate costs during requirement and development phases and worked closely with PM with recommendation on project plans within budgetary guidelines.
• Worked closely with system analysts, data modelers and architects team in defining the system functionalities on IBM Rational RequisitePro and solutions from business requirement perspective
• Working closely with QA team to establish the testing strategies and support the team with business clarification on testing strategies and help manage the defects using HP Quality Center.
• Leading UAT effort with business product owners to document test plans and its execution and identified entry and exit criteria for successful completion of UAT phase.

Confidential

Sr. Business Analyst

Responsibilities:

• As a Sr. Business Analyst for Global Wealth Management Data Mart Group, am responsible for organizing and conducting JAR & JAD session with business stake holders and deliver business requirement specifications, business cases, functional & non-functional specifications and own requirement traceability matrix artifacts to deliver future state architecture to support applications managing BOA Merrill Lynch high end clients’ assets.
• Conducting elicitation and JAR sessions with new line of business for gatherings requirements for building a cohesive data warehousing solution using BEAM methodology to meet all BI reporting needs on customer asset management and ROI using MicroStrategy reporting tool on Microsoft SQL Server.
• In prior assignment, successfully conducted JAR sessions in gathering requirements and functionalities for rewrite of an application called “Edge Book Segmentation Tool” application on Microsoft SQL Server using dot Net & SSRS technology with data sourced from multiple mainframe legacy systems.
• Managed & conducted JAD sessions successfully during functional design specification phase with business SMEs, architects, engineers’ data modelers and development leads of the project on application future state.
• During elicitations created business use cases, business user stories, wireframes, prototype models and work flow analysis to support & facilitate clarity on new business needs and to articulate concise direction on enhancements from current state of application.
• Managing & guiding team members work efforts with reviews and recommendations to help identify redundancies and duplications on workflow and efforts and help build cooperative team.
• Playing a key role in the project by reviewing and recommending changes to system requirements from business requirement perspective with project engineers and architects.
• Worked closely with business stake holders and SMEs to strategize for successful execution of UAT plan which was highly commended by the business, supervisor and peers.
• Working closely with QA team to establish the testing strategies and resolving and managing defects list on HP Quality Center application.
• Strategize and execute work details with project manager of the application on product rollout. The application was deployed successfully in May 2014 as per schedule with very minimal defects.
• As a member of process improvement committee identified and suggested key areas for process improvement which was approved and implemented by committee.
• Successfully demonstrating the ability to accurately estimate costs during requirement and development phases and worked closely with PM with recommendation on project plans within budgetary guidelines.
• Working closely with the offshore / onshore development & QA team members to provide analysis on source to target data mappings for ETL jobs, define the data dependencies with various source information.
• Actively participating in various seminars and training session conducted by the client to get necessary specific additional skills and to get a better understanding on higher management policies and directives on projects.

Confidential

Business Analyst

Responsibilities:

• As a Business Analyst was responsible for creation of deliver business requirement specifications, business cases, functional & non-functional specifications, Requirement traceability matrix artifacts for enterprise warehouse model called Actuarial information factory (AIT) for Traditional Annuities & for new line business product called “Pru Inside”.
• Received recognition from business and upper management groups for excellent business elicitations resulting in clear and concise requirements documents.
• Successfully shaped cohesive requirements for Hedge and Actuarial business groups for “Pru Inside” and traditional Annuities line of business with data sourced from 3 mainframe legacy applications spanning 5 subject areas for enterprise data warehouse, rewrite of Algorithmic Trading Contingency application & Data Hub activities reporting using Cognos.
• Successfully created business use cases/business user stories, prototype models, work flow analysis to articulate the enhanced requirements from both existing and new line of businesses.
• Led strategic work plans for design and development of BI enterprise warehouse for interim and strategic solutions with COGNOS reporting layer with Data Stewardship group, Data Modelers, System Administrator, Legacy application SMEs and business representatives, Architects & Engineers.
• Profiled source data from different legacy source systems for anomalies and in defining enterprise level business definitions.
• Using Informatica Data Analyst tool identified gaps and overlaps in data models and made recommendations for changes in target state and legacy applications resulting in successful design meeting the business requirements.
• Acted as mentor in building a cooperative work team and to identify redundancies and duplications of work efforts across projects.
• Successfully reviewed and recommended changes to system requirements document for integrated SOA clusters architecture for Enterprise Service Bus using canonical models with XML for Annuities Information Technology enterprise data warehouse.
• Planed and led UAT test plans execution and developed process to track defects and issues and identified entry and exit criteria for successful completion of UAT phase.
• Was instrumental in tracking project artifacts to ensure minimum requirement defects and non-compliances from internal SDLC process audits on all projects.
• As a member of process improvement committee, identified and suggested key areas for process improvement which was approved and implemented by committee.
• Successfully demonstrated the ability to accurately estimate costs during requirement and development phases and worked closely with PM office to implement project plans within budgetary guidelines.
• Worked closely with the offshore / onshore development & QA team members to provide source to target data mappings for ETL jobs, detailed test plans and data dependencies for successfully completion of design and testing phases on time.
• Driven feasible solutions for various source system modifications and work flow implementations to meet the requirements of the business from data warehouse perspective.
• Successfully documented and established SOP document for defining and streamlining requirements by BSA roles on HP Application Lifetime Management tool.

Confidential

Business & Techincal Analyst

Responsibilities:

• As a Business Analyst was instrumental in facilitating, JAR, JAD sessions with client’s business functional heads, SMEs based in Europe and with stake holders at corporate office in Europe to elicit business requirements, User stories and functional requirements for development of enterprise data warehouse and COGNOS BI Reporting tool.
• Analyzed current workflow of legacy applications “SUMMIT” for gaps and additional requirements and developed prototype models, Use cases, technical documentation, system flow diagrams, application interfaces to meet the needs of enterprise warehouse & new BI reporting tool for business.
• Successfully communicated with end user group, SMEs, development team consisting of ETL, COGNOS offshore/onshore members using data and process flow models to convey the objectives of target state and clarify validate the requirements.
• Led strategic work plans between project management, functional & development teams for version controls and change management of applications under testing for product releases. Identified process gaps and recommended improvements.
• Defined and implemented security processes for user groups, user access levels to application and steer UAT for European users on BI application.
• Ensured testing, established QA standards through compliance with all established testing and quality procedures and documentation standards adhering to agile methodology.
• Developed excellent training materials for business users’ community and successfully conducted boot camps to introduce users to new BI reporting functionalities across 13 company’s Europe regional centers.

Confidential

Business & Techincal Analyst

Responsibilities:

• Developed and deployed chargeback enhancements of SAP supplied application “CPCC (Contract pricing and chargeback)” integrating with SAP R/3 - data repository on ORACLE 9i database and data exchange via EDI documents written in legacy MF-COBOL, Unix scripts with embedded SQL & PL/SQL.
• Analyzed current workflow of legacy application for gaps and additional requirements. Developed excellent business, User stories and technical documentation, system flow diagrams, Use cases, application interfaces with SAP and with third party applications.
• Conducted JAD, JAR sessions between onshore and offshore ABAP development team, SAP functional Analysts, EDI support team during system upgrades and integration phases and for defects resolutions.
• Validated completeness of EDI data loads & data transmission from CPCC application via EDI with wholesaler’s applications using appropriate reports and screens for data accuracy.
• As a single point of support analyzed test results during system integration and regression test phases for various SAP - OSS Notes patch updates and for SAP system upgrade to ECC 6.0 and successfully resolved with minimum downtime. Adhered to Agile process, standards and procedures as per FDA GxP regulations on all documentations for system upgrades and integrations.

Confidential, Philadelphia, PA

Lead Programmer-Analyst

Responsibilities:

• Successfully developed and deployed “HSA” (Health Saving Account) module on Health and welfare legacy application written in Micro focus-COBOL using Net Express 3.1, Pro*COBOL, embedded SQL PL/SQL with data repository on Oracle 8i databases.
• Conducted JAD sessions with project and QA teams on solutions for system defects and enhancements.
• Designed and implemented auto deployment jobs for propagation of binary units to Test/QA, and Production environments.
• Documented and reviewed high level test plans and test cases procedures, program specifications based on the functional requirement documents.
• Facilitated JAR sessions to evaluate system requirements, design plans with SMEs and development team during various SDLC phases
• Developed excellent training and help desk materials on new system enhancements.