• Business Intelligence Professional Tableau developer ,SQL Server 2008/2012 and Business Intelligence Development Studio. Experienced database analyst and report writer working with numerous data sources and report writing tools including Amazon Redshift, Snowflake, SQL server Reporting Services.
• Additional experience includes Agile methodology, business analysis, writing requirement documents. Reliable, professional team player with strong business user mentoring abilities.
Reporting Engineer and business Intelligence Professional. Skilled in placing data into position for asking and answering the right questions. Skilled SQL writer and Tableau Developer Tableau Developer with more that 6 years of hands on experience designing complex dashboards and reports
• Developer of reports and dashboards using Microsoft BI stack
• Analysis and design of disability and health care metrics.
• Daily adhoc development of reports and data feeds for internal and external customers
• Work with team members to produce and document requirements; develop Business Intelligence solutions.
• Created and maintained complex views and stored procedures to support reporting needs
• Provide leadership and mentoring to team members
• Knowledge of the Kimball methodologies of data warehouse design.
• Provide reporting development using Microsoft SQL Server Reporting Services
• Migration of over 50 IBM Cognos Impromptu reports to a Microsoft SQL Server Reporting Services environment
• Manage data migration and transformation from numerous databases into local data warehouse using Microsoft SQL server Integration Services
• Maintain and develop table structures for Microsoft SQL Server data warehouse and data marts
• Provide administration and design of Microsoft SharePoint Services 2007/2010
• Support and development of a Microsoft SQL Server Reporting Services integrated into Microsoft SharePoint 2010 for Microsoft Project Server 2007
Provided Cognos architecture and development consulting (Impromptu, Upfront) and report migration from extremely complex legacy SQL to Impromptu as well as related documentation.
Teamed to create and maintain data warehouse and data marts via application tools that extract and transform data from one or more transactional databases. Performed Cognos Impromptu report writing and Cognos Portal administration.
• Developed reports using Impromptu and Impromptu Web Reports.
• Created multi-dimensional cubes using PowerPlay, Transformer and Visualizer
• Assisted in implementing and maintaining the Cognos Portal.
• Developed training documentation for Cognos products.
• Provided application support with limited mentoring resources.
• Received financial recognition during a period of a merit increase freeze.
Environment: Cognos v 6-7 (Impromptu Administrator and Report Writing, Impromptu Web Reports, PowerPlay Enterprise Server, PowerPlay Transformer, Cognos Portal, Cognos Visualizer), SQL, SQL*Plus, MapInfo, Redbrick, Windows NT/2000, Microsoft Access