SUMMARY:

• Over  11   years  of IT experience in System Analysis, Design, Development, Maintenance and Support using  Oracle Database 8i/9i/10g/11g, SQL, PL/SQL, SQL * Loader, Query Optimization, Performance Tuning, and Trouble Shooting .
• Over  2  years of experience in Hadoop Ecosystem ( HDFS, YARN, MapReduce, Pig, Hive, Sqoop, Zookeeper & Phoenix ) & NoSQL ( HBase ).
• Strong experience in Extraction, Transformation and Loading ( ETL ) data from various sources into Data Warehouses and Data Marts using Pentaho, DataStage .
• Expertise in Hadoop Ecosystem ( HDFS, MapReduce, Pig, Hive, Sqoop, Zookeeper, Phoenix & HBase )
• Expertise in writing Hive/Pig/HBase queries and extensively used Phoenix to query and join HBase tables .
• Experience with advanced SQL query writing and data retrieval using " Big Data " Analytics.
• Assigned schemas and created HIVE tables. Applied other HDFS formats and structure ( Avro ) to support fast retrieval of data, user analytics and analysis
• Broad understanding and experience in data pipelines, data modeling, data management, and data APIs
• Experience with advanced SQL query writing and data retrieval using " Big Data " Analytics.
• Assigned schemas and created HIVE tables. Applied other HDFS formats and structure ( Avro ) to support fast retrieval of data, user analytics and analysis
• Broad understanding and experience in data pipelines, data modeling, data management, and data APIs
• Expertise in implementing  Data modeling , Erwin, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer.
• Extensively worked on Data Migration using Flat files and Data Mapping through SQL* Loader Imp/Exp utilities, UTL - File Package on Oracle 9i and 10g Databases.
• Experience in  Performance tuning , Application tuning and Query Optimization using Hints, Explain plan, TKPROF
• Hands on experience with tools like SQL Navigator, Toad, Sql*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM).
• Managed Hadoop clusters, writing ETL codes to move data in and out of Hadoop.
• Also worked on MS SQL Server, Access Databases and developed  T-SQL, SQL, Stored Procedures, Cursors, Triggers, Views, Indexes and Constraints, Query Optimizer

TECHNICAL SKILLS:

Programming Language: Oracle SQL, PL/SQL, Unix Shell scripting

Database Environments:   Oracle 9i/10g,11g, Netezza, HBase(NoSQL), IBM DB2, Sql Server

Big Data Technologies: Apache Hadoop, Hive, Pig, Sqoop, HBase, Phoenix, Zookeeper

ETL Tool: Kettle - Pentaho 3.2.0,   DataStage 9.1, Composite

Scheduler: Appworx, Autosys 4.0

Operating Systems: Windows, Unix & Linux

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Technologies: Hadoop Ecosystem (HDFS, Hive, Pig, Sqoop, Zookeeper, Phoenix), HBase(NoSQL), Oracle, Cognos, Linux, Python, Pentaho & Java

Responsibilities:

• Involved in Design and Development of Technical Specifications using Hadoop technology. Responsible for data movement from legacy application and relational database to HDFS using Pentaho and Sqoop .
• Designed and developed Big Data analytics platform for processing customer viewing preferences using Hadoop, Hive, Pig, HBase and Cognos .
• Integrated Hadoop into traditional ETL (Pentaho) , accelerating the extraction, transformation, and loading of massive structured data in to No-SQL database, HBase .
• Loaded the aggregate data into a relational database for reporting, dash boarding and ad-hoc analyses, which revealed ways to lower operating costs and offset the rising cost of programming.
• Incorporated Phoenix (thin jdbc layer) on top of HBase for better load performance and also it provides Sql capability to the data stored in HBase.
• Hands-on experience in writing MapReduce jobs in Python. Good knowledge on streaming and event processing technologies (Kafka, Flume, Storm, Spark)
• Good understanding of installing and configuring Hadoop Ecosystem. Have done Proof of concepts using Scala for establishing SPARK (in memory data processing).

Confidential, Dallas, TX

Technologies: Oracle 10G, Pl/SQL, DataStage, Java, Unix, Composite, Cognos

Responsibilities:

• Provided expertise on resource management and allocation, risk mitigation, communications, project plans, deliverables, quality assurance, project documentation and best practices.
• Developed a full set of business requirements and conducted an evaluation of the technical architecture.    Modelled the database tables on the entity level - Data Modeling.
• Developed complex Oracle PL/SQL procedures, functions and packages that heavily involves dynamic SQL to support the changing classification during run time.
• Developed Composite stored procedures to pull the data from multiple sources to VPR Oracle DB to support Client report generation from VPR.
• Used advanced Bulk techniques ( FOR ALL, BULK COLLECT ) to improve performance. Developed Installation scripts for all the deliverables.
• Involved in Performance Tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities. Worked on external hints during the Sql optimization to fast up the Sql process.
• Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, PARTITION OVER .
• Involved in implementing Table Partitions using Range, Hash, Composite techniques. Written Test Plans and Involved in Unit/SIT/UAT testing.

Confidential, Dallas, TX

Technologies: Oracle 10G, Netezza, DB2, Pentaho, DataStage, Composite, Cognos, Java

Responsibilities:

• Responsible for creating and developing highly complex applications using Oracle as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Extensively worked on  CDC,  Pentaho & Datastage ETL  to Extract, transform and load Transactional data into VPR (Downstream System) data warehouse.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Implemented parallelism in loads by partitioning workflows using Pipeline , Round-Robin, Hash, Key Range and Pass-through partitions.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD)
• Created Views and Triggers required for the Incident, Investigation, Consequence and Action Items modules based on the business requirements.
• Designed, developed and tested Oracle PL/SQL packages,  Composite  stored procedures , and functions to push the test data from GDW to VPR.
• Developed automated SQL scripts to schedule the load of employee/contractor user information from active directory on daily basis.
• Played a pivotal role in the migration of open Incidents from legacy application databases to Oracle 11g in a planned manner
• Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures
• As part of performance tuning, used TKPROF, and Explain Plan in tuning PL/SQL code and SQL queries
• Created Unit and Assembly Test Scripts and performed the test cases.
• Experience with establishing and adhering to technical development standards
• Provided Ad-hoc Reports whenever the business requested and maintained a good relation with Business Customer

Confidential, Dallas, TX

Technologies: Pentaho 4.2, Oracle 10G, PL/SQL, Linux, Shell Scripting

Responsibilities:

• Interacted with the Business users to understand the existing environment and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Extensively used Pentaho PDI suite to extract the data from flat file, transform and load in to Oracle database.
• Created Jobs, reusable transformations( sub-transformation ) and used them in different mappings.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Used stages namely Row denormaliser, Row flattener, Lookups, Joins and Modified Java script values with in the transformation.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
• Validation of Pentaho mappings for source compatibility due to version changes at the source.
• Trouble shooting of long running sessions and fixing the issues.
• Involved in writing SQL scripts, stored procedures and functions and debugging them. Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Confidential, Dallas, TX

Technologies: Pentaho 4.2, Oracle 10G, PL/SQL, Unix, Shell Scripting

Responsibilities:

• Involved in managing, architecting, testing, deployment, and monitoring of the software projects.
• Created Database tables, Logical/Physical model, ERD Diagrams
• Resolving issues related to Stored procedures in OLTP system and analyzed, design and develop ETL strategies.
• Developed mappings, sessions and workflows in Pentaho.
• Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP enviironment. Troubleshooting of long running sessions and fixing the issues related to it.
• Involved in the development of PL/SQL stored procedures, functions and packages to process business data in OLTP system.
• Worked with the testing team to resolve bugs related to ETL mappings & Oracle Stored Procedures before production.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.

Confidential, Cincinnati, OH

Technologies: Oracle 9i, PL/SQL, Unix, Shell Scripting, Appworx Scheduler

Production Support/Oracle Developer

Responsibilities:

• Oracle/Unix  technical analyst for WMS related projects in Supply Chain Section
• Resolving all Real Time Support(RTS) issues and provides production support activities.
• Gathered and defined user requirements.
• Created database triggers, procedures, functions using PL/SQL.
• Extensively written UNIX Shell scripts to extract the meta data from flat files to a specific format and import into Oracle database using SQL*Loader.
• Performance tuning of SQL code.
• Enhancements for GET Confidential
• Mentor and grooming new resources for WMS related projects and Unix/Oracle projects in SCS.
• Identifying, prioritizing of root cause of problems and resolve break and bug fixes
• Estimations of enhancements for all GET Oracle related projects
• Gate keeping and approval of all GET Oracle related projects
• Single point of contact for all the RTS issues and provide the necessary details on the implications of other SCS Systems

Confidential 

Technologies: Oracle 9i, PL/SQL, Unix, Shell Scripting, Appworx Scheduler

Production Support/Oracle Developer

Responsibilities:

• Production support (monitoring, error handling and rerun the failed jobs).
• Coordinate with the team at onsite for a smooth deployment, any change management or production issues
• Gather and define user requirements. Involved in the Database design.
• Created database triggers, procedures & Functions using PL/SQL.
• Design and implementation of Stored Procedures to combine complex queries and business logic there by improve performance.
• Developed UNIX shell scripts/batch jobs to insert the reader data into oracle database.