SUMMARY

• 15+ years of strong experience in Information Technology as Senior BI/DW/Oracle Developer having in - depth knowledge in Analysis, Design and Development of Database and Web Service applications.
• Have expertise knowledge in Oracle Database, Cognos, Oracle APEX, DataWarehousing, Cassandra, BO WebiReports, Informatica, ETL, UNIX Shell Scripting, Tableau, Corda, QlikView and Oracle-RDBMS Concepts, for reporting solution for Operational Reporting System.
• Extensively worked on all the phases of Database life cycle from Requirement Gathering, Analysis and Design to Project Support. Extensively worked on all types of Project (Development, Migration & 24*7 Support).Experienced in designing & developing (OLAP & OLTP) Database reporting solutions for Operational Reporting System.
• Expertise in Oracle 9i/10g/11g & PL/SQL Reporting and writing complex and scalable solutions using stored packages, procedures, functions, views, Materialized views and triggers. Have expertise knowledge and experience in Supply Chain Management.
• Have expertise knowledge in Database Concepts, Data Modeling, ETL packages, PL/SQL and advanced Oracle concepts, such as: Bulk Collections, Records, Varrays, Performance Tuning, Hints, TKPROF, SQL Trace, Explain Plans, AUTOTRACE, Indexing, Query Optimization, Materialized Views and Partitioning.
• Developed Control-M jobs for UNIX scripts using KORN shell, Scheduler jobs to automate jobs.
• Have expertise knowledge of various development methodologies like Waterfall, Agile, Scrum and SDLC methodologies. Experience in using Agile based tools JIRA.
• Experienced working as liaison between IT and Business Users and supporting the users. Experienced working proactively in identifying the issues and escalating and communicating the issues to the business clients.
• Liaison with Data Warehouse and ERP as needed to set priorities, define requirements, vet solution design and test as required for reporting and analytics.
• Leverage SQL or similar skills to efficiently model data to meet business needs.
• Prepare monthly, weekly and ad-hoc reports for Supply Chain leveraging Cognos, Oracle Business Intelligence (OBIEE) and Tableau etc.
• Experienced in preparing test cases of the business process or application. Experienced in presenting trainings to the wider audience. Strong Oracle database experience. Excellent communication skills, Passion for analysis and reporting, Fast Learner; Dedicate, Hard worker and Good Team player.
• Have expertise knowledge in CMM and CMMI Quality measures. Have expertise knowledge of complete Agile, Scrum and SDLC methodologies. Dedicated team player with proven analytical, and communication skills. Demonstrated ability to learn Newer Technologies.

TECHNICAL SKILLS

Languages: Oracle PL/SQL, UNIX Shell Scripting, APEX, SQL*Plus, DataWarehousing, Java Script, CSS, JDBC-Spring Frameworks, Oracle and Ajax.

Databases: Oracle 12c/11g/10g/9i, SQL Server 2005/2000, MSAS and MS Access 7.0.

Operating Systems: UNIX, MAC OS X, Windows 2003, 2000, 95, 98, XPWindows NT 4.0, MS DOS.

Front End Tools: Cognos, TOAD, SQL developer, Informatica Power Center 9, Oracle APEX, Tableau, QlikView, Eclipse, Adobe Works, MS-Office Suite, Visio, Corda, CVS, SVN, Splunk, GitHub.

PROFESSIONAL EXPERIENCE

Confidential, NC

Senior Oracle/BI/DW Developer

Responsibilities:

• Data modeling experience for business problems in various domains. Expertise in Analytical operations research background. Implementing software solutions for financial modeling, valuation, financial reporting. Analytical framework for valuation of financial securities.
• Development of PCR feeds which are set of ETL procedures to optionally extract, transform/normalize and load trade data with pre-calculated RCs into the Fact table and Summarized to be reported via a set of external tools (Cognos/Tableau/QlikView/QilkSense)
• Development of scheduled feeds to run in two modes: DAILY and YTD. YTD mode is intended to process YTD data as is. These YTD processes the latest trade versions only for all the feeds on weekly basis. DAILY mode is intended to process DAILY deltas between YTD loads to make the data up to date.
• Develop ETL and CTRL-M jobs. Extract/load raw data from the source system into specific table in LOAD area.
• Develop data normalization and load data from a specific table in LOAD area into STAGE.
• Process the data in STAGE area to apply rates, exclusion/exception rules, overrides, coverage split rules and other split logic etc.
• Develop processes which load data from STAGE area into fact tables into STAR area. These are then populated into summary tables in STAR area based on fact table’s data.
• Specialties: Risk Management, Analysis of Fixed Income Securities, Financial Modeling & Valuation Software.

Environment: Oracle PL/SQL, Cognos, Tableau, Stash, GitHub, Udeploy, Control-M, Informatica, ETL, QlikView, QilkSense, ClickHouse, UNIX

Confidential, Northbrook, IL

Senior Data Engineer

Responsibilities:

• Migration of Oracle to Cassandra mapping and validations. Hands on experience on both Cassandra and Oracle.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Involved in Unit Testing Stored Procedures and Functions. Created Materialized Views and partitioning tables for performance reasons.
• Worked on various backend Procedures and Functions using PL/SQL. Trouble shooted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases. Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements. Created SQL*Loader scripts to load data into the temporary staging tables.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team. Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements. Created Materialized Views and partitioning tables for performance reasons.
• Resolving the issues on priority basis. Responsible for Analyzing and Implementing the Change Requests. Involved in handling the changes in compiling scripts according to the database changes.
• Environment: Oracle PL/SQL, JDBC-Spring Frameworks, MAC OSX, Informatica ETL

Environment: Oracle PL/SQL, Cassandra, APEX, Splunk, GitHub, OBIEE, Informatica, ETL

Confidential

Senior BI Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes and hints on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Initiated APEX Application which users can directly use and set up business rules and campaigns for future dates and pull historical reports for business decisions also.

Environment: Oracle PL/SQL, Cognos 8, SQL, APEX, Informatica, ETL