SUMMARY:

• Over the past 16 years have been working in IT. Worked as a developer using Java, C#, C, C++, Oracle developer. Over ten years working as Oracle and SQL server Database Administrator. Past two years working as a Hadoop Admin and Big data Architect.
• Areas of expertise most of any technical team would emphasize on:
• Database administration / Database Architecture / Hadoop administration
• Multiple cluster installations / Maintenance
• Server builds/Software installations
• Creating jobs
• Upgrades/ applying patches
• Over 16 years of experience in IT and Expertise in Oracle DBA, SQL Server DBA, Unix, Java, SQL&PL/SQL. Over 2 years of experience in BigData, Hadoop, HDFS, HBASE, Hive, pig and Linux with hands - on project experience in various Vertical Applications which includes Healthcare, Pharma, Telecom, Financial Services, and eSales.
• Extensive Experience on UNIX, Shell Scripting and SQL.
• Good Experience SQL performance Tuning.
• Expertise in Oracle and SQL Server administration, Backup/Restore, performance tuning, high availability, monitoring, creating jobs for database maintenance.
• Expertise in HDFS Architecture and Cluster concepts.
• Extremely motivated with good inter-personal Skills; have ability to work in strict deadlines.
• Expertise in Hadoop Security and Hive Security.
• Expertise in Hive Query Language and debugging hive issues.
• Expertise in sqoop and Flume.
• Involved in implementation of Hadoop multi node cluster, installed Hadoop Ecosystem softwares, configured HDFS.
• Worked on Multi Clustered environment and setting up Cloudera Hadoop echo-System, creating jobs to get the data from RDBMS to HDFS, from HDFS to RDBMS.
• Experience in Big Data, Hadoop architecting.
• Worked on Hadoop environment (HDFS) setup, Map Reduce Jobs, HIVE, HBase, PIG and NoSQL and MongoDB
• Software installation and configuration
• Built automation and internal tools for Hadoop jobs.
• Managed project deployment & configuration.
• Done performance analysis and capacity planning for multi node clusters.
• Trouble-shoot and triage production issues.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator / Hadoop Admin / Architect

Responsibilities:

• Configured and built multinode cluster and installed Hadoop Eco system softwares such as HDFS, MapReduce, HBase, Pig, sqoop, spark and Hive.
• Responsible for maintaining and performance tuning on Hadoop cluster.
• Experienced in running Hadoop streaming jobs to process terabytes of xml format data.
• Load and transform large sets of structured, semi structured and unstructured data.
• Responsible for administering Unix/Linux along with Databases.
• Administer Hadoop, diagnose databases, storage, and other backend services.
• Responsible to manage data coming from different sources.
• Got good experience with NOSQL database.
• Supported Map Reduce Programs those are running on the cluster.
• Involved in loading data from UNIX file system to HDFs
• Installed and configured Hive and also written Hive UDFs.
• Responsible for 24/7 on call and cluster availability, scalability, high availability and fault tolerance.
• Involved in creating Hive tables, loading with data and writing hive queries which willrun internally in map reduce way.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Involved in data modeling for the application and created ER diagram using ERWin.
• Implemented database standards and naming convention for the database objects.
• Expert in two database platform (Oracle, SQL-Server) with solid knowledge of RDBMS-specific tool and utility knowledge and experience in such areas as monitoring, database migration, DDL management and replication.
• Experience with Oracle RMAN, Oracle Data Guard, Veritas and Net Backup, Knowledge of Veritas volume manager, Veritas Cluster Server and SAN
• Has a strong understanding of data warehouse concepts
• 2 years of experience with Hadoop, HDFS, MapReduce and Hadoop Ecosystem (Pig, Hbase, sqoop, zookeeper, Flume & Hive).
• Experienced in installing, configuring, and administrating Hadoop cluster of major Hadoop distributions.
• Have hands on experience in writing MapReduce jobs using Java.
• Hands on experience in writing pig Latin scripts and pig commands.
• Hands on experience in installing, configuring and using ecosystem components like Hadoop MapReduce, HDFS, Sqoop, Pig & Hive.
• Configured Zoo Keeper to the existing hadoop cluster.
• Hands-on experience with Hadoop applications (such as administration, configuration management, monitoring, debugging, and performance tuning).
• Ability to effectively adapt to rapidly changing technology and apply it to business needs.
• Experience in effectively managing projects in a cross-functional environment. Has effective interpersonal and communication skills and proven leadership skills.
• Written proposals and technical documents.
• Has ability to solve problems quickly and thoroughly.
• Proven ability to establish and maintain a high level of user trust and confidence in the IT group's knowledge of and concern for, users' business needs.
• Have strong skills in performance tuning and administration of Oracle database administration.

