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/9iSQL 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

Assistant Vice President - 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, IL

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

Confidential

Technical Analyst

Responsibilities:

• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Responsibilities included requirement gathering/analysis, estimation, design& development, test planning and testing, review, deployment and production support.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports. Assisted in defining the scope of the project, technical and business specifications
• Creating complex reports by linking data from multiple data providers, using free hand SQL, stored packages, procedures and functions. Performance Tuning, TKPROF, SQL Trace, Explain Plans, Indexing, Query Optimization, Materialized Views, Compression, and Partitioning.
• Presented Trainings to the higher managements using PowerPoint.
• Involved in documenting the business process by identifying the requirements.
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning. Coding, Code Review, Technical assistance to team. Test developed program modules against prepared test cases. Ensuring quality and timeliness of product delivery. 24*7 Support of the Project.

Environment: Oracle PL/SQL, UNIX Shell Scripting, Cognos, APEX, SQL developer, MAC OSX, Informatica ETL

Confidential

Technical Analyst

Responsibilities:

• 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. Troubleshooted 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, UNIX Shell Scripting, Corda, JDBC-Spring Frameworks, MAC OSX, Informatica ETL

Confidential

Technical Analyst

Responsibilities:

• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Designed Physical and Logical Data model and Data flow diagrams. Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace. Involved in writing several Queries and Procedures. Built database objects like Tables and Views.
• Involved in the Database Design (Relational and Dimensional models) using TOAD Data Modeler. Defined both logical views and physical data structure using Toad Data Modeler.
• Filtered and Loaded data from different formats of data sources into Database Tables. Extracted required data from the database tables and exported the data to different sources in different formats.
• Worked with several tools to access and perform several operations on database. Experience in Generating Reports. Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization. Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Environment: Oracle PL/SQL, UNIX Shell Scripting, SQL developer, MAC OSX, WebIReports, Windows

Confidential

Technical Analyst

Responsibilities:

• Designed and developed database packages, procedures, functions and triggers on Oracle 9i/10g databases.
• Made enhancements and applied defect fixes. SADB functionalities: Distribution, Picking, Inventory Control and Invoice. These changes were developed using Oracle forms, UNIX scripting, PL/SQL and TOAD.
• Created Technical Design documents for major enhancements and attended Technical Design Reviews.
• Created Summary Designs to address fix/enhancement code change to support Story's acceptance criteria.
• Codes and test software that meets the design specifications. Creating complex reports by linking data from multiple data providers, using free hand SQL, stored packages, procedures and functions.
• Presented Trainings to the higher managements using PowerPoint. Involved in documenting the business process by identifying the requirements.

Environment: Oracle PL/SQL, UNIX Shell Scripting, TOAD, Windows

Confidential

Technical Analyst

Responsibilities:

• Coded various stored procedures, packages and triggers to in corporate business logic into the application.
• Used the technical document to design the database tables. Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping. Created control files for SQL*Loader.
• Gather Database and User Level Statistics and Analyze Overall System Performance. Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports. Develop UNIX shell scripts to administer the system.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables. Responsible for purging and archiving the production databases. Used UTL JOB to automate the PL/SQL procedures and packages.
• Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions. Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Communicate issues and progress to project manager. Performed logical backup using export and import utilities. Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Involved in Unit Testing Stored Procedures and Functions. Created SQL*Loader scripts to load data into the temporary staging tables. Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures. Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Created various SQL and PL/SQL scripts for verification of the required functionalities. Developed complex SQL queries for data retrieval from various database objects including tables and views. Worked on various backend Procedures and Functions using PL/SQL.

Environment: Oracle PL/SQL, UNIX Shell Scripting, Jade, Cocoa, MAC OSX, Windows

Confidential

Oracle and UNIX Developer

Responsibilities:

• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Responsibilities included requirement gathering/analysis, estimation, design& development, test planning and testing, review, deployment and production support.
• Responsible for planning and managing offshore delivery.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports.
• Assisted in defining the scope of the project, technical and business specifications
• Creating complex reports by linking data from multiple data providers, using free hand SQL, stored packages, procedures and functions.
• Presented Trainings to the higher managements using PowerPoint.
• Involved in documenting the business process by identifying the requirements.
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning.
• Coding, Code Review, Technical assistance to team.
• Test developed program modules against prepared test cases.
• Ensuring quality and timeliness of product delivery.
• 24*7 Support of the Project.

Environment: Oracle PL/SQL, UNIX Shell Scripting, Windows