Business Intelligence Data Warehousing

Nandakumar Manni Soundarrajan

Senior Oracle Business Intelligence Developer 920-***-****

*************@*****.***

Professional Summary:

Competent software professional having around 18 years of experience in IT and 14 years in Data Warehousing and Business Intelligence architecture, design, development, testing and performance tuning in ETL process and have good knowledge on implementing BI reports.

Experience in gathering, analyzing business requirements, Data Modelling and converting them into efficient technical solution for ETL and data reporting.

Skilled in RDBMS / Data warehousing and Business Intelligence (OLTP/OLAP) concepts, dimensional model (physical/logical) and wide experience with STAR schema.

Extensive experience in preparing High Level, Detailed Technical Design documents, Unit Test plans and writing SQL /PLSQL packages, procedures, functions.

Expertise in design, implement the complex business requirements to load ODS, EDW tables using Oracle Data Integrator (ODI) 12c/11g/10g, Load Plans and maintaining data quality.

Experience in creating the Master/work repository, Physical and Logical architecture in Topology Manager and User profiles in Security Manager.

Have strong experience in all ODI components, Knowledge Modules (KM), Change Data Capture (CDC), implementing Slowly Changing Dimension (SCD) and creating custom built Knowledge Modules as per business requirement and production support.

Have experience in creating OBIEE repository (Physical, BMM and Presentation Layer).

Have experience in designing and implementation of business-critical dashboards/reports from EDW using OBIEE 11g/10g and analyze reports for different subject areas.

Exposure to other ETL tools SQL Server Integration Services (SSIS), Informatica.

Initial experience in creating Worksheet/Dashboard using Data Visualization tool Tableau Desktop and publish in Tableau Server.

Manage team and provide guidance to subordinates for deliverable, self-development and experience in agile environment.

Technical Skills:

Hardware / Platforms

Windows, Unix

Technology/Practice

Data warehousing and Business Intelligence

Database/RDBMS

Oracle 12c/11g/10g, DB2, MS Access

ETL Tools

Oracle Data Integrator(ODI) 12c/11g/10g, Informatica, DataStage 8.7, SSIS

BI Tools

OBIEE 11g/12c, BIP

Programming Languages

SQL, PLSQL

ERP Exposure

EBS, Siebel, OTM

Other Utilities

CA WA, HP Service Manager, Toad, SQL Developer, MS Visio, JIRA, GIT, Autosys

Education:

Bachelor of Technology in Information Technology (Anna University) - Graduated in First Class

Project Details:

Employer: Tek Leaders Inc., Frisco Texas

Client: US Food and Drug Administration, Maryland Nov 2020 - Till Date

Role: ETL /BI Lead

Environment & Technologies: ODI 12c/11g, Oracle 12c, OBIEE 12c

Responsibilities:

•Design, development and implementation of the data extractions, transformations and load procedures including analysis of existing source systems and data stores.

•Develop the ETL mappings using various methodologies such as Oracle Data Integrator (ODI) an ELT/ETL tool, ODI procedures, Oracle SQL, PLSQL.

•Tune the performance of ETL mappings, procedures and make sure the data flow is smooth without causing data discrepancies.

•Providing Subject Matter expertise in OBIEE reporting with a focus on designing and developing business critical reports using the Answers capability.

•Providing service on Business process reengineering projects, testing and release management.

•Conduct peer reviews on the design, development phases of the project and make necessary corrections to maintain the data quality.

•Create structured process to analyze, test, validate and review the solutions implemented.

•Define and execute on a robust plan to ensure all client requirements are met, while pushing the team to continuously improve and streamline the data quality assurance/testing process.

•Evaluate and test software applications, compile data and produce relevant reports.

•Helping in business process, improving internal controls. Improve efficiency of operations, increase transparency and performance management, and comply with Federal laws and regulations.

Employer: Resolve Tech Solution Inc., Addison, Texas

Client: 7-Eleven Inc, Irving Tx Oct 2019 – Nov-2020

