Data Project

Yegu Subbiah, MBA

*** **** **** **** ****, CT ***01

860-***-**** acx19f@r.postjobfree.com

Database Architect

Highly Experienced in DevOps Architecture, Excellent Program Management

Comprehensive knowledge in database architecture, with expertise in SDLC, Oracle technology stack, Waterfall, Iterative and Agile methodologies, and on-time project delivery. Excellent verbal and written communicator. Strong track record of building, leading and motivating teams.

CORE COMPETENCIES

Business Process Improvement Customer & Vendor Relationships Program Management Data Modeling Solutions Advice Troubleshooting Service Delivery Cost Reduction

EXPERIENCES AND ACHIEVEMENTS

ISO New England, Holyoke, MA 2011 – Present

An Independent, non-profit Regional Transmission Organization serving New England

Database Architect / Senior Computer Scientist

Manage DevOps model business critical forecasting applications integration, ensuring business operations continuity and minimizing downtime.

Work with business to obtain, analyze and translate business requirements into data models and implementation

Oversee New England electricity market database architecture ensuring high performance, quality software and on time delivery, saving 7 man months

Provide architectural solutions identifying vulnerable areas to upgrade .NET software

Offer expert support in Performance Tuning, ETL, SQL, PL/SQL, stored procedures, functions, triggers and packages

Demonstrated expert-level development and implementation of database objects to enable weather transactions via RESTful web interface

Automated processes for managing partitions and purge old data using Oracle stored procedures/Unix shell scripts

Redesigned database physical and logical structures to improve application response in Oracle 11g – part of fine tuning

Led Windows 7 implementation, ensuring seamless transition

Managed projects effectively delivering a high quality product on time and within budget

Managed releases involving critical market and operations applications development with minimal business impact

Environment: Oracle 12c/11g, PL/SQL developer, Visual Studio 2012, CVS, VSS

Yale University, New Haven, CT 2011

Leading teaching and research university

Architect / Software Consultant

Working within Enterprise Systems, Yale University ITS, delivered critical project for the Yale School of Medicine on time and in budget.

Led project lifecycle, from translating initial proposal, formal requirements to implementation

Prepared technical design document and application performance improvements

Led optimization improving database performance

Led analysis and troubleshooting, improving performance in data accuracy

Delivered additional enhancements proposed within original estimated time, saving 3 man months

Environment: Oracle 11g, Oracle Forms and Reports, TOAD

Webster Bank, Bristol, CT 2007 – 2011

National US commercial bank

Data Architect

Successfully delivered $400,000 project on time and in budget, involving applications that supported internet retail banking business and user base of 600,000+ customers.

Enforced strong internal controls over access to data, working closely with senior IT security and Database Management groups to meet compliance and auditing requirements

Led solution architecture for business problems and presentation to key stakeholders

Automated email generation to the respective teams in case of outages or emergency in databases

Troubleshot production issues, identifying root cause and providing technical direction

Integrated email communication with vendor email services, preparing and executing the integrated project plan, responsible for technical design and development

Demonstrated expert-level development and implementation of database objects to enable customer-initiated financial transactions via java-based web interface

Automated processes for online fund transfers using Oracle stored procedures/Unix shell scripts

Involved in design and creation of database physical and logical structures in Oracle 10g

Conducted data migration using UNIX shell scripts, SQL*Loader and Export and Import utilities

Worked extensively in performance tuning, SQL, PL/SQL, stored procedures, functions, triggers and packages

Provided training for Oracle 10g features to different project teams

Environment: Oracle 10g, Oracle Developer, ERWIN, TOAD, PL/SQL Developer, SQL *Plus, SQL *Loader, Export, Import, TKPROF, SVN, Microsoft Project, Excel, IBM AIX 5.2

ESPN Inc., Bristol, CT 1998 – 2007

Global cable and satellite television channel

Architect

Acted as lead developer of a high-transaction, high-profile, sensitive system in Oracle 9i, with projects handling foreign currency, time zone, Oracle A/R interface and SAP implementation.

Managed projects from requirement through deployment, present solutions and recommendations, technical decisions and create test plans

Demonstrated expertise in designing, developing and manipulating Oracle databases

Designed, developed and deployed new modules to existing system for multiple business units

Completed performance tuning, data modeling, centralizing business rules, troubleshooting production issues, and explained plan run over critical queries in Estimating Costs

Identified root cause of errors and provided technical guidance as required

Create database objects Tables, Views, Indexes, constraints and Database links, develop PL/SQL Procedures, Functions, Packages and triggers, create Oracle user accounts and grant privileges

Environment: Oracle 10g/9i, Forms & Reports 6i, TOAD, SQR, PL/SQL, PVCS, IBM AIX 5.2

KPMG at HP, San Jose, CA 1998

Multinational consulting and advisory firm

Systems Consultant

Played critical role in development, testing and implementation of modules for Data Cleansing, Data Collection from EDI, Data Filtering /Transformation and validation rules for each data element and reporting for a robust demand planning engine to support Hewlett-Packard’s PC division.

Participated in design of data model, creating database objects (Tables, Views, Indexes, constraints, database links), developing procedures for customer authentication

Identified bottlenecks and tuned application for better performance

Environment: Oracle 8i, C, PL/SQL, PRO*C, SQL *Plus, PVCS, Windows/NT, HP-UX

Earlier Roles

Application Architect Program Lead Team Lead Technical Lead Systems Analyst Software Engineer

EDUCATION AND TRAINING

Master of Business Administration Madurai Kamaraj University, India

Master of Computer Applications, University of Madras, India

Postgraduate Diploma, Operations Management, Indira Gandhi National Open University, India

Bachelor of Science, Mathematics, University of Madras, India

Contact this candidate