Highlights

• An enthusiastic individual with more than 5.2+ years of experience in Oracle fusion middleware, ODI, OBIEE, PLSQL, and a strong understanding of Data Warehousing concepts. Looking for a challenging role in a reputable organization to utilize my skills for the growth of the organization as well as to enhance my knowledge.


• I have more than 5.2 years of experience in working with Oracle Business Intelligence Applications.


• Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.


• Expertise in ODI and ETL loads.


• Worked on ODI Designer to create Interfaces, procedures, packages, and Scenarios to extract the data from different sources, cleaned, and loaded into the target.


• Design, Development, and Documentation of the ETL strategy to populate the Data Warehouse from the various source systems.


• Worked in extracting data from Oracle EBS, OLTP, flat files, and integration and loading data to OLAP system.


• Worked on the different ETL tools(primarily in ODI )to create Interfaces and Mappings.


• Working Knowledge of different ODI tools like Designer, Operator, Security, and Topology.


• Extensively worked on ODI production support.


• Worked on ODI Load Plan level, scheduling load plans, and Monitoring.


• Export/Import interfaces, packages, and their scenarios across different environments.


• Experience in customizing OBIEE dashboards and reports.


• Created prompts, Ad Hoc reports, and customized reports.


• Developed various dashboards and reports for Inventory Analysis according to business requirements to enhance better decision-making processes.


• Worked on Informatica Data Warehouse Admin Console (DAC).


• Worked on the different SOA NPDS to create new environments eg.SIT EIS, SANDBOX, etc according to the user’s requirements.


• Working experience in performing different Interface testing.


• Enthusiastic team player.

Skills

Primary Skills

ETL

ODI tools

PL/SQL

Secondary Skills

Data Integration

SQL

Projects

ODI/OBIEE Developer (21 months)

• Project/Client: EXPRESS SCRIPT ESI Corporation


• Team Size: 5


• Domain: Pharma Company






Description: Express Scripts Holding Company is a pharmacy benefit management organization. In 2017 it was the 22nd-largest company in the United States by total revenue as well as the largest pharmacy benefit management organization in the United States. Express Scripts had 2016 revenues of $100.752 billion






• Technologies Used: ODI 11g/12c, OBIEE 12c Admin Tool, OBIEE 12c, SQL Developer 4, WinSCP Roles and






Responsibilities in this project:






• Analyzed Functional & technical design documents.


• Created custom OBIEE reports based on the client's business user requirements and built validation scripts for the same.


• Developed intuitive and user-friendly Dashboards by appropriately including guided navigational links, prompts, and drill-downs.


• Involved in unit testing, and integration testing of the reports generated by OBIEE.


• Designed, developed, and checked the functionalities of ETL tools.


• Directly communicated to the client.

Technical Consultant - Business Intelligence (4 months)

• Project/Client: HNI Corporation


• Team Size: 4


• Domain: Office Furniture Manufacturers






Description: HNI Corporation is one of the largest office furniture manufacturers in the world in regard to revenues resulting from office segment sales. HNI is also the world's leading hearth products company, manufacturing and marketing gas, electric, wood, and biomass-burning fireplaces, inserts, stoves, facings, and accessories.






• Technologies Used: Data Warehouse Administration Console, OBIEE 12c Admin Tool, OBIEE 11g and later migrated to 12c, SQL Developer 4, WinSCP.






Roles and Responsibilities in this project:






• Created DAC execution plans.


• Ensured OOTB reports rendered data without any issues.


• Created custom OBIEE reports based on the client's business user requirements and built validation scripts for the same.


• Interacted with clients to understand the requirements.


• Prepared unit test case documents, handed over documents, and provided a demo to the client IT team explaining the functionality of various features of OBIA and the functionality of the Dashboard designed.


• Responsible for the maintenance of operational standards and Data Warehousing requirements.


• Designed, developed, and checked the functionalities of ETL tools.


• Good experience in monitoring loads and determining the reason for delay and failure.

ETL/OBIEE developer (3 months)

• Project/Client: Children’s MN


• Team Size: 6


• Domain: Nursing






Description: Children's Minnesota is one of the largest free-standing pediatric health systems in the US and provides health care for the most amazing kids on earth.






• Technologies Used: OBIEE, Data Stage ETL, Data warehouse table access, Peoplesoft HR (for data extraction only), Taleo (for data extraction only) Roles and






Responsibilities in this project:






• Developed a dashboard for nursing in OBIEE.


• Set up and configure authentication for OBIEE leveraging Active Directory


• Set up, configure, and implement object and data level security:


• Object level – who can see which dashboards


• Data level – who can see specific data on dashboards.


• Modify the existing feed into the mini data warehouse for PeopleSoft HR as needed for Nursing dashboard requirements.


• Fix the organizational hierarchy that already exists in OBIEE to support security and reporting requirements, including drill-down.


• Created a dashboard that will support drill down to additional detail.


• Executed UAT prior to migrating to production.

ODI, ETL/SOA Developer (14 months)

• Project/Client: ADM


• Team Size: 10


• Domain: Food Processing






Description: The Archer-Daniels-Midland Company, commonly known as ADM, is an American multinational food processing and commodities trading corporation founded in 1902 and headquartered in Chicago, Illinois. The company operates more than 270 plants and 420 crop procurement facilities worldwide, where cereal grains and oilseeds are processed into products used in food, beverage, nutraceutical, industrial, and animal feed markets worldwide.ADM ranked No. 54 in the 2020 Fortunelist of the largest United States corporations. The company also provides agricultural storage and transportation services. The American River Transportation Company along with ADM Trucking, Inc., are subsidiaries of ADM.






• Tools & Technologies Used: ODI 12c|Oracle fusion middleware 12.2.1.4|BPEL|OSB|Zena Scheduler|JDeveloper|WINSCP






Roles and Responsibilities in this project:






• Worked on the ODI Interface issues within SOA.


• Setting up meetings with the client regarding the requirements and analyzing the resources.


• Worked on the NPD level and gave required solutions within the given Timeline.


• Creating new UAT and SIT environments as per the Client’s requirement.


• MAXIMO Upgrade testing and documenting the results of the Integration.


• Experienced working with SQL, File Adapters, Zena Scheduler, SOA|OSB console, and resources.


• Experienced in Doing the configuration of different resources creating releases and doing the deployment in different test Environments.


• Developed several Interfaces with Transformation logic like Filters, Joins, Lookups, Sets, Aggregate, Expression, etc.

ODI Data Engineer (10 months)

• Project/Client: Emerson


• Team Size: 15


• Domain: Industrial Machinery Manufacturing






Description: Emerson is the global technology, software, and engineering powerhouse driving innovation that makes the world healthier, safer, smarter, and more sustainable. Emerson Automation Solutions is a leader in helping process, hybrid & discrete manufacturers automate and optimize production processes through best-in-class technologies and industry expertise. Emerson has the most complete automation portfolio in the industry with the depth of services to back it up.






• Tools & Technologies Used: ODI 11g|ODI 12c|TOAD|SQL DEVELOPER|DevOps|WINSCP






Roles and Responsibilities in this project:






• Used ODI Designer to develop complex interfaces to load the data from the various sources into dimensions and facts.


• Worked on the Production Support.


• Monitoring daily Load Plans and performing prompt actions.


• Scheduling and Unscheduling of Load Plans.


• Rectifying the Production issue within MLP(main load plan).


• Using ODI Operator for debugging and viewing the execution details of interfaces, packages, and Load Plans.


• Worked on ODI 11g to 12c Migration.


• Comprehensively used Normal Join, Full Outer Join, Left Outer Join, Right Outer Join, and Inner Join in the Joiner Transformation.


• Done changes at the Model level.


• Reversed engineered source and target models.


• Working knowledge of Various Knowledge Modules (KM) like LKM, IKM, CKM, etc.


• Doing Code comparisons between 11G and 12C mappings and making the required changes.


• Creating Package, Load plans, and procedures in Stage Env according to the requirements and migrating that to Production Env

Sr. ODI Developer ( DWH Tech Analyst ) (6 months)

• Project/Client: AU Bank


• Team Size: 20


• Domain: Banking






Roles and Responsibilities in this project:






• Worked on Project Shakti to take data from multiple flat flies and push data to multiple downstream like D2k and NPA.


• Done end-to-end implementation to read data from source and create packages and procedures for the same.


• Migrated tagit app data to the cloud.


• Converted Oracle code to MySQL code.


• Enhancement of tables as per requirement.


• Fetching data from Oracle DB.


• Developed logic to get data according to user’s request.

Awards

• Received various appreciations from clients as well as from the Onsite Lead on multiple occasions.