SUMMARY

• 11+ years of IT experience in design and development in Oracle, SAP HANA, Teradata, Big Data, Axiom SL
• Experience in creating PL/SQL objects such as Stored Procedures, Functions, Packages, Triggers in Oracle
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes
• Experience in building regulatory reports on Axiom Controller View
• Experience in Performance Tuning for Oracle RDBMS using Explain Plan and Hints
• Experience in designing and developing Attribute, Analytic and Calculation views in HANA with table functions, counters, private and calculated measures, input parameters, filters.
• Good knowledge of creating PL/SQL procedures and triggers in HANA and debugging using SQL script debugger and tracing
• Experience in creating user, roles and assigning the privileges in HANA
• Extensive knowledge of Teradata Utilities such as B - TEQ, Fast Load, MultiLoad, FastExport
• Proficient in developing optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
• Intermediate level knowledge of Unix Shell Scripting and scripting in PERL
• Intermediate level knowledge of Regression Analysis using R
• Worked in both Agile and Waterfall models
• Involved in all phases of the SDLC from analysis, design, development, testing, implementation, maintenance and support.
• Demonstrated excellence in understanding customer's business needs and translating them into effective solutions that improve processes, increase productivity and reduce costs

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Axiom Developer

Responsibilities:

• Created data sources, developed data models, portfolios, aggregations
• Built tabular and free forms as per requirements
• Participated in migration of Axiom components within environments
• Automated program workflows
• Created Unix shell scripts to schedule workflows and for file management

Confidential, New York

Lead PL/SQL Developer

Responsibilities:

• Designed solutions to generate management information reports on Anti-financial crimes
• Gathered and analyzed requirements from Business users
• Designed components to transform data in Actimize to store in Oracle 12c and Hadoop and use in Tableau reports
• Acted as team lead for team of developers who worked on Actimize, Oracle, Hadoop and Tableau
• Interacted with vendors and data sources to coordinate the project activities
• Maintained project artifacts in JAMA, Sharepoint and JIRA

Confidential

Lead PL/SQL Developer in HANA

Responsibilities:

• Responsible for end to end delivery of dashboards on manufacturing analytics for daily production analysis, planning and defect prevention
• Led team comprising of UI, Java and HANA developers, representing team in business discussions, meetings on sprint planning and backlog grooming
• Converted stories to technical designs and made estimates for fortnightly deliveries
• Modeled attribute views in SAP HANA to represent dimensions and their relations
• Designed and developed Attribute and Analytical views in HANA to create production analysis reports such as Linearity measurement, Sequencing, Defects per machine
• Designed and developed Calculation views to be used in Inventory planning reports
• Did performance tuning on existing calculation views
• Managed user and role creation and privileges
• Engaged in discussions with business to understand requirements, develop stories and create sprint plans
• Manage sprint execution of the team in Rally
• Mentor new team members

Confidential

PL/SQL Developer

Responsibilities:

• Worked with Users to understand Business requirements
• Prepared High level Designs for the requirements
• Collaborated with offshore team to create detailed design and delivery plans
• Designed and built stored procedures that calculates the commission to be given to insurance planners based on the number, frequency of new business the planner brought and the type of policies - implemented on Oracle 11g and Unix
• Developed Package in Oracle 11g that has functions and procedures to track movement of customers from an existing policy to a new policy
• Performance tuning on procedures and functions that find and extract details of lost customers and unclaimed policies for bi-yearly Taxation Office reports
• Designed data model with dimensions and facts required to calculate Net Promoter Score. Built packages containing procedures to transform customer survey and feedback logs from call centers to generate customer satisfaction reports.

Confidential

PL/SQL Developer

Responsibilities:

• MFP - Enhanced Merchandise financial planning packages in Oracle to compare in-season performance against approved plans and tuned existing procedures.
• Buy Planning - Developed data warehouse architecture for buy planning based on suppliers and assortment plans - implemented in Oracle 11g, Teradata 12
• Single page facts - Designed and Developed solution to bring Purchase order, Receipts and Sales-Returns to same fact level - implemented on Teradata 12
• Agile Report Requests - Designed, developed packages, procedures and functions to support number of agile requests such as sales trend, marketing effectiveness, customer choices, store performance, resource management - implemented in Oracle 11g, Teradata 12
• Receipt Flow - Performance tuning of Pro*C modules in receipt flow from RMS to Data Mart.
• Created and modified Unix Shell scripts to connect to a single server to use Syncsort instead of installing Syncsort on all servers.