Fernando Morote

**** ** ***** *** ******** Pines FL 33028

Mobile Phone: 954-***-****

E-mail: ad035z@r.postjobfree.com

November 13, 2023

StevenDouglas

Oakland Park - Florida

Subject: Senior Business Analyst

Dear Sir/Madam

I am a Senior Software Engineer/Business Analyst & Business Intelligence Analyst, with more than 15 years of combined strategic and operational leadership in the design and development of a different variety of systems and applications mainly in the Finance and Accounting area that also includes hands-on BI&A projects using Tableau for more than 7 years, and 25 years of SQL. I worked with the business to ensure their needs are translated into technological capability. I have managed and led resources vendor provided on-shore and off-shore.

I am a strategic thinker, leader, and motivator with a talent for training and developing top-performing technical teams, building collaborative business partnerships across all business layers, and inspiring team engagement and accomplishment. Developing and translating organizational vision into highly effective documentation management, financial planning, and responsive solutions, bridging cross-functional team communications, and presenting technical concepts to technical and non-technical audiences have benchmarked my professional performance. Designing and delivering Best-in-Class, high-value software applications, optimizing the user experience and driving projects and day-to-day operations have been the consistent result.

Following are some of the areas in which I excel:

Bachelor of Science in Industrial Engineering Degree, with Strong experience with Software Development Lifecycle (SDLC) methodologies, Agile/SCRUM, JAD sessions and Project Management Life Cycle - PMLC.

Provide ongoing support to software developers and architects, business analysts to plan, design, develop, test, and maintain applications.

Create and execute test plans (Quality Assurance) based on business requirements for traceability and instruct test resources on proper procedures to ensure team compliance.

Excellent problem-solving skills identifying the root cause of a problem and recommending solutions.

Ability to build data processes, workflows, and scalable solutions.

Document business requirements and detailed specifications from multi-department stakeholders for review and delivery to the development team.

Excellent experience with Data flow diagrams, Data dictionary, Data Modelling, Database normalization, Entity relation modeling and design techniques.

On-time, on-budget project delivery ensuring business requirements are met.

Skillful asset stewardship providing business and development strategy.

Superb communication skills and ability to deliver technical information to non-technical audiences.

Maintain stakeholders’ visibility into projects while holding them accountable for their role in the development

process to avoid bottlenecks.

Provide ongoing support to Business & Data owners on analytics requirements to build reports, KPIs, dashboards using Tableau and other technologies.

Conducting JAD sessions, interviewing business reps, resolving stakeholder conflicts, fielding questions from executives.

Confident that I can make a meaningful contribution, I have included my résumé for your consideration.

Fernando Morote

Fernando Morote

1025NW 157th Ave Pembroke Pines, Florida

Mobile Phone: 954-***-**** E-mail: ad035z@r.postjobfree.com

SENIOR SOFTWARE ENGINEER

Business Analyst / Business Intelligence Analyst

QUALIFICATIONS PROFILE

Results-driven Senior Software Engineer/Business Systems Analyst & Business Intelligence Analyst with demonstrated track record for training. motivating, and leading high-performing technical teams, managing onshore and offshore development and deployment projects, and delivering Best Practices technical services. Interpersonally skilled motivator, team leader, and liaison credited with managing numerous concurrent technology development projects, streamlining, aligning, and standardizing business processes, reducing operating costs, and optimizing the user experience. Knowledgeable Subject Matter Expert with reputation for brainstorming and implementing innovative technical methodologies and solutions, executing continuous quality improvement programs, and delivering technical innovation, operational, and performance excellence.

CORE COMPETENCIES

Lead BI projects from the conceptualization until its production deployment using Tableau and Dundas.

Change Management, Continuous Process Improvement, Data Management, Migrations, & Transitions

Software Development Lifecycle Procedures (SDLC), Data Modeling, Datawarehouse Management

Business Analysis, Resource Allocation/Optimization, Regulatory & Security Compliance

IT Operations Management, Project/Program Management, Strategic Planning

Cross-Functional Team Leadership, Training, & Performance Management

Web Development, Client-server, & ERP Systems (PeopleSoft), Agile & Scrum Methodologies

Subject Matter Expert: PeopleSoft, PeopleTools, ORACLE migration and patching.

Client/Server, Object Oriented, and Windows/UNIX Technologies

Service Oriented Architecture Techniques, Structured Analysis/Design, Object Oriented Analysis/Design

Case Tools, Sybase and Oracle-stored Procedures, System Interfaces, Data Migration

Requirements Analysis, Project Scope/Planning, Budget Administration, End-to-End Project Execution

PROFESSIONAL EXPERIENCE

AUTOMATIVE MGMT SRVS INC, West Palm Beach, Florida, June 2021 – September 2023

Senior Software Engineer/ Business Analyst and BI Analyst

Support the Database Architect in designing/maintaining the Database Warehouse and Datamarts.

Developed complex stored procedures and Excel/VBA programs to validate the quality of the information.

