SUMMARY

• Over 6 years of programming experience as an Oracle and PL/SQL developer in Analysis, Design, Data Modeling (Logical and Physical) and Implementation of Business Applications using Oracle products
• Database: Using Oracle 10g/11g/12c, Teradata TD13/TD12, SQL, PL/SQL, SQL*Plus, SQL Server 2005/2008. Proficient in working with PL/SQL. Expertise in TOAD (Tool for Oracle Application Developers).
• Extensively worked on PLSQL - Functions, Procedure, Functions, Packages, Ref-Cursors, Triggers, Views, Materialized Views, Hits and Indexes.
• Strong hands on experience usingTeradata utilities (B-TEQ, FastLoad, MultiLoad, FastExport, and Tpump).
• Strong Data warehousing experience using Informatica Power Center, Power Connect for ETL, OLTP, OLAP, Data Mining, and Scheduling tool. Worked with heterogeneous source systems like flat files, RDBMS, and XML.
• Data Modeling: Data modeling noledge in Dimensional Data modeling, SCD, Star Schema, Snow-Flake Schema, Dimensions and Fact Tables, Physical and logical data modeling and De-normalization techniques.
• Experience in data cleansing/profiling operations on Source data (From source to Staging) and experience in performing SCD Type 1,2 and 3 on Target data.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof, Table Partitioning.
• Involved in providing Extensive production support to various Applications along with server Maintenance projects 24x7.
• Experience in Using JIRA for bug tracking, Issue tracking and project management.
• Experienced in MS Power BI Desktop and Power BI Service.
• Knowledge in generating periodic reports based on the statistical analysis of the data from various time frame and division using Power BI.
• Extensive noledge in writing DAX queries to measure the calculated columns.
• Worked extensively on Power BI and created Reports/Dashboards using different type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts etc. to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI.
• Extensive noledge in Transform and combine the data using Query Editor in the Power BI and publish to Power BI Service.
• Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
• Experienced in generating monthly and quarterly reports as bar charts for the management using different techniques like data filtering and deploying reports to Power BI Service.
• Proficient in Power BI data visualization to analyze and obtain insights into large datasets, create visually powerful and actionable interactive reports and dashboards.
• Experience in developing applications using Agile, Scrum and Waterfall methodologies.
• Experience in developing reports and forms using Oracle forms and reports 6i/9i.
• Good experience in version control of documents and database objects using tools like VSS and SVN.
• Experience in developing applications using Agile, Scrum and Waterfall methodologies.

TECHNICAL SKILLS

Approaches: Waterfall, Agile/Scrum, SDLC, STLC

Programming Tools: C, C#, SQL, PL/SQL, R, JAVA

RDBMS: Oracle 9i/10g/11g, SQL Server 2008/2005/2000, MS Access 9.0/7.0, Teradata 12/13, Sybase, UDB DB2, My Sql.

Databases: Oracle, SQL SEVER

Reporting Tools: Power BI, SSRS, Oracle Reports

Defect Tools: JIRA

Operating Systems: Windows NT/ 2008/2000/2003/ XP/Vista/7,Linux, UNIX

Utilities: OKTA, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

Sr Oracle PL/SQL Developer

Responsibilities:

• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.
• Performed discussions with data modeler to update the data model for new requirements.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
• Involved in PL/SQL code review and modification for the development of new requirements
• Developed PL/SQL code for various levels of front-end validations
• Integrated customized forms into Oracle Applications and added new forms and registered in Oracle applications
• Developed multiple reports using Reports for listing the customers who visited the center
• Used PL/SQL and SQL *Loader to import /export data from various sources
• Analyzed the security holes in the PL/SQL and Java script coding. Fixed all the security hole and bugs in most of the packages and also fixed security hole in control file’s of the SQL*loader
• Extracted data from the source views by writing the procedures to load the data into staging tables
• Created materialized views on remote source database and automated scheduler of refreshing of materialized view on source side.
• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL
• Database security by authenticating users, using logon triggers.
• Created indexes on tables and optimized procedure queries.
• Fine tuned the SQL queries using optimizer hints for joins, parallelism and Explain plan
• Fine tuned the PL/SQL queries by creating complex views, using explain plan and use TKPROF if necessary
• Created the integrity constraints and database triggers for complex data validations
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Copied the data from oracle database to an external directory in an XML format.
• Used SVN to version control all the database scripts.
• Developed and implemented several types of Financial Reports by using SSRS. Validated reports and resolve issues in a timely manner.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Migrated existing self-service reports and ad-hoc reports to Power BI.
• Creating relationships between different datasources in Power BI to visualize the data and build the reports.
• Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using Power BI.
• Wrote Calculated Columns, Measures, and Queries in Power BI desktop to show good data analysis techniques.
• Responsible for Unit, System and UAT testing the data and provided the test evidence reports.
• Involved in UAT testing, Bugs fixing and the code was sent to Production.
• Executed the test scripts in Quality Centre and raised the defects.
• Responsible for writing the functional and technical design documents and maintaining the documentation

Environment: Oracle 11g, Oracle Forms 6i, Reports 6i, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL Developer 6.0, Toad 9.1, UNIX, Erwin r4, XML, SVN, Informatica power center tool 8.1.1, QC 10.0, Windows.

Confidential, San Jose, CA

RDM Developer

Responsibilities:

• Involved in getting the User Requirements, Data Modeling & Development of the RDM Application.
• Extensively used SAP Power Designer to create data models
• EncapsulatedPL/SQLprocedures and functions in packages to organize application.
• Extensively used Views, Cursors, Store procedures, Packages, Collections and Triggers.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Participated in Performance Tuning using Explain Plan and created local indexes to increase the performance and to make the database objects more manageable
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Responsible for creating objects, deploying jobs and providing production support for Reference Data Management (RDM) application
• Collaborated with Hadoop team to provide data masking and data encryption for RDM application.
• Involved in UAT testing, Bugs fixing and the code was sent to Production. Executed the test scripts in Quality Centre and raised the defects.
• Designed python scripts to scrape data from websites.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, flat files,, SAP Business Objects, SAP Power Designer, Teradata 15, and Python 2.7.

Confidential, Irvine, CA

RDM Developer

Responsibilities:

• Gatheird requirements from Business users and created a Low level technical design documents using high level design document.
• Participated in the design meetings, and prepared technical and mapping documentation.
• Wrote SQL scripts to create temporary tables and developed control files for SQL*Loader to load from legacy system into the temporary tables.
• Created various types of procedures using PL/SQL and SQL queries for data validation, data cleansing.
• Designed and developed the scripts to create table, views, indexes and sequence.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Involved in using dimensional modeling, created fact tables, dimensional tables and other database objects in the Star schema model.
• Involved in Performance tuning, Included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats.
• Wrote Procedures to drop appropriate Indexes on tables to improve the performance of loading.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Participated in performance tuning, unit test case preparation and execution.

Environment: Oracle 10g, Informatica, flat files, SQL Loader, SQL * plus, PL/SQL, Erwin 4.0/3.5.2, and Unix Shell Scripting.