SUMMARY

• Over 7+years of extensive diversified experience as an accomplished Business/Data Analyst proficient with Analytical and Technical knowledge including strong Business Analysis, Data Analysis, System Analysis, Testing and Deployment of business applications experience in HealthCare/ Banking/ Pharmaceutical domains.
• Extensive experience in interaction with business user, understanding their requirement and delivering projects and other permission related solutions in time.
• Experience in gathering Business and Functional Requirements, developing Project Plan document, Business Requirement document, Mapping Documents, Functional specification document, conducting JAD sessions, Gap analysis, SWOT analysis, Risk analysis, Mitigation plan and Impact analysis, preparing Training manuals and Knowledge Transfer manuals.
• Excellent understanding of Business/Market Intelligence, Business Process Modeling, Re - Engineering, Databases, Data Warehousing, Data Mapping, Data Modeling, Data Migration and Data Integration, ETL Process.
• Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling
• Skilled in Object Oriented Analysis and Design with experience in creating Use Cases, Class Diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams, Unified Modeling Language (UML) using MS Visio and Rational Rose to extract business process workflows.
• Worked with COGNOS, Business Objects and Micro Strategy to create reports based on SQL - queries. Generated executive Dashboard reports, Standard Reports, Ad-hoc reports and Customized reports as per Business needs.
• Extensive experience working on different databases such as Oracle, My SQL using SQL Plus, DB2 and Netezza
• Proficient in writing SQL Queries for validating and verification of data structure. Generated reports using complex joins, sub-queries and aggregate functions, good knowledge of object-oriented programming.
• Experience in different management scenarios like Change Control, Quality Assurance, Project Schedules and Timelines.
• Excellent knowledge in Software Quality Assurance (SQA), effective software quality control and in developing test cases, test plans, test scripts, tests strategies in HP Quality Center with effective Content Management skills.
• Experience on different EDI healthcare transactions: 837 for submitting claims (D), 835 for payments, 270/271 for healthcare eligibility, 834 for benefit enrollment, 278 for claim attachments and 276/277 for claim status.
• Excellent Communication, Presentation and Management skills with experience in conflict resolution, creative problem solving techniques and working in a challenging environment.

TECHNICAL SKILLS

Data Modeling Tools: UML, Rational Rose, MS Visio

Reporting Tools: Cognos, Business Objects, Micro Strategy

Project Management: MS Office Suite, MS Project, Clarity

Databases& Tools: Oracle, Netezza, MySql, SQL Server, DB2, Aginity, Erwin

Methodologies: Agile, Scrum, Rational Unified process, Waterfall

ETL Tools: ACE Abinito, Informatica Power Center, MS Access

Languages: VB, C/C++, SQL,HTML

Operating Systems: MS-DOS, Linux, Windows (2000, NT, XP,VISTA,7,8)

Others: Rational Requisite Pro, MS Office, HP Quality Center, Pulse, Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Technical Lead Analyst (Business-Data Analyst)

Responsibilities:

• Worked as both Business Analyst and Data Analyst fit into one tailor made position.
• Acted as a liaison between Business users, Clients, Software development team to gather requirements.
• Worked closely with Business and conducted JAD sessions with various teams such as Developers, DBA’s, and Framework Managers to finalize the requirements.
• Performed BI(Business Intelligence) and ETL (Extraction Transformation and Load) Lead Analyst role interfacing with subject matter experts to understand and define the functional and information requirements supporting reporting applications by outlining data strategy andreport specifications and documenting these in the Specific Data Requirements Document (SDR) and Functional Requirement Documents (FSD).
• Analyzed the existing and future state database environment, modeled the future state tables and created the data mapping documents with transformation rules.
• Responsible for transforming the Functional Requirements, Business Process documents into System and IT requirement documents.
• Responsible for ensuring the "Business Rules" set forth by the business to be documented and analyzed before the implementation. Captured and Documented Business Rules to facilitate the migration of old Mainframe systems to new ETL process.
• Extracted data from Netezza using SQL on Aginity tool for analysis. Worked closely with offshore development team and conducted meetings everyday to clarify the requirements and track status.
• Reported progress against Development/Action Plan routinely to the Project Manager with recommendations for corrective actions, where necessary.
• Worked in various sprints all through the project to help and make the developers understand the functionality.
• Conducted gap analysis on existing processes and potential alternatives, performed to-be analysis by identifying, validating and implementing changes to incrementally improve process efficiency and effectiveness, and assisted in resolution of process gaps
• Responsible for re-testing the reports after being developed and tested by QA team; and signed off before sending them to UAT.
• Worked closely with UAT personnel to both ensure that their needs are met, and to provide sufficient understanding for the UAT test teams
• Managed production support issues and assign to developers and monitor that they are resolved efficiently and closed on time.
• Experience in updating SharePoint, Maintaining Documents and Version Controlling.
• Organized with the ability to complete multiple tasks under various tight deadlines with minimal supervision.

Environment: Cognos 8, Cognos 10.2.1, Aginity Work Bench, Netezza, DB2, Micro strategy, Pulse, SQL Server, SharePoint, MS Office.

Confidential, Jacksonville, FL

Business/Data Analyst

Responsibilities:

• Performed duties of team lead, trained new employees on EDI healthcare transactions such as 834, 835, 837, 270/271, 276/277 different levels of health Insurance coverage available on Marketplace.
• Acted as an SME for 834 Benefit Enrollment; assisted Mock-up teams, provided design and research data for various teams hold Subscribers’ Benefits Enrollment Data in Open Enrollment Period for subscribers for whom we are waiting to receive on 834 Transactions.
• Demonstrated Leadership and problem solving skills, took responsibility of crucial tasks, followed Agile software development process, established an effective communication among various departments (Large Accounts, Project Management Office, Business Intelligence, and ETL), and helped the team to regain confidence and motivation.
• Schedule periodic review sessions with department team members to assess progress and propose tactics in development.
• Proactively participated in extensive data profiling and analysis for Health Care Analytics.
• Designed and developed business Intelligence analytics reports using Report studio in Cognos.
• Played the role of an effective team member, which helped the team to outperform the expectations in deadline oriented environment. Good practices of our team were complimented and mentored across the board.
• Helped developers in Unit Testing their code to support development.
• Facilitated JAD sessions with internal resources to better understand the challenges, risks, and requirements of outsourcing Dental Claims processing. After collecting all the requirements came up with Requirement Traceability Matrix, Use Cases, and process flow diagrams to explain different pieces involved in the Project.
• Gathered User Requirements and Business Requirements from Business User Group and documented Business/User/Functional/Technical Requirement Specification using MS Word and MS Visio that provided appropriate scope of work for technical team to develop prototype and overall system.
• Implemented SDLC methodology, which included requirements specifications, design, analysis and testing. Followed RUP methodology with Agile/Extreme Programming and for various phases of RUP.
• Worked directly with technical IT Staff such as developers, application architect, data architect to ensure the compatibility between the as-is and to-be models.
• Responsible for reviewing of CMS Edge Server Guidelines and Creating Data mapping.
• Ensured corporate compliance and business objectives were met by partnering with internal stakeholders to manage ICD-10 impact assessments on all enterprise-wide systems.
• Assisted Business and Development team to create E-billing and Enrollment platform for Employers.
• Performed Data quality check by Score carding, created Data Dictionary and Data Trust Score logic for Trusted Information Hub Enterprise Architecture.
• Created Mapping for Data Model to integrate various enterprise applications.
• Captured data level, application level and business process level interactions according to the Service Oriented Architecture.
• Worked closely with QA team to create test cases based on different scenarios, tracking the defects using HP Quality Center.

Environment: MS Office, SQL Server, Sybase, DB2, ClearQuest, HP Quality Center, RAD, Winsql, XML, SoapUI, SharePoint, XMLSpy.

Confidential, Seattle, WA

Data Analyst/Data Modeler

Responsibilities:

• Used the Agile methodology to build the different phases of Software development life cycle.(SDLC)
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, Logical Data Models using Erwin, documenting and rolling out the deliverables.
• Normalized the database based on the new model developed to put them into the 3NF of the data warehouse.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through interviews (group and one-on-one) along with JAD sessions.
• Developed BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional using RequisitePro and Rational Rose to create/maintain: Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Came up with methods to reduce risks of releasing new upgrade to the system in production by doing a controlled of new features (upgrades).Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers.
• Conducted business-impact assessment and the results were compared with the new HIPAA 5010 standards to determine the current level of compliance and developed an action plan for approval by the project steering committee.
• Involved in meeting with Clinical Users and Clearing Houses to involving discussions regarding ICD-9/ICD-10 codes, CPT/ HCPCS codes and NCDPD Codes.
• Examined the EDI process, working directly with trading partners to enhance the secure and HIPAA Compliant electronic flow of information. Provided knowledge and support to the development teams to understand HIPAA and EDI transactions (834, 835, 837, 270, 271, 276, and 277) and processes.
• Coordinated with onsite and offshore teams for better understanding of client needs and provided quality deliverables.
• Manually generated reconciliation reports using MS Excel and Access.
• Developed, reviewed, understood and validated Testing scenarios/scripts, Defect Tracking with Clear Quest, Configuration Management with Clear Case.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Environment: Oracle, SQL Server, Erwin 8.1, Windows XP, XML, Excel, Quality Center, MS Office, MS Project, SharePoint, MS Visio.

Confidential, Houston, TX

Business System Analysis

Responsibilities:

• Created business requirement, functional, technical and ETL specification documents in support for the bank’s Asset Liability Management.
• Respond to client requests like Request for Proposal (RFPs), Request for Information (RFI) and specific Statement of Work (Sow) or Work Orders and informal responses like collaterals & references.
• Ensured compliance and transparency of all data transformations in CRDW.
• Estimated impact of discovered issues and identified and resolved root causes.
• Assisted Project Manager in setting realistic project expectations, in estimating efforts and in prioritizing tasks.
• Validated quality of existing data and performed gap analysis by comparing current state data with future business requirements and enhancements.
• Ensured, through rigorous testing, that the data are consistent with the business specifications and reflect the Bank’s current view of risk.
• Analyzed ETL jobs and mappings to document the existing business rules and transformation logics.
• Planning/Reporting/Technical mentoring - to enable knowledge transfer/communication between Management and Junior Staff
• Carried out detailed and comprehensive business analysis with Waterfall SDLC methodology.
• Use MS Visio to draw business process flow diagrams. Involved in Dimensional Modeling, Data Analysis & custom DTS package analysis and design.
• Analyzed data to find discrepancies between business requirements and system functionality.
• Identified errors in the process and collaborated with the Application Engine developers to resolve any processing issues and coding errors in a timely manner.
• Developed UAT test plan, test cases for specific business requirements, SQL test scripts to test business/functional requirements, executed test scripts, documented test results and escalated issues/defects found during testing to project team.
• Extensively used HP Quality Center\' for creating tests, logging defects, reviewing, analyzing and comparing defects.

Environment: Waterfall, MS Office 2010, MS Visio, Oracle 10g, HPQuality Center, SQL Navigator, UML, SharePoint 2010, Microsoft Project, Windows XP, Unix (AIX).

Confidential, Boston, MA

Data Analyst/Data Modeler

Responsibilities:

• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business logic.
• Created Physical Data Model (PDM) for the OLTP application using ER Studio.
• Created Data Models using IDEF1X methodology.
• Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
• Worked at conceptual and physical (using IE methodology) database level to implement and build corporate enterprise information strategies.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.

Environment: Erwin 6.0, Informatica Power Center 7.1.2, Windows, Oracle 9i, SQL Server 2000, SQL Loader, AIX 5.0, Windows 2000.

Confidential, New York

Data Analyst

Responsibilities:

• Analyzed business requirements and worked closely with the various application teams and business teams to understand business requirements and the source data.
• Understanding and Analysis of the requirement specifications of the client.
• Designed and developed PL/SQL functions, stored procedures, cursors, packages, triggers.
• Involved in writing complex queries to generate processes as per client request.
• Created Sequences to generate unique numeric values.
• Tuned complex SQL statements, complex joins co-related sub-queries which were taking too much time to run by using Explain Plan and Hints.
• Rebuild Indexes for better performance during query execution.
• Wrote extensive Exception handling procedures to handle exceptions.
• Involved in creating different kinds of partitions for managing large tables.
• Used TOAD for creating PL/SQL and SQL Scripts to debug and test the code
• Enforcing data Integrity using integrity constraints and database triggers as per data model.

Environment: Oracle9i, Erwin 4.0/3.5.x, Informatica Power Center 5.1, SQL Server, MS Office, MS Project, MS Visio UNIX, and Windows 2000

Confidential

Data Analyst

Responsibilities:

• Analyzed the DW project database requirements from the users in terms of the tables which will be most useful.
• Collected the information about the existing ODS by reverse engineering.
• Analyzed the requirements for developing Conceptual model.
• Worked on all SDLC methodologies most importantly Agile Methodology.
• Normalized and De-normalized the entities for the Data Warehouse applications.
• Defined relationships, cardinalities among entities.
• Created fully normalized till 3rd Normalization technique using Power Designer.
• Wrote PL/SQL Stored Procedures, Functions, Views, Packages and Triggers to implement business rules into the application.
• Involved in Data Loading and Data Migration. Used SQL*Loader to load data from Excel file into Temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed queries using PL/SQL and many stored procedures to do the validations.
• Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures etc).

Environment: Oracle, Siebel, Trillium, PL/SQL, UNIX, Erwin3.0, Windows XP/NT, MS Office, MS Project, MS Visio, XML, ClearCase, Informatica Power Center, Designer, Work Flow Manager.