SUMMARY:

• A performance oriented Database/ETL Developer experienced in design, development, implementation and maintenance of various Databases in various domains like Banking, Healthcare, Telecom and Public Sector.
• Proven ability and expertise in processing big data, performance tuning, automation of data processing, as well as, developing and automating ETL processes.
• Relational Database Management and Data warehouse systems.
• Data analysis, logical, physical and dimensional data modeling techniques.
• Developing ETL processes in Informatica, Talend and PL/SQL.
• Developing Database Applications with various software development techniques such as; SDLC, Waterfall, Agile (SCRUM, Kanban)

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, PERL, JAVA, UNIX, C, C++, C #, VB.NET, HTML

Databases: Oracle, MySQL, SQL Server, Teradata & MS - Access

ETL Tools: Informatica, Talend

Data Modeling: Physical, Logical, Relational and Dimensional Modeling

Operating Systems: Unix, Sun Solaris, HP-UX, Windows

Scripting: Shell Scripting & PERL scripting, Python

Reporting tools: Crystal Reports, Oracle Reports

File Transfer tools: Filezilla, Winscp

Job Scheduler tools: Automic, Control M, DBMS Scheduler

Tools: TOAD, Putty, SQL Developer, Eclipse, Aqua Data Studio, SQL*LOADER, SVN, ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, Garden City, NY

Database Developer

Responsibilities:

• Developed various Packages, Procedures, Functions to apply the business logic on the back end.
• Created Materialized View, Inline Views, standard views to support the data fetching for the application.
• Worked Extensively with Finance team to provide them the data and reconcile the monthly invoices and splits to various brokers.
• Created DBMS Scheduler jobs to automate the data processing for the daily files received from clients to be stored into the internal database.
• Extensively used External table and SQL Loader to load data into the system on scheduled basis.
• Develop and automate ETL processes using Informatica & PL/SQL.
• Automated various weekly and monthly reports to be sent out via email using PLSQL stored procedures.
• Extensively used PLSQL exceptions to automatically send emails to the users in case any failure or based on specific conditions.
• Performed performance tuning for the sql queries and the application to reduce the response time.

Environment: Oracle 11G, Unix, Windows, SQL Developer, WINSCP, Informatica, SQL*PLUS, ORACLE Forms & Reports.

Confidential, NYC, NY

Database Developer

Responsibilities:

• Created Design Documents from Business Requirement Documents and interacting with Business.
• Created Stored Procedures and Functions in Oracle packages related to each module.
• Developed pl/sql code to summarize source data and apply complex business logic for reporting purposes.
• Extensively involved in performance tuning of the queries to improve application performance.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Extensively used Partitions & Hints and created materialized views for faster data retrieval.
• Handled Exceptions based on the business logic to display errors using both oracle built in exception and user defined exceptions.

Environment: Oracle 11G, Unix, Windows, SQL Developer,Cognos Reports,Data Modeler, Visio

Confidential, San Francisco, CA

Database Developer

Responsibilities:

• Created PL/SQL stored procedures to perform ETL operations.
• Created various database objects like Views, Tables, Sequences, Packages and Procedures.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used PL/SQL profiler to debug the performance of procedures and identify the bottlenecks.

Environment: Oracle 11g, SQL * Plus, SQL Server, TOAD for oracle, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Microsoft Visio 2007,Data modeler, TOAD Datapoint.

Confidential, Augusta,ME

Database Developer

Responsibilities:

• Extensively worked on the Adhoc Data requests to satisfy the needs of the program managers to achieve different goals of the project.
• Extensively worked of Toad Data Point to create automation scripts for the recurring Monthly, Weekly and Daily data requests.
• Extensively did Quality test plans and reviewed the Quality System Test Plan & Test cases.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Performed Performance tuning for SQL Queries and the system.
• Managed the monthly pool of recurring reports and data requests

Environment: Oracle 10g, SQL * Plus, TOAD for oracle, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Microsoft Visio 2007,Data modeler, Informatica Power center 8.x, TOAD Datapoint.

Confidential, Holmdel, NJ,

Oracle PL/SQL Developer

Responsibilities:

• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD
• Develop Oracle PL/SQL triggers and procedures. Set up Oracle PL/SQL package to analyze the tables and indexes, records tables and rebuild indexes.
• Created database objects, tables, indexes, writing procedures, SQL scripts
• Worked in Identifying and requirements and developing models according to the customer’s specifications and drafting detailed documentation for the same.
• Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
• Extensively worked towards optimizing the query to enhance the performance.
• Used %Row type and %type to define data types based on row and column respectively.
• Loaded external files into our Database through UTL FILE.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms.

Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX