Sql Server Sales
Resume:
Roger Mabry BI
Marietta, GA *****
******@*******.***
http://www.linkedin.com/in/rogermabry
SUMMARY
Highly motivated Business Intelligence Professional using SQL Server 2008 and Microsoft Technologies.
Experience manipulating various data sources to support Senior Management decisions. Demonstrated
leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction
and supervision.
CERTIFICATIONS
TECHNICAL SKILLS
Microsoft Technologies:
SQL Server 2008 Integration Services (SSIS), SQL Server 2008 Analysis Services (SSAS), SQL Server
2008 Reporting Services (SSRS), Microsoft Office SharePoint Server 2007, Microsoft Office Performance
Point Server 2007, Microsoft Visio & FrontPage.
Databases:
MS SQL Server 2005 & 2008
Software:
Utilization of Visual Studio .NET 2008, & SQL Server Business Intelligence Development Studio for the
above Technical skills.
Commercial Skill Sets
Skill Years experience Proficiency Year last used
Active Server Pages/HTML 9 Expert 2011
Adobe Acrobat Prof 9 Expert 2011
Dream Weaver 3 Intermediate 2008
Java Script 6 Expert 2008
LMS Pathlore, Plateau 1 Intermediate 2011
LMS SABA, Atlas Pro, Moodle 5 Expert 2008
MS Access 11 Expert 2013
MS Excel 11 Expert 2013
MS FrontPage 11 Expert 2013
Ms Office all major apps 10 Expert 2013
MS Project 5 Intermediate 2010
MS VISIO 6 Intermediate 2011
MS Visual Studio 1 Intermediate 2012
Oracle 4 Intermediate 2011
Plateau Report Designer (PRD/BIRT) 1 Expert 2011
Question Marks "Perception" Assessment App 5 Expert 2008
SCORM/AICC 5 Intermediate 2008
Share Point 2007 4 Intermediate 2011
******@*******.***
SQL Server 2005 08: Administration 6 Intermediate 2013
SQL Server 2005 08: Reporting services 6 Intermediate 2013
TCP/IP 11 Expert 2013
Windows NT LAN Administrator 9 Expert 2013
******@*******.***
PROFESSIONAL EXPERIENCE
Vertisys, Corp Marietta, GA 05/13 – 10/13
Help Desk tier I/II Support
• Desktop Support Provided services either remotely or on site visit
• Helpdesk applications: Spiceworks and ConnectWise.
• MS Exchange Server Administrator Configuration Of Outlook Clients for Email, Contacts and
Calendars. Ensured synchronization on Exchange server for clients, desktops, laptops and
Phones where appropriate.
• Remote Support /Control: Logmein, Symantec desktop, NTR global, Webex.
• Imaging of workstations using Ghost Server, & Acronis Backup and recovery.
• Backing up of critical client Data using CA ARCserve D2D.
• Enterprise Content Management (ECM)Desktop hardware, iManage
• LAN troubleshooting, configuring Cisco Catalyst Switches and Routers.
• Printer installation and troubleshooting
• Remote connectivity via Cisco VPN or RDP
• Excellent working knowledge of Windows XP/7
• Excellent working knowledge Office 2003 2010
• Expert knowledge of Outlook 2003 2010
Whittaker and Associates, Inc Marietta, GA 11/12 – 2/14
Director Of Technical Recruiting
I was brought on to bring to the Company the experience of Recruiting Top notch Candidates in the
area of "Technology". From Networking, Database Management, Business Intelligence, E
Learning to Configuration Management. We aim to provide to our Clients the most qualified
Candidates possible.
Summit Industries Marietta, GA 07/12 – 10/12
Consultant Microsoft Reporting Services Developer
• Developing & troubleshooting SSRS reports
• Converting SSRS Reports ver2008 to Crystal Reports ver2010
• Troubleshooting SQL Server Configuration for consistent operations.
• Configuring Crystal reports for Client usage as report writers.
• Developing ADHOC reports for power users.
• Trouble shooting Client workstations for proper configuration for reporting: both SSRS,SSAS &
Crystal reports (Business Objects).
******@*******.***
SunTrust Bank Atlanta, GA 08/10 – 10/11
Plateau/Pathlore LMS Administrator with Reporting Responsibilities.
• Created job AID For Users to run reports
• Created Job AID for Report Runners & Risk Managers.
• Created user groups to run reports for specific reports
• Add users to report groups.
• Design reports to run as a background report vice “real time” to save System resources to run
LMS.
• Provided banking "Lines of Business” Reports needed to track compliance training.
o Familiar with over 70 Report Runners Needs and Reports
o Familiar with over 15 Risk Managers Needs and Reports
• Utilize "SQL Reporting “Services under “Business Intelligence Design Studio (BIDS)” for SQL
2005 Enterprise edition.
o Created over 100 reports
Curriculum reports
o
Item status reports
o
Pivot tables with excel
o
Created reports using custom fields
o
Utilized SQL Agent for creating Report Subscriptions.
o
Delivery Method:
• SharePoint Site
• Plateau Analytics BI Tool Ver. 6.2 Created typical OLAP navigations such as drill downs, roll ups,
and the slicing and dicing of tables to customize views of reports for Compliance reporting.
• Pathlore LMS Ver. 6.1 Reporting In depth Utilization of Crystal Reports Ver. 9, Microsoft Access,
Microsoft Excel, Microsoft SSRS, MS SQL 2005 for Back end DB, JavaScript and XML coding .
(VBA)Visual Basic for Applications and Visual Studio.. Utilized dot net & .ASP pages for “Lines of
Business” reporting.
Atlanta Technical College Atlanta, GA 04/10 –06/10
Adjunct Instructor Reporting Analyst
• Teaching a basic Microsoft Office 2007 course. Instructing general lessons in Windows for
navigation, familiarity and file management, as well as an introduction to Word 2007, Excel 2007,
Access 2007, and Power Point 2007.
• Responsible for various paperwork that accompanies the course, keeping track of attendance
and grades.
• Administer the use of the Angel Learning Management System to enable to students to take tests,
turn in project work and complete assignment work.
• Created Reports for Management Utilizing Access/Excel for Student completion and grades.
******@*******.***
SetFocus, LLC. Parsippany, NJ 11/08 1 /09
Master’s Program – Business Intelligence
• Implemented a Labor Analysis Business Intelligence solution for a simulated national construction
company.
• Existing data from diverse data sources were consolidated into a uniform SQL Server 2005
database. SQL Server Integration Services was used to define imports of the data, build
scheduling packages, to define integration flow, log data error exceptions and orphaned data and
to define Database Maintenance Plans and send emails.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis
Services (SSAS) representing aggregations in several different ways hierarchically and using
custom groupings that the company will use to analyze performance. Created several MDX
queries according to business requirements.
• Developed several detail and summary reports including line and pie charts, trend analysis
reports and sub reports according to business requirements using SQL Server Reporting
Services.
• Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel
Services producing different summary results based on user view and role membership.
• Created score cards with executive summary dashboards using MS Office Performance Point
Server 2007 Dashboard Designer that display performance monitoring measures for sales, sales
trends, and book return rates for a fictitious book publisher deriving data from a SQL Server 2005
OLAP data source and deployed them to SharePoint sites . The dashboards also contain drill
down capabilities to view book sales by book category and customer, through summary reports
and sales trend charts.
• Created score cards with advanced set of dashboards using MS Office Performance Point Server
2007 Dashboard Designer that feature executive summary measures for revenue, overhead
costs, material purchases, labor and profitability trends for a fictitious construction company
extracting data from a SQL Server 2005 OLAP data source and deployed them to SharePoint
sites. The dashboards also contain pages to view performance by employee, by region, and by
quarter enabling end users to make filter selections.
HIPK, LLC. Atlanta, GA 12/07 9/08
JTIDS/MIDS Deconfliction System And Database Administrator
• (Same duties as 10/02 11/04)
• Addition of MS BI Tools SQL 2005,SSIS,SSAS SSRS
******@*******.***
SDS International, Inc. Atlanta, GA 11/04 12/07
Learning Management System Administrator
Responsible for the operation and maintenance of the SABA Learning Management System
•
(LMS). My Background with the Navy’s NITRAS /CANTRAC system, similar to (ATTRS), allowed
me the ability & experience to manipulate the LMS. Publishing the SCORM Packages using
Shareable Content Objects (SCOs).
I also performed the following tasks:
•
o Created system accounts and assigning LMS roles and privileges to users.
o Activation and deactivation of user accounts.
o Respond to approved requests from users to make changes to database (e.g. add a new
resource type).
o Monitor the system and the system interfaces to ensure required availability.
o Respond to alerts from the system based on severity.
o Notify users of scheduled and unscheduled down times for maintenance and emergency
operations.
o Coordinate maintenance tasks with the systems administrators / operations and
maintenance groups of external systems.
Designed & Developed the classified (SIPR) network website for the division. Provides tactical
•
documents and recourses for the war fighter on and off the battle field
Implemented the Navy’s Authoring Instructional Materials (AIM II) Learning Content Management
•
Tool. Provides for learning content for developing, maintaining and delivering task based
curriculum products, utilizing SCORM ver. 2004.
Developed, implemented Deployable class room. "Lan In a Can".
•
Created a secure wireless network that is exportable (mobile). Students can register, provide
•
critiques, and conduct testing using QuestionMarks’Ver 4.4” "Perception" Testing Machine.
Designs Web pages for student access and utilization at the school house.
•
Designs Web pages for the Instructors to reach content for the classroom.
•
Designs interactive web pages for the ISD (Instructional System Design) Department, to obtain
•
critical DB data. Such web pages query critiques, student registration, testing data bases for end
of course reporting.
Created Share Point Survey on division Website. Survey designed to provide student feedback.
•
******@*******.***
SDS International, Inc. Atlanta, GA 10/02 11/04
JTIDS/MIDS Deconfliction System And Database Administrator
• Operate, maintain and administer the JTIDS/MIDS Deconfliction Server (JDS) Website
https://jndl.forscom.army.mil. (Password protected).
• Coordinate and develop change/addition requirements to the baseline JDS software and
incorporate fixes and patches.
• Update, maintain and administer all existing Microsoft SQL, ACCESS and ORACLE
Databases required for the JTIDS/MIDS Deconfliction Server, and identifies and develops
new ORACLE Databases as required for growth of the JTIDS/MIDS Deconfliction Server.
Develop, maintain, and migrate Microsoft ACCESS Databases to Microsoft SQL Databases,
when required for enterprise usage.
• Update, maintain and administer the Deconfliction System domain, administer computer and
domain security, and administer JTIDS/MIDS user access to the Deconfliction Server.
• Update, maintain, and administer the JNDL Website, including the JTIDS/MIDS Deconfliction
Server.
• Act as the principle point of contact for JTIDS/MIDS Deconfliction Server, assist user, provide
technical support, and manages daily database operations.
• Provides periodic 24 hour on call support for administration of the JTIDS/MIDS Deconfliction
Server.
• Assists the JNDL staff in providing technical assistance and advice to Joint Staff, Services,
unit, and terminal operator personnel in the resolution of pulse deconfliction issues.
• Updates and maintains the JTIDS/MIDS Deconfliction procedural documents, including
Standard Operating Procedures (SOP), user, administrator, and training manuals as required.
• Assists the JMTS staff with the Pulse Deconfliction Server blocks of instruction.
• Conducts Pulse Deconfliction Server user training at other military site locations.
L 3 Communications. Atlanta, GA 01/01 09/02
JTIDS/MIDS Deconfliction System And Administrator
(SEE above) Conducting and performing same responsibilities when SDS International was awarded
contract.
EDUCATION
American Intercontinental University (AIU), Atlanta, GA 07/2003
Masters of “Information Technology” Degree Overall GPA 3.75
Certificate, Local Area Network Technology Program, North Metro Technical Institute, March 1996)
Published articles.
• USMTF Automation & Managers Course Presentation, January 1996, Fort McPherson.
• MAJIC Glossary, February 1996, Principle Author, Fort McPherson
• Configuration Managers Manual, May 1999, Dobbins ARB
• SJDS “Spatial Joint Deconfliction Server” Users Manual, Nov 2002, Fort McPherson
******@*******.***
• Dissertation- “ Pulse Deconfliction in an International Arena ” May 2005, Fort
U U
McPherson, GA
Contact this candidate