Post Job Free

Resume

Sign in

Asp.Net Oracle Developer

Location:
Laguna Beach, CA, 92651
Posted:
July 22, 2022

Contact this candidate

Resume:

Re: RESUME

Phillips Pham

RankedWise LLC.

Plano, TX 75024

972-***-****

adrua3@r.postjobfree.com

EXECUTIVE SUMMARY

Independent Principal Consultant & Owner of RankedWise LLC. with 21+ years of proven work experience (desktop/web/mobile app development) in IT and in-depth technical background and functional background in Logistics, Supply Chain, Bills of Materials, Finance & Accounting using .NET Technology Stacks and source code repository management and control using Teams Foundation Server hosted securely on-premise or in-house.

WORK EXPERIENCE

02/2021 – Current RANKEDWISE LLC. Dallas, TX

Principal / Founder & CTO

Founded RankedWise.com as an alternative online B2B2C SaaS platform that connect business owners and people to exchange products and/or services online. The backbone of RankedWise.com is technology enabling businessowners abilities to manage their store, inventory, jobs openings, real estate properties, social connection. RankedWise.com built on Microsoft .NET Technology Stack and Azure Cloud Computing using N-Tiers architecture and VS 2019 Enterprise.

Employed AzureDevOps architecture and relevant agile practices like project boards, epics, stories, actionable methods, points > hours estimate.

Subscribed, setup and manage Azure cloud services to host MS SQL Server 2019 database, REST Web Api, App Services, Azure AD, Azure Storage, ASP.NET portal, SSRS.

Created responsive portal applying JQuery, Bootstrap, CSS, HTML/HTML5, and relevant Javascript libraries.

Created iOS mobile app using confidential language on App Store.

Created RESTful Web Api solution using VS 2019, C#, and licensed 3rd party APIs to share public and authorized access to applications data and database.

Created login/registration using OAuth 2.0 and Identity access management.

Employed Entity Framework initially and expanded into ADO.NET to handler smart data services and/or microservices.

Employed Azure Microservices, Functions.

Employed continuous integration and deployment (CI/CD).

Created SQL Server 2019 database and all underlying db objects (schemas, tables, stored procedures, …) using Entity Framework initially and expanded during the SDLC.

Planned and implemented role-based securities on all tiers.

Employed unit and regression testing methodologies using NUnit, TDD, BDD, SpecFlow.

Employed Angular 10 to provide Angular front-end alternative.

Prepared release notes and manage scheduled release and deployment.

02/2021 – 11/2021 COGNIZANT Dallas, TX

Lead Software Engineer (Senior Manager)

The Premera Blue Cross Engagement. Brought in to help with the research, discovery and establishment of the migration to Okta Identity and Access Management project and CMS upgrade project. Helped streamline the VPN access process, application & systems request and approval process. Helped with the L2 interview, recommendation and hiring of new resources to add to the project. Participated in daily sprint and periodic team meetings (Sprint of Sprint) to formalize and create new and update existing features, defects, user stories, estimate of development tasks. Utilized software development tool and specialized area of expertise in Microsoft Visual Studio Enterprise, Microsoft .NET, C#, Microsoft SQL Server, Azure, Azure DevOps, Agile and Waterfall Project Management Methodology to develop, unit test and regression test software change requests. Successfully communicate, collaborate and maintain client relationship across various roles from Help Desk to Software Development Manager to Director via all forms of communication channel (MS Teams chat, Zoom call, Email, Phone, etc.).

Utilized MS Visual Studio 2019 Enterprise, C#, SQL Server/Oracle, Angular, LINQ, HTML5, CSS, Bootstrap, SQL and -TSQL, SQL and PL/SQL.

12/2019 – 02/2021 SAIC Oklahoma City, OK

Lead Principal .NET Architect / Data Management & Analytics

Onboard to lead and manage a large and complex Enterprise Business Intelligent Reporting, Systems Integration and Data Analytics portfolio and projects using .NET technology stack and Tableau.

Successfully worked with the Project Management Office (PMO) planned and organized New and Approved programs and projects.

Successfully initiated and Lead a team completed 2 critical MVP solutions that directly resulted in $1M funding for future phases. Both MVP included a BI & data analytics solution and a functional Enterprise mobile app.

Planned, proposed, installed, licensed MS Azure services.

Created MVP and wireframe to demo with project team, stakeholder including Director, Managers, Field personnel.

