SUMMARY

• Over 8 years in the Information Technology field leveraging business requirements for the development of technical solutions
• Over 6 Project Management, Six Sigma Methodologies
• Business and Data Analysis, Business Intelligence, Business Process Improvement, Customer and Supply Management and Data Quality.

BUSINESS AND TECHNICAL SKILLS

Information Technology Skills

• Business Intelligence: COGNOS Query and Report Studio, SAP ERP CRM, SRM
• Applications: SQL SERVER 2012, MS Office 2013 / Databases: MS Access, ORACLE, Report Builder 3.0
• Methodologies: Six Sigma, Project Management, SDLC, ETL, UML Data Modeling

Business Skills

• Excellent verbal- Written Communication Bilingual Spanish-English / Problem solving / Analytical Thinking skills
• Excellent People - Technical / Organizational - Analytical / Project Management skills
• HEDIS, DRG, SOX and HIPPA

PROFESSIONAL EXPERIENCE

Business Analyst / Project Manager

Confidential

• Utilizes ETL methodology to Extract data from different data sources utilizing SQL, transform data into meaningful pivot table report analysis and load information into secured environments such as Shared point site and developed PIVOT Tables in order to highlight meaningful information for requestors review. Conduct frequently meeting with stockholders to gather business requirements for scope formulation and the creation of business requirements documentation BRD
• Perform Data analysis under HEDIS measurements in support of preventive medicine strategies. Conducts business process improvement analysis, process testing and validation based on various Six Sigma tools.
• Discuss Data Modeling rules relational modeling of queries and data in server environment with other data analysts in order to specify data integrity.
• Collaborate with project managers during SCRUM meetings to find solutions to scope creeps issues. Perform UAT on claims processing system installation, documents system work flow, project charter and SOP.
• Conduct preliminary business requirements analysis, action, and process improvement planning utilizing SDLC methodology for business process improvement.

Business Analyst

Confidential

• Performed data extraction utilizing PL/SQL via Manager Studio, analyze and discuss relevant HEDIS measurement information with stockholders. Created and design Business Dashboards for the formulation of provider network KPI
• Provided end users support and technical troubleshooting on Hospital registration and billing applications, ADMINISTRATOR PLUS COGNOS ORACLE based application
• Developed Decision Support Systems DSS in MS Access, that combine data from existing sources, tailored to specific user groups and business needs. Worked with key system users to identify user requirements under HIPPAA regulations and continuously improve their ability to access information easily and efficiently.
• Interacted with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions. Defined testing scenarios and develop test scripts. Support clients with the execution of test scripts. Provided status and issue reports to the Project Manager on a regular basis.
• Designed and developed automated actionable reports using Report Builder technology to inform managers in a timely fashion. Conduced analysis and make recommendations to business unit based on findings of analysis.

Business Analyst

Confidential

• Translated business needs into functional and technical requirements for COGNOS business intelligence solutions across business and departments. Designed, developed, tested and maintained reporting and analytics solutions dashboards, scorecards, reports, etc. . Supported the standardization of data definitions, performance metrics and reporting formats throughout the organization as appropriate.
• Served as a business intelligence subject matter expert across the organization and assist users with reporting and analysis activities and tools, including ad hoc reporting.
• Responsible for providing knowledge-based, content or technical expertise for the development and implementation of customer applications COGNOS SAP Business Objects xi2.0
• Responsible for the analysis of scope formulation for fraudulent activities against US Health Department utilizing CRM technology that led to the saving the US Government CMS 344MM

Senior Business Analyst

Confidential

• Provided analytical data support for finance Hospital billing Department in order to minimize discrepancies on patients' reimbursements and copay overpayments. Evaluated current systems and processes for efficiency and effectiveness in order to identify systems improvements.
• Developed project scopes, Project Charters, communication, action plans and Risk Analysis plans in order to define spend and financial analysis
• Performed claims cost analysis and data analysis using SQL programming ORACLE COGNOS . Evaluated impact of business and environmental changes on organization historical/projected claims. Developed and maintained standardized reporting on utilization trends.
• Performed data analysis to address emerging trend in medical cost. Prioritized Ad hoc requests.
• Made recommendations for existing Patients to Providers billing audits saving the organization 1.2MM

Business/Marketing Analyst

Confidential

• Extract data using SAP ERP to support ORACLE COGNOS CRM / SRM sales and marketing teams in efforts to acquire and retain customers and suppliers. Consulted with unit business managers on logistics management.
• Served as a functional team liaison between business communities LATAM and sales-marketing teams.
• Collected, prepared and interpreted data for marketing / sales units for decisions and strategy development.
• Analyzed client-reported ORACLE COGNOS Financials, Supply Chain, Manufacturing, or CRM issues, and resolve them in a timely and professional manner. Some issues can be very complex.
• Contributed to the implementation of Oracle based Applications utilizing SLDC methodology to meet client requirements and document application set-ups and communicate solutions to the client.
• Gathered and analyzed CRM requirements across departments and management stakeholders. Presented and discussed needs and solution options to management including visual layouts of the CRM reports that meets managers' requirements.
• Construct deliver cost-benefit analysis for potential CRM solutions including cost of solution, timing of implementation, operating expense, capital expense, training and lost productivity.
• Maintain regular verbal and written communication advising management of project progress.
• Create and deliver a project plan for implementation of the chosen CRM