SUMMARY:

Senior architect with over 14 years of diverse experience in Software Development Lifecycle (SDLC), Enterprise Systems Architecture, Implementing Cloudera Big Data solution, Machine Learning, Database Design, Architecture, Performance Tuning, Oracle EBS suite (11i,R12), PLSQL Development, and Enterprise Reporting in Financial, retail, Manufacturing, and Utilities industries.

EXPERTISE:

• Big Data Ecosystems: Hadoop, Map Reduce, HDFS, HBase, Hive, Pig, Sqoop, Impala, Apache Spark, Scala.
• Database Architecture/Design
• Database Performance Tuning
• BI/Enterprise Reporting
• Database/Data Warehouse Development
• Oracle EBS Developer (Financials, Manufacturing, Inventory)
• PLSQL Development
• UNIX Shell Scripting

EXPERIENCE:

Confidential, New York

Consultant Big Data, Hadoop, Oracle - Dev Ops

Responsibilities:

• Responsible in gathering requirements from users and designing Use cases, Technical Design and Implementation.
• Developed data models, algorithms, and back-end services to implement machine-learning solution for back office IT.
• Responsible to deliver end-to-end solution, i.e. ingesting raw data, transformation, model training and generating prediction using Cloudera big data ecosystem (hadoop, sqoop, spark, scala, hive, impala etc.).
• Understanding the data nature from different OLTP systems and designing the injection processes for HDFS
• POC with Spark Data Frames (SQL) and Spark Machine Learning: Implementation of Proof Of Concepts with Spark Data Frames and SQL, and Spark Machine Learning (by using objects like Transformer and Estimator for Pipelines, Evaluator, Cross Validator). Developments by using ML algorithms like the Linear and Logistic Regressions, Random Forest and Gradient Boosted Machine.
• Developed various Spark scripts by using Scala as per the business requirement.
• Responsible for designing and developing data pipeline solution from various sources (File, MySql, oracle) to Data Lake.
• Involved creating/designing Hive tables, and loading and analyzing data using hive queries
• Developed Hive queries to process the data and generate the data cubes for visualizing
• Implemented Partitioning, Dynamic Partitions, Buckets in HIVE.

Tools: Cloudera Ecosystem, Hadoop, HDFS, SQOOP, Scala, Apache Spark, SBT, Impala, PIG, Hive, HBASE, Oracle 10g,11,, PLSQL, Linux Shell scripting, ControlM scheduler.

Confidential

Sr. Oracle Application Developer

Responsibilities:

• Responsible to develop/support and implementation of multiple applications - Oracle Financial 11i, R12, IBM MDM, Direct-Tech, Itrade…etc.
• Responsible for development and delivery of Conversion/Interface programs for Items, Item Costs, BOMs
• Worked on various EBS development/customization projects as per business requirement.
• Developed interface to get the Customer Details and Receivable Invoices from the legacy system to Oracle Accounts Receivables (AR).
• Lead the oracle hardware upgrade project (Solaris to Linux migration).
• Design and develop the architect of stage area to support various incoming/outgoing interfaces.
• Create and maintain service requests with Oracle with regards to various functional bugs, patches etc., Updating them with the required info and follow up for a faster response.
• Create custom menus, responsibilities, request groups, functions etc., set up of the various profile and security options to align with the security policies of the company.
• Creation of value sets, setting up key and descriptive flex fields as per the functional requirements.
• Developed and support the existing Batch process. Interact on a regular basis with users/ Functional team in getting/understanding the business requirements, estimate time, allocate tasks to offshore and coordinate with the project.

Tools: Oracle E-business Suite 11i, R12, AOL, Forms/Reports 6i, Oracle 10g, 11i, BI Publisher, Java, IBM MDM, Informatica, Power Center, Amazon AWS, Redshift, PostgreSQL, JavaScript, XML, XSL, XPath, SOAP, Web Services, Unix.

Confidential, New york, NY

Sr. Database Architect/ Developer

Responsibilities:

• Architectural design, development & production support of mission-critical financial applications for Back office IT operation.
• Design and Developed ETL process to source the trade data from various legacy systems.
• Design and Developed the adjustment accounting engine for daily/intra day adjustments.
• Develop various Oracle PLSQL package, procedure and Unix shell script as per business requirement.
• Design, develop and setup the ARE (Accounting Rule Engine) process to improve data quality and to automate to apply accounting rules to inbound data feeds.
• Designed the DB architecture and developed the application to integrate business requirement for partner*s trade data * which is to create Trial Balance Record and to calculate and publish daily, monthly and yearly P&L statement.
• Successfully implemented the partitioning and sub partitioning methodologies to store and process high volume data in optimized fashion.
• Troubleshoot problems in real time with high-pressure and ensure production support 24*7.
• Resolving DB performance issue and providing recommendation for application tuning.

Tools: Oracle 10g, 11i, Informatica, Linux Shell scripts, BI Publisher, TOAD, Control M job.

Confidential

Sr. Oracle Application Developer

Responsibilities:

