SUMMARY:

• Over 9 years of experience in Information Technology with Extensive knowledge and work Experience encompassing a wide range of skill set, roles and industry verticals. Confidential Vertica Administration, Systems Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions. Worked with both data warehouses and OLTP databases. Good hands on experience with MPP data warehouse.
• Master of Information Management Optim Technical Professional v2.
• Handled multiple roles - Vertica Database Developer, Oracle DBA and Deployment Administrator, Oracle, MySQL Migration cum Data Analyst, and in-house ERP Systems Analyst. Worked in various platforms like Confidential -UX, AIX, OEL, Red Hat Linux and Windows.
• Expertise with setting up multi node Vertica Cluster.
• Expertise with migrating data to Vertica from Oracle, Teradata and Sql Server Database.
• Expertise in developing scripts with loading Vertica and using ETL tools to perform the load.
• Experience as Data Quality team member to actively drive and manage the data requirements for migration, coordinate with the Integrity project manager(s) and technical teams, create and review requirements documents.
• Big Data Solutions - Installing and configuring Vertica for a single 3-node/20-node cluster, Projection design for query specific, and monitoring database on command line via AdminTools for Confidential Vertica Analytics DB. Expertise with Vertica DBD, tuple mover, move out, merge out tasks and Management console.
• Strong in resource management, and memory management depending on the priority of resource pools and users.
• Database Migration specialist - Expertise in migrating data from any traditional RDMS (Oracle, MySQL, and DB2) to Confidential Vertica.
• Experience in Performance Tuning with the best implementation practices for improved performance in High-Volume reporting and real time Analytics.
• Did Vertica version upgrades from 7.1 to 7.2 and 7.2 to 8.0.
• Associate with Oracle more than 6years of experience in Oracle 11g/10g/9i, SQL, PL/SQL, forms & reports as an Oracle Developer/ PL/SQL Developer.
• Expertise working with Oracle 11i,10g, 9i, 8i, PL/SQL, Oracle Forms 11i,10g/6i, Reports 11i,10g/6i, SQL * Loader.
• Extensive experience as Oracle Developer in utilizing PL/SQL procedures, functions, packages, triggers, shell scripting, unit testing and also involved in data extraction, transformation and loading operations on oracle using SQL Loader
• Strong skill set in using developer tools such as Oracle Forms 11g/10g/9i/6i, Reports 11g/10g/9i/6i
• Developed several custom reports using Oracle Reports 6i/9i/10g/11g
• Extensive working knowledge in database objects like creating tables, views, indexes, sequences, primary key, foreign keys and constraints, external tables.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, TOAD, SQL*Navigator, Putty.
• Experience with software Development life cycle (SDLC) process performing detailed analysis, collecting requirements, documents requirements, coding and unit testing, integration and system testing.
• Experience in interacting with Business/Technology groups and analyzing business needs
• Excellent Interpersonal Skills which helped me to share a good report with co-workers and the management.
• Excellent knowledge in Data Guard implementation, Relational Databases, Data Modeling and Managing Schema objects. Oracle Export/Import (To take Logical backup of Oracle Database and restore), RMAN (Oracle Utility to manage Oracle Backup), Data Pump.
• Monitoring database performance and generate AWR Report.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
• Experience in extracting, transforming and loading data from other databases and text files using SQL*Loader utility and external tables.
• Experience in taking logical backups of data using oracle data pump utilities EXPDP and IMPDP.
• Used Flashback feature to recover a dropped table and also to recover a database.
• Creation and maintenance of test schema, setting up test environment and development by installation & configuration of Oracle 11g/9i/10g DB and oracle Application server.
• Involved in upgrading projects from 10g to 11g.

TECHNICAL SKILLS:

Operating Systems: Windows Vista/XP/98/2000, UNIX, and Mainframes.

Programming: C, JAVA, HTML, Perl, SQL, PL/SQL, and Unix Shell Scripting.

Database: Vertica 7.2/7.1, Hive, Oracle 11g/10g/9.x/8.x/7.x MS SQL Server 2000/7.0/6.5

Tools: Sqoop, Squirrel, Vsql, SQL*PLUS, SQL*Loader, Oracle Discoverer 6i/9i/10g/11g, TOAD, Forms 11g/10g/9i/6i/4.5, Reports 9i/6i/4.5, SQL Developer, Developer 2000

GUI Tools: Oracle forms 11g/10g/9i, Oracle reports 11g/10g/9i/6i, Tableau, Arcadia

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Vertica Consultant

Responsibilities:

• Installed and Maintained Vertica Cluster.
• Actively involved in Analysis, Estimation, Resource Planning, Design, Development, Testing, and Implementation of Confidential Vertica 7 for multi-tenant environment.
• Documented project requirements, understanding the current infrastructure and actively involved in profiling and analyzing data.
• Configured and Installed Vertica on their environment.
• DDL scripts were developed to support right transformation and not cause failure on data loads from Oracle 11.1.2.
• Created data model in Vertica database by defining objects like tables by mapping the Vertica supporting data types.
• Data type Mapping between Confidential Vertica and Oracle.
• The Master data dimension tables were decided to be one schema and replicated across the cluster.
• Testing the data model with sample data. Fix in case of any issues and finalize the data model built.
• Database configuration and design with relationships in tables.
• Installed
• Installed Vertica Extension Packages like Strings package for group contact function on Vertica 7.1.1
• Data was partitioned on Modified date after careful analysis to leverage partition pruning and faster deletes.
• Work with Informatica team and make sure the data mapping has been done between Oracle database and Vertica database.
• Optimized Informatica to have better load performance to Vertica by increasing the buffer size and higher commit limits. Informatica loads were improved with the use of staging tables with in the schema.
• System configuration parameters were set to avoid ROS pushback errors and loads failures.
• Staging tables had the forward and backward lookup transformations to load data in target tables with a Merge command fired to the Vertica.
• Performance Tuning using Database Designer and Query Specific Projections.
• Writing and Connection of User Defined Functions.
• Providing remote support to customers.

Environment: Vertica 7(40node cluster), sqldeveloper, Oracle, Informatica, VSQL, Sqoop, Hive, Squirrel.

Confidential

Vertica DBA Lead

Responsibilities:

• Installed & configured multi-node Vertica cluster.
• Maintained Production, Staging and Dev Environments.
• Created scripts for daily backup, analyze statistics, unrefreshed projections etc.
• Upgraded Vertica to higher versions and also upgraded vertica license.
• Designed resource pool with set of users according to client requirement.
• Running DBD for optimized tables.
• Everyday checkups for delete vectors, epochs, memory, disk utilizations.
• Wrote scripts for cleanup activities on daily, weekly and monthly basis.
• Installed Vertica Management Console for the better monitoring of the system health through a more user friendly interface
• Designed the ETL for Vertica Analytical Platform for different groups in ICICI group.
• Our Team is also responsible for designing & delivering of migrating Sybase data & ETL to vertica using Java UDXs and Informatica.
• Used my expertise in Vertica to solve production related issues on a day to day basis.
• Identified requirements for performance improvements/enhancements.
• Used External table concepts for archived Data
• Resolved errors like resource pool unavailable, Table Locking issue, etc…
• Identified small size tables and replicated for better performance.
• Resolved an issue of hitting more than 100k queries hitting the DB in a day.
• Added more nodes to support the client requirement.
• Analyzed the performance bottlenecks in the existing Sybase DataMart to reduce the system load.

Confidential, Fremont, CA

Vertica ETL Consultant

Responsibilities:

• Created scripts for daily backup, analyze statistics, unrefreshed projections etc.
• Upgraded Vertica to higher versions and also upgraded vertica license.
• Running DBD for optimized tables.
• Everyday checkups for delete vectors, epochs, memory, disk utilizations.
• Wrote scripts for cleanup activities on daily, weekly and monthly basis.
• Installed Vertica Management Console for the better monitoring of the system health through a more user friendly interface
• Designed the ETL for Vertica Analytical Platform of 3PAR storage data.
• Setup ETL for initial data migration using custom program written in python.
• Setup ETL for daily extraction and load using custom program written in python.
• Analyzed the performance bottlenecks in the existing Oracle DataMart to reduce the system load.
• Analyzed the performance bottlenecks in the existing DataMart for smooth ETL operation.
• Setup the Vertica database schema objects for the ETL process to load.
• Ran the Database Designer in comprehensive mode to tune the projections.
• Ran the Database Designer in query specific mode to tune the projections for improved query time for user queries.
• Conducted the performance tuning on the Vertica schema for faster user query responses.
• Analyzed the analytical user queries for performance tuning and suggested changes.
• Analyzed the users and roles configuration for user access management and control.
• Installed Vertica Management Console for Vertica cluster management and monitoring.
• Setup the ETL monitoring scripts and reports.
• Experienced with handling big data (Data transfer, import/export, storage, performance and security).
• Setup ETL for dataload from oracle DB to Arcadia Analytical Database (Arcsql on Hadoop file system).
• Developed dashboards in Arcadia.
• Implemented ETL automation process using scala and java programing.
• Maintained Database schema, adding and revoking users when required.
• Applied segmentation and partitioning concepts on required tables for better performance.
• Tuned customized end user quires.

Confidential, San Francisco, CA

Vertica DBA

Responsibilities:

• Database Cluster installation, and configuration. Creating Schemas, users and roles.
• Helped with technical assessment of their Vertica Analytics Platform to identify bottlenecks that could result in system instability and performance issues.
• Analyzed the application team with front end queries which were resource intensive for better performance.
• Installed Vertica Management Console for the better monitoring of the system health through a more user friendly interface.
• Implemented the backup and recovery program for daily database backup to help in case of system failures.
• Installed Vertica Extension Packages like Strings package for group contact function on Vertica 7.1.1
• Adding and removing of nodes when required without system maintenance window.
• As a Vertica DBA, helping with system issues on a day to day basis.
• Trouble-shoot and tune poor performing query.
• Performance Tuning includes creation of projection, partition swapping etc.

Environment: Linux and Vertica 7.0

Confidential, CA

Responsibilities:

• Analysis of specification to suggest the right solutions based on client requirements.
• Involved with design, development testing and production phases of the SDLC.
• Customized various Forms 10g/11g and Reports 10g/11g to make them user friendly and also based on the business.
• Developed and customized complex PL/SQL procedures based on client requirement.
• Tuned procedures to improve overall system performance.
• Created tables, views, materialized views, procedures, functions, triggers, sequences, packages and executed them using TOAD.
• Was responsible for handling production issues related to daily reports and performance issues.
• Extracting, transforming and loading data from other databases and text files using SQL*Loader utility and external tables.
• Coordinated with the Quality Assurance/Testing team members to perform user acceptance testing (UAT).
• Involved in the Design of Backup and Recovery Strategies using RMAN, and Configuring Oracle Data Guard.
• Creation and maintenance of test schema, setting up test environment and development by installation & configuration of Oracle 11g/9i/10g DB and oracle Application server.
• Involved in 11g upgrade. Having good knowledge in 11g Database installation and resolved most of the ACL issues reported by client.
• Involved in taking logical backups of data using oracle data pump utilities EXPDP and IMPDP.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Works with clients for production support and requirement gathering for new enhancements.

Environment: Oracle 10g, Forms & Reports 10g/9i/6i, SQL*LOADER, Windows XP, UNIX, Microsoft Visual SourceSafe (VSS), Putty, PL/SQL, SQL*PLUS and TOAD 9.6/10.5

Confidential

Responsibilities:

• Worked with PricewaterhouseCooper’s (PwC) consulting team and played a key role in the customization and development of Forms & Reports using Oracle Forms & Reports 9i and PL/SQL.
• Created and re-customized forms and reports according to the client’s requirement.
• Creating Packages, Triggers, And Stored Procedures.
• Involved in writing System Test cases and Unit Test cases.
• Supported during all testing phases and problem resolution

Environment: Oracle Developer Suite, Toad, SQLLDR, SQL, Pl/SQL, Forms & Reports 10g/9i/6i