SUMMARY

• 7 years of experience as a Business Analyst with the ability to understand and analyze complex business requirements. Have a detailed and thorough understanding of various domains like Finance/Banking, Credit Card and Healthcare.
• Hands on Expertise on Requirement Gathering, systematic analysis of the requirements, Joint Application Development JAD sessions and use of Rational Requisite pro for requirement Management.
• Analysis of Business requirements with Use Case Diagrams, Class Diagrams, State Diagrams, Sequence and Collaboration diagrams for Intranet Based Applications Development using backend Oracle, MS Access and MS SQL Server.
• Strong experience in Data Analysis, Data Cleansing, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Writing Test Scripts to make sure the end product is actually according to the requirement of the Clients for Web Based Applications as well as Intranet based applications.
• Defined business requirements and successfully re-engineered business processes for various industries/sectors like, Healthcare and Finance.
• Delivered business process models and derived Process Improvement initiates that met IT application requirement process.
• Good Understanding of Data warehousing DWH and Business Intelligence BI concepts with emphasis on ETL
• Experience in implementations involving client side Technologies such as Java
• Experienced with EDI Transactions and HIPAA, ICD9/ICD10 and complete Heal Insurance Policy Administration modules including Underwriting and Claims transactions in healthcare.
• Experienced in Federal State Government reporting regulations related to Medicare and Medicaid
• Extensively involved in all the phases of SDLC, requirement analysis and Graphical user interface GUI business specification, development, enhancement, quality assurance, testing methodologies and implementation.
• Authored business and system requirements analyses and functional specifications with supporting business process flows data modeling , Traceability matrices, risk analyses and concept of operations for systems utilizing company standards, processes, and procedures.
• Conducted Joint application development JAD sessions with relevant Subject Matter Experts to assess and document current configuration.
• Strong experience of creating Use case documentation from business requirements and/or existing application.
• Excellent knowledge in creating test cases for various stages of software testing.
• Functioned as a liaison between client and project team.

TECHNICAL SKILLS:

• SDLC Methodologies : Waterfall, Agile, RUP
• Modeling Tools Languages : Rational Rose, MS Visio, UML
• Project Management Tools : MS Project.
• Requirement Traceability Matrix : Rational Requisite pro, MS Excel
• Change Management Tools : Rational Clear Quest, MS Office, Snag-It
• Web Technologies : HTML, XML, LAMP,
• Operating Systems : Windows 2000, 2003, MS-DOS, LINUX.
• Languages : C, C , SQL, JAVA
• Databases : Oracle, SQL Server

PROFESSIONAL EXPERIENCE

Confidential

Business /SME Analyst

Job Responsibilities:

• Analyzed business processes, products and operations to create detailed business requirements and communicated them to the development team for the design and implementation of business solutions.
• Streamlined business processes through analysis, design, documentation of new processes and applications including risk assessments and mitigations, creations of process flows, change management, quality controls.
• Responsible for MS Business Intelligence Solution and reporting for enterprise and corporate business units using Cognos BI.
• Gathered business requirements and created functional specifications and use cases.
• Gathered requirements through a series of one-on-one and group meetings with the identified users and developers.
• Provided thorough documentation of all Business Intelligence MSBI applications and processes to be used in the event of equipment or system failure.
• Conducted technical meetings with the development team to finalize the ETL specifications and Reporting Release Plans
• Managing the planning, development, design, and implementation of Data warehousing ETL, Reporting Requirements across the enterprise.
• Designed sequence diagrams for all the use cases identified.
• Assisted in documenting BPM Business Process Model and process overview.
• Used Rational Unified Process RUP methodology and Rational Rose and Rational Requisite Pro for developing the use case diagrams.
• Involved in development specifications and schematics for forms using HTML and Java script to gather information from analysts to maintain and refresh the knowledge base.
• Facilitated meetings with clients and users across all departments to deliver business requirements.
• Involved in the design of Datawarehouse DWH using Star-Schema methodology and converted data from various sources to oracle tables.
• Managed and coordinated phases of Software Development Life Cycle.
• Interacted with different SME's to get a clear workflow analysis.
• Created AS-IS and TO-BE business process flow diagrams, integrated process flow diagrams to show one end-to-end business model.
• Technical Management of BI projects and instruction in ETL Informatica development, SQL, Oracle and Business Objects.
• Identified issues involved in the integration.
• Coordinated UAT User Acceptance Test testing by writing test cases, training end users and giving demonstrations along with documenting and resolving the issues.
• Provided testing assistance and guidance in order to ensure accurate requirements fulfillment.
• Assisted technical team in understanding and developing the appropriate functionality.
• Performed strategic planning activities and built test case scenarios to ensure requirements are being satisfied.
• Allocated timelines using MS Project by scheduling meetings with developers and testers.

Confidential

Business Analyst

Job Responsibilities:

• Responsible for gathering and analyzing Business and system functional requirements and for understanding and translating these needs into Business Requirement Specification BRS , System Requirement Specification SRS documents, Conceptual design document CDD , Client requirements document CRD , and Functional specification document FSD .
• Creating use case scenarios and documents work flow and business process.
• Prepared use cases and data flow diagrams to analyze the impact of ICD10 diagnosis codes embedded in different systems and applications.
• Identified information and analytical needs of business users with regard to data analytics, Business Intelligence BI .
• Facilitated study of each source system to identify the data that needed to be mapped and extracted using ETL understood the reporting requirements ensured it was documented and communicated to Business Objects Team.
• Followed the Rational Unified Process RUP methodology of iterative software development with its various workflows, artifacts and activities.
• Business reporting analyst using MS ACCESS, BUSINESS OBJECTS, and EXCEL, tracked, analyzed, and reported.
• Provide Business Intelligence BI analysis to decision-makers using an interactive OLAP tool.
• Working with the development and implementing the new designs of the layouts between ICD-9 and ICD-10 crosswalk.
• Prepared the system requirements and Functional Specifications Documents for the Data Modelers and the ETL Teams for Card Data Warehouse. DWH
• Responsible for conducting gap analysis as is to be for ICD9 and ICD10. Prepared Data Flow Models for code sets validating in Facets and Claim Process Engine.
• Supporting IT unit creating functional specification documents for the design, development and implementation of project.
• Staging and loading delta feeds in to the Data Ware house DWH using a Transformation ETL.
• Utilized corporation developed Agile SDLC methodology.
• Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Used General equivalence Mappings GEM to convert ICD 9 to ICD 10.
• Validating imported and exported files in different format and preparing layout charts for the data transports.
• Supporting, Assisting and advising Project Director and Program Manager from time to time for Project Management and taking decisions on various aspects of the project like performance metrics and non-functional requirements.

Confidential

Business Analyst

Job Responsibilities:

• Created functional and non-functional requirement documents and technical specification documents and delivered within project timelines by conducting user interviews for requirements gathering, analysis, and design.
• Wrote SQL query to extract data from the tables to validate data flow.
• Created SQL scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
• Worked with Fixed Income Business users to facilitate technical team with functional aspects of various capital market instruments.
• Interface with the business leaders and end users to identify areas to leverage MicroSoft Business Intelligence MSBI
• Facilitate meetings with front office /middle office desk supervisors, Market Risk managers and subject matter experts to breakdown source data analysis associated to the KRIs key risk indicators .
• Perform credit risk and Market risk assessments of new customers.
• Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle SDLC to discuss open issues and resolve them.
• Used SQL queries to transfer data from the server to the web page. Conducted presentations on the progress of the project after ever phase of SDLC based on RUP methodology.
• Skilled at performing GAP analysis, User Acceptance Testing UAT , SWOT analysis, Cost benefit analysis and ROI analysis.
• Met with client groups to determine User Requirements and Goals, thus converting User Requirements and Business Requirements into Functional Requirement Specifications.
• Assisted with Manual and User acceptance testing of the systems UAT , developing and maintaining quality procedures and ensuring that appropriate document is in place.
• Identifying and measuring risk ledger faced and calculating credit risk, making decision on the applications and preventing loss by evaluating credit risk.
• Facilitated UAT and test strategies with developers and testers and performed manual front-end testing to check all the functionalities incorporated with the different modules. Involved in UAT session to test the system with stakeholders.

Confidential

Business Analyst

• Forecast and monitor North American and Indian market trends.
• Analyzed of bank volatility, assigning limits and exposures based on CAMEL and BASEL II guidelines.
• Create recession analysis model and risk model analysis for Insurance companies.
• Analyzed for potential governmental system breakdown and changes.
• Performed and recommended steps to analyze and upgrade the existing process in order to increase the efficiency.
• Designed and demonstrated technical solutions for international clients
• Proficient to analyze and document business requirements and system functional specifications.
• Executed in a team to determine the control strategy of the process and documented steps for process automation.
• Performed required GAP analysis, User Acceptance Testing UAT , SWOT analysis, Risk Analysis and mitigation plan, Cost management and ROI analysis, feasibility studies and to define scope efficiently.
• Worked extensively with the stakeholders and with different levels of management to identify requirements, business events and to develop functional specifications for the lending procedures.
• Provided projects with pre-project planning expertise high-level and detailed project
• Tracking Central bank's policies and interpreting data for internal policy modification.