• Responsible to develop/support and implementation of multiple applications - Oracle Financial 11i, R12, IBM MDM, Direct-Tech, Itrade…etc.
• Worked on Auto Invoice Conversion Program to validate, load credit memos, debit memos and invoices from legacy system.
• Developed new program in PL/SQL and Modified old programs for Payables Open Interface (AP) to import invoices from two different sources. Created new custom tables, Procedures, Value sets, Sequences etc., for this process. Utilized FND REQUEST API to submit concurrent programs from PL/SQL programs
• Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.
• Created custom packages to return the Order Status on an hourly basis to an indirect customer and on a daily basis to a direct customer and attached them to the concurrent programs.
• Created packages to fetch the item availability status and item price on a requirement basis.
• Created PL/SQL procedure to copy the given drop ship sales order to Standard sales order and to create the ship sets for the standard order.
• Created a database trigger to populate purchase orders descriptive flex field with drop ship order number and legacy system order number if the purchase order is a drop ship purchase order.
• Identified, demonstrated and documented Order Entry, drop shipments, Internal Orders, RMAs.
• Extensively worked on GL, AP, AR and Fixed Assets modules in automating the closing process.
• Defined the descriptive flex fields on Sales orders and Invoices to facilitate additional information
• Used SQL *Loader and UTL FILE Packages for data conversion and interfaces.
• Wrote UNIX Shell Scripts for coping and moving files to and from the server.

Tools: Oracle E-business Suite 11i, R12, AOL, Forms/Reports 6i, Oracle 10g, 11i, BI Publisher, Java, IBM MDM, Informatica, Power Center, JavaScript, XML, XSL, XPath, SOAP, Web Services, Unix.

Confidential

Data Warehouse Architect/ Developer

Responsibilities:

• Design, developed and implement an enterprise Data Warehouse for collection application.
• Designed a three tier based Data Warehouse architecture including Database partitioning strategies.
• Performed Vendor Product evaluation and Selection for: Data Extraction and Transformation Tools, Meta Data Tools, Database (DBMS), DSS OLAP tools (Product analysis included the World Wide Web/Internet Interfaces).
• Created the Data Warehouse Data Model to store atomic level data and the summarized data.
• Performed Dimensional Data modeling and created Star Schema and Snow Flakes Schema data model to meet the OLAP needs.
• Created a Prototype data warehouse and provided the OLAP front end to show the Drill Down, Roll ups, Pivoting, Slice and Dice features.
• Created the Design for Extraction process from legacy systems using combined techniques of Data Replication and Change Data Capture.
• Created the Sample Meta Data from perspective of technical and business users.

Tools: Oracle 10g, 11i, Informatica, Oracle Warehouse builder, Linux Shell scripts, BI Publisher, TOAD, Control M job.

Confidential, Mineola, NY

Sr. Enterprise Application Developer/Data Architect

Responsibilities:

• Responsible to develop/support and implementation of - Oracle Financial EBS suite R12.
• Worked on various EBS development/customization projects as per business requirement.
• Design and develop the architect of stage area to support various incoming/outgoing interfaces.
• Create and maintain service requests with Oracle with regards to various functional bugs, patches etc., Updating them with the required info and follow up for a faster response.
• Create custom menus, responsibilities, request groups, functions etc., set up of the various profile and security options to align with the security policies of the company.
• Creation of value sets, setting up key and descriptive flex fields as per the functional requirements.
• Developed and support the existing Batch process. Interact on a regular basis with users/ Functional team in getting/understanding the business requirements, estimate time, allocate tasks to offshore and coordinate with the project.

Tools: Oracle E-business Suite 11i, R12, AOL, Forms/Reports 6i, Oracle 10g, 11i, BI Publisher, JavaScript, XML, XSL, XPath, Unix.

Confidential

Sr. Software Engineer

Responsibilities:

• Responsible to develop/support and implementation of - Oracle Financial EBS suite 11i.
• Used custom SQL*loader program to load the invoices from other accounting systems to payables staging tables.
• Developed several Procedures and Database Triggers as per Business requirement.
• Imported Items from legacy system into Oracle Inventory base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed PO interface to import Purchase Orders from legacy systems.
• Customer & Invoice data Conversion from Legacy System into Oracle Account Receivables (AR) by using Customer and Auto Invoice interface.
• Developed GL Interface for importing journals from legacy systems into GL INTERFACE table.
• Conducted Interface Testing (Customer Interface and Auto Invoice in AR, Order Import in OM) of application and reported the defects to the development team.
• Used seeded Oracle interface programs (Import Standard Purchase Orders and Receiving Transaction Processor) to create new POs and receipts.
• Developed interface to update On Hand Quantity for the items upon receiving Shipment Receipt.
• Worked on XML/BI Publisher bursting to send PDF reports via email.
• Created an RTF template with XSL equivalents to group data as of date placed in service and registered to Template definition.
• Developed various reports based on the business requirements in AP, AR, and GL modules.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Analysis of customer reported issues, which could be a code issues, data fix issue, performance issue.

Environment: Oracle Applications 11I, Unix, SQL*Plus, PL/SQL, TOAD, Reports 9i, Forms 9i, XML/BI Publisher, SQL*Loader.

Confidential

Software Engineer

Responsibilities:

• Design and developed the lending application (FinnOne) using oracle forms/reports.
• Developed various PL/SQL Packages, Procedures and Functions accordance with Business Requirements.
• Created Materialized Views and partitioning tables for performance reasons.
• Development of forms/reports using Oracle 6i and 10g.
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Created Materialized Views and partitioning tables for performance reasons.

Tools: Oracle 10g, PL/SQL, Oracle Forms, Reports 6i, 10g, UNIX, SQL*Loader, Toad, Explain plan.