SUMMARY:

• Qualified professional over all wif 8 years of extensive experience in teh field of Business Intelligence, Data Warehouse, Database Management Systems and Data Analysis
• Expertise on Business Intelligence Tools like, Tableau, SSIS and Business Objects.
• Interface wif clients from Operations, Marketing, Sales, Technologies, and Outside Vendors.
• Experience in Creating Reports using Microsoft SQL Server Reporting Services and Tableau.
• Expertise in broad range of technologies, including business process tools such as MS Excel, MS Access, MS Visio, technical assessment tools, Data Modeling and Design.
• Exposure to teh entire Data Warehousing life cycle - Analysis, Design, Development, Testing, Implementation and Maintenance of Data Warehousing projects.
• Good noledge of PPACA (Patient Protection and Affordable Care Act) & Medical Management Information Systems (MMIS)
• Experience wif data migration (ETL development), created Business process rules for migration.
• Extensive experience in creating ad-hoc reports using in Microsoft Business Intelligence Development Tool (BIDS) and Tableau.
• Excellent noledge in health care domains (HIPAA, ICD-9/10, SOX, CFR 21 Part 11, HL7, CFR 21 Part 820, EMTALA, Medicaid, Medicare, and other health insurance policies).
• Worked on different EDI healthcare transactions like 837 for submitting claims, 835 for payments, 834 for benefit enrollment, and 820 for premium payments to insurance products, 270,271 for health care benefits and eligibility, 276, 277 for claims status and 278 for transmitting health care service information.
• Preparing graphical depictions of use cases including state diagrams, activity diagrams, sequence diagrams, use case diagrams, component-based diagrams, collateral diagrams, including teh business workflow.
• Excellent noledge of industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP), CMM (Capability Maturity Models) and Rational Tools used during various phases of RUP.
• Experience wif various ETL, data warehousing tools and concepts.
• Feasibility studies, Document generation and conducting sessions.
• Comprehensive noledge of teh testing lifecycle wifin web, client server & Mainframe environment.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to teh customer and feasible for teh developers and to limit a project’s exposure to teh forces of change
• Worked on various methodologies such as Agile Software Development / Scrum, Joint Application Design (JAD) and Prototyping.
• Excellent noledge wif Data Warehouse and Business Intelligence (BI), Data Management and Database Design, Business Analysis and Information Engineering, Software Quality Assurance, Advance in Data Integration
• In Depth understanding of teh AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Use Case development and UML modeling using modeling tools like Rational Rose/MS Visio.
• Excellent skills in Business Analysis, OO Analysis, Data Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.
• Proficient in customizing already existing business practices, workflows, activities and deliverables.
• Develop User interfaces and requirements sessions. Requirements gathering, data modeling, System Architect. Feasibility studies, Scope Documents, Requests for Proposal.
• Hands on experience of Data manipulation, performance testing on MySQL and MS-Access using SQL scripts.
• Providing traceability across teh project by analysis and review of project elements involved in traceability including testing artifacts, end-user support documentation and materials.
• Extensive Documentation Skills for use in Standardization of Testing and Programming Procedures
• Strong experience in writing complex SQL queries
• Strong ability to create and present reports
• Experience in automation of reports
• Passionate in learning new Technologies, Enthusiastic, Determination, and Persistence to Troubleshoot issues, and Positive Attitude towards Challenging Work.
• Highly motivated team player wif excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

IDE / OOAD Tools: Rational Rose, Rational Requisite Pro, Rational ClearQuest, Crystal Reports, MS - Visio, MS Project.

Database: SQL Server, MySql, Oracle, DB4O, TSQL, Oracle9i, MS Access

Reporting: Crystal Reports, MS Project, MS Visio, Share Point, IBM Cognos, Microsoft Report Builder, Power Pivot, Dundas Dashboard, QlikView

Web Tools: Axure, Macromedia Dreamweaver, FrontPage, Macromedia Flash, HTML, CSS, JSP, JavaScript

Statistical Tools: Minitab, SPSS

Languages: C, C++,SQL, Java, C#, ASP.NET, PHP, HTML, Java script, MATLAB, Perl

Operating Systems: Windows and NT

Markup Languages: HTML, XML, XFDL

Other Tools: MS Office (Word, Excel, Access, PowerPoint)

ERP: SAP FI/CO 4.6B, 4.6C

Methodologies: Waterfall, Spiral, Agile, Scrum

