SUMMARY

• 10+ years of data management, analytics and leadership experience managing large databases across multiple industry sectors
• 2+ years of experience with Hadoop stack: MapReduce, Pig, Hive, HBase, sqoop, and Oozie
• Effectively managed Oracle Enterprise Applications and Databases for over 13 years
• Experience in installing, configuring and managing Hadoop ecosystem components like Hadoop MapReduce, HDFS, HBase, Oozie, Hive, Sqoop, Pig, Zookeeper and Flume.
• Ability to optimize the usage of Hadoop to get maximum performance in Amazon Web Services and in - house data centers
• Experience in importing and exporting data using Sqoop from HDFS to RDBMS and vice-versa. Extending Hive and Pig core functionality by writing custom UDFs.
• Experience in analyzing data using HiveQL, Pig Latin, HBase and custom Map Reduce programs in Java
• Experience in building, maintaining multiple Hadoop clusters (prod, dev. etc.,) of different sizes and configuration and setting up the rack topology for large clusters.
• Hands on experience with ability to produce positive results through expense management and partnering across cross-functional teams
• Experience working in Operations, Architecture and Strategy teams in building and managing large scalable distributed systems
• Global Service Delivery experience by bringing together resources to accomplish organizational goals using ITIL framework
• Proven strength in managing off shore resources, meeting goals and producing results oriented team through excellent interpersonal, motivational and communication skills
• Expertise in hiring, training, motivating new employees and vendor management

PROFESSIONAL EXPERIENCE

Confidential, Morristown, NJ

Hadoop Developer

Responsibilities:

• Executed queries using Hive and developed Map-Reduce jobs to analyze data
• Developed Java MapReduce programs for the analysis of sample log file stored in cluster
• Developed Map Reduce Programs for data analysis and data cleaning
• Used Sqoop to import data into HDFS and Hive from other data systems
• Using Core java Technologies to manipulate data from HDFS and getting desired results
• Hadoop Map-Reduce used to analyze unorganized text files, searching for data or pattern
• Worked on loading the data from MySQL to HBase where necessary using Sqoop

Confidential, Parsippany, NJ

Big Data Analyst

Responsibilities:

• Actively participated in the deployment of Hadoop 2.0.0 cluster in fully distributed mode, Cloudera manager 5.2.3
• Monitored the various dedicated clusters for production, development and testing
• Extensively used Map-Reduce to process the available terabytes of data
• Used various compression techniques in HDFS like Snappy, lzo, gzip
• Used Hive to query the exported CSV data containing billions of data records
• Created schemas for HBASE tables and also utilized the performance of Hive on top of HBASE
• Used Pig default transformations and UDF to transform large datasets
• Actively involved in the decision process of the data flow and utilization
• Built and managed a team of five on-shore and off-shore staff enabling 24x7 support; guided staff in career development
• Responsible for daily operations of a 20,000 user global Oracle EBS system
• Daily responsibilities included planning, architecting, acquiring, and administering the database and application infrastructure for enterprise wide deployments
• Guaranteed uptime on numerous database servers located in various data centers by flawless change execution and monitoring resulting in minimal downtime and exceeding the SLA
• Maintained 100% compliance to all SOX procedures and also mandated the same level of compliance within the group
• Ensured code migrations followed the software development processes and are compliant with overall security policies
• Architected a global patch management strategy by collaborating with various business units
• Developed an internal knowledge base of all issues resolved by team resulting in reduced downtime and increasing customer satisfaction
• Spearheaded technical assessment and impact analysis of R12 upgrade and presented the findings to senior management
• Developed processes for daily team activities such as assignment of shifts, clarified roles and responsibilities and suggested process steps resulting in the team work efficiently
• Actively protected confidential information, always careful to guard against careless release of important information and PII and PCI data
• Managed third party tools such as Control M, Synchro Brazil, ADP taxware, and KRONOS
• Developed documentation detailing policies and service level agreements between departments leading to the definition of a service catalog
• Delivered a high availability by implementing PCP for EBS concurrent processing management
• Led and delivered successfully EMEA R12 multi-tier install and upgrade project
• Maintained and supported 20 EBS databases used for development and support activities
• Daily activities included cloning, patching, monitoring and administering EBS environments
• Responsible for Oracle Applications version release 11.5.10.2 production environment
• Experience with configuration of Oracle e-Business tech-stack 11.5.10.2 with 11gR2 database in a multi-tier load balanced environment
• Provided Oracle SYSADMIN support for setting up Printers, configuring custom Concurrent Managers, workflow mailer setup, scheduling jobs using specialization rules and work shifts
• Successfully led Oracle database upgrades from 9i to 10g and from 10g to 11g
• Successfully delivered ATG RUP 7, Brazil localization and baseline patches
• Identified performance issues and provided action plan to resolve using different tools like AWR
• Managed applications reporting tools such as Discoverer versions 4i and 10g
• Worked closely with developers, team members, and the project management office to design database structures and ensure objects are created efficiently

Confidential, Chicago, IL

Senior Oracle Database Administrator

Responsibilities:

• Experience with configuration of Oracle e-Business tech-stack 11.5.10/9iAS/10gDB in a multi-tier RAC environment
• Member of Oracle on Demand team responsible to deploy software based on customer specific needs and budget requirements
• Supported Oracle Portal versions Portal 9.0.2, 10G with IAS and infra databases (LDAP repository), J2EE, and Webcache
• Identified and resolved performance issues using tools such as Statspack, or AWR in 10g
• Authored resolutions to escalated issues into the Knowledge BASE
• Managed applications having Discoverer versions 4i and 10g
• Experience in Oracle Parallel Concurrent Processing (PCP) in RAC database deployments
• Diagnosed and resolved java-based workflow mailer and email mapping issues
• Coordinated technical details and action plans with subordinates and vendors for RDBMS and application level maintenance procedures
• Provided timely detailed action plans for high priority and recommended patch deployments to manage and implement scheduled customer system maintenance
• Recognized and communicated to executive management and implemented approved plans to meet Operations' needs for additional products, support, and services
• Served in leadership role for prevention, detection, identification, and resolution of technical issues in the On Demand outsourced environment

Confidential, San Francisco, CA

Senior Oracle DBA

Responsibilities:

• Provided 24x7 support for Oracle On-Demand environments for top 20 platinum clients
• Served as escalation point for technical issues that cannot be resolved by customer DBA teams
• Performed disaster recovery tests for various E-Business Suite Release 11i hosted customers which included switching the database and middle-tier services from the primary site to remote secondary site
• Responsible for service restoration of various Oracle Applications systems within the clients SLAs
• Diagnosed and resolved customer system outages within the SLA time period
• Maintained Oracle Applications using various application utilities
• Suggested enhancements to and performed, daily, weekly, monthly, and quarterly maintenance to production systems as procedures as defined in the operational guides and standard procedures of DBA Management
• Performed various database recoveries, which included creating 4-node RAC (Real Applications Cluster) standby environments.
• Developed and implemented maintenance procedures in accordance with client-centric resolution timeframe and blackout window policies
• Created daily reports about Service requests resolved, which are required for audit (SOX)
• Experience in setting node and entity level blackouts in blackout tool in 10G database used during downtime to prevent false alerts from Oracle Enterprise Manager
• Used COMS (Change Management database) which is a change management tool to record all the changes done to an environment according to SOX policy

Confidential, Cupertinio, CA

Oracle Applications DBA

Responsibilities:

• Administered environments and tools centrally accessible to developers
• Proactive monitoring of Oracle Applications, database monitoring, apache monitoring
• Prioritized concurrent issues to meet client satisfaction and service level agreement commitments
• Cloning an existing Oracle Applications System configuration to a new Oracle Applications System using RAPIDCLONE
• Administered and maintained Apache web servers, concurrent managers, forms servers and multi-node web deployments
• Set up custom forms, menus, sub-menus, functions and concurrent programs
• Developed Unix shell scripts to automate database operation and database monitoring
• Continuously updated technical and procedural documentation based on increasing productivity and client satisfaction for both unique and repetitive situations