SUMMARY

• Sr. BI Developer with 8 years of experience System Analysis, design and development of database applications in Client/Server applications using Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Loader.relevant ExperiencE & Skills
• Manging and Leading the projects as well as attending business meetings to gather the requirements.
• Involved in creating requirement documents as well as design documents in parallel with Devlopment work. Invloved in creating Groups of tasks apart from assigned projects and lead production support.
• Worked as a acting PM when necessary to the team. Experienced in Agile Environment and Waterfall.
• Proficient in developing concurrent programs using SQL, PL/SQL and UNIX Shell Scripting.
• Experienced in developing Master - Detail and Transaction Forms in Oracle Forms Builder (6i/10g) on Windows and Linux platforms, also involved in writing UNIX Shell scripts when needed.
• Experienced in developing Simple and Matrix reports in Oracle Reports Builder (6i/10g) on Windows and Linux platforms.
• As a part of 4DX worked on multiple projects and created tasks on my own to learn and implement Core Java concepts,Tableau and use Grafana for ananlysis reports and monitoring.
• Hands-on experience in Tableau & Core Java.
• Involved in OBIEE Reporting and ETL’S.
• Invloved in Production Support and ON calls.
• Experienced in leading offshore team (QA/Dev Role).
• Experience in building Data marts for a Commercial Lending Banking product.
• Proficient in PL/SQL programming - Stored Procedures, Functions and Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers.
• Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections.
• Expertise in Query Tuning.
• Good understanding of oracle Data Dictionary, RDBMS and Normalization Techniques.
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Testing (UAT), Quality Assurance, Code Review.
• Hands-on experience with Oracle Reports, SQL, PL/SQL, Open Interfaces, and apis.
• Good Understanding of GUI using javascript, HTML, DHTML, XML,COLD FUSION 8.0.
• Thorough knowledge in software processes and involved in all phases of development life cycle.
• Involved in developing Forms and Reports using Oracle9i, 10g (ORACLE 10g AS).
• Involved in preparing Integration test, Database Test for TOAD.
• Experience in Unit and Integration Testing.
• Knowledge in UNIX, and Shell Scripting.
• Knowledge of DB2 Database.

TECHNICAL SKILLS

• Windows XP/ NT/95/98/2000, UNIX, SQL,
• PL/SQL, UNIX Shell Script, JavaScript,
• HTML, Cold Fusion, C, C++,
• Oracle 10g, 9i, 8i,
• SQL server 2000/2005,
• Oracle Pl/SQL Developer Suite,
• Reports 9/10, TOAD, SQL*Plus, SQL*Loader,
• Work-flow, SQL Navigator,
• Toad, MS Word, Excel,Tableau,Obiee.

PROFESSIONAL EXPERIENCE

Sr. Oracle PL/SQL Developer

Confidential, Denver,CO

RESPONSIBILITIES:

• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Worked with the data conversions by application screens.
• Worked for designing Logical and Physical data models for Master Data and Transactional Data.
• knowledge and experience in structured systems analysis and design techniques.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Prepared the Mapping document which details out the mapping of source to the target data model with application of business rules.
• Importing and exporting the data into multiple environments.
• Support and Maintenance of Monthly Metric Reports for LOB Analysis.
• Active part in 4DX projects,apart from the assigned projects.
• As a part of 4DX worked on multiple projects and created tasks on my own to learn and implement Core Java concepts,Tableau and use Grafana for ananlysis reports and monitoring.
• Implemented Nagios Alarming on multiple operations and Automating the recycle process.
• Designed and developed audit control process for PL/SQL jobs to keep track of all the job execution along with balance and reconciliation reports.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate
• conditions, parsing of objects and hierarchies.
• Worked with Postman and Soap URL’s as a part of implementing code.
• Involved in ETL Design and development of Informatica mappings and sessions.
• Developed PL/SQL programs to load and validate the data into staging environment
• Tuning Legacy operations and Automated the Analysis reports.
• Developed reports using SAS scripts.
• Devloped Tableau Reports to display monthly ananlysis on each LOB requirements.Designed and Implemented the ETL for the report flow,created Dynamic Data Types,Implemented Data Aggregation in Tableau.
• Invloved in Performance considerations in Tableau vis,calculation and Dashboard design.
• Involved in creating OBIEE dashboards and migrating OBIEE Dashboard reports to Tableau and Graphana.
• Automated Daily outlook email reports to Tableau display.Created grant charts and box charts for data display.
• Involved in creating Word Cloud bubble charts in tableau as a part of 4dx project to track a game in the team.