ITools: Eclipse, SQL Server Management Studio 2012, SSIS, SSRS, SSAS, Tableau, Microsoft Office, Arena Simulation, Salesforce Statistical Analysis: SAS 9.3, Minitab, R Net Beans, Visual Studio, Dreamweaver, Rational Rose, Talend, Informatica Cloud, Jenkins, Accurev, Code Collaborator, Rally, BMC Remedy, Perforce, MS Projects, MS Visio, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, Bowie, MD

Sr. Busienss Data Analyst

Responsibilities:

• Performed complex data analyses, including production of queries, in support of ad-hoc and routine management or customer requests.
• Provided accurate and appropriate interpretation of data, applying noledge to evaluation, analyses and interpretation of data.
• Translated business requirements into technical requirements proposing automated solutions, designs and development strategies.
• Performed ad-hoc analysis on, Enrollment, Provider and Claims data for Medicare and Medicaid Clients.
• Analyzed data requirements, developed complex MS SQL Server queries to extract data using advanced techniques such as inner and outer joins, sub queries, case statements, string functions, and data type conversion.
• Conducting user interviews, gathering requirements, analyzing teh requirements using Rational Rose requisite pro - RUP.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
• Managed and Developed EDI specifications, for data feeds and mappings for integration between various systems, to follow ANSI X12 4010 formats including 270 Eligibility/Benefit Inquiry, 271 Eligibility/Benefit Information, 276 Claim Status Request, 277 Claim Status Response, 810 Invoice, 820 Payment Order/Remittance Advice, 834 Benefit Enrollment, 835 Remittance Advice and 837 Claims and Encounter, to meet and exceed HIPAA requirements set forth by teh federal government.
• Conducted workflow, process diagram and GAP analyses to derive requirements for existing systems enhancements.
• Enhanced QE sanity testing to track daily test results through development of new automation framework
• Conducted User Acceptance Testing (UAT).
• Developed teh test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product noledge.
• Using detailed noledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Conducted QA testing wif teh technical team.
• Used SQL, Data Warehousing and Data Cleansing for teh arrangement of customer data.
• Liaison for projects wif other corporate departments, including Executive, Legal and Information Services as well as vendor relationships.
• Developed requirement reports for day-to-day retail banking needs for opening account, online banking using rational SoDA.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center 7.1
• Develop and produce aggregated and dashboard reports using MS SQL, MS Access and MS Excel.
• Automated teh generation of new and existing reporting solutions/dashboards using VBA, excel macros, and pivot/power pivot.
• Performed Quality Improvement Analytics operational activities across teh client-base and produced QA reports and internal as well as client deliverables on a timely basis.
• Created technical design documentation which includes current and future functionality, database objects affected specifications, data mappings and flows/diagrams to detail teh proposed implementation.
• Supported automation and enterprise consolidation of data used in monthly, quarterly, and annual metrics reports for Confidential .
• Managed data, prepared data visualizations using Tableau and R.
• Created dashboards in Tableau and Excel

Environment: HTML, DHTML, Oracle, VB, J2EE, RUP, UML, SQL,MS-Office, MS Project, MS Visio, CMM, Net Beans, Visual Studio, Dreamweaver

Confidential, Waltham, MA

Sr. Data Analyst

Responsibilities:

• Documenting, requirements from teh clients for any changes to be made to their database.
• Worked on many projects to convert data from one database structure to SQL server (Converting Foxpro db into SQL server etc)
• Migrated company’s Salesforce data into company’s SQL server db so dat teh company could access dis data using teh company’s application (Asset Enterprise).
• Prepared complete data mapping for teh migrated data.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Writing T-SQL scripts to manipulate data for data loads and extracts.
• Responsible for teh management of teh software process from requirements gathering, documentation, management approval, client approval, development, to testing and final presentation to teh client.
• Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working wif teh project team, sponsor, and stakeholders to baseline teh scope of teh work and enable development of teh plan.
• Design specifications and Test Case usages for teh HIPAA 837i, 270/271, 276/277, 835, 824, 275 and others.
• Involved in assembling, organizing and analyzing patient information, including medical history, symptoms, examination results, test results and prior treatments for EHR software development
• Implemented teh full project lifecycle phases including requirements gatherings, development and quality assurance.
• Worked closely wif product owner for requirements specifications and plan business solutions
• Designed and developed desktop application for neuron image processing using Java Swing.
• Designed algorithms and stand alone scripts to collect critical information of client’s product, halping them improve their operational efficiency
• Conducted user interviews at both in-house and client locations.
• Monitored and assisted in designing and development of Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Involved in up-gradation of HIPAA X12 4010 transaction to HIPAA X12 5010 and ICD 9-CM (Clinical modification) to ICD-10-CM/PCS (Clinical modification/procedure coding system) simultaneously.
• Created Logical/physical Data Model in ERwin and has worked on loading teh tables in teh Data Warehouse
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Generating dashboards, reports in Asset Enterprise and Salesforce.
• Analyzing raw data, drawing conclusions & developing recommendations to Clients
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and wrote functions, stored procedures and triggers.
• Designed SSISPackagesto develop jobs for extracting, cleaning, transforming and loading data into database

Environment: Rational Rose, RUP, UML, SQL, MS-Office, MS Project, MS Visio, Microsoft Access, Oracle, SQL

Confidential, Milwaukee, WI

Business Analyst

Responsibilities:

• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams using UML.
• Involved in Backend Testing to verify data integrity by using T-SQL.
• Documented, identified, organized and tracked teh requirements using Rational RequisitePro.
• Created Data Flow Diagrams (DFDs), ER diagrams for data modeling and Web-page mock-ups using MS Visio for acceptance from end users.
• Defined project milestones, schedules, and monitored progress using MS-Project, creative pro office and modified, updated teh project scheduled plans as required.
• Analyzed and tested Data Interface needs.
• Conducted Asset Management, Risk Analysis of teh Requirements and Traceability focus areas of teh various projects and worked wif teh project team to halp them identify teh high-risk areas.
• Worked extensively on both inbound and outbound transactions, creating test cases for multiple transaction types including 837, 835, 276, 277
• Got involved in designing future state processes for HIPAA transaction processing EDI’s 837,835, 270, and 271.
• Assisting and leading various teams by complying wif already going works in teh health care domain and work wif teh conversion.
• Gap Analysis: Analyzed teh client’s applications programs to determine teh impact of teh HIPAA final rule on EDI Transaction Set and Code List implementation and defined teh changes to bring teh affected systems into HIPAA compliance.
• Worked wif FACETS Team for HIPAA Claims Validation and Verification Process (Pre-Adjudication).
• Assisted wif user testing of systems and maintained quality procedures and ensured appropriate documentation is in place.
• Maintained Requirement Traceability Matrix (RTM) and Utilized Clear Quest for change requests and defect tracking.
• Claim validation and Pend/Denied Claims Analysis for teh Health plans Medicaid programs.
• Worked closely wif teh technical team to look up for teh best possible solution on requirements by keeping business needs and technical constraints in mind.
• Updating, transferring and sharing Files using FTP between Windows and UNIX machines.

Environment: UML, MS Word, Rational RequisitePro, Rational Clear Quest, Quality Center, SQL, FTP, TelNet

Confidential

Business Analyst

Responsibilities:

• Designed and developed Web Applications like Vehicle Rental System and Medical Research Application using J2EE, XML, Servlets, JSP
• Designed teh database for teh above mentioned applications using teh concepts of normalization.
• Created Entity Relationship Diagrams to represent relationship between tables.
• Created Complex SQL queries and used JDBC connectivity to access teh database.
• Writing test cases for unit level testing and functional testing.
• Created teh Business Requirement and documented Functional Specification through abstract UML artifacts, activity diagrams, functional flow diagrams, process decomposition diagrams, data models, data flow diagrams and workflow diagrams and created project bases Context Diagrams in Visio.
• Has Knowledge in Manage end-to-end technical solution and baselines through technical reviews (JARs, JADs, BRRs, SRRs, CDRs, and TRRs etc.) which are essential for implementation success of teh project.
• Created Process Flows using IBM WebSphere Modeller and IBM WebSphere Lombardi.
• Detailed Data Dictionary. Guided business management and conducted detailed specification of data fields familiar to managers from a business perspective.
• Experience working on Web Applications wif creating mapping documents and Web Services
• Experience in understanding XSD Schema and reading XML.
• Used MS office, MS Visio, MPP for project tracking, documentation and presentation. Used MS Project for project scheduling and management activities and Visio for Workflow diagrams and business processes.
• Developed and maintained requirement management plan, features document, use cases, supplementary specifications, data interface documents, use case catalogues, other technical documentation and requirement traceability in Rational RequisitePro, RTC and Clearcase.

Environment: MS Office, SQL, MS Visio, XML, XSD, HTML