SUMMARY:

• 5 years of overall experience, including 2 years of relevant IT experience in Requirements Gathering, Analysis, Design, Development, Implementation, Testing, and Support for Business Intelligence applications using Oracle RDBMS.
• Used Oracle Data Integrator Designer (ODI) t o develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Possess clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL/ELT Using ODI (Repository Manager, Topology, Designer, Load Plan Generator, Operator).
• Implemented Projects, Interfaces, Scenarios, Packages, and Load Plans in ODI.
• Experienced in UNIX working environment, writing UNIX shell scripts for ODI session operations.
• Experiences in creating BI reports in different subject areas, critical analysis and upgrade of the existing reports.
• Hands - on experience in using BI reporting tools like Oracle Business Intelligence Enterprise E d i t i o n (O B I EE ), Oracle BI Publisher, Crystal Reports, Discoverer Reports.
• Experienced in creating executive reports with BI Publisher integrated with OBIEE.
• Highly experienced in creating Oracle BI Publisher Report Templ ates using BI Publisher Desktop Edition.
• Proficient with using various templates to publish BI Publisher and Crystal reports as per user requirements.
• Experienced in delivery of BI Publisher reports to FTP locations.
• Experienced in building Interactive Dashboards and Reports with drill-down capabilities, filters, prompts, pivot tables, etc.
• Very good in Performance Tuning of Oracle BI Reports and ODI jobs.
• Actively involved in Performance Tuning, Error handling and production support for various projects.
• Performed Data Validation to check if correct data is present in the reports and dashboards.
• Experienced in designing and developing Stored Procedures, Packages, Functions, Views, Cursors, Sequences, Dynamic SQL using Oracle PL/SQL.
• Expertise in using Hints t o t une the performance of PL/SQL queries.
• Experience in creating patch scripts t o deploy PL/SQL objects after database refreshes.
• Experience in translating Business Requirements to Functional and Technical specifications, ensuring delivery, and tracking requests.
• Experienced in analyzing the needs of the user and accordingly creating new BI reports in OBIEE, BI Publisher, and Crystal.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS:

Business Intelligence: OBIEE 11g

ETL Tools: ODI 12c

Databases: Oracle 12c

Reporting Tools: Oracle BI Publisher 11g, Crystal Reports, Oracle BI Discoverer 10g

Database Tools: Oracle SQL Developer

Languages: PL/SQL, UNIX Shell Scripting, R, MS SQL

Analytics: OBIEE, RStudio

Operating Systems: Microsoft Windows 7/10/XP

PROFESSIONAL EXPERIENCE:

Confidential

ODI/ETL Developer

Responsibilities:

• Used Oracle Data Integrator Designer (ODI) t o develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse.
• Implemented Projects, Interfaces, Scenarios, Packages, and Load Plans in ODI.
• Worked on various development phases of Active Data Warehouse (ADW) using Agile methodology in collaboration with BI data modelers, developers, analysts, and architect.
• Br a ins t o r med a nd created t he solutions required to resolve issues with the deletion and update of data in source systems.
• Ex t r a c ted d ata from various source systems, such as Oracle Database, Microsoft Database, and flat files.
• Troubleshot and tuned performance of ODI jobs by analyzing the logic used in the mappings.
• Created d a ily jobs using variables.
• Created UNIX Shell Scripts to conduct pre and post ODI session operations.
• Improved performance of ODI jobs by using a combination of procedures and knowledge modules t o speed up the processing.
• Created tables, views, procedures, functions, andsequences using PL/SQL to be used in the ODI jobs and in OBIEE for ad-hoc reporting and dashboards.
• Reverse engineered the source and target system objects.
• Edited the XML code of mappings to resolve file corruption.
• Created a nd maintained the deployment documents t o s t rea mline the deployment to production.
• Provided post-production support, enhancements, and performance tuning of the ETL process.

BI/PL-SQL/Oracle/ODI Developer

Responsibilities:

• Mi grated t he enterprise reporting system with 300+ Crystal Reports to Oracle BI Publisher.
• In ter a c tedwi th Subject Matter Experts and Business Analysts for requirements gathering and analysis.
• Created PL/SQL objects, including tables, views, procedures, functions, and package fun c t ion s to be used in the data models in BI Publisher.
• Created data models that allow data filtration using parameters for user input dates, lists items, and text.
• Created d ata models with complex connected data sets to connect data from different source systems.
• Created BI Publisher templates in the online Layout Editor.
• Created BI Publisher RTF templates using Oracle BI Publisher Desktop Tool.
• Created multi-format enabled reports that could be opened in multiple tools, such as MS Excel, MS Word, PDF, XML, CSV, HTML, and Interactive Mode (restricted to Layout Editor Templates).
• Offered drill-down functionalities, pivot tables, graphs and charts, filtration by groups, and hyperlinks i n v a r ious reports.
• Created user-training documentation including instructions to access and schedule the reports, and conducteduser-training sessions.
• Coordinated the User Acceptance Testing (UAT) effort and helped wi t h c omplet ing validation process.
• Provided post-production support, enhancements, a n d p erf o rm a n ce tuning of the reports.
• Worked with system engineers to enable FTP locations in order to deliver reports directly to user-accessible folders using the FTP Deliver y feat u re of BI Publisher reports.
• Guided users on best-practice for scheduling and accessing reports.
• Created patches for the Database Administrators to apply after completing database refreshes to seamlessly enable the BI Publisher reports to work.
• Embedded BI Publisher reports within OBIEE Dashboards.
• Created ETL processes using ODI for reports using similar queries to optimize and improve the performance and report scheduling.
• Conducted performance tuning of PL/SQL queries used in the reports using hints.
• Used various source systems t o create reports, including the Oracle Utilities Customer Care & Billing (CC&B), Utility Center, TWACS (Two Way Automated Communications System) (OLTP source for inputting meter related data), and Asset & Resource Management (ARM) applications (work requests, crew scheduling, etc.)
• Provided support of various Crystal reports that broke down before the corresponding BI Publisher reports were released in production.

BI/PL-SQL/Oracle/ODI Developer

Responsibilities:

• Migr ated t he Oracle BI Discoverer repo r t s to OBIEE.
• Worked with Subject Matter Experts to gather requirements.
• Trimmed the reports to be mi g r ated by consolidating multiple requirements within singular queries.
• Conducted analysis ofthe ETL processes t o a llow report consolidation in OBIEE.
• Worked with database administrators to migrate PL/SQL objects wi t hi n different schemas.
• Created BI Analysis and Dashboards in the Presentation Layer t o mimic the Discoverer reports.
• Created patch scripts and documentation for BI Analysts to use for maintaining the reports after database refreshes.

BI/PL-SQL/Oracle/ODI Developer

Responsibilities:

• C reated solutions using reporting tools, ETL, and PL/SQL objects for c us t omer s in the Finance and Accounting departments.
• Worked closely with Subject Matter Experts from the Finance and Accounting Dep a r t men t s for requirements gathering.
• Created complex queries using nested queries, group by and order by clauses, and subqueries.
• Created customized reports a n d c ondu c ted data validation for these reports with the customers in the test environments.
• Created patch scripts for PL/SQL objects to be deployed in the test and production environments.
• Extracted historical data requi red for internal and external audit purposes, and automated t hi s p r o cess by creating reports that deliver this data.
• Created repo r ts to identify external customers that are unreachable for equity delivery purposes.
• Incorporated hierarchy logic for customers designated for equity delivery within various reports and ETL mappings.
• Provided post-production support for enhancements and tuning.

Leasing/Community Assistant

Responsibilities:

• Integrated the filing systems for residents after merger of two properties.
• Reviewed leasing documents for prospective and current residents.
• Prepared and maintained lease documents using the Leasing Administration and Marketing Sy s t e m ( L AM S ), a proprietary lease maintenance application.
• Qualified and closed prospective residents.
• Conducted property demo tours for prospective residents to show the a p a r t men t s a nd other amenities.
• Coordinated housing maintenance and pest-control reques t swi th the on-call staff and the residents using MRI, a real estate software used for tracking maintenance requests from residents.
• Conducted pest-control visits i n c oll a bo r at ion with the pest-control specialists.
• Ma in ta ined t he rent receipts register and issued receipts.
• Worked with the delivery persons from shipping companies such as UPS, FedEx, and USPS to accept, store, and track incoming package deliveries using TekTrak tracking software.
• Helped residents wi t h t he move-in process on Move-In days for Fall and Spring 2014 semesters .
• Conducted move-out procedures upo n resident move-out, including the inspection of the residences for damages.
• Conducted regular inspections o f p r o per t ies t o no te violations of fire or health code, other lease violations, and maintenance requirements for common areas.

Team Lead/Supervisor

Responsibilities:

• Managed a team of employees to upkeep the daily functions of the Dining Hall.
• Trained t e a m mem b ers on the various tasks associated with the maintenance of the front-end of the Dining Hall.
• Created daily sales reports and analyses used for forecasting sales and creating general ledger reports.
• Monitored the cash register a n d t he Meal Swipe Program (Prepaid Meals and Passes).
• Coordinated the maintenance of inventory and stock levels in the dining hall with the Head Chef.
• Reviewed new dishes a n d p r ovided feedback to the cooking staff.
• Stocked and m a in ta ined t he self-service salad bar, sandwich station, soupstation, breakfast station, and hot and cold beverages area.