DATABASE DEVELOPER Resume

SUMMARY

I am a zealous and innovative database professional looking for opportunities to apply my technical and analytical skills in a challenging career.
Experience working as a database analyst/developer
Strong understanding and professional expertise in Oracle, MySQL, SQL Server databases and SQL/PLSQL/TSQL
Experience in BI tools like OBIEE, Discoverer, APEX, Tableau and MS Office tools - Excel for VLOOKUPS, Pivot, formulae, formatting etc
Excellent knowledge and experience of Python, bash scripting and Experience working with issue assignment and automation in JIRA
Strong understanding and professional expertise in HTML5, CSS3, Bootstrap, Javascript
Experience in Client interaction, excellent leadership, strong domain knowledgeanalytical reasoning, team player and business analysis and project management skills.
Well - versed in Data Warehousing concepts and analytical schemas Star, Snowflake, Constellation
Experience working with Business Analysis/ Project Management tools like TopTeam to manage requirements, tasks, issues, data modelling and other attributes of the Project

TECHNICAL SKILLS

Office Tools: MS Word, MS Excel, MS Powerpoint, MS Access, MS Outlook, MS Visio

Process/Modelling: MS Visio, TopTeam

Operating Systems: Windows, Linus, Unix

Languages: PL/SQL, SQL, TSQL, R, XML, HTML, Python, JSON

Databases: Oracle SQL,SQL server

Other Tools: Drupal, Emacs, Microsoft Access, OBIEE, Discoverer, Forms, TOAD, SQL developer, DB Visualizer, Cygwin, Putty, Eclipse, APEX, JIRA

PROFESSIONAL EXPERIENCE

DATABASE DEVELOPER

Confidential

Responsibilities:

Creating reports in Discoverer and migrating to OBIEE and Tableau
Extensively performed analytics and built repository objects in OBIEE
Supporting and automating issue assignment in JIRA
Extensively used Python with a combination of JSON to create and assign Individual and bulk issues in JIRA
Analyzed Tableau as a good replacement tool to Discoverer for visualization
Supporting industry data investigation by developing procedures, functions, tables and other Oracle database objects
Writing SQL queries and PLSQL to analyze fishery data
Gain an understanding of NOAA Fisheries from a business perspective
Analyze requirements using ERD and document them on Topteam
Built Oracle Forms and trained in creating applications in Oracle APEX

Environment: Oracle SQL, PLSQL, Discoverer, OBIEE, APEX, TopTeam, JIRA, Tableau

DATABASE DEVELOPER

Confidential

Responsibilities:

Creating reports in OBIEE Publisher and Tableau
Supporting fishery management plans by developing procedures, functions, tables and other Oracle database objects
Writing SQL queries and PLSQL to analyze fishery data
Built Oracle Forms and trained in creating applications in Oracle APEX

Environment: Oracle SQL, PLSQL, Discoverer, OBIEE, Tableau

DATABASE SOLUTIONS ENGINEER

Confidential

Responsibilities:

Development and Maintenance of Sql server and Oracle databases using SQL,TSQL and PLSQL
Writing code in perl and bash to pull files from SFTP server to our systems
Migration of legacy systems
Supporting marketing software UNICA and triggering campaigns
Uploading and downloading files from Portal and footprints SQL server DBs
Gain an understanding of Marketing from a business perspective
Responsible for initiation, testing and implementation of the client needs and ensure smooth functioning of the systems

Environment: Sql server, SSIS, TSQL, MS Excel, ETL, UNICA, Visio, Perl, Linux, Bash

GRADUATE ASSISTANT

Confidential

Responsibilities: