SUMMARY:

• 12+ years of experience in IT industry with hands on experience in Cloudera Hadoop ecosystems (Hadoop 2.6.0 - cdh5.9.0).
• Expertise in requirement gathering, analysis, development, data migration, production support, and maintenance environments.
• 2 years of experience as a Big Data developer on Apache Spark, Hive 1.1.0, Impala 2.7.0, Sqoop 1.4.6, HDFS and Python 2.6.
• Hands on experience in creation and maintenance of reports using SAP Business Objects 4.1 client tools - Information Design Tool, Web Intelligence, Crystal Reports and BRIO Intelligence Suite 6.6 in relational database environments.
• Experience in design, development and maintenance of applications in relational databases and client server environment using PowerBuilder 8.0/9.0, Oracle 9i/10g and PL/SQL.
• Development experience in Shell scripting in Unix and Linux.
• Strong Knowledge in MS SQL Server 2008, Business Intelligence in ETL Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Good knowledge of Normalization, Dimension and Fact Tables, also dealing with OLAP and OLTP systems.
• Techno-functional responsibilities include interfacing with users, identifying functional and technical gaps, estimates, designing custom solutions, development, leading developers, producing documentation, and production support.
• Excellent interpersonal and communication skills, creative, research-minded, technically competent and result-oriented with problem solving and leadership skills.
• Strong knowledge in data modelling, effort estimation, ETL Design, development, system testing, implementation and production support. Experience in resolving on-going maintenance issues and bug fixes.

TECHNICAL SKILLS:

Hadoop/Big Data: Cloudera Hadoop (Hadoop 2.6.0-cdh5.9.0), Apache Spark, Hive 1.1.0, Impala 2.7.0, Sqoop 1.4.6, HDFS.

Programming languages: Python 2.6, Unix and Linux shell scripts, PowerBuilder 8.0/9.0

BI: SAP Business Objects 4.1 client tools - Information Design Tool, Web Intelligence, Crystal Reports and BRIO Intelligence Suite 6.6

Database: Oracle 9i/10g, SQL Server 2008

Operational Systems: Windows, Linux, Unix

Database Tools: SQL Developer, TOAD, SQL*plus, SQL*Loader

Database Query Language: SQL, PL/SQL

Version Control: Bit Bucket, PVCS

PROFESSIONAL EXPERIENCE:

Confidential, California

Hadoop Developer

Responsibilities:

• Developed data injections jobs using Attunity, Spark, Python, Hive, HDFS, Sqoop, Shell and Python to load data to Data Lake from SAP.
• Development and testing of Dimension, Fact and Summary Hive tables to move data from Data Lake to Processed databases in Hive.
• Developed framework using Python, Hive, Spark, Shell and Impala for job processing and scheduling which includes loading of data from data lake to processed DBs.
• Worked as Subject Matter Expert for the different functional modules and co-ordinate design and development activities with functional analysts and other developers.
• Provided support during the different phases of testing (ITC1, ITC2 and UAT).
• Developed HIVE scripts for analyst requirements for analysis. Cross-examining data loaded in Hive table with the source data in SAP.

Environment: Cloudera Hadoop (Hadoop 2.6.0-cdh5.9.0), Apache Spark, Hive 1.1.0, Impala 2.7.0, Sqoop 1.4.6, HDFS, Bit Bucket and Linux.

Confidential, California

PL/SQL and BI Developer

Responsibilities:

• Analysis, Design, Development, Testing and Deployment of application change request and assist team to evaluate code and facilitate necessary approvals through Application Change Release Database.
• Provide continuous support, monitor and Maintenance of ETL activities to refresh data from Oracle ERP and Other Source.
• Interact with business users and functional experts to gather business requirements, Prepare technical design and Unit test cases documents, interact and co-ordinate with offshore to ensure delivery.
• Develop Complex database objects such as Stored Procedures, Functions, Packages, Cursor, Analytical Functions, PL SQL tables and Triggers using SQL and PL/SQL and Tables, Views, Constraints, Index (B Tree and Function Based) and Database links.
• Effectively tune the database objects with explain plan, hint, removing unnecessary large-table full-table scans and verified optimal index usage.
• Design and develop user universes and reports using Business Objects, Information Design Tool and BRIO Intelligence tools. Convert reports from BRIO to SAP Business Objects and post the reports to Quality and Production enticement through Migration processes.
• Deployment of database objects to production and quality environments through Kintana and PVCS version control tools.

