Al Ottley
Database Developer/Data Warehousing/Data Mining at Ent Federal Credit Union
Database Developer at Ent Credit Union
Highly motivated Business Intelligence Professional using SQL Server 2005/2008 and other related 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.

o SQL Server 2005/2008 Integration Services (SSIS)
o SQL Server 2005/2008 Analysis Services (SSAS)
o SQL Server 2005/2008 Reporting Services (SSRS)

o Microsoft Office SharePoint Server 2007 (MOSS/SP)
o Microsoft Performance Point Server (PPS)

o MS SQL Server 2005/2008
o MS Office Visio

o Business Intelligence Development Studio (BIDS)
o SQL Server Management Studio (SSMS)

o T-SQL
o MDX 

I am also an experienced, insightful and results oriented Information Technology professional with many notable successes related to Business Marketing and Call Traffic Settlement initiatives in the Telecommunications Business. 

Extensive participation and contribution to the development and implementation of specific client based solutions, to support various and numerous business objectives and requirements. 

Possess a multitude of hands-on experiences in various stages of systems development, including analysis, design, architecture, testing and support. 

Motivation and guidance to other team members to facilitate timely project completion and consultation is always enthusiastically provided.

I've worked in mainframe environments, midrange environments and with a variety of DBMS back ends, such as DB2, Oracle, Sybase, Informix and MS-SQL Server. 

I always welcome opportunities to further my knowledge and education, solving problems to meet design goals and business requirements and seeing a project come to fruition.

Specialties: Recent, intensive and extensive knowledge with MS SQL Server 2005 and 2008 (SSIS, SSAS, SSRS), MDX, T-SQL, PPS, SP, and Visio.

Mainframe based data transformations for midrange processing; extensive use of mainframe tools, particularly Endevor and CA-7; PERL and KSH scripting for writing and handling database loads on UNIX/AIX platforms.
Ent Federal Credit Union
https://www.linkedin.com/company/entcreditunion
Database Developer/Data Warehousing/Data Mining
Analyze and develop varied DB warehousing solutions. Develop both Tabular and Multidimensional Analysis Services solutions. Explore data mining and predictive analytics opportunities.
Colorado Springs, Colorado
https://media-exp1.licdn.com/dms/image/C4E0BAQGLSNiPX0SD9A/company-logo_100_100/0/1598394142935?e=1655942400&v=beta&t=_wdkE8pX78vYYqRtebeCZuC0oQiqNN7aJjQpLVob7e0
Colorado Springs Health Partners
https://www.linkedin.com/company/colorado-springs-health-partners
Business Analyst/Data Analyst/Reporting
Colorado Springs, Colorado Area
https://media-exp1.licdn.com/dms/image/C560BAQEO9MODA7NZrg/company-logo_100_100/0/1519902759061?e=1655942400&v=beta&t=z5rL8V1JNVMmQhA4bjHngAL35zOVJXaIhwzS19zue0M
HP
https://www.linkedin.com/company/hewlett-packard-enterprise
Consultant
•	Designed and implemented numerous databases, tables and requisite relationships and stored procedures to support hardware issue tracking and management reporting.
•	Developed SQL Server Integration Services ETL packages to extract, cleanse, validate and consolidate data from SharePoint lists and other external database back ends.
•	Designed and developed numerous T-SQL scripts, stored procedures and user defined functions to gather and prepare data sets for the many authored reports. Parameterized reports use T-SQL queries to populate parameter lists.
•	Developed numerous daily, weekly and monthly summary and detail reports to support management reporting requirements and to improve timely and accurate reporting utilizing SQL Server Reporting Services and a centralized Report Server. Created scorecard reports using report parts and sub reports. 
•	Reporting requirements include parameterized, cascading parameter, drill down and drill through reports. Many reports were set up to use subscriptions for automated execution and delivery.
•	Maintained all of the SQL Server databases and DB permissions; maintained all Report Server objects and permissions.
https://media-exp1.licdn.com/dms/image/C4E0BAQH6qdm7VJ5BPA/company-logo_100_100/0/1593697162881?e=1655942400&v=beta&t=nfWKAePFfhlchhCtfjX-IPzN5Jdvn6x5iaJ5CCTI5Ls
SetFocus
https://www.linkedin.com/company/setfocus
Graduate-Business Intelligence Master's Program
I have completed the Business Intelligence Master's Program at SetFocus. This has been an exciting experience working with SSIS, SSAS, SSRS, MDX queries, Sharepoint Services and Performance Point Server.

Microsoft Technologies:

o SQL Server 2005 Integration Services
o SQL Server 2005 Analysis Services
o SQL Server 2005 Reporting Services
o Microsoft Office SharePoint Server 2007
o Microsoft Performance Point Server

Database:
o MS SQL Server 2005

Software:
o Business Intelligence Development Studio
o SQL Server Management Studio

Query Languages:
o T-SQL
o MDX
https://media-exp1.licdn.com/dms/image/C4D0BAQHFymcYktfOSA/company-logo_100_100/0/1519856162141?e=1655942400&v=beta&t=KGiM6vDg0X2ei00Utx94_mIFMmIXpY5Sp_PDp0FdPUw
Verizon Data Services
https://www.linkedin.com/company/verizon-data-services
Support Analyst/Programmer-Analyst
•	Analyzed and successfully redesigned and implemented a mainframe front end for third party marketing data, eliminating unnecessary CNTL member modifications for e-mail notifications, error notifications and FTP data transmissions—all reducing manual intervention significantly, as Vendor providers and FTP targets changed.
•	Analyzed and designed a complete rewrite to a manual ETL process to improve MS SQL DTS package and Teradata SQL procedure processing times, reducing machine load and processing time by 30%. Automated entire job streams by processing UNIX based BTEQ scripts into parallel ESP and ESP/X scheduled jobs.
•	Correctly identified and migrated numerous production Teradata database tables to a new production database, working with several DBAs to design and create the new production environment, modifying numerous BTEQ scripts to reference the new DB table design, testing and installing the modified scripts and ESP/X jobs and coordinating the final cutover into production.
Worldcom/MCI
https://www.linkedin.com/company/verizon
Analyst/Programmer
Consulted and worked with business analysts, marketing personnel, technical analysts, QA testers and implementation personnel to enhance and improve the efficiency, productivity and the system functionality of various marketing system data feeds.
	
- Analyzed, designed, developed and implemented numerous enhancements to several processes, extracting and transforming additional data elements from numerous ADABASE and DB2 data sources, supporting the requirements of expanding business requirements and practices.
- Integrated existing application functionality into an on-line Lead Database system, from other antiquated, disparate and obsolete marketing systems, incorporating appropriate data transformations and business logic.
-	Monitored, maintained and modified, dozens of daily, weekly and monthly mainframe job streams that support several downstream feeds to UNIX and Sybase midrange processing platforms. ABENDs were analyzed for cause and appropriately modified to eliminate future occurrences.
https://media-exp1.licdn.com/dms/image/C560BAQHAiVb75wIpDQ/company-logo_100_100/0/1645721742845?e=1655942400&v=beta&t=EJhgPS8YHpG2nKlT1Ahkl9zXcz9zkBiG-nMutIZTIDY
MCI
Programmer/Analyst
•	Analyzed, designed, developed and implemented numerous enhancements to several processes, extracting and transforming additional data elements from numerous ADABASE and DB2 data sources, supporting the requirements of expanding business practices.
•	Monitored, maintained and modified, as business rules dictated, dozens of daily, weekly and monthly mainframe job streams that support several downstream feeds to a UNIX and Sybase midrange processing platforms. Any ABENDs were analyzed for cause and appropriately modified to eliminate future occurrences.
•	Analyzed, designed and implemented major improvements to a front-end Enhanced Settlement (ENSET) edit program, to enhance the readability, functionality and maintainability of this very crucial program. Data inconsistencies were eliminated in this program by this code restructuring. Additional processing requirements were now easily added to meet the settlement business needs on an ongoing basis.
Business Intelligence
Masters
SetFocus
Management Information Systems
BBA
Pace University
https://www.linkedin.com/school/pace-university/
https://media-exp1.licdn.com/dms/image/C4D0BAQEcSw4qs9msJg/company-logo_100_100/0/1611584337807?e=1655942400&v=beta&t=tQ1vUEnho81tmlPrii9zZSyVPSKGsXalO3s0fXQKjhI
https://www.linkedin.com/in/jim-landreth-13b3b413
Jim Landreth
IT Serv Delivery Tech Sr at Ent Federal Credit Union
Colorado Springs, CO
https://www.linkedin.com/in/damaris-monreal-21606219a
Damaris Monreal
Service Center Manager at Ent Credit Union
Denver, CO
https://www.linkedin.com/in/jessie-richardson
Jessie Richardson
EntRANCE Program Trainee at Ent Credit Union
Greater Colorado Springs Area
https://www.linkedin.com/in/charlsie-eijlers-ab4b1598
Charlsie Eijlers
Cherwell Tool Owner/Admin/Developer at Ent Credit Union
United States
https://www.linkedin.com/in/caleb-henney
Caleb Henney
Automation Team Lead at Redwood Credit Union
Napa, CA
https://www.linkedin.com/in/candi-king-072300a1
Candi King
Manager at Ent Credit Union
United States
https://www.linkedin.com/in/robynhandycpa
Robyn Handy, CPA
Controller at Ent Credit Union
Colorado Springs, CO
https://www.linkedin.com/in/mike-grady-cude-b93ba88
Mike Grady, CUDE
Regional Director of Center Operations at Ent Credit Union
Colorado Springs, CO
https://www.linkedin.com/in/jerdavisco
Jeremy Davis
Manager, Business Banking at Ent Credit Union
Greater Colorado Springs Area
https://www.linkedin.com/in/ginger-lamphere-crpc%C2%AE-8481709
Ginger Lamphere, CRPC®
Senior Investment Representative, CUSO Financial Services, L.P.
Peyton, CO
https://www.linkedin.com/in/tom-trujillo-a830a1a
Tom Trujillo
Software Quality Assurance Test Specialist at Ent Credit Union
Colorado Springs, CO
https://www.linkedin.com/in/lamar-johnson-97938213
Lamar Johnson
Service Area Manager at Ent Credit Union
Colorado Springs, CO
https://www.linkedin.com/in/harold-callabrass-489676169
Harold Callabrass
Member Success Representative at Ent Credit Union
Greater Colorado Springs Area
https://www.linkedin.com/in/jeff-wilkins-7a70a01
Jeff Wilkins
VP of Strategic Initiatives at Ent Credit Union
Monument, CO
https://www.linkedin.com/in/bboyle37922
Bob Boyle
Sr Data Architect
Knoxville, TN
https://www.linkedin.com/in/brianmorris
Brian Morris
Architect and Builder of Cloud Data Platforms supporting Data Science, Advanced Analytics, and Data Warehousing. Experienced with Python, Spark, Pyspark, AWS, Azure, Hive, Impala, CDP, CDH, Data Engineering and Analytics
Oklahoma City Metropolitan Area
https://www.linkedin.com/in/sujay-pawar-549476a4
Sujay Pawar
Data analytics
New York City Metropolitan Area
https://www.linkedin.com/in/ritika-singh-793a6416
Ritika Singh
Data Analyst
Greater Boston
https://www.linkedin.com/in/klsrao
Lakshmi Korrapati
Available
Iselin, NJ
Robert Witkowski
      
          



            
              
        
              
  

    
        To Whom It May Concern:

It is my pleasure to provide a recommendation for Al Ottley. Graduating from the SetFocus Master’s Program, he excelled in our intense, integrated, in-depth, full time MS Business Intelligence Training Program.  

I was impressed by his ability to work with many technologies during his time with SetFocus. He has gained experience with the latest Microsoft BI Technologies, including but not limited to:

•	Microsoft SQL Server Integration Services (SSIS)
•	Microsoft SQL Server Analysis Services (SSAS)
•	Microsoft SQL Server Reporting (SSRS)
•	Microsoft Office SharePoint Server 2007

  
In addition, he has established competency with defining business requirements, designing the Business Process Model and developing, deploying, and managing a BI System.

I found his excellent work ethic was demonstrated by his ability to work in an environment with firm deadlines, very large workloads, and complex specifications.  He delivers projects in a time efficient manner, is flexible with specification changes and is able to work within teams on assigned projects.

I recommend Al Ottley as a solid addition to your Business Intelligence staff.  If you would like more information, I’d be happy to provide it.  

Sincerely,

 

Robert Witkowski
Dean of Students
rwitkowski@setfocus.com Brian Erlich
      
          



            
              
        
              
  

    
        Al has an excellent grasp of the Microsoft BI stack and an easy going personality, both of which earned him a spot as a team leader for the final project.  Al’s leadership and understanding of the Microsoft business intelligence tools allowed him to lead his team to one of the highest scores of his class.  I enjoyed working with him and would recommend him highly.  I believe that Al would be an asset to any company lucky enough to work with him.

The final project was a complete end to end business intelligence solution. The teams were provided two database files that represented survey data. They each created a SharePoint site that was used to both collaborate on the project and to display the results of their project work. The students then created an ETL process utilizing SQL Server Integration Services. The ETL process stripped out a minimum of 5 dimension tables and two fact tables from the original databases. A date dimension table was built by hand by each team. The data was cleaned and put into a data mart that was designed by Al’s team using Microsoft Visio. The teams next built a cube using SQL Server Analysis Services. The cube contained hand built hierarchies with attribute relationships and at least one named set. Once the cube was completed the teams were required to use MDX to report off of that cube, in several formats. Parameterized reports were created using SQL Server Reporting Services and Performance Point. The parameterized reports were presented on SharePoint in dashboards and as their constituent files. Shared data sources were configured as was a subscription, for one of the reports, which delivered the report daily into a folder on the SharePoint site.  This was a comprehensive project.  It covered all of the students learning and successful completion required that they discover a few additional tools and techniques on their own.
Always be grateful...
https://www.linkedin.com/signup/cold-join
Liked by Al Ottley
Photo
https://www.linkedin.com/signup/cold-join
Liked by Al Ottley
Turtle & Hughes celebrates its 95 years in business and frank Millard’s 50 years with the company - I dont know what he enjoyed more - the party or…
https://www.linkedin.com/signup/cold-join
Liked by Al Ottley
https://media-exp1.licdn.com/dms/image/C4D07AQH8xuyQcZ_tVg/group-logo_image-shrink_200x200/0/1631362675710?e=1647694800&v=beta&t=PU92XUbZL96q1MPC_IrfjaOxK48ROZZw-InwUIlF7kI
Colorado Springs SharePoint User Group
https://www.linkedin.com/groups/162434
https://media-exp1.licdn.com/dms/image/C4D07AQFlLQiTqxR7pg/group-logo_image-shrink_200x200/0/1631357017777?e=1647694800&v=beta&t=GieOYkcGyCqcPvXRRevm8Ss36v3ZbZpZSfohgp5bOFg
SetFocus MP Alumni and Hiring Companies
https://www.linkedin.com/groups/3553
https://media-exp1.licdn.com/dms/image/C5107AQEAdNsg0IqduQ/group-logo_image-shrink_200x200/0/1631421648710?e=1647694800&v=beta&t=jWRnxUnJbajXEN0NFvMWs33sPF2MpfoOOiwp2xQ2Gj0
SetFocus Free SharePoint Training
https://www.linkedin.com/groups/3977304
https://media-exp1.licdn.com/dms/image/C5607AQHBkQk8iq7xug/group-logo_image-shrink_200x200/0/1630998503592?e=1647694800&v=beta&t=jJP0FN7NgKrZUR7AR-MNnDrJpneZRJ-pxUkhFOkOYE0
SQL Jobs
https://www.linkedin.com/groups/1778334
https://media-exp1.licdn.com/dms/image/C4E07AQGf6NA6Nb0EQw/group-logo_image-shrink_92x92/0/1631006787035?e=1647694800&v=beta&t=VjZ3Ty00QOVIJSDXM-070j7x-MmL2tpXLUfA2nYBKk4
Denver SQL Server User Group
https://www.linkedin.com/groups/1789566
https://media-exp1.licdn.com/dms/image/C4E07AQFCQDGCWF1Wgw/group-logo_image-shrink_92x92/0/1521154560102?e=1647694800&v=beta&t=fWah4Wbl7C9MMJbmrp1B4SYjbp5o2uYfygFj7s_I5PI
Moving Careers Forward
https://www.linkedin.com/groups/1640
https://media-exp1.licdn.com/dms/image/C4D07AQHnswdJg9KXhw/group-logo_image-shrink_200x200/0/1631362128802?e=1647694800&v=beta&t=U7UB0MXRK0iCABh9SaIr9zdRS8yRnvVTyA7DA3X9dOQ
Data Warehouse & Business Intelligence Architects
https://www.linkedin.com/groups/108904
https://media-exp1.licdn.com/dms/image/C5107AQFOZwOAV7E6RA/group-logo_image-shrink_200x200/0/1631402989678?e=1647694800&v=beta&t=_QRcnzqLNZH-On13lE197wLfB3-h340jCgm4iNZRxnk
MSFT Business Intelligence Professionals
https://www.linkedin.com/groups/60555
https://media-exp1.licdn.com/dms/image/C4D07AQGcI_kGWq-vDw/group-logo_image-shrink_92x92/0/1521155565344?e=1647694800&v=beta&t=N9eg4HcMjpVysyW2SPQHvdpw9RwQ71QqqA3u0_WdjQU
Jobs In Colorado
https://www.linkedin.com/groups/41580
https://media-exp1.licdn.com/dms/image/C4D07AQEVnxA0Y0Vtpw/group-logo_image-shrink_92x92/0/1631006843780?e=1647694800&v=beta&t=7EYE5FrPHTeQUsc6aa5nCn1nG70GVc6WjMVnkZUMzuE
Global Programming, App Development and Coding Group
https://www.linkedin.com/groups/1881363
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
SQLServerCentral
https://www.linkedin.com/groups/72017
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
Microsoft Business Intelligence
https://www.linkedin.com/groups/59185
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
SharePoint Practitioners
https://www.linkedin.com/groups/38260
https://media-exp1.licdn.com/dms/image/C4D07AQHsy8PaEed0og/group-logo_image-shrink_200x200/0/1631373512165?e=1647694800&v=beta&t=cfZtzFEUnNXKGZcCH_DIy363EmzuuQKbyWHwNCikhQs
TDWI: Analytics and Data Management Discussion Group
https://www.linkedin.com/groups/45685