SUMMARY

• Qualified professional with over 8+ years of extensive experience in teh field of Business Systems Analysis, working with teh technical staff to implement management and staff s business requirements into teh software application in Banking, Finance industry, and Healthcare Industry.
• Proficient in analyzing and creating Unified Modeling Language (UML) Diagrams such as Use case diagrams, Activity diagrams, Sequence diagrams, Data flow diagrams, Business flow diagrams using MS Visio and Rational Rose.
• Experience working in all phases of teh development life - cycle including requirements gathering, design, development, testing, implementation and post-implementation support.
• Working experience with SharePoint Designer, Designer Workflows, Web Based InfoPath Forms, Navigation Controls, Excel Services, Master Pages and Web parts.
• Extensively used MS SharePoint Designer 2010 to design workflows.
• Experience in 2 or more of teh following modules in EBS or PeopleSoft HCM: Core HR, Benefits, Time and Labor, Payroll, Compensation, Performance Management.
• Knowledge and hands on experience in configuring Oracle Cloud HCM, including Core HR, Benefits, Absence Management, Payroll, Compensation and Talent modules with proven project delivery through full lifecycle from requirements through deployment / support.
• Works directly in configuring all cloud computing modules, together with teh manager specialized in configuration.
• Provide status and issue reports to teh Project Manager on a regular basis.
• Involved in configuration of FACETS Subscriber/Memberapplication.
• Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETSand has good knowledge on FACETSbusiness rules.
• Did teh forward andbackward data mappingbetween teh fields in mainframe and FACETS.
• Experience in developing application using .NET framework 2.0/3.0/3.5.
• Successfully developed applications using WPF and WCF (3.0/3.5).
• Primary experience working with entity framework ADO.NET.
• Successfully deployed .NET applications on IIS 5, IIS 6, and IIS 7.
• Experienced in creating and analyzing artifacts and already existing past projects if exists or going through teh application to perform AS-IS analysis to extrapolate To-be analysis. However, this process was used as teh base for JAD and interview sessions.
• Hands on working experience in requirement gathering, reporting, documentation, process mapping, scheduling, planning, and data analysis.
• Conducted and participated in Joint Application Development (JAD) sessions with stakeholders and system users to collect teh software requirement specifications (SRS).
• Experienced in creating Test Plans thorough hands on experience with designing test cases covering all test conditions and eliminating redundancy and duplications.
• Proficient in using wireframes to visually support teh business rules and interaction requirements for a screen.
• Developed Requirements Traceability Matrix (RTM) using Rational Rose to trace each software requirement to test case.
• Experienced in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Risk Analysis and mitigation plan, Cost benefit analysis, and ROI analysis.
• Experienced in selecting and executing elicitation techniques such as Interviews, Facilitated Workshops, Focus Groups, Observation, User Task Analysis, Documentation Study and Surveys and overall Process Reengineering.
• Excellent knowledge of MS Office especially MS Excel, Power Point, Word etc.
• Knowledge on medical necessities, software validation and healthcare compliance auditing.
• Develop and maintain complex SQL queries for MS SQL Server and MS Visual Source Safe for extensive back end testing purposes.
• Strong experience in Business Analysis, Business Modeling, and Data Modeling.
• Proficient in creating UML Diagrams including Use Case diagram, Class diagram, Sequence diagram & Activity Diagrams using MS Vision.
• Extensive management background within varied sectors of teh healthcare industry including HMOs, PPOs,Integrated Hospital Systems, Out-Patient Surgery Centers, Dental, and Vision.
• Strong knowledge of gathering requirements for Medicaid Management Information System(MMIS) session.
• Knowledge of health care services regulatory environment in compliance with HIPAA, ICD, and EDI.
• Thorough knowledge of HIX, PPACA, HIT, HIT Governance Policy and HL7.
• Proficient in business requirement gathering and writing, including teh EDI transaction from .
• Detail understanding of ICD 9/ANSI/HL7 to ICD 10/ANSI/HL7 coding standards in Medicare and Medicaid domains of teh healthcare industry.
• Experienced in provider and payer systems, including Electronic medical records (EMR) and revenue including Medicare and Medicaid projects.
• Experienced in working with HIPAA ANSI X12 4010A 270/271, 276/277, 834, 835, 837 for institutional, professional and commercial claims, and up-gradation of ANSI 4010 to ANSI 5010.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks. Expertise in Project Management i.e..Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experience in UNIX shell scripting, Perl scripting and automation of ETL Processes.
• Prepared user requirement documentation for mapping and additional functionality.
• Extensively used ETL to load data using Power Center / Power Exchange from source systems like systems likeFlat Files and Excel Files into staging tables and load teh data into teh target database Oracle.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling,Business Analysis and Testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups,conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Managementwith Project team members.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Productknowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems,Health Insurance, Auto Insurance and Crop Insurance.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfalland Agile.
• Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams,Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysisand Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Facilitated Change Management across entire process from Project conceptualization to Testingthrough Project Delivery, Software Development and Implementation Management in diverseBusiness and Technical Environments.
• Responsible to Track, Document, Capture, Manage and Communicate teh Requirements usingRequirement Traceability Matrix (RTM) which halped in controlling numerous artifacts produced bythe teams across teh deliverables for a project.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generationto assure that all aspects of a Project are in Compliance with teh Business Requirements.
• Proficient in DMAIC
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and actas their customer interface point as teh lead of teh Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, ProvenCommunication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Programming Languages: C, C++, HTML, XML, SQL.

Data Base: MS Access, Oracle (SQL Series), DB2

Project Management: Microsoft Project, Microsoft Office, OLAP Crystal Report

Operating Systems: MS-DOS, Windows95/98/NT/2000/XP, Apple McIntosh, Linux

Software: MS Office Suite(Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes

Performance Testing Tools: Virtual User Generator, Load Runner

Processes/Technologies: Rational Unified Process (RUP), Waterfall, UML & Microsoft Office SharePoint 2007

Automation Tools: Requisite Pro, Win runner, QTP, Test Director, Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Silver Springs, MD

Sr. Business /Data Analyst

Responsibilities:

• Established a RUP (Rational Unified Process) centric business analysis methodology.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Provided key initiatives in working with users in defining project and system requirements.
• Provided inputs in teh strategic development of detailed project plans, work assignments, target dates etc.
• Developed teh workflow to produce teh output for teh user in Pega Systems using html.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict teh workflows to be incorporated into teh development of Pega Business Process Management (BPM) tool.
• Responsible for teh development of a Data Warehouse for personal lines property and casualty insurance.
• Designed and Customized data models for Data warehouse.
• Designed three research systems involving; geographical locations, weather damage, and cause of loss for insured crops.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Facilitated teh User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from teh right parties.
• Exposed to Agile methodology.
• Designed teh business requirement collection approach based on teh project scope and SDLC methodology.
• Processed annuitant transaction to move their payout investment from one separate account to another.
• Experience in managing teh changes in requirements by Unified Change Management Tools (UCM) like Rational Clear Quest.
• Tested validity and integrity of teh calculation engines for Deferred Annuities, Past Services Pension adjustments.
• Design and develop teh data load process using XML Style sheets and ACORD.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Performed requirement analysis, went through all teh use cases and issue logs.
• Developed strategic partnerships with teh business unit to prepare a solid knowledge base of teh business line, including teh business plan, products, and process’ and revenue streams aimed towards problem solving.
• Helped design scope documents and teh Request for Proposal (RFP) after extensive ROI analysis and coordinated with top management for teh approval process.
• Functioned as teh primary liaison between teh business line, operations, and teh technical areas throughout teh project cycle. Worked with ODS and OLAP system. Worked with Data Extraction, Transformation and Loading. Metadata architecture was also provided, for teh purposes of query enhancement and clarification of data relationships. Also built teh foundation for process implementation in MS-SQL.
• Conducted mass user interviews with brokers, enterprise user representatives and SMEs.
• Worked extensively with MS Excel.
• Partnered with teh technical areas in teh research and resolution of system and process problems especially related to Power Builder platform.
• Provide customer service and support for Property & Casualty risk management needs
• Played a key role in teh planning, testing, and implementation of system enhancements and conversions.
• Created customized report using OLAP Tools such as Crystal Report for business use.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Guided development team in teh Oracle 9i based database.
• Assisted in presenting reports and analysis to halp guide teh management.
• Organized cross training of team members and users to become more responsive.
• Assisted in development of training materials for new technology and process improvements.

Environment: Erwin 9.5, Work bench, crystal reports 9, Jira, Github, Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .NET, Oracle, Crystal reports, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner

Confidential, San Jose, CA

Business Data Analyst

Responsibilities:

• Prepared ad-hoc reporting to enable teh sales operations to prioritize teh SAVM accounts based onbookings and P2B, SFDCpipeline.
• Collect teh data, scrub teh data, analyze teh data and interpret teh data.
• Performed Data validation using SQL scripts to identify teh duplicate records and performed data profiling to identify teh anomalies in a metadata.
• Validated data coming from third party data providers to ensure data quality and re-usability through data profiling and source to target mapping and provided scalable solutions to ensure data quality.
• Created Quarterly reports to show overallpipelinevalue by division and by key accounts, along with segmenting all sales leads in teh CRM system by estimated value, sales stage, close probability, and expected close date.
• Involved in development ofInformaticamappings/sessions/workflows to load teh data related to Customer, sales Hierarchy.
• Pull data from different sources like Sql server, applications (SFDC) and Flat Files usingInformaticaPower center 9.5.1 and loaded it into Teradata.
• Exportingdatafrom RDBMS toHIVE, HDFS andHIVE, HDFS to RDBMS by using SQOOP.
• HiveQL scripts to create, load, and query tables in aHive to perform analysis on webex customer’s.
• Identification & cleansing of incorrect information including duplicates, bad addresses and other "quarantined" accounts to identify "winning" and "losing" accounts based on agreed business logic.
• Mapping of CI account structures to Salesforce Accounts.
• Generated reports based on data pulled from FINBI, SFDCPipelineReport, other.
• Created comprehensive and accurate functional specifications; Data Mapping, and process flow.
• Gathered Requirements, interacted with teh Project lead and SMEs to get a better understanding of teh Business Processes.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created differentKPI'susingTable calculationsand calculated key figures Manipulating Strings, Arithmetic Calculations, Aggregation Options and Logical functions.
• Developed a360-business dashboardwithmultiple panels and Parameters.
• Created actual sales and target sales view withTrend lines, Table Calculationsto see teh difference between each quarter.
• Developed various POC (proof of concept) models based on teh minimal availabledata.
• Developed Complex cross tab Reports. Used advance charts like Dual Axis charts, Bullet Graphs, Stacked bar, Trend Analysis, Histograms in Data Visualizations. TEMPEffectively used context filters, action filters and data source filters to improve teh performance of teh reports.Actively involved in testing new/upgraded features like new Visualizations, Forecasting,Data Blending, Dashboard etc. in Tableau.
• PerformedTableau Adminduties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in teh Tableau Server.
• Restricted data for users usingRow level securityandUser Filters.
• Created complexStored Procedures, triggers, cursors, tables, viewsand other SQL joins and statements for applications.

Environment: Microsoft Sql server, FINBI SAP BO, Salesforce, Informatica, smart sheet, UAT, Puma, Microsoft office, Agile, Anaplan, Oracle, Hadoop.

Confidential, OH

Business/Data Analyst

Responsibilities:

• Gathered requirements for business process flow and onscreen flow for wizards driven products from products SME's and Sales people and created Requirements documents to implement in Pega PRPC.
• Created Business Rules Document and Requirement Traceability Matrix to track teh requirements for Pega PRPC.
• Communicate with Customer Service on ACORD Forms design and other technical problems.
• Used SDLC (System Development Life Cycle) methodologies like teh RUP and teh waterfall.
• Created functional requirement documents for teh impacting projects.
• Performed criteria table updates for each project.
• Updated teh impacted MS Access tables.
• Worked extensively with MS Excel and MS access.
• Developed test plans with QA team and halped to develop test cases for system testing, integration testing and performance testing.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.Involved in Risk Assessment for each project. Gathered high-level requirement for all teh external projects in a release.Gathered high-level requirement for all teh external projects in a release.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed.
• Negotiated with teams from projects to decide if modules should be implemented independently, or Parallelly.
• Analysis of business requirements and system requirements of teh client and also for Property and casualty modules.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all teh impacting projects and updated teh documents based on recommendations (if any).
• Created UAT plans with several test cases for each project to ensure that teh system runs smoothly after teh proposed enhancements or changes has been made.
• Reviewed test results and coordinated with testing and development team to correct teh issues.
• Developed timelines for project delivery, and managed projects/resources
• Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining teh Data Process Models.
• Responsible for preparing Business Requirement Document (BRD) and tan translating into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
• Documented and delivered Functional Specification Document to teh project team.
• Used MS Project to manage schedules, deadlines and resources and collaborate on teh project.
• Interacting with teh developers on resolving teh reported bugs and various technical issues.
• Assisted teh QA team in designing teh Test Plan and Test Cases for User Acceptance testing.

Environment: Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, C#. DOORS, C++, NET, ASP.NET, Business Objects, TestDirector, LoadRunner

Confidential

Business Data Analyst

Responsibilities:

• Used teh guidelines and artifacts of teh RUP (Rational Unified Process) to release multiple iterations of teh deliverable over teh span of teh project lifecycle, propounded early development and base lining of a robust executable architecture.
• Participated in teh identification, definition and documentation of impending work flows for teh purpose of migrating to a superior version of party information system.
• Facilitated JAD (Joint Application Development) sessions to identify business rules and requirements and tan document them in a format that can be reviewed and understood by both business people and technical people.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Analyzed existing data to identify critical data elements, perform source to target data mapping, elicit data requirements and converted them into BRD and SRS.
• Performed extensive data modeling to different between teh OLTP and Data warehouse data model.
• Used SQL*Loaders to load bulk data from various Flat Files used SQL for DDL commands utilized SQL to create Risks signals and Extract large subsets of data.
• Handled teh development of Business Requirement Documents (BRD) resulting from JAD sessions.
• Wrote clear, concise detailed System Requirements Specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop teh application with minimum guidance. Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Used Rational Clear Case and Clear Quest as Configuration Management and Change control tools.
• Prepared Business Process Models that includes modeling of all teh activities of teh business from teh conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.

Environment: RUP, UML process, MS-Office suit, Windows NT/2000/Vista, crystal reports, Business objects, dot NET, Delphi (Borland Suit), Mainframe.