SUMMARY

• About 8 years of diversified experience in defining entities, attributes and entity relationship diagrams as Oracle PL/SQL developer and Database designer.
• Extensive experience in all areas of Project Life Cycle including requirement analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Proficient in writing PL/SQL stored procedures, packages, functions and triggers. Worked with testing team to create test cases for unit and integration testing.
• Experience in writing Unit test plans and Unit testing.
• Experience in Oracle and Other Utilities/tool: TOAD, PL/SQL Developer, UNIX Shell Scripting, Export/Import, SQL*Loader.
• Knowledgeable in writing test plans, defining test cases, developing and maintaining test scripts, Analyzing errors, interaction with team members in fixing the errors.
• Strong experience in writing SQL Queries, Views, Materialized Views, Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL, Exceptions. PL/SQL tables in 11g, 10g, and 9i.
• Experience in Deploying Forms and Reports on the web.
• Experience in query optimization, performance tuning using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Experienced in using Exception Handling methods along with Pragma Exception init in order to associate our own created exception names.
• Expertise in using advanced PL/SQL like Collections, Analytical Functions.
• Knowledge of data modeling techniques includes virtually every flavor of Entity - Relationship (ER) modeling, Physical and Logical data modeling.
• Hands on experience in writing SQL using MySQL, SQL Server 2005, Oracle andDB2 environment.
• Experience in version control system tools like CVS, SVN ClearCase
• Involved in complete life cycle of software development including designing, developing, testing and deployment of application using Agile methods.
• Analyzed and Created the Stories in JIRA project tracker for new and existing requirements.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x/5.x.

Databases: Oracle 12c/11g/10g/9i, DB2, SQL Server 2000/2005.

Languages: HTML, PL/SQL, SQL, Shell Scripting

GUI: Oracle Developer 2000, Visual Basic 5.0/6.0,Power Builder

Tools: TOAD, SQL Developer, ODI, Informatica, Datastage, C#, SQL*Plus, PLSQL Developer, SQL*Loader, TKPROF, MS Office 2007,2010

BI Tools: TableauDesktop 9.0,8.0

Scripting: Unix Shell Scripting

Operating Systems: Windows 9x/2000/XP/7, Linux Red Hat and Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

PLSQL/Tableau Developer

Responsibilities:

• Involved in full project life cycle like Designed, developed, implemented, maintained and tested the application.
• Ensure conformance to code standards and documentation requirements.
• Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms.
• Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
• Collectively used different types of control statements in order to process and manipulate data in the Stored Procedures.
• Developed Triggers to enforce complex business rules and to audit changes to data.
• Create temporary table in a Stored Procedures.
• Tuned SQL statements and Procedures using Explain Plan and TKPROF.
• Achieved the application design using IBMDB2.
• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary
• Built Joint Commission Report, Organizational Hierarchy report, Compliance report at institutional level and Many Utility Report which are internally used within the organization.
• Worked in Data blending with different Data sources. Scheduling data-source Extract and creating Dashboards using the Data source.
• BuiltTableauvisualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Oracle).

Environment: TableauDesktop 9.0, 8.2/8.1, TOAD, PLSQLdeveloper, Oracle 11g, DB2, JIRA, Microsoft Excel, MS Access, Windows server

Confidential, Rochester, NY

Database Developer

Responsibilities:

• Developed PL/SQL stored procedures, packages, and triggers for data load and transformation, and data extraction.
• Extensively used sub queries and joins while writing stored procedures.
• Involved in extensive coding using Oracle PL/SQL.
• Troubleshoot and repair software systems, both collaboratively and individually.
• Create documentation for use by other developers and internal customers.
• Write and modify software according to business specifications.
• Create and execute unit and integrations tests to ensure code meets requirements.
• Participate in project planning sessions to understand development requirements, provide design options, and provide work breakdown estimates.
• Analyzed various reports, dashboards, scorecards using Tableaudesktop server.
• Develop software using industry and company best practices.
• Account for the quality and timelines of own work.
• Maintain and grow applications according to business and technology priorities.
• Created Packages to automate transactions from the Oracle Forms.
• Designed, developed various reports using Reports 10g.
• Tuned and Optimized the SQL statements using Explain Plan and SQL trace utilities.
• Created Shell scripts to automate the loading of data from Text files to Oracle tables.
• Used bulk collections for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• SQL*Loader was used to load the data from the flat files to database tables.
• Developed batch jobs, shell scripts to automate file transfers, data cleansing, loading and final data processing.
• Performed the unit testing for procedures, functions and packages.

Environment: Oracle 12c/11g, PLSQL Developer, SQL Developer, TOAD, Sun Solaris, SQL, PL/SQL, JIRA, MS Access, SQL*Loader.

Confidential, Columbia MD

Production Support Analyst

Responsibilities:

• Worked with Magellan in the process of transitioning all of their servers and applications from Oracle 10g to 11g.
• Run and monitor applications in both Oracle 10g and 11g environments
• Create PL/SQL scripts to query the database as necessary to test results after the transition to 11g.
• Running various jobs in Unix/Linux(using nohup command) dependent upon the needs of the application being tested
• Involved in running Sessions & Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor. Fixing the connection issues in it, and comparing the data with 10g production database using the Data Warehouse Audit tables.
• Involved in running the Oracle Warehouse Builder (OWB) jobs in UNIX server in both Oracle 10g and 11G Environments and Comparing the data with 10g production database using the Data Warehouse Audit tables.
• Compare application performance and results between 10g and 11g environments and working with Oracle DBA Team in fixing them.
• Provided production support to the batch jobs.
• Query the database and test the results of various applications
• Document the results of the tests to development teams tasked with fixing any issues that arise.
• Clearly communicated the results and issues to Tier 2 and 3 support teams to fix it.

Environment: Oracle 11g/10g, PLSQL Developer, SQL Developer, TOAD, Informatica, OWB (Oracle Warehouse Builder), Sun Solaris, SQL, PL/SQL, Crontab, JIRA, MS Access, SQL*Loader.

Confidential, Charlotte, NC

ETL/PLSQL Developer

Responsibilities:

• Used SQL Navigator, a popular tool which increases user productivity and application code quality to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries. Checking the performance of the overall application and tune the SQL Queries and performance tuning of the database where exactly it is necessary using TKPROF and explain plan.
• Worked with UTL FILE to write the files. Involved in generating new files, modifying or updating the existing. Files as needed and monitoring them if they are successful during NOPS/DOPS.
• Thoroughly involved in unit testing, creating unit test documents and involve in peer reviews,
• Technical Design reviews, code reviews, follow ups and status updates to closely monitor the development throughout its life cycle. Constantly tracking the defects logged by the testing teams and business using IBM Clear Quest tool and working on the defect fixes through the release.
• Validating all the database changes with validation scripts when the changes are moved to different environments and supporting them.
• Developed scripts for tables with partitions and indexes, views, materialized views and functions as per the business requirements.
• Migrated data from legacy systems to the data warehouse environment using SQL and PL/SQL Scripts.
• Built database objects like Tables, Views, Synonyms, Grants, Sequences and Triggers, procedures, packages using Oracle tools likeSQL* Plus,PL/SQL Developerand TOAD.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed data conversion procedures in PL/SQL and Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation, and for sending real time and batch transactions.

Environment: Oracle 11g, PLSQL Developer, SQL Developer, TOAD, Informatica, Sun Solaris, SQL, PL/SQL, Crontab, MS Access, SQL*Loader.

Confidential

Oracle Developer

Responsibilities:

• Worked on FACETS database to generate the reports and also worked with business analysts to gather the business logic, testing, metrics and project coordination.
• Developed PL/SQL Stored Procedures, Functions, Packages and SQL Scripts.
• Loaded the data into database tables using SQL*loader from flat files.
• Developed scripts for tables with partitions and indexes, views, materialized views and functions as per the business requirements.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
• Migrated data from legacy systems to the data warehouse environment using SQL and PL/SQL Scripts.
• Used the standard Oracle package DBMS SCHEDULER to automate / schedule jobs on daily, weekly and monthly basis and to run jobs in parallel to improve time-constrained performance.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed data conversion procedures in PL/SQL and Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, AUTOTRACE.
• Analyzed the data using statistical features inTableauto develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in logical modeling and physical modeling of application.
• Worked in cross function teams based in various parts of the globe.

Environment: Oracle 11g/10g, UNIX, PL/SQL, SQL*PLUS, SQL*Loader, Forms 10g and Reports 10g.

Confidential

PL/SQL Developer.

Responsibilities:

• Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from flat files.
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functionsas per the business requirements.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL-Informatica) using PL/SQL and SQL*Loader.
• Used the standard Oracle packageDBMS SCHEDULERto automate / schedule jobs on daily, weekly and monthly basis and to run jobs in parallel to improve time-constrained performance.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Used Bulk Collect and FOR ALL to improve the retrieval of data
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, LINUX Red Hat, PL/SQL Developer, Oracle Data Integrator.

Confidential

Oracle Developer

Responsibilities:

• Experience in assisting the Application Developers in creating conceptual database designs that meet the business and technical objectives.
• Used conceptual models and extended conceptual models with business rules to develop logical data models.
• Designed Oracle Logical Objects including Triggers, Stored Procedures, and Sequences that helped in automating various operations in the database.
• Developed complex reports like matrix reports, tabular reports for the systems using running totals, sub totals, grand totals and daily balance by using lexical parameters.
• Developed SQL*Loader scripts to load flat files into source staging database and plan the loads to run concurrently without any manual intervention.
• Fine Tuned SQL for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.
• Created new and modified database procedures, functions, triggers and other database objects by using TOAD tool.

Environment: Oracle 8i, Developer 2000, SQL, PL/SQL, SQL Plus, Windows 2000.