PROFESSIONAL SUMMARY:

• Over 7+years of experience as Data Analyst with more than 7+ years in IT, Healthcare and finance.
• Conducted Jar/JAD sessions to facilitate design and various constructs.
• Well versed in marketing processes including lead qualification, lead enrichment and lead assignment processes etc.
• Worked with Informatica Server and Client tools, experience in the Data Analysis, Design, Development, Implementation, Testing, Production Support of Database/Data warehousing /Legacy applications for various industries using Data Modeling, Data Extraction, Data Transformation and Data Loading.
• Worked on MS Office productivity suite applications like MS Word and MS Excel, Access, Visio, Outlook etc. extensive.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Excellent skills in Business Modeling and Use Case Development using UML methodology.
• Experience in Agile PLM integration with other Enterprise / legacy application is desirable.
• Ability to identify and isolate improvement and automation opportunities in businessprocessflows. Challenge business team on improvement opportunities
• Experience in writing the Korn Shell Scripts to run batch jobs in UNIX and communicate the messages to the database analysts.
• Lead an effort to create a project or an initiative plan (includes tasks, resources, and timeframes) by gaining input from appropriate parties and obtaining management sign - off and commitment.
• Accomplished in writing to end to end test plan along with regression strategy.
• Accomplished in different types of testing like black box, white-box, functional, system, integration, etc. and various models of testing like V-model and W model.
• Good experience in understanding Business Logic, current Business Process flows, Business scenarios, Functionalities and Development of test cases
• Involved in Functional testing, User interface testing of the applications which consist of Accounts, Contacts, Activities and Order
• Plan, design, facilitate and document UAT results with business team

TECHNICAL SKILLS:

UML Tools: Rational Rose / Microsoft Visio / Enterprise Architect 4.0

Version Tools: Clear Case/ Clear Quest, Clarity, Doors

Databases: Oracle, DB2, Teradata, MS Access, SQL Server

Reporting Tools: Visual Basic 6.0, Win Runner, Load Runner

Database Skills/Tools: Stored Procedures, Triggers, and Packages/ Toad

Languages: SQL, PL / SQL, VB Script, Java Script, C, C++, HTML

