SUMMARY

• 9+ years of experience as Oracle PL/SQL,SQL, SAP HANA data model Developer in Analysis, Design and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).
• Experience in implementation and development of Argus safety at database level.
• Worked in Argus 8 upgrade and Japan adoption
• Application Support of critical issues on Argus Safety (Oracle) meeting the SLA and KPI of critical issues.
• Modification of configurable table to generate correct E2B reports to meet the regulatory requirements.
• Adding and modifying the CFG E2B queries to meet the requirement of FDA and EMEA.
• More than a year experience of working with SAP HANA data models. Building and implementing HANA calc views and models on IB data to integrate with REST API.
• Hands on experience in writing and analyzing complex SQL queries.
• Hands on experience in using SQL * PLUS, TOAD, SQL Developer.
• Exposure on Data Modelling and Normalization Techniques.
• Created Oracle Database objects such as Tables, Views, Synonyms, Indexes, Sequences, Triggers, Packages, Procedures and Functions.
• Effectively made use of few features like Analytical Functions, Aggregate Functions, Table Functions and Hierarchical Queries in SQL.
• Oracle Supplied Packages such as DBMS JOBS, DBMS SCHEDULER and UTL FILE.
• Implemented Types, Collections, PL/SQL Records, Global Temporary Tables, Bulk Collects, Parallel Processing, Hints, Indexes and Partitions for boosting the performance of existing processes.
• Optimized and tuned SQL and PL/SQL programs by examining EXPLAIN PLAN statistics.
• Performed DBA activities like CREATE USERS, GRANT ROLES and PRIVILEGES.
• CRONTAB, SPOOL, Materialized Views and DB links.
• Involved in writing interface programs for importing data from flat files into Oracle staging tables using SQL LOADER, External Table and UTL FILE.
• Managed large table processing by creating Partitions.
• Written PL/SQL programs using REFCURSORS, Dynamic SQL, XML types and Exception Handling.
• Used SVN/TFS and PVCS for version control of code during releases.
• Experience in working in Agile model of Software. Participated in daily Stand up Calls, Demos, Sprint Planning and Sprint Retrospective Meetings.

SOFTWARE SKILLS

Programming languages: PL/SQL, SQL, HANA SQL Script

Database: Oracle 11g, SAP HANA

Operating Systems: UNIX/LINUX.

Tools: Mcraft, Quality Center, TFS,HP ALM

SDLC: Agile

Tools: Argus Safety (Oracle tool for Pharmacovigilance reporting), SQL Developer, Toad, HANA Studio.

PROFESSIONAL EXPERIENCE

SAP HANA backend developer

Confidential, San Jose CA

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go - live and Post Go-live support.Worked in Agile and WaterFall Project management approaches.
• Managed Offshore and Onshore team model.
• Worked extensively on Data Modeling design like developing HANA Objects.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models
• Cooperated with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture
• Designed, Developed and Maintained HANA models by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
• Hierarchies are implemented to support drill down reports
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Monitoring and troubleshooting data loads

Database consultant

Confidential

Responsibilities:

• Analysis and resolution of live production issues in Argus and interfaces. This role also includes responsibility to track and manage multiple incidents and problem tickets on the application in service now.
• This role not only include support but also development of critical releases to fix production issue and incorporating new features. I was involved in making complex changes in configurable tables of E2B reports.
• I was also involved in modification of reporting rule queries and configuration of Product/License/Drugs as per business advice in the database level.

Confidential

Database developer

Responsibilities:

• Database developer for Lilly on pharmacovigilance interfaces. The role mostly includes developing interfaces like packages, triggers and email services for population and manipulation of clinical data based on client requirements.
• It also includes converting Linux interfaces into database schedulers and process. In this role, I have been involved in not only development but also debugging and analysis of critical issues.

Confidential

Scrum Team

Responsibilities:

• Details: Worked as a designer to develop the HLD for changes in Confidential due to change of custodian for SEI investment. This includes delivering the HLD after detailed analysis within strict agile timelines.

Confidential

Programmer analyst

Responsibilities:

• SEI investment in building and maintaining a Global Wealth Management Platform that supports security trade, security administration, and corporate action for US and UK clients.
• I worked in change request like income tax and backup withholding for US and UK instance. This includes implementation of PAYUP and PAYDOWN CA in US and UK markets on asset backed instruments.
• The job involved requirement gathering, analyzing, designing the high-level documents, making the low-level documents, coding and unit testing. My job was to convert QPP code to Pl/SQL procedures.