Whiting, IN 46394
219-***-**** firstname.lastname@example.org linkedin.com/in/millsgroninger
Business Intelligence developer skilled in SQL, SSIS, SSAS, and SSRS. Extensive work in merging diverse data sets into centralized warehouses for internal analytics/performance management, ad hoc inquiries, and external regulatory reporting. Accomplished in conducting root-cause analysis of data quality issues. Experienced in requirements gathering, implementation, and training/support. Knowledgeable in OLAP and complex reporting environments. Excellent written and interpersonal communication skills. Evangelist for data-driven decision-making.
T-SQL, SQL Server 2008 R2 and 2012 Integration Services (SSIS) including ETL, .NET and C# components, SQL Server 2008 Analysis Services (SSAS), SQL Server 2008/12 Reporting Services (SSRS), Microsoft Office SharePoint Server 2007, Microsoft Visio, Microsoft Access and Access VBA, Microsoft Office integration with a concentration on MS Excel. BusinessObjects reporting and universe design.
MS SQL Server 2008 R2/2012, Access/Jet, Oracle 10g
SQL Server Business Intelligence Development Studio/Visual Studio, BusinessObjects Enterprise Desktop Intelligence and Web Intelligence
T-SQL, PL/SQL, MDX
Redwood Logistics Chicago, IL 2013 – Present
Senior BI Developer
Holding company concentrating on brokerage, fleet management, and third party logistics. Constituent companies use in-house, commercial, and SaaS software with a high level of integration and overlap of data sets.
Developed SSIS packages to import data from newly acquired companies with innovative solutions to deriving required data for the destination system that did not exist in the source systems
Created numerous MDX queries to speed investigations into cube data quality issues
Implemented SSAS/OLAP cubes for senior management to investigate non-financial business processes
Maintained and developed extensive set of SSRS reports over multiple LOBs
Implemented and maintained T-SQL stored procedures, triggers, and UDFs, including refactoring for speed and ease of maintenance
AXA-Assistance Chicago, IL 2011 – 2013
Business Intelligence Reporting Analyst
AXA helps travelers with health and lifestyle problems on behalf of insurance and credit card companies. Challenges include call center data, multiple case and claims management systems, and international payments.
Implemented BusinessObjects report development and universe changes resulting in seamless transition to new back end call-center database architecture. Provided extensive handholding to user community to introduce new environment. Provided hospice assistance to BusinessObjects during transition to SSRS.
Built and maintained SSIS packages to consolidate data from Avaya/Informix, Excel, and PCI-secured SQL DBs resulting in broader reporting opportunities and comprehensive response to client inquiries.
Created SSRS environment for internal and external reporting on process control, financial, and performance metrics. Extensive use of drill-down features and KPIs allows executives to identify under and over-performing areas requiring intervention or replication.
Implemented pure SQL-based NCQA/HEDIS measures resulting in more accurate reporting, faster turn-around, and more consistently repeatable results over previous semi-manual methods. Successfully presented results and code to evaluator with the full set of measures being accepted prior to deadline.
Introduced self-service BI tools via SQL back end to Excel pivot tables resulting in improved understanding of trends in underlying data and fewer, but higher quality, requests for ad hoc queries
Independent Consultant, Whiting, IN 2010 – 2011
Information and technology management
Providing nonprofits, government agencies, and small businesses with software selection assistance, application design and maintenance with Microsoft tools (including SQL and MS-Access), and operational support.
Overhauled product pipeline and sales reporting systems in SSRS and Access for a manufacturing company that improved decision making by streamlining KPIs.
Built and maintained donor and client focused CRM and analysis databases, saving clients up to $50k over alternate solutions.
Utilized SQL Server and Access databases for development, as well as proprietary systems
CNA Financial, Chicago, IL. 2007 – 2010
International Property and Casualty insurer
Senior Business Analyst, Data Quality
Seventh largest property and casualty insurer in the US. Member of four-person team within Corporate Actuarial researching the root causes of data errors and inconsistencies. Acted as adjunct team member for numerous statistical reporting projects for internal and external customers, often regulatory agencies.
Streamlined data warehouse research tools using Oracle data to feed Excel, Access, and Outlook to help staff respond to regulator inquiries 30% faster over prior methods.
Improved data quality through root cause analysis of interrelated claim, policy, and financial datasets to deliver submissions on time with fewer fines from regulators.
Improved year-to-year efficiency and consistency of reporting by creating a series of Excel VBA tools that allowed users to switch between multiple datasets while preserving complex pivot tables and other formatting.
Enabled C-level risk analysis of KPIs and deadlines via innovative scoring and assessment tool.
IT Resource Center/Lumity, Chicago, IL. 1994 – 2007
Nonprofit technology and financial management consulting and training agency serving local and national nonprofits.
Associate Executive Director/Senior Consultant
Increased the impact and efficiency of more than 400 nonprofits per year via training and consulting services, saving them $2 million annually.
Achieved 5+ year retention of staff and volunteers, reducing service disruption and maintaining better client continuity and satisfaction.
Licensed service tracking/invoicing CRM application to 8 partners across the US.
Recruited C level executives to Board, developing cash and in-kind contributions.
Developed national support network, gaining access to best practices in administration and service delivery.
Master of Fine Arts, Florida State University, Tallahassee, FL
Bachelor of Arts, Purdue University, West Lafayette, IN
Business Intelligence Master’s Program, SetFocus, LLC, Parsippany, NJ
The SetFocus Business Intelligence Master’s Program is an intensive, hands–on, project oriented program where participants add knowledge and valuable experience putting the Business Intelligence skill set to use in a simulated work environment.
Consolidated Existing data from diverse data sources into a uniform SQL Server 2008 database. ETL capabilities of SSIS were used to define imports, build scheduling packages, define integration flow, log data error exceptions and orphaned data, and to define Database Maintenance Plans with email notifications.
Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX queries according to business requirements.
Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
Implemented Business Intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership.
Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios, such as multiple hierarchies, data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions. Possess solid knowledge of writing, tuning and optimizing T-SQL queries.
Author of the chapter Staffing ePhilanthropy in the book Nonprofit Internet Strategies. Contributor to multiple publications and books including: Advancing Philanthropy, Chronicle of Philanthropy, Printout, Nonprofit Management Strategies.
Member, Automated Data Systems Reform Panel for the Illinois Department of Children and Family Services (DCFS).
Grant reviewer, US Department of Commerce NTIA TIIAP/TOP program and Chicago Community Trust.
Freelance technology trainer, including SQL Boot camp for GeneralAssemb.ly