SUMMARY

A creative, committed and experienced self - starter who has worked as a Business Intelligence Analyst, SQL developer/DBA, programmer analyst and business intelligence analyst on multiple platforms

TECHNICAL SKILLS

Reports Development: SSRS, SSIS, T-SQL, Report Builder 3.0, TOAD, COGNOS 7.6 Impromptu, Oracle Reports 2.5-6i, SSMS

RDBMS: SQL Server 2016, 2012, 2008, 2005 & 2000, Oracle 8i/7.x, DB2

Platforms SUN Solaris, HP-UNIX, Mainframe, Windows:

Software: ARCU, BSO, AlertNow, Eduphoria, Kronos, Oracle Applications (AP, GL, PO, FA), SunGard eFinancePlus & eSchoolPlus, TFS

Languages: T-SQL, SQL Plus, PL/SQL

Development Tools: WORD, EXCEL, ACCESS, Enterprise Manager, Query Analyzer, Joomla

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer

For Confidential, using SQL Server 2008, & 2012 & 2016 in a Data Warehouse environment to develop reports using Report Builder, and SSIS packages per specifications to meet business unit requirements. Confirmed successful completion of daily jobs and when necessary applied updates to confidential when certain category kick outs would occur (the next daily run would update the database). Assist in confidential software version upgrades every year by developing and successfully executing test plans. Currently studying to prepare for confidential certification.

Environment: Reports Development: SSRS/SSIS (Report Builder 3.0)

RDBMS: SQL Server 2008, 2012 & 2016

Platforms Windows 7 Enterprise

Software: Advanced Reporting for Credit Unions (ARCU)

Languages: T-SQL, SQL

Development Tools: SSMS, WORD, EXCEL

Confidential

Applications Development Programmer Analyst

Responsibilities:

For Confidential, using SQL Server 2008 SSRS developer working as a member of the Collections Initiative team, my first project was to convert 8 manual MS excel macro-driven reports that read from Oracle tables to fully automated confidential reports. Used openquery to populate data from Oracle database tables into SQL Server database tables. Team was responsible for not only gathering requirements, but for developing reports and/or packages, building/scheduling the job(s), and production support as well. Developed a training summary report that shaved several hours off of an employee’s weekly duties.

Environment: Reports Development: SSRS/SSIS 2008

RDBMS: SQL Server 2008

Platforms Windows 2008

Software: TFS (Team Foundation Server)

Languages: T-SQL, SQL

Development Tools: WORD, EXCEL, ACCESS, Enterprise Manager, Query Analyzer, SSMS

Confidential

SQL Server Developer

• For the Confidential, SQL Server 2005 confidential developer working as a member of a team supporting the city’s financial systems.
• I developed 6 reports from scratch, 6-8 where additional functionality was added.
• Added prompts so that an entire report would not execute each time it was selected.
• Built several SSIS packages from scratch, tested them, then scheduled them to run on a production server.
• Developed a drill down report that would roll up all purchases for a given fiscal month within a given fiscal year for city credit card vendors.
• Developed 2 SSRS matrix reports for the capital improvements team that required data from an enormous view. When the query to retrieve the data was executed from within the report, the report timed out, so I built a table from the original query that read the large view and used the table as input for the report greatly improving response time. Both of these reports were generated from Access databases requiring a great deal of my boss’s time before I was tasked with converting them to SSRS.

Environment: Reports Development: SSRS 2005, SSIS 2005, DTS 2008-2000

RDBMS: SQL Server 2008, 2005 & 2000

Platforms Windows 2008

Software: BSO (Buyspeed Online - City’s Purchasing system)

Languages: T-SQL, SQL

Development Tools: WORD, EXCEL, ACCESS, Enterprise Manager, Query Analyzer, SSMS

Confidential

Programmer Analyst

• As an application/DBA support analyst, I built data file extracts according to vendor specifications.
• Built maintenance plans and several DTS package jobs for version 2000 and 2008, database functions, backup & restore databases, database monitoring, and job scheduling using SQL Server version 2008, 2005, and 2000.
• Developed confidential Impromptu reports for departments as well as for district usage. District website support for the past three years. Primary application support, report developer for student and finance systems, parent notification, and eduphoria. I was also the primary confidential support for about 3 years, monitoring the many clocks throughout the district, applying remote reboots when necessary, and replacing clocks as needed.

Environment: Reports Development: DTS 2008-2000, COGNOS 7.6 Impromptu

RDBMS: SQL Server 2008, 2005 & 2000

Platforms Windows 2008

Software: SunGard eSchoolPlus & eFinancePlus, AlertNow, Eduphoria, Kronos

Languages: T-SQL, SQL

Development Tools: WORD, EXCEL, ACCESS, Enterprise Manager, Query Analyzer, Joomla (Web development)

Confidential

Programmer Analyst

Design and code programs using COBOL, Easytrieve, and build accompanying JCL Procs based on program specifications. Also built and loaded Oracle tables using SQLLDR on SUN Solaris.

Environment: Reports Development: COBOL, Easytrieve Plus

RDBMS: Oracle 8i

Platforms SUN Solaris, Mainframe

Software: TSO, ISPF/PDF

Languages: COBOL, JCL, Easytrieve Plus, SQL Plus

Development Tools: WORD, EXCEL, SQLLDR

Confidential

HRIS Analyst

Support Analyst for the HR/Payroll system confidential and its’ reporting solution, Impromptu. Responsible for supplying data files to vendor for AAP reporting, and extracting data for confidential reporting. Built data file from confidential to serve as input for orgchart building software, Org Publisher. Assisted in a major project to convert employee numbers from nine to five digits. Also assisted in a software/hardware upgrade of confidential Impromptu.

Environment: Reports Development: COGNOS 7.3 Impromptu

RDBMS: Oracle 8i

Platforms SUN Solaris

Software: CYBORG

Languages: English Language, SQL Plus

Development Tools: TOAD, WORD, EXCEL, ACCESS

Confidential

Senior Consultant

For a major jewelry retail corporation, assisted in a conversion project from a legacy mainframe Accounts Payable system over to Oracle Payables running on a HP-UNIX platform. Wrote interfaces to build flat files for downloading to UNIX, and templates for mapping flat files to Oracle tables using a tool called SmartDB. Primary on-call support for the Oracle Payables, Purchasing, and Fixed Assets applications from August 1998 to August 2000. Responsible for writing new and maintaining existing nightly cycle shell scripts, SQL scripts, and Oracle reports. Converted reports written in SAS to DYL280. Traveled for two months to and from Chicago on assignment. Also worked as an Oracle DBA at CGE&Y’s Project Development Center as a member of the infrastructure team. Built and tuned small scale databases for project teams on SUN Unix and Windows platforms, and performed data imports and exports as well.

Environment: Reports Development: COBOL, DYL280, Oracle Reports 2.5-6iRDBMS: Oracle 8i/7.x

Platforms HP-UNIX, Mainframe

Software: Oracle Applications (AP, GL, PO, FA)

Languages: COBOL, SQL Plus, PL/SQL

Development Tools: WORD, EXCEL