Environment: Oracle 9i SQL and PL SQL, Unix, SAP Business Objects 4.1, Information Design Tool (IDT), Web Intelligence (WEBI), Oracle SQL Developer 4.0, Toad 9.0, Brio Intelligence Suite 6.6, PVCS, Kintana, Windows 7.

Confidential, California

PL/SQL and BI Developer

Responsibilities:

• Gather and Analyze of reporting requirement. Analyze the requirements with the business users and prepare the technical and Functional specification.
• Development of various database objects such as Tables, functions, views and Stored Procedures using Toad and PL/SQL in Oracle.
• Create various complex reports using Crystal Reports 9 and post it to SAP Business Objects Xi.
• Enhance/modify existing reports and scheduled the reports to run at specific intervals in BOXI as desired by the Business Users.
• Optimize various SQL queries through performance tuning to make the reports run faster and used SQL extensively in command objects of Crystal reports.
• Converted reports from Crystal Reports to Microsoft Business Intelligence Reporting Service (SSRS) reports. Created Dashboard for Remedy using Microsoft Business Intelligence Analysis Service (SSAS).
• Created ETL jobs in Microsoft SQL Server using ETL service (SSIS) to migrate the data from ARS76RPT system.

Environment: Oracle 10g SQL and PL SQL, Crystal Report 9, SAP Business Objects Xi 3.1, TOAD, MSBI

Confidential, New York

PL/SQL and PowerBuilder Developer

Responsibilities:

• Developed new programs and codes with packages, functions, procedures analytical functions, triggers, cursor and SQL and PL SQL package and collections.
• Involved in performance tuning of database queries and analyzed the database plan through explain and added hints and index wherever required.
• Moved data from RPM to CORE through database links and implemented the core business logic through functions, procedures and packages. Parsed the data nodes by string functions.
• Prepared technical and unit test cases specifications by adherence to all project timeframe.
• Developed PowerBuilder forms and code with Inheritance, User Objects, Nested Data windows, MDI, Multi Table Data window Update, Describe and Modify functions features.
• Developed programs with Power Builder Foundation Classes (PFC) and made use of PFC objects for debugging and SQL traceability and created the reports in Power Builder using Data windows.
• Exported and imported data between data sources with Data Store Object and Pipe Line Objects functionality and developed modules with User Objects such as Visual UO, Standard UO, External and Class UO.

Environment: Oracle 10G SQL and PL SQL, Sybase PowerBuilder 9.0,Sql Navigator, SQL Loader, PB Delta 5.3, Mercury Quality Center, Window XP

Confidential, New Jersey

PL/SQL and PowerBuilder Developer

Responsibilities:

• Created and modified stored procedures, cursors, triggers and views.
• Extensively worked on the power script (Structures and Objects, Function and Events, System Objects and controls) to develop different modules of the application.
• Participated in the full life cycle of development (define, develop, test, install, and maintain).
• Maintained a source control and inventory system, to ensure appropriate version control.

Environment: PowerBuilder 8.0/9.0, Sybase Adaptive Server Anywhere, Postgre Secure Shell, SQL, Window XP

Confidential

PL/SQL and PowerBuilder Developer

Responsibilities:

• Developed PowerBuilder forms and code with Inheritance, User Objects, Nested Data windows, MDI, Multi Table Data window Update, Describe and Modify functions features.
• Developed programs with Power Builder Foundation Classes (PFC) and made use of PFC objects for debugging and SQL traceability
• Created the reports in Power Builder using Data windows and assisted the team to deployment of code.
• Developed procedures and function in database and referred from power builder application.
• Involved in bug fixing

Environment: PowerBuilder 8.0, Sybase Adaptive Server Anywhere, Postgre Secure Shell, SQL, Window XP