Role: ETL /BI Lead

Environment & Technologies: ODI 12c/11g, Oracle 12c, OBIEE 12c

Responsibilities:

•Understanding the business requirements and translating functional requirements into technical deliverables/solution.

•Design Oracle Data Integrator (ODI) ETL mappings and flows by interacting with the BI technical Lead, business analyst and other team members for the Data Warehousing/Business Intelligence applications.

•ETL development using tools including Oracle Data Integrator and Oracle SQL, PLSQL stored procedures. Analyze the BIApps flows and Data warehouse flows to find the root cause if business critical issues.

•Tune ETL and Oracle SQL processes and provide assessment/resolution of the performance issues.

•Automate the ETL flows using ODI that creates the outbound files/report extracts and delivers to internal and external servers through SFTP process.

•Develop OBIEE (Oracle BI Enterprise Edition) dashboard, analysis based on the business requirements and analyze the existing reports to fix the issues.

•Perform unit testing and document the various cases to make sure the application is in line with the requirements.

•Providing technical fixes for ongoing production issues and performing the impact analysis to find the root cause.

•Create deployment artifacts for migration of the solution on various environments following the stages of the project.

•Work towards SIT, UAT migration and QA testing support, Prod cut over and providing support during warranty phases of the projects and status updates to the management.

•Work closely with business users, technical architects, managers to discuss the data flow, design of ETL system and status of overall project implementation and maintenance.

Employer: Resolve Tech Solution Inc., Addison, Texas

Client: Essilor of America, Inc., Dallas Tx Oct 2017 – Oct 2019

Role: Senior Oracle Business Intelligence Developer

Environment & Technologies: ODI 12c, Oracle 12c, OBIEE 12c, BIP, Informatica

Responsibilities:

•Understanding the business requirements and translating functional requirements into technical deliverables/solution.

•Analyze the ETL mappings in Informatica and transform them into ODI as part of upgradation.

•Provided value-added data analysis for Sales, Finance, and Marketing organizations to resolve complex data gaps.

•Design Oracle Data Integrator (ODI) ETL mappings and flows by interacting with the BI technical Lead, business analyst and other team members for the Data Warehousing/Business Intelligence applications.

•ETL development using tools including Oracle Data Integrator, Informatica and Oracle SQL, PLSQL stored procedures.

•Tune ETL and Oracle SQL processes and provide assessment/resolution of the performance issues.

•Automate the ETL flows using ODI to get data from various sources such as Flat files, SQL Server, XML, Oracle EBS to load into OOTB and Data Warehouse. Also, ODI Packages create outbound files/report extracts and delivers to internal and external servers through SFTP process.

•Develop OBIEE (Oracle BI Enterprise Edition) dashboard, analysis based on the business requirements and analyze the existing reports to fix the issues.

•Develop and Enhance the OBIEE repository as per the reporting needs and assisting in migrating to new environments.

•Create BIP (Business Intelligence Publisher) reports that run on schedule and deliver the reports dynamically to various partner groups.

•Automate the existing OBIEE analysis to dynamic BI Publisher reports that leverages a single data model and RTF to be reused across multiple reports.

•Perform unit testing and document the various cases to make sure the application is in line with the requirements.

•Providing technical fixes for ongoing production issues and performing the impact analysis to find the root cause.

•Create deployment artifacts for migration of the solution on various environments following the stages of the project.

•Work towards SIT, UAT migration and QA testing support, Prod cut over and providing support during warranty phases of the projects.

•Provide documentation on all the above deliverables and status updates to the management.

•Serve as Technical SME for Business Leads throughout delivery. Work closely with Marketing, Finance, Supply Chain, ELOA, and other parties involved.

Employer: Resolve Tech Solution Inc., Addison, Texas

Client: The Michaels Stores Inc., Irving Tx Apr 2017 – Sep 2017

Role: DWBI Lead

Environment & Technologies: Oracle 11g, Netezza, DataStage 8.7/11.5

Responsibilities:

Gather the business requirements from customers and communicate/coordinate with source partners to get the necessary data.

Responsible for data profiling tasks, dimensional modelling and design data integration.

Liaison with cross functional teams for project scope and conducting POC’s wherever necessary to suggest the feasibility of achieving BI solutions.

Preparing the design document and ETL data mapping necessary for implementation.

Develop the ETL code using DataStage and Oracle SQL to implement the business functionalities.

Coordinate with multiple teams to resolve the ongoing critical issues.

Conducting peer reviews on design, coding, test case plans and data quality checks.

Perform unit testing and assisting with required details on UAT.

Preparing the support document to move the code to production environment and coordinate with Offshore on daily tasks.

Prioritize the ongoing activities and balance the workload with team to deliver the project in timely manner.

Employer: Resolve Tech Solution Inc., Addison, Texas

Client: Verizon Corporation, Irving Tx. Dec 2014 – Feb 2017

Role: ETL/BI Lead

Environment & Technologies: Oracle 11g/12c, SQL, ODI, OBIEE 11g / SSIS

Responsibilities:

Involved in analyzing requirements with business users and helping in the dimensional modelling for the OLAP system.

Impact analysis on the existing system and managing the dependencies across different teams, arriving level of effort for tasks.

Designing the ETL flows and creating high level and detailed technical design documents for the project.

Defining data servers - physical and logical schema for various sources in ODI topology manager.

Creating database objects like tables with necessary constraints, views, sequences and reverse engineer in ODI Designer (Model) to use in package/interface.

Reverse engineering the objects to use in source and target in interfaces.

Developing ETL mappings, creating package, interface to pull data from sources such as flat file, HANA SAP, Oracle, PeopleSoft and apply transformation rules in ODI designer.

Implementing the Data quality checks for ETL process using SQL scripts, PLSQL packages and procedures.

Developing reusable micro services in ODI that has Data Quality (DQ) validation process flow which is implemented in various critical packages.

Implemented Performance tuning techniques to optimize ODI ELT objects to reduce the execution time and scheduling using Autosys.

Helping in creating repository (.rpd) and developing the OBIEE dashboards, summary/drill thru interactive reports using aggregates, hierarchies, action links etc.

Testing the OBIEE dashboard reports against the functional requirements and root cause analysis, troubleshooting /fixing on the logic for any ongoing issues.

Involving in migration process, Production support for existing application and resolving the issues on timely manner.

Employer: Cognizant Technology Solutions Inc, USA

Client: L.A. Care Health Plans, Los Angeles, CA Apr 2014 – Nov 2014

Role: Senior Analyst/Lead

Environment & Technologies: Oracle PLSQL, SSIS, SQL server, OBIEE.

Responsibilities:

Responsible for gathering the requirements from SMEs.

Analyzing the impacts on various source systems for the data warehouse which are not capable of handling/processing the ICD-10 codes.

Creating Data Flow/Control Flow using SSIS.

Involved in integrating different Database Applications using SSIS packages.

Creating SSIS packages that involves migration from legacy systems to centralized Database.

Designed and tested packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion.

Creating OBIEE reports/dashboards for HR subject area for the organization.

Responsible for Functional & Technical Design for all the surround systems, reports used across the organization and other planned partners.

Consulting with customers and proposing the ideas to be implemented to make the system effective post ICD-10 compliant date.

Employer: Cognizant Technology Solutions Inc, USA

Client: Schneider National Inc., GreenBay, WI Aug 2010 – Mar 2014

Role: Senior Analyst

Environment & Technologies: SQL / PLSQL, Oracle Data Integrator 10.1/11 g, Informatica 9.1, OBIEE 10g, BIP.

Responsibilities:

As an onsite team member, involved in the requirement gathering from customer, analyze, defining KPIs and the dimensional modeling using ERWIN for OLAP DW.

Responsible for creating Technical Design for Business Intelligence/Data Warehousing spread across different subject areas.

Created physical schema, logical schema, data scheme, and context appropriate for ELT mappings in topology manager.

Developing the ETL flows to get data from Operational Data Store and loading it to data warehouse using the ELT tool Oracle Data Integrator with different Knowledge Modules. And developing Informatica mappings for legacy data warehouse.

Creating necessary ODI packages, Interfaces, variables to implement business requirements.

Extract data from different sources from Oracle EBS, OTM, Siebel tables and flat files and load into dimension and facts.

Involved in Performance tuning the SQL Queries and to ensuring all aspects of deliverable for Build/Code go through quality review and oversight of the process.

Review and ensure the documentation and configuration implemented are in sync with the changes in the Requirement, Design, and Code Changes.

Scheduling the ODI scenarios using CAWA for both ODS and data warehouse batch.

Creating OBIEE Repository (RPD) using physical, BMM and presentation layer.

Developing the OBIEE dashboards, summary/drill through interactive reports using aggregates, hierarchies, action links etc.

Testing the OBIEE dashboard reports against the functional requirements and root cause analysis, troubleshooting /fixing on the logic for any ongoing issues.

Involved in OBIEE administration and user level security on dashboards/reports.

Handling and Managing EIM Production Operation streams which include 24/7 EIM Production Support, Maintenance and Enhancements of ODI, Informatica mappings, OBIEE/BIP, Hyperion/Essbase and Cognos reports.

Developed a value-add application that helps is customer IT sector which saved the manual efforts and cost and consulting with clients on various such aspects.

Lead Onsite and Offshore teams to perform efficiently and to handle any challenges.

Dealing directly with customers for ongoing production issues and business requirements.

Consulting with customers on the entire change requests, proposing possible solutions with foreseeing the impact and implementing them.

Maintaining the HP Service manager tool to track the number of issues in existing requirements and preparing metrics to calculate the cost of project.

Client: VMware Inc. Feb 2009 – July 2010

Role: Senior Software Engineer

Environment & Technologies: Oracle Data Integrator, Informatica, SQL, HelpZilla

Responsibilities:

Gathering Requirements and translate them into a technical solution by creating source to target mappings.

Set up the Topology including physical architecture, logical architecture and context.

Responsible for configuration of Master and Work Repository on Oracle.

Creating new models for the data sources – flat files, Oracle and interface/package to load into target tables.

Creating PL/SQL stored procedures, functions and triggers.

Performance tuning the ODI interfaces.

Optimized the knowledge modules to improve the functionality of the process.

Performed unit and integration testing. Created various test scenarios to test the application.

Delivered the assignments before the deadlines.

Conducting code reviews and planned the knowledge transfer to client.

Handle various client issues and respond accordingly during ETL process.

Providing immediate solutions for production issues based on severity.

Routing the user’s technical issues to an appropriate group in Helpzilla.

Providing ad hoc reports to customers who give the history of scheduled jobs and time taken for ELT loads.

Client: TravelClick Inc. Mar 2008 - Dec 2008

Role: Programmer Analyst

Environment & Technologies : Oracle 9i, Java, Flash, JIRA

Responsibilities:

Involved in requirement analysis for media library.

Writing SQL for some business functionalities to integrate with Java.

Involved in regression testing for the entire application.

Written test cases for all functionality and UI specifications as per SLA.

Worked in JIRA for assigning the functional/UI bugs to developers.

Client: American International Group (AIG) Nov 2006 - Feb 2008

Role: Programmer Analyst

Environnent & Technologies : DB2-SQL, Java, Servlet, JSP and PVS.

Responsibilities:

Involved in understanding Risk Analysis System in insurance domain.

Providing business critical fixes in project using SQL and Core Java.

Delivering Ad hoc reporting which provides critical information to TPAs.

Primary person for Monthly Update module which updates the processed claim data in database.

Delivering monthly loss run reports based on TPAs requirement.

Providing some of the critical reports on time by understanding the requirements.

Contact this candidate