Skills

. Languages/Technologies: PL/SQL, Javascript, Perl, Python, C, C++,

Oracle 11g, MongoDB

. SDLC: Agile (Scrum) Development Life Cycle

. IDEs and other tools: Microsoft TFS, IBM ClearQuest, HP ALM Quality

Center, VersionOne, TOAD, PL/SQL Developer, PyCharm, Eclipse (Perl)

. MatLab, MiniTab, ARENA

. OS: Windows, Macintosh

. Miscellaneous: MS Excel, Access, Other Office Products, LaTeX

Experience

Ventyx an ABB Company - Database Developer March 2012 - Present

Worked in an Agile (Scrum) development environment as Software Developer

for Ventyx's Advanced Business Analytics Unit.

As part of the Operations Management development team, analysed, designed,

developed and implemented an Oracle - PL/SQL based data warehouse and used

in-house ETL, dashboarding and reporting tools.

Internationalized and localized several BI solutions including Ventyx's

Outage Management, Storm Management, Asset Reliability and Outage

Communications solutions.

Implemented an automated build and deploy solution built in Perl that

reduced installation time from 4 days to 5 hours.

Used Perl scripts for automation and maintenance tasks, extensively used

DBI and File::Find packages.

Championed continuous improvement through automation, consistent code

reviews, pair programming, team empowerment, effective use of

retrospectives, and overall adherence to Agile best practices, and

introduced an open-source model for inter-team development.

Evaluated several PL/SQL unit-testing frameworks, and currently involved in

integrating a SQL Developer based test harness with the custom build and

deploy solution.

Experience with data flow diagrams, data normalization theory and

techniques, data dictionary, physical and logical models, ER diagrams and

design techniques; strong background in data warehousing and optimization

for OLAP.

Developed complex procedures, packages, functions, triggers, materialized

views, tables, constraints and indexes (B*Tree, bitmap and function based);

built cubes from ground up (for compatibility with Oracle Standard Edition)

extensively used collections, ref cursors, exception handling, dynamic SQL,

pipelined functions, analytic functions, bulk collections, regular

expression based validations, DBMS_JOB and UTL_FILE packages.

Performance tuned SQL using cost-based optimization techniques, indexes,

hints and explain plans.

Administered development, QA and integration databases including parameter

file maintenance, disk space allocation, tablespace management, general

troubleshooting, maintaining and purging of archive logs and restore

points.

Worked in a highly matrixed environment and coordinated with clients,

product managers, customer support professionals and quality assurance

analysts to gather requirements, write up technical design documentation,

and to maintain cadence between different development teams.

Trained other resources on technical aspects as well as Agile development

practices and processes.

Ventyx, an ABB Company - Database Developer/Tester April 2011 - February

2012

Selected to work on Asset Health Center -a flagship project integrating

ABB's subject matter expertise and Ventyx's business intelligence solutions

as part of a team winning the ABB CEO's award-one of only twelve awarded

among 125000 employees.

As part of FocalPoint's Federation Support team, trained new teams, setup

environments, developed development and testing strategies, helped

bootstrap new development teams.

Developed stored procedures, functions and packages to address new

development requirements.

Involved in the business unit wide effort to improve product quality

including transition of application lifecycle management to Microsoft TFS

and HP Quality Center, integrating release delivery of FocalPoint with

other products in the organization, formulating processes for versioning

and releases of FocalPoint solutions.

Developed packages, functions and views for data validation, data integrity

and functional testing. Monitored performance using Oracle Enterprise

Manager.

Worked with clients, customer support personnel, and development team to

identify goals and requirements, define technical specifications, draw out

timelines, write and execute test plans, investigate, review and approve

defects and resolutions.

Hawkes Learning Systems, Charleston, SC-Product Developer February 2010

- March 2011

Designed and developed Hawkes Learning Systems' software for Developmental

Mathematics and Pre-algebra and Intermediate Algebra.

Developed and maintained a real time Oracle database backend to support

online testing and score reporting.

Created stored procedures, functions, packages and developed database

schema including tables, views, materialized views etc.

Monitored and performance tuned database using ASH and ADDM.

Worked closely with product managers, QA analysts, in development of

several software products including Developmental Mathematics, Business

Statistics, College Algebra, Pre-calculus, Introductory Algebra etc.

Education

Georgia Institute of Technology, Atlanta, Georgia. August 2008 -

December 2009

Masters in Industrial Engineering, GPA-3.30

Courses: Regression and Time Series Analysis, Data Mining, Probabilistic

Models, Risk Analysis, Simulation, Design of Experiments, Reliability

Theory.

Vellore Institute of Technology, Vellore, India. August 2004 - June 2008

Bachelor of Technology in Biotechnology, GPA-3.67

Miscellaneous courses and continuous learning

Inspiring Leadership through Emotional Intelligence (Coursera),

Introduction to Computer Science and Programming using Python (EdX),

MongoDB for Developers (MongoDB University)

Societies and organizations

Co-founder and Secretary, Students for Development and Exploration of Space

(VIT Chapter)

Member, Toastmasters International

Contact this candidate