Adriano Nogueira Email & Phone Number

State Of São Paulo, Brazil

São Paulo, Brazil

Led systems development team (C#, .net, Dapper, Redis, PostgreSQL, MariaDB, Oracle, Selenium WebDriver) to:- Build bank payments solution;- Build a spreadsheet conversion solution into TISS standard XML;- Build a workflow solution for checking customer documentation;- Build micro services and APIs for querying registration data for consumption in applications and web solutions;- Integrate systemic functionalities for checking orders, sending documents, opening tickets and recording leads to the WhatsApp API;- Identify and eliminate security flaws in websites and applications;- Optimize and reduce response time and loading of features in web applications;- Automate public data capture through RPA;- Extract and organize data from standardized PDF files (notes, guides, forms).Understood and documented business requirements in technical language.Interviewed and recommended talent for IT positions.Optimized technological capital by reducing costs and security risks, integrating solutions and consolidating assets.

São Paulo, Brazil

Led a decentralized multidisciplinary team (specialists in the areas of medicine, statistics and technology) with 25% of team from USA and replicated and adapted data analyzes to the Brazilian operation.Replicated, adapted and created analyses, reports and dashboards (MicroStrategy Cognos, Tableau, Excel VBA, Oracle and PL/SQL) for:- Identifying fraud, abuse, error and waste in medical cost;- Benchmarking average cost by region, specialty, services and items;- Creating optimal provider networks and new medical plans;- Pricing of products and medical plans;- Benchmarking of service NPS;- Forecasting medical costs based on legal changes, contractual adjustments and usage trends (budget);- Follow-up and assure effectiveness of initiatives to encourage and steer members to cost-effective providers;Documented and reported to American team:- Rules and criteria for systemic denials;- ANS legislation and regulations (TISS) that outline the legitimate scope of activity of insurers.Documented and facilitated with the technology area the implementation of rules and criteria for systemic denials performed in other countries.

São Paulo, Brazil

Made development outsourcing possible for multiple software factories, reducing technology costs.Enabled outsourcing of software testing (QA), increasing the quality/stability of systems and creating a performance evaluation point for software factories.Created objective metrics to evaluate the performance of software factory contracts, allowing the implementation of contractual fines for breach of SLA.Led internal development team and managed contracts for outsourced software factories.Implemented pull-request and peer-review policies reducing code rollback errors.Led the development and exposure of features on the web and mobile App (Java, .Net, Oracle and PL/SQL):- Provider network search by procedure;- Provider network search by geolocation;- Tokenization of visits (sending codes via SMS or Push);- Eligibility of procedures considering grace periods and payments.Led the development of an internal tool that enabled the business area to define deployment windows (CD/CI integration).

São Paulo, Brazil

Led development team to code and develop:- Oracle PL/SQL functions to perform systemic denials reducing fraud and abuse;- Data entry forms for providers, customers and rules for applying denials (Java and .Net);- APIs for receiving TISS XML files (Java and .Net);Replaced and centralized SVN repositories with Git and deployed GitHub Enterprise Server.Implemented automation for automatic deployment (CD/CI).Standardized the development policy (SDLC) by creating a quality control point when merging pull-requests, reducing maintenance risks.Captured and prioritized business requirements to build use-cases and user-stories.Replaced 20 instances of the same client-server application with a new web application created (C# and Oracle Exadata), simplifying access control, reducing infrastructure and reducing headcount in the business area.

São Paulo, Brazil

Implemented new BI solutions with data from Bristol Myers Squibb's SAP HCM.Improved and corrected the DW database structure, reducing reading time (queries) by 20%.Created and corrected Cognos reports.Replaced ETL developed in script with tools (e.g. ACTA), reducing maintenance cost and complexity.Trained international technical teams allowing Bristol Myers Squibb to have 24/7 technical support ('Following the Sun' project: distributed teams).Led the BI team in building solutions for complex AMBEV problems (e.g. detection of market cannibalization as a side effect of marketing campaigns; cleaning, standardization and consolidation of proprietary coding of resellers and distribution points).Built dashboards that allowed AMBEV's marketing team to create sales incentive policies and monitor their effect with T+1.

São Paulo Area, Brazil

Led a team of developers to code the company's ERP system. Integrated the financial module with banks via CNAB. Adapted the billing and accounting modules to changes in company's strategy. Improved the medical billing adjudication module reducing fraudulent and abusive medical cost.

São Paulo Area, Brazil

Developed and programmed the UNIFESP college system and the management system at Hospital São Paulo. He trained the development team in Delphi, made up of those approved in a public competition, and enabled them to rewrite all Cobol systems.

São Paulo Area, Brazil

Codificou e desenvolveu sistemas com foco em soluções que permitiram operadoras de saúde realizarem redução de custo através de críticas e glosas em contas médicas.