SUMMARY:

• Improves performance of high - volume databases by tuning SQLs; designs, develops, and maintains ETL codes.Database Development
• Data Warehousing Performance Enhancement Data Modeling
• Streamlines data warehouse procedures through automated solutions: Saved 2 hours’ daily escalation time by automating a job scheduling application’s status notification for business users using UNIX shell scripts.
• Speeds up applications performance by identifying and fixing errors
• Reduced data extraction time from 40 to 3 hours at FI by rewriting client application code to avoid unnecessary processes; streamlined systems data analysis.
• Improves standard testing process by developing Oracle-related packages
• Developed customized application “pass-fail” reports for management at Confidential ; enabled report generation at a click of a button and uploaded results for the team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.1/7.1

Databases: Oracle 11g/10g/9i/8i, Sybase, PostgreSQL,Exadata, Mongodb

Languages: SQL, PL/SQL, UNIX, Shell scripts, Python 2.6, Perl, HTML5, Java Scripting, PHP, CSS3

Scheduling Tools: Autosys, Control-M, JAMS

Other tools: JIRA, Eclipse, GIT, SVN, Junit, Splunk, Cucumber

Key Skills: OLAP, Tuning/Query Optimization, Mapping Designing, Repository Management, Workflow Management, Repository Server Management, Data Processing, Process Automation, Regression & Performance Testing, API Testing, Project Management, CRM

PROFESSIONAL EXPERIENCE:

Performance Engineer

Confidential, Pleasanton, CA

Responsibilities:

• Existing applications which contains patients information which is being loaded using Epic ETL Clarity tool is being migrated from Teradata to Exadata.
• We need to make sure the performance remains same or matches the with that of Teradata for 5 regions throughout USA
• Tune the queries which are converted from Teradata to Exadata either by rewriting it from scratch or by rewriting the part of the code which might be of concerns.
• Making of use smart scans and other performance improvement methods in Exadata to make sure performance of the application matches with Teradata.
• Working with different applications which uses various reporting tools like Business Objects and Clarity Reporting to make sure the Exadata queries works as expected.
• Use various reports such ass Exachk reports, SQLT reports, trace files and sql monitor reports to aid in improving the performance of the application.

Oracle Developer

Confidential, Rockville, MD

Responsibilities:

• Automated database processes using PL/SQL packages, data modeling and replication into Amazon Web service clouds using python and java codes, and enhanced application performance at this Congress-authorized, non-profit organization dedicated to investor protection.
• Automated and tested Postgres code changes by developing test frameworks using Cucumber; generated color-coded HTML reports.
• Collaborated with a senior architect to automate the time-consuming uploading of HTML reports onto Jira.
• Replicated data from the external source using materialized views; validated codes to ensure data conversion from Oracle to Postgres.
• Enabled large data transfer from one database to another by using complete and fast refresh methods.
• Created and monitored alerts and reports from AWS logs using Splunk; customized queries to visualize machine data. Tests the performance of web applications using JMeter.
• Had to write few python scripts to connect aws to initiate table migration and to start and stop replication and other services on aws.

Oracle Developer

Confidential, Durham, NC

Responsibilities:

• Carried out data modeling and design, utilized PL/SQL objects, loaded data using ETL/Informatica, and optimized long-running queries at this multinational financial services corporation with $15.9B in revenue.
• Avoided lengthy and troublesome data restoration process by developing a web application for users to upload files and get notified 2 weeks prior to data removal; added modifications based on client feedback.
• Eliminated 10 man-hours/week spent on uploading client data by developing a front-end page for clients to upload data easily. Established front-end validations and customized technical errors.
• Utilized ETL/Informatica to process data from various vendors and used UNIX scripts for file transfer protocol.
• Accelerated lengthy data extraction process by creating partitioning tables and local/global index on partitioned tables.
• All the Online applications for business users were managed with the help of Exchange Partition.
• Utilized Toad to develop PL/SQL objects including tables, indices, packages, triggers, sequences, and stored procedures.
• Collaborated with architects to upgrade information systems to retain existing data and accommodate new one.

SQL Developer

Confidential, New Jersey, NY

Responsibilities:

• Led a team of 4 and tracked performance through traceability matrix; updated manager.
• Automated job scheduling processes using Autosys and reports generation using PERL.
• Enhanced systems performance using various tools including Explain Plans, Hints, DBCC Traceon, and Force Index.

Oracle & ETL Developer

Confidential

Responsibilities:

• Prepared test scripts for the system and integration testing.
• Developed Informatica mappings to load data files sourced from various clients on the Oracle databases.
• Accommodated Basel’s new risk mitigation plans for UK banks by writing new codes, creating new mappings, tables, triggers and packages in compliance with new rules. Broke down complex technical documents into easier terms for clients.
• Supported technical teams with overnight batch processes and addressing escalated queries.