SUMMARY:

• Design and implement business solutions using Business Intelligence, Advanced PL/SQL, Database Technologies.
• Develop customized applications and business intelligence reports.
• Work diligently, catching on to new information quickly and frequently pursuing additional skills.
• Lead projects with exceptional oral/written communication and problem - solving skills.
• Analyze database structures and create objects utilizing advanced database languages, ETL processes, and Oracle development tools.
• Reporting Services ( Microsoft BI Stack SSRS/SSIS/SSAS and Oracle BI Report) |Power BI | BI Publisher Interactive Web Reports |
• Customized Dashboards| ETL Data Processing

TECHNICAL SKILLS:

Languages: SQL, Transact SQL,PL/SQL,XML, HTML, JavaScript, C#, Unix Scripting

Platforms: Snowflake, Azure Dev Ops, Microsoft SQL Server(SSIS/SSRS/SSAS), Oracle, Unix

Applications: Microsoft Power BI, Oracle E-Business Suite, BI Publisher, Oracle Forms/Reports, Oracle Workflow Builder

Databases: MS Server 2005-2016, Oracle 8i R12

Tools: Visual Studio 2010-2017 MS Versioning, MS Flow, MS Teams, SQL, Python, R, Jdeveloper, PL/SQL Developer

EXPERIENCE:

Confidential

Business Intelligence Specialist

Responsibilities:

• Leading BI software development, deployment, maintenance report curation and data modeling
• Developed robust core framework for analytics platform
• Creation of data visualization and interactive dashboards in Power BI
• Data Warehouse design document meta data storage and technical documentation for BI tools.
• Created visualizations, reports and dashboards for requested projects
• Maintain File storage via Azure

Confidential

Business Intelligence Specialist

Responsibilities:

• Designed, built and deployed BI solutions with SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS) and SSAS
• Translated business needs to technical specifications
• Evaluated and improved the existing BI systems
• Developed and executed database queries and conducted analyses
• Created visualizations, reports and dashboardsfor requested projects
• Developed and updated technical documentation

Confidential, Broomfield , CO

Senior Programmer / Analyst

Responsibilities:

• Developed, maintained and supported application programs for Reporting Services Department.
• Performed Data Modeling and Design of Interactive Web Reports, Dashboards with Oracle BI Publisher 11g..
• Processed ETL Data from Oracle 11g database.
• Developed Database Objects utilizing advanced PL/SQL and SQL.
• Maintained and developed Crystal Reports utilizing Microsoft SQL Server(SSRS).

Confidential, Denver, CO

Software Developer / Analyst

Responsibilities:

• Performed Software Development work for Confidential s Clients on the East Coast.
• Responsible for the creation of Reports, Conversions, Interfaces, Extenstions.
• Developed Procedures, Packages and Functions for Oracle EBS R12 utilizing PL/SQL .
• Created custom WEB ADI integrators for HR module.
• Maintained code for CWB Compensation Work Bench.

Confidential, Aurora, CO

Oracle Federal Financials Developer

Responsibilities:

• Designed and developed a Claims Disbursement Application utilizing Oracle Forms 10g, Oracle R12 Database and Advanced PL/SQL skills.
• Built Federal Financial Reports to interact with Claim Forms using Oracle Reports 10g.
• Developed SFIS compliant GL Data interface for existing Oracle Apps 11i - Modules AP, AR, PO.
• Processed ETL Data from legacy applications using Unix Shell Scripts and Advanced PL/SQL.

Confidential, Lakewood, CO

Oracle Developer

Responsibilities:

• Supported Oracle Applications 11i EBS. Created designs in compliance with all Federal DOE regulations.
• Developed Federal Financials Module utilizing PL/SQL.
• Worked in Oracle 11i Modules GL, AP, AR, Assets, Cash Management, Project Costing, Project Management, Treasury.
• Deployed, tested and developed custom reports, forms, and workflows in Unix Environment.

Confidential, Denver, CO

PL/SQL Developer

Responsibilities:

• Developer for several local Confidential client projects.
• Customized Dashboards within Oracle's Project Accounting Module for forecasting Revenue, Expenditures and Cost.
• Created the workflow process for expense reports utilizing Oracle Workflow Builder.
• Resolved defects fixes, provided on call support and trouble shooting.
• Developed a Data Warehouse interface utilizing Microsoft SQL Server (SSIS/SSRS), (T-SQL), PL/SQL, and JavaScript to support Data Modeling for ARCA reporting solution.
• Performed Extract, Transform, Load-ETL processes for the Data Warehouse.
• Tracked and coordinated testing and related activities for assigned projects.
• Supervised Offshore and Onshore Test Team members.
• Reported to Project Manager on issues effecting team’s ability to complete deliverables on time and successfully pass testing phase.
• Developed new functionality and resolved defect fixes within Oracle Siebel CRM Applications 7.8. for Call Center application .
• Created and maintained custom Siebel eScript routines used to extend the application.

Confidential, Englewood , CO

Programmer/Analyst

Responsibilities:

• Responsible for Administration and Reports Development of Oracle EBS Applications.
• Configured and validated setups in Oracle EBS 9i/11i modules-Finance, CRM, HR, Manufacturing and Inventory.
• Workflow creation and maintenance, custom setups, and CRM Alerts.
• Creation of database constructs using PL/SQL.