We provide IT Staff Augmentation Services!

Bi Developer / Atlassian Suite Admin Resume

SUMMARY:

Seeking Business Intelligence position in a firm that will allow me to apply proven programming business strategies. Implement and improve established procedures through knowledge gained from both my degrees and experiences. Focus on increased productivity and efficiency.

WORK EXPERIENCE:

BI Developer / Atlassian Suite Admin

Confidential

Responsibilities:

  • Maintained an external Oracle AWS DataMart that used Oracle scripts and a SSIS package to load the databases in an AWS server instance.
  • Developed PL/SQL scripts that ran nightly to generate reports developed via the companies Hyperion WorkSpace.
  • Developed BI financial reports that used both SQL and PL/SQL for Hyperion WorkSpace, SSRS, Crystal Reports and Jasper Soft including scheduled SSIS packages.
  • Troubleshooted issues with existing ETL packages, updated error handling on SSIS packages.
  • Jira administrator for Cloud instances - met with Project stakeholders to create projects within Jira, Confluence, and BitBucket.
  • Determined the ideal project type for the stakeholders (Classic vs Next - gen).
  • With existing Project, I met with project Stakeholders and gave the Project Admins more control to manage their project by simplifying the workflow and creating a scalable solution for the PMO team.
  • Created customized issue types and associated the issue type with customized workflow schemes, updated Permission schemes to restrict access on which team members can create issues, Updated Screens and Screen Schemes according to the PMO department.
  • Troubleshooted boards and optimized board display with secondary filters using JQL.
  • Completed a migration from both cloud to server and server to cloud of importing projects, portfolio roadmaps, issues and workflows from both instances.
  • Implemented SSO authentication with Auto provisioning for applications Jira, Confluence, and Slack on the cloud instance.
  • Modified screen Transition Issues Permissions to control which team members would transition issues.
  • Modify Jira access to use SSO authentication with Auto provisioning.
  • Slack Administration adding new channels and workspace.
  • BitBucket Administration controlling access to Repos of outside non-domain users via SSO groups.
  • Also used Postman to connect to Jira to both update and insert new issues.
  • Completed Workfront PPM Administration tasks using Postman and Kick start and created adhoc reports with custom fields.

Senior Clarity Support Engineer

Confidential

Responsibilities:

  • Senior Clarity Support Engineer for two hybrid instances of Clarity PPM version 15.4 integrated with Jira/Confluence, involving both troubleshooting issues with Jira and the PPM application with an average monthly closing of 9 million dollars and the use of Open Work Bench, the scheduling tool integrated.
  • The maintenance of the application involves adding lookups, Dynamic NSQL and new attributes to the application and maintaining and updating workflow processes.
  • Configuration of portlets to meet the business reporting needs.
  • I have assisted in the upgrade process and testing of Clarity version 13.1 to version 14.2. I also act as a liaison with the CA Clarity team in troubleshooting issues.
  • Trouble shooting issues related to WIP, timesheet postings and Charge Code related issues.
  • Created new reporting time periods and charge codes, also resolving end of month issues with WIP and Timesheet postings.
  • Maintained an external Oracle AWS DataMart that used Oracle scripts and a SSIS package to load the databases in an AWS server instance.
  • Developed PL/SQL scripts that ran nightly to generate reports developed via the companies Hyperion WorkSpace.
  • Developed BI financial reports that used both SQL and PL/SQL for Hyperion WorkSpace, SSRS, Crystal Reports and Jasper Soft including scheduled SSIS packages.
  • Troubleshooted issues with existing ETL packages, updated error handling on SSIS packages.
  • Converted Crystal Reports to JasperSoft platform. Created change management request for changes for DataMart scripts and the application.
  • Converted Microsoft SQL views and stored procedures to Oracle PL/SQL views and stored procedures.
  • Currently in the process of migrating from Clarity PPM version 14.2 to version 15.4.

SSIS / SSRS Developer

Confidential

Responsibilities:

  • Developing BI reports using dynamic T-SQL for SSRS.
  • Developing SSIS packages for export to external business clients.
  • Wrote ad hoc reports as needed by management.
  • Created stored procedures for both SSIS packages and SSRS scheduled reports.
  • Created schedule using SSRS and SharePoint Server.
  • Developing BI reports using T-SQL and MDX for SSRS.
  • Converting Crystal Report to SSRS reports.
  • Developing SSIS packages for flat files, Oracle, Eloquence and MySQL databases to update insert and delete files in SQL server.
  • Developing SSAS new cubes and also maintaining existing cubes. Create ad hoc SQL queries, performing DTS service to update and add new information to Financial System.
  • Write ad hoc reports as needed by management. Implementing software updates to Financial system and acting as a liaison with closed source software developers implementing upgrades requested by management.
  • Implementing security roles and permissions for SQL server Data Warehouse.

Support Engineer December

Confidential

Responsibilities:

  • Developing BI reports using both SSRS and Crystal Report.
  • Depolying both SSRS and Crystal Reports using VB.Net and C# web applications both for internal and external use.
  • Converting Crystal Report to SSRS reports.
  • Developing SSIS packages for flat files and Microsoft SharePoint to update insert and delete files in SQL and SharePoint server.
  • Create ad hoc SQL queries, performing DTS service to update and add new information to Legal System.
  • Write ad hoc reports as needed by management.
  • Run routine system support using DML to maintain database integrity and trouble shooting issues.
  • Implementing software updates to Legal system and acting as a liaison with closed source software developers implementing upgrades requested by upper level management and shareholders.

Hire Now