SUMMARY

• Around 8 Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle 8i/9i/10g,11gR1 and 11gR2, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Having 3 years of experience on Tableau Business Intelligence/Business Analytics software.
• Experienced on Tableau Admin activities, Multidimensional database and writing SQL queries
• Expertise in Tableau, Jasper, BO, Oracle, MySQL, Informatica
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Proficient knowledge in HTML and JavaScript.
• Exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning & Optimization of SQL statements.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Created materialized views like primary key, rowid, and sub query materialized views.
• Strong in writing Stored Procedures and SQL queries
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Good understanding of the Oracle database, related utilities and tools.
• Around 4 Years of Experience in Pearl Scripting & UNIX Shell scripting Perl/sh/awk.
• Designed and developed the Extraction, Transformation, and Loading (ETL) program to move data from source to target, mapping source data attributes to target data attributes.
• Have extensive experience in Performance tuning by analyzing the execution plans of the query
• Hands on experience in tracking down the bottlenecks in query using trace files.
• Extensive experience in utilizing Collections to boost performance in PL SQL block.
• Participated in all Business Intelligence activities related to data warehouse(TERADATA), ETL and report development methodology.
• Strong Background in implementation of RDBMS and OOPS concepts.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Strong personal drive and ability to work individually and in team environments.
• Ability to learn new tools, concepts and environments.
• Ability to explain technical concepts and communicate with users and system administrators at all levels.

TECHNICAL SKILLS

Operating Systems: Windows 98 / NT / 2000 / XP, UNIX

Languages: JAVA,C,C++,VB6.0,SQL,PL/SQL,FOXPRO

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, iSQL*Plus, SQL*Loader, Oracle procedure Builder

Development Tools: Developer 11g/10g/9i/6i/2000 Release 1 & 2, Reports 10g/9i/6i, Forms 6i/9i/10g

Reporting Tools: Tableau 7/8, Jasper Server 1.3/ 4.5, Crystal Reports, Oracle Reports

Scripting Languages: Java Script, UNIX Scripting

Web Technologies: HTML

PROFESSIONAL EXPERIENCE

Confidential, NJ

Tableau Developer

Responsibilities:

• Analyze the functional & technical requirements and of the project.
• Discuss with business users, BA's to finalize requirements and scope of the project.
• Provide development, CUT, and SIT estimates to project services team
• Create functional and technical documents.
• Create new tables, views, materialized views, Packages, Stored Procedures and functions per the requirements.
• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on CnC database and generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Worked with Sharepoint team to Embedded Tableau views in to SharePoint
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Used sets, groups, Top N Rank filters on various reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for PnL with forecast and reference lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding.
• Optimize the code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve the performance
• Maintain SVN repository, deploy code base to SIT, QA, UAT, dry - run environments as requested.
• Ability to develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables
• Ability to trouble shoot technical issues and problems, monitor progress against plan, and communicate status to Leads
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.

Environment: Oracle 10g/11g, Tableau 7/8, PL/SQL, PL/SQL Developer, Perl, Unix

Confidential, NJ

Tableau Developer/PLSQL Developer

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Designed Technical design document based on the business requirements.
• Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Created Materialized Views for extracting the data from remote database.
• Preparation of wrapper scripts for all the database processes and data quality checks using Unix Shell scripting.
• Performed unit test on the developed code to ensure that its bug free.
• Handled Production issues and manage the same in issue log.
• Wrote complex SQL queries to extract data from various source tables of data warehouse.
• Created various Function Based Indexes to significantly improve performance.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.
• Extensively used Bulk Collections to insert and update huge amount of data into target databases.
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.
• Worked on Exception handling, to trouble-shoot PL/SQL code and to display the error messages in the application.
• Used Explain Plan, SQL*TRACE, TKPROF for tuning the SQL statements by creating indexes.
• Extensive usage of Oracle External Table Concept to extract Data from feed File sent to FTP feed file location.
• Monitoring the schedules and timely escalations to the project management and client in case of any slippages.
• Extensively involved in using HINTS to direct the optimizer to choose an optimum query execution plan.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Generated Tableau combination charts using Tableau visualization software.
• Extensive use of Oracle PL/SQL, Analytic Functions, SQL

Environment: Oracle 10g, Tableau 7, TOAD 10.5, VI editor, SQL loader, PL/SQL

Confidential, FL

Oracle PL/SQL Developer

Responsibilities:

• Used the merge statements to select rows from one or more sources for update and insertion into one or more tables.
• Used PL/SQL collections (Nested Tables and Varray) in complex backend packages.
• Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data.
• Developed test plan documents for all back end database modules.
• Extensively worked on Explain Plans and various hints for Performance tuning.
• Wrote Database triggers for audit and to implement complex business logic.
• Discussed and analyzed business functionality with the client and the developers.
• Involved in the database design for better understanding the relations, associations and dependencies within the data base.
• Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Involved in writing functional and technical documents.
• Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms.
• Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems.
• Wrote complex SQL queries to retrieve information from the database depending on user requirement.
• Created PL/SQL program units to implement DML, DDL statements using dynamic SQL.
• Wrote control files and loaded the data into oracle database with SQL*Loader.
• Used PL/SQL Developer tool to do the backend development.
• Wrote complex oracle SQL using joins, sub queries and correlated sub queries.
• Implemented Materialized View for extracting the data from remote database.
• Handled various Exceptions to trouble-shoot PL/SQL code.

Environment: Oracle 10g, PL/SQL, Report Builder 10.1.2.0.2 , Toad 7.5.2.0, UNIX, Perl

Confidential, Phoenix, AZ

Oracle PL/SQL Developer

Responsibilities:

• Wrote stored PL/SQL Procedures for reports.
• Developed PL/SQL scripts for data processing.
• Created Indexes, Views and Tables
• Optimized the existing UNIX scripts to achieve better performance.
• Wrote triggers and procedures to handle the data processing.
• Created scripts to trigger nightly batch processes.
• Involved in Developing and Generating Reports.
• Experience with Enterprise Guide in generating analytical reports.
• Preparing Unit test scripts, setting up a test environment and unit testing the code.
• Tuning of the SQL statements for application developers.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Using UNIX Shell scripting perl/sh/awk.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.

Environment: Oracle 10g, PL/SQL, Report Builder 10.1.2.0.2 , Toad 7.5.2.0, Unix, Perl

Confidential, Stamford, CT

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Developing Stored Procedures, Functions and Triggers.
• Development was done extensively on collections (Associative Arrays, Nested Tables)
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries manually by Explain plan.
• Partitioned tables and indexes for better performance of application.
• Involved in importing the production data to lower environments for testing purpose.
• Involved in handling the changes in compiling scripts according to the database changes.

Environment: Oracle 10g, UNIX, MS visual studio 2005

Confidential, Dulles, VA

Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Involved in GUI designing using Oracle Developer 10g (Forms 10g and Report 10g).
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used pipelined functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Using UNIX Shell scripting perl/sh/awk.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for different Oracle Forms application functionalities.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in migrating database from oracle 9i to 10g database.
• Involved in developing screens and generating reports.
• Developed Forms and Reports.

Environment: Oracle 9i, 10g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, Toad.

Confidential

Oracle Developer

Responsibilities:

• Created and maintained PL/SQL scripts and stored procedures.
• Coded many generic routines (as functions), which could be called from other procedures.
• Developed user interface screens, Master detail relations and Report screens.
• Developed various Reports for the end users as per their requirements and created many reports to suit preprinted format of the company.
• Created user defined Exceptions while handling exceptions.
• Wrote stored procedures, Functions and Database triggers using PL/SQL.
• Conducted training sessions for the end-users.
• Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems.
• Identified and implemented programming enhancements

Environment: Oracle 8i, SQL*Plus, Windows 2000.