Ssrs Report Developer Resume
TECHNICAL SKILLS:
Development: Creating and maintaining Oracle PL/SQL Packages for ETL extraction of data from one Oracle database to another; Creating and maintaining triggers for table level auditing; Creating and maintaining Oracle SQL queries for QA reporting of data quality; Creating and maintaining Microsoft VB Programs to improve manual processes
Database Systems: Oracle 10g, 11g, 12c, Oracle 9i, MS Access
Language & Software Knowledge: Toad for Oracle, stored procedures, functions, triggers, Excel VBA Programming, MS Access, Oracle SQL & PL/SQL, C# .NET, XML, HTML5, CSS3, JavaScript, jQuery, SSRS Reporting, PL/SQL Server Pages(PSP’s)
EMPLOYMENT HISTORY:
Confidential
SSRS Report Developer
Responsibilities:
- Create, implement and maintain a reporting suite of standard reports while also customizing many reports to meet individual user needs.
- Creating filtered, sub reports and other specialized reports to meet user needs
- Assist in deploying reports to report server, and managing reports within the Team Foundation Server (TFS)
- Assist in maintaining court PL/SQL Server Pages, used for Performance and Accountability Reporting
Confidential
Data Analyst (Environmental Specialist)
Responsibilities:
- Assist in maintaining three Oracle Enterprise Databases, working directly with Oracle Data Administrators and other IT staff.
- Provide ad hoc query reports to members of public and internal agency staff.
- Maintains quality assurance program by writing report queries (Oracle) which is the primary QA Program for the Confidential Database
- Created database mapping for Migration of Confidential data to the Environmental Protection Agency via XML format.
- Assist in the maintenance of PL/SQL code, which extracts and loads Confidential data for submission to EPA.
- Modified data quality program to check and ensure data meets EPA data quality standards before extracting and loading data to submit to EPA
- Created triggers for table level auditing, to assist with the tracking of changes to dynamic tables in database
- Wrote DML queries to correct erroneous data in database to meet agency data quality standards
- Support fellow subsection staff by writing Microsoft Applications that automate day - to-day manual processes.
- Maintain Application program written in Visual Basic 6 code in support of data quality program.
- Written Excel Macro programs to format/transform organization data into a format that will load into Confidential Enterprise database.
- Modified code in VB6 program to support checking staging area for data errors before data is pushed from staging to production
- Generated database mapping for 130 plus table scheme to a smaller approximately 60-table scheme.
Confidential
Cyber Security Analyst
Responsibilities:
- Taught classes to other Confidential employees and general public on how to stay safe online.
- Analyzed and responded to all cyber security issues and exploits
- Performed fact-finding research to determine emerging threats’, likelihood of use, and potential for harm
- Distributed key information and alerts to Florida citizens and businesses through the Secure Florida notification system.
- Updated content and assisted in the administration of the Confidential website.
- Remained aware of all cyber security issues and served as a point of contact for analysis and notification
