Jorge Ortiz Email & Phone Number

Lexington, Massachusetts, United States

Lead Global Commercial data lake projects. Manage the design, implementation, deployment and maintenance of data flows to support analytics, reports and AI algorithms. Responsible for the quality control framework. Manage stakeholder's engagements and relationships across commercial functions. Partner with functional teams to define and maintain KPI and to support a consistent data management process. Lead the technical design and engineering to support commercial operations, field sales teams, sales compensation, sales force alignment, contract and pricing and finance organizations.

Bannockburn Illinois

Design, implement and support advanced and diverse application and data management solutions to address complex business requirements. Provide data and solution architecture expertise and leadership for application developers on all system development activities. Evaluate and recommend innovative and valuable products and systems solutions to drive analytics and business intelligence efforts for Takeda's commercial organization.

Deerfield, Il Usa

Data warehouse architect for human resources business intelligence function. Responsible over the entire BI work stream including: Data architecture/ Data Modeling and ETL development. Developed an integrated data warehouse solution from PeopleSoft (HRMS), employee benefits and Taleo talent management systems.

Deerfield, Il Usa

Project manager leading the implementation of Microsoft 365 SharePoint.

Project Management - Responsible for the administration of multiple IT projects. Accountability of the budget administration, resource allocation and successful completion of the project goals with the use of SDLC and Lean Six Sigma techniques. Experience with validated systems (ISOtrain) with a role of Validation Lead and Technical Representative.Business Intelligence – Development of the ETL (Decision Stream/ IBM Data Stage) batch coding, knowledge framework design, data structures/ architecture, data flow documentation, data designs/ proposals, advance report creation using ReportNet-Cognos, in charge of presenting data schemas to functional team. Integration of multiple applications in one database instance: BrassRing, JD Edwards, HRMS-PeopleSoft, WeComply and others.Programmer responsibilities: Administration and development of employee information services systems. Responsible for the coding in HRMS-PeopleSoft tools, SQL, PL/SQL, SQR (Batch) and UNIX/Oracle server administration.PeopleSoft 9.1 - HRMS upgrade - Security and data migration Technical Lead.

BI developer. Experience with Cognos Reports, Decision Stream (ETL), Data Manager and Cognos framework administration.

PeopleSoft HRMS application developer. Author compensation and employee benefits systems.