Seasoned Business Intelligence Analyst / Consultant

LISA MARIE CRYER

Phone: 443-***-****

Email: *********@***.**********.***

Professional Summary

I am a Senior Analyst with 13+ years of technical and analytical experience. I have strong leadership and organizational skills, and proven problem-solving and analytical abilities. I am SDLC oriented and adept at translating business needs into technical requirements and documentation. My technical strength lies in my ability to use diverse technologies on multiple platforms to perform complex analysis, data mining, query optimization, and full lifecycle development.

• Ability to multi-task in a fast paced environment with proven record of consistent results.

• Proven record of strategic planning to achieve desired outcomes.

• Agility – strong grasp on importance of requirement evolution independent of technology

• Excellent negotiation skills, effective communication with varied audiences

• Extensive experience within structured SDLC / process-oriented environment.

• Experience with diverse technologies & platforms.

• Personality – inquisitive, persistent, strong passion for what I do!

TECHNICAL SKILL: YEARS OF EXPERIENCE:

*Proven ability to write complex reports using sub-reports, graphs, drilldown objects, & dashboards.

*Proven ability to setup & maintain Crystal Enterprise / Business Objects environment.

Report Development, Distribution, Maintenance:

o Crystal Reports – versions 6, 7, 8, 8.5, 9, 10, 11, 2008 11 years

o Other reporting tools: MS Access / Excel, COGNOS, SQL 2005, SSIS 9 years

o Crystal Enterprise - versions 8 – 9. Business Objects 11, r2 7 years

o Hyperion / BRIO 3 years

*Proven ability to write complex queries, views, triggers, & procedures in SQL & Oracle.

Databases Development / Administration:

o SQL: MS SQL Server 7, MS SQL Server 2000 , MS SQL 2005, 9 years

SQL Enterprise Manager, RedGate SQL ToolKit, Insightful Miner

o ORACLE: Oracle 8 & 9, PL/SQL, TOAD, Oracle DB Diff 5 years

o ETL: Business Objects, Pentaho, Red Gate 4 years

o Miscellaneous: Oracle Reports, Oracle Forms 2 years

EDUCATION: BS, Economics & Finance, Business Administration

Gallaudet University, Washington DC 1996

Crystal Reports Developer (Contract) 01/2009 – Current TEKSYSTEMS Wilmington, DE

• Work with business analysts to understand changes to schema and structure resulting from data integration effort.

• Assist with identification of issues; provide recommendations related to impact on current business practices / KPIs resulting from integration effort.

• Design, development, and modification of reports using Crystal XI and ‘true’ SQL programming.

Senior Business Intelligence Consultant 01/2008 – 12/2008 PHH Arval, Sparks MD

• Senior consultant responsible for the design of the BI repository & development of system processes to populate, maintain & archive inputs from data warehouse environment.

• Performed detailed data analysis, system & process assessments to gauge robustness of technical architecture (AS IS and TO BE), reported findings / recommendations to senior leadership.

• Primary technical resource for design of logical models & standards for maintenance.

• Responsible for gap assessment, business (functional) & technical requirements for BI platform & Enterprise Content & Collaboration Management system.

• Conducted brainstorming sessions with functional user base to understand & prioritize business needs.

• Served as primary POC for vendor interaction with focus on evaluation of technologies for fit with business needs.

• Co-lead effort to establish new business intelligence dashboards (for targeted audiences with multiple layers of drilldown / ad-hoc functionality). Direct responsibility for crafting solid foundation (guidelines, process definition, source & risk control measures). Joint responsibility for design and development of pilot and proofs.

• Functioned as in-house expert on data mining, report development, dashboard design & deployment tasks.

• Lead dashboard development effort focused on definition and channel of KPI metrics for senior leadership.

• Served as team lead for junior analysts, responsible for guidance & technical training / support.

• Crafted extensive ETL processes (along with documented procedures) to perform data loads between systems.

Manager of Applications / BI Solutions 07/2002 - 08/2007 ATK, Elkton MD

• Serve as manager over database, application development, and business intelligence teams.

• Responsible for performance evaluations, development initiatives and growth opportunities for staff.

• Key player in development of IT strategic vision, charged with capitalization of opportunities to increase client satisfaction and business benefit (internal and external).

• Managed strong portfolio of projects, both continuous & discontinuous in business nature.

• Identified methods to measure intangible customer value & developed balance scored card methods to track productivity, quality, profitability, & value effectiveness.

• Responsible for Business Objects environment in its entirety – implementation, administration, security, design & development of universes, data objects, reports, & dashboards.

• Lead development effort for Sharepoint web pages (heavy focus on data / graphical integration).

• Facilitate the elicitation of business & systems requirements through workshops, use case workshops, JAD sessions, & research & analysis. Facilitated translation of functional requirements into technical tangibles.

• Following formal SDLC methodology – documented work flows, system architecture diagrams, user test plans. .

• Team lead responsible for planning stage of next major ERP release. Assessed current product / processes, performed gap analysis & provided technical impact of suggested solutions.

• Coordinated & lead database crosswalk effort for migration of data into new ERP system. Designed & performed unit & integration testing for multi-step data migration effort.

• Created database mapping documentation (Oracle to Oracle to SQL for integrity / recovery purposes).

• Design and modification of data objects using PL/SQL.

• Responsible for management of complex database system comprised of 2 Oracle environments feeding into one local SQL system – required creation of complex procedures to transfer data and error handling to address issues.

• Championed the re-design of development processes / methodology to maximize lean development efforts. Resulted in total overhead reduction of 35%.Developed mechanisms to reduce manual maintenance / system checks of systems that resulted in 45% time savings for database administrators.

• Created & maintained procedures & documentation for 3-tier database architecture.

