SUMMARY:

• Accomplished professional with over 10 years of experience in IT.
• SAP Certified Application Associate SAP HANA 2.0 (SPS03).
• Proficient in data warehousing dimensional data modelling, data analysis, discovery and profiling.
• Strong knowledge of Oracle database 12c/11g/10g/9i and Oracle ERP R12 (OM & AP) products.
• 5+ years of experience in SAP Application design, architecture and integration.
• In - depth knowledge of SAP HANA Database, SAP Cloud Environment (XSA), APIs, Web IDE, GIT & Odata.
• Strong analytical writing & research skills, developing processes and standards to ensure consistency in quality.
• Demonstrated ability to optimize business models & processes with automated technical solutions.
• Analyzes impacts of solution designs and provide suggestions for optimization and mitigation. Attuned to both Agile & Waterfall project development life cycle.

TECHNICAL SKILLS:

Technology and Tools: SAP HANA SAP Business Objects SQL & DB Tuning OEM 12c SAP BW RAC Tuning Toad Data Modeler - ER Oracle PL/SQL 12c/9i/10G/11G Oracle ERP AP, OM, BOM, INV, AOL/FND (11i & R12) Basics of Perl Scripting Basics of Unix Shell, Linux Version control tool PVCS, SVN, TFS Deployment Control Tool HP PPM Kintana Oracle Forms 6i & 10g Agile Tool Rally ETL Using Informatica Certified by Cisco on multiple occasions for quality and excellence in various projects on Oracle & SAP databases. Acknowledged for optimizing long running processes to near real time/real time. Part of engineering excellence team for tuning SAP HANA & Oracle DB & SQLs. Developed self-service tools like doctor db, db cure & app db deployment tool.

PROFESSIONAL EXPERIENCE:

Sr. Data Modeler, Developer

Confidential

Responsibilities:

• A data warehouse project, which deals with business analytics of Cisco’s global sales using various BI techniques.
• Design, document and maintain overall architecture of data warehouse architeture. Research and recommend architectural solutions and establish SAP functional roadmap.
• Provide guidelines on integration solutions in SAP cloud platforms and SAP On-Premise environments with new acquisitions’ SAP/Non-SAP environments.
• Transform business requirements in conceptual, logical and technical solutions as per best architecture standards.
• Create optimal physical data models for high performance reporting from Oracle and SAP Hana databases.
• Set guidelines and governing principles for solution designs, development and testing to ensure quality deliverables and low impacts.
• Review existing and emerging technologies to ensure an up-to-date optimal business design and models. Preside technical code review meetings with development technical leads.
• Recommend solutions for maintenance, upgrade, enhancement and troubleshooting SAP applications.
• Develop easy on-boarding playbooks for new hires or new members of the SAP team.

Environment: Oracle, SAP HANA, SAP HANA Data Services, SAP HANA BO, Teradata, Informatica.

Sr. Oracle ERP Developer

Confidential

Responsibilities:

• Cisco Commerce Workspace is an e-commerce, web-based, streamlined qualification and approval experience for partner initiated standard deals, contractual discounts, and pricing letters in telecom domain.
• Designed and developed custom ERP applications and solutions to meet customer’s business requirements.
• Tuned DB, PL/SQL & SQL coded long running processes to reduce overall new product initiation time.
• Developed optimal physical & logical data models in Oracle using ERWIN. Created application architecture and technical design to best-fit customer’s business needs.
• Led code reviews in the team to ensure industry standard coding practices.
• Interacted with key business stakeholders to understand the requirements and translate it into efficient technical design.
• Created technical solutions to a pre-defined requirement and developed components including extensions, views, customizations, modifications, reports, and workflows independently or as a part of a team.
• Developed reusable code components like delta capture mechanisms, session monitoring and management, SQL query and code analyzer for tuning and optimization.

Environment: Oracle Database 12c/11g, Oracle EMB R12 OM & AP (Advanced Pricing) Windows 10, UNIX, SQL Developer, Toad, XML, SQL, PLSQL, UNIX Scripting.

Assistant Systems Engineer

Confidential

Responsibilities:

• Developed new and custom Oracle forms screens for various business requirements. Wrote various database artefacts like packages, functions, procedures, triggers, workflows to implement business requirements.
• Created and maintained detailed technical specification documents, playbooks and manuals for new developers.
• Coded, tested, and analysed software programs and applications. Researched, documented, and modified software and specifications throughout the system development life cycle.
• Involved in developing Extraction - Transformation-Loading (ETL) process, using SQL*Loader and PL/SQL package UTL FILE.
• Tuned existing Oracle packages, SQL queries and provided optimal and robust technical solutions.
• Participated in all phases of development lifecycle including requirement gathering, technical solution designing, testing and support. Used ERWIN to develop logical and physical database models.

Environment: Oracle 9i, Oracle Forms 6i, Oracle Reports 6i, Perl Scripting, PL/SQL TOAD, UNIX.