SUMMARY

• Results oriented, self - driven software professional with over 6 years of contribution in individual and leadership roles with experience in managing, design, modeling, development and testing of data warehouse and reporting solutions.
• Thorough understanding of system development Life Cycle (SDLC) experience from requirement analysis through Design, Development and Deployment of data warehouse and reporting solutions.
• Expert in developing and analyzing of data warehouse applications using OBIEE 10g/11g/12c, Informatica 8.x and 9.x, ODI 12c.
• Proficient in design and development of new Dashboards, data models and reports in OBIEE for end users as per business requirements., and involve in analysis, design, development, maintenance and migration.
• Expertise in gathering Business Requirements, GAP Analysis, Documentation.
• Experience in upgradation to OBIEE 12c from OBIEE 11g using Oracle BI Cloud
• Experience in Star Schema reporting model with confirmed and slowly changing dimensions, Fact, Metrics, and Conformed Dimensions.
• Well versed with Dimensional Modeling (Star and Snow flake) to build the Data warehouse developing and integrating data sources, Client/Server applications using ODI, Informatica, Oracle DB and Postgres DB.
• Experience in configuring, administering and managing the repository, creating complex reports and role based Analytics Intelligence Dashboards using OBIEE.
• Developed iBots/agents in OBIEE to automate report delivery, seed cache and provide alerts on Interactive Dashboards.
• Expert in building physical, logical and presentation layers in repository.
• Worked on various OBIEE features (i.e Security, cache, usage tracking, dimensional hierarchy, aggregation, Variables/Initialization Blocks configuration, content levels, externalization strings etc.).
• Experience in OBIEE administrator activities including Enterprise Manager, Weblogic Server and maintaining user life cycles.
• Experience in configuring single sign on(SSO) dashboards for multiple applications using SAML and Oracle Identity Management.
• Optimized the Solution using various performance tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations and memory parameters), Database tuning using Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions etc.)
• Strong experience in Extraction, Transformation, Loading (ETL) of data from various sources into target Data Warehouse and Data Marts using Informatica Power Center.
• Worked on Bulk data loading on Peoplesoft environments and involved to resolve the production issues.
• Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.
• Experience on Oracle Data Integrator Designer ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Experience in handling various data sources like flat files, XML files, Oracle database and postgresql database etc.
• Experience in using the data visualization tools like Visual Analyzer and Tableau.
• Gather and translate data and informational needs into reporting requirements and technical specifications, understanding data and process workflow interdependencies. Produce functional and technical specifications, use cases, workflow/process diagrams as applicable.
• Experience in communicating project status, deliverable progress, and risks and issues to stakeholders and leadership in a timely manner
• Experience in building collaborative internal and external relationships and align technical or functional solutions with business needs
• Identify, prioritize and drive projects for BI solutions from concept to user accessible capabilities in reporting and analysis.
• Experience in providing the development of BI-related service offerings to expand the company's product mix and to help provide more value to external partners and customers.
• Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS

BI Tools: OBIEE 10g/11g/12c, OBIA 11.x, Oracle BI Cloud 12c, Visual Analyzer, TableauBI Publisher, Enterprise Manager, Weblogic Server Console.

ETL Tools: ODI 12c, Informatica Powercenter 8.x, 9.x

Languages: sql, pl/sql, C, C++, HTML

ERP Systems: Oracle E-Business Suite, Peoplesoft, Confidential Life Sciences Cloud

Databases: Oracle 10g/11g/12c, Postgresql and My SQL.

Version Control: Clearcase, TortoiseSVN

Other Tools: MS Visio, Toad7.6/8.5, SQL-Developer, HP Quality Center, MS-Office, MS Project, AWS, Jira, HP PPM

PROFESSIONAL EXPERIENCE

Confidential, Berwyn, PA

Business Intelligence Application Lead

Responsibilities:

• Primary duties include designing, developing and support reporting and ETL applications in the Confidential Life Sciences Cloud product.
• Responsible for developing OBIEE reports and dashboards to provide insights into Study, Site clinical data milestones, Subject Enrollments, customer data analytics
• Implemented OBIEE BI Cloud upgradation from OBIEE 11g to OBIEE 12c.
• Implemented data migration from Oracle Cloud Server to Amazon AWS server using snowball client system.
• Worked on various OBIEE features (i.e Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, Variables/Initialization Blocks configuration, content levels, externalization strings etc.).
• Optimized the Solution using various performance tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations and memory parameters), Database tuning using Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions etc.)
• Worked on visual analyzer and tableau to create reports with combination of warehouse, XML and csv file data.
• Implemented SAML SSO in Weblogic server console and worked as Enterprise Manager Admin.
• Created and debugged ETL mappings, sessions, workflows and ran scheduled loads.
• Gather requirements from business users and transform them to technical data mapping specification outlining the road map for data warehouse design and development.
• Create release plans and coordinate with client team in the deployment/release activities when the specific deliverables are going into production
• Work with client on PT cycles and document the changes/code fixes that are implemented as per change requests.
• Work on Post Production Support(PPS), wherein I need to work on Incident management process and work with client team on an offshore onshore hand off model.
• Providing 24/7 support to critical reporting applications through successful in house and offshore team model. Participate in daily standup meetings with CIO, BI director and department heads.
• Provide metrics and recommendations to client for improvement, enhancement of the existing reporting and ETL applications.

Confidential, New York

Senior OBIA/ODI Developer

Responsibilities:

• Gathering requirements from business users and converting them to technical requirements using the data mapping documents which enable the team and business users to understand the reporting process.
• Lead multiple modules(Procure to Pay, HR and Payroll, Financial Reporting) independently.
• Contribute in requirement gathering and reviewing functional documents
• Creating technical document, Source to Target mapping documents and star schema.
• Design and develop new Dashboards, data models and reports in OBIEE for users as per business requirements.
• Modify existing code in OBIEE, BIP and ODI according to the change requests.
• Work with client on PT cycles and document the changes/code fixes that are implemented as per change requests.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Used ODI commands like ODIFile Move, odiFileAppend, odiFilecopy etc
• Implemented logic to archive the source files with date stamp affixed after the successful load.
• Create release plans and coordinate with client team in the deployment/release activities when the specific deliverables are going into production.
• Profiling of source data and to perform impact analysis of system for all change request and enhancements.
• Manage Offshore and Onshore project resources and coordinate the work between client team and offshore team.

Confidential, Pittsburgh, PA

OBIA/OBIEE Developer

Responsibilities:

• Worked on multiple modules(Asset Management, Production Orders, Shipments, Inventory, Invoice, Pricing) independently on both ETL and BI fronts.
• Contribute in requirement gathering and reviewing functional documents
• Creating technical document, Source to Target mapping documents and star schema.
• Design and develop new Dashboards, data models and reports in OBIEE for users as per business requirements.
• Design and develop new mappings, sessions and workflows in Informatica tool
• Modify existing code in OBIEE, ETL and DAC according to the change requests.
• Work with client on PT cycles and document the changes/code fixes that are implemented as per change requests.
• Create release plans and coordinate with client team in the deployment/release activities when the specific deliverables are going into production.
• Work on Post Production Support(PPS), where in I need to work on Incident management process and work with client team on an offshore onshore hand off model.
• Schedule Informatica tasks in DAC and do the Production load support. Design and develop metadata in DAC and fix the defects/issues and update the client management on the production loads daily.
• Perform reviews, performance testing and data validation of the new Objects (Informatica, OBIEE and DAC) developed for enhancements and changes to an existing Object(s).