SUMMARY

• Over 14 years of experience in application development including analysis, data modeling, development, implementation and support that constitutes complete SDLC.
• Experienced working on Waterfall projects as well as Agile projects.
• Easy going person that is a good team player - bring support and collaboration atmosphere to any team and allow every member of the team to shine
• Possess good problem solving and conflict resolution skills
• Developed add-in for QTP which enables QTP (all versions) to support all major browsers: Safari (latest versions), Chrome (latest versions), Firefox (latest versions), HTMLUnit and Opera (latest versions) as well as mobile support for IPhone, IPad and Android (support for emulators and actual devices).
• This revolutionary technology brings tremendous value to any organization that uses QTP because existing QTP scripts now can be run on different environments including mobile platforms (Android and iOS), Mac or UNIX as well as major browsers.

TECHNICAL SKILLS

Languages: HiveQL, Java, PL/SQL, SQL, Python, C#, JavaScript, XML, Perl, VBScript, PHP

Databases: Hadoop, Oracle, MySql, Postgres, Couchbase, Salesforce

O/S: Windows, Unix, Linux, Mac

Tools: Hive, Sqoop, Eclipse, Toad, PL/SQL Developer, Erwin

Technologies: MapReduce, Lucene, Elastic, Data Modeling for OLTP as well as OLAP models, Application Business Analysis and Design, Apache Malhout, Selenium/WebDriver, Sikuli, OCR, cakePHP framework

PROFESSIONAL EXPERIENCE

Data Architect

Confidential - San Francisco, CA

Responsibilities:

• Provided database design for storing data for various systems on MySql and Postgres.
• Built stored procedures and functions to use as APIs for front end in agile environment.
• Developed python code to read and write data to the database.
• Reviewed code submitted by other developers.

Database Engineer

Confidential - Emeryville, CA

Responsibilities:

• Used HiveQL, MapReduce, sqoop, perl, python and shell scripts to store data in hadoop and create export files.
• Created UDFs (user-defined functions) and UDAFs (user-defined aggregated functions) in Java to enhance an existing logic and deprecate use of perl scripts in HiveQL scripts.
• Experimented with some machine learning approaches and Apache Malhout project to create recommendations for music profiling team.
• Used C#, Lucene library and Elastic index to enable search for Editor application.
• Developed and supported packages, procedures and triggers in Oracle for Nuance data exchange
• Re-factored monitoring system of Open Program Development project to use Python and Salesforce as a primary database and enhanced data exchange Oracle databases.

Business Application Developer

Confidential - Walnut Creek, CA

Responsibilities:

• Performed development environment analysis for a new project to determine whether they fit the company requirements.
• Used Hadoop to prototype reporting system for Hand Held devices.
• Developed, validated and documented data modeling solutions addressing performance requirements and reusability, availability, integrity and security challenges, and business functional requirements. Analyzed data-related systems integration opportunities and challenges.
• Provided timely delivery of developed packages, stored procedures, triggers and functions for multiple projects according to specifications.

Sr. Database Developer

Confidential - San Mateo, CA

Responsibilities:

• Successfully filled role of database architect by providing database design and documentation in agile environment.
• Analyzed effects of the changes to various systems and provided a plan for data flow between several systems. This included initial migration of data as well as timely data exchange.
• Provided timely delivery of developed packages, stored procedures, triggers and functions for multiple projects according to specifications.
• Successfully conducted performance tuning for SQL queries and PL/SQL code for existing SQL and PL/SQL code.

Sr. Database Developer

Confidential - San Francisco, CA

Responsibilities:

• Developed, validated and communicated modeling solutions for both relational and dimensional models addressing performance requirements and reusability and availability. Analyzed data-related systems integration opportunities and challenges.
• Provided timely delivery of developed packages, stored procedures, triggers and functions for multiple projects according to specifications. Time was especially important when delivering pl/sql stored procedures for improved front end screens.
• Worked with data warehouse design and development: extracting, cleaning, conforming, and delivering source data into a dimensional data store.
• Successfully and efficiently fulfilled a project lead role for several projects that included sizing the project, evaluating the scope of work, coordinating Java and Perl developers and QA with different skills. Successfully implemented projects between several systems in the bank.
• Successfully conducted performance tuning for SQL queries and PL/SQL code for existing processes.

Sr. Database Developer

Confidential - Brisbane, CA

Responsibilities:

• Provided timely and efficient delivery on projects requiring Oracle technologies: designed and developed stored procedures, triggers and functions for multiple pricing projects - discount per category, product level bidding, quality based pricing project and etc. that improved company’s pricing policy and brought additional revenue.
• Developed, validated and documented modeling solutions for both relational and dimensional models addressing performance requirements and reusability, availability, integrity and security challenges, and business functional requirements. Analyzed data-related systems integration opportunities and challenges.
• Effectively tuned PL/SQL code for existing processes using collections to increase performance.
• Saved company about 20% of its income by evaluating tradeoffs of the design for product level bidding project. Project has involved middle tier and database development teams.
• Provided data for ad-hoc reports for business analysts for further review for important decision making about development strategies.
• Used home-grown ETL tools to load data logs to warehouse and oracle for billing database and provided data QA mechanism for data loading.

Sr. Programmer Analyst (Database)

Confidential, San Jose, CA

Responsibilities:

• Designed, developed and supported an application to organize annual members’ conference, and project to print labels and track roster changes for officers, board, and committee members that resulted in completed rollout of the project using OAF, Oracle Forms and Reports, and PL/SQL.

Software Engineer/System Analyst/ Technical Lead

Confidential, San Francisco, CA

Responsibilities:

• As a consultant worked in multiple number of projects that included CRM, conference management, data migration and other applications.
• Architected, designed, developed and delivered extensible and reliable persistent high volume, high availability, transaction-oriented (OLTP) database schemas for web-based business applications.
• Supervised 4 people in application development team.