PROFESSIONAL SUMMARY:

• Over 7 years of experience in IT industry with first - hand knowledge of all facts of software Development Lifecycle (SDLC) including requirement gathering, analysis, design, development, reporting, testing, implementation, and post implementation support.
• Solid experience in Database Design, Creation and Management of Schemas using Oracle 11g/10g database, extensive experience in writing Stored Procedures, Functions, packages, functions and query performance using PL/SQL.
• Expertise in all aspects of the system development life cycle (SDLC) such as requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi-tier and client/server architectures.
• Experience in creating Tables, Views, and Synonyms, Indexes, Sequence, Users and assigned privileges in development environment.
• Knowledge in Low-level and Detailed (Subject area specific) designing and implementing of OLTP, OLAP (Data warehousing, Decision Support System, Data-marts). Expert in Data Warehousing ETL methodologies, analyzing source systems and target systems, Metadata, process control, reporting and BI.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Developed batch programs using import/export utilities, SQL Loader.
• Expertise in Database Design, Database programming, SQL and Database Tuning and Database Administration, Performance Tuning.
• Extensive involvement in development and Performance tuning of SQL and PL/SQL using Hints, bulk-collect, forall, Global Temporary tables, Explain Plan, Table Partitioning, Indexes and Join Optimization.
• Experience of using Exception handling for interactive solution of problems related database access.
• Experience of co-coordinating with various teams like Network Admin, testing Team to speed up the development process.
• Excellent communication and interpersonal skills. Versatile team player with proven problem solving skills. Worked independently as well as in team environments and Experience in Interacting with users for business requirements.
• Worked on Python Module such as SQLAlchemy, Pandas, Selenium Web driver, matplotlib

TECHNICAL SKILLS:

RDBMS: Oracle 12C,11g/10g, MS-Access2000, POSTGRES, SQLSERVER

Languages: PL/SQL, Python, PSQL, HTML, Ajax, JavaScript, jQuery, Selenium

Operating Systems: Windows 7/XP, Unix.

Modeling/ETL Tool: Toad Data Modeler, Informatica

Other Tools: PLSQL Developer, SQL*Plus, SQL developer, TOAD, SVN, Control-M, Tableau, DBeaver, PyCharm, Eclipse

PROFESSIONAL EXPERIENCE:

Confidential - Linthicum Heights, Maryland

Data Scientist/BI Analyst/Application Programmer III

Responsibilities:

• Built a method for transitioning from ICD9 to ICD10 in an application which handles the Shock Trauma registry for Billing.
• Handling ad-hoc add-on on the web registry which requires new build and also modified many existing features to support client new requirements.
• Worked on various tuning workload to enhance the speed of the web-registry and to reduce the load on the server.
• Worked on replacing outdated JavaScript codes by using a JavaScript Library jQuery and Ajax.
• Custom built a web-page for ease of running the code and analyzing the output.
• Worked on various Tableau Dashboards and brought together the excerpts from all of them to create a Landing page which communicates to its respective Dashboards.
• Continuous conversation with the clients to in corporate addition/modification to the Dashboards.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using Oracle Pl/SQL to provide definition, structure and to maintain data efficiently.
• Create a package to email the developers to notify others developers of working on Procedure/Function to avoid the overlapping of work by other developers.
• Building, publishing customized interactive dashboards, Dashboards scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Download different sets of data from NHSN MANUALLY.
• Later built a process to automatically download all the files from NHSN and load into POSTGRES Database table using Python and Selenium.
• Worked on performance tuning by creating indexes using bulk collect, for all, collection etc.
• Created backup for tables using export and import.
• Created reports for analyzing the results.
• Working with business users.

Environment: Oracle 11g/12C, SQL/PLSQL, R analytics tool, TOAD, SQL DEVELOPER, PL/SQL DEVELOPER, JavaScript, jQuery, Ajax, HTML, POSTGRES, Python, Tableau10.3, Tableau 10.5, Tableau 2018.1, WINSCP, SVN, UNIX, DBeaver, PyCharm, Eclipse, JIRA, GITLAB.

Confidential - Rockville, Maryland

PL/SQL Developer

Responsibilities:

• Handling ad-hoc queries from the client and incorporated them in the requirements.
• Loaded files like .csv, .txt into tables through SQL*LOADER and EXTERNAL TABLES.
• Created tables, view, Materialized views, indexes, and constraints.
• Created Procedures, function and Packages.
• Worked on performance tuning by creating indexes using bulk collect, forall, collection etc.
• Created backup for tables using export and import.
• Analyzing data for fraud detection with fraudster data and mapping it into different table.
• Created reports for analyzing the results.
• Working with business users.

Environment: Oracle 11g, SQL/PLSQL, R analytics tool, TOAD, SQL DEVELOPER, PL/SQL DEVELOPER, WINSCP, SVN, UNIX .

Confidential - Baltimore, Maryland

PL/SQL Developer

Responsibilities:

• Coordinated with the business team to get necessary requirement from product owner
• Participated in the ongoing process enhancements and modification requests
• Created PL/SQL procedures, functions and packages for moving the data from Flat files.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created scripts to create new tables, views, queries for new enhancement in the application.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer.
• Involved in performance tuning with EXPLAIN PLAN and Indexes.
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement
• Wrote complex queries involving multiple-joins to generate user reports
• Created number of database Triggers according to business rules using PL/SQL.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g, SQL/PLSQL, TOAD, UNIX .

Confidential, Philadelphia, PA

PL/SQL Developer

Responsibilities:

• Involved in defining system requirements, designing & prototyping, developing, testing, training and Implementation of the applications.
• Developed packages for processing data in the staging tables according to the Clients requirements.
• Extensively worked on oracle objects such as Tables, views, synonyms,
• Involved in the developing of the Database objects.
• Wrote PLSQL Packages, Stored procedures and functions for accessing, inserting, modifying and deleting data in the database from GUI.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Used Global temporary tables for processing DML operations on huge data from GUI at one time.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Handled Production issues with high pace and efficiency.
• Optimized existing queries for better performance and less impact on database.
• Used Materialized views in places where the data does not change very frequently.
• Wrote Queries to retrieve data in XML format from the tables.
• Once done with Unit testing migrating the objects to the QA & UAT TEST environment.
• Coordinating and helping the QA team to help understand what the different program aims at.
• Familiarity with entity-relationship/multidimensional modeling (star schema, snowflake schema).
• Created test scenarios for created code and distribute across to the QA along with Knowledge transfer.
• Attending and Solving both QA and Production tickets simultaneously for different programs across different schemas at any given point of time.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.

Environment: Oracle 10g/9i, SQL/PLSQL, TOAD, UNIX, Hp Quality Center, Clear case, Windows Xp.

Confidential

Junior Oracle SQL and PL/SQL Developer

Responsibilities:

• Create database tables, views and sequences.
• Data was inserted and updated into back end using SQL.
• Involved in writing PL/SQL Stored Procedures in Oracle.
• Created Cursor Parameters for retrieving the data.
• Created Functions and Procedures in PL/SQL.

Environment: Oracle, SQL, PL/SQL.