Business Intelligence Developer Resume
St Louis, MissourI
SUMMARY:
Leverage my business intelligence & project management skills to lead a company/organizational unit in their efforts.
TECHNICAL SKILLS:
Skills: Microsoft Business Intelligence Stack (SQL Server 2005/2008/2008 R2, SSIS, SSAS, SSRS, ASP.NET/C#/VB.net development, Sharepoint 2007 Designer. Various other business intelligence platforms Reporting tools (Cognos Impromptu - Powerplay/Crystal Reports/Business Objects), ETL tools (Cognos Decision Stream & Business Objects Data Integrator). SQL DBA experience, SQL Querying & project management skills.
Tools: Delivery Tools, such as Clear Case, Requisite Pro and Clear Quest.
CAREER HISTORY:
Confidential, St. Louis, Missouri
Business Intelligence Developer
Responsibilities:
- Lead business intelligence developer for Trailer Leasing Company.
- Responsible for all report creation, using SSRS 2008 R2 and Report Builder Ad-Hoc reports.
- Creation of 4 Customer and Branch centric dashboards using Performance Point Server and SharePoint 2007.
- Responsible for report and cube related SSIS packages and SSAS cube development.
- Implemented Power Pivot and led development of SharePoint 2010.
Project Manager
Confidential, St. Louis, Missouri
Responsibilities:
- Project manager for Client Service Reporting, Master Contract Repository and Performance Management tools.
- Led projects for initial deployments and change requests.
- Created client estimates for AMT tools, in conjunction with build resources.
- Managed workplans in service system to deliver on time, within budget projects.
- Managed requirement gathering processes with client contacts and subject management experts.
- Led project to deliver standard estimators for all non-customer AMT tool deployments.
- Participate in Microsoft SQL Server User community group in St. Louis.
- Maintain high level knowledge of SQL Server 2008, including SQL Server R2.
Business Intelligence Development
Confidential, St. Louis, Missouri
Responsibilities:
- Build resource for all business intelligence duties for project team. Coordinate efforts of a global team which report key performance indicators and metrics for all Confidential Outsourcing Contracts.
- Create and maintain several ODA BI Assets including reporting, cube structure/changes, report builder models/view and changes to SharePoint design for performance management and business scorecards. Subject matter expert for Performance Point, Share Point, SSRS, SSAS, SSIS and Report Model Design for onshore team.
- SQL DBA for development, staging and production databases (SQL 2005). Create and maintain logical and physical data models, using ERWin and Microsoft Visio.
- ETL development within Microsoft SQL Server Integration Services. Architected and created packages within numerous solutions. Led process improvement project for Business Objects Data Integrator ETL Jobs in 2007; this led to a 85% gain in job batch efficiency.
- Requirement gathering for build projects with business and technical architects for business intelligence related tasks. Use these requirements to create functional/technical design documents to satisfy business problems and issues.
- Tasked with project management duties (project initiation, resource estimate/requirements, time tracking vs. budget constraints) for build tasks.
- Creation of build documents to satisfy and exceed Confidential Business Intelligence Delivery Excellence standards (requirements gathering/completion, functional design, technical design, case diagrams, migration documents, lessons learned).
- Responsible for unit & assembly testing for all build projects. Create test plans, execute team testing execution and delivery. Work through debug fixes and resolution to delivery projects on time.
Confidential, St. Louis, Missouri
Business Intelligence Analyst
Responsibilities:
- Sole Business Intelligence analyst for 150 Person Company.
- Responsible for all report, cube and ETL creation/maintenance for company (using Cognos Impromptu/PowerPlay/DecisionStream & Microsoft BI Stack - SSRS,SSAS, SSIS).
- Transitioned all Cognos Impromptu Reports and Cognos Decision Stream ETL code to Microsoft SQL Server Reporting Services and Microsoft SQL Server Integration Services.
- Implementation of Analysis Services cubes for use by sales staff to measure key sales indicators.
- SQL Service DBA for all testing/production servers. Modeled and architected 2 iterations of data warehouses to support new CRM/Ordering software systems.
- Led and participate in all requirement gathering sessions with executive staff to deliver valuable reporting tools and data.
- Member of Confidential DBA team for stored value credit and gift cheque data services.
- Lead data related projects to move CRM and ordering software in 2005 to new technologies.
- Manage BI related projects; coordinate and lead efforts of outside consultants to achieve business goals.
- Create and managed internal help desk in regards to reporting and data related activities. Main resource in problem resolution for these incidents.
Confidential, Maryland Heights, Missouri
Clinical Analyst
Responsibilities:
- Led business intelligence program for pharmacy management benefit claims.
- Expert on building data model and reporting solution to utilize PBM claims for Doctor/Patient education programs.
- Created data model with hierarchies for doctor, drug and patient information.
- Database expert for all clinical reporting programs, which included Academic Detailing and mail order reporting.
- Used Microsoft Access, Actuate and Cognos Impromptu to deliver high quality reporting and data to clients.
- Use VBA to efficiently read recordsets for granular data analysis.
- Create and maintain several call center Access databases with efficient security and pessimistic locking strategies to allow multiple users to access database.
- Provided front line system support for any PBM-education data issues. Participated with Express Script helpdesk to create a trouble ticket system for PBM-Education.
- Created and maintained department level SQL Server for use with all client related data and clinical programs. In conjunction with HIPAA, provided security solution to maintain integrity of all information.
Confidential, Webster Groves, Missouri
Technical Support/Data Conversion Support
Responsibilities:
- Provided high quality technical support to internal and external clients using a recruitment/applicant tracking software solution.
- Responsible for all data conversion from client system to Sendouts.com SQL Server. Built these routines within Microsoft Access and Visual Basic.
- Developed testing program for client data conversions, to ensure high quality for end users.
- Acted as Database Administrator for Training level SQL database for use in data conversions.
- Built reporting programs within Business Objects/Microsoft Access for use within the Sendouts.com software program.