• Performed duties as SOX Compliance officer, developed & implemented appropriate controls to enforce adherence to policies & procedures to support industry best practices & SOX compliance.

• Revamped antiquated MS Access system into SQL / .NET application.

Business Intelligence Consultant 02/2000 – Ongoing LMC Technology Solutions, Inc.

FOCUS: Consultant –database & report development for clients in the healthcare industry:

• Clinical Data Management Consultation:

• Design databases, systems, data collection methods and measurements (definition, design, workflow).

• Define, design, and coordinate approval of validation testing controls, processes, and study documentation.

• Function as liaison with Clinical Team to coordinate appropriate application of regulations, policies & procedures to data control and analytic activity.

• Responsible for fielding data process and quality challenges in consultation with diverse clinical personnel.

• Provide strategic guidance and data analysis within a managed care organization, including health care costs, provider contracts, revenue & profitability, provider incentives & utilization.

• Oversight of data management trial startups (conduct, planning activities).

• Prepare clear and well-organized project-specific documentation to reflect analytic methods used, key decision points, anomalies identified, etc with supporting documentation.

• Technical Consultation:

• Report development / deployment mechanisms

 Analysis of current reporting processes, recommendations for future state

 Requirement gathering & development of functional specifications

 Design / development of complex reports using multiple tools, mining from multiple sources

• Heavy involvement with loading, exporting, & manipulating data environment.

• Senior consultant responsible for the design of the expansion to the data warehouse (BI repository) & development of system processes to populate, maintain & archive inputs from data warehouse environment

• Use of SQL and PL/SQL for development of required data artifacts.

• Performed detailed data analysis, system & process assessments to gauge robustness of technical architecture & make recommendations to senior leadership.

• Primary technical resource for design of logical models & standards for maintenance.

• Responsible for gap assessment, business (functional) & technical requirements for BI platform & Enterprise Content & Collaboration Management system.

• Conducted brainstorming sessions with functional user base to understand & prioritize business needs.

• Served as primary POC for vendor interaction focusing on technology fit with business needs.

• Co-lead effort to establish new report / dashboard mechanism with direct responsibility for crafting solid foundation (guidelines, process definition, source & risk control measures). Sole responsibility for design and development of pilot dashboards.

• Functioned as in-house expert on data mining, report development, dashboard design & deployment tasks.

• Served as team lead for junior analysts, responsible for guidance & technical training / support.

Healthcare Data Analyst 10/2000 – 06/2002 ElderHealth, Baltimore MD

FOCUS: Consultant –database & report development:

• Function as liaison with Clinical Team to coordinate appropriate application of regulations, policies & procedures to data control and analytic activity.

• Responsible for fielding data process and quality challenges in consultation with diverse clinical personnel.

• Provide strategic guidance and data analysis within a managed care organization, including health care costs, provider contracts, revenue & profitability, provider incentives & utilization.

• Design databases, systems, data collection methods and measurements (definition, design, workflow).

• Responsible for database design, development and maintenance

 Design of physical database (objects, primary and foreign keys, constraints, triggers)

 Creation of database objects in SQL and Oracle (tables, views, stored procedures)

 Creation of complex stored procedures to perform load transfers between SQL and Oracle

 Creation of multiple reports to identify any service interruptions or transfer failures between multi-layered systems

 Maintenance of Oracle environment (TOAD) – responsible for management of 3-tiered architecture, integrity between production, staging and development arenas.

• Creation of process and database for capture and analysis of service requests.

 Designed process, presented using Visio / Powerpoint

 Presented and obtained buy-in on streamlined process, negotiated deliverables

 Crafted system using MS SQL backend, Access frontend and Crystal reports

• Define, design, and coordinate approval of validation testing controls, processes, and study documentation.

• Function as liaison with Clinical Team to coordinate appropriate application of regulations, policies & procedures to data control and analytic activity.

• Responsible for fielding data process and quality challenges in consultation with diverse clinical personnel.

• Provide strategic guidance and data analysis within a managed care organization, including health care costs, provider contracts, revenue & profitability, provider incentives & utilization.

• Oversight of data management trial startups (conduct, planning activities).

• Prepare clear and well-organized project-specific documentation to reflect analytic methods used, key decision points, anomalies identified, etc with supporting documentation.

Clinical Data Analyst / Report Developer 10/1999 – 09/2000 HealthCare Strategies, Inc. Columbia, MD

• Technical activity:

o Conversion of all Procomm RS6000® databases to new Seagate Wisdom system

• Development of data legends, mapping, development and execution of test plans

• Create, publish, and maintain Crystal reports

• Management reports – performance analysis, budget variances, management dashboards

• Creation of check and invoice generation system

• System administration of several software tools (client setup security, troubleshooting)

• Database maintenance / data tuning within SQL & Oracle environments – responsible for change management mechanisms and database maintenance of views and procedures in both environments.

• Lead data team in developing protocol quality control measures for quality analysis of data collection and dissemination activities.

• Perform setup of databases – tables, views, procedures, relationships, keys, functions

• Liaised with group of CRAs – actively contributed to CRF design and correlating database to capture inputs.

• Using SQL and Crystal reports, designed scripts and reports to automatically identify data issues

Clinical Data Analyst 05/1997 – 09/1999 Bio-Reg Associates, Laurel MD

• Data entry & coordination of administrative tasks.

• Promotion to supervisor: Function as liaison with Clinical Research Team, Medical Affairs, Biometrics and Data Analytics on resolution of data specific challenges.

• Serve on team geared towards SOP of clinical data input, capture, management and analysis functions.

• Train multi-shift staff on job duties, adherence to SOPs

• Responsible for development & implementation of qc procedures using comparative analysis & monitoring tools

• Report development – create, publish, & maintain Crystal reports

Contact this candidate