Project Manager Resume

SUMMARY

Technical Professional with over 15 years’ experience working in all phases of the software development lifecycle with specific expertise as a Reporting Analyst, Data Analyst and Business Intelligence Specialist within the Financial, Manufacturing and Healthcare industries.
Specializing in collecting and analyzing data for driving business solutions ; proficient in database design and development.
Proven ability developing complex decision making reports and performance metrics that support strategic organizational goals.

TECHNICAL SKILLS

Applications: Allscripts, Framework, MS Office, Fogbugz, SageCRM.

Languages: Transact SQL, VBA, ASP, Object Pal

Reporting Tools: Crystal Reports, SSRS, Power Pivot, MS Access

Methodologies: Agile, SSM, SSADM, IE, JSD, OO, Normalization.

ETL Tools: SSIS, SQL, Excel.

Databases: SQL Server, MS Access, Q&A, and Paradox, Cloudera

CASE Tools: Ascent, Erwin and Visio

PROFESSIONAL EXPERIENCE

Confidential

Project Manager

Responsibilities:

Responsible for preparing the deck of monthly financial reports.
Clone, modify or develop new Tableau dashboards as required.
Represent PPO data interests in all decisions regarding data sources and data governance.
Become familiar and conversant with Cloudera/Impala as main Datasource.
Manage Sharepoint site and modify as required.
Troubleshoot all dashboard or data related issues as they arise.

Confidential

Snr Data Analyst

Responsibilities:

Developed and distribute monthly financial reports, with a focus on KPI targeting and forecast analysis, to the Board of Directors and Executives
Prepare strategic trend reports for sales and retention to measure KPI, Increased leadership focus on key Performance Indicators
Consistently self - managed and independently motivated ahead of expectations in providing new data solutions to company
Daily tasks involved extensive use of reporting and data visualization tools.
Authored complex stored procedures, views, functions and scripts to support data analytics needs.

Confidential

Programmer/Analyst

Responsibilities:

Allocate request to appropriate team by determining the best system to provide data. This requires extensive and continuous knowledge of several systems, data warehouses as well as the information held in each.
Determine appropriate form for output based on users’ current and future needs. This requires a deep understanding of Analytics and reporting and excellent communication skills.
Manage request from requirements gathering to delivery using project management software Fogbugz.
Create SQL stored procedures, Tableau dashboards and/or Crystal Reports as required.
Technically manage team of developers by helping them through challenging requests, mentoring and training.
Advise management as needed re infrastructure constraints and stay abreast of new data feeds for our internal BIS system.

Confidential

Business Objects Crystal Reports Developer

Responsibilities:

Provide technical review of design specifications coming from internal and external product development teams.
Develop, modify and maintain reports, stored procedures and report installations based on specifications from design teams.
Support lead developer for standard report development during full and maintenance releases of the Confidential system.
Provide code review for report development, both standard and custom.
Design and present informational classes for internal staff regarding report development.
Support other core development as necessary.

Confidential

Snr Business Intelligence Analyst

Responsibilities:

Designed and developed over 20 KPI reports to aid business decisions.
Lead, trained and mentored a group of 3 in converting over 100 reports.
Developed all stored procedures to enhance existing reports performance and allow for re-usability.
Wrote ad-hoc queries to support decision making.
Implemented new scheduling system for the automatic deployment of reports to users.
Make reporting and business intelligence decisions as required.

Confidential

Lead Crystal Reports Developer

Responsibilities:

Designed, developed, maintained and enhanced over 400 Convergex bulge bracket investment bank Crystal reports valued at over $500,000
Designed Dashboards and Analysis and trained clients to use Targit (BI Tool).
Redesigned over 100 existing reports with new ‘look and feel’. Improved readability using alternating colored lines; reorganized and improved the appearance of reports by using drill downs to present information in a hierarchical format; and highlighted critical facts using various visualization techniques.
Documented user requirements and technical specifications which ensured seamless implementations.
Managed software implementations for HedgeTrak and ResearchTrak360 totaling $300,000.