Led and executed the migration of BI tools. From SiSense BI to Dundas.

Developed BI Projects in the marketing and advertising areas. Trained people to use the Dundas BI software.

Created a Decision Matrix to evaluate and lead the acquisition of a Business Intelligence tool for the company.

Created a Data Governance solution document for the company and led the software acquisition process.

Identified opportunities for automation to increase accuracy, reduce manual effort and accelerate decision making.

Established key performance indicators (KPIs) and metrics to track the success of process optimization initiatives.

Effectively communicates process changes to relevant teams and ensures smooth transition. Provided support and guidance to stakeholders during the implementation phase.

Designed and developed a utility tool to update numerous database lookup tables directly from Excel.

Fernando Morote Page Two

PROFESSIONAL EXPERIENCE

AMERIPRISE FINANCIAL USA, Minneapolis, Minnesota, June 2011 – May 2021

(World-leading financial planning company, the total workforce of is about 66,555 employees.)

Senior Software Engineer/Systems Analyst, June 2011 – May 2021

Responsible for applying business process knowledge and data analytics to develop, recommend and communicate timely, accurate, relevant, and actionable insights to support business decisions.

Partnered with business stakeholders to understand their requirements and assist in the development and deployment of dashboards, KPIs, visualizations, data stories, and solutions tailored to their needs.

Led the design and development of Business Analytics for different size projects and complexity using Tableau, Excel macros, SQL, PL/SQL, ORACLE and Access DB. It was integrated into SharePoint for better visualization and Security handling.

Examine analytics and metrics results, customer data/files to ensure cohesion of data collection; data profiling to determine and recognize anomalies.

Own the data development process end-to-end including business understanding, methodology, QA, and maintenance

Oversaw ongoing migration, patching and upgrades and technical manager of Peoplesoft (9.0, 9.1, 9.2) PeopleTools (8.51.15, 8.54.00, 8.56.06) and ORACLE (10.2, 11.2, 12.1). Led the annual failover and DR test. Achieved licensing security requirements compliance.

Optimized the end-user experience through performance testing, Gomez monitoring services, database health check reports, incident reports, response time, SLA (service level agreement), RTO and RPO.

Leading on-shore and off-shore Software Development Teams, directing the development, documentation, testing, and modification of new and existing software applications for small, medium, and large companies, and consistently meeting targeted budget, schedule, and project deliverables objectives.

Implemented end-to-end accountability systems, procedures, and protocols, streamlined operational processes, maximized cost-reduction opportunities, and increased execution efficiency and project value.

Consulted with business partners, defined/presented Best-in-Class technical solutions, developed architecture designs, evaluated/monitored project status and performance, and assured compliance with complex security and quality objectives.

Technical support (enhancements & bug fixing) to the PeopleSoft Modules: Accounts Payable, General Ledger, Asset Management and Project Costing.

Providing technical team and senior leader training in one-on-one and group settings, mentoring and educating team members on technical and security procedures and protocols, and newly evolving technologies and improving team technical competencies.

Collaborated with IBM, Oracle, and India-based vendor partners, troubleshot server and technical issues, performed root-cause analysis, strategized/implemented technical solutions, substantially reduced downtime, and mitigated organizational risk and loss.

Introduced and implemented database performance techniques to process large volume of data.

Leading a Data Center migration: architecture, infrastructure and systems.

INTERVAL INTERNATIONAL, INC. USA, Miami, Florida, 2000 - 2011

(Quality Vacation Exchange Network with 1900 resorts and 1.2 million member timeshare owners.)

SOA Technical Leader, 2009 - 2011

Led 35-person offshore and onshore Development Team, oversaw design, development, and testing of a web services Accounting & Finance System, integrated a smart architecture Finance PeopleSoft module interface, and achieved on-time, on-budget project deliverables objectives.

Managed numerous application deployment projects within Development, QA, and Production environments, monitored project progression, and assured compliance with targeted security and quality performance parameters.

Fernando Morote Page Three

PROFESSIONAL EXPERIENCE

Collaborated with business analyst, bridged project manager, database administrator, web-designer, and web-developer communications, analyzed/documented functional requirements, reported project and budget status to senior leaders, and successfully executed conversion of AS400 to a web-based functional system within 30 months.

Designed numerous web service applications to support the Membership Re-Architecture development project.

Transitioned flexible business rules into JEXEL software application, streamlined the accounting process, and assured regulatory compliance.

Designed and submitted complex financial reports to the Finance Department.

Utilized job scheduler, created an automated Batch Process, facilitated efficient data migration to PeopleSoft general ledger, and achieved department-wide recognition.

Technical Team Leader/PeopleSoft Developer, 2007 - 2008

Designed, developed, tested, and enhanced PeopleSoft HRMS System, utilized PeopleCode, Application Engine, SQR, and Crystal Reports tools, customized HR, Payroll, and Base Benefits modules, improved productivity, and achieved deliverables objectives and user satisfaction.

