Business Intelligence Report Developer / Engineer Resume Profile USA

Reference Id: 83898     Posted on Sunday 20th September 2015      Business Analyst



Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

Business Intelligence Report Developer / Engineer  Resume Profile USA

Talented Technical Project Manager / Business Analyst with over 10 years of Business Intelligence and Analytics experience in Telecom, Software Development and Healthcare

 

SUMMARY OF QUALIFICATIONS

 

  • Expert in complex data mining analysis, building and maintaining accurate reporting in ad-hoc and custom-built automated reporting projects
  • Expert at translating business needs/ high level product descriptions and ideations into detailed business and technical requirements
  • Experience with Data modeling concepts, database design for relational and multi-relational databases
  • Expert in business process engineering and software development and delivery methods (SDLC, Agile, Scrum, ITIL), including analysis, design, specifications, testing and implementation of software applications.
  • Developed SRS, SDD, project plans, documented process flows SDLC processes, UML modeling and developed training documentation and courses work.
  • Familiar with current industry standards, such as HIPAA, SOX
  • Experience with Web Analytics, Clickstream Data, Omniture, SiteCatalyst
  • Adept at reducing development costs and providing traceability of projects.
  • Expert working with Oracle 11g, ERP, Financials, Quantum Oracle, CRM,

·         Excellent communication, analytical, interpersonal, and presentation skills; expert at problem solving, managing multiple projects simultaneously and working independently

·         Communicated to team members by use-cases, sequence diagrams and process flows

·         Functional Business Analyst for implementation, upgrades and releases

·         Project Managed integrating real time asset management data to HRMS system for employee audit self-service capabilities

 

TECHNICAL SKILLS AND CERTIFICATIONS

 

Databases:

Oracle 11.5.6, MS Access, SQL Server, Netezza, VAIOCare

 
     

Industry Standards:

HIPAA, SOX

 
     

Platforms:

Windows NT/2000/XP, Vista, MSDOS, Mainframe

 

Defect Tracking:

Service-Now, Team Tracker

 
     

PROFESSIONAL EXPERIENCE

 Confidential

 

Business Intelligence Report Developer / Engineer

·         Requirements gathering, developed use cases, and wrote specifications

·         BIRT (Business Intelligence Reporting Technology; open-source), SpringSource

·         DTM Data Generator to script test data

·         SQL Server SQL, Oracle SQL

·         Enterprise Architect

·         Visual Studio

 Confidential

 

Data Mining Contractor

·         Requirements gathering, developed use cases, and wrote specifications

·         Use SQL database to restructure and analyze the data

·         Create tables / views, write stored procedures

·         Make insights and conclusions from the data provided

·         Make suggestions based on data analysis to improve data, business opportunities

 

 

 Confidential

 

Business Analyst Contractor, Web Analytics team of the Consumer Group

·         Requirements gathering, developed use cases, and wrote specifications

  • Responsible for understanding internal and external data sources and creating processes to easily access data
  • SQL to query click stream data warehouse to analyze online visitor behavior
  • SQL query writing for Omniture, Netezza Teradata
  • Identified tracking and reporting gaps and develop solutions that enable us to meet business goals
  • Instrumental in implementing aggregate tables for streamlined and efficient SQL queries
  • Improved number of SQL queries to run simultaneously and improved the number of tests to run simultaneously
  • Developed and provided standard and ad hoc reporting for strategic customers, using campaign, tax-year and fiscal-year-data
  • Produced multivariate or A/B tests to drive fundamental changes to the site experience.
  • Demonstrated strong analytical and quantitative skills and intellectual curiosity about data and its implications
  • Communicated to team members by use-cases, sequence diagrams and process flows
  • Proven ability to glean key insights from data
 

 Confidential

 

 

Project Manager / Sr. Business Process Analyst, for the Invoice Management team of the Information Technology department supporting development of QBID, a homegrown Oracle ERP based billing and inventory Accounts Payable database system.  Project realized annual savings over $2.9 million.

 

·         Gather project and user requirements, following SDLC processes, UML modeling, and design, develop, test and release QBID system version updates.

·         Responsible for project managing all aspects of QBID development

·         Responsible for data modeling of all new data elements and tables

·         Responsible for management and administration of QBID including access and security.

·         Worked with managers, software engineers, developers, business unit, finance, legal and senior management to capture user requirements and design, develop, test and release self service solutions, including dashboards and scheduled reports, using Cognos 8 Analysis Studio

·         Responsible for all reporting and analytics to financial community

·         Query and script writing in SQL and PL/SQL for ERP Oracle Financials, Quantum Oracle CRM

·         Developed ETL tools using Excel VBA, ActiveX, ADO, loading into Oracle ERP Payables

·         Responsible for Dimensional Data Modeling

·         Project Managed Annual Corp IT audit, inventorying all Telecom Devices, Hardware and Software assets including Cognos reporting to CFO.

·         subject matter expert and data software engineer to capture user requirements and transform these into appropriate solutions for QBID

·         Communicated to team members by use-cases, sequence diagrams and process flows

 

 Confidential   

 

 

Sr. Business Systems Analyst, for the Information Services Department, Practice Management Unit

 

·         Responsible for supporting GE (FORMERLY) IDX  BAR, BAR Admin / AR Reports, PCS, Statements, PCX, DBMS.

·         Responsible for developing A/R catalogue of Financial, Analytic and Statistical reports using SQL, Excel VBA, ActiveX, ADO

·         Developed a proprietary registration utility

·         Requirements gathering, developed use cases, wrote specifications, developed user acceptance testing, training materials and conducting training sessions, following SDLC processes and UML modeling, developing ERDs, BRD, FSD, SRS, SDD and Data Dictionary modeling documents, use case, sequence diagramming, traceability testing and class diagrams. 

·         Provided weekly project status reports, budget analysis and statistics on all projects

 

 Confidential

 

 

Project Manager / Business Data Analyst, for the Managed Care, Utilization Management department of a regional health and benefits provider.

 

·         Reporting to the Director of Operations my responsibilities included supporting the GE (FORMERLY) IDX BAR, SCHED, MCA, DBMS, PCS and PCX applications and Decision Support activities.

·         Responsible for Dimensional Data Modeling

·         Requirements gathering, developed use cases, and wrote specifications

·         Project managed the GE (FORMERLY) IDX 9.0 HIPAA compliant upgrade. 

·         Project Manager who wrote specs, project plan, test scenarios and implemented Medicare HIPAA compliant 835 remittance advice program utilizing MS-Excel, VBA, ActiveX, ADO and MS-Access.

·         Developed user acceptance testing, training materials and conducting training sessions, following SDLC processes and UML modeling, use case, sequence diagramming, traceability testing and class diagrams. 

·         Project Managed who wrote specs, project plan, and implemented NSF 3.0 program to submit encounter data utilizing SQL with strict adherence to SDLC process and UML and Predictive modeling.

 

 Confidential

 

 

Sr. Consultant for a major Southern California multi-specialty health care system and Health Plan benefits provider

 

·     Reporting to the Provider Professional Services Director my responsibilities have                       included Project Managing a team who completed an e-claims feasibility study for a large Northern California PSO

·         Requirements gathering, developed use cases, and wrote specifications

·     Completed an “As Is” analysis prior to implementation of a Siemens’ Novius SQL Server Data Warehouse Solution and participated in the design team’s recommendations.

 

 Confidential

 

 

Sr. Consultant for major Northern California multi-specialty health care system and Health Plan benefits provider

 

·     Global Works Systems is a consulting group that specializes in GE (FORMERLY) IDX applications and their own products enhancing the GE (FORMERLY) IDX applications.

·      Reporting to the Managing Director as project manager my responsibilities included the merging of archive data of a recently acquired medical group into the parent PSO’s organization’s SQL Server data warehouse.

·     I was also the project manager for integrating pharmacy, laboratory and benchmark data into an Oracle data warehouse systems and created reports utilizing Cognos.

·         Developed provider profile models.

·         Requirements gathering, developed use cases, and wrote specifications for MIDAS+ case management software, Payer Contracts

 

 

 

         

 

Search Resumes

Looking for I.T Professionals on a Contract basis?