SUMMARY:

• I have a healthy appetite for technology. I've always been fascinated with it and more so it's ability to assist us human beings live to our fullest potential.
• One area where I am most passionate about is centered on is data.
• Gathering, manipulating, storing, analyzing data to expose the ways in which it can help us live fuller, better lives.
• It's truly valuable when you unlock the ability of well read data to assist humanity.
• Freelancing gives me the opportunity to meet new people to work with and toward the ultimate good; service to humanity.

SKILLS & EXPERTISE:

Microsoft SQL Server SSRS

Databases Business Analysis SDLC

Software Development Requirements Analysis Visio

Access

SharePoint

Business Intelligence

Testing Analysis Microsoft Excel SQL

Visual Basic Integration VB.NET ITIL

IT Service Management Software Documentation VBA

HTML

EXPERIENCE:

Senior Database and Reporting Developer

Confidential

Responsibilities:

• Design and develop database models that support Partner facing Firm applications
• Adopt SQL Server best practices and standards for legal industry client facing applications
• Develop SQL scripts surrounding core legal data dimensionsDesign SSRS report visuals, quantifying, aggregating and trending data used by Firm Partners
• Create SSIS packages to extract external data, applying the appropriate transformation logic and loading to Firm supporting applications.
• Participate in data and report related new technology reviews and discussions to provide the best supporting technology available
• Daily communication with DBAs, Business Analyst, Clients, Application Developers, Managers, Designers

Technologies: SQL Server 2008 R2, 2012, Microsoft Visual Studio 2008, 2010, 2012, SharePoint Integrated Mode 2010, SQL Server Tool Belt

Confidential

Responsibilities:

• Actively interacted with business managers, project managers, technical managers, DBAs and users to fully understand system requirements.
• Comprehensive understanding of ITIL framework and principles aimed to govern Information Technology as a service to the business (Incident, Availability, Problem, Change, Capacity and Supplier Management)
• Created online service performance reports within the enterprise wide Service Now IBM system quantifying and trending data that span across high volume time frames, using Service Now Reporting module.
• Created SSIS packages to extract, transform and load data from multiple data sources to a single data SQL Server database repository.
• Designed T SQL scripts, joining and aggregating tables as necessary (Left, Right, Inner, Outer, Group By, Sum, Avg, etc.) to query repository (above) using SQL Server 2012 objects (Views, User Defined Functions and Stored Procedures)
• Created SSRS Key Performance Indicator (KPI) reports in alignment with ITIL focus areas relevant to business stakeholders interests. Displaying graphically, metrics such as (Outage Durations, Critical Incidents Logged, Mean Time to Resolve Critical Incidents, etc.) using SSRS Gauges, Indicators, Charts, etc.
• Developed interactive features for SSRS reports allowing user to filter, sort and drill thru to related detail data sets; using Drop Down List Parameter, Cascading Parameters, Linked Reports, Sub Reports and Dynamic Matrix.
• Created supporting MS Access and Excel reports using Macros with complex VBA Scripting (IF, Then, Do, While Loops, Names Ranges) and advanced formulas (VLOOKUP, SUMIFS, INDEX + MATCH, SUMPRODUCT).

Confidential

MS SQL Server/SSIS/VBA Developer

Responsibilities:

• Created a multi - layer User Interface (UI) for data entry using Microsoft Access Forms, Sub Forms, Select, Crosstab and Append queries in conjunction with underling VBA coding.
• Created SQL Server 2008 data warehouse building Dimension tables for sorting and filtering of assembling data from multiple sources (MS Access, CSV Flat Files, Excel and Oracle Database).
• Designed strategies to Extract Transform and Load Employee Benefit data to the data warehouse using SSIS Data Flows.
• Created multiple User Defined Functions (UDF, Stored Procedures and Views) to apply proprietary decisive formulas, categorizing Active and Retiree employee populations and applying appropriate benefits to them.
• Designed and developed tabular and graphical SSRS reports using Grouped Tables, Calculated Fields, Conditional Formatting, Gauges, Drop Down and Cascading Parameters within the Reporting Services environment. Reports clearly illustrated allocation of employee benefits to correct employee bases as determined by HRIS system logic mentioned in previous bulled point.
• Improved report execution times by 20% via altering underlying Stored Procedures T SQL scripts and scheduling SQL Server jobs to trigger data refreshes during off peak hours.

SQL Server/SSIS/SSRS Developer / Business Analyst

Confidential

Responsibilities:

• Designed precision critical SQL Server 2008 Stored Procedures Views, Triggers used as dataset inputs for
• SSRS online reports.
• Created and modified SSIS packages to import data from SQL Server, Oracle, comma and tab delimited external data sources; extracting, transforming and loading (ETL) to a SQL Server 2008 data repository.
• Performance tuned existing stored procedures and functions improving report generation time.
• Used Reporting Services to create new SQL Server online reports displaying summary data in dashboard format. Build into dashboards clickable drill thru functionality to view related detail data in tabular format.
• Worked closely with business managers and produced technical requirement documents citing report design, performance standards, SQL Server object selections and hardware specification for new SSRS report development.

Manager of Software Development/MS Access/SQL Server Developer

Confidential

Responsibilities:

• Created custom relational database structures using SQL Server, capable of processing Point of Sale (POS) retail data for various vendors of major discount retailers.
• Analyzed data content specific to individual vendors, creating strategic table indexes to optimize the processing 10+ million rows of data.
• Developed numerous Views and Stored Procedures to query and process POS data in preparation for SSRS report data set inputs
• Created online SSRS reports using Reporting Services to display business critical product sales data, critical to vendor product placement.
• Developed VBA Scripts within MS Access and MS Excel environment to provide supporting reports.

SQL Server /MS Access/ Excel VBA Developer

Confidential

Responsibilities:

• Reviewed, developed and designed application and data models using Logical Data Modelling, Visio and User Interface prototypes.
• Translated requirements into physical client server relational database applications using VB6 and SQL Server 2005, MS Access and MS Excel.
• Optimized application performance via applying non - clustered and clustered indexes to appropriate tables and indexing views.
• Created complex Stored Procedures and views involving multiple table joins (Union, Left, Right, Full, Inner and Outer).
• Automated inter departmental processes with systems as described above; effectively improving speed, accuracy and communication of time sensitive business functions.
• Installed configured and administered SQL Server 2005 software on Microsoft Windows Server 2008.