SUMMARY:

9 years of IT experience with roles as Oracle PL/SQL Devloper, Oracle DBA, SQL Server Developer,Netezza DBA and developer as major areas of expertise.

TECHNICAL SKILLS:

Core Languages: SQL, PL/SQL, T - SQL,Netezza,Basic Java OOP concepts,Unix shell scripting

Operating System: Linux, Windows 7.

DBMS: Oracle 9i/10g/11g,12c, SQL server 2008R2/2012/2014

BI: SSIS, SSRS, SSAS,Tableau

Tools: SQL *PLUS, PL/SQL Developer, SQL Navigator, Toad, Informatica, SSMS, SSIS, SSRS, SSAS,SSDT

Special Software: Visual Source Safe (for source code control),SVN

Specialization Area: Exposure to complete project life-cycle, from Analysis, design, coding to testing and maintenance.

PROFESSIONAL EXPERIENCE:

Confidential, Cambridge, MA

Oracle PL SQL Developer

Responsibilities:

• Database development in SQL, TSQL, PLSQL using functions, stored procedures in RDBMS
• Designing and building of Data warehouse solution in Oracle database.
• ETL of data from multiple sources like Oracle, SQL Server, Access, Excel and CSVs using tools like SSIS to build data warehouse solution to see the history trends.
• Understanding of Data Integrity and Data analysis, advanced skills in SQL and PL/SQL
• Analyze assay data for the correctness, completeness, integrity and high quality and implement quality checks.
• Work to ensure that data flows properly across systems and databases, and is represented adequately in data reporting/visualization application so that it provides value to the scientific community.
• Conduct fact findings to identify specific data integrity issues. Document and provide detailed analysis of the issues identified- where problems occur and why. Collaborate with the other teams as appropriate toward specific issues resolution.
• Wrote scripts for the quality checks to support QA efforts and validation processes overall.
• Develop recommendations to address common Data Integrity issues and collaborate with data warehouse team to implement Data Integrity issues remediation.
• Work closely with Scientific Data Curation Team, data warehouse and project teams as related to data integrity/data consistency issues.
• Developed functions to generate output in json format by querying multiple tables and using LOBs.
• Wrote Complex SQL queries for reporting needs.
• Used PL/SQL collections, Types.
• Datamodelling for Reporting on Data integrity issues in Datawarehouse environment
• Worked on performance tuning of sql queries by using hints, indexes and checking the explain plan for the queries.
• Worked on loading data into tables from files using SQL Loader.
• Version control of scripts and code using Tortoise SVN. Documentation of functional and non-functional specification like data dictionary, schema, user manual, and data mapping document.

Solution Environment: Oracle Pl /SQL, Oracle 11g/12c,SQL server 2008R2/2012/ 2014.

Confidential, Cleveland, OH

Oracle Database Developer

Responsibilities:

• ETL of data from multiple sources like Oracle, SQL Server, Access, Excel and CSVs using tools like SSIS to build data warehouse solution to see the history trends.
• Imported data in multiple chunks for multi terabyte database, Data cleaning and merging/purging of data, which comes from different sources like, Oracle, SQL Server and Excel.
• Worked on storage of xml components in database and analysis for space taken by it
• Database development in SQL, TSQL, PLSQL using functions, stored procedures,Triggers in RDBMS which involved complex logic for extracting data from xml fields.
• Designing, Dimensional Modeling, Extraction, transformation, and loading (ETL), data cleaning, data merging/purging, OLAP cubes, Business Intelligence and data mining
• Worked on copying data from one database to another using toad and informatica
• Wrote complex SQL queries for repoting needs.
• Created mappings, workflows using informatica.
• Worked on performance tuning of sql queries by using hints, indexes and checking the explain plan for the queries.
• Performance tuning of SSIS, SSAS and SSRS and cube using SSIS techniques and parallelism, SQL Profiler, execution plan, system monitor, materialized views, and indices
• Design and development of database maintenance routines for partitioning and auto create and drop partitions.
• Used SQL tuning advisors and SQL access advisor for long running queries
• Worked on tuning the PL/ SQL procedures doing DML operations on large tables.
• Used PL/SQL collections, Types.
• Created materialized views.
• Managing users, roles and profiles
• Also worked on preparing the test cases to validate the data in target database.
• Helped testing team to understand the data and prepare the test cases
• Worked with Java app Tier developers to troubleshoot database related performance issues

Solution Environment: Oracle Pl /SQL, Oracle 11g, Unix,SQL server 2008R2/2012.

Confidential, Minneapolis, MN

Oracle and Netezza DBA

Responsibilities:

• Worked on Twin fin model of netezza (6.0.3 p4)
• Deploying and installing Netezza clients
• Managing the Netezza appliance
• Managing system notifications and events
• Managing Netezza users and groups
• Loading and unloading data using nzload /external tables.
• Migration of tables /database from one environment to another using nzmigrate
• Setup of database backup on TSM server and on disk, Database backup and restore
• Query history management
• Workload management
• Performance tuning of queries Gather statistics
• Monitoring database locks and killing the required session
• Reorg of database tables to reclaim the unused space.
• Checking tables for proper distribution of data
• Netezza software upgrade-Firmware upgrade and host platform upgrade
• Moving and reorganizing data
• Import and export data using datapump and loading data using sql loader and external tables
• Managing users, roles and profiles
• Monitoring database sessions
• Capacity Planning Memory management
• Creating database objects (Tables, indexes, views, procedure, functions)
• Design and development of database maintenance routines for partitioning and auto create and drop partitions.
• Setting up oracle database parameters
• Monitoring database locks, blocking and waiting sessions
• Generating awr reports Gather statistics
• Identified queries taking long time to run and tune them by creating indexes on table,using SQL advisors, creating materialized views.
• Creating baselines and exporting them in different environment to make sure best plan is getting used.
• RMAN Database backup and restore

Solution Environment: Netezza, Oracle 10g,Oracle 11g, Unix

Confidential

Oracle Developer

Responsibilities:

• Requirement Analysis/gathering and planning of the development activities.
• Creation and modification of stored procedure, functions etc in Oracle (PL/SQL) and T-SQL as per business’s requirements.
• Converting PL/SQL scripts from Oracle to Netezza.
• Creating unix shell scripts.
• Worked on development of Netezza scripts.
• Migration of data from AdR1.0 to AdR2.0 using External tables.
• Worked on hierarchical queries.
• Involved in internal as well as external code review for Netezza scripts.
• Unit Testing of Netezza Scripts.
• Designing and development of objects in SQL Server to implement processes using SQL, TSQL including UDFs, SPs, Triggers, packages, query rewriting & hints etc.
• Source Code Version Management in CVS.
• Worked with SQL Queries using analytical functions, Stored Procedures, triggers, indexes, views, functions.
• Worked on complex queries used for Reporting needs (backend for Cognos).
• Bug Fixing during the product Quality Control Cycle
• Writing Main Queries for Reports and Forms.
• Debugging Packages and Procedure
• Preparing Reports from Scratch Using PL/SQL Queries.
• Worked on reports related to Order Management, Inventory and Purchase Orders.
• Worked on all the Dimensions and facts of XPRO.
• Writing Test cases (Pl/Sql Queries) for the dimensions and facts (Mappings, Function, Procedure) and Manual Testing using SQL queries for checking the mappings of the process.
• Tested modules which involved multiple sources. Solving Tickets