PROFESSIONAL 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 then organize Review Meetings with the Stakeholders and End Users towards identifying the Business Critical Requirements and finalizing the 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 the 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 effective at working across multiple teams within an organization.
• Experienced in Tuning SQL statements and procedures for enhancing the 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 PROFICIENCY:

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.
• Performing the tasks of designing and developing project-specific SAS programs like producing analysis datasets, graphics and reports
• Analyzing datasets and generating statistical reports using SAS
• Modifying incoming data using SAS code by reformatting, importing, sorting, merging and restructuring
• 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 that 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 the back end of applications and websites requiring forms.
• Performed back end validation as part of forms development.
• Collaborated with the QA team for developing scenarios for validation and testing. Involved in the User acceptance Testing (UAT) and documented the test scenarios and outcomes. Worked with several off-shores teams and onshore resources. Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

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 the point of contact, for the upcoming Phase 2,3 requirements in the Confidential 3.2 releases.
• Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes
• Worked closely with ETL developers on the Various XML feeds to analyze how participant, Member, Provider data can be used with all the metrics.
• Acted also as a member of the 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 the data structure and build the target xsd of the HSIS application.
• Defining the data validation rules to run against the authorizations and claims from the transactional system. Worked as a Hands on member for the ICD-9 to ICD-10 migration project.
• Implemented the Match && Merge(Trust settings) for the Semi Enterprise MDM data of the Member for the Next gate feeds.
• Create the strategy for the Error Handling techniques and ftp jobs(Batch Jobs) for the business stake holder to review data for the Error out claims.
• Provided a strong SQL skill set for the Data Integration team to ensure the development of data feeds are implemented successfully.
• Fostered strong team work on the project by assisting fellow DAs/BAs on the Data Integration team, answered questions from business.
• Written functional and High Level documents for the EDW team- Partially helped them for re-writing the Low-level design documents for the 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 effective 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 the cost associated, values delivered and break even time
• Worked on analysis of the 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 the requirements for accommodating HIPAA 4010 and 5010 standards for EDI X12 transactions and capture these requirements for mapping purposes.
• Mapped the standard 4010 and 5010 elements to the associated Java classes for rules processing
• Mapped the Bloodhound tool (clinical editing tool) related data elements to the internal XML elements.
• Created the data dictionary for the clinical aberrancy rules
• Participated in the testing process, ensuring testing verifies the user requirements.
• Works to continually improve the quality and efficiency of business systems
• Aided in management and documentation of all project deliverables as well as 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 the CRMS quarterly. Non-HEDIS and CRMS HEDIS data warehouse ETL processes.
• Instrumental in designing and transforming the monthly manual ETL process of diamond OLTP data files, (a three day process), to an automated, weekly ETL process that only takes eight hours, a 66% processing time improvement.
• Analyzed critical business, data and application issues that were crucial for management reports and data warehouse projects, alerted and proposed possible solutions to the business owners and functional managers.
• Developed high-level business requirements, in-depth data analysis and detailed use cases for Medi-Cal pricing project that was substantial for management to negotiate new contracts with the 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 the 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 the existing Claims Direct Data Entry (DDE) application
• Worked on analysis of the Facets claims processing application in order to gather requirements to comply with HIPAA requirements.
• Conduct gap analysis between the current system and new requirements to be implemented thereby mapping the business requirements to the application
• Prepared high level and detailed system requirements documents for the application
• Analyzed HIPAA standards for 837P transactions, related to providers, payers, subscribers and other related entities.
• Identified the requirements for accommodating HIPAA standards for 837P transactions and captured these requirements to develop new GUI for the 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 the claims application.
• Involved in daily Scrums to determine the status of the project and impediments, if any.
• Involved in sprint planning meeting to identify the tasks for the sprint and getting team members acceptance/commitment for the assigned tasks.
• Involved in Sprint review meeting with the team and stakeholders to review the s from the sprint and get approvals.
• Identified the requirements that go in each sprint, collect them in the sprint backlog and collecting and managing the requirements that are not part of the current sprint into the product backlog.
• Designed the Internet based application and managed the business and design specifications in the business specific wikis.
• Write high level and low level business requirements and design mock-up screens for the application
• Analyzed the existing data model and provided suggestions and recommendations
• Validated the requirements and mock-up screen designs of new GUI for internet based application with the product owner and other stakeholders
• Conducted meeting with the team members to discuss the requirements and mock-up screens
• Involved in designing the mock-up screens of the new GUI for claims entry
• Conducted meeting with the product owner to validate the requirements and mock-up screens for new GUI
• Translated the requirements prepared for SDLC methodology to User Stories and implementing Agile methodology as a standard for the ongoing project
• Wrote user stories and acceptance criteria for the requirements of the project.
• Involved in daily scrum meeting to discuss any roadblocks or impediments in the project path
• Involved in sprint planning session to identify the features and functionalities that should be achieved by the new application
• Identified various points of integration among the new and existing applications and required integration with other IT components
• Worked closely with the business team, development team and the quality assurance team to ensure that desired functionalities will be achieved by the application
• Provided business and technical suggestions and recommendations during the project life cycle.