Sheldon Webb

Mobile Phone: 954-***-****

Secondary Phone: 954-***-****

E-mail: adfi00@r.postjobfree.com

OBJECTIVE

Opportunity

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 Feb 2019 – Apr 2020

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 May 2012- Feb 2019

Royal Caribbean Cruises

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 (Contract) January 2012- April 2012

Tekpartner State: FL Software Services

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.

Business Intelligence January 2011- January 2012

Tropical Financial Credit Union State: FL Financial Services

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 2006 – January 2011

Greenberg Traurig State:FL Legal Services

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.

Report Writer May 2006 - December 2006

MSI Consulting ( Contract) State:FL Waste Management

Developing and modiifng existing Crystal Reports using Crystal Reports 8.5. Creating views and stored procedures using SQL Query Analyzer, Check cost of each query using SQL Query Analyzer to improve efficiency of SQL queries from crystal reports. Trouble shoot ongoing issues with VB.net Windows application with end user.

Systems Analyst May 2005 - May 2006

Royal Management West Palm Beach, FL Construction - Industrial Facilities and Infrastructure

Troubleshooting VB.net mobile application, editing webservices. Writing and modifing Crystal Reports using Crystal Reports 9.2.2 for Microsoft CRM and Solomon. Trouble shooting ongoing connectivity issues with both CRM and Solomon. Developing and modifing current customized pages in Microsoft CRM using VB.net and system utility in Microsoft CRM. Using VSS for version control. Running SQL reports to verify connectivity issues with Project Server 2003. Developing ODBC connections to use in Crystal Reports. Developing views to cross connect to multiple servers from both CRM and Solomon servers. Implementing and supporting both Microsoft CRM and Solomon. Acting as a liason with external contractors.

Systems Analyst/ Accounting Manager October 2003 - September 2004

Elite Golf Cruises Sunrise, FL Sports and Physical Recreation

Used Visual Basic 6.0, VB .Net, XHTML, SQL, XML, Dreamweaver, JavaScript, CSS, Adobe Photoshop 7.0 to apply design themes from ad images into content of company Web pages, including images from posters. Developed and maintained company websites that consist of 30 web pages using both VB .Net and Dreamweaver to create Window Forms and Web Forms accessing databases developed in Microsoft Access. Used the .Net platform to evaluate and modify XML schema for web forms. Maintained the local area network including trouble-shooting the network and resolving occurring issues, such as connections to the network printer, spam email and viruses. Diagnosed and resolved email connectivity issues. Added user accounts for new employees to the network controlling permission to sensitive files, also configuring TCP/IP protocol for employee’s computer system. Configured Linksys router with T1 line from company’s ISP. Installed and presently maintaining HP5500 DeskJet for printing poster and banners for advertising. Run daily back-up of system data using Veritas Back-up Exec software on 20GB Seagate drive. Proposed the upgrade of Workgroup/Client server to a Dell server, which is presently being considered. Using Adobe Photoshop to design and modify poster ads for onboard marketing strategies on the Carnival, Celebrity, and Princess cruise lines. Print ad posters using Wasatch SoftRIP and HP Design jet 5500 printer. Installed and maintained HP Design jet 5500 printer. Responsible for all activities in the accounts payable/receivable and payroll functions such as: reconciling general ledger accounts (cash, accounts receivable, accounts payable, pre-paid, accrued liabilities, payroll liabilities and fixed assets), and ensuring the integrity of the accounting records, using QuickBooks Pro. Ensuring timely payments of payroll, vendor invoices and expense vouchers while maintaining accurate records. Experienced with ADP payroll system. Manage collection activities such as sending follow-up inquiries, negotiating with past due accounts. Liaise with operation and inventory managers regarding receipt of inventory and performance of employees.

Systems Analyst / Operations Manager January 2002 - October 2003

S.D.& C. International, Inc. Pembroke Pines Automotive and Parts Mfg

Developed and maintained company Web Site using HTML, Dreamweaver, CSS and JavaScript. Used VB.NET and Visual Basic 6 to create user interface for viewing available inventory and developed a program that allowed customers to purchase parts from company's website. Used Adobe PhotoShop to create flyers to distribute to retailers and competitors.

Operations Manager January 2000 - October 2002

S.D.&C. International, Inc. Pembroke Pines, FL Automotive and Parts Mfg

Established and maintained customer Lines of Credits, Letters of Credit, bank accounts and Fixed Deposits with financial institutions in the corporate area. Implemented software for the generation of accounting statements and communication with parent and subsidiary divisions. Meet Federal and State tax requirements and approve tax returns for submission. Researched and applied new investment strategy and, in general, monitored daily operational issues. Purchased 20 & 40-foot containers of aftermarket replacement, used and performance automotive parts from the Far East for sale in the Caribbean to retailers and wholesalers. Maintained and grew an inventory flow of automotive parts estimated at $600,000 US annually. Traveled to the Far East to develop working infrastructure with suppliers in Japan, India, China and Taiwan. Researched and developed parts list of fast-moving automotive aftermarket parts for the state of Florida compromising over 4000 items. Established price comparisons of key leaders in the automotive industry and gained purchasing prices from the exercise.

EDUCATION

Master's Degree, Dec 1998

Barry University MBA/MIS- Masters Information Systems GPA: 3.5

Bachelor's Degree, Dec 1996

Barry University Major: Mathematics GPA: 3.0

Contact this candidate