SUMMARY:

• Evangelizing Netezza - Vice President for the Tri-State Netezza Users Group (NY, NJ, CT)
• Architected BIG DATA Strategy for a Cable Company for their Network Operations Centre (NOC) - Building IBM Netezza Servers, bringing in Hadoop Implementation of Hortonworks. IBM Netezza, MySQL Servers, MongoDB and Hadoop Stack (PIG, Hive, HBase, Zookeeper), Kafka along wif Storm.
• Supported more TEMPthan 50 Terra Byte databases (Financial Databases) and supporting more TEMPthan 1 Peta Byte installation
• Experience in the MySQL Server environment, architecting the environment along wif Netezza and MongoDB.
• Experience in Netezza workload/resources management wif GRA and User/session
• Experience wif configuring Netezza events notification manager, query history, history database, nz support scripts and in-house system monitoring.
• Experience in working wif Netezza Parent and Child Nodes replication.
• Experience wif all aspects of Netezza NZSQL, multi-threaded NZ load, NZ Backup/Restore, Netezza database/schema creation, managing physical database objects (tables, views, materialized views, stored procedures) in both development and production environments.
• Experience wif Netezza high availability, Replication, Business Continuity and Disaster Recovery, migration redundant NIC bonding modes, SPU/Disk failover and regeneration - Build the BCDR Environment - Boston to Lousville(Texas).
• Working closely wif Netezza - IBM, in changing the disks, SPU and SPA’s, software upgrades and create support tickets and resolve them.
• Worked on Architecture of Sybase, MS SQL Server and Netezza - Data movement and in-bound and outbound of the data flows of both the Client and Internal databases
• About 10+ years of experience in Sybase, Perl and Shell Scripting.
• About 5+ years of experience as SQL Server DBA, as Oracle DBA.
• Install New and /or upgrade Sybase and SQL servers.
• Database Administration experience in Oracle 11g, 10g, Sybase 15.5, 15.0.3, 12.5.3, Replication Server, MS SQL Server 2008, 2005, 2000 and Sybase IQ.
• Performed Physical and Logical Data modeling and architecting various applications.
• Experience in Production, Development and Testing support environment.
• Performed Performance and tuning to the Sybase servers Replication Server implementation.
• Supported 24x7 for production, Experienced wif Backups and Disaster Recovery.
• Good noledge in the Autosys, Visio, ERWin, Remedy and Peregrine Ticketing systems.
• Excellent troubleshooting and problem resolution skills.
• Ability to work under tight schedules and Good decision making skills.
• Excellent communication, oral, written skills and a Good team player.

TECHNICAL SKILLS:

HARDWARE: Sun Systems, IBM RS/6000 Systems.

OPERATING SYSTEMS: Sun Solaris, AIX, Win NT 4.0, UNIX System V, AOS/VS, VAX VMS.

LANGUAGES: Shell Programming, python, C, PERL, JAVA, COBOL.

DATABASES: Netezza, Hadoop, Hive, MySQL, Sybase ASE, 15.02, 12.5, 11.3, 11.92, 12.0.3, Oracle 11g, 10g, SQL Server 2000, 2005, 2008, 7.0, 6.5 Informix: SQL, ESQL, 4GL.

BigData: Netezza, Hadoop Technologies.

PROFESSIONAL EXPERIENCE:

Head of Netezza & BigData Support

Confidential, Philadelphia

Hadoop Technologies, Confidential, Python, Perl, Shell Programming, Agility Netezza Workbench, MySQL Server, MongoDB, Talend, Vertica

Responsibilities:

• Defining Confidential 's Global Netezza & Big Data Support Strategy and Collaborating wif customers to build state of the art solutions to address their Netezza & Big Data & Analytics, Netezza Replication and also defining the infrastructure support for all the various Big Data environments.
• Define the best practices, Vendor Management for all the platforms under Big Data group (Netezza, Hadoop & others as get developed), Relationship Management. Guide development teams to resolve issues wif the Help of SMEs & Vendor suport.Plan & Manage software upgrades, Application migration efforts, adoption of new technology initiatives etc.
• Interfaced wif senior executives wifin business and IT organizations to communicate on adoption various Big Data Platform - Hadoop - Hortonworks implementation.

Principal Architect

Confidential

Responsibilities:

• Architected BIG DATA Strategy for the Cable Company for their Network Operations Centre (NOC) - Building IBM Netezza Servers, bringing in Hadoop Implementation of Hortonworks. IBM Netezza, MySQL Servers, MongoDB and Hadoop Stack (PIG, Hive, HBase, Zookeeper) and Kafka along wif Storm.
• Built a 16+2 Node Hadoop cluster initially (500TB) and we are already expanding by another 16 Node Cluster - total it will be 32 Node Cluster.
• Using Scoop moving data from Netezza to Hive DB and Ambari and Nagios to monitor the Hadoop Cluster.
• Using MongoDB (NoSQL) getting data from Live systems and loading them in MySQL and Netezza.
• Also devising a strategy in implementing Kafka and Storm to get the Modem Log data.
• Supporting more TEMPthan 30 Terra Byte databases in Netezza environment along wif 40TB Data Storage.
• Developing Netezza to Hadoop Archival System of 40TB.
• Installed MySQL Servers in a large environment.
• Netezza Performance at Server Management admin level, SPU Maintenance using NZ options
• Load and Unload data using External Tables (NZLOAD), Backups using nzbackup/nzrestore
• Netezza User, Group and Database access Provisioning, NZ System Activity Monitoring, Netezza User Security and Authentication/authorization.
• Talend is our ETL Tool - which controls all our data movement between all the environments.

Sr. Database Architect

Confidential

Responsibilities:

• Working at an Marketing Analytics Company, as a Sr. Database Architect, managing their various databases - IBM Netezza.
• Supporting more TEMPthan 50 Terra Byte databases and supporting more TEMPthan 1 Peta Byte installation
• Netezza Performance at Server Management admin level, SPU Maintenance using NZ options
• Load and Unload data using External Tables (NZLOAD), Backups using nzbackup/nzrestore
• Netezza User, Group and Database access Provisioning, NZ System Activity Monitoring, Netezza User Security and Authentication/authorization.
• Architecting various applications and improving them.
• Looking into the growth strategy - Tables Growth and skew, table distribution
• Help the user community regarding the queries and resolve inefficient queries and also doing the performance tuning and solving some of the problems.
• Also worked on installing the Netezza Analytics software.

Senior Consultant

Confidential

Responsibilities:

• Working at an MFS Investment Bank, based in Boston, MA, as a Sr. Consultant, managing their various databases - Sybase.
• As a Sr. Database Consultant, working on doing performance tuning of their Compliance Systems - both Server level as well at the stored procedure level.
• Created various data base model's using Erwin's Data modeling tool - Reverse Engineered from various databases.
• Responsible for tuning as well as database administration.

Senior Consultant

Confidential, Albany, NY

Responsibilities:

• Worked at MVP Insurance, based in Albany, NY as a Sr. Consultant, managing their various databases - Sybase, MSSQL and Oracle.
• As a Sr. Database Consultant, working at a HealthCare Insurance company in NY, supporting their various distributed databases.
• High-level support of existing systems utilizing the Remedy ticketing system to resolve various tickets created by users
• Database administration of various databases including Sybase, MSSQL, and Oracle.
• Designed, developed and implemented the database management repository for the Enterprise where dis database captures database capacity over time also provides all servers information at the patch level. As the design is modular it also has the functionality to include an enterprise password reset application for the database user id’s.
• Defined database management strategies for enterprise databases and handled application performance and tuning; responsible for tuning stored procedures and servers and managing complex systems.
• Worked at the Department of Health, NY State as a consultant, managing and administering their databases in Sybase as well as in Oracle.
• Worked on the Performance Tuning using the various tools - Performance Center (Embarcadero’s), ProActive DBA (WhileHall Technology’s) and also extensively used Mon Tables from Sybase.
• Helped in converting one of the databases from Sybase to Oracle Database and also getting data from other database servers for the application.

Senior Consultant

Confidential, NJ

Responsibilities:

• Worked as a free lance consultant for an insurance company, defining the database design, architecture.
• Responsible for the performance and tuning the application - tuned various stored procedures and also the servers.
• Working remotely wif the application teams from both India and Mexico, halping them having the right processes - (FACETS application)
• Helped in converting one of the databases from Sybase to SQL server and also getting data from other database servers for the application.
• Trained in the Oracle Database administration 11g.

Senior Consultant dba

Confidential

Responsibilities:

• Responsible for Production Support of various databases for different application Groups at the Confidential - dis is a 24/7 support env.
• Participated in a data center migration project
• Responsible for all the database growth strategy for all the databases across Americas - Infrastructure Group.
• Responsible for the defining and implementation of database backup and tape backup strategies for whole North Americas - Infrastructure Group.
• Responsible for the defining and implementation of Autosys (Sybase, Oracle) servers for the North Americas.
• Responsible for the upgrading of the servers in both Sybase and SQL Server environments.

Consultant dba

Confidential

Responsibilities:

• Responsible for development, QA & Production Support of various databases for different application Groups at the Fannie Mae, performance & tuning of Sybase & SQL Servers & Fine tuning of stored procedures, halping the developers for the design issues from the database perspective.
• Participated in a data center migration project
• Responsible for the conversion of an application database from Sybase to Oracle 10g.
• Responsible for the logical and physical schema implementation and Defining backup and recovery procedures.
• Responsible for the Autosys Jobs, Remedy Ticketing system and also ClearQuest Enterprise Configuration Management for our applications.

Chief Architect/VP of Engieering

Confidential, New Jersey

Responsibilities:

• Confidential is a Startup company where they were focused on developing Wealth Management Solutions for High NetWorth Individuals and also for the mass affluent people.
• Performed physical and logical data modeling and also responsible for the architecture of the product.
• Responsible for the design, development and prototyping architecture for the Wealth Management Platform “WealthDirector”.
• Responsible for the thorough understanding of the Wealth Management and various strategies provided by various companies in industry (Banks, Investment Companies, Insurance Companies etc.).
• Performed comparative trend analysis of the both the businesses and software solutions being provided by various companies. Discussed the requirements and Client experience wif the industry experts.

Senior Consultant

Confidential

Responsibilities:

• Worked at Trizetto Corp, who were the developers of the FACETS application, worked wif various insurance companies - worked wif the developers and project managers of the insurance companies implementing the application and supporting the application.
• As a Sr. DatabaseAdministrator (DBA), accountable for the planning, design, implementationandmanagement