Principal Software Engineer Resume

SUMMARY

Analytical information technology professional with 15+ years of hands - on experience in writing Sybase, Oracle, MS SQL database SQL scripts, stored procedures and triggers SQR, Unix Shell and Perl scripts.
Experienced in entire system life cycle including System Analysis, Design,
Programming, Testing, Debugging and Query Optimization, User Support and Maintenance of client/server based applications.
Developed and maintain 850+ Sybase/Oracle SQL, Stored procedures and triggers, 275+ Shell and 325+ Perl scripts for various Confidential internal 65+ projects.
In-depth knowledge in SAP Business Objects Data Services (BODS/BODI) ETL tool.
Experience in design, configuration, implementation and maintenance of security solutions for entire SAP ERP suite (R/3, BO, BODS, BPC).

TECHNICAL SKILLS

Database: Sybase 10.x/11.x/12 .x, Oracle 10g/11g, MS SQL Server, Vertica DB, ETL, AB Initio, SAP BODS/BODI, Informatica 9.x

OS: Unix, Linux Solaris, SunOS, Windows NT

Languages: SQL, T-SQL, PL/SQL, SQR, Db library/C, PERL, Shell, Stored Procedure and Triggers.

ERP: SAP R/3 ENTERPRISE 4.7, ECC 6.0, BO 4.1, BPC 10.1 HANA, Enterprise Portal 7.31.

Scheduler: Cron job, Autosys

DB Tool: DBArtisan, TOAD, SQL Developer

PROFESSIONAL EXPERIENCE

Principal Software Engineer

Confidential

Responsibilities:

SQL and Stored Procedure optimization by analyzing query plan.
Physical and logical data modeling.
Developed and maintain 850+ Sybase/Oracle SQL, Stored Procedures and triggers, 275
Extract data from Confidential data warehouse systems Netezza using Ab Initio and load into Confidential finance systems for retail store royalty and bounty tracking systems running on Sybase.
Wrote SQL, PERL and Unix script to extract data from Sybase database and create text file to load into SAP systems during Confidential financial systems migration.
setup and configure SAP BODS/BODI central and local repository in Oracle DB.
Extract data from SAP R3 tables, transform and load into Oracle database using SAP Business Objects Data Services (BODS/BODI) tool for SAP Business Partner (BP) data cleansing.
Extract data from SAP R3 tables, transform and load into Oracle database using SAP Business Objects Data Services (BODS/BODI) tool for SAP to oracle finance system data migration.
Successfully led the complete Confidential ’s complex ERP landscape SAP security redesign for international rollout.
Developed and configure security roles and user authorization for SAP BPC and BO project.
Collaborate with Confidential IT Security team for SAP security technical support and troubleshooting production problems.
Strong interpersonal skills with the ability to work with diverse teams across organizational lines and structures.
Ability to learn new tools quickly and excellent troubleshooting skills.