Senior Software Engineer Resume
San Francisco, Ca
SUMMARY:
- Adept at designing applications that support internal and external organizational processes.
- Expert in all facets of product development life cycle from analysis and design through development, implementation and documentation.
- Employ problem solving and communication skills to partner with non - technical audiences in delivering full scale IT solutions.
TECHNICAL SKILLS:
Databases: Oracle RAC 12c, 11g, 10g, Sybase 15.7, MySQL 5.5
BigData: HDFS, Hadoop, Spark, Map Reduce, Hive, Pig
Operating Systems: Sun Solaris, Linux ES, MS WINDOWS, UNIX
Languages: SQL, PL/SQL, C, C#, Python, HTML, XML
Version Control: Git, SubVersion, Rational Clearcase
Case Tools: ERWIN 9.0, 4.1, Case Studio and Designer 2000
ETL Tools: Ab Initio GDE,Co>OpSys 3.1.7, Informatica Power Center 7.1
Utilities: Oracle Enterprise Manager, Data pump, SQL*Loader, PL/SQL, TOAD, Sql Developer, DB Artisan
PROFESSIONAL EXPERIENCE:
Confidential,San Francisco,CA
Senior Software Engineer
Environment: Oracle RAC 12c, 11g Databases on Sun Solaris, Shell scripting, PL/SQL, C#, ERWIN 9.0, Oracle Utilities, DBArtisan 2016, SubVersion, Git.
Responsibilities:- Completed business requirements analysis, including evaluation of systems specifications, actualizing content ingestion sets 2 weeks ahead of deadline.
- Increased revenues 5% by developing content ingestion process for portfolio analytics proprietary data module, including cost estimation and revenue generation.
- Improved existing PL/SQL stored procedures performance 10 times by utilizing oracle tuning features like bulk SQL and binding, result caching, optimizer hints, and batch updates.
- Increased C# backend database access performance 5 times by applying ODP.Net tuning methods, including batching, collections, ref cursors and multiple active result sets.
- Analyzed and monitored application performance using various oracle tools like ASH, AWR reports, identifying bottlenecks and implemented solutions, and improving application performance.
- Improved productivity by training offshore developers to come up to speed with existing code base and mentored to write efficient PL / SQL procedures and SQLs.
- Participated as level 4 support, troubleshooting problems, providing workarounds and producing patches for customers as required.
- Served as active participant in Agile Scrum sprint planning, sprint testing, demonstrations and retrospectives and solution releases.
Confidential,San Jose,CA
Database Engineer
Environment: Oracle 9i Database on Sun Solaris, Oracle Utilities, Import, Export, SQL*Loader, PL/SQL, Informatica Power Center, Business Objects 6.5, FTP and ERWIN.
Responsibilities:- Developed and implemented generic data rights module, protecting hospital member data rights within pharmacy reports provided to manufacturers.
- Created software design specifications and deployment guides and contributed to functional design specifications.
- Integrated 3 rd -party external procedures with Informatica mappings, achieving better data cleansing.
- Implemented database partitioning, dbms job routines, analytical queries and parallel queries, improving performance of existing backend processes.
- Improved performance of database queries by analyzing EXPLAIN PLAN, TKPROF.