Architected and implemented N-Tiers architecture using AzureDevOps to manage Front-end user interfaces, RESTful Web Api, Android iOS mobile app., and MS SQL Server 2016 Enterprise db.

Created product features, stories, tasks, acceptance test and test criteria.

Assigned RESTful Web api ownership to another member of the team.

Taken on web-based database applications using ASP.NET Core 3.1, mobile app. Development, and database design and development.

Created meeting agenda, attended daily, weekly status meeting to discuss progress and resolve blockers.

Planned and run demos. Gathered feedback and organize workloads into future releases.

Successfully completed full SDLC of both solutions include wireframes, documentation of app features > user stories > tasks & estimates > Kanban boards.

Successful navigated complex and rapidly changing priorities to gather functional requirements > development of MVP > Wireframes > creation of app features, user stories, work break down structures, tasks, estimates, assignments, development efforts (front-to-end to Cloud Computing), on-going weekly or as-needed team meetings to meet or adjust milestones and/or deliverables.

The technology stack, source code depository and projects management include Microsoft Visual Studio .NET, C#, ASP.NET, Excel VBA, Tableau, Microsoft SQL and T-SQL, Oracle SQL & PL/SQL, Cloud Computing, Team Foundation Server & Git for source code configuration & management, and JIRA Kanban boards, Docker, etc.

Currently leading the re-branding and mobile app implementation for both Android and iOS platform using Xamarin Forms, Visual Studio 2019 Enterprise, .NET Core 3.1 REST WEB API, Microsoft SQL Server, C#, AWS private virtual hosting. Responsible for prototype / proof of concept design, functional requirements, epics / stories / tasks documentation, product demo, architecture, …

01/2016 – 12/2019 Baker Hughes Houston, TX

Senior Data Management and Advanced Data Analytics Manager

Work individually and as part of the Upstream Oil & Gas division to support all Exploration and Production North American energy producers. Support a portfolio of 5 critical business web applications: LASER (a chemical lab information system), uView (an analytical lab), a set of customize Excel VBA templates and Services Catalog written in .NET Framework. The technology used include MS Azure services and AzureDevops framework, C#, Microsoft .NET Framework 4.5, MS SQL Server 2012, Business Intelligent Reporting Spotfire, Excel VBA and Python, SAP R/3 Order to Cash, Oracle 11g, Oracle SQL and PL/SQL. Written data migration algorithms in C# to transfer NoSQL to SQL Server and MS Excel.

04/2014-04/2016 Johnson Controls Norman, OK

Software Development Manager .NET, MS SQL and Oracle

Johnson Controls is a global diversified Fortune 100 company in the building and automotive industries and serve these markets through three (3) business units: Building Efficiency, Automotive, and Power Solutions. Worked as part of the team within Building Efficiency business unit of Johnson Controls Inc. provide web-based database applications implementation, maintenance and daily operational support of single sign-on portal www.upgnet.com. The single sign-on portal consists of approximately 96+ web applications providing online solutions for Building Efficiency employees including regional sale managers, external indirect sale channels including distributors & dealers.

Responsibilities:

* Conversion of legacy classic asp UPGNET.com to C#, ASP.NET MVC 4.5, Bootstrap, Knockout.js, Angular, AJAX, JQuery, WCF Web Services, SQL Server 2008 R2, SQL Server BI / SSRS / SSIS Reporting

* Conversion of legacy classic asp SmartSearch to C#, ASP.NET MVC 4.5, Bootstrap.js, Knockout.js, AJAX, JQuery, WCF Web Services, SQL Server 2008 R2, SQL Server BI / SSRS / SSIS to include order management module and seamless integration with SAP (Parts, Bills of Material), Click Commerce CRM, NxTrend (Parts, Bills of Material), SiteCore

* Obtained latest version of core libraries and web solutions from Team Foundation Server 2012 to make changes and update source code.

