Systems Engineer Resume

SUMMARY

Expertise in Database Administration, design, development, migration, upgrade, testing and automation.
Significant experience in data warehousing, ETL, performance tuning of queries, reports and high volume transaction processing.

TECHNICAL SKILLS

Oracle(8i,9i,10g,11g), Sybase(11.x,12.x,15.x), MicroSoft SQL Server 2014, MicroSoft Access 2013, Vertica(5.x)
MySQL, Migration (from Sybase to Oracle, Oracle 10g to 11g), PostgreSQL, Git, Oracle tools ( PL/SQL, TOAD, RMAN
Data Guard, OEM, SQL Loader), Python, PHP and Shell Programming, Agile Development Process, ERStudio, GCP, 21 CFR Part 1, SAS.

PROFESSIONAL EXPERIENCE

Systems Engineer

Confidential

Responsibilities:

Automate Database/Data Guard Repoint/OS Patches using HPOO - Automation flows.
Modify existing flows as per requirements.
Onboard applications, conduct tests for dry run, validation before and after repoint and patching.
DBA related activities for HPOO servers.
Map, Plan and design loading self service portal data to HPOO database.

Database Administrator/Database Developer

Confidential

Responsibilities:

Migrate application for administrative and clinical data processes from QuickCap6 to QuickCap7.
Install SQL Server for QuickCap7 system and configure backups.
Configure trading partners and encounters for each trading partner, process and fix error in encounters.
Configure, process and troubleshoot EDI claim transactions (837 and 835 ).
Develop and manage Claim Recoveries and RX data processing.
Generate Providers rosters.

Developer and Database Consultant

Confidential

Responsibilities:

Volunteer to develop tool using tkinter to communicate with laser from Raspberry pi using usb.
Log data for monitoring Laser.

Database Engineer

Confidential

Responsibilities:

Design, develop and implement segmentation, traffic report, postbacks, cohorts using PostgreSQL.
Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for segmentation, traffic report, postbacks, cohorts.
Conduct data model reviews to enforce standards and best practices around data modeling efforts.
Develop applications and systems in deadline-oriented environments using PostgreSQL.
Design, develop and implement new workflow for sales and operations campaigns.
Identify bottlenecks for performance, tune queries for better performance.
Analyze data and Create Audience for different clients for maximizing ROI.

Database Administrator

Confidential

Responsibilities:

Database Architect

Confidential

Responsibilities:

Install, upgrade Vertica.
Designed and developed complex mappings to move data into Vertica from multiple sources.
Design schema, transform and load and analyze data for various games.
Troubleshoot problems loading/transforming data and help analysts.
Genarate dash boards for audits and alerts for games using php and Vertica.
Design, implement curl calls for publishers using php.
Create,Automate and manage processes for games analytics.
QA all parameters for games.

Senior Database Administrator

Confidential

Responsibilities:

Worked nights/weekends as necessary to support all clinical trials.
Install,upgrade,manage database servers ( SYBASE / ORACLE).
Automate dump and load database with user access for SYBASE databases for data transfers.
Migrate SYBASE databases from Solaris to Linux.
Backup and Disaster recovery and consistency of databases using RMAN.
Configure database for physical and logical Data guard for all servers.
Help users to analyze, cleanse, report clinical data.
Performance tuning on server and database level.
Release patches/new versions in test/staging and production environments.

Data Migration Lead

Confidential

Responsibilities:

Use Nextance XML-based product to create 'System of Record' for contracts.
Participate in Business process reengineering for different contract types.
Create AS IS and TO BE data flows.
Create data dictionaries for existing systems and Nextance System for data mapping and gap analysis.
Create web interface for terms glossary and documents for project using PHP and Apache.
Develop and document strategy for data migration and data cleansing.
Create and Design schemas for data cleansing.

Database Engineer

Confidential

Responsibilities:

Performed DBA activities for their QA group for coreif software.
Configure Ethereal to inspect network packets for security purposes.
DBA activities for Oracle and Sybase servers such as: install, backup and recovery, performance tuning
Principal support for oncall rotation and troubleshooting of the nightly trade processing for Portia.
Technical Lead for tax lot process. Collaborate with business analysts to analyze data, physical and logical data modelling and develop and implement new methods for reconciliation of tax lots.
Create processes in Perl to transfer data between Oracle and Sybase.