SUMMARY

• 11+ years of IT experience as an Oracle, PL/SQL Developer, Data analysis, System Analysis, Implementation and Maintenance of Business Intelligence and Data Warehousing.
• Around 4 years of programming experience as an Oracle, PL/SQL Developer with the Oracle 9i/11g in Analysis, Design and Implementation of Business Applications using the Oracle Relation Database Management System (RDBMS).
• Over 2 years of TableauExperience in enterprise environment including report / dashboard design, development and maintenance of Tableau Desktop and Tableau Server.
• Good knowledge in complete SDLC life cycle including Requirements gathering, requirements elicitation, high level design, detailed design, Integration testing, stress testing, release management, change management etc.
• Have good problem - solving techniques and provided support for many production issues.
• Decent knowledge in performance tuning of oracle jobs.
• Skilled in Unix Shell Scripting.
• Worked on Joins, subquery, Indexes and sequences to improve performance and make the application to run faster.
• Worked on set operators inPL/SQLlike Union, Union all, Intersect and Minus.
• Participated in the development of new PL/SQL procedures, functions, triggers and updating the old ones based on the change request.
• Created various DML and DDL statement using Oracle Pl/SQL and SQL.
• Created database objects like tables, views, cursor (Implicit, Explicit, REF), packages, curser using Oracle tools like TOAD as per business requirement.
• Prepare sequence for automatic generation of unique keys to support primary and foreigner key constraints in data conversions.
• Involved in table redesigning with implementation of partition indexes to make database faster and easier to maintain.
• Well-versed in using tools like TOAD, SQL*Plus and SQL Developer.
• Prepare the test scenarios and performed unit and regression tests on PL/SQL programs.
• Experience in writing dynamicSQLStatements using EXECUTE IMMEDIATE and DBMS SQL.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Have received multiple client appreciations for immediate response & resolution to queries posted
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, line diagrams, pareto charts, funnel charts, scatter plots, pie-charts, donut charts, bubble charts, funnel charts, heat maps, tree maps according to the end user requirements.

TECHNICAL SKILLS

Operating Systems: MS Windows, CentOS LINUX, UNIX

Languages: PL/SQL, SQL, HTML5, CSS

Databases: Oracle 9i/11g Enterprise edition, SQL Server.

Tools: TOAD, Tableau, Microsoft Excel

SDLC Methods: JIRA, Agile

PROFESSIONAL EXPERIENCE

Confidential - Burbank, CA

Responsibilities:

• Provided production support for System ESS application.
• Understanding and Collecting requirements from Business and convert that requirement to SQL queries or PL SQL.
• Use different strategies of database development to meet the requirement
• Involved in extracting business data using PL/SQL from Oracle databases and filtering the data according to the business requirement.
• Created database objects like Procedures, views, cursors using Oracle tool like TOAD as per the business requirement.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, REF CURSORS.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• Created various DML and DDL statement using Oracle Pl/SQL and SQL.
• Worked on set operators inPL/SQLlike Union, Union all, Intersect and Minus.
• Worked on Joins, Subquery, Indexes to improve performance and make the application to run faster.
• Performed Unit Testing to analyze and conclude whether the scripts are executed and met the client requirements.
• Created mappings/sessions to process purchase order, sales order and product related data from different sources to down streams AR, AP and artist royalties.
• Providing and Automating Ad hoc Reports from NIDB (National Inventory Database System) System.
• Implemented procedures for identification and resolution of application issues in coordination with other IT team members.

Environment: Oracle 9i/11g, SQL, PL/SQL, SQL*Loader

Confidential - Glendale, CA

PL/SQL Developer

Responsibilities:

• Participated in the Database Analysis, design and Interacted with the business users and participated in requirement collection.
• Developed and modifiedPL/SQLcode to make new enhancements or resolve problems, as per customer requirements.
• Involved in SDLC gathering requirements from users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, triggers, functions, procedures, and cursors.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Created stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, REF CURSORS.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.

Environment: Oracle 9i/11g, SQL, PL/SQL, SQL*Loader

Confidential

SQL/BIDeveloper

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel andSQLServer for design, development, testing, and production rollover of reporting and analysis projects.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Involved in the continuous enhancements and fixing of production problems
• Troubleshooting query performance.
• Generated and Published Daily, Weekly, Monthly reports as per the Client's requirement
• Monitored Database server, performing health check,SQLJobs on day to day basis
• Involved in creating and schedulingSQLjobs as per requirements.

Environment: SQL, Tableau, MS Excel, Microsoft Office (Word, Excel, Power Point)

Confidential

SQL/BI Developer

Responsibilities:

• Generated monthly statistics reports on market-trends and developed market specific reports for management and sales department.
• Managed the design of the company surveys in collaboration with sales and customer service.
• Contributed to the development of sales budgets and forecasts for the sales team.
• Generated monthly forecasting reports on sales trends and product supply.
• Analyzed specific product information and produced reports for management daily.
• Reviewed forecasts in insure accuracy and to control product cost.
• Used Clear Case for creating documents repository and sharing the documents across the team.
• Conducted one to one and group interviews to understand Business Requirement and subsequent documentation.
• Converted Business Requirements to the Functional Specification and Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Created Use Cases / Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model.
• Developed customized SQL reports and queries for management decision-making and operational management.
• Involved test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.

Environment: SQL, Microsoft Office (Word, Excel, Power Point)

Confidential

Business Development

Responsibilities:

• Responsible for collection of subscription revenues as per targets assigned, penetration in all markets and seeding of new TV channels from the network with appointed distributors in the territory.
• Reconciliation of customers outstanding monthly, distributor monthly reconciliation; ensure all accounts are maintained for all customer by distributors.
• Ensure compliance of all operational norms that have been assigned and database management for the territory. Audit all sales transactions in the system for the distributor.
• Ensuring that all network outstanding is collected from the assigned territory on a monthly basis
• Responsible for maintaining a record of all sale and purchase order.
• Coordinates with senior management for timely supply of activation boxes.
• Reviews all orders of major customer, track shipment of orders and timely delivery, manage documentation.

Environment: Microsoft Office (Word, Excel, Power Point), Oracle’s Siebel CRM system