SUMMARY

• Well experienced Senior Systems Analyst/Data Analyst/Business Systems Analyst with 10+ years of enterprise experience at CG, Confidential, T - Mobile, Blue Cross, Confidential Health Care System, and Confidential
• In depth knowledge of SDLC methodologies like AGILE, RUP, SCRUM and Waterfall.
• Strong knowledge in developing project plan and estimating project timeline.
• Expert in business process analysis/modelling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Efficient in writing various BRD, Technical Specification document, Use Case and Functional Specifications. Creating diagrams to extract business process and workflows design using UML, MS Visio, and Rational tool.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Helping development and quality assurance teams in understanding the requirements.
• Perform Gap Analysis to check the compatibility of the existing system infrastructure with new business requirements along with Risk analysis-risk engineering.
• Excellent Knowledge on HL7, Membership, Billing, Claims Payment Processing in relation to EDI 4010, ICD-9 ICD-10, codes 834, 837,835, and 270, 271.
• Worked on ad-hoc and canned reports in multiple projects to provide analysis and end results.
• Worked closely with Project manager on Project planning, scope diffing along with organizing meetings and supporting during UAT.
• Strong expertise in Health Insurance Claim process, Medicare and insurance and well versed with HIPAA, claim adjustments and processing from point of entry to finalize it.
• Well versed with client server environment and tools like SQL*Loader, UNIX shell scripts and TOAD
• In-depth knowledge data modelling and mapping and used various tools like Erwin and Power designer.
• Extensive experience with databases like Oracle, Teradata, SQL Server, DB2, and MS Access and Data Warehousing concepts and web design and development.
• Proficient in ETL implementation using SQL Server Integration Services (SSIS) from source to data warehouse.
• Experience in Designing, Creating, and maintaining reports extensively used BI process through My Sql server studio, WEBI reports and Domains (Security, Universe, Document) in Business Objects.
• Strong knowledge in Analytical, methodical, and resourceful approach to problem solving, identifying, and documenting root causes and corrective actions.
• Well versed knowledge of big data tool as Hadoop and virtualization tool Denodo.
• Hard working, positive thinking, self-starter with a strong goal orientation and good communication skills.
• Ability to inculcate new relevant skills with ease in a time sensitive frame.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, VC++, VB, VB.NET, C#.NET, ASP.NET, XML, Java, SQL

Scripting languages: VB script, JavaScript

Development Methodologies: AGILE, RUP, Waterfall

Databases: MySQL, SQL Server, Oracle, Teradata, DB2, SQL Developer

Business/ Automation Tools: MS Visio, Rational tools; RequisitePro

Bug Tracking Tools: HPQC, Jira, Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop, Rally

Reporting Tools: Crystal Reports, MSBI; SQL Server Reports (SSRS), Business Objects, Cognos

Data warehousing/other Tools: Informatica, Erwin, Hadoop, Denodo, Sybase PD

PROFESSIONAL EXPERIENCE

Confidential, Irvine CA

Sr. Business-System Analyst

Responsibilities:

• Works with Model team to understand the business requirement.
• Work as liaison between Argo Development team and business team.
• Analysis, design, programs, documents, and implements new systems and/or software programs.
• Prepare templates and process flow Diagram on Confluence and using Visio.
• Work with Testing team on testing the API payload through Postman and AWS service.
• Define Acceptance criteria and work on the User stories/tasks creation.
• Prepare API in MuleSoft and explain the process to Model team to test on business requirement.
• Create and manage documentation on confluence of APIs, Mapping, Model Servicing, and standards.
• Identify and define error codes document for development and centralized to use among all APIs, Services.
• Organize meetings with different teams to discuss functionality and development changes.
• Works with Dev team to understand the changes and blocker to resolve.
• Use AWS service to get extract and perform analysis.
• Use Toad and perform analysis against existing data, source data and find the gaps to fill in Target.
• Extensively use the Toad, Visio, Confluence and Excel for business representation to show the model structure.

Environment: Agile-Hybrid process, MS- Office Suit, VISIO, Enterprise Architect SQL Developer, Windows 10, Kafka host/FTP, SQL Server, SharePoint, Confluence, Jira Github and DevTest (LISA).

Confidential, San Leandro CA

Sr. Business-System Analyst

Responsibilities:

• Gather and review requirements with business and external team.
• Work as Lead cum Product Owner and participate in Planning, effort Estimation and Monitoring.
• Analysis, design, programs, documents, and implements new systems and/or software programs.
• Prepare Sequence, Process flow diagram by using Visio Enterprise architect using Gliffy Diagram on Confluence.
• Define Epic and write user stories for different functionality and maintain Jira board.
• Define Acceptance criteria and Write User Acceptance Testing (UAT) document.
• Prepare Solution Design document and maintain them on Project confluence page.
• Diligently work with other functional project teams on development and business changes.
• Identify and define error codes mapping document for development when error occurs during process and convert those status into customer facing language.
• Organize meetings with different teams to discuss functionality and development changes.
• Host daily stand-Up scrum meetings and refinement sessions along with backlog grooming.
• Works with UI development team to understand and develop the functionality as per requirement for operational search and reporting of wells on Payments.
• Define and validate the functionality development of various API’s in DevTest Virtual tool on dummy data.
• Well Knowledgeable in API modeling language and actively worked on Swagger to provide the detail for development.
• Participate in compliance/ technical meeting applicable to API’s
• Well familiar with REST and SOAP API web services.
• Review Business Criticality on MVP changes post MVP development.
• Prepare weekly project and team status reports and present to business during progress meeting estimation.
• Extensively use the Visio, Confluence and Excel for business representation to show the model structure.

Environment: Agile-Hybrid process, MS- Office Suit, VISIO, Enterprise Architect SQL Developer, Windows 10, Kafka host/FTP, SQL Server, SharePoint, Confluence, Jira Github and DevTest (LISA).

Confidential, Atlanta GA

Sr. Data Security-System Analyst/Data Analyst

Responsibilities:

• Participated in Project Planning, Effort Estimation & Monitoring for CERTIFI project.
• Identified requirements, perform feasibility study to identify the gaps and risk, design requirement documents for specification using MS Word and Rational tool.
• Extensively used MS Visio to develop the workflow of a given scenario in programming sequence.
• Acted as subject matter expert and liaison with other areas within RBAC on deployment.
• Defined deployment process to carry out the development and validation of assignation task.
• Reviewed business criticality and work on data storage structures, data mining, and data cleansing Identify and interpret trends or patterns in composite data sets.
• Cleansed, mapped and transformed client data to the desire schema and data standards.
• Worked on test design docs for new enhancements and Hotfixes for the existing system where needed.
• Closely worked with the web Development and testing team to review and resolve the issues of UI application.
• Defined Test Methodology to carry out the development and deployment SME validation process.
• Involved proactively in E2E testing with customer completely from onsite counterpart.
• Developed or modified procedures that solve complex business problems with due consideration for hardware/software capacity and limitations, operating times and desired result.
• Aiding in identifying possible solutions data security using statistical techniques and provide ongoing reports.
• Performed validation process after Role Assignment is prompt in Production.
• Provided support for Analytics Processes monitoring and troubleshooting to end users.
• System design, deployment, configuration and support Windows and Mac OSx environments.
• Evaluated system design specifications and produce technical documentation for new and existing specifications and Performs complex conceptual analysis.
• Wrote queries in SQL Developer to retrieve and refine the data for reporting purposes and for logical model.
• Extensively used the Pivot charts in Excel for business representation to show the model structure.
• Run Scripts to generate the reports through prod servers to review data issues and resolve the issues.

Environment: Agile-Hybrid process, SQL Developer, SQL Assistant 15.0, Windows 10, Passport host/FTP, SQL Server, SharePoint, MongoDB, CERTIFI, MS. VISIO, MS- Office Suits and Putty.

Confidential, Bothell WA

Sr. Business/Data Analyst

Responsibilities:

• Worked on multiple tracks as Finance, Marketing to develop and support transforming BI operating model.
• Dynamically worked in Hybrid and Agile Methodology from Sprint/backlog planning till retrospective.
• Worked with Portfolio Manager and Business groups to document and create Business & Technical Requirement Documents, Use-Cases, Wireframes, Scope Tracking and Traceability Matrix spreadsheets.
• Actively participated in Sprint meetings to work on the selected User Stories and aligned them on Rally tool.
• Created Change Request document and Participated in Change Control Board (CCB) meetings to present the CR for approval of different requirements.
• Led the SSA’s team to complete the documentation precisely for further development by Dev. team.
• Played a key role in mapping meetings with SME’s to complete and resolve the code logics, queries and get the correct mapping to design and deploy.
• Developed Source Mapping Documents to capture all the changes with logics and status.
• Closely worked with DA team on the S2TM development and Design in Power Designer along with review and finalize the S2TM/designing for Dev. team to deploy Hive Jobs.
• Assisted cross functional project teams with data analysis, data mining and data profiling as needed.
• Ensured developmental activities, changes are consistent and implemented properly in the system.
• Provided solutions to resolve problems related to EDI transactions when occurred as prioritized.
• Helped the team on creating Teradata views for reporting or further processing.
• Worked with CIS data Protection team on the data security and define the process to establish the CIS team approval mechanism.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit and regression testing.
• Provided QA/UAT support while code promotion and worked with QA’s to resolve any defects if found.
• Functioned with Data Warehouse team to understand repository objects that support the business requirement and process. Used sandboxes to explore data.
• Participated in Ingestion process to resolve the Ingestion issues and get the files on time.
• Closely worked with Hadoop team to delivered Pre-Prep and Prep jobs and to test the Mapping and identify the gaps and to understand the consequences.
• Used Putty to manage the files on different Servers and Informatica tool to get the results of each source table to review the data.

Environment: Agile process, Hadoop, SQL Developer, Teradata SQL Assistant 15.0, Windows 7, Power Designer, SQL Server, Denodo 5.5, MS. VISIO, MS- Office Suits, Putty, Rally.

Confidential, Quincy MA

Sr. Business / Data Analyst

Responsibilities:

• Involved in requirement gathering and was generating the Standards and templates for the data captured.
• Involved in project management using MS Project and created detailed functional specifications documents for development team.
• Worked closely with the Data Warehouse team to understand repository objects that support the business requirement and process.
• Involved in developing HIPAA EDI Transmissions. Work includes complete business cycle management and hands-on production as well and create EDI Testing process, documentation, and performance matrices.
• Worked and tested HL7 Message Validation and sending of ADT Messages like ADT A02.
• Ensured the changes are tested and fulfill the requirement as requested by State.
• Worked on Different HL7 interface messages and facilitate mapping along with migration from clients existing epic interface to CHIA Sends like Mirth.
• Worked with Different vendors to improve and support the EHR software, create document for modifications
• Monitored and resolved the bottlenecks in EDW for smoother process.
• Provided clear and concise documentation regarding requirements management plans, functional requirements, supplemental requirement.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server environment or through SQL adapter.
• Worked with development team to integrate the data through Datastage from mainframes and oracle systems to do ETL processing.
• Written SQL queries to verify data quality and the code logics implemented as requested.
• Closely work with SAS team to understand and convert the code with ODI developer into SQL..
• Analyzed multiple test scenarios and tested different files in WinSql to see the changes met the requirement.
• Worked closely with different Managers to develop the Specification Documents for capturing the process.
• Worked closely with Development team to understand the consequences.
• Participated to transform the data from one server to other by using SSIS.
• Worked with BI to create reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
• Worked on Vermont data in ODI with Tech and Buss teams on design and logic changes. Along with testing.
• Sent Reports to State through FileZila and Sends + tool of all claim types.
• Worked with Business on TME and REL to send through CHIA site and manage reports.
• Generated different types of Delimiters files and used Putty to manage the files on different Servers.

Environment: Oracle Data Integration (ODI), Windows 7, SQL Server, MS. VISIO, CSV files, FileZila, Sends+, Datastage, WinSql, MS- Office Suits, Putty.

Confidential, West Des Moines

Business Data Analyst

Responsibilities:

• Implemented and integrated hybrid solutions with complete line of traceability for all the artifacts of web development projects.
• Involved in customer segmentation, Portfolio Analysis/Management.
• Organized JAD sessions and gathered requirements, process mapping to find gaps, to integrate various discrete processes sections with developers and business clients.
• Developed Use cases and functional specifications. Provided UML diagrams.
• Involved in development and maintenance of workflow plans and artifacts.
• Interfaced with external contacts to obtain financial data solutions for clients.
• Managed Scope and change throughout the SDLC process of the product.
• Developed Use Case Models using Rational Rose to depict Actor and Use-Cases in various Business processes and identification of Basic/Alternative flows; definition of pre-and post-conditions of the System.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Closely worked with testers to develop Quality Assurance standards and processes to all levels.
• ETL Design/Development through Informatica Power Center 9.5.1 version.
• Created detailed functional specifications for development team.
• Created Artifacts and defined Milestones and iteration plans for Inception and Elaboration phases of SDLC
• Used Test Director with QA team for writing and testing Positive and Negative Test cases.
• Designed and develop the data dictionary and Meta data of the models and maintain them.
• Coordinated with DBA on data base build and table normalizations and de-normalizations.
• Assisted in developing the forecasting models for various departments.
• Run simulations and provide recommendations on various scenarios by using critical thinking.
• Prepare accurate, timely and insightful monthly variance reporting to partner departments
• Developed triggers, stored procedures, and functions associated with the project using Pl/SQL.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules and glossary evolve and change during the project.
• Created Data Models using Power Designer, implementing physical models for databases.
• Used TOAD to connect to the database and ran SQL queries to view data.
• Used Informatica Data Quality Data to analyze and enhance source data through processes called plans by creating in Workbench application.
• Used Power Center tool to perform data integration to pull the data from different sources and cleanse it.
• Worked on data mapping of source to target elements performing gap analysis using TERADATA.
• Worked under Agile/Scrum project methodologies to enhance current dimensional models using Power Designer 12.5 to integrate in DWH.
• Worked on data quality and validated business scenarios for a new database.
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating with various teams to decide on the appropriate action to be taken.
• Coordinated in database changes needed for the frontend development team, explained and guided them on the database architecture and objects for effectively accessing the database.
• Worked directly with non-IT business analysts throughout the development cycle, and provide post-implementation support, once developed including investigation of data and report issues identified.
• Maintained change log for each data model. And participated with dev team solve the production issues by debugging the code.

Environment: Rational Requisite, Visio, Win Runner, HPQC, Test Director, J2EE, Excel, MS Project, MS Office, ODBC, VB Script, PL/SQL D HTML, Windows NT/XP, SQL Server/Oracle, MS Access and Informatica Power Center.

Confidential, Bloomington IL

Sr. Business System Analyst

Responsibilities:

• I was involved in business requirement gathering phase and responsibly worked on writing user stories with scrum master for the new roles as well as Injury scope for Auto and Fire Insurance added later to the OCS System as part of phase 2.
• Extensively worked for capturing, linking, analyzing, and managing changes to requirements and their traceability. Additionally, created traceability matrix for the changes and Estimates.
• Worked closely with Business and dev team to complete the project requirement successfully throughout SDLC from requirement gathering till the implementation phase.
• Wrote the Business Scenario based on the User stories created for the phase 2 and upload it on the SharePoint and the Lotus Notes for the team.
• Uploaded and made changes after review by team and finalize to develop on SharePoint.
• Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the New Change, Code set.
• Conducted business-impact assessment to compare the results with new requirements to determine the current level of compliance and developed an action plan for approval by the project steering committee.
• Worked with financial team to generate adhoc reports and develop models to support strategic initiative
• Worked on to clean up requirement repository and prepare it for the phase 2 after phase 1 stories have been archived separately for implementation.
• Analyzed complex financial information, reports to provide accurate and timely financial recommendations.
• Supporting technical team leaders for designing and implementing infrastructure for clients.
• Worked with BI team to generate and Implement by using BI Tool and Dashboard reports
• Used extensive Visio diagrams to develop the workflow of a given scenario.
• Uploaded the requirements to the repository known as TestLink.
• Created the functional requirement document for Dev team by converting business requirements.
• Attended the mega training session for doing the work related to Business Architecture.
• Closely worked with test team in creating the efficient and effective test plan, scenarios and Strategies along with Unit and System testing followed by User Acceptance testing.
• Assisted team to create test scenarios and cases and upload those on TestLink repository, trace and documented the issues related to Use cases or test cases.
• Developed & executed several Optimized queries in SQL on this data.
• Used Tableau to produce visual output of the results in desired format for business review.

Environment: RUP, UAT, GAD (Gap Analysis Document), Microsoft Office Professional (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint 2003, UNIX, Tableau, Lotus Notes, MS Lync, TestLink, Oracle 10g, HP QC, SQL, PL/SQL.

Confidential, Washington DC

Sr. Business / Data Analyst

Responsibilities:

• Performed the requirement analysis, impact analysis and documented the requirements.
• Translated business requirements into functional requirements and approaches for developers.
• Worked on HIPAA4010/ 5010 transactions set and ICD-10 initiatives.
• Analyzed CMS comparison documentation highlighting changes of 5010 format and ICD10 diagnosis and procedure codes.
• Created ICD-9-CM/ICD-10-PCS comparison document and documented ICD9 to ICD 10 mappings for technical team and implementation process.
• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims. Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set.
• Interacted with Claims, Payments and Enrolment hence analyzing and documenting related business processes.
• Performdata profiling, data qualityrules development and assessment usingdata quality andmetadatatools.
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool.
• Understand the business needs and implement the same into a functional database design.
• Designed and customized data models for Data warehouse supporting data from multiple sources real time.
• Experience in EDI automated first-pass claim adjudication, requiring full understanding of claim processing, both front and backend operations.
• Conduct complex documentation and user needs analysis. Interface with team and staff to develop HL7 integration.
• Performed positive and negative testing to identify the defects & report them to the Data warehouse Team.
• Involved in intensive system level testing of analyzing the HL-7 messages coming out and in of EPIC Bridges.
• Extensively worked with the SAS programming and in data step and with various SAS Procedures in Base SAS and SAS/Stat, including thorough knowledge of SAS Macro.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also, used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.
• Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript, worked on data modelling and produced data mapping and data definition documentation.
• Analyse requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models).
• Organize requirements into high level Use Cases and low-level Use Case Specifications and modelled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Compiled Weekly, Monthly, Daily Financial analysis reports as per Business Groups requests with help Teradata SQL Assistant, UNIX.
• Experience in EDI automated first-pass claim adjudication, requiring thorough understanding of claim processing, both front and backend operations.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams, Involved in Service Oriented Architecture (SOA) of the claims processing system
• Designed, developed, and maintained various Business unit reports by using Teradata, SQL, and Ms Excel.
• Created Teradata SQL Assistant scripts, Temp tables to be compatible for the monthly segmentation and migrated tables.
• Documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Performed Integration testing for various mappings. Tested the data and data integrity among various sources and targets.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Did Integration Testing, GUI testing, Smoke and Sanity Testing, and Acceptance testing in the new builds for Basic Functionality Checking.
• Performed Integration testing for various mappings. Tested the data and data integrity among various sources and targets.
• Analyzed and recommended effective modifications and improved efficiency of systems
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyse and document the Business Data Requirements.
• Generating the Standards and templates for the reports, interfaces and the universes.
• Creating and modifying the universes using Business Objects designer for Sales and Distribution System.
• Used data transformation tools such as DTS, SSIS, Informatica.
• CreatedSSIS packagesto extract data from OLTP to OLAP systems.
• Creating, maintaining and modifying the business complex reports using Business Objects Reporting Module.
• Created Custom Hierarchies in the universe to Perform multidimensional analysis

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, PL/SQL, DB2, Mainframe, Sybase, EVPN, XML, Business Objects, Test Director, Load Runner, UNIX.

Confidential

Customer Service Analyst

Responsibilities:

• Implemented and integrated hybrid solutions with complete line of traceability for all the artifacts of web development projects.
• Involved in requirement gathering including interviews, brainstorms and meetings with stakeholders and created requirement specification artifacts.
• Involved in customer segmentation, Portfolio Analysis/Management.
• Organized sessions for process mapping to find gaps, to integrate various discrete processes followed in RSO.
• Developed functional specifications documents. And provided UML diagrams.
• Involved in development and maintenance of workflow plans and artifacts.
• Conducted user interviews, gathered requirements, and analyzed the requirements by using Rational Rose, Visio and Requisite pro.
• Developed Models and identification of Basic/Alternative flows and definition of preconditions and post conditions of the System.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Designed and develop the data dictionary and Meta data of the models and maintain them.
• Coordinated with DBA on data base build and table normalizations and de-normalizations.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.
• Created Models using MS Visio, implemented physical models for databases.
• Used TOAD to connect to the database and ran SQL queries to view data.
• Generate user and technical documentation for individual processes.
• Worked on data quality and validated business scenarios for a new database.
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating with various teams to decide on the appropriate action to be taken.
• Maintained change log for each data model. And participated with dev team solve the production issues by debugging the code.

Environment: Rational Requisite, Visio, WinRunner, J2EE, Excel, MS Project, MS Office, ODBC, VB Script, PL/SQL DHTML, Windows NT/XP, SQL Server/Oracle, MS Access.