SUMMARY

• Over 16 years of proven experience in system analysis, design, develop and delivery of critical business applications with excellent problem solving & multi - tasking skills.
• With hands on, I am actively involved with application/database design, development, architecture and prototyping future business solution to support organization’s strategies and objectives.
• I always lookout for emerging technology trends and look how they can strengthen existing or new business solution.
• Experience as aSolutionArchitect, Technical Manager, Project Lead, Lead Developer andSystemAnalyst
• Experience in design and execute pilots, Prototypes, Proof of Concepts
• Experience on Hadoop ecosystem based on Cloudera CDH5.4 and familiar with DataStax Cassandra
• Experience deploying Hadoop components
• Participated in all phases of SDLC starting from Requirement Analysis to delivery & support
• Well experienced in Waterfall and Agile (SCRUM) SDLC methodologies
• Experience in OLTP and data warehouse application design and data modeling
• Have a very strong experience in RDBMS such as Oracle with advance features
• Many years of experience managing and leading onsite & offshore team
• Equally competent at Technical, Functional and Project Management areas
• Ability & Experience to facilitate and lead cross-functional teams to deliver complex IT projects
• Extensive hands-on Experience with database design and developing objects such as Stored Functions/Procedures/Packages/Triggers, Collections, Tables, Views, Materialized views, Pipelined Function, Indexes, Partitioning etc in ORACLE
• Strong knowledge of Advanced SQL & PL/SQL features/techniques like Exception Handling, REF Cursors, Nested Tables, Dynamic SQL, Merge, With, Pragma, Pipeline Function, Bulk Binds
• Extensively involved in performance tuning using Explain plan, Optimization Hints
• Extensively involvement in the Data migration from legacy system to new system
• Experience in Data Capturing, Cleansing, Refining, Validation and uploading data using Oracle PL/SQL scripts, SQL*Loader and External tables
• Designed & developed complete APIs in Oracle PL/SQL to integrate Primavera with in-house ERP. Also, integrated P6 and Oracle Projects using OP3 and created JDBC adapters in webMethods 7.x
• Functional & Technical knowledge of Oracle ERP modules e.g. Procurement, Order Management, Projects, HRMS, Inventory, Work in Process etc

TECHNICAL SKILLS

Big data Ecosystem: Hadoop, Cassandra, HDFS, Hive, Impala, Sqoop, Flume, Solr, Spark

Languages: SQL, PL/SQL, Proc*C, C, XML, Python, Scala and UNIX Scripting

Operating Systems: AIX, Red Hat Linux, Hp-Unix, Windows 7, 2000, 98

Databases & Modeling Tool: Oracle 11g/10g, SQL Server 2005, MySQL, ERWIN, Power Designer, Oracle Designer, SQL*Loader

Development Tools: Control-M, Informatica, TOAD, SQL Developer, BI Publisher

Versioning control: SVN, GIT, Confluence, Jira, PVCS (Polytron Version Control System)

Integration Tools: webMethods 7.x ESB Suite, OP3, ODI (Oracle Data Integrator)

Planning Tools: Primavera (p3e, P6), MS Project

ERP Applications: Oracle EBS (HRMS, PO, OM, INV, WIP, AP, AR & GL), Syteline

Office Tools: SharePoint, MS Words, Excel, PowerPoint, Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Solution Architect / Developer

Responsibilities:

• Solution is capable to handle CSV, JSON, XML etc structured data
• Solution is capable to handle PDF, DOCX, XLSX, MSG etc unstructured data
• Used Cloudera Manager for monitoring services and managing Hadoop cluster
• Created HDFS file structure to ingest structured & unstructured data
• Created External/Managed Hive tables with Partition to load large datasets
• Experience in using Parquet, SequenceFile and AVRO file format
• Created Hive HQL scripts to load data in Hive tables from HDFS
• Solution is based on SOLR, MORPHLINE, SPARK, Hive & HUE
• Collaborated with application and BI team to ensure data quality

Environment: Hadoop (Cloudera CDH5.4, Hive, Impala, Solr, Morphline, Spark, Scala, Sqoop, Hue), Oracle 11g, Sql Developer, PL/SQL, SQL, SharePoint, CollabNet, SVN, Git, Maven, Sbt etc

Confidential, Whippany, NJ

Sr Data Modeler / Developer

Responsibilities:

• Created HDFS file structure to ingest structured & unstructured data
• Created External/Managed Hive tables with Partition to load large datasets using AVRO & Parquet file formats
• Created Hive HQL scripts for load data in Hive tables from HDFS
• Developed SPARK jobs using Scala for data Preparation, Transformation &
• Developed UDFs & UDTFs in Hive and Spark
• Developed Sqoop jobs to move data between Oracle and Hive/HDFS

Environment: Hadoop (Cloudera CDH5.5, Hive, Spark, Scala, Sqoop), QlikView, Oracle 11g, TOAD, Confluence, Jira, GitStash, Maven, Sbt, IntelliJ, Eclipse etc

Confidential, Jersey City, NJ

Tech Architect / Developer

Responsibilities:

• Used Cloudera Manager for monitoring services and managing Hadoop cluster
• Created HDFS file structure to ingest structured & unstructured data
• Created External/Managed Hive tables with Partition to load large datasets
• Experience in using Parquet, SequenceFile and AVRO file format
• Created Hive HQL scripts for load data in Hive tables from HDFS
• Built Ingestion framework using Flume and aggregating data in HDFS
• Installed and configured Flume for staging data in HDFS from spool directory
• Used JSON, CSV format files for data ingestion and storage in HDFS
• Developed SPARK jobs using Scala for data Cleansing, Transformation & Preparation
• Developed Sqoop jobs to move data between RDBMS and HDFS
• Integrated QlikView with Hive & Impala using ODBC connector
• Installed and configured Zeppelin
• Collaborated with application and BI team to ensure data quality

Environment: Hadoop (Cloudera CDH5.4, Hive, Spark, Scala, Python, Sqoop, Flume, MySQL), Exadata, QlikView, ODI (Oracle Data Integrator), Oracle 11g, TOAD, PL/SQL, SQL, SharePoint, CollabNet, Git, Maven, Sbt etc

Confidential, Spokane,WA

Senior Developer/Functional/Technical Lead

Responsibilities:

• Understanding the Business Requirement / Functionality and Workflow of new and legacy applications
• Developed Conceptual, Logical and Physical models based on business requirements
• Followed Oracle AIM methodology for project documentation e.g. BR100, TE040, CV010, CV040, MD050
• Developed SQL Scripts, Database procedures, functions in Oracle and SQL Server to extract data
• Used SQL & PL/SQL features like Materialized View, Ref Cursors, Dynamic SQL, Merge, PL/SQL tables, Bulk Binds, Pipeline Function etc
• SQL Tuning of long running complex SQL queries, used Explain Plan, TKPROF utility and various HINTS, Index to increase performance of procedures, functions, views etc
• Worked in High Performance Team (HPT) to ensure conversion deliveries in time
• Prepared templates to load Suppliers, Customers, Purchase Orders, Customer Orders, Open Demands
• Written complex SQL queries to validate data
• Written PL/SQL programs to load cleansed data from staging area to Oracle Interface tables
• Assist Rollout Manager in planning & preparation of rolling out major Oracle modules e.g. Projects, SCM, Finance and HR for three deployment sites of small to medium sized offices
• Assist Rollout Manager conducting SIT, UAT, Cut-Over Strategy, Go-Live, Burn-in & Maintenance
• Acted as the team lead of an Oracle functional/technical deployment team providing all necessary support as well as liaising between project management, enterprise architecture and instance management
• System Configuration and Provided end user training in Oracle HRMS, OTL, Oracle Purchasing, Order Management, Inventory, WIP & Planning (MRP/MPS/MDS)
• Configuration and setup of HR Organizations, Organization Hierarchy, Jobs, Positions, Roles, Employees
• Configuration and setup of position based PO approval hierarchy
• Written PL/SQL script using Materialized View & Pipeline function to Extraction approved PO lines
• Written database Procedures, Functions, and Views and configured OP3 to integrate Oracle Primavera

Environment: Oracle 10g, TOAD, PL/SQL, SQL, SharePoint, Syteline, SQL Server 2005,SQL Server Management Studio, SQL*Loader, Oracle EBS(Projects, HRMS, PO, OM, INV, WIP, AP, AR, MRP, MDS), Primavera P6, OP3

Confidential

IT Project Lead/Delivery Manager

Responsibilities:

• Daily team status meeting and weekly meeting with Project Management
• Developed Conceptual, Logical and Physical models based on requirements gathered through interviews with the business users
• Involvement in project & Resource Planning On-Site & Off-Shore
• 5+ years of experience managing and leading onsite & offshore team of 14+ members
• Led team to Design & Developed APIs in PL/SQL to integrate Primavera with ERP system
• Led team to enhance/upgrade Procurement system, designed & developed VDR system
• Organize and participate in daily team status meeting and weekly meetings with Project Management
• Involvement in project & Resource Planning On-Site & Off-Shore
• Managed Task assignments and workload
• Led team to design and disintegrate tightly coupled modules into logical components and re-integrate them using Service Oriented Architecture (SOA) architecture (webMethods)
• Developed and maintenance of existing Oracle Forms and Reports, PL/SQL procedures, functions etc
• Used advance SQL and PL/SQL features like Materialized View, Ref Cursors, Dynamic SQL, Merge, With, PL/SQL tables, Bulk Binds, Pipeline Function etc
• Tuning of long running complex SQL queries and Batch process using Explain Plan, TKPROF utility and use of Hints, Indexes
• Design & developed flows, web services, JDBC adapters in WebMethods
• Daily currency update from DK bank into existing ATLAS and Oracle EBS instances
• Daily feed of Purchase Order Lines from ATLAS and Oracle EBS to external systems "webPackingList"
• Daily feed of all approved Purchase Order Lines from ATLAS and Oracle EBS to external system "Sievo"
• Unit testing and integration testing after decoupling with Internal systems such as myFLS, Transmittal, PDB, Proposal, Procurement, Routing and external planning tool (Primavera-P3e)

Environment: Oracle10g, 9i, OracleForms10gand Reports 10g, Designer 2000(v1.3), Developer 2000 (Forms6iand Reports 6.0), LECCO SQL Expert, TOAD, PL/SQL, SQL*Plus, SQLServer2005database, webPacking List, Sievo, PVCS, webMethods v7.x, Primavera v6.x etc

Confidential, Dayton, Ohio

Systems Architect/Analyst

Responsibilities:

• Designed & Developed Oracle Forms, Reports• Developed Entity Relationship diagrams
• Optimized SQL queries and Stored Database Procedures using LECCO SQL Expert
• Wrote complex SQL queries, Database Views, Procedures, Triggers, Functions & Packages
• Written recursive function in PL/SQL and in Proc*C
• Preparation of SRS (System Requirement Specification), DDD (Detailed Design Documents), UTP (Unit test plans), Coding and Testing
• Unit testing and integration testing of different modules with external and internal systems
• Developed & Implemented S-Curve to be used by management to track progress of project

Environment: Oracle8, Forms 6i & Reports 6i,ERWin, LECCO, TOAD, PL/SQL, SQL*Plus, Pro*C, Java, PVCS etc