SUMMARY

• Experienced IT Professional with 8+ years as a Business/Data Analyst with extensive experience in Healthcare, Retail industry and Finance domain.
• Experience in developing both client - server and web-based applications.
• Converting User Requirements into Business Requirements and User and Functional Requirement Specification.
• Understanding of Business Rules and implementing them into Business Process Flow.
• Conducting Requirement Analysis, Feasibility Studies, Risk Analysis, and Adaptability Studies, Base lining Acceptance Criteria and Deliverables, and tan organize Review Meetings with teh Stakeholders and End Users towards identifying teh Business Critical Requirements and finalizing teh Software Requirements Specifications (SRS).
• Created Functional and User Acceptance Test Plans, Test Strategies Test Cases, and Test Scenarios to measure requirements and provide a Head Start for teh QA Team.
• Used MS Project for scheduling deadlines, resources, and facilities.
• Diversified experience in Data Analysis, Business Analysis and Software Testing.
• Experience working with Oracle, SQL Server, DB2 and Teradata RDBMS systems.
• Experience in SQL, PL/SQL, stored procedures, functions, packages.
• Strong working knowledge of SQL Querying tools like SSMS, Toad and Teradata SQL Query Assistant.
• Good business understanding and TEMPeffective at working across multiple teams within an organization.
• Experienced in Tuning SQL statements and procedures for enhancing teh load performance in various schemas across databases.
• Strong understanding of Normalization. Good understanding of Data warehousing concepts like star and snowflake schema and well as fact and dimension tables.
• Good understanding of ETL concepts and related technologies. Some experience working with migration of data cross platforms like Oracle, SQL Server and Teradata.
• Strong understanding of DWH concepts like data mining, data quality, data profiling, data cleaning, data scrubbing and data validation.

TECHNICAL SKILLS

Requirement Tracking: Rational RequisitePro, Mercury's Test Director

Automation Testing Tools: Rational Robot, WinRunner, LoadRunner, Quick Test pro

Management Tools: Rational ClearQuest, Test Director, Quality Center, Crystal Reports,ERwin

Languages: C, C++, SQA Basic, SQL, TSL.

Operating Systems: MS Windows NT/98/2000/XP, UNIX

Web/Design Tools: HTML, MS Front Page, Flash, Adobe Photoshop, MS Paint, HTML, XML

Databases: Sql Server 2008,2012,2014,DB2,Oracle, MS Access, Toad

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Data Analyst/Optimization

Responsibilities:

• Optimizing predefined SQL queries.
• Writing SQL scripts from scratch.
• Modifying Source to Target mapping (STTM) as per business needs.
• Working closely with QA team to ensure final testing at UAT environment.
• Currently on Integrated development environment for working with SQL in Oracle database.
• Developed a data profiling strategy to ensure data integrity for all feeds using Informatica Analyst v9.x. created ODBC connections from Informatica Analyst to various source systems.
• Aggregate and mine large volumes of data into valuable analytical insights based on acquisition expense opportunities and risks.

Confidential, Wilmington, DE

Data Analyst

Responsibilities:

• Aggregate and mine large volumes of data into valuable analytical insights based on acquisition expense opportunities and risks.
• Compile senior management presentations on a weekly/monthly/ad-hoc basis
• Analyzed campaign performance and provided insights on trends projections and variances against forecast and budget.
• Involved in monitoring months on book customer engagement key performance indicators and recommended strategy improvements.
• Created reports on trend analyses summary and recommendation for new account premium redemption rates with focus on maintaining annual financial objectives.
• Developed a data profiling strategy to ensure data integrity for all feeds using Informatica Analyst v9.x., created ODBC connections from Informatica Analyst to various source systems.
• Aggregated and mined large volumes of data from Teradata/Oracle into valuable analytical insights based on acquisition expense using SAS Base and Macros.
• Extensive use of SAS, SQL and Excel (Pivot tables, VLOOKUPS, Macros).
• Expertise in SQL.

Confidential, Atlantic City, NJ

Sr. Data Analyst

Responsibilities:

