We provide IT Staff Augmentation Services!

Business Analyst/crystal Report Developer Resume

SUMMARY:

  • I am an analyst, and reporting professional with extensive experience in business intelligence, database marketing, custom report development, geographic analysis and Interactive Visualization development utilizing such tools as Crystal Reports, Crystal Xcelsius, Business Objects Web Intelligence, Crystal Clear, SSRS, Cognos, Adobe Flex, Information Builders Focus, Visual Fox Pro, Access, SQL Server, Oracle, SPSS, MapInfo, Personify, Postgre SQL, and ArcGIS.
  • I have also used these tools to perform market research, market and sales analysis and segmentation, resource balance and deployment.
  • Not only do I have extensive knowledge of these tools, I also possess the experience of utilizing them to identify serious decision making issues and to help managers understand their significance and to quantify the potential outcomes of various action alternatives.
  • I look forward to the opportunity to discuss the position and to use my skills to fulfill the mission as a Business / Data Analyst and Custom Report designer / Interactive Visualization developer.
  • I believe that I possess all of the skills and requirements to successfully assume this position utilizing my skills and experience.
  • Years of marketing management experience.
  • 25 years of experience with Crystal Reports and Crystal Enterprise as a user and an administrator.
  • Experience creating Stored Procedures and Views in SQL Server required for custom reports in CampusVue the academic institution management software.
  • Experience creating custom reports in Crystal Reports for use in CampusVue the academic institution management software.
  • Years of experience designing interactive visualizations utilizing Crystal Xcelsius and Adobe Flex.
  • Experience creating reports in SSRS
  • Experience creating Stored Procedures, Views and Queries in SQL Server to use as data sources for reports.
  • Years of corporate strategic planning experience.
  • Years of experience in market research and analysis.
  • Experience with companies that sell through distribution and direct sales forces.
  • Experience working for government agencies.
  • Managed national trade shows and have been involved in packaging and POP design.
  • Conducted training programs and made presentations to various national associations.
  • Communications background with experience as a Commercial Photographic Illustrator, Industrial Filmmaker, Slide - Show Producer, I have created countless presentations using PowerPoint and as a Designer and Developer of Interactive Visualizations using Crystal Xcelsius and Adobe Flex.
  • I am a business/market intelligence professional, strategic planner, marketing analyst and manager, with extensive experience.
  • I possess expert computer and database marketing skills. I have an extensive skill set which includes the creation of visualizations and Reports using such tools as, Crystal Reports, Crystal Xcelsius, Business Objects Web Intelligence, Crystal Clear, Adobe Flex, SPSS, Information Builders Focus, MapInfo and ArcGIS.
  • Experienced in market research, analysis and segmentation, sales force balance and deployment, desktop mapping and geographic data visualization.
  • I have extensive experience in primary and secondary research.
  • I am skilled in data extraction and analysis from mainframe; client server and PC based data.
  • I have extensive experience with MS SQL Server, Postgre SQL, Oracle, Information Builders Focus, Fox Pro and Access.
  • I possess professional skills in photography, cinematography and slide show production.
  • I am a strong communicator with excellent team building skills.

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst/Crystal Report Developer

Responsibilities:

  • Modified existing Crystal Reports to address changes in business requirements
  • Modified existing Crystal Reports to address the updating of reporting software
  • Took specifications for new reports and delivered Crystal Reports that satisfied business requirements
  • Developed Reports against SQL Server data sources
  • Published reports to a new instance of Crystal Report Server
  • Insured that reports would function correctly in new software version
  • Maintained a library of Crystal Reports and created a library of report documentation

Confidential

Business Analyst/Crystal Report Developer

Responsibilities:

  • Modified existing Crystal Reports to address changes in business requirements
  • Took specifications for new reports and delivered Crystal Reports that satisfied business requirements
  • Developed Reports against SQL Server data sources
  • Developed new Reports that would be published in a manufacturing ERP system
  • Maintained a library of SQL Server and created a library of report documentation

Confidential

Business Analyst/Crystal Report Developer

Responsibilities:

  • Performed analysis of existing Crystal Reports
  • Explored ways to modify existing Crystal Reports to address changes in business requirements
  • Analyzed complex “SQL Commands” to be used as data sources for Crystal Reports

Confidential

Business Analyst/ Business Objects Web Intelligence Report Developer /Crystal Report Developer

Responsibilities:

  • Performed analysis of existing Crystal Reports and Web Intelligence Reports
  • Created new reports - Web Intelligence and Crystal Reports
  • Developed Reports against both Oracle and SQL Server data sources
  • Modified existing reports - Web Intelligence and Crystal Reports to address changes in business requirements
  • Created complex “SQL Commands” to be used as data sources for Crystal Reports
  • Maintained a library of Crystal Reports and created a library of report documentation

Confidential

Business Analyst/ SSRS/Crystal Report Developer

Responsibilities:

  • Performed analysis of existing Crystal Reports in order to convert them to SSRS reports.
  • Created and modified SQL Queries for new reports and to address changing business rules.
  • Modified existing SSRS Reports to accommodate changing business requirements.

Confidential

Business Analyst/ Crystal Report Developer

Responsibilities:

  • Performed analysis of existing SQL Server databases and reports in order to modify existing and create new Crystal Reports.
  • Created Stored Procedures and Views required for new reports.
  • Modified existing Stored Procedures and Views to accommodate changing business rules.
  • Modified existing Crystal Report Reports to accommodate changing business rules.

Confidential, Oakbrook, IL

Business Analyst/ Crystal Report Developer

Responsibilities:

  • Performed analysis of existing SQL Server databases and reports in order to develop new reports in Crystal Reports.
  • Created new custom reports as they migrated to a new academic institution management software system, CampusVue. Both the old and the new systems utilized SQL Server as the database, however the old system utilized SSRS for reporting
  • Analyzed Stored Procedures and Views to identify tables and fields in both old and new systems.
  • Mapped database, table and field conversions from old reports (SSRS) to new databases, tables and fields to be utilized in the to be created custom reports in Crystal Reports
  • Created Stored Procedures and Views required for reports in CampusVue
  • Created custom reports in Crystal Reports for use in CampusVue the academic institution management software

Confidential, Carol Stream, IL

Crystal Report Developer

Responsibilities:

  • Created custom reports from new ERP Systems, one utilizing SQL Server on its back end and Crystal Reports for its reporting tool and the other ERP system utilizes Postgre SQL on its back end and requires the use of Crystal Clear a Java based Crystal Report like tool
  • Reports From both systems required extensive use of complex formulas, Graphic data representations and a lot of conditional formatting. Both sets of reports also required the extensive use of parameters for customizing the end user experience.

Confidential, Hanover Park, IL

Crystal Report Developer

Responsibilities:

  • Created custom reports from its new ERP System which utilizes SQL Server on its back end and Crystal Reports for its reporting tool
  • Developed a series of reports that had been produced in their old system that utilized a variety of tools including Cognos and Toad
  • Reports were extremely complex requiring hundreds of complex formula fields and extensive use of parameters.

Confidential, Glenview, IL

Crystal Report Developer

Responsibilities:

  • Created custom reports (Business Objects (2008), Personify and SQL Server)
  • Developed reporting standards
  • Responsible for documentation and Quality Control

Confidential, Chicago, IL

Regional Indicators Analyst

Responsibilities:

  • Created and developed Web Based Interactive Visualizations
  • Generated XML output for Interactive Visualizations by creating IBI Focus procedures
  • Created custom visualizations utilizing Crystal Xcelsius and Adobe Flex
  • Generated ETL scripts utilizing FoxPro, SQL Server
  • Generated various unique Data Sources for Visualizations

Confidential, Overland Park, KS

Business Objects and Crystal Reports Development and Administration

Responsibilities:

  • Managed a team of developers responsible for installing and implementing a new instance of Business Objects
  • Created custom visualizations utilizing Crystal Reports, and Crystal Xcelsius
  • Created Crystal Reports in an Oracle environment
  • Created custom reports and reporting standards
  • Responsible for the administration of Business Objects

Confidential, Memphis, TN

Technology Consultant-Crystal Report Development

Responsibilities:

  • Created new Crystal Reports for various clients.
  • Revised and up-dated existing Customer Reports
  • Worked in whatever database environment the client utilized (SQL Server, Oracle, Fox Pro, d-Base and Excel.

Confidential, Memphis, TN

Marketing Manager

Responsibilities:

  • Created and administered a computerized project-tracking program for the sales force.
  • Created software to manipulate data (Access & FoxPro)
  • Created reports to help sales force and top management utilize and manage the data (Crystal Reports)
  • Created electronic forms to permit data collection and a two way communication process (Omniform)
  • Converted paper forms to electronic forms to expedite daily tasks.
  • Extracted data from corporate data source (Cognos PowerPlay) to perform various ad-hock analyses of opportunities within existing and potential customer and market bases (Excel, FoxPro, Quattro Pro, Crystal Reports and MapInfo)

Confidential, Memphis, TN

Manager, Strategic Marketing

Responsibilities:

  • Responsible for creation and development of T&B Customer Consultancy Program designed to help a select group of customers utilize modern marketing and computer techniques, understand their own marketplaces, identify potential opportunities and sell more effectively.
  • Increased customers’ businesses by 20-35% in following year with incremental sales totaling $35 million.
  • Developed a division marketing information base utilizing PC, Client Server based and mainframe databases (FoxPro, Oracle, Crystal Reports, Crystal Report Server (also administrator) and MapInfo)
  • Created Crystal Reports and queries to extract for Marketing analysis in an Oracle environment
  • Developed predictive models and other analytical tools, as well as created targeted marketing lists and developed competitive intelligence (D&B Market Outlook, SPSS, Excel, FoxPro, Crystal Reports and Quattro Pro)
  • Developed tracking programs to increase sales to target markets. (FoxPro, Quattro Pro, MapInfo and Crystal Reports)
  • Identified highest potential accounts for the sales force. (FoxPro, SPSS, MapInfo and Crystal Reports)
  • Defined market potential and calculated market share and sales performance measures for all regions and product lines. (SPSS, FoxPro, Crystal Reports, MapInfo and Quattro Pro)
  • Automated annual budgeting process. (FoxPro and Crystal Reports)

Confidential, Tinley Park, IL

Manager, Market Research and Development

Responsibilities:

  • Directed the corporate strategic planning process.
  • Established marketing plans and programs designed to maximize effectiveness of corporate sales effort in key markets.
  • Designed and executed both original and secondary research, direct mail marketing and sales incentive programs, as well as the development of sales forecasts and other predictive and planning models (D&B Market Outlook, SPSS, Excel, FoxPro, Crystal Reports, Quattro Pro, Lexis and Nexis)
  • Directed market intelligence efforts and created applications and systems using microcomputers and mainframe information retrieval systems ( FoxPro, Dbase, SPSS, MapInfo and Crystal Reports, SPSS, Excel, FoxPro, Quattro Pro, Lexis and Nexis)
  • Programmed a Competitive Cross Reference System
  • Wrote and managed sales training programs.
  • Supervised staff of five.
  • Developed reports utilizing Crystal Reports

Confidential, Chicago

Assistant Advertising Manager / Marketing Manager

Responsibilities:

  • Coordinated $400 Million inventory reduction program through 37 branch locations.
  • Developed forecasts and sales goals.
  • Organized and managed corporate participation in national trade shows.
  • Developed sales aids for all product lines.
  • Managed an office staff of 30.
  • Created sales brochures, catalogs and annual report, as well as managed photographic services department.
  • Wrote, directed, photographed and edited films, videos and slide presentations.
  • Supervised creative staff.
  • Created photographic illustrations, doing large format advertising and catalog photography.

Hire Now