Environment: Bigdata, Hadoop, Oracle, SQL Server, Unix, Linux, NOSQL, Hive, HBASE, Sqoop, OEM, Zookeeper, Solr, Flume, Pig, Spark, HDFS, MaoReduce, Datawarehouse, Windows 2008, Cluster HA, Unix Shell Scripts

Confidential, RTP, NC

Oracle/SQL server DBA

Responsibilities:

• Relocation of Databases from one server to another server using attach and detach databases.
• Touch works application was implemented in Active Passive clustered environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters.
• Maintaining the database consistency with DBCC at regular intervals.
• To set up SQL Server configuration settings.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and dead-locks.
• Maximum performance and uptime in production environment.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: Oracle, SQL server, Clarity, Unix, Windows, DTS, SSIS, SSRS, Shell Scripting

Confidential, Durham, NC

Web Developer/ DBA

Responsibilities:

• Created web pages Admin Tool in Active Server Pages using Visual Interdev
• Written code, Data validation using ASP, VBScript, JavaScript, HTML, XML for web interface screens
• Used SQL and created PL/SQL procedures extensively Using TOAD.
• Created Web Pages for setting the Permissions for NT Users (ex. Managers for different groups).
• For a quick review to get approval from the clientele did the Proto Type with MS-Access Database.
• Created the application as browser compatible to work in both Netscape and IE.
• Architecture: B2B Web Application.
• Worked as a SQL Server DBA to maintain the database.

Environment: Java, C#, SQL Server, Java Script, VB Script

Confidential, NC

TEAM LEADER / DEVELOPER

Responsibilities:

• Created web interface for an electronics web based store to enable the sales and purchase from the wholesale distributor and retailer data transactions.
• Involved in data modeling, system analysis, design and coding. The database is designed in Erwin data model for SQL Server 2000 to create the data maintenance of wholesale distributor data and returning retailers, retail sales, and financial data, shipping status etc.
• Primarily responsible for writing .net Class Libraries in VB.Net as a wrapper API to DocumentumeContent Server core functions. COM Interop was used extensively to achieve that
• Created Web Forms using Visual Studio.Net, written code components and created .aspx, .aspx.resx, .aspx.vb files for the web application.
• The COM+ components are written using C# to extract data from the SQL Server 2000 to the front end ASP’s. COM+ enables to operate several instances of the same application for multiple transactions.
• The design of the system enables to add new modules for enhancement of system requirements based on business users.
• Wrote and validated functional specification, Prototypes, Design Documents, Coding standard and UML Object model for all class libraries and code modules for interaction with SQL 2000 backend data objects.
• Created Web services for web pages to render datasets basing on client requests.
• Built Middle-Tier interface using SOAP & XML for the existing backend repository which supports non-Win32 platforms.
• Developed/Implemented validation schemas for input XML validation, XML messages were the objects for transactions between the client and the server.
• Created Active Server Pages using Visual Studio.NET for the web site which in turn talk to the middle tier COM+ objects where the business layer is defined.
• Deployed personalized portals on Commerce Server for catalog management and order processing.
• Used Plumtree for navigation and customizing UI.
• Error Handling, Testing Phase code review .

Environment: Visual Basic, SQL, XML, ASP, JavaScript, VBScript

Confidential

SR. DEVELOPER / DATA WAREHOUSE ANALYST

Responsibilities:

• Created web pages using Active Server Pages using Visual Interdev for a Data entry screens with JavaScript, HTML, XML.
• Created screens for Data validation using ASP and VB.
• Used SQL and created PL/SQL procedures extensively to extract data from Legacy System using Corvu.
• Joined the tables and getting the data from legacy system using Abinitio.
• Generated queries, Graphs and reports using Corvu.
• Created the application as browser compatible to work in both Netscape and IE.

Environment: ASP, VB, SQL, PL/SQL, JavaScript, HTML, XML, Corvu

Confidential, NC

TECHNICAL LEAD / DEVELOPER

Responsibilities:

• Created web pages using Java Server Pages and Java Beans for a Bid request with HTML, JavaScript, XHTML, XML,XSLT and business logic is embedded in Beans.
• Responsible for analysis, requirements gathering, design, development, testing, deployment and maintenance of system solutions.
• Frequent interaction with clients and various levels of management.
• Used SQL and created PL/SQL procedures extensively to extract data from DB/2 tables
• Created Cookies for authentication purposes.
• Created screens for authentication for allowing access US reseller websites to create a bid allows the business partners.
• Bulk Mailing to the email addresses using Java mail and Confidential mail.pm.
• Created the application as browser compatible to work in both Netscape and IE.
• Used Net.Data, Net.Commerce with Lotus Domino Go Server using GWA standards.
• Tested and deployed application on Websphere Application Server in Aix UNIX and Windows NT.
• Entire application is designed and developed using J2EE architecture .
• Used CORBA as a middleware to communicate with objects.
• Created web page modules in Cold Fusion for B2C related interfaces and used Cold Fusion Web application server for delivering scalable e-business applications.
• Architecture: n-tier Web Application.

Environment: Java, JSP, XML, HTML, Webspere, Unix, SQL, PL/SQL, CORBA, Cold Fusion, Unix Shell Scripting

Confidential, CA

Developer

Responsibilities:

• The Confidential Website and portal development project was initiated to expand upon the Confidential Company’s ability to provide Internet communication services to Actors, Agents, Directors and Producers within the entertainment industry.
• Development of the presentation layer, which was comprised mainly of ASP’s interacting with COM Objects to produce the dynamic content and usage of SQL queries inline code modules.
• Created PL/SQL procedures extensively to extract data from Oracle Database using ODBC.
• Created Active Server Pages using COM Objects to interact with webpages and Database.
• Done LDAP programming for authentication. Created HTML, JavaScript, XML and XSLT templates, from requirement specifications provided by Confidential .

Environment: Java, JavaScript, LDAP, XML, HTML, SQL, Unix, Shell Scripting

Confidential, AZ

Analyst / Developer

Responsibilities:

• Designed and developed a web based application to provide users with information of restaurants within their geographical reach.
• Wrote programs in Java for registration of restaurants and users. Created GUI using Swings.
• Developed application for restaurants and users to login with password for specifying restaurant services and user requirements. Used HTML and Java applets with JavaScript, VBScript, ASP using Visual Interdev to develop the application.
• Visual SourceSafe maintains version control. Coded programs for Servlets to connect with Oracle 8.0 database and used COM objects to read data from SQL Server using SQL queries and display in Active Server Pages. Established database connectivity using JDBC compliant drivers. Hosted application using Java Web Server 2.0.

Environment: Java, VB, VBscript, SQL, PL/SQL, HTML, JavaScript, Unix, Windows

Confidential, Chicago, IL

Datawarehouse Developer

Responsibilities:

• As Web Developer for the Transportation and Logistics Project, I helped to create an Intranet site for Confidential Inc.
• A web based application Transportation logistics system was developed using Java, Applets, JavaScript, VBScript, ASP, HTML using Visual Interdev and we created COM components where application servers reside at the host.
• Designed and developed a system using Java and data service layer using JDBC for communicating with the EDI data via the Java WebServer, used COM to extract data from Oracle database using inline SQL in the code to present the data into Active server pages.

Environment: Java, JavaScript, ASP, HTML, SQL, PL/SQL, Unix, Windows

Confidential

Analyst / Developer

Responsibilities:

• Responsibilities include technical features encompass:
• Design and development of Hospital Management System for NMHS based on Client-Server. Developed user interface for both modules using application generator and resource workshop.
• Designed and developed application generator, schema builder using ORACLE 7.1 using Forms 4.5. In- Confidential t details, Out- Confidential t details, medical stock and store stock maintenance, Doctors details, Bed status, Diagnostics System, Operation theater schedules etc. are included. On-line menu handles IP & OP Pharmacy details.
• Pharmacy is segregated for IP & OP. Generated reports for Accounts payable, Payroll and Personnel modules are well designed which supports the best user friendly environment. A total control over the Hospital Management is fetched by this system. My Role as Team Member / Analyst and responsibilities: Participated in analysis, designing and created forms for Diagnostic System, Pharmacy Details, In Confidential t Details, Out Confidential t details, Billing (IP / OP), Doctors / Consultants Details, Payroll system and have done coding for above modules.

Environment: Oracle, SQL, PL/SQL, Oracle Forms, Unix