SUMMARY:

• Multi - faceted Data professional with experience in Front End and Back End data solutions. Utilizing the latest .NET and Business Intelligence methodologies to provide start to finish application, reporting and data warehousing solutions. Expert with ETL design, tabular modeling, multi-dimensional data modeling, database design, reporting and web applications.
• Hands on experience with MVC.NET, Microsoft Business Intelligence Stack (SSIS, SSAS, SSRS), Oracle, SQL Server, Informatica and PowerBI

TECHNICAL SKILLS:

Software: Visual Studio 2013, Business Intelligence Developer Studio 2012, SharePoint Dashboard Designer, TOAD, SAP, Crystal Reports, C#, Visual Basic conversion, Visio, Advanced Excel, XML

Operating Systems: SQL Server 2012 Business Intelligence Edition, SQL Server 2008 R2, Oracle 11g, Windows Server 2012, Microsoft Office 2013 Pro Plus, SharePoint 2013 & SharePoint 2010

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

C# .NET Developer / Sr. Reporting Developer

• Develops applications and reports for Fossil/Hydro generation solutions, IT/Business merger projects, business initiatives, IT Corporate initiatives, and IT solution alternatives
• Develops enterprise wide .NET (C#) applications utilizing latest web development technologies including MVC (3, 4 and 5), Bootstrap 3, JQuery, JavaScript, JQgrid, CSS3, Angular.js and Ajax
• Leverages and integrates Oracle and SQL Server data sources into web applications using Entity Framework, ADO.NET and ODP.NET
• Supports system critical Smart Gen technology applications for Fossil and Hydro Generation
• Requirements gathering with Business Unit into technical specifications to estimate solution delivery cost and timeline to stakeholders in order ensure predictable outcomes
• User Interface design (UI) and User Experience (UX) with responsive design
• Develops and supports data delivery of Generation data to the Federal Energy Regulatory Commission from SQL Data Warehouse
• Supports existing Reporting and Analytics Solutions and assist in design and creation of new reporting solutions
• Creates dashboards using multi-dimensional SSAS cubes and external data sources for analytical ad-hoc reporting and metrics visualizations
• Creates implementation plans for migration management for test and production environments
• Perform application testing in accordance with company standards and as outlined in approved testing plans
• Creates technical documentation using defined technical documentation templates that met SDLC standards
• Analyze, document and corrects reported defects

Confidential, Charlotte, NC

Business Intelligence Developer

• Design and implement new data warehouse used for Integrated Risk Management of southeastern bulk electric system, including datasets from internal and external data sources
• Create data models using multi-dimensional SSAS cubes and Tabular models for analytical ad-hoc reporting
• Developing new dimension tables for the data warehouse, includes end-to-end development from the initial requirement gathering to the final presentation layer
• Cube design, development and support for integrated risk data warehouse
• Implement Data mining functions and comprehensive analysis of business operations using MDX queries
• Support daily data imports using SSIS packages from external data sources including XML, flat files, Web API’s and excel sheets
• Served as Project manager of enterprise-wide centralized reporting dashboard including user acceptance testing and post deployment training.
• Created SharePoint 2013 BI dashboards using Performance Point services and Excel Web Services to craft KPI’s and Scorecards ranging from Corporate Metrics to Technical Operations
• Reverse engineered complex VBA powered workbooks and internal application reports into SSRS Reports
• Implement SSRS reports and manage accurate report delivery to various business units
• Perform root cause analysis to determine source of errors, correct the underlying issues and make recommendations to business units based on the results
• Monitored performance and modified code as needed to improve performance and reduce occurrence of errors
• Improve business efficiency utilizing automation via complex stored procedures and C# scripts when applicable
• Minor DBA tasks including query performance tuning, table and view creation, table indexing and backup job scheduling

Confidential, SC

SSRS Report Developer / IT Tech

• Created complex analytical SSRS reports utilizing multiple datasets, data sources and sub reports, using BIDS and SQL Server Data Tools
• Created multifaceted drilldown SSRS reports within graphical dashboards, including charts and maps, analyzing a wide range of business operations, from raw materials purchasing and inventory to production to sales and shipments
• Determined new report requirements for parameters, datasets, visuals and other necessities based on weekly production meetings and collaboration with various business units
• Created SSIS Packages to perform data conversions and imports from flat files to SQL tables
• Querying OLAP data cubes for excel PowerPivot
• Deployment and testing of new SSRS reports into SharePoint 2010 native Report Viewer
• Converted existing SAP Crystal Reports into SSRS Reports for redeployment and subscription
• Created complex stored procedures and views
• Decipher, document and modify existing complex queries
• Created report snapshots and facilitate automated report delivery to business unit managers
• Responsible for designing, building, enhancing and supporting Microsoft Business Intelligence solutions and assuring smooth ongoing operation of the solutions
• Review, assess current reporting state and identify improvement opportunities and best practice recommendations

Confidential, Charlotte, NC

IT Helpdesk Analyst - Level 2 Team Lead

• Served as level II IT Helpdesk as Team Lead providing training, call monitoring and quality assurance in a IT Helpdesk supporting over 40,000 North American employees
• Application support for Citrix Farm Applications accessed locally and remotely by VPN
• Modified and administered Firewall Rules as needed for production and test environments
• Troubleshooting for VPN connectivity using Sonicwall and Cisco AnyConnect
• Monitored network connectivity and escalated enterprise support tickets with service provider for downed network circuits

Confidential, Charlotte, NC

IT Helpdesk Analyst

• Provided frontline Helpdesk & Desk Side support for over 180,000 North American employees
• Created and resolved tickets using BMC Remedy Ticketing System
• Troubleshooting comprehensive corporate software deployments and upgrades
• Advanced support for Microsoft Office 2003, 2007 and 2010
• Software installs and upgrades through remote desktop
• Account unlocks and password resets using Active Directory

Confidential, Concord, NC

TSR - Vonage - (Contractor)

• Provided technical and customer service support for customers, including installation and configuring/reconfiguring customers’ VOIP hardware devices and home networks
• Setup of advanced Firewall configurations such as port forwarding, DMZ, MAC cloning, MAC Filtering, Port Forwarding, QOS, etc.
• Provided support and training for VOIP software utilized for inbound/outbound domestic and international calls
• Maintained top of the line customer service while utilizing multiple applications to accurately document and record customer needs and concerns
• Assisted with TCP/IP connectivity issues, re-establishing connections to existing networks

Confidential, Charlotte, NC

Web Developer/Web Designer

• Proficient in various web languages including HTML, PHP, C#.NET, VB.NET, ASP.NET
• Cascade Styling Sheets - CSS, JQuery, Java Script and Unobtrusive Ajax
• Created .NET web applications with SQL back end, using ADO.NET and Entity Framework
• Created database tables, views and stored procedures.
• UX and UI design experience
• Assisted in the design, development and maintenance of over 30 websites and applications
• Created User navigation flow charts, sitemaps and wireframes for site pre-planning.
• Created custom web templates over existing platforms such as WordPress, Joomla and Drupal