OBJECTIVE

• Seeking a challenging and growth oriented position in the field of information technology, where I will be able to utilize my strong business, technical, and analytical skills for the advancement of the organization.

SUMMARY

• Hands on experience in HealthCare, Pharmacy, Insurance, and Mortgage industries’.
• Expertise in all the phases of the Software Development Life Cycle (SDLC), Agile Development, Waterfall and RUP methodology.
• Expertise in conducting detailed and comprehensive Business Analysis by working with the stake holders, SME’s, technical developer to identify the operational requirements for system and its process improvements.
• Expertise in documenting the Business Requirements Document (BRD), User Stories, Functional and Nonfunctional Requirements Document (FRD), System Requirements Document (SRD), Metadata Import Specifications Document (MISD).
• Expertise in gathering business requirements, functional requirements, metadata requirements and in Data Modeling for both Data warehouse and transactional databases.
• Assist in defining, developing, and implementing the strategy, priorities, and key areas of HL data management best practices.
• Efficient in developing Logical and Physical Data model and organizing data as per the business requirements using Erwin, ER Studio, Sybase Power Designer.
• Understanding of property and casualty (P&C)insurance business processes.
• Exposure to product development, pricing, underwriting guidelines and workflow, policy administration, property and casualty insurance billing, and claims administration.
• Strong in maintaining, validating metadata for databases, schemas, copybooks and data files under various platforms.
• Expertise in Metadata Analysis, analyze Metadata requirements, identifying the source and target.
• Efficient in developing data structures, stated lineage, and enrichment documents including message broker XML services on Ab Initio platform.
• Efficient in managing Data model’s as per the business metadata standards.
• Expertise in structuring Source to Target Mapping, Extraction Transformation and Loading (ETL) and conducting review with the business users.
• Strong and effective in identifying dependencies on other teams, collaborates and communicates effectively in a timely manner to meet the project deadlines.
• Efficient is developing test plans, maintaining the Traceability Matrix and assisting in Post and Pre Implementation activities.
• Experience in creating database Tables, Views, Sequences, triggers, etc taking the Performance and Reusability into consideration
• Expertise in Data Quality, Data Profiling using DQ analyzer.
• Experienced in Fee for Service Claims, Client Enrollment, Provider Enrollment, Pricing, Reports, Adjudication and Interfaces.
• ICD 9 - ICD 10 Conversion Project - Worked in the analysis of the ICD 9 - 10 codes conversion Project.
• Expertise on HIPAA ASC X12 fee for service and encounters transactions EDI 837, 834, 835, 276, 277, 270,271,277CA Transactions.
• Experience working with different Business Areas - Finance, Billing, Claims, Benefits Administration, Group Administration and Provider Administration.
• Expert in creating Use Cases, Use Case Diagrams, Class Diagrams, Sequence Flows using MS Visio.
• Expertise in administering and maintaining PROD, UAT, SIT and Dev environments and providing resolution to Production issues.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.

TECHNICAL SKILLS

Methodologies: SDLC -RUP, Agile methodology, Waterfall methodology

Languages: C, C++, Java, SQL, PL/SQL

Operating Systems: Windows 95/98/2000/XP, UNIX, Linux, iOS, SunSolaris8/7/2.x

Databases: Teradata 12, Oracle 10g/9i/8i, SAS, MS Access, SAS, MS SQL Server 2008, DB2, Sybase.

Business Intelligence Tools: Cognos 8 BI suite, SAP BI, SAP Business Objects, MS Strategy and MS BI

Data Modeling Tools: Sybase Power Designer V15 / V16, Erwin 8.0, 8.1, 8.2, Microsoft Visio, ERStudio

Tools: and Packages: Sybase Power Designer, Minitab, MatLab, MS Office, MS Project Plan, Adobe Acrobat Suite, Ab Initio, JIRA, TROUX, Informatica, Microsoft Project Plan, MS Visio, Ultra Edit, HIPPA File Viewer, GUIDEWIRE.

Other Tools: FACETS, TOAD, Oracle SQL Developer, SQL*PLUS, Teradata SQL Assistant.