* Build, unit test and regression test data access layer, user interface layer, views, mvc, controllers (homecontroller.cs, apicontroller.cs

* Created and updated stored procedures, table-valued functions, sql jobs, ssis packages within SQL Server 2008 R2

* Developed data fixed scripts to help business units correct critical business transactions such as claims data, sales data, payment data

* Usage of Business Intelligent Development Studio (BIDS) of Visual Studio 2008 and .NET Framework 3.5 SP1 to create and schedule SSIS packages to extract, transform, and load one time and recurring master business transactions from multiple source systems (SAP, AS400 NxTrend and flat files in .csv and .txt format) into SQL Server 2008 R2 databases upgnet.com business applications depend on. A short list of one time and ongoing batch load jobs include: Products Group, Products Hierarchy, Products Materials, Customers Master, Vendors Master, Production Sale Orders

* Implementation of Order Services Center: Air-cooled Chiller Quantities In Stock and seamless interface to SAP Material Management (MM)

* Extract Transform Load (ETL) SAP Materials Master Data and Bills of Materials (BOMs): Multi-Level into SmartSearch ASP.NET 4.5 MVC, Bootstrap.js, Knockout.js, JQuery, Entity Framework, SQL Server 2008 R2

* Acted as a Subject Matter Expert on all reporting, data conversion and interfaces need

* Mentor less-experience developer and IT Help Desk Tier-1 and Tier-2

* Collaborate directly with sales and marketing super users, bill of materials (BOM) and parts super users to document, resolve and close bug fixes and software enhancement requests

* Collaborate with offshore developers to outsource User Interface Layer development work for implementation of SmartSearch Phase 2

* Data conversion, design, development of User Interface (UI) Layer, Business Logic Layer using C# WCF web services, and SQL Server objects (schemas, tables, functions, views, jobs, ssis packages) for both UPGNET.com and SmartSearch applications. Provide database administration / maintenance / production support of SQL Server databases hosting SAP (Bills of Materials, Parts, Order Management, Materials Master) / Click Commerce / Channel Fusion / Upgnet.com and SmartSearch. Develop and maintain technical documentation of open and closed issues include problem description, root cause analysis, solution analysis/optional solutions, test plans, test results

* Create, scheduled and manage SSIS jobs to extract, transform, and load data from external source systems such as SAP, AS400, excel files, text files that UPGNET suite of applications depend on. Example of tasks involve: Created new job category, job operator, email notification, master materials, production orders, products pricing, products categories, vendors

* Refactoring code of legacy code written in Classic ASP, VB.NET and Coldfusion into C#, .NET 4.5 Web Forms

9/2009-04/2014 L-3 Communications Oklahoma City, OK

Software Development Manager .NET and MS SQL 2008 R2

As member of web development team, provided development, maintenance and production support of the following FAA mission critical web-based database applications: IACRA, AOVCredentialing

IACRA is the web-based certification/rating application that guides user through the FAA’s airman application process. IACRA helps ensure applicants meet regulatory and policy requirements through usage of extensive data validation. It also uses digital signatures to protect the information’s integrity, eliminates paper forms.

AOVCredentialing allow FAA administrative personnel abilities to create, store, manage and issue credentials to Airway Transportation System Specialist and Air Traffic Controllers.

Technology used include: MS Visual Studio 2008/2010, Microsoft Team Foundation Server, Microsoft Sharepoint, C#, VB.NET, Classic ASP, ASP.NET Framework 2/3/4, SQL Server 2005/2008, T-SQL, AJAX, JQUERY, Javascript, HTML, LINQ, Master Page Templates, MS Team Foundation Server, Class Factory Design Pattern, MS Enterprise Class Library, Spotfire, Tableau.

05/2006-09/2009 HERTZ Oklahoma City, OK

Software Development Manager – Oracle North American and APAC

Environment: Oracle 10g, Oracle e-Business Suite 11i, Oracle SQL and PL/SQL, Oracle SQL*Loader, Oracle Forms/Reports, Oracle Developer 6i, TOAD, SQL Navigator, Oracle Enterprise Manager, Spotfire, Tableau.

Responsibilities: Worked as part of a team to provide development, operational support and maintenance of Oracle e-Business Suite 11i for all 3 business units: North American, APAC, and Europe.

* Developed data import and export utilities using Oracle SQL*Loader, SQL and PL/SQL

* Provided development and enhancement of custom and seeded Oracle Forms

* Provided development and enhancement of custom and seeded Oracle Reports

* Performed database and applications refresh from production environment to qa to development

* Performed database backup and recovery

* Trained Business Analyst and System Administrators how to use TOAD and Oracle Enterprise Manager

* Performed administrative tasks such as changes and configuration management, status of assigned tasks and percent of completion

EDUCATION

Bachelor of Science in Computer Science – Edmond OK - Graduated 1997

CERTIFICATIONS

ITIL V3.



Contact this candidate