SUMMARY:

• Business and Data Analyst professional with over 10 years experience in large corporations.
• Strengths include development of specific business logic and financial transaction processing methodologies.
• Proven experience using SQL scripting for application development, decision support and database conversions.
• Ability to navigate multiple concurrent initiatives with changing priorities for the overall good of the team.
• Successful in matrixed - managed organizations. Does not get caught up in “politics.”
• Personable. Proactive communicator.

TECHNICAL SKILLS:

• Business Analysis
• Healthcare business experience
• Requirements gathering / Interviewing / Business needs assessment
• Data Analysis
• Systems and Data integration
• SQL
• Business and Data flow Diagrams

TECHNICAL SKILLS:

Operating Systems: UNIX (HP-UX/SCO/Solaris), Windows 7

Databases: Oracle, Sybase, Teradata, SQL Server

Programming Languages: SQL, PL/SQL, Hyperion SQR Production Reporting

Other Tools: Cognos Impromptu, Hyperion Intelligence, Embarcadero Rapid SQL, TOAD, SQL Developer, Teradata SQL Assistant, SQL Server Management Studio

Methodologies: SDLC, Waterfall Method, Agile

EXPERIENCE:

Confidential, San Antonio, TX

Data Analyst

Responsibilities:

• Assisting in the landing of asset data sourced from COTS and internally developed systems for downstream consumption in new management reporting solution.
• Active in both data sourcing and data quality efforts by working to ensure accuracy of the existing and new inbound data sources.
• Used Microsoft Visual Studio for profiling inbound source data to ensure accuracy and completeness. Conducted follow up research on data quality issues as required.
• Worked to identify then validate data attributes required to support all I. Confidential . Asset reporting activities.

Confidential, Richardson, TX

Business Analyst / Reporting Analyst

Responsibilities:

• Assigned to the Retail Segment of Affordable Care Act ( Confidential ) project as a Business Analyst. Worked with QA group creating traceability matrix linking Functional Requirements to test scenarios for 2015 product releases.
• Reporting Analyst tasked with developing high level requirements for reporting outcomes of point of contact efforts for HEB insured membership. Collaborate with data delivery team to capture source level field information that validated that business needs could be met.

Confidential, Austin, TX

Reporting/Data Analyst

Responsibilities:

• Analyst responsible for creating SQL extract scripts to report customer experience data for Confidential & Confidential Emerging Business Market project. Documented ETL requirements including transformation logic in source to target mappings for extract files transmitted to client.
• Data analyst assigned to reporting team; assisted in creating ad hoc SQL extracts to report customer experience to Verizon management.

Confidential, Richardson, TX

Business Analyst

Responsibilities:

• Wrote and validated Business Rules for Encounters Workstream. Conducted rules review meetings then scheduled follow up interviews to complete functional requirements. Captured all requirements in the Business Requirement Document (BRD) and Customer Requirement Specifications (CRS).
• Scheduled and facilitated Joint Application Development (JAD) sessions to gather and validate Business Rules for NM Medicaid project. Scheduled project meetings and reviews for multiple Work Groups to gather functional requirements. Captured requirements in Business Requirement Documents (BRD) and Customer Requirement Specifications (CRS) to describe needs, features and dependencies.
• Developed traceability documents describing Business Rules across multiple Work Groups on the project. Defined, and then independently performed Business Rules analysis to ensure adherence with, and compliance to State Government Contractual Language.
• Documented ETL requirements for sourcing and loading claims encounter data into the Encounter Quality System using Waterfall method of requirements gathering.
• Assigned to the Affordable Care Act ( Confidential ) project as a Business Analyst on the Summary of Benefits and Coverage (SBC) Work Group. Developed high level requirements for both the generation and delivery points of SBC documents to BCBS membership.
• Worked in collaboration with team assisted in documenting business, user and system requirements using appropriate methods to describe statements of the goals, objectives, and needs for stakeholders

Confidential, Dallas, TX

Analyst

Responsibilities:

• Responsible for documenting embedded SQL scripts with in a suite of COTS legacy reports prior to conversion to new in house reporting solution.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.
• Assisting in integration of inbound hospital data from proprietary off the shelf third party application into EDW; tasks assigned included data profiling and validation.
• Analyst responsible for developing functional specifications and system requirements new reporting solution.

Confidential, Richardson, TX

Business Data Analyst

Responsibilities:

• Business Analyst in support of high level system documentation for ICD 9 to ICD 10 procedure/diagnosis code conversion for Enterprise Reporting Workstream. Worked to elicit, analyze, communicate and validate requirements for changes to business processes, policies for one or many information systems. Collaborated in documenting business, user, functional, and system requirements using appropriate methods to describe statements of the goals, objectives, or needs of a particular stakeholder or group of stakeholders. Translate high-level business requirements into functional specifications in support of code conversion.
• Technical Data Analyst working on Confidential . Assisted in requirements gathering, writing technical business rules and metrics definitions in early phases of Confidential . Transitioned to team tasked with identifying, profiling data, and documenting data flows from source systems to reporting data mart. Responsible for writing mapping documents outlining both how to acquire and land data for client reporting. Worked on issues resolution and production support as assigned during life cycle of project.
• Among the Business Analysts assigned to the Integrated Data Mart (IDM). Participated in the collaborative effort to produce documents used to trace data from multiple source systems and document the ETL process. Responsible for contributing to and supporting the final artifacts handed over to the QA team for process validation. Supported the change management process during QA by updating the mapping documents.
• Member of the support team assigned to the Operational Data Store ( Confidential ) project. Prepared source to target mapping documents which detailed data requirements from both the business and application including sources of information as well as transitional data stores.
• Assigned to Confidential Data Warehouse project team to assist in creating report maps.
• Compiled mapping spreadsheets including pseudo code used to query the Confidential Data Warehouse. Documents were used by the reporting team to develop the reporting solution for the Confidential Data Warehouse.

Confidential, Austin, TX

SQR/Teradata Consultant

Responsibilities:

• Responsible for updating existing Hyperion SQR code set to run against a Teradata database.
• Participated in conversion effort to re-write production Hyperion SQR reports and SQLPlus scripts to execute against a Teradata RDBMS.
• Tasked with updating the current SQL code to ANSI standard SQL for use in a Teradata database.

Confidential, Austin, TX

Application Developer/Data Warehouse Developer

Responsibilities:

• As a member of BI/Data Warehouse team helped to support the daily Informatica process used to populate the Forrest Products financial data warehouse.
• Created new Informatica mappings or modified and updated existing Informatica mappings as business requirements were changed and refined.
• Created BQY files in Hyperion Intelligence used in the development, maintenance, and integration of BI/Data Warehouse reports for accounting.
• In a customer facing role met regularly with project managers and technical leads to assess customer's business objectives and system requirements.
• Collaborated with other team members for 24/7 on call technical support to ensure on-time product delivery.
• Built business relationships to integrate activities with other IS& Confidential departments to ensure successful implementation of project support efforts.

Confidential, San Antonio, TX

Sr Data Warehouse Analyst

Responsibilities:

• Member of data warehouse team responsible for supporting and enhancing existing reports for delivery across the enterprise to a broad user community including senior management.
• Developing new reports and supporting existing production reports using Cognos Impromptu
• Shared responsibility for data mining and validation using Oracle based tool set against an Oracle 9i database.