SUMMARY

• Oracle Packaged Applications Developer with experience in Oracle BI Applications, ORDM (Oracle Retail Data Model) and OCDM (Oracle Communication Data Model).
• ODI 11g/12c expertise in Development, Installation, Configuration and Administration.
• OBIEE 11g Development and Administration expertise.
• PL/SQL expertise in creating stored Procedures, Functions, Packages, collections and bulk collections.
• Extensive experience on Retail, Telecommunications, Finance and Healthcare Domain.
• Over 8 years of IT experience in all phases of the Software Development Life Cycle (SDLC) including design, analysis, application development, implementation and documentation of data warehouse, data mart and business intelligence.
• Experience in OLTP/OLAP system study, analysis and E - R modeling: developed database schemas like star schema and snowflake schema used in relational, dimensional and multi-dimensional modeling. Extensive experience with Fact, Dimensional tables, Slow Changing Dimensions, Physical and Logical data modeling.

TECHNICAL SKILLS

Oracle Applications: ORDM, OCDM and Oracle BI Applications (Finance)

ETL Tool: Oracle Data Integrator 10g, 11g, 12c

BI Tools: OBIEE 11g, BI Publisher

Databases: SQL, PL/SQL, XML, HTML, SQL Server 05/08, Oracle 10g, 11g

Operating Systems: Window XP/2000/NT, Window Vista, Window 7

PROFESSIONAL EXPERIENCE

Sr. ODI Developer

Confidential, Wilmington, Delaware

Responsibilities:

• With use of Groovy to automate the ODI tasks and exploit the ODI SDK to its full potential.
• Used Groovy ODI SDK to update hints in various interfaces according to new standards in various interfaces.
• Generated documentation skeleton using Groovy SDK to facilitate quicker documentation.
• Used ODI Repository tables to do log analysis and built reports to get the trends in the load time.
• Participated in business requirement gathering through interactive sessions with the business teams and DB architect teams.
• Involved in preparing system requirement specifications and design documents to provide an overview of the technical design specifications required for the warehouse enhancements.
• Extensively worked in the designer, topology and operator navigators.
• Created the topology including physical architecture, logical architecture and context.
• Created new models for the data sources, flat files, MS SQL server and Oracle.
• Worked in sample data population in the foundation layer.
• Designed, built and test sequencer jobs to run all of the server jobs (Extract, Transform, Load Dimension data and load fact data in Sequence).
• Changed the knowledge modules to customize as per the requirements.
• Performed sending mails to the teams whenever any ODI jobs were failed by using ODI tools.
• Administered in ODI by monitoring the ODI scheduled scenarios in the QA and production environments.
• Developed and deployed dashboards, analytics and reports properly.
• Designed and placed data in layers varying to physical, business and presentation.
• Worked with the administrators, users and analysts to maintain exchange of the reporting requirements.
• Used the best practices of the business to meet project and company objectives.
• Identified production faults and critical issues fallowed and troubleshoot them.
• Provided remedial measures to the production issues or process failures.
• Prepared yearly, quarterly and monthly reports and presented them to the management.

Environment: ODI 11G, Oracle 11g, Windows NT/XP, Linux

Oracle BI Applications Developer

Confidential, New York, NY

Responsibilities:

• Excellent technical skills in Oracle Business Intelligence (OBIEE), including OBIA, BI Repository development, reports and dashboards creation, and catalog/security administration in presentation services Configuration.
• Developing and plan executive level dashboards, complex reporting, and metadata modeling.
• Participating in the configuration, and documentation of all OBIEE, OBIA components.
• Extensively working in creating hierarchies and aggregates in the BMML, data and object level Security in OBIEE 11g.
• Expertise working with Oracle Financial Analytics Subject Areas
• Created different types of Customized Reports (Drilldown, Aggregation for Sales and Product) to meet client requirements.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger (GL).
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Extensive experience in customizing OBIEE 11g dashboards and reports / Dashboards with different analytic views (Drill-Down/Dynamic, Pivot Table, Chart, Column selector, Tabular with local and global filters) using OBIEE 11g.

Environment: OBIA 7.9.6.x, OBIEE 11g, Oracle 11g, Windows 7, Solaris server.

Sr. BI/ETL Developer

Confidential, Ronkonkoma, NY

Responsibilities:

