Business Analysis IT Professional
ROBERT LARIOS
SUMMARY
(PM/Business Analysis, Operations, Marketing, Finance, Software Systems)
Brings data analysis & interventions-resulted in $2+ Billion in new markets, revenue or cost avoidance
Creates profit centers of data software systems- reforming business processes and corporate legacy systems
Delivers on business requirements & proven to work with all corporate staff levels & off shore staffs
Extensive knowledge of software & DB management design life cycle & testing procedures –SQL queries
Accomplishes full cycle re-engineering in ECM, EDMS, AR/AP, Marketing, Finance, Ops, IT, & business
Proposes alternative solutions resolving complex business issues where other SME experts fail in requirements
Quick bottoms up business process analysis with profit based change management transformations
BA, PM, & Program Manager cultivating Golden solutions to stay within scope, on budget, and time
TECHNICAL SKILLS
FunctionalèTraining; Marketing; Finance; Sales Comp/Commissions; Billing; Reporting; Sales; DB; Software
Problem Solverè Unique Root Cause Business process analysis; Project end to end-road block remover; provider of innovative developments; applies market place benchmarks; cost/benefits & best practice results
Process analysisèProactive DRIVE: Define, Review, Identify, Verify, Execute-Task on arrow, process maps
PM/PMOèExpert in managing multiple projects and leading team to meet business objectives on schedule
Strategy setting as group lead or PMO directive- for corporate project delivery pipeline with high output
Methodology is Waterfall and Agile – with focus on what works best for the company and project
Expert in managing through issues with innovative get well plans- and post project analysis for efficiencies
Ability to organize and execute plans and resources into cohesive teams and communicate project status
Have managed projects of all sizes and complexity and have track record of 95% success rates
Brings not only project management, but business and technical expertise in quality developments
QA/Bus Analystè Expert requirements gatherer & definer of user stories, features & epics; process visionary & GOTO expert for stakeholders; provider of technical requirements & test plans; with post project learning’s
Environments: ad hoc to large projects-with CPDEP; Agile/Scrum; Waterfall; SDLC; DOORS; Jira;Web
Creates advanced analysis-data filled dashboards; visualizations, & operational performance reports
Adept at analyzing business requirements and software requirement specifications
Creates BRD, traceability matrix, frame & liaise across: business, designers, techs, & sprint developers
Proficiency in Developing, Designing, Reviewing, Executing, and Preparing Test cases
Use case, storyboard with system structured testing plans: Unit, Integrated, Regression, & UAT testing
Database\ETL Tester in Manual and Automated client-server applications
Solid understanding of quality assurance, software development life cycles, & implementing QA methods
Software testing involving creation of test scripts / cases and tracking of defects using bug tracking tools
Business processèbusiness cases, life cycles, business-workflows, process decompositions/turnarounds
Strategic PlansèAligning business practices with existing /emerging strategies-inclusion of reluctant member
Dashboardè Creation of Innovative dashboards for executive reporting on project and project deliverables
Technologyè MSOffice; Spotfire; Excel; VB/Pivot, MDM; SAP; Oracle; CRM; EAM; SAS; SQL; ECM; EDMS,+
Data warehouse: è DWH-Operations; DB-SW conversions; Work flows in SharePoint(project tracking)
Relevant Accomplishmentsè Data: collection, classifying, cleansing, mastering, Big data usage, analysis
Devon (2017)-SQL, Power BI, Spotfire, iPoint, Datameer, Excel Macro-reservoir engineering DBM model, internal and public oil & gas data model for Inventory Management modeling-GIF oil field characterization
CVR(2016)-SQL, Oracle, EAM to integrate 2 Nitrogen Plant merger-to use data rich integrated maintenance
CVR(2016)-ExtraHOP, SQL, (4)Load out SW(Fuelfac analysis on day 1 replaced PLC plans at 60% save
USDA(2016)-SQL, Java-loan transition from Cobol, new Credit analysis and data interface for credit scores
BHP Billiton(2015)-SQL, Oracle, OBIEE, MDM, Informatica, DSO,=> implemented Data quality, upgraded data based work flow processes, management, governance- RE data, reporting model on Spotfire/OBIEE
Chevron(2013)-SQL ETL, Jira, CRDB Composite, CSC, HTML, SCADA, Wonder Ware-developed inj. data dictionary and mappings for data gathering and management reporting for all oil fields- compliance- type
Sprint(2008)-SQL, SAS, Teradata, VB-$250K –revamped Network Table/system billing system emulating millions call routing connection options & data- replaced 1,200 staff, decreased product introduction by up to 98%, & reduced data tables by over 50% with a GUI interface & what if analysis-$40+M/year savings
Sprint(2008)-SQL,SAS, Teradata, Adbas, Cobol, Natural, Holos, Datamart, GUI-Hybrid OLAP development that exposed CIS, order, sale, revenue, performance, product, program for drill down with statistic maps
Sprint(2008)-SQL, SAS, Teradata, Adbas, Fuzzy, Bigdata- 10 year $1B class action lawsuit DB, defense strategy mapping- monthly updates, and overnight report support disproving Plaintiff IT in arbitration
PROFESSIONAL EXPERIENCE
Devon Energy; Oklahoma City- (3/2017 to 8/2017)
Lead BA- (Reservoir Engineering-DB Management analysis, strategy, Quality, MDM, & Governance)
Well life cycle work flow process analysis and decomposition-GeoTech and reservoir engineering-Petra
Reservoir tech operated & OBO operational work flows and process problem analysis & resolution lead
IRC tool and process work flows and decomposition – new area/well processes and interfaces-tools
Establishment of data management interview and work flow goals and initial strategies-charter creation
IMT & Production analysis for IP, cumulative, and a variety of tracking methodologies –Big Data approach
TSCTI-USDA Kansas City (6/2016 to 12/21/2016) AGILE JIRA- BA
ADPS-loan transaction requirements- systems business analysis- RTM, Use Cases, and technical design
CAIVRS/Credit Bureau-business requirements & technical/test case/data/UI requirements for application
CVR Energy Nitrogen- Refinery Kansas City (10/2015-5/2016)
BA-(Business Process, Auto Load out facilities, M&A; IT)
M&A Business Process mapping, EAM, Procure to Pay, AP, AR business requirements process analysis
Business plan for PLC conversion and load out software replacement requirements analysis
Recovery analysis IT for business plans for Gen 3 Load out facilities-FuelFac-Maximo-Oracle
Developing emulation software plans for electro-mechanical testing
BHP Billiton, Houston 03/2014-06/2015
SR Business Analyst/PM/(MDM, OBIEE, RER, JMS, D&C SME, SharePoint, & IT)
Support E&P operator in various upstream requirements development areas as BA or PM.
Executed with Engineering, IT and business infused analysis & implementation providing process analysis
Provided new corporate data governance & MDM-mastered data requirements
Top 3 projects are MDM (Master Data Management) initial implementation and conversion, PM-DSO (Well Delivery System-D&C well Reporting-OBIEE, Spotfire) & RER (Reservoir Engineering Database) -Deloitte.
Chevron, Houston 04/2012-12/2013
SR Business Analyst / SME Petro technical Occupational Competency/SharePoint (International Audience)
IMET 3.0 Water Flood Software Development in Late Stage 4 CPDEP--03/2013-12/2013
Utilized oilfield knowledge, process and analysis skills as key in providing a higher quality product delivery.
The project a data quality improvement effort became significant process improvement functionality.
Analysis contributed to a significant business change with the discovery of work flow errors for WAG wells
Another notable-was requirement analysis on complex well status redesigning ETL in CRDB Composite
Uncovered numerous requirements issues with the Scada reporting system and tree map model
Information Analyst/Domain PM-Petro-Technical Operational Competencies Group-PIMOC 04/2012-12/2012
Helped author Major Capital Project competency maps and developmental activities specific to each CPDEP phase such as in the IM plan development, IM Specification plans, IM standards; for contractor or vendor processes and communication plans; and phase specific activities to mature MCP CPDEP awareness skills.
Project managed the developed specific domain competency areas, formal training curriculums, and on the job development activities. Steered engineering domain knowledge in MCP processes
Pioneered additional training class plans with PetroSkill for Facility engineering, FE equipment, report concept, and expanded another class with added topical areas of coverage.
Project roll out was 2013 to supply and fill projected occupational competencies resource gaps by the Major Capital Project (MCP) business.
Halo Oil Inc., Noble OK 1/1990-04/2012
Turnaround SR Business Oil & Gas Consultant
oProject management from gathered requirements of customer lease turnaround activity.
oWorked as PM consultant with NDA technology addressing Shale horizontal but thru V-completions
ABS, ROI & GPS, Buffalo Grove, IL 06/2010-10/2010-Turnaround Sr. Business Consultant
oTrained and helped target companies to turn P&L, A/R, A/P, Marketing, Ops, Business processes
oUtilized the Theory of constraints for requirements in process model in turning around companies
Ameroyal, Shawnee, OK 01/2009-12/2010- Business Analyst Start-Up & Oil & Gas PM Consultant
oRisk venture on this start-up with a potential $10 million/year investment capital.
oGathered requirements built, drilled, logged, and completed the well per the project plan.
Sprint & Nextel, Overland Park, KS 08/1987-12/2008
Group Manager Information Management-PM/Innovative Solutions-Marketing Manager Strategic Mkts/ General Mgr
Received patent in 2012-a second pending for resource management system /business model-SAS, Excel
Managed project managers & business analysts on risk analysis, requirements, project design, marketing, progress, problem solver, to keep projects on time, within costs exceeding business and marketing needs.
Developed executive daily 1 page score card-Excel, HTML, SQL-that gave executive line of business insight
Project manager & Risk Manager/Maintenance Manager-N2K Lawsuit Project
CEO selected as PM for the 2 year development and 9 year maintenance manager law suit process.
Resulted in risk abatement, settlement, as data manager, marketing, plan-performance, pricing strategy, churn, bad debt, house holding, profitability, and legal data models business lifetime risk damages.
Project Manager Sierra Project
The project implemented a new transformed data warehouse & billing process for $250K.
The new system increased risk tracking, risk analysis, provided what if analysis, cut product to market introduction by up to 98%, provided for testing platform, and eliminated the majority of the 2,100 staff.
Project Manager Commission System
Developed a new commission system & warehouse that took a legacy system and made it a profit center.
Information System supported $4 billion/3500+ partners with Daily to monthly data exchanges.
EDUCATION
University of Texas El Paso (UTEP)
Bachelor of Science, Electrical Engineering, Computer, & Math (Matriculated 3 Years)
CERTIFICATIONS & TRAINING
Granted Resource Management System Patent 2012 - (another Patent Pending)
Bilingual- English/Spanish Read, Write, Fluent, Conduct business