SUMMARY:

• 18+ years of experience in a multi - tiered database development and support
• Off-shore team management in Agile Scrum environment (Pune, India)
• Microsoft Certified DBA (Sql2012, Sql2008, Sql2005, Sql2000)
• Informatica PowerCenter 8.6 Certified Administrator
• Sybase Certified ASE 12.0 Server Administrator Associate

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

DW Architect/Manager

Responsibilities:

• In collaboration with another engineer, created a Data Warehouse solution, which utilizes Financial & Sales data from various data sources for existing Confidential customers.
• Maintaining database schemas, DDL, logical & physical database design, index design
• Implementing SSIS management framework (master & template packages, configurations, logging), SSIS packages and ETL stored procedures
• DBA Role
• Query performance analysis and tuning
• Capacity planning
• Working with Sql server installs, creating new database environments, managing db maintenance plans, performing backups/restores, deploying database changes to production, resolving data issues
• Providing support for external customers (pre-Sales, post- Sales)
• Maintaining Tableau 8 Server(backups, upgrades, tabadmin, tabcmd), building simple Tableau dashboards
• Performing release & build management via Tortoise SVN & Jenkins

Confidential

DBA/Report Writer

Responsibilities:

• Designing and developing internal reporting system (logical & physical db schemas, stored procedures, reports).
• Creating & maintaining simple C# console app, which utilizes API calls and synchronizes data between external & in-house databases.
• Performing SQL Code performance turning and troubleshooting
• Providing internal customer support

Confidential, San Francisco, CA

DBA

Responsibilities:

• SQL Server DBA role
• Support for prod, sql server installs, creating new database environments, managing db maintenance plans, performing backups/restores, supporting log shipping via Quest Lite Speed 6, deploying database changes to production, running ad-hoc queries, maintaining database schemas.
• Report developer role:
• Creating and modifying existing reports using MDX and T-SQL, working with data-driven subscriptions
• Collecting reporting requirements from end-users
• Implementing SSRS custom security extensions for external customers- faced reporting
• OLAP developer role:
• Creating and maintaining data source views (DSVs), named queries, cubes, dimensions and measures to support reporting activities.

Confidential, San Francisco, CA

Staff Enterprise Systems Admin

Responsibilities:

• Maintaing db schemas & dictionaries, logical & physical database design
• SysAdmin support for internal and external Web-based Applications.
• Informatica PowerCenter 8.5.1 Admin role
• Change Manager/Release Manager role (based on ITIL v.3 framework): validation of change requests, deployment to production
• Sql Server 2005 Reporting Services (SSRS) Administration
• Transitioning MS SQL 2000 systems into MS SQL 2005

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Support and development for in-house developed financial software package, which calculates royalties received from the Licensing of Confidential technologies for Trademark and Patents. It translates each legal agreement between Confidential and its licensees into a royalty structures such as tiered rate based calculation by volume sold, several incentive discounts, lump sum payments, Cost of Living Adjustments (COLA), etc
• Support and development for other in-house developed VB Applications such as Royalty Reporting Excel spreadsheets
• MS SQL Server DBA role (support, sql code optimization, data analysis, data conversion, maintaining data model)
• Manager Role ( one direct report+one contractor)
• Release Manager role (releases into production & test environments, process enforcement via DevTrack bug tracking system workflow)
• Helping other engineers with sql development
• Writing Functional & Design specifications and other documentation
• Providing internal customer support, leading sessions

MS SQL Server 2000/2005, DevTrack 5.6.6, MS Excel 2000, VB .NET 2.0, Visual Basic 6.0 (VB6), MS Visio, Telerik Controls for .NET 2.0, Visual Studio 2005/2008, Embarcadero ERStudio 6.0

Confidential, Mountain View, CA

Database Engineer

Responsibilities:

• Sybase/ MS SQL Server DBA role (support, sql code optimization, data analysis, data conversion)
• Database Architect role (maintaining data model, data dictionary, upgrade scripts)
• Transitioning PowerBuilder5.0/ Sybase ASE 12.0 data feeds system into VB6/ MS SQL Server 2000
• Redesigning and redeveloping reporting system for the National Oncology DataBase (DTS, stored procedures, queries, reports).
• Visual Basic 6.0 Development: ADO, ASP, UI, file management
• Helping/mentoring other engineers with sql development, leading sessions
• Writing Functional & Design specifications and other documentation
• Providing internal and external customer support

Confidential, Oakland, CA

Consultant (Contract position)

Responsibilities:

• Designing and developing reporting web-based system (logical & physical schemas, stored procedures, reports).
• Working with business owners to define requirements for the project and translating functional specifications into technical design
• Building prototype application in MS Access 2000.
• Developing Excel macros for collection of the client data (such as IMS/ NDC) for the project.
• Transitioning MS Access 2000 prototype to the MS SQL Server 2000.

Confidential, San Francisco, CA

Software Engineer

Responsibilities:

• Leading team of 1-2 junior engineers
• Sybase development DBA role (support, security, sql code optimization, data analysis)
• Migration from Sybase ASE 11.9.2 to Oracle Server 8i
• Database Architect role ( maintaining data model, data dictionary, upgrade scripts )
• Java Development: JDBC, servlets, UI, JavaScript, Sybase Jconnect 5.2 Connection Pool
• SQL programming ( stored procedures, triggers, queries)
• Writing Functional & Design specifications and other documentation

Confidential, Louisville, KY

Production DBA (Contract position)

Responsibilities:

• Sybase DBA (support, security, backup, restore, recovery, installation, space management)
• Designing/developing Sybase/UNIX data feeds system (from numerous ISAM-based systems into the Operational Data Store & Data Warehouse)
• UNIX scripting (Korn shell, vi, awk, sed, bcp)
• Data Analysis (duplicate data, data conversion, ‘bad’ data)

Confidential, Louisville, KY

Senior Programmer-Analyst

Responsibilities:

• Acquisition: Took a leading part in transitioning of the TheraTX Billing/Clinical System ybase/Unix) into Confidential Billing System (MS SQL Server 7.0/ WindowsNT)
• Performed Sybase DBA role (security, DDL, performance analysis)
• Engaged in database programming (tuning Transact SQL quiries, working with stored procedures)
• Ported UNIX scripts into VB scripts

Confidential, Louisville, KY

Programmer-Analyst

Responsibilities:

• Responsible for the system implementation of the Health and Welfare
• Administrative System for a given client(s).
• Developed, maintained and debugged Sybase stored procedures
• Created custom reports