Report Analyst Resume
Dorchester, MA
SUMMARY:
Experienced business systems analyst solid technical skills excellent communication skills enthusiastic customer service attitude IT experience supporting enterprise initiatives (data management, information access, report generation, project management and system analysis) demonstrated ability to adapt to new tools and environments adding value quickly to new assignments
TECHNICAL SKILLS:
Languages: Program, compile, link expertise (COBOL, C), Scripting (UNIX, VMS, MVS), SQL), ASP,VB
Operating Systems: UNIX (AIX, HP - UX, CompaqT64), VMS, IBM MVS, AS400, Unisys, Windows
Business Intelligence: Cognos Powerplay, Impromptu, Platinum Forest &Trees, Crystal Reports, ThinkTank, SSRS, MS Visual Studio
Databases: Relational (DB2, Oracle, SQL Server, MS Access), RMS, VSAM, dbase, Lotus Notes/Domino
Project Management: MS Project 2000, Rational Tools
Enterprise systems: MS Sharepoint 2010 site definition and implementation, Numerous ETL projects
PROFESSIONAL EXPERIENCE:
Report Analyst
Confidential, Dorchester, MA
Responsibilities:
- Develop and maintain daily and monthly reports (in Excel) based on production data for systems availability and incident management.
- Work with the team to develop and execute a plan to build a data warehouse (SQL Server) and reporting platform (SSIS,SSRS) that will support federal regulatory requirements as well as meet the customer requirements for contract defined service levels.
Report Developer
Confidential, North Andover, MA
Responsibilities:
- Design and develop interactive reporting solutions using SQL Server Reporting Services (SSRS) to support payroll and management of a varied labor force.
- Develop new and utilize existing stored procedures using MS Visual Studio 2012 to retrieve data for reports including handling single and multiple valued parameters, case and dynamic sql statements.
Business Development Analyst
Confidential, Andover, MA
Responsibilities:
- Developed and distributed sophisticated reporting solutions using Crystal Reports to improved decision making/approval process.
- Working with different levels of users, defined metrics, data requirements and report scheduling.
- Developed Excel based reports including pivot tables and charting features for quarterly, annual and trend reporting by senior management.
- Participated in JAD sessions with IT, business groups and support groups to develop the in house opportunity tracking system to include new functionality as well as more seamless integration with other dependent applications. Promoted and educated users of the system to improve data quality and increase self reliance.
- Worked with HR, Contracts and Proposal Development teams to improve quality and reduced RFP response and proposal development turnaround times by designing an integrated knowledge repository and a sustainable process for reusable and dynamic content on MS Sharepoint 2010 contributing to winning new business. Using what was learned during these sessions, provided similar sessions for additional projects.
- During acquisitions and when Confidential was acquired I applied my knowledge of SQL with MS Access, advanced formulas and macros in Excel and other tools to extract, transform and load (ETL) data speeding integration for accurate reporting of sales activity.
- Provided consulting services for data access, data warehousing, report generation, project management and system analysis as an independent consultant.
Director of Product Delivery
Confidential, Cambridge, MA
Responsibilities:
- Managed software engineering, hotline support, documentation and quality assurance teams.
- Co - ordinated cross-functional teams performing programming and systems analysis activities related to the development, modification, and enhancement of multiple medical billing and healthcare-related auditing software products.
- Negotiated service level agreements internally as well as with vendors and contractors to provide top quality services and products to our customers.
- Facilitated and participated in JAD sessions to defined scope, project plans and milestones for releases with product management and clinical teams. Developed requirements analysis and functional specifications for product maintenance and new features.
- Worked with remote management and development teams to merge products and resources to meet business unit goals.
Manager of Release Engineering
Confidential, Cambridge, MA
Responsibilities:
- Increased efficiency, quality and reduced costs by standardizing product development across 12 platforms
- Achieved on-time delivery of three application and database releases per year to 200+ customers with $15M contract value.
- Improved support satisfaction by developing direct contact with customers and assuring responsiveness to their needs.
- Negotiated software and hardware licensing and vendor relationships across 12 platforms.
- Supervised 6 full-time and various contract employees; Improved product development and delivery process through marketing, sales and clinical personnel support
Systems Engineer
Confidential, Cambridge, MA
Responsibilities:
- Supported product sales through the production and demonstration of customized business intelligence and analytics.
- Products included web-based solutions and add-on custom reporting features.
- Used SQL and MS Access extensively in pre- and post-sales support for the OLAP server technology application and for report development.
Senior Consultant
Confidential, Wilmington, MA
Responsibilities:
- Developed Cognos data dictionary and custom reports for the Confidential application. Provided training and consulting to customers to enhance and utilize the dictionary.
- Implemented production reporting systems utilizing enterprise data from multiple sources (Excel, Oracle, Access) using Impromptu and PowerPlay tools to provide reports and dashboards for management decision making.
Senior Technical Consultant
Confidential, Waltham, MA
Responsibilities:
- Provided solutions to customers working with multi-platform application development and data access tools.
- Assisted end user developers with the coding of executive information and expert systems based on relational data. Provided customized training for specific client requirements.
- Educated and consulted on data warehousing, data access, GUI design, and EIS development.
- Increased the value of customer data by combining diverse sets of information via intuitive front-end applications.
Pre/Post Sales Technical Consultant
Confidential, Dedham, MA
Responsibilities:
- Introduced and supported the IDMS/SQL relational database and related tools in the VAX marketplace.
- Delivered SQL developer and end-user education.
- Delivered customized courses and on site expertise to national diverse customer base.
Programmer Analyst
Confidential, Lexington, MA
Responsibilities:
- Provided system programming, operating system support and production release management
- Maintained in house CASE tools used to develop FieldWatch, a successful commercial field service application.