PROFESSIONAL EXPERIENCE

Confidential, Des Moines IA

Database Analyst

Responsibilities:

• Experience with data governance, data stewardship in home mortgage business area of Metadata Management working with various LOB’s.
• Assisting technical expertise for the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases.
• Expertise in maintaining metadata in (SOR) System of Record, (ODS) operational data environment and (IDE) integrated data environment.
• Strong understanding in documenting requirements, process / data flows, and creating data mappings and capturing business rules.
• Gather and document metadata requirements for various home lending projects under different technologies.
• Gathering detailed data requirements and conducting design analysis, data mapping and profiling.
• Handle complex or critical data/ database management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database architecture, design, integration.
• Expertise in metadata driven design, technical metadata, business metadata, operational metadata
• Experience is design of DQ reporting matrix to measure accuracy, timeliness, consistency, completeness, validity and reasonableness.
• Consult extensively with multiple client groups to provide strategic solutions, influencing long-range internal and enterprise-level data/ database architecture and management strategies.
• Managing team, provide oversight, mentoring and leadership through the entire development, deployment, and operations lifecycle
• Strong understanding of Ab Initio Data Dictionary, business tem definition, lineage, linkage, data models, copybook, executables and files.
• Independently analyze data design and identify data sources, touch-points and movement.
• Work closely with data modelers and data analysts doing design work to document metadata requirements and facilitate the transition from requirements to design of metadata structure in metadata repository.
• Work with technical resources, key users in the enhancement and maintenance of the metadata repository and its contents and to identify project issues as they arise
• Ensure testing results correspond to the metadata steward business and functional requirements.
• Design and develop conceptual data models, logical data model using power designer.
• Redefining the cardinalities and Domains of the existing data models.
• Normalize data to 3NF and developing schema.
• Performed Forward Engineering data models for Schema generation, Reverse Engineered on the Existing Data Models.
• Created Database Tables, Views, Indexes, Triggers and Sequences and Developing the Database Structure.

Environment: Data modeling, Enterprise Data Warehouse, Data Warehousing SDLC (requirements, design, ETL, testing, BI solutions), TOAD, Metadata Management, Teradata, Oracle SQL, Ab Initio, JIRA, iGrafx and Troux, Business Process Modeling Notation (BPMN), Business Objects, Micro strategy and Microsoft BI.

Confidential, NE

Business Analyst / Data Analyst

Responsibilities:

• Conducted detailed and comprehensive Business Analysis by working with the technical experts, Business Staff, SME’s, and other stakeholders to identify the system, operational requirements and process improvements across the department.
• Research on various MMIS functional areas that have impact/nonimpact for 837 Encounter Process.
• Worked with existing system analysis and reviewing the impacts with team and with the MCOs.
• Participated in State Wide Managed Care Expansion Project.
• Gathering requirements on Batch Edits that applicable to 837 Encounter project.
• Worked with various Managed Care Organizations in transition from proprietary encounters in 837 Encounter transactions.
• Strong understanding of HIPPA X12 EDI 837I/P/D, 835,834, NCPDP, TA1, 999, 277CA transactions.
• Documenting gathered Business Requirements from Business users, Stake Holders and SME’s.
• Training and mentoring team to ensure tasks are completed on time.
• Worked with different project team across the department to identify risks if requirement is not followed.
• Organized internal meetings with team members to ensure to meet the requirements.
• Expertise in developing and prioritizing User Stories, Test Scripts and Test Scenarios.
• Developing Mapping Data elements from existing proprietary Encounter Data record Layout to proposed 837 Electronic formats.
• Maintained the Traceability Matrix table to uniquely trace the identified business requirements to general design to testing as proof that requirements requested have been developed into a solution and that it has been tested and tracked.
• Plan, document, evaluate and track testing results to ensure system applications are free from defects
• Research on various MMIS functional areas that have impact/nonimpact for 837 Encounter Process.
• Working with different team to resolve production and testing issues across department.
• Assisting team during testing as needed to ensure to meet the implementation deadline.
• Develop high-level test Plan for Testing of EDI 837I/P/D, 835,834, NCPDP, TA1, 999, 277CA and developed Test Cases.
• Strong understanding with MARS and SURS.
• Ensure that quality processes are carried out throughout the implementation.
• Support project activities in validating production implementation and assisting in Post & Pre implementation.
• Expertise in administering and providing resolution to Production issues.

