SUMMARY:

• Self - motivated software professional with more than 8 years of progressive and diversified experience in Unix shell/Perl and Oracle, PL/SQL based software development; 4 plus years at client location for Confidential as Onsite Coordinator and Tech Lead.
• Proactive solution-driven individual having passion for quality and attention to detail.
• Quick learner, self-starter, creative and an exceptional problem solver with keen design and analytical skills.
• Proven success in managing software development projects in a Team Lead role. Good hands-on experience in end-to-end project lifecycle.
• Deep understanding of the business with the ability to translate business needs to functional and technical requirements.
• Proven ability to influence and collaborate across cross-functional teams and internal partners and ability to manage deadlines and meet cost constraints.
• Strong consulting and client interfacing skills with experience in bridging technology and business goals to provide productive solutions.
• Proven leadership skills and project level planning in defining project scope, goals and deliverables that support business needs in collaboration with senior management and stakeholders. Effectively communicating project expectations to team members and stakeholders in a timely manner.
• Adept at gathering and transforming business requirements into functional requirements.
• Comprehensive knowledge of Waterfall and Agile software development methodologies.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases such as requirements gathering, analysis, design, development, testing and Production maintenance/support.
• Strong database querying and reporting skills using Oracle, PL/SQL, Unix shell and Perl scripting.
• Very competent in various Oracle and PL/SQL concepts including but not limited to, stored procedure, functions, triggers, materialized and non-materialized views, aggregate functions, dynamic SQL, ref cursors, complex queries using joins, sub queries etc.
• Exceptional analytical & problem solving skills in Oracle; proficient in data modeling, entity and attribute identification, developing Entity-Relationships.
• Good understanding of Hadoop ecosystem (HDFS, Hive, OraHive, Sqoop). Expertise in dealing with large datasets including storage of data in HDFS, interacting with and querying large datasets in distributed file system using Hive, and data transfer between Oracle tables and Hive tables using OraHive.
• Familiar with SQLite and CQL; learning Python and MongoDB.
• Extensive working knowledge and experience in using Splunk for data extraction and reporting using CLI, UI and Dashboard. Good at using regex for querying on Splunk data.
• Proficient at developing scripts for automation of reporting and ETL processing.
• Familiar with building web applications using Oracle APEX tool.
• Willingness to learn new skills and expand current skill set
• Worked under pressure in critical production environment situations; experience with 24x7 on-call support to proactively identify and troubleshoot live systems issues.
• Great team player with excellent communication, networking and interpersonal skills. Could work equally well in an individual environment.

TECHNICAL SKILLS:

Languages: Unix Shell scripting, Perl scripting, SQL, PL/SQL, Pro*C, C, C++

Web Technologies: HTML, CSS, Java (Basic), Jasper

Databases: Oracle 11g/10g/9i, Vertica

Tools: /Utilities: SQL Developer, TOAD, SQL*Plus, SQL*Loader, Oracle APEX, Splunk

OS: Linux, Mac OS X, Red Hat Linux

Hadoop: HDFS, Hive, OraHive, Sqoop

Management: MS Office, Pages, Numbers, Keynote

Configuration Control: SVN

Messaging System: Familiar with Kafka

PROFESSIONAL EXPERIENCE:

Technology Lead

Confidential, Cupertino, CA

Responsibilities:

• Leading a three membered team comprising two members at offshore. Interfacing with senior management and Level 3 and 4 DBAs to gather and analyze requirements and working with the team to develop and deploy efficient solutions to automate the operational and maintenance tasks of DBAs for managing the large infrastructure of active-active distributed databases in Confidential .
• Identifying and resolving issues with very short turnaround and supporting various automated scripts for the DBA team’s day-to-day admin tasks.
• Developing Unix shell and Perl scripts to automate extraction of storage, usage and performance data from the large number of Oracle databases for iTunes and iCloud.
• Preparing scripts in Unix shell and Perl used for various types of reporting and alerting, involving complex Oracle PL/SQL queries, stored procedures, functions etc.
• Developing scripts for automation of Disaster Recovery activities. Working on enhancements to various utility scripts for managing DB roles, VIP status, FSFO status, storage and health of database hosts, etc.
• Building web applications using Oracle APEX tool.

Technology Lead

Confidential, Cupertino, CA

Responsibilities:

• Led small and medium sized teams as onsite Technical Lead in delivering many projects from idea to implementation.
• As team lead, actively involved in all phases of project life-cycle; Met and discussed with multiple cross-functional teams to define technical and functional requirements, prepared requirement specification and design document, test plans, tracked development, testing and deployment of projects, prepared implementation plan, managed configuration control and provided support and maintenance.
• Collaborated with Confidential external partners and data publishers on setting up interfaces for ingesting business critical data. Built automated scripts using Unix shell, Oracle SQL*Loader, stored procedures and packages, PL/SQL, and Java JDBC for extraction, transformation and loading of data in Oracle tables. Designed and developed programs to implement complex business logic for processing the data and making it available to other downstream teams.
• Led solutions engineering that involved process automation and functionality enhancement. Replaced time-consuming, error-prone manual processes with elegant, automated solutions.
• Worked closely with DBA team in migrating user account data from one database to another. This involved very complex programs in Oracle PL/SQL to compute logical criteria for identifying user accounts and moving data using joins with multiple tables.
• Developed smart solution for near real-time data extraction from Splunk and reporting on dashboard, for iTunes Festival.
• Reengineered multiple reports that led to performance improvements and faster data availability.
• Worked with Engineering team on extraction and profiling of user experience data for apps, helping in fine-tuning the data capture logic prior to launch. Built automated batch processing scripts in Unix shell to load the data in Oracle tables, used scp to copy data to Hadoop cluster, and queried data for reporting purpose using Hive. Used Sqoop and OraHive to interact with and transfer data between Oracle and Hadoop (HDFS).
• Developed reports for various reporting needs implementing Oracle and PL/SQL concepts like WITH clause, nested and correlated sub queries, date functions, aggregate functions, joins, Group By, inline functions, HTML tags etc.
• Designed and developed Unix shell scripts, Oracle stored procedures for batch processing Invoice and Tax data. Worked with different teams for support and maintenance, ensuring smooth data flow during important business heavy events like Holiday season and product launches.
• Worked closely with vendors that provide Confidential critical transaction data (FX rates and Bin Ranges), on implementing scalable processes and troubleshooting challenges.

Technology Analyst

Confidential, Cupertino, CA

Responsibilities:

• Involved in all stages of Software Development Life Cycle of the project, partnering with various cross-functional teams (SAP, UI, QA, internal testing and support) spread across different geographies.
• Primary point of contact at onsite for the AOS backend engineering team. Gathered business requirements from SAP and other stakeholders.
• Developed batch processing program using Unix shell script, SQL*Loader, PL/SQL and Stored Procedure for ingesting and processing commit code feed files from SAP and load data in Oracle database. Worked with application team to integrate script with web service for fetching data from Oracle tables and publishing to front end.
• Coordinated with testing teams during unit, integration and user acceptance stages of testing to ensure bug-free code. Successful in delivering finished product matching high standards of quality, strict deadline and budget, which led to enhanced customer experience.

Senior Software Engineer

Confidential

Responsibilities:

• Analyzed business requirements, existing architecture and data model to define problem statement and translate them into technical and functional specifications; created Entity-Relationship (ER) diagram from the schema using Oracle SQL Developer tool, applied Tree structure to the table hierarchy to understand parent-child relationship.
• Reengineered the complex PL/SQL package and simplified it using Dynamic SQL, Bind variables, Merge queries, BULK COLLECT, FORALL, identifying parent and child nodes at run time using foreign key constraints in the schema.
• Optimized the query performance using indexes and hints.

Software Engineer

Confidential

Responsibilities:

• Designed schema in Oracle database and created database objects like tables, views, synonyms, sequences, indexes, global temporary tables, DB links etc.
• Developed many reports implementing complex business requirements for querying database using Oracle and PL/SQL concepts such as triggers, functions, stored procedures, cursors, materialized views, joins, sub queries and correlated sub queries. Built wrapper scripts for reporting and batch processing using Unix shell scripts and Pro*C
• Used Oracle Data Pump and Export/Import utilities for high-speed bulk data movement.
• Developed efficient solutions for database management for purging large data volumes using Bulk delete, point-in-time reporting and data recovery using Oracle Flashback query.
• Used query tuning and Partitioning concepts, SQL Trace, TKPROF, Explain Plans for optimizing performance of various reporting queries and managing large data volumes.