Developed numerous interface reports and facilitated data migration from PeopleSoft Financials to external and internal applications.

Assisted the team to migrate JD Edwards to PeopleSoft Financials.

Project Leader/Senior Web Developer, 2005 - 2007

Led Project Team, defined/interpreted business requirements, created technical documentation, designed and developed setup modules, and orchestrated the end-to-end launch of a travel marketing website.

Created web development specification standards, tools, and techniques, positioned the company for the introduction of a website development venue, and deployed a new profit stream.

Technical Team Leader/Senior Client Server Developer, 2000 - 2005

Led and technically supported Development Team, coordinated cross-functional team communications, and designed/developed Interval International (Resort Solutions) and Softbrand Co. (Portfolio) Electronic Data System interface.

Developed and deployed maintenance fees and numerous RS modules and enhanced Contract Administration Module and finance data processing.

Produced technical design documents, achieved on-time, on-budget project results, and exceeded user expectations.

Wrote and implemented stored procedures and functions, and improved calculation and informational accuracy, validity, and referential integrity. Designed and created a Reporting Engine.

ORIX AUSTRALIA PTY LTD (AUSTRALIA) Sydney, Australia, 1997 - 2000

(World-leading banking institution with 500 offices in 23 countries.)

Senior Consultant/Programmer/Analyst

Partnered with in-house Technical Team, developed, tested, and enhanced a Fleet Management System framework, and coordinated integration of customer acquisition, quoting, supply, maintenance, administration, disposal, and accounting modules.

Successfully supported ORIX and Sybase Australia joint venture initiative, delivered FMS project, and achieved high user satisfaction

Collaboratively managed Data Warehouse from Sybase System 10 to 11 conversion, rewrote SQR reports, wrote stored procedures, and accommodated database structure changes.

Technically supported FMS Team and junior programmers on "Object Cycle Manager", PowerBuilder, SQL programming, and SQR.

Fernando Morote Page Four

PROFESSIONAL EXPERIENCE

WESTERN SYDNEY AREA HEALTH SERVICE (WSAHS) Sydney, Australia, 1994 - 1997

(WSAHS Department of Health Unit with 56 community health centers, a dental school, and 8500 staff in 7 hospitals.)

Consultant/Programmer/Analyst

Directed development of Dental Area-Isation System, completed business analysis and functional design of Dental Realization System, created/submitted system prototype to end user, and successfully delivered on-time, on-budget project results.

Designed, developed, and implemented numerous small systems applications within targeted schedule and budget parameters.

AUSTRALIAN SECURITIES COMMISSION, Sydney, Australia, 1991 - 1994

(Securities service organization with 23 Australia-based offices.)

Project Advisor, Informational Technology

Consulted with clients, strategized/defined technical project requirements, implemented program packages, introduced ASC Revenue Subsystem and Intelligence Notation System, enhanced informational quality and data-capture programs, and improved productivity and the user experience.

Identified, registered, and eradicated system faults and reported results to project manager.

PETROPERU S.A., Lima, Peru, 1983 - 1990

(Peruvian national exploration, extraction, and petroleum refinement company with 12,000 personnel.)

Programmer Analyst

Developed an ON-LINE transportation system, integrated mechanized contractor registry, capital-asset, and investment-control capabilities, and reduced labor and operating costs.

Fernando Morote Page Five

EDUCATION

SAN MARCOS NATIONAL UNIVERSITY, Lima, Peru

Bachelor of Science Degree in Industrial Engineering

TECHNICAL SKILLS

Environments: UNIX, Windows, MS-DOS, MVS

Mainframe: MVS/COBOL, MANTIS, IDCAMS UTILITY, JCL, ROSCOE EDITOR

BI Software: Tableau, SiSense, Dundas BI

Software Languages: PeopleCode, Java/J2EE, JSP, Javascript, PowerBuilder V4/V10, SQR

V3/V4.1, PL-SQL, T-SQL.

Tools: Workday, PeopleSoft HR & Finance, Application Designer, People Code, Application Engine,

Component Interface, Integration Broker, PS/query, Crystal Reports, SQR, Process

Scheduler, Data Mover, Security Administration, SQA Suite, PTF (PeopleSoft),

SharePoint Designer.

Methodology: SPECTRUM, LBMS Systems Engineering, JAD, RAD, SDLC

Database Design: AppModeler for PowerBuilder, Rapid SQL, TOAD

Frameworks: PFC (client server) Spring (web development)

Web Editors: DreamWeaver Ultradev 4.0, Brio, Portal 6.0

Web Server: WebSphere, JSF, JBOSS, Apache, EAS (Jaguar)

Deployment: SVN, PVCS, Object Cycle Manager, Subversion

Management: Microsoft Project, ChangePoint Request, JIRA

DBMS: Oracle V8/XI, Adaptive Server Enterprise (SYBASE 10/11) Adaptive Server, MSSQL

Access DB

Contact this candidate