Experience Summary:

• Around 9 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.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• In-depth knowledge on Tableau Desktop, Tableau Server and Tableau Viewer.
• Ability to design and display Graphic rich visualizations with Filters, Drill Downs and Parameters.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to requirements specifications.
• Have experience on security setup using Active directory integration.
• 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 Perl 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, ETL and report development methodology.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail-level data analysis.
• Experience in Tableau software Installation in Single and clustered environments.
• Hands on experience in configuration and administration of Tableau Server
• 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:

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyze the functional technical requirements and of the project. Discuss with business users, BA's and Architects to finalize requirements and scope of the project. Design the Database and Tableau reports for the new enhanced COMPASS. Design and provide Database service call to UI team. Create functional and technical documents. Create new tables, views, materialized views, Packages, Stored Procedures and functions per the requirements. Perform code review and make changes/improvements as required. Optimize the code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve the performance. Used Exception Handling to handle runtime user defined exceptions. Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested. Plan production deployment activities, ITSM processes, raise RFCs and coordinate with various teams like DBAs, Unix, Tableau Admins etc. Used PIVOT, UNPIVOT, LISTAGG and many functions in Oracle 11G to transform complex source data as per mappings.
• Designed and developed intuitive Tableau Dashboards against Order Provisioning System to bring visibility on Order provisioning process and performance.
• Built Tableau visualizations by connecting to various Data Sources Relational Databases Oracle, SQL Server .
• Built reporting against Single, Multiple Tables, Views, Materialized Views and Complex Custom SQL.
• Designed and deployed interactive reports with Drill Downs, Drop down menu option, Parameters and Linked reports using Tableau.
• Created variety of visualizations and dashboards according to business requirement specifications.
• Experience with Active Directory Integration within Tableau Environment for automated user provisioning.
• 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. Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections. Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc. Provide development, CUT, and SIT estimates to project services team. Designed Database Triggers for audit and validation purpose. Migration from Oracle 10g to Oracle 11g.

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

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in the Response Track implementation of Global Investment Bank Offices.
• Performed unit test on the developed code to ensure that its bug free.
• Handled Production issues and manage the same in issue log.
• 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.
• 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.

Environment: Oracle 10g, TOAD 10.5, VI editor, MKS, FileZilla FTP tool, SQL loader, PL/SQL.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• 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.
• Involved in writing functional and technical documents.
• 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.
• Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• 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.

Confidential

Role: 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, Crystal Reports, Windows 2000.