• Working as a support professional on a project dat required developing data for SQL Server 2012 and DB2.
• Tracking Shipment from foreign countries, Receiving and Delivering to Confidential Stores for (Halloween).
• Developed queries, triggers, views, procedures, assertions and functions using SQL, PL/SQL.
• Utilized SQL Plus to analyze teh back end of applications and websites requiring forms.
• Performed back end validation as part of forms development.
• Collaborated with teh QA team for developing scenarios for validation and testing. Involved in teh User acceptance Testing (UAT) and documented teh test scenarios and outcomes. Worked with several off-shores teams and onshore resources. Worked extensively with teh QA team for designing Test Plan and Test Cases for teh User Acceptance Testing.
• Created teh SQL scripts for demonstrating teh prototypes and for verifying teh result sets
• Verified teh Business Scenarios on new builds to allow extended testing by teh QA team.
• Writing SQL Codes on daily Basis.

Confidential, Danville - PA

Business Analyst / Data Analyst

Responsibilities:

• Developed a data profiling strategy to ensure data integrity for all feeds using Informatica Analyst v9.x., created ODBC connections from Informatica Analyst to various source systems.
• Quickly ramped up to become teh point of contact, for teh upcoming Phase 2,3 requirements in teh Confidential 3.2 releases.
• Created ERWIN reports in HTML, RTF format depending upon teh requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply teh data model changes
• Worked closely with ETL developers on teh Various XML feeds to analyze how participant, Member, Provider data can be used with all teh metrics.
• Acted also as a member of teh Quality Assurance team, identifying source to target mapping (STTM) and requirements defects, and documenting recommended solutions
• Took strong initiative to lead integrating data coming multiple domains(Patient && Member) by understanding teh data structure and build teh target xsd of teh HSIS application.
• Defining teh data validation rules to run against teh authorizations and claims from teh transactional system. Worked as a Hands on member for teh ICD-9 to ICD-10 migration project.
• Implemented teh Match && Merge(Trust settings) for teh Semi Enterprise MDM data of teh Member for teh Next gate feeds.
• Create teh strategy for teh Error Handling techniques and ftp jobs(Batch Jobs) for teh business stake holder to review data for teh Error out claims.
• Provided a strong SQL skill set for teh Data Integration team to ensure teh development of data feeds are implemented successfully.
• Fostered strong team work on teh project by assisting fellow DAs/BAs on teh Data Integration team, answered questions from business.
• Written functional and High Level documents for teh EDW team- Partially halped them for re-writing teh Low-level design documents for teh ETL and Reporting purposes.

Confidential, Providence - RI

Business / Data Analyst

Responsibilities:

• Maintained data consistency, database integrity and reported instances of data corruption.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for reports.
• Perform source-to-target mapping (STTM) and building database schema in an SQL 2008 environment including creating scripts and procedures for production migration
• Implemented business rules on data using Stored Procedures, Functions and Packages.
• Worked extensively on SQL Server 2005/2008, MS Access
• Solid program development and business process knowledge - utilized TEMPeffective communication skills
• Performed data quality checking.
• Used Teradata OLAP functions like random, qualifies, top n, csum, sample and random. Teradata SQL performance tuning.
• Data migration between different environments and Third Party Databases.
• Using Oracle SQL, SAS procedures, packages, functions, database triggers to developing and execute reports for performance and response purposes
• Created drill down analysis reports using SQL Server Reporting Services.
• Extracted data from Teradata and Oracle and created pivot tables in Excel.
• Created Transformations and Mappings by using Informatica Designer
• Processing tasks using Workflow Manager in order to move data from multiple sources into targets.
• Examines existing data and makes recommendations for improvement/efficiency. Resolved requirements and design issues.
• Involved in meetings with director of analytics, project manager and other stakeholders to identify teh cost associated, values delivered and break even time
• Worked on analysis of teh Facets claims processing application in order to gather requirements to comply with HIPAA 5010 requirements.
• Analyzed HIPAA 4010 and 5010 standards for 837P EDI X12 transactions, related to providers, payers, subscribers and other related entities.
• Identifying teh requirements for accommodating HIPAA 4010 and 5010 standards for EDI X12 transactions and capture these requirements for mapping purposes.
• Mapped teh standard 4010 and 5010 elements to teh associated Java classes for rules processing
• Mapped teh Bloodhound tool (clinical editing tool) related data elements to teh internal XML elements.
• Created teh data dictionary for teh clinical aberrancy rules
• Participated in teh testing process, ensuring testing verifies teh user requirements.
• Works to continually improve teh quality and efficiency of business systems
• Aided in management and documentation of all project deliverables as well as training knowledge based articles.

Confidential, Alameda, CA

Business / Database Analyst

Responsibilities:

• Spearheaded life cycle implementation of McKesson HEDIS (Health Plan Employer Data Information Set) and CRMS (Care Enhance Resource Management Software) quarterly data warehouse projects.
• Automated teh CRMS quarterly. Non-HEDIS and CRMS HEDIS data warehouse ETL processes.
• Instrumental in designing and transforming teh monthly manual ETL process of diamond OLTP data files, (a three day process), to an automated, weekly ETL process dat only takes eight hours, a 66% processing time improvement.
• Analyzed critical business, data and application issues dat were crucial for management reports and data warehouse projects, alerted and proposed possible solutions to teh business owners and functional managers.
• Developed high-level business requirements, in-depth data analysis and detailed use cases for Medi-Cal pricing project dat was substantial for management to negotiate new contracts with teh delegated vendors.
• Own ETL rules for data transfer from different Teradata databases to DataWarehouse
• Conduct Enterprise Analysis and define Solution Scope and Solution Approach
• Analyzed, designed, developed and implemented 834, 837 HIPAA EDI maps for several trading partners.
• Developed and optimized convoluted stored procedures, scripts, Extraction Transformation and Load (ETL) process and database objects.
• Actively involved in performance tuning at source, transformation, target and workflow levels.
• Designed and developed data mappings based on teh business requirements and business rules to load data from OLTP legacy source text files to optimized relational target tables.
• Support Unit, Integration, Regression and UAT testing

Confidential, Nashville, TN

Sr. Business Systems Analyst/Requirements Analyst

Responsibilities:

• Analyzed teh existing Claims Direct Data Entry (DDE) application
• Worked on analysis of teh Facets claims processing application in order to gather requirements to comply with HIPAA requirements.
• Conduct gap analysis between teh current system and new requirements to be implemented thereby mapping teh business requirements to teh application
• Prepared high level and detailed system requirements documents for teh application
• Analyzed HIPAA standards for 837P transactions, related to providers, payers, subscribers and other related entities.
• Identified teh requirements for accommodating HIPAA standards for 837P transactions and captured these requirements to develop new GUI for teh internet based application.
• Identified claims processing functions for different payers including Medicaid, Medicare and other commercial payers.
• Worked with CMS 1500 claims standard required for Medicare and Medicaid processing and utilized it to provide a CMS 1500 view within teh claims application.
• Involved in daily Scrums to determine teh status of teh project and impediments, if any.
• Involved in sprint planning meeting to identify teh tasks for teh sprint and getting team members acceptance/commitment for teh assigned tasks.
• Involved in Sprint review meeting with teh team and stakeholders to review teh achievements from teh sprint and get approvals.
• Identified teh requirements dat go in each sprint, collect them in teh sprint backlog and collecting and managing teh requirements dat are not part of teh current sprint into teh product backlog.
• Designed teh Internet based application and managed teh business and design specifications in teh business specific wikis.
• Write high level and low level business requirements and design mock-up screens for teh application
• Analyzed teh existing data model and provided suggestions and recommendations
• Validated teh requirements and mock-up screen designs of new GUI for internet based application with teh product owner and other stakeholders
• Conducted meeting with teh team members to discuss teh requirements and mock-up screens
• Involved in designing teh mock-up screens of teh new GUI for claims entry
• Conducted meeting with teh product owner to validate teh requirements and mock-up screens for new GUI
• Translated teh requirements prepared for SDLC methodology to User Stories and implementing Agile methodology as a standard for teh ongoing project
• Wrote user stories and acceptance criteria for teh requirements of teh project.
• Involved in daily scrum meeting to discuss any roadblocks or impediments in teh project path
• Involved in sprint planning session to identify teh features and functionalities dat should be achieved by teh new application
• Identified various points of integration among teh new and existing applications and required integration with other IT components
• Worked closely with teh business team, development team and teh quality assurance team to ensure dat desired functionalities will be achieved by teh application
• Provided business and technical suggestions and recommendations during teh project life cycle.