SUMMARY

• Over 7 years of IT experience in teh field of Business/Data analysis, ETL Development and Data Modeling. Good understanding of business process and requirements management methods. Expertise in creating business process flowcharts, Visio diagrams, test plans and test cases. Created project plans, business process flow, requirement traceability matrix, systems requirements specifications, work scopes and business case justifications.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Good experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per teh Software Development Life Cycle.
• Experienced in developing accurate business process requirements for Health, Pharma and State projects.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Extensive experience in project management best practices, processes, & methodologies including Rational Unified Process (RUP) and SDLC
• Excellent communicator focused on customer service.
• Ability to understand current business processes and implement efficient business process.
• Expertise in defining scope of projects based on gatheird Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Strong background in support documentation.
• Analysis and review of Software and Business Requirement Documents.
• Gathering business and Technical requirements that would best suit teh needs of teh technical architectural development process.
• Team lead skills encompassing user interviews, coordination with Tech Lead, DBA's, Developers, QA/QC Analysts during teh design phase.
• Extensive experience on Excel, Word, PowerPoint, MS Project, MS Visio, Rational Suite and SQL.

TECHNICAL SKILLS

• Domain/Industry
• Healthcare, Pharmaceutical
• Bug Reporting Tools
• Quality Center, Test Director, Clear quest
• Programming Languages
• C, C++, Java, VB, SQL
• Data Base
• Oracle 9i/10g/11g, MS SQL Server, DB2 MS ACCESS
• Methodologies
• RUP, UML, Waterfall, Agile
• Operating System
• Windows XP,2007,WindowsNT/2000/2005/2008
• Testing Tools
• Selenium, QTP, Clear Quest, Load runner
• Functional
• Business/Data analysis/QA
• Application Software
• MS Project, MS Office Suite
• Requirements Management Tools
• Rational Rose, Requisite Pro
• Reporting Tools
• Rational SODA, Crystal Reporting

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Lead Data Analyst

Responsibilities:

• Working closed with business analyst in gathering reporting requirements
• Conducted JAD sessions and performed data analysis for documented data quality standards
• Documented Technical & Business User Requirements during requirements gathering sessions using Rational Requisite Pro
• Involved in modeling business processes through UML diagrams using Rational Rose.
• Experience using test director, conducting walkthroughs of data cleansing rules, and test case validations working with teh QA team
• Conducted logical data model walkthroughs and peer review sessions for validation
• Facilitated transition of logical data models into teh physical database design and recommended approaches for good data management practices
• Worked with DBA group to create Best-Fit physical model from teh Logical Data Model
• Created DDL scripts for static dimensions and ETL Mappings using DataStage
• Developed Data Migration and Cleansing rules for teh Integration Architecture (OLTP, ODS, DW), considering data linkage and data transformation rules
• Maintained data mapping documents in reference to HIPAA transactions primarily 837(P, I, D), 835, 270/271, 276/277 and 278.
• Understanding and assessment of teh current ICD 10 codes used by teh State
• Responsible for addressing, diagnosing and resolving issues that arise on a day to day basis for teh team.
• Creation of a Gap/Impact Analysis Document for changes of teh EDI Transactions (837, 835, 276/277, 270/271)
• Used data analysis techniques to validate business rules and identify low quality missing data in teh existing Amgen enterprise data warehouse (EDW).

Environment:MS Office 2007, MS Visio 2003, PowerPoint, MS Project, Windows XP, UML, SQL, Test Director, MS Outlook

Confidential, Bloomington, MN

Sr. Data / Business Analyst

Responsibilities:

• Developed teh High Level Project Requirements (HLR) for a very large project.
• Modified and used Project Templates to gather teh requirements and carry on teh project.
• Facilitated teh requirement gathering work sessions with stakeholders, SME’s and Business owners to understand and incorporate teh potential requirements in teh BRD.
• Coordinated teh project team for JAD and BRD Sessions.
• Contributed in implementation of 4010 to 5010 transition in accordance with HIPAA standards.
• Created 837(P, I, D) claims, and maintained data mapping documents in reference to HIPAA transactions primarily 837(P, I, D), 835, 270/271, 276/277 and 278.
• Worked on 837 and 835 projects, including syntax and business rules for X12 HIPAA 4010 and 5010 validation for loops, segments, elements, qualifiers and code sets.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Performed System testing, Regression testing and UAT for several claim types and test scenarios.
• Compared and validated 5010 system test results with 4010 results for teh same test scenarios.
• Executed Step-down testing from 5010 to 4010 to validate teh EDIFECS results.
• Maintaining noledge of Medicare and Medicaid rules and regulations pertaining to teh Facets configuration and evaluating teh impact of proposed changes in rules and regulations.
• Created X12’s for 4010 and 5010 standards to meet test scenarios.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and insured that critical requirements are not missed.
• Frequently resolved teh issues with EDIFECS and ACTT Now, primarily teh generation of 997, 999, 824, 277CA reports.
• Coordinated activities between business unit and technical staff, developed new methods, policies, and procedures to meet teh business needs.
• Developed Data Conversion Strategy using ETL functions for converting data from teh existing site to teh new site.
• Assisted Project Manager to complete teh project approval process.

Environment: MMIS portal, EDIFECS, Facets, HIPAA, Oracle, SQL, QTP, Caliber, MS Office, MS-Visio

Confidential, San Diago, CA

Data/Business Analyst

Responsibilities:

• Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions with teh process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Coordinated teh project team for JAD and BRD Sessions.
• Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect teh Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering.
• Worked on data modeling and produced data mapping and data definition documentation.
• Performed System testing of teh Claims processing systems (Pricing Rules, Duplicate/Limits validation, Member Eligibility, Provider Enrollment, et al).
• Executed Extract, Transform, and Load (ETL) process from teh data warehouse.
• Performed testing for Medicare, Medicaid and X-Over claims for Medicaid Management Information System (MMIS)
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing teh functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Database table review and data mapping for large scale data conversion project Oracle database to Mainframe.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Worked on NASCO system on Claims, Membership and Benefits
• Involved in creation and reviewing of Functional Specifications and created a Functional Requirement Document
• Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases) and modeled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
• Created product documentation, including online halp, Printed User Manual, and training materials.
• Conduct QA testing of ETL data transformation and data warehouse for reporting solutions

Environment: Waterfall, Agile, FINEOS, Web Application, Incoming Documents, Integration, HIPAA, Java, SQL, QTP, MS Office, MS-Visio

Confidential, Saddle River, NJ

Data Analyst

Responsibilities:

• Gatheird business and system requirements from various departments like accounting, Fund Management, Legal and Human Resource through focus groups, surveys, interviews, and JAD sessions.
• Analyzed data to generate information about clients and their attributes, and drafted a data requirement document.
• Held meetings with users and stakeholders to identify problems, resolve issues and improve teh process to ensure a stable and accurate solution.
• Prepared Business Workflow models and process diagrams depicting how business processes are accomplished.
• Created Activity Diagrams, Data Flow Diagrams, Use Cases, Business Process flowcharts for teh To-Be process.
• Managed chart completion (ICD-10-CM and CPT coding/abstracting), chart assembly and analysis, patient admission and patient information privacy/security.
• Created detailed workflow diagrams, business flowcharts of existing and proposed systems.
• Actively involved in creating/updating Work Breakdown Structure (WBS), preparing deliverable tasks in teh project plan.
• Created Use Cases to identify automated processes and teh actors (vendors, systems) involved in teh project to ensure reliable results of implemented business/functional needs.
• Involved in feasibility analysis and risk analysis of teh project.
• Gatheird and documented business requirements in order to describe teh business needs in terms of teh main deliverables.
• Maximized reimbursement by ensuring accurate ICD-10 coding and conducting regular quality audits of providers' selected codes compared to chart documentation.
• Facilitated meetings with Subject Matter Experts (SMEs) to create teh process requirements, process improvements and to proper explain teh development team teh flow of future data modules.
• Functioned effortlessly and efficiently, as a liaison between four work streams and its task leads, SMEs, development team, and management group. Actively participated in Joint Meetings with teh various teams involved in teh development process.
• Helped in designing and implementing deployment process, and thus maintaining teh application in post deployment process.
• Reached out to vendors for clarification of data.

Environment: Rational Enterprise Suite (Rose, Requisite Pro, Clear Case), IBM Web Sphere, XML, Mercury, MS Office, Oracle, SQL Server Reports

Confidential, Morris plain, NJ

Data Analyst

Responsibilities:

• Conducted System Analysis & Design along with teh Business Continuity and Crises Management.
• Authored blueprint of all Functional Requirement Specifications (FRS) and Business Level Specifications (BLS) including job profiles using UML with department collaboration and sequencing diagrams.
• Conducted JAD sessions with multi location team and authored Use Cases and Use Case diagrams.
• Captured business requirements using Rational Rose methodology.
• Prepared Data Flow Diagrams (DFDs) and Sequence diagrams.
• Created X12’s for 4010 and 5010 standards to meet test scenarios.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and insured that critical requirements are not missed.
• Frequently resolved teh issues with EDIFECS and ACTT Now, primarily teh generation of 997, 999, 824, 277CA reports.
• Utilized UML notations to document activity, deployment and workflow diagrams in Visio.
• Conducted User Acceptance Testing (UAT).
• Created an initial use case for teh Log books signing-off process under Healthcare rules and Healthcare compliance.
• All procedures occurred under teh compliance of Good Manufacturing Processes (GMP).
• Conducted full Life Cycle which included Business requirements/Workflow analysis, Change Management, Liaison between Technical/Functional, QA, Testing, Security Analysis, and Blueprint Delivery.
• Suggested recommendations for integrated systems and Business Process optimization, by eliminating redundancies and reducing cycle time.

Environment: Rational Rose, Test Director, RUP, UML, MS Office, MS-Project, MS Visio, RQM, UNIX, Crystal Reports.

Confidential, Richmond, VA

Jr. Data Analyst

Responsibilities:

• Developed BTEQ, MLOAD, FLOAD and TPump scripts for data migration, and automated them in Unix using shell (ksh) scripts
• Conducted JAD sessions with teh stewardship team, for gathering functional and data requirements
• Developed short-term tactical solutions to achieve long-term objectives and to promote teh enterprise data architecture vision.
• Responsible for identifying data quality issues and downstream impact to teh data warehouse
• Designed reports to analyze end user data for compliance with teradata governance standards.
• Developed ksh scripts to capture file system usage both on SASDOME & PEARL unix servers
• Performed data mapping of Business Objects universes in XIR2 for reporting end user data
• Developed bobj reports to analyze space usage by end users/groups on unix servers.
• Responsible for testing bobj reports and providing teh signoff to teh BI team, during teh migration of Business Objects from XIR2 to XIR3
• Responsible for communicating with end users for cleanup of files on unix servers as a BAU.
• Designed a process in Unix to send space alert notifications by email.
• Developed documentation for end users, to halp get familiar with TAOS data mart
• Responsible for submitting work orders for code promotion, enhancements and job scheduling.

Environment: Rational Rose, Test Director, RUP, UML, MS Office, MS-Project, MS Visio, RQM, UNIX, Crystal Reports.