al ottley
Database Developer/Data Warehousing/Data Mining at Ent Federal Credit Union
database developer ent credit union
highly motivated business intelligence professional using sql server 2005/2008 related microsoft technology . experience manipulating various data source support senior management decision . demonstrated leadership ability team work skill well ability accomplish task minimal direction supervision . sql server 2005/2008 integration service ( ssis ) sql server 2005/2008 analysis service ( ssa ) sql server 2005/2008 reporting service ( ssrs ) microsoft office sharepoint server 2007 ( moss/sp ) microsoft performance point server ( pps ) sql server 2005/2008 office visio business intelligence development studio ( bid ) sql server management studio ( ssms ) t-sql mdx also experienced , insightful result oriented information technology professional many notable success related business marketing call traffic settlement initiative telecommunication business . extensive participation contribution development implementation specific client based solution , support various numerous business objective requirement . posse multitude hands-on experience various stage system development , including analysis , design , architecture , testing support . motivation guidance team member facilitate timely project completion consultation always enthusiastically provided . 've worked mainframe environment , midrange environment variety dbms back end , db2 , oracle , sybase , informix ms-sql server . always welcome opportunity knowledge education , solving problem meet design goal business requirement seeing project come fruition . specialty : recent , intensive extensive knowledge sql server 2005 2008 ( ssis , ssa , ssrs ) , mdx , t-sql , pps , sp , visio . mainframe based data transformation midrange processing ; extensive use mainframe tool , particularly endevor ca-7 ; perl ksh scripting writing handling database load unix/aix platform .
Ent Federal Credit Union
https://www.linkedin.com/company/entcreditunion
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
Database Developer/Data Warehousing/Data Mining
Colorado Springs Health Partners
https://www.linkedin.com/company/colorado-springs-health-partners
Colorado Springs, Colorado Area
https://media-exp1.licdn.com/dms/image/C560BAQEO9MODA7NZrg/company-logo_100_100/0/1519902759061?e=1655942400&v=beta&t=z5rL8V1JNVMmQhA4bjHngAL35zOVJXaIhwzS19zue0M
Business Analyst/Data Analyst/Reporting
HP
https://www.linkedin.com/company/hewlett-packard-enterprise
•	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
Consultant
SetFocus
https://www.linkedin.com/company/setfocus
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
Graduate-Business Intelligence Master's Program
Verizon Data Services
https://www.linkedin.com/company/verizon-data-services
•	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.
Support Analyst/Programmer-Analyst
Worldcom/MCI
https://www.linkedin.com/company/verizon
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
Analyst/Programmer
MCI
•	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.
Programmer/Analyst
Masters
Business Intelligence
SetFocus
BBA
Management Information Systems
https://media-exp1.licdn.com/dms/image/C4D0BAQEcSw4qs9msJg/company-logo_100_100/0/1611584337807?e=1655942400&v=beta&t=tQ1vUEnho81tmlPrii9zZSyVPSKGsXalO3s0fXQKjhI
Pace University
https://www.linkedin.com/school/pace-university/
https://www.linkedin.com/in/jim-landreth-13b3b413
Colorado Springs, CO
Jim Landreth
IT Serv Delivery Tech Sr at Ent Federal Credit Union
https://www.linkedin.com/in/damaris-monreal-21606219a
Denver, CO
Damaris Monreal
Service Center Manager at Ent Credit Union
https://www.linkedin.com/in/jessie-richardson
Greater Colorado Springs Area
Jessie Richardson
EntRANCE Program Trainee at Ent Credit Union
https://www.linkedin.com/in/charlsie-eijlers-ab4b1598
United States
Charlsie Eijlers
Cherwell Tool Owner/Admin/Developer at Ent Credit Union
https://www.linkedin.com/in/caleb-henney
Napa, CA
Caleb Henney
Automation Team Lead at Redwood Credit Union
https://www.linkedin.com/in/candi-king-072300a1
United States
Candi King
Manager at Ent Credit Union
https://www.linkedin.com/in/robynhandycpa
Colorado Springs, CO
Robyn Handy, CPA
Controller at Ent Credit Union
https://www.linkedin.com/in/mike-grady-cude-b93ba88
Colorado Springs, CO
Mike Grady, CUDE
Regional Director of Center Operations at Ent Credit Union
https://www.linkedin.com/in/jerdavisco
Greater Colorado Springs Area
Jeremy Davis
Manager, Business Banking at Ent Credit Union
https://www.linkedin.com/in/ginger-lamphere-crpc%C2%AE-8481709
Peyton, CO
Ginger Lamphere, CRPC®
Senior Investment Representative, CUSO Financial Services, L.P.
https://www.linkedin.com/in/tom-trujillo-a830a1a
Colorado Springs, CO
Tom Trujillo
Software Quality Assurance Test Specialist at Ent Credit Union
https://www.linkedin.com/in/lamar-johnson-97938213
Colorado Springs, CO
Lamar Johnson
Service Area Manager at Ent Credit Union
https://www.linkedin.com/in/harold-callabrass-489676169
Greater Colorado Springs Area
Harold Callabrass
Member Success Representative at Ent Credit Union
https://www.linkedin.com/in/jeff-wilkins-7a70a01
Monument, CO
Jeff Wilkins
VP of Strategic Initiatives at Ent Credit Union
https://www.linkedin.com/in/bboyle37922
Knoxville, TN
Bob Boyle
Sr Data Architect
https://www.linkedin.com/in/brianmorris
Oklahoma City Metropolitan Area
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
https://www.linkedin.com/in/sujay-pawar-549476a4
New York City Metropolitan Area
Sujay Pawar
Data analytics
https://www.linkedin.com/in/ritika-singh-793a6416
Greater Boston
Ritika Singh
Data Analyst
https://www.linkedin.com/in/klsrao
Iselin, NJ
Lakshmi Korrapati
Available
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.
Liked by Al Ottley
https://www.linkedin.com/signup/cold-join
Always be grateful...
Liked by Al Ottley
https://www.linkedin.com/signup/cold-join
Photo
Liked by Al Ottley
https://www.linkedin.com/signup/cold-join
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…
Colorado Springs SharePoint User Group
https://media-exp1.licdn.com/dms/image/C4D07AQH8xuyQcZ_tVg/group-logo_image-shrink_200x200/0/1631362675710?e=1647694800&v=beta&t=PU92XUbZL96q1MPC_IrfjaOxK48ROZZw-InwUIlF7kI
https://www.linkedin.com/groups/162434
SetFocus MP Alumni and Hiring Companies
https://media-exp1.licdn.com/dms/image/C4D07AQFlLQiTqxR7pg/group-logo_image-shrink_200x200/0/1631357017777?e=1647694800&v=beta&t=GieOYkcGyCqcPvXRRevm8Ss36v3ZbZpZSfohgp5bOFg
https://www.linkedin.com/groups/3553
SetFocus Free SharePoint Training
https://media-exp1.licdn.com/dms/image/C5107AQEAdNsg0IqduQ/group-logo_image-shrink_200x200/0/1631421648710?e=1647694800&v=beta&t=jWRnxUnJbajXEN0NFvMWs33sPF2MpfoOOiwp2xQ2Gj0
https://www.linkedin.com/groups/3977304
SQL Jobs
https://media-exp1.licdn.com/dms/image/C5607AQHBkQk8iq7xug/group-logo_image-shrink_200x200/0/1630998503592?e=1647694800&v=beta&t=jJP0FN7NgKrZUR7AR-MNnDrJpneZRJ-pxUkhFOkOYE0
https://www.linkedin.com/groups/1778334
Denver SQL Server User Group
https://media-exp1.licdn.com/dms/image/C4E07AQGf6NA6Nb0EQw/group-logo_image-shrink_92x92/0/1631006787035?e=1647694800&v=beta&t=VjZ3Ty00QOVIJSDXM-070j7x-MmL2tpXLUfA2nYBKk4
https://www.linkedin.com/groups/1789566
Moving Careers Forward
https://media-exp1.licdn.com/dms/image/C4E07AQFCQDGCWF1Wgw/group-logo_image-shrink_92x92/0/1521154560102?e=1647694800&v=beta&t=fWah4Wbl7C9MMJbmrp1B4SYjbp5o2uYfygFj7s_I5PI
https://www.linkedin.com/groups/1640
Data Warehouse & Business Intelligence Architects
https://media-exp1.licdn.com/dms/image/C4D07AQHnswdJg9KXhw/group-logo_image-shrink_200x200/0/1631362128802?e=1647694800&v=beta&t=U7UB0MXRK0iCABh9SaIr9zdRS8yRnvVTyA7DA3X9dOQ
https://www.linkedin.com/groups/108904
MSFT Business Intelligence Professionals
https://media-exp1.licdn.com/dms/image/C5107AQFOZwOAV7E6RA/group-logo_image-shrink_200x200/0/1631402989678?e=1647694800&v=beta&t=_QRcnzqLNZH-On13lE197wLfB3-h340jCgm4iNZRxnk
https://www.linkedin.com/groups/60555
Jobs In Colorado
https://media-exp1.licdn.com/dms/image/C4D07AQGcI_kGWq-vDw/group-logo_image-shrink_92x92/0/1521155565344?e=1647694800&v=beta&t=N9eg4HcMjpVysyW2SPQHvdpw9RwQ71QqqA3u0_WdjQU
https://www.linkedin.com/groups/41580
Global Programming, App Development and Coding Group
https://media-exp1.licdn.com/dms/image/C4D07AQEVnxA0Y0Vtpw/group-logo_image-shrink_92x92/0/1631006843780?e=1647694800&v=beta&t=7EYE5FrPHTeQUsc6aa5nCn1nG70GVc6WjMVnkZUMzuE
https://www.linkedin.com/groups/1881363
SQLServerCentral
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
https://www.linkedin.com/groups/72017
Microsoft Business Intelligence
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
https://www.linkedin.com/groups/59185
SharePoint Practitioners
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
https://www.linkedin.com/groups/38260
TDWI: Analytics and Data Management Discussion Group
https://media-exp1.licdn.com/dms/image/C4D07AQHsy8PaEed0og/group-logo_image-shrink_200x200/0/1631373512165?e=1647694800&v=beta&t=cfZtzFEUnNXKGZcCH_DIy363EmzuuQKbyWHwNCikhQs
https://www.linkedin.com/groups/45685