Environment Oracle 11g, SQL Server Reports 10g, GoCd Pipelines,GIT Implementation.SQL, PL/SQL, Toad, Tableau, Oracle RDBMS, SQL Developer,OBIEE,SOAP and PostMan.

Sr. Oracle PL/SQL Developer

Confidential, Co

RESPONSIBILITIES:

• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.Created Repository by building Physical Layer, Business Model and Mapping Layer, and presentation Layer using Oracle Admin Tool.
• Involved in getting the perl c coding and making changes to the production if necessary on the new implementation logics.
• Involved in creating and implementing SqlCopy and DB links (Supported the scripts and necessary P1 level access) across the servers.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update
• Strategy transformations extensively.
• Created data mapping files for the data coming from different web services.
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked with DBA extensively to create External tables, Loading schedules,Redo & Undo logging.
• Worked on various backend Procedures and Functions using PL/SQL.
• Developed the forms and Reports as per the requirements.
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.

Environment Oracle 11g, APEX, SVN,SQL, PL/SQL, Toad, Tableau, Oracle RDBMS, SQL Developer,SQL Loader,External Tables.

Oracle PL/SQL Developer & System Analyst

Confidential, Long Island, NY

RESPONSIBILITIES:

• Involved in writing new procedures and enhancing the existing procedures.
• Knowledge and experience in structured systems analysis and design techniques.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Worked with ETL team and architect to build data model for staging area.
• Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
• Worked on SFTP process.
• Involved in creating detailed Functional Documentation which includes all Business part of production support.
• Invloved in Data Analysis and Debugging the legacy code with no documentation.
• Invloved in working with offshore both QA and Devlopment team.
• Invloved actively with the PM role to understand and assign tasks to offshore team and get the daily updates,soley responsible for representing the offshore team.
• Performed SQL tuning using Explain Plan, Hints and indexes
• Responsible for performing code reviews
• Created SQL*Loader scripts to load data into temporary staging tables.
• Utilized SQL*Loader to load flat files into database tables.
• Used reports to display formatted data. Reports can be viewed in the database where they were created or printed. Saved reports as snapshot files so they can be viewed outside an Access application.
• Created Repository by building Physical Layer, Business Model and Mapping Layer.

Environment: Oracle 10g, SQL Server Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS, SQL Developer.

Jr. PL/SQL Developer and Testing/Java

Confidential

RESPONSIBILITIES:

• Involved in the whole life cycle of the project.
• Interacted with clients to understand their requirements.
• Involved in Table design.
• Programmed Packages, stored procedures, queries, and triggers on Oracle 10g.
• Used Unit and System Testing.
• Planed and supervised the daily activities of the application support.
• Implemented Database Query tuning and implementation.
• Involved in resolving production problems for the applications and Ensure all support service level agreements are met.
• Prepared root cause analysis for problems occurred.

Environment: SQL PLUS, PL/SQL 2.3.4, TOAD, Windows XP.

Oracle Server Developer/ Java / QA

Confidential

RESPONSIBILITIES:

• Involved in maintaining database, handling performance issues, query optimization, locking issue, creating DTS Package and documentation.
• Developed packages, procedures, functions, and triggers for the application.
• Used UNIX environment for performing the testing.
• Performed the tests on the newly coded procedures and documented the same.
• Written technical documents using the functional specifications.
• Written PL/SQL code using the technical and functional specifications.
• Created Oracle objects like tables, types, packages, procedures and functions.
• Automated SQL loader using shell scripting.
• Made a JAVA Chat Server using JAVA and JUnit as the testing tool the product
• Developed various Customer and Network capacity flows. Developed various server side components using J2EE and TIBCO APIs.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.
• Understanding the QA cycle,writing test cases,presenting demo on the test scenarios.
• Reporting Test (Apex,OBIEE).