Data Sap

Carlos Navas

516-***-**** Mobile *** Cameron Ave Merrick NY 11566 ******@*****.***

Principal Technical Architect (Hands On )

Skilled principal software/data architect with versatile expertise with ERP

implementation, SAP development and Enterprise System Integration

- Accomplished software/data developer vast experience in developing

software solutions across distributed systems and database management,

with broad skill in SAP and ERP systems for FDA-regulated environments.

- Comprehensive technical ability in business and systems analysis,

solutions design and process/strategy alignment, bringing efficiency,

ease-of-use and streamlined coding to business-critical tools.

- Strong team leader, able to drive consensus in cross-functional

initiatives, bring unity to conflict and achieve synergy for maximum

productivity.

- Well-versed in written and oral communication from documentation,

reporting and facilitation of projects, meetings and negotiations.

Technical Expertise

Data Modeler System Integration Systems Analysis

ETL

Database Management SAP CRM Web Applications SDLC

Process Improvement SAP BI/BW SAP ECC

ERP Implementation

Vendor Management Remedy MS Office

Technical SKILLS

Languages: Oracle PL/SQL, SQL, ABAP/4, LSMW, ASP, Java,

ASP.NET, JavaScript, VBScript, HTML,XML,VBA, Perl,

Linux/Unix Shell,KSH, C

Operating Systems: Linux 3.13.6, AIX, (Solaris HP) UNIX, Windows

Databases: Oracle 12g, SQL Server 2000/2005/2008,

Informix

Software: OracleHome11.2, TOAD for Oracle, Erwin Data

Modeler, ALM HP QA

Informatica PowerCenter 9.5.1, BODS, SQL server

Management Studio, SSIS, SSRS, SAP CRM 7.0, SAP

CRM 4.0,SQL Server Business Intelligence Development

Studio, Open Text/MetaStorm BPM, Visual Studio 2010, SAP ECC,,SAP BI/BW,

Veeva

Career History

Mandel Architects

Principal Technical Architect - Systems/Data Architect - Support

Wellington Park NY May 2014 - Present

Serves as the subject-matter expert in gathering and identifying system and

integration requirements and translating findings into software solutions

with comprehensive system design documentation.

< Worked extensively on PL/SQL as part of the process to develop several

scripts to handle different scenarios

< Used Informatica Power Center for extraction, transformation and load

(ETL) data to production environments

< Extensively used Informatica debugger to figure out the problems in

mapping. Also involved in troubleshooting existing ETL bugs.

< Developed Complex database objects like Stored Procedures, Functions,

Packages and Triggers using SQL and PL/SQL.

< Analyzed the business requirements and functional specifications.

< Extracted data from oracle database and spreadsheets and staged into a

single place and applied business logic to load them in the central

oracle database.

< Manage all phases of the software development lifecycle (SDLC) for

multiple custom solution

< Provide support in database architecture of the organization through

database design, modeling and implementation

< Develop and implement strategies, policies and standards for data

architecture in the enterprise

< Involve in data cleaning procedure by removing old, corrupted or

irrelevant data in consultation with the teams

< Instrumental in the initiation of an Enterprise-wide, integrative

approach to data analysis and data modeling for share ability in

relational database OLTP application environments. Used the CA/ERWIN,

Quest/TOAD; Oracle RDBMS data modeling tool.

< Use database design and database modeling concepts to ensure data

accessibility and security

< Coordinated with development managers / project managers to identify

appropriate scope of testing required for a project and managing the

overall testing activities for projects.

< Validated data integration by developing and executing test plans and

scenarios including data design, tool design, data extract/transform,

networks, and hardware.

< Used Reverse Engineering approach to redefine entities, relationships

and attributes in the data model as per new specifications in Erwin

after analyzing the database systems currently in use

Forest Laboratories Inc

Principal Technical Architect - CRM Implementations Commack, NY Jan

2005 - March 2014

< Managed SAP CRM Master and transactional data integration with Veeva(

SalesForce.com) CRM

< Two full life cycles CRM implementation experience using ASAP

Methodology ( Business Blue Printing, Realization, Testing, Go

live/Support )

< Interacted with business partners to understand the AS-IS process and

work on developing TO-BE process.

< Developed implementations RICEF objects with emphasis on extensions and

interfaces.

< Implemented SAP CRM 4.0 and SAP 7.0 systems with emphasis on middleware

and SAP Basis Tools to configure middleware with the admin console

transaction code for replication, realignment, subscription and

publication.

< Maintained team accomplishments by communicating essential

information; coordinating actions; obtaining expert input; reviewing

open issues and action items; contributing information to team meetings

and reports; transferring knowledge of data integration process,

techniques, and issues to application and support teams.

< Developed SQL code to push data to Aggregate Spend Repository landing

tables and created SQL scripts to identify system exceptions; extracted

data loads using TOAD and LSMW reports.

< Configured and coordinated complex quarterly realignment process,

which involved the collaboration between the sales administration, CRM

and Business Intelligence (BI) departments to load files for targeted

account into CRM systems to be synchronized into the sales

representatives' hardware.

< Leveraged SAP ABAP/4 development in CRM modules for conversions,

interfaces and initial data loads using the Legacy Systems Migration

Workbench (LSMW SAP Idocs) for Sales Activities and Business Partners.

< Executed data conversion and migration using LSMW; developed and

modified reports, user exits, batch job monitoring program and

enhancements to existing programs.

< Built complex system architecture using new and existing methodologies

to ensure productivity/success.

< Partnered with business customers to identify needs and assist in

collecting, documenting and analyzing business requirements and process

workflows

< Development of test plans ( data, integration, functionality, UAT)

< Analyzed current business processes and devised solutions for process

problems; recommended process improvement options and led system change

management.

< Provided production system support for related technical issues

including, but not limited to, solving problem reports, developing new

requirements and applying OSS notes.

< Provided knowledge transfer and training and documentation on

middleware and CRM modules to in-house team members.

< Detected and resolved issues and performed root cause analysis of

problems to propose alternative

options.

< Assisted Business Analysts and Developers to interpret and implement

business rules into Transact SQL queries on Microsoft SQL Server 2000

database

< Evaluated Transact-SQL Stored Procedure code for potential pitfalls

< Assisted development staff to convert Oracle/PL-SQL code into Transact-

SQL Code

< Validated data integration by developing and executing test plans and

scenarios including data design, tool design, data extract/transform,

networks, and hardware.

]

Project Leader/Web Development - Intranet/internet Applications

Commack, NY 1997 - 2005

Developed multiple intranet/internet applications using ASP, HTML, .Net and

Javascript; recognized and promoted for quality, breadth of knowledge and

versatility.

Education and Training

BS in Computer Science - State University of New York, Old Westbury,

Westbury, NY

Other Skill

Languages: Spanish

salesforce.com

Contact this candidate