SUMMARY

• 10 + years SQL Server\T - SQL
• 5 + years Visual Basic coding and development
• 3 + years SSIS\SSRS 2005\2008R2\2010\2012
• 3 + years Crystal Reports\Business Objects
• 3 + year SSAS 2005\2008R2\2010\2012 Multi-Dimensional and Tabular Modes
• Data analysis and management, database design and administration, forms design and programming for variable data processing in the insurance, healthcare, manufacturing and financial industries
• Functional design, graphics design for forms and websites, dashboard design and deployment, reporting
• Network Assessments, Administration of servers and databases, backup and restoration
• Data warehousing and integration of variant data sources, data cube creation, report generation and deployment
• Scope of projects include full project lifecycle; providing expertise and recommendations to the client, programming, testing, implementation, documentation, training, and change management

TECHNICAL SKILLS

Platforms: SQL Server, Windows Small Business Server, Windows Server 2003, Windows 7\8, Exchange, Sharepoint 2007\2010

Server Software &: Operating Systems

BI Tools: Business Objects, Planview, Clarity, SQL Server 2005\2008\2010\2012 Integration Services (SSIS), Analysis Services (SSAS - MultiDimensional and Tabular), Cognos PowerPlay, Transfluent Data Mapping

Programming Software: Visual Studio 2008\2010\2012, VB Scripting, VB 6, VB.net, C#, X++, SQL Server 2005 BIDS, Visual Interdev, Syteline, TextPipe\WebPipe, PlanetPress 3 & 5

Design Tools: Business Objects 12 & 13, Rich Client, SharePoint Designer, Crystal Reports 6\7, MS Access (all versions), MS Publisher, SQL Server Reporting Services (SSRS)2008\2010\2012, Adobe Creative Suites 2 & 3, Visual Studio 2008\2010\2012

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Business Intelligence Consultant

Responsibilities:

• Worked on 2 Proof of Concepts for an ETL process to take a Web-based ERP tool, extract the data with a SQL query, import the data into SSIS package, and pass the data to another Web based tool using REST services and an API coded using JSON and C#.
• Studying and preparing to take the SQL Server Query Exam 70-461.
• Modified SSIS configuration and ETL packages using SQL Stored Procedures
• Updated all environments with changes, tested and implemented in the Data Warehouse and Data Marts
• Created new packages and modified templates for new Data Warehouse projects using SSIS 2010
• Created new reports and updated existing reports for their clients using T-SQL views
• Converted InfoView\Business Objects reports to Crystal Reports format
• Created DSN’s and change data sources
• Made design changes to reports per user requests as needed
• Normalized data from variant sources\files types
• Created SSIS packages using Visual Studio 2010 and T-SQL, SQL Server 2012
• Normalized and imported 30+ data files
• Created connection managers and SSIS packages to transform and load the data into SQL tables
• Defined and created perspectives and relationships in SSAS 2012(Tabular mode)
• Created SSAS data cubes(Tabular mode) to provide a data warehouse for PowerView and other reporting tools

Environments and Tools: Visual Studio 2010, SSAS\SSIS 2012, T-SQL, SQL Server 2012

Confidential

BI Developer

Responsibilities:

• Lead team of 3 Developers, the QA Analyst and a BA to define use cases and scope of test plan
• Assisted with the setup, testing and implementation of SharePoint roles(SSO and Active Directory)
• Various ETL\T-SQL job tasks(Populating and updating SharePoint lists from SQL databases)
• Converted reports from variant file \data types to SSRS 2008R2
• Converted reports for Dynamics AX 4 to SSRS\Dynamics AX 2012 format
• Set up SharePoint 2010 site, user security, department pages, forms and document libraries
• Created SSIS packages to handle the processing and uploading of EDI files to SQL Server
• Used Visual Studio 2008R2\2010, VB and AX and successfully converted the reports and code from Dynamics AX 4 to the 2012 release
• Installed, created, and implemented SharePoint 2010 pages for all departments using SharePoint Designer
• Created and modified T-SQL, C#, VB and X++ scripts to handle web services, FTP traffic and Dynamics Reporting

Environments and Tools: 15 SQL Server databases, SSRS\SSIS 2008R2\2010, Microsoft Dynamics AX4\2012, SharePoint 2007/2010, C#, T-SQL, VB.net, X++, SharePoint Designer

Confidential, WI

Contract Programmer\Analyst

Responsibilities:

• Reporting and Metrics Specialist for the IT Resource Director
• Designed and customized solutions for tracking labor for all IS projects and resources
• SharePoint Administrator, managing and training over 30 Team Site Administrators and over 500 users
• Site creation, modification and customization of web parts for IS Sourcing
• Created Business Objects reports with Rich Client, T-SQL code
• Created customized reports based on PlanView universes for IS Managers and Sourcing Staff
• Created process and tools to extract PlanView data, cleanse, transform, and format for loading into Clarity
• Created customized reports to extract data from Clarity and provide similar reporting functionality as PlanView

Environments and Tools: Business Objects 12 & 13, PlanView, Clarity, T-SQL, Visual Basic, Microsoft Access, and Rich Client, Resource\ Project\Time Tracking universes, SharePoint 2007

Confidential, WI

Owner\Developer

Responsibilities:

• Converted Syteline Progress code to SQL Server 2005 stored procedures
• Reviewed existing code and created new PL-SQL scripts
• Modified existing file structure and system generated reports
• Created Crystal Reports that are used to call the SQL Server stored procedures
• Created a programming template and trained the users on how to set up stored procedures
• Met with clients and did on-site network analysis, coordinated and scheduled resulting work with the 5 other Technicians
• Provided On-site support to businesses for hardware and software problems
• Application development and programming, Network Administration
• Obtained Microsoft Certification for Dynamics Retail Management Systems
• Designed a complex database for a leading local construction company to track the specifications and regulations for the project using MS Access and Visual Basic scripts
• Customized programming for Retail Management Systems clients using SQL Server(2005, 2008)

Environments & Tools: Microsoft Dynamics Retail Management Systems, SQL Server Management Studio(SSMS), SQL Server 2005\2008, MS Access, PowerPoint, Visio, Publisher, Syteline, VB 6, VB.net

Confidential, NJ

BI Developer

Responsibilities:

• Imported data from diverse data sources into a SQL Server 2005 environment
• Used SQL Server Business Intelligence Developer Suite(BIDS) to manipulate the data, add business rules, create reports and publish to Microsoft SharePoint and PerformancePoint sites
• Implemented a Labor Analysis Business Intelligence solution for a simulated national construction company
• Performance monitoring measures for sales, sales trends, and book return rates for a simulated book publisher deriving data from a SQL Server 2005 OLAP data source
• SQL Server Integration Services(SSIS) was used to define imports of the data, build scheduling packages, to define integration flow, log data error exceptions and orphaned data, define Database Maintenance Plans and send e-mails to process owners
• Created cubes, dimensions and business critical KPIs using SQL Server Analysis Services(SSAS) representing aggregations hierarchically and using custom groupings to analyze performance. Created MDX queries to requirements.
• Developed detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services(SSRS).
• Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership.
• Environments & Tools: Microsoft BIDS(SSIS, SSAS, SSRS), T-SQL, Dashboard Designer, SQL Server 2005, MDX Queries, SSMS
• DBA for all servers, responsible for backup and maintenance procedures
• Analyzed, designed and programmed variable data forms for financial and insurance industries (DEC pages and bank statements)
• Provided Network Administration, maintenance and support of servers, firewalls, user workstations and peripherals
• DBA for RightFax\SecureDocs - created and maintained server and data warehouse for distribution and storage of electronic forms, created and maintained user roles and security
• Worked with clients to evaluate their data, created and performed ETL processes, developed form layout and design programming in SQL and VB.net using the Planet Press Suite and Adobe Creative Suite
• Created ETL processes for mainframe to PC data conversions
• Created and implemented Disaster Recovery Plan for both facilities (Prima Graphics and Prima Data)
• Created and implemented the SAS 70 compliance plan, successfully facilitated the audit process and certification - Technical Lead working with 2 Developers, Network Administrator and DBA

Environments & Tools: Exchange, Outlook, FTP, SQL Server 2005, Windows Small Business Server

Confidential, WI

Database Analyst\Network Administrator

Responsibilities:

• Network Administration, maintenance and support of servers, firewalls, user workstations and peripherals, including backups and restoration of files
• Hardware\Software support for 130 users, assisted remote access yacht owners with connectivity issues
• DBA for Syteline ERP package, maintained data warehouse and created customized reports to improve efficiency
• Created and implemented executive dashboards for the company owners with a web interface which allowed them to see the status of completion for each yacht (used Xcelsius and VB.Net)
• Created queries and reports in Syteline, Project and Excel that allowed cross-checking of items between Bills of Materials for the Purchasing Agents
• Programmed Time Tracking database in MS Access using VB Scripts and SQL that saved each employee 15 minutes a day of manual tracking
• Environments & Tools: SQL Server 2000, MS Access, VB scripts, VB.net, Visual SourceSafe, SQL, Visio, PowerPoint, Project, Syteline, Xcelsius Dashboard designer
• Worked on technical team to remotely assist with set up of interoffice networks for field agents (over 2500 field agents nation-wide)
• Provided programming and database management support for our team
• Hardware and software troubleshooting and support, Spyware/adware removal
• Designed and modified Crystal Reports and MS Access databases (using SQL databases, MySQL, and VB 6.0)
• Created a survey in Crystal Reports (deployed using Survey Solutions) to request input from field agents regarding the option of outsourcing the Call Center, managed the SQL Server database, tracked and summarized responses, created and provided weekly reports to management documenting feedback

Environments & Tools: Crystal Reports, MS Access, SQL Server 2000, MySQL, Survey Solutions, Remedy, VB 6.0, Visual SourceSafe

Confidential

WI Systems Analyst

Responsibilities:

• Developed programs to assist IT Department and Central Billing Office, Technical Lead working with 2 Application Developers and 3 Network Specialists
• Created an ETL process that compiled fee schedules from all clinics with various data types
• Compared rates and volume to local CPT code standards, and developed a standardized company fee schedule using Cognos PowerPlay against an Informix database - dis increased profit and provided consistency in billing among physicians
• Created data warehouses for Physicians, Patient Records, Human Resources, Help Desk\Project Management, Performance Review Management System
• Created data cubes and reports for Finance and Executive Management, Accounting Blue Book reporting using Cognos PowerPlay and Crystal Reports
• Environments & Tools: SQL Server, Access and Informix databases, MS Access, VB scripting, SQL stored procedures, Cognos PowerPlay, Crystal Reports
• Designed, coded and tested screens, files, and programs
• ETL processing of agency data for national insurance company
• Worked on Policy, Claims, Endorsements, Agency, 1099, Bureau Reporting
• Developed PC based printing of all bills, notices, declaration pages converted from AS/400 mainframe
• ETL\Data mapping and conversion from field offices(over 450 offices nationally) uploaded, mapped, normalized and imported data from diverse data formats into mainframe for national insurance agency
• Created data cubes and reports for management and field offices using Transfluent Data Mapping

Environments & Tools: AS\400, Cobol, Transfluent Data Mapping Software