Brian Drackley

*** ***** ***** **. · Gilberts, Illinois 60136 · 630-***-**** · ac8t63@r.postjobfree.com

www.linkedin.com/in/brian-drackley-6bb305178

QUALIFICATIONS SUMMARY

Over twenty eight years of experience in a wide variety of roles in Information Technology. Extensive experience in all phases of software development life cycle including system analysis, design, development, testing, and installation. Energetic and enthusiastic team player with excellent communication, analytical, design, organizational and problem solving skills. Ability to work effectively in teams as well as individually.

28 years’ experience, including 13 years at senior level, on teams across a variety of applications and technology development and support teams.

Recognized in obtaining operational improvements across multiple application areas.

Successfully delivered of small to medium sized projects on time and within budget.

Excellent technical skills across multiple technologies including Microsoft SQL, T-SQL, & SSRS Reports, SSIS, Domo Reports, Oracle SQL & Reports, PL/SQL, SQL Loader, Teradata SQL, DataStage, both Micro-Focus COBOL and COBOL2 programming, and UNIX Korn Shell Scripting.

Experience in using Explain Plan and other tuning techniques for tuning SQL queries and PL/SQL programs.

Experience in Integration of data sources like Microsoft SQL Server & Access, Oracle 11g/10g/9i, Teradata into a staging area.

TECHNICAL EXPERIENCE

Packages: Lawson Financials and Human Resources (ERP), SmartStream Financials, Compass Annuity Life Insurance Planning (ERP), JDA/Manugistics Inventory Planning

Languages: SSRS Reports, SSIS, Domo Reports, Oracle SQL, SQL Loader, & Reports, PL/SQL, DataStage 7.2 & 6.3, UNIX Korn Shell Scripting, SAS, Micro-Focus COBOL, RM/COBOL, DB2/SQL, COBOL2, CICS, JCL

Databases: Microsoft SQL Server, Oracle 9x/10g/11g, Teradata, DB2, VSAM

Tools: Microsoft SQL Server Management Studio, Microsoft Visual Studio, Oracle SQL Developer, Oracle Forms/Reports, Teradata SQL Assistant, OEM, Ultra-Edit, Telnet, Putty, Toad, Vi Editor, Visual Basic, Control-M, Microsoft Office (Word, Excel, and Access), Visio, Clearcase, SPUFI, SNDM, RMDS, FTP/SFTP, TSO/Roscoe, TCP/IP, FileAid, Xpediter, Abend-Aid, Syncsort, Multiple IBM set of Utilities, Business Objects, PowerBuilder

OS: Microsoft, HP, IBM (AIX), and Linux UNIX, DOS, MVS/ESA, OS/2, Windows NT / XP / 10

PROFESSIONAL EXPERIENCE

Sears Holdings Corporation - Hoffman Estates, Illinois

Product Engineer / Data Analyst & SQL Server Developer / Domo Reporting 7/2017 – 12/2018

Responsible for building normalized SQL statements and collecting data to analyze in SSMS and/or pulling data through Domo workbench to analyze in Domo Reporting.

Developed reports using Domo Reports or in Microsoft Visual Studio for SSRS.

Created and/or enhanced reports like with the conversion of excel reports to Domo Reports.

Created normalized and managed views, store procedures, or server agent jobs in SSMS and debugged views and store procedures of others.

Superior time-management skills with ability to meet deadlines and have flexibility to reprioritize as necessary.

CEANNATE Corporation - Schaumburg, Illinois

Business Intelligence Analyst / SQL Server Developer 9/2014 – 5/2017

Responsible for building optimized SQL & transact-SQL (T-SQL) bases applications and for updating SQL code in SSMS.

Developed T-SQL to facilitate ETL process or in SSIS.

Implemented error handling within T-SQL.

Developed reports using Microsoft Visual Studio for SSRS or in Excel.

Created and/or enhanced reports like with the conversion of excel reports to SSRS, KPI’s and scorecards deliveries.

Documented all code and work.

CVS Caremark - Buffalo Grove, Illinois

Application Developer Consultant / Quantum (QL) Eligibility System 6/2013 – 7/2014

Worked with the business and technical team to define requirements and then developing the technical solution in COBOL2 and DB2/SQL all on an IBM mainframe.

Fulfilled business partner needs/requests with ad hoc query and project requests successfully on very tight deadlines.

Built working relationship with business partners and provided support of applications.

Retrieved and/or updated documents from SharePoint.

Sears Holdings Corporation - Hoffman Estates, Illinois

System Engineer / IDRP Group / Supply Chain Forecasting/Replenishment Inventory Planning 5/2007 – 8/2012

Worked with the business and technical team to define requirements and then develop, test, and maintain the technical solution in JDA/Manugistics Distribution Resource Planning application (ERP System), using Oracle SQL Reports / SQL / PL/SQL, Teradata SQL, UNIX Korn Shell Scripting, Micro-Focus COB OL programs, and/or DataStage 6.3 all on an IBM (AIX) UNIX OS.

Leading small to mid-sized projects with shared onshore and offshore consultants.

Built working relationship with business partners needs/requests and acting application SME in charge of Inventory Dashboard Reporting System. Also, provided technical support of application and ad hoc reports as the Reporting Specialist.

Modified existing or created new FE (Fixed Editor) screens for testing with Inventory Dashboard Reporting System and wrote detailed support procedures for cross training team members on support.

Rolled newly developed application out to additional businesses and ensured cross training of resources to provide consistent business support of applications.

HSBC, Mount Prospect, Illinois

Senior Business System Analyst / Retail Services Data Warehouse Information Technology 10/2004 – 5/2007

Worked with the business and technical team to define requirements and then developing the technical solution in DataStage 7.2 and Oracle SQL scripts / Reports to the Retail Services Data Warehouse.

Built working relationship with business partners.

Fulfill business partner needs/requests and project requests.

Coding and testing of new DataStage enhancements.

Researching and documenting business requirements

Leading small to mid-sized projects with shared onshore and offshore consultants.

Nightly Mainframe/Server production pager support.

Ensured cross training to provide consistent business support of applications.

Ownership of Retail Services application suite.

Interactive Business Systems, Oak Brook, Illinois

Senior COBOL/UNIX Consultant / Application Solutions 1/2004 – 9/2004

Responsible for modifying RM/COBOL source code to expand the length of data fields for a client.

Designed, wrote, unit tested, and documented new RM/COBOL programs for a client for a one-time conversion of primary data files.

Remotely debugged and clean-compiling the RM/COBOL source code via a VPN connection for a client.

Built & fulfilled working relationship with business client partner needs/requests and project requests.

Pechiney Services America, Chicago, Illinois

Senior Lawson Consultant / Lawson Human Resource Applications 1/2003 – 11/2003

Responsible for upgrading their 7.2 Lawson Human Resource Applications (ERP System) to the new 8.0 Lawson version.

Redeveloped, tested, and implemented in-house Micro-Focus COBOL programs and Oracle SQL scripts to work with the new 8.0 Lawson version.

Provided end user support and consultation in the use of the system which included Oracle SQL Reporting capabilities and day-to-day operations as the Reporting Specialist.

Insured that the daily, weekly, and monthly processing schedules were completed successfully.

Applied new Corrective Address software to their database.

EDUCATION

1989 – Bachelors of Science, Major in Computer Management

Eastern Illinois University, Charleston, Illinois

Contact this candidate