SUMMARY:

• Defined ability to analyze data/information, interpret & recommend solutions for complex problems
• Refined current business processes and engineered coherent methodologies for top management
• Facilitated QA/UAT on Data Warehouse & helped resolve any technical issues found with team/IT
• Established, innate skills to quickly learn new software, applications, processes & procedures
• Proven leader in training & supporting business end - users on new BI Technologies implemented

TECHNICAL SKILLS:

• MicroStrategy Software Application for Business Intelligence Reporting & validations
• SAP Business Objects 4.2 - Web Intelligence Software/BI Data Reporting Systems
• Assist with Data Modeling and Database Design & (ETL) Data flows into Data Warehouses from many disparate sources and systems
• Extensive Testing experience performing detailed QA/UAT best practice testing processes for both Agile and Waterfall SDLC.
• Develop Structured Query Language (SQL) queries using PLSQL Developer tool to extract required datasets for data profiling and in-depth analysis.
• Expert Business Intelligence Analyst leading & managing Enterprise Data Governance policies & processes establishing the Companywide Data Dictionary with all approved Meta-data for reference definitions, formulas, & fields in Reports
• Oracle 12c and Neteeza very large Database Environments experience
• Guidewire Enterprise Insurance Platform (ERP) System across Policies, Claims, Billing, & Reports
• Track-it & Census Software for all BI Development tickets & workflow management
• IT ServiceNow and BMC Remedy for work & production incidents resolution.
• Extremely Proficient Expert with all Microsoft Office Suite (Outlook, Excel, Word, PowerPoint, Access, Project & Visio)
• SharePoint Document Library to publish all IT assets for sharing with other teams
• JIRA QA Software and ticket tracking system
• HP Quality Center QA Software for managing issues & test cases
• Extensive & in-depth Internet research & analysis; products, markets, industries, etc.
• Distinct PowerPoint decks with visual charts, tables & diverse graphical representations of vital information

PROFESSIONAL EXPERIENCE

Sr. Business Systems Analyst

Confidential, Irvine, CA

• Institutional Billing Application (iBill) BSA Invoicing Global Asset Management Fees
• Project lead to upgrade Application, Servers, & Databases to newer environments
• Implement a new SAP BO 4.2 Reporting solution for iBill Application business users
• Corporate-wide Project Initiative team for CIRRUS VM cloud computing environment
• Manage and facilitate on-going iBill Software vendor relationship with Confidential
• Write Complex Functional and Technical Business Specifications for IT development
• Provide Production Support root cause analysis with findings and recommendations

Sr. BI Business Systems Analyst

Confidential, CA

• Lead EDW BSA for all Guidewire Enterprise System Project Initiatives & support
• Consult & Collaborate closely with Business Partners to provide ideal solutions
• Document Functional and Technical Business requirements for EDW Project teams
• Drive the full SDLC for EDW Team through inception/design/dev/testing/deployment
• Develop Data Mappings and Data Flow Diagrams for IT systems and processes
• Analyze Informatica ETL Mappings gaining insight on Data Transformations/Logic

Sr. Business Intelligence Analyst

Confidential, CA

• Conduct business area analysis, interview users for requirements gathering/ definitions & write BI documentation for a comprehensive library of reusable assets
• Develop Custom Complex Analytical Reports for stakeholders with Key Performance Indicators (KPI’s) & metrics presenting info with Business Objects Webi4.2 software
• Work with BI and IT resolving all DW data issues & recommend optimal solutions
• Manage SDLC & create QA Test Cases for new DW development for Production
• Business Subject Matter Expert on all Data, Structures, Software, and Designs
• Perform analytical processes & apply critical thinking to DW data identifying vital relationships & trends to find & establish New Business Intelligence for the company

Report / Data Analyst

Confidential, CA

• Websites “Expert” providing technical support for 150 field managers & 800+ dealers
• Ensured all sales/service data & information sent to/received from vendor’s via FTP Daily was accurate and without any interruptions. Logged & tracked all data in Excel
• Write SQL queries & procedures to access required datasets for project analyses
• Design comprehensive ad-hoc daily, monthly, quarterly & yearly reporting solutions
• Work as valued C.S. team member closely with all levels of management to isolate any problem issues & make solution recommendations to improve business results
• Develop PowerPoint presentations visually summarizing key business findings

Project Analyst

Confidential, NJ

• Project Analyst in charge of all major Executive client accounts and new projects
• Conducted meetings & presentations with all levels communicating project’s status
• Formulated quotes, contracts, work orders, change orders & invoices into system
• Facilitated new workflow processes between sales & production departments
• Managed, updated and maintained Salesforce CRM database, software & systems