Solution Developer Resume

SUMMARY

Experienced in Reporting, T - SQL and PL/SQL development in various industries including Oil & Gas, Education, Financial, Compliance, Retail, and Loan Servicing databases using SSRS, Crystal Reports, Power Platform (Power Apps, Power Automate, Power BI), Common Data Service (CDS), JasperServer iReports, and other reporting tools, with experience in reporting solutions consultation and analysis to include requirement gathering, application support, and functional and technical specifications.

TECHNICAL SKILLS

Software: Power Platform (Power Apps, Power Automate (Microsoft Flow), Power BI), Spotfire, ArcGIS, SSRS (Visual Studio BIDS & Report Builder Standalone), Crystal Reports (versions 9, 11, 12, 14), SSMS (2016 and previous versions), Oracle SQL Developer, JasperServer iReports, Peoplesoft Peopletools 8.4, Toad (for SQL Server and Oracle), Visual Studio

Languages: T-SQL, PL/SQL, DAX formulas, Crystal Syntax, PeopleCode, VB Script, C++, C#, PASCAL

PROFESSIONAL EXPERIENCE

Confidential

Solution Developer

Responsibilities:

Developed a PowerApps tool pulling from CDS entities and utilizing DAX functions and Microsoft Flow (Power Automate) to populate Microsoft Word template content controls and emailing them as .pdf attachments.
Developed a Spotfire Reporting tool populated by Teradata queries for surface subsidence analysis and mitigation.
Created Power BI visualizations for trending and analysis of a water sampling database.
Implemented a mobility device solution with consideration for Class 1 Div 2 requirements.
Created a proposed well location survey tool and process workflow through ArcMaps, ArcGIS Pro, and ArcGIS Online, utilizing hosted feature layers.
Created a PI AF datasource solution.
Participated in an annotated reality mobility solution utilizing Microsoft Hololens.

Confidential

Business Intelligence Developer/Analyst

Responsibilities:

Implemented a Point-of-sale business solution (Future POS) to gather customer and transaction information, process payroll, and analyze sales data. Created an inventory control using SQL Server 2005 and SSRS reporting server. Developed a secondary digital and cash payment system for off-site purchases. Developed an SSRS Report Builder Sales, CRM, and back office reporting solution. Developed a Power BI solution providing visualizations for performance analysis.
Implemented a Point-of-sale business solution (Future POS) for a local business expansion location. Used existing database instance to create and customize new machine. Researched and applied methods for cost savings on hardware, software licensing, and vendor customization.
Developed and implemented a business process solution to increase efficiency and productivity for a local café and boutique. Reorganized the management structure for better delegation authority.
Created a Quickbooks financial solution. Developed an ETL and reporting solution for Quickbooks utilizing QODBC and SSRS Report Builder.
Oversaw an expansion into a satellite kiosk location along with a new Point of Sale application customization and database implementation (Heartland POS).
Analyzed and developed business process flows for a local restaurant. Maintained and diagnosed existing POS system.
Drafted a proposal and placed a successful bid for a reporting and ETL solution.

Confidential

Development Analyst

Responsibilities:

Created and maintained an SSRS solution to replace a Crystal Reports reporting server querying multiple SCADA measurement and historical archive databases, including UCOS, JLOG and Pi.
Created various datasets in T-SQL for MS SQL Server 2005, 2008R2 and 2012 servers.
Developed alarm reporting solution for the SSRS reporting server.
Maintained an SSIS ETL solution for a closed SCADA system datasource using data-driven subscriptions and FTP scripts.
Analyzed existing trending and volume reports to ensure calculation accuracy.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship