SUMMARY

• 10+ years of experience in Complete Software Development Life Cycle including Analysis/Planning, Design, Development, Testing and Implementation of retail applications
• Expertise in Oracle PL/SQL, Data stage/ODI ETL, Netezza, Unix shell scripting, VB.net, VB, VBA and Hadoop
• Backend expert with 10+ years of experience using Oracle, PL/SQL, Netezza and SQL Server
• Leading the whole backend related changes for extract utility and providing design for the implementation
• Involved in High level estimation and Project charter preparation
• Analyzed Functional Specification documents and prepared Process flow, Technical Specification design documents and Test cases documents
• Worked closely with Architects, Business Systems Analysts and Testing Teams
• Involved in writing SQL, SQL Loader, NZSQL, NZLOAD, External table, UNIX shell scripts, stored procedures and functions, zip utility, FTP, SFTP, MFT for extract utility
• Experience in Dimension Data modeling concepts like Star Join Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling
• Involved in identifying Bottlenecks in backend processes and involved in performance tuning of the production application using Query tuning, Index, parallel hint, collect statistics, Identify and rewrite complex queries
• Experience in onsite - offshore Model
• Experience in agile software development
• Hands on proficiency in Oracle, PL/SQL, Netezza, SQL Server, Oracle Data Integrator and Shell Scripting, Visual basic, Visual basic.NET, Macro VBA.
• working on Hadoop extract migration, Good Exposure using Hadoop ECO System, Hive, Scoop and importing and exporting data using Sqoop from HDFS to Relational Database Systems
• Experience in Aginity Workbench for PureData System for Analytics and Oracle development tools such as PL/SQL Developer, Oracle SQL Developer
• Created UNIX shell scripts to access Netezza table and dump the results into a flat file, Compress and transferring to client location through SFTP/MFT.
• Involved in production support process for Client facing applications
• Experience in code versioning tools, such as Git (bit bucket), SVN
• Experience in preparing architecture diagram using Visio.

TECHNICAL SKILLS

ELT Tools: Oracle data integrator, PL/SQL

Databases: Netezza, Oracle 10g/11g/12c, SQL Server 2008/2010

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions)

Scheduling tools: ODI Load planner & Scheduling, TIBCO Scheduler and Cron job

Hadoop Eco System: HDFS, Hive, Sqoop, Spark, Scala, Map Reduce

Programming Languages: Unix Shell Scripting

Operating systems: Windows 8, UNIX

Version control: Atlassian tool Git/Bit Bucket, PVCS (Serena Application), VSSOther Tools: Aginity workbench, PuttyOracle SQL Developer/PL SQL Developer

PROFESSIONAL EXPERIENCE

Lead Developer

Confidential

Responsibilities:

• There is an initiative to maintain product reference details globally.
• Current US system does not deliver data to the OGRDS System to maintain product reference data Globally
• Implemented a solution to deliver the newly identified data to OGRDS system and get dispatched them to the field to collect more details of the product and get back them from the field and loaded into OGRDS and deliver the collected US & Global data to the downstream system by using the below interfaces.
• Input Interface - DB8/DB9 data to the OGRDS system using SI01, SI03 interfaces
• Dispatch interface - is being used to get the dispatched items and loaded them into ICDM database to deliver the same to the field for further data collection.
• SIO2 interface - will receives item from the field and creates SIO2 file and transfer them to the OGRDS system
• Pro publication interface - is being used to get the completed item from the publication data base and creates flat file and MFT them to local mainframe system
• PRO ETL process- it is a mainframe process will be used to process these input files generated by the ODI process and deliver the coded product details to the downstream system.

Confidential

Developer (Team member)

Responsibilities:

• The aim of dis project is provide the option to validate the final data before delivering to the client
• Implemented staging logic in NAPE system to hold the final results in staging tables for validation.
• Implemented a swap schedule logic to swap data b/w staging and production tables.
• The aim of dis project is provide an option to refresh individual or multiple categories -components in warehouse. To achieve dis, we have created new Refresh database which holds the entire refresh related information,
• The refresh database will be copied from ongoing database and data management person will do the refresh repository process. Finally the refreshed data will be moved into ongoing database.
• Involved in Requirements discussion
• Prepared Approaches and low level design documents
• Developed SQL procedure to implement business logic
• Developed Visual basic application to read SPINS data and create a BLOB file
• Modified the existing Gupta SQL Application to consume BLOB file and load SPINS data into Nielsen database.
• Prepared unit test plan and user manual documents.
• Involved in transitioning the application to Operation and Production support team

Confidential

Developer (Team member)

Responsibilities:

• Gathering Requirements from Client and Team Leader and design the form accordingly
• Involved in preparing Design documents
• Developed PL/SQL procedure, function and packages for report module
• Developed Visual basic application for Master, Transaction, Account and transfer module
• Involved in Product Demo and Implementation.
• Followed the Operational Documents like Activity Log, FS, PS, etc.