Environment: Erwin, FACETS, Sybase Power Designer, EDIFECS, Microsoft Outlook, SharePoint, Lotus Notes, PPM Clarity, DB2, SQL, IBM Mainframe, MS Visio, Word, Excel, PowerPoint, HIPAA File Viewer, Sybase Translator.

Confidential, IL

Business Analyst

Responsibilities:

• Conducted detailed and comprehensive system analysis by working with the senior IT staff, Business Staff, SME’s, and other stakeholders to identify the system, operational requirements and process improvements.
• Worked with various Managed Care Organizations in order for them to meet the DHFS standards.
• Documenting DHFS claim processing rules, use cases, for MCO’s Business as per the stakeholder’s guidance.
• Training and mentoring team to ensure tasks are completed on time.
• Worked with various departments to solve the MCO issues.
• Worked on validating, developing HIPPA EDI 837I/P/D claims 834, pharmacy claims, claims acknowledgement (999), Interchange Acknowledgment (TA1)
• Worked with multiple users under various business environments.
• Expert in Mapping Data elements for claims batch processing.
• Conducted detailed review with business users to make them understand each edits.
• Research on various functional areas that have impact/nonimpact for 837 Encounter Process.
• Participated in analysis and design walkthroughs, as well as project meetings with the MCOs.
• Ensure that quality processes, accuracy, standard are maintained throughout the process.

Environment: Microsoft Outlook, SharePoint, FACETS, Web FOCUS, Lotus Notes, PPM Clarity, DB2, SQL, IBM Mainframe, MS Visio, Word, Excel, PowerPoint, HIPAA File Viewer, Sybase Translator.

Confidential, Howell, MI

Business Analyst

Responsibilities:

• Involve with Stakeholders, technical analysts team in requirements gathering and in preparing functional specifications to changing them into technical specifications.
• Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs for reporting requirements
• Involve in making screen designs,use cases and ER diagrams for the project using ERWIN and Visio.
• Coordinate with the data modelers for Logical and Physical Data-models as per the requirements
• Design and develop the data dictionary and Metadata of the models and maintain them.
• Identify problem areas and recommend ways to revise and improve efficiencies and processes
• Coordinate withDBAon data base build and table normalizations and de-normalizations
• Create business process documentation conduct BPM sessions and technical documentation for individual processes.
• Perform trend analysis to determine cause as well as trouble-shoot issues related to response time.
• A Work independently with users to define concepts and under direction of project managers
• Involved project management and technical best practices in all technology solutions.
• Perform other duties as required

Environment: GUIDEWIRE, MS Visio, Word, Excel, PowerPoint, Microsoft Project Plan, Oracle, MS-SQL Server, MS-Visio, Clear Case, MS Office

Confidential, CO

Business Analyst

Responsibilities:

• Conduct JAD sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
• Interacted with the Subject Matter Experts (SME’s) and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Worked with Internal and External Users to define requirements and coordinated user management and developer expectations.
• Used SQL queries for extracting desired data from multiple databases.
• Developed Use Cases using MS Visio, and a detailed project plan with emphasis on deliverables.
• Monitored Change Requests and documented requirements, integrating them with Use Cases.
• Developed and Implemented Test Strategies using the Test Director.
• Assisted QA team in testing phase by creating Test Plans and Test Cases documents.
• Facilitated User Acceptance Testing (UAT) and reported the results to the Business Stakeholders.
• Maintained proper communication with the developers ensuring that the modifications and requirements were addressed and also monitored these revisions.
• Created as-is and to-be process models, specifications, and process flow diagrams.
• Worked with stakeholders and project team to prioritize collected requirements.
• Validated business rules and all artifacts with users, approval and sign off.

Environment: EDIFECS, WTX, Rational Rose, Requisite Pro, Clear Case, Clear Quest, SQL, SAS, Oracle, J2EE technology, Java.