• Participated in business requirement gathering through interactive sessions with the business teams and DB architect teams.
• Identified Facts and Dimensions according to the design specifications.
• Involved in preparing system requirement specifications and design documents to provide an overview of the technical design specifications required for the warehouse enhancements.
• Extensively worked in the designer, topology and operator navigators.
• Created the topology including physical architecture, logical architecture and context.
• Created new models for the data sources- flat files, MS SQL server, and Oracle and Metadata population in model.
• Worked in sample data population in the foundation layer.
• Involved in creation/modification of DDL using OSDM and SQL developer.
• Designed, built and test the sequencer jobs to run all of the server jobs (Extract, Transform, Load Dimension data, Load fact data in Sequence).
• Modified the Intra-ETL Packages and Procedures to populate the derived Tables and Aggregate tables.
• Created and configured business intelligence server metadata for Confidential reporting project.
• Created the connection pools that were used to import the objects from OLAP into Physical Layer.
• With use of the administration tools, I designed and developed OBIEE RPD and configured repository with logical dimensional modeling using star schema methodologies.
• Created dimensional hierarchies, level based measures and added Aggregate tables against base fact tables.
• Developed many Ad-hoc and standard reports/dashboards with different analytics views (Drill Down, Pivot Table, Chart, Column Selector and Tabular with dashboard and page prompts) using the OBIEE analytics Web.
• Designed and implemented the new security changes in OBIEE 11G.
• Provided the necessary backups of ODI master and work repository, OBIEE rpd and the Webcat folder.
• Deployed the repository and Webcat from Dev to QA to UAT to production.

Environment: ODI 11G, OBIEE 11g, Oracle 11g, Windows 7, Unix server, ORDM 11.2

ODI/OBIEE Consultant

Confidential

Responsibilities:

• Involved in mapping functional requirements to technical design documentation.
• Interacted with individual application owners to understand the respective system.
• Worked extensively with interfaces, procedures and variables as per the requirements in ODI.
• Reviewed and captured the known major errors/bugs in the existing application.
• Monitored the daily backups of the repositories.
• Debugged the master jobs and packages by using the operator navigator.
• Created ELT workflows in the package by using ODI tools.
• Monitored interfaces and execution logs as per the requirements.
• Created several reverse engineering models as per the requirements.
• Developed packages as per the requirements.
• Developed interfaces for dimensional incremental uploading.
• Created reports and prompts in answers and created dashboards and links for the report.
• Extensively worked in the designer, topology, operator modules and metadata population in models.
• Worked in sample data population in the foundation layers.
• Involved in creation/modification of DDL using OSDM and SQL developer.
• Development/maintenance/customization Intra/Source ETL development through package/ODI.
• Worked on OCDM reports using OBIEE 10g and worked on sample data population and coordinated with the offshore team.
• Developed the RPD and generated the reports as per the client’s requirements.
• Created reports and prompts in answers and created dashboards and links for the report.

Environment: ODI 11G, OBIEE 10g, Oracle 11g, Windows 7, OCDM 11.1, Solaris Server

ODI Consultant

Confidential, Orlando, FL

Responsibilities:

• Gathered business requirements by interacting with the business users and defined subject areas for analytical data requirements and prepared design documents.
• Worked extensively in the designer, topology and operator modules.
• Worked extensively with Interfaces and Procedures and Variables as per the requirements in ODI.
• Migrated Objects into other environments and performed well in testing levels.
• Performed integrated testing for various mappings. Performed UAT and data migrations from Development to testing.
• Created ELT workflows in the package by using ODI tools.
• Resolved the issues in mappings and packages during execution.
• Developed the RPD and generated the reports as per the client requirements.
• Created reports and prompts in answers and created dashboards and links for the report.
• Developed, implemented and deployed data warehousing and business analytical solutions.
• Worked in collaboration with data analysts, business analysts, other technical teams and business teams.
• Involved in ETL applications, data feeding, cleansing, archiving and re-modeling.
• Prepared documentation and gave project performance feedback to the clients and the senior management.

Environment: ODI 11g, Oracle 11g, Linux, Windows 7

Software Developer

Confidential

Responsibilities:

• Gathered business requirements by interacting with the business users and defined subject areas for analytical data requirements and prepared design documents.
• Converted the functional requirements into technical documents as per the business standards.
• Analyzed the existing codes and did the impact analysis.
• Created data base objects like, Tables, Views, Sequences, Synonyms and Stored Procedures, Functions, Packages, Cursors, Ref Cursor and Triggers as per the business requirements.
• Used SQL Loader to upload the information into the database and used UTL FILE packages wrote the data to the files.
• Maintained and managed all versions of the data models for production, testing and developing databases.
• Tested the codes functionality using testing environment.
• Used different Joins, sub queries and nested query in SQL query.

Environment: SQL, Windows XP, Oracle 9i,SQL/PLSQL

Software Developer

Confidential

Responsibilities:

• Setting up new MS SQL Server instances and databases.
• Going through the clients’ requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Capacity planning of MS SQL Servers. Implemented and maintained database security.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Have written several stored procedures and Triggers as per the client requirements.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000, Transact-SQL, Enterprise Manager, Query Analyzer, Oracle 8i, DTS Designer, SQL Profiler, Index Tuning Wizard and MS-ACCESS 2000