Adam Buchanan
Summary
Professional Business Intelligence Admin/Developer/Analyst with broad experience in several data warehousing environments. Attained "Secret" level governmental clearance in 2014. Developed BI framework including an aggregate of database design, ETL development, and report building. Knowledgeable of many diverse programming languages, with a focus on ETL development, database engineering, Agile software development, usability engineering, and report design. Served as a Data Warehouse admin and lead production support of a worldwide security company. Adept at performing complete software life cycle. Successfully managed and led an entire company's Business Intelligence / Data Warehousing department. This both tested and strengthened knowledge gained through previous work engagements, and solidified not only the key tenets of BI, but the wide variety of additional complexities that arise over the entirety of delivering useful Business Intelligence Solutions.
Overview
15
15
years of professional experience
Work History
Data Warehouse Administrator / Lead Data Analyst
JOHNSON CONTROLS
04.2016 - Current
- Served as Administrator of multiple Data Warehousing environments including Informatica instances, Business Objects implementations, and AIX Unix boxes
- Responsible for upholding business SLA by monitoring all data warehouse processes for successful execution on a daily basis
- Performed full scope analyses of production issues by conducting business research, reverse engineering code, and safely implementing solutions
- Became lead Mapping and Data Transformation Developer using Informatica 9.5.1, 9.6.1, and 10.2 which included Technical Design, Data modeling, and Process optimization
- Used Oracle SQL to optimize existing queries to create efficient new ones
- Included tertiary usage of PL/SQL, DB2, SQL Server, Teradata, SSIS, etc
- Solved an entire business unit's worth of issues including Informatica failures, UNIX script issues, missing report data, network problems, code logic gaps, or business requirement changes
- Provided general support in all development life cycle activities including scoping, data modeling, analysis, documentation, impact analysis, development, testing, UAT, deployment, scheduling, researching, auditing, releases, IT support, business teaching, and technical design.
Lead Informatica / OBIEE ETL Developer
CROSS COUNTRY HOME SERVICES
12.2014 - 04.2016
- Delivered new Data to business by creating new Data Warehouse dimensions and OBIEE Reports.
- Responsible for Documenting, Requirements Gathering, Modeling, and Development of all associated Informatica ETL Mappings and OBIEE Reports.
- Developed Mappings in Informatica 9.1 using Mapping Designer, Workflow Manager, Workflow Monitor, Oracle Data Warehouse Administration Console (DAC), OBIEE RPD, etc.
- Migrated many existing reports and dashboards to new Business Intelligence Data Warehouse in OBIEE reporting environment.
- Optimized existing Data Warehouse processes by reconfiguring queries, leveraging Informatica lookup caches, and refactoring mappings.
- Ensured reports were properly understood and accepted by working in Scrum/Kanban (Scrumban) development style closely with department heads and their sales representatives
- Strengthened knowledge of Oracle BI platforms by attending training as well as enacting skills by developing reports and dashboards.
- Refreshed skills with Pentaho by using it as secondary ETL tool.
ETL Developer, Contractor
TYCO INTEGRATED SECURITY
03.2014 - 09.2014
- Worked as Data Auditor and ETL Developer for Tyco Integrated Security’s Company wide data migration project.
- Attained governmental Security Clearance: “Secret” level in order to view secured data
- Responsible for migrating Informatica ETL processes and complex UNIX scripts and their associated objects to new environments.
- Audited and confirmed data quality in several environments by querying Oracle Databases in Toad for Oracle.
- Created, modified, and optimized UNIX scripts using VIM, which included many styles of ETL including DB Links, Views, Synonyms, PL/SQL, Stored Procedures, and Packages.
- Received Business Objects training and subsequently reviewed, tested, and executed BO reports sourced from migrated scripts using BI Launchpad.
- Tested entire life cycle of migrated code, from UNIX scripts through produced reports in Business Objects
Data Architect, Contractor
JM FAMILY ENTERPRISES, INC
05.2013 - 02.2014
- Responsible for project processes between business user's requests and architectural ETL development which included data analysis, requirements gathering, documenting, project planning and scheduling, meeting organizing and cross-business communication, technical assessment, SQL optimization, and ad-hoc report generation.
- Recorded business requirements and translated them into many project requirements by analyzing data, documenting information, and facilitating communication between several departments.
- Queried Oracle and Teradata databases to perform analysis associated with finalizing project requirements.
- Optimized existing processes by modifying existing SQL queries during analysis phase.
- Ensured that some very highly valued company members were presented with proper data/reports at project end by playing key role in communications with focus on cross team understanding and visibility.
- Handled support tickets by managing communications and time allowing time to work on extra support tickets without stopping main project flow.
Data Warehouse Developer / Analyst
2CHECKOUT.COM
12.2011 - 05.2013
- Lead Business Intelligence team and executed business' reporting needs by modeling data into data warehouse using Pentaho to create ETL
- Built reports from that warehouse and troubleshot users problems using simple ad hoc reporting environment set up for the business.
- Encompassed full software development life cycle including requirements gathering, business case analysis, data and schema modeling, ETL development, report writing, metadata translation, and end user adoption and understanding.
- Every piece of software pipeline was delivered, understood, enacted, and implemented solely myself for over a year.
Informatica ETL Developer
ABBOTT LABORATORIES
04.2011 - 11.2011
- Completed project that modified an important piece of code which reflected a change in source data and a database structure change.
- Worked in health field in an careful environment regarding information security
- Exemplified Data Modeling techniques while defining project requirements
- Confirmed and refined project scopes by researching project data
- Performed large scale Data Impact Analysis on central table structure changes
- Developed precise test cases and test protocol plans
- Created visual and written project documentation including Technical Specification Docs, Design Docs, Test Docs, and Run Docs with an emphasis on ease of conceptual understanding
- Developed mappings using expressions, joiners, filters, aggregators, lookups, routers, unions, sequence generators, update strategies, sorters, etc.
- Modified workflows that used several tasks including email, event wait, command, etc.
- Documented all changes for easy maintenance and reference
- Worked with versioning in Informatica
- Utilized UNIX systems to work with flat files, stored procedures, and scripts
- Migrated code from Informatica 8.6 to 9.1
- Extensively queried Oracle 10g and Teradata
- Converted database usage from Oracle to Teradata.
DataStage ETL Developer Consultant
HUNTINGTON NATIONAL BANK
03.2011 - 04.2011
- Completed contracted ETL project for Huntington National Bank using DataStage
- Analyzed project templates to identify program logic
- Utilized source to target job rule documents along with program logic to develop jobs
- Used ODBC connectors to associate database tables with DataStage
- Developed jobs using Aggregators, Transformers, Filters, Funnels, Joins, Merges, Lookups, Copies, Modifies, Remove Duplicates, Sorts, Sequential Files, Data Sets, Row Generators, Peeks, ODBC Connectors, etc.
- Unit tested each job at every stage and level of ETL
- Debugged jobs using DataStage director error logs Worked with SQL Server to query tables
- Created test cases and scripts for each job Used UNIX systems to work with sequential files and data sets
Informatica ETL Developer
NATIONWIDE INSURANCE
06.2010 - 03.2011
- Completed several ETL projects for Nationwide Insurance using Informatica
- Developed ETL mappings and workflows for the Nationwide CIM
- Agile Test Driven Development approach using technical specs and test cases
- Developed mappings using expressions, joiners, filters, aggregators, lookups, routers, unions, sequence generators, update strategies, sorters, etc.
- Developed workflows using several tasks including email, command, decision, control
- Created Netezza tables in test environment to hold data
- Utilized Netezza power connect to increase performance using Pushdown Optimization
- Gained DB2 knowledge from using DB2 connect. Performed Unit testing on mapping and workflows at various levels of ETL
- Queried databases using SQL for data analysis and validation
- Executed test cases and recorded results
- Provided test environment support to resolve defects found by QA
- Debugged mappings by utilizing session logs and Informatica Debugger
- Created mapplets for recursive code Used Database sources, Flat Files, XML, Cobol file sources
- Implemented shell scripts to automate mainframe file uploads
Education
Associate of Science - Computer Science
Bowling Green State University
Bowling Green, OH2008
Skills
- ETL Tools: Informatica 95x, 96x, 102x, DataStage, Pentaho Data Integrator
- SQL languages: Oracle (Toad), PL/SQL, MySQL, Sql Server, Teradata, DB2, ODBC, Netezza
- Scripting Languages: UNIX, AIX, Linux, Lua, XML, Shell
- Reporting Tools: OBIEE, Business Objects
- Development Styles: DevOps, Agile, Agile, Scrum, Sprint, TDD, Waterfall
- Main Roles: Production Support, ETL Development, Data Modeling & Analysis
- General Business Intelligence and Data Warehousing Skills: Data Modeling, Requirements Gathering, Monitoring, Optimization Automation, Project Planning, Data Analysis and Validation, Quality Assurance, Code Migrations, Report Writing, Documentation
Timeline
Data Warehouse Administrator / Lead Data Analyst
JOHNSON CONTROLS
04.2016 - Current
Lead Informatica / OBIEE ETL Developer
CROSS COUNTRY HOME SERVICES
12.2014 - 04.2016
ETL Developer, Contractor
TYCO INTEGRATED SECURITY
03.2014 - 09.2014
Data Architect, Contractor
JM FAMILY ENTERPRISES, INC
05.2013 - 02.2014
Data Warehouse Developer / Analyst
2CHECKOUT.COM
12.2011 - 05.2013
Informatica ETL Developer
ABBOTT LABORATORIES
04.2011 - 11.2011
DataStage ETL Developer Consultant
HUNTINGTON NATIONAL BANK
03.2011 - 04.2011
Informatica ETL Developer
NATIONWIDE INSURANCE
06.2010 - 03.2011
Associate of Science - Computer Science
Bowling Green State University
Similar Profiles
Noah MillsNoah Mills
Machine Operator at JOHNSON CONTROLS INC, Johnson ControlsMachine Operator at JOHNSON CONTROLS INC, Johnson Controls
Donald JaworskiDonald Jaworski
Fire Sprinkler Service Manager at JOHNSON CONTROLS INC, Johnson ControlsFire Sprinkler Service Manager at JOHNSON CONTROLS INC, Johnson Controls
Cheryl DannerCheryl Danner
Customer Care Representative at JOHNSON CONTROLS INC, Johnson ControlsCustomer Care Representative at JOHNSON CONTROLS INC, Johnson Controls
ISIDRO (SID) RIOS IIIISIDRO (SID) RIOS III
AE/ Application Specialists at JOHNSON CONTROLS INC, Johnson ControlsAE/ Application Specialists at JOHNSON CONTROLS INC, Johnson Controls
Jonathon NanceJonathon Nance
Senior Data Analyst /Lead Data Analyst at Two Kings CasinoSenior Data Analyst /Lead Data Analyst at Two Kings Casino