Business Intelligence: Business Objects 5.1.6, XI Release 2 (Designer, Reports, Broadcast

Tools: Agent, Web Intelligence, Oracle Reports 6i

Front end tools: Microsoft Project, Rational Portfolio Manager

Internet Tools: HTML, XML, DHTML, VB Script, ASP

Operating Systems: UNIX, SUN SOLARIS, Windows XP, Windows 98/2000

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Worked on gap analysis for various assignment functionalities including assignment groups and assignment rules.
• Prepared and developed monthly sales management report from different investments companies and different format by using Access (data design, complex Join), advance lookup features of Excel, Macros, pivot tables, crystal report for Sales.
• Turned around the investment process and significantly improved returns on portfolio.
• DevelopedData Mapping, Data Governance, TransformationandCleansingrules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Created and modified tables, views and indexes; PL/SQL stored procedures, functions and triggers according to business requirement.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Responsible for analyzing data from client extracts and identifying data quality issues
• Provided direction to less experienced software engineers regarding MDM platform development, processes, and product architecture.
• Maintained and created test data required for the test execution at the test planning stage.
• Queried the databases, wrote test validation scripts and performed the System testing.
• Involved in extensive DATA validation by writing several complexSQLqueries and Involved in back-end testing and worked with data quality issues.
• Conducted user interviews, JAD sessions, brain storming and surveys. Gathered and analyzed the requirements using Rational Requisite pro.
• Responsible for creating Business Requirement Documents (BRD), Functional Requirement Specification (FRS) document, User Requirement Specifications (URS) document, UML Modeling - Use Case Diagrams, object diagrams, Activity Diagrams,Sequence Diagrams.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Coordinated activities with supervisor for re-mapping data warehouse and refined existing SQL code for expediting reporting mechanism and improving accuracy of reports.
• Defined and documented clear and complete detailed business requirements and functional specifications using the SDLC methodology from the Business team.
• Designed use-cases and use-case models to further refine the requirements and understand the business processes. Worked extensively in Rational Requisite Pro to organize and catalog requirements, documents, and use-case documents.

Environment: XML, PLM, UNIX, PL/SQL, Oracle, UML, MS Excel, Windows 2000, SQL Server 2005, MS Office, ETL, Rational Requisite Pro, Rational Rose, UAT, MS Visio, MS excel, MS PowerPoint, Rational XDE, .Net

Confidential, New York, NY

Data Analyst

Responsibilities:

• Applied Unified Modeling Language methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram in Rational Rose.
• Continuous analysis of utilized mutual funds via quantitative and qualitative data, especially in regards to the fund’s investment process and the portfolio manager information.
• Maintained/updated system data flow chart, Visio documents, and system documentations
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Performed data normalization as part of building up a department wise data mart on top of the current enterprise level data warehouse.
• Design and develop ETL mappings using Informatica to support the reporting data mart.
• Involved in requirements gathering for MDM tool implementation and user workflow processes.
• Acted as a liaison between the Data Warehouse Management group and end-users to understand, identified and resolved data discrepancies/errors and established one version of the truth in applying business rules to data sources while maintaining data integrity and provided timely answers to assist business units in making business decisions.
• Re-engineered the business model using data modeling tools like MS Visio.
• Conducted mass user interviews and gathered business requirements using JAD sessions with SMEs, Fund Managers and Portfolio Managers
• Data Warehousing and Mining: Concepts, Methodologies, Tools, and Applications
• Worked on data profiling including column profiling, dependency profiling, redundancy profiling.
• Developed process for capturing and maintaining metadata from all data repository components.
• Performeddata analysisanddata profilingusing complexSQL (T-SQL, PL/SQL)on various sources systems including Oracle andTeradata.
• Implemented SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Coordinated User Acceptance Testing (UAT), developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Conducted JAD sessions with Business users and stakeholders across the globe to identify the requirements, use case analysis and outlining business rules.
• Gathered requirements during inception phase, documented and delivered functional requirement document (FRD), and segregated them into high level and low level requirements for eCase Management System.

Environment: UML,PLM, PL/SQL Server 2005, ETL, MS Excel, Macros, MS Office, UNIX,UAT, SAP, Rational Requisite Pro, Rational Rose, Oracle, MS Visio, MS excel, MS PowerPoint, Rational XDE, .Net

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

• Primarily responsible for ensuring service delivery while coordinating with Business Users, Technical and Quality teams.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Extracted and manipulated large customer/health care service providers' data sets using SQL and created multi-dimensional visualizations/dashboards/pivot tables/charts and used advance functions in MS Excel.
• Gathered and documented MDM application, conversion and integration requirements.
• Facilitated design negotiation and decision making between application teams (Master Data Management (MDM), Content Management)
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.
• Documented data quality and traceability documents for each source interface.
• Developed detailed Use cases and User Interface specifications for the features implemented, Prepared Activity Diagrams (UMLs)
• Conducted meetings, interviews and JAD sessions with SMEs, business users and stakeholders to understand their business process and elicit requirements.
• Handled project planning, unit testing, functional testing and user acceptance testing (UAT).
• Performed proactive Gap analysis on the application to identify the business gaps and reported to business team.
• Reviewed/Analyzed functional requirement specifications, system requirements and technical specifications and developed/documented test requirements.
• Plan and execute system testing and interface impact testing based on project plan.
• Developed test plans, designed and developed test cases after thorough requirement analysis.
• Performed both manual testing as well as automated testing.
• Conducted Functional, Integration, System, Regression, Positive, Negative, White and Black Box Testing.
• Test Management and Test Case generation was done using Test Case Management System tool.
• Maintained and created test data required for the test execution at the test planning stage.
• Enhanced test scripts by parameterization, introducing check points, synchronization points.

Environment: Windows 2003,BPM, Win Runner, MS Excel, Microsoft Project 2008, MS Project, Pricing Module, Windows XP, UAT, MS Visio, Oracle, UML, UNIX, HTML, Oracle 10g, Web-Logic, Business Objects, and Test Director7.6, SQL.

Confidential, San Diego, CA

Data Analyst

Responsibilities:

• Assisted the Developer, while working in the agile team, in terms of the BOE Universes and reports.
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including Oracle andTeradata.
• Exposed to using ICD 9/ICD 10/ANSI/HL7 coding standards in Medicare and Medicaid domains of the healthcare systems and industry for both inpatients, outpatients, Reimbursement methodology.
• Performing troubleshooting of various network-related issues and X12 data. Reviewing logs, transactions and correcting data issues. Troubleshoot EDI 834,835 data flows within production/test environment.
• Collected the information related to ongoing application upgrade and their impact on ICD-10 implementation and created awareness within the departments regarding the need, impact, benefits and risks of ICD-10 code application
• Responsible for attaining HIPAA EDI, 837, validation from Medicare, Medicaid and other payers of government carriers.
• Worked on data profiling including performing assessment whether metadata accurately describes the actual values in the source database.
• Established a business Analysis methodology around the SDLC Waterfall, helped to develop use cases, project plans and manage scope.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Queried relational databases using SQL on a daily basis to resolve operational issues and assist business and IT in better understanding of business requirements.
• Worked with the Data Modeler and drafted the Logical Data Requirement towards closing these gaps.
• Analyzed and resolved the ongoing issues with the Data Warehouse and the upstream and downstream applications.
• Defined and documented clear and complete detailed business requirements and functional specifications using the SDLC methodology from the Business team

Environment: RUP, Java, Rational Rose, Oracle, MMIS, HIPPA, EDI,DB2, SQL, QNXT,MS Share Point, Team Track, MS Visio, MS Office.