SUMMARY

• Eight years of IT experience in Business Analysis and financial analysis: Requirements gathering, Analysis, Design, and Documentation and Project implementation.
• Experience in working towards projects in Finance, Healthcare and Insurance sectors.
• Experience in health care, Claims,, Eligibility, Pharmacy, DRG, diagnosis - ICD9 / 10 code mapping.
• Experience in Medicare, Medicaid and Commercial products.
• Experience in ICD9, ICD10, CPT, DRG codes and other Encounters.
• Experience in gathering business and functional requirement, developing process flow diagrams, data analysis, generating financial reports and maintain (KPI) dashboards.
• Thorough understanding of all the phases of Software Development Life Cycle (SDLC) and specialized in different models like Rational Unified Process (RUP), Agile, and Waterfall.
• Experience as a financial system analyst providing system solution, implementation, testing, upgrades on financial system (Oracle, SAP, ERP, and Financial Reporting).
• Extensive knowledge of data warehouse, data mining and modeling. Skilled in BI tools, including report and query writing. Strong use of SQL, PL/SQL MS Access, TOAD.
• Experience in Project management, designing, implementation, preparing project plan and testing.
• Knowledge onBusiness Objectstools includingCrystal Reports, Business Objects.
• Extensively used ETL methodology for supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solutions.

TECHNICAL SKILLS

Computer knowledge: Advance MS Excel, MS Word, Power point, MS Project, MS Visio, UNIX, Dreamweaver, VBA.

Programming language: C, C++, Database (SQL), PL/SQL, T-SQL

Software: Arena Simulation, SAP ERP.

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential

Responsibilities:

• Gather business/ system requirement and prepare user documentation. Translate business requirement into functional requirement.
• Perform claims,, eligibility data integration, interface and audit. Work with IT & Finance team to resolve BI issues. Worked on BI tools for reporting and data analysis, performed monthly audits and generate monthly financial reports.
• Worked Medicare, Medicaid and Commercial products. Perform data analysis on Medicare member.
• Worked on data integration for ICD9, ICD10, CPT, DRG codes and other Encounters.
• Work on medical claims,, eligibility and pharmacy reporting. Worked on DRG codes, diagnosis - ICD9 / ICD10 code reporting process. Worked with external clients like BCBS, HPHC TUFTS for medical claims details.
• Perform business process design and process modeling, using MS Visio.
• Strong experience in documenting business workflow, creating process flow diagrams, process improvement, reengineering by using MS VISIO and MS office products.
• Liaison with cross-functional teams to develop Healthcare Claims Processing system, Healthcare portal, Care Management solutions.
• Work on Data warehousing project, data mining, and data integration. Develop technical specs, interfaces ETL process, data mapping for IT programming. Manage financial data flow from various sources to the data warehouse.
• Worked on Financial reporting system (Oracle, SAP, ERP, EPIC, HPM and HBI) for reporting across business units and maintaining KPI dashboard
• Experience working on data warehousing writing SQL, PLSQL queries for report generation. (ETL, data mapping,datamigration).
• In depth knowledge of RUP, Agile, waterfall Software Development Life Cycle (SDLC) processes.
• Interact with clients, internal system users to create business process, develop design documentation.
• Used tools like TOAD, SQL, Oracle, MS Access, Excel, for data analysis and reporting.
• Performed (UAT) using used cases and diagrams in up-gradation project of financial system.
• Write SQL queries in database, resolve data warehousing and data mining issue.

Business Consultant

Confidential, CA

Responsibilities:

• Conducted JAD Sessions to show the effects of Cost of Debts, Cost of equity and SML (Security Market Line).
• Participated in business requirements meetings with the business sponsors, end-users and business analysts to gather end-user requirements
• Performed GAP analysis to identify the various existing processes and analyzed the process based on end user requirements.
• Used Rational Unified Process (RUP) for preparing Functional Requirement documents
• Designed and developed project document templates based on SDLC methodology.
• Developed business requirement specification documents as well as high-level project charter.
• Designed and implemented basic SQL queries for QA testing and report.
• Involved in SDLC including requirements gathering, designing, developing, testing, and release to the working environment. Developed and maintained Requirement Traceability Matrix (RTM).
• Prepared Data modeling and Data Mapping document for data elements and data cleansing that were used for Current and New system in MS-Excel.
• Business and systems analysis of the business reporting requirements and translated the requirements to a technical specification for them to be deployed within the SAP Business Objects Data warehouse.
• Lead a team to develop the reporting set to be delivered via Business Objects.
• Data analysis and reporting using strong - Excel, Crystal Reports and MS Access.
• Develop the SQL codes as well as use ETL tools to Data Cleansing, Data Mapping and conversion rules and applications.
• Maintain reports and dynamic dashboards with use of tooltips and highly customized features like subtotal, alerts, derived metrics, color coding, drill maps etc. to better understand about business trends.

Business Intelligence Analyst

Confidential

Responsibilities:

• Interacted with Users, Developers, Project Manager and SMEs to understand the business processes, identify enhancements and gather Requirements.
• Work on different Insurance Products, contracts and liabilities.
• Create strong financial risk analysis and maintain the KPI dashboard.
• Perform monthly/ quarterly / yearly Claims reporting process.
• Participated in the identification, understanding, and documentation of requirements including the applications capable of supporting those requirements.
• Prepared Use Cases, Activity Diagrams and Sequence diagrams by using MS Visio.
• Conducted JAD sessions with the stakeholders at regular intervals.
• Documented project related artifacts and sent them for onsite review and stored them in the MS SharePoint site.
• Wrote use cases, designed wire-frames and workflow diagrams to supplement the business requirements and mapped the use cases to corresponding business requirements.
• Accessed data from data tables using SQL queries.
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources.
• Created and developed thestored proceduresto handle complex business rules, history data and audit analysis.
• Reviewed analysis and test plan documentation updates and evaluated the results of the test execution.
• Designed data processing technology and built logical and physical MSSQL database models.
• Resolved Data Warehouse MSSQL database performance issues by improving its architecture.
• Advised new improvements on the reporting tools, used in the MSSQL database.
• Provided programming, testing, performance tuning, and production support on Oracle database.
• Reviewed analysis of benefits and different claims products.

Business Analyst

Confidential

Responsibilities:

• Was involved in project management activities, like project planning, development and testing for developing operational reporting system.
• Worked on developing system for operations, inventory, logistics and maintaining the KPI across the business units.
• Work on SDLC process for application development. Gather business requirements translate into functional requirements; generate workflow process and necessary documents to improve reporting structure.
• Worked with the SME’s to define business critical needs and analyze the possible technical solutions.
• Designed data processing technology and built logical and physical MSSQL database models.
• Provided analysis of database work.
• Conducted joint requirements planning (JRP) sessions as a facilitator to gather requirements from the business area and to discuss different critical success factors of the project like Operational Feasibility Analysis, Technical Feasibility Analysis, Cost Benefit Analysis & etc.
• Business Intelligence experience for data warehousing, data mining and reporting.
• Performed end user testing for system upgrade and conversions projects. Created test cases for testing at each phase of the upgrade project.
• Assisted Project Teams in preparingSoftware Requirement Specifications (SRS),Software Design Documents (SDD),user Interface Design to develop operational system.
• Define & updating project milestones, schedules, monitoring progress usingMS Projectand updating plans as required.