SUMMARY

• More than 15 years of IT experience in complete Software Development Life Cycle and Agile Methodologies including Requirement Analysis, Design, Development, Customization, Data Modeling, Gap Analysis Testing, Documentation and Maintenance of Data Warehouse / Data Marts and Business Intelligence.
• Excellent skills in OLAP/BI Tools - OBIEE/Siebel Analytics, SSIS, SSRS, Business Intelligence Cloud Services (BICS), Tableau, BI Publisher, ODI, Informatica and DAC
• Strong understanding of Business Logic, Business Process flows and Business opportunities.
• Implemented ETL logic for Oracle DB using ODI by building Packages, Procedures and Interfaces.
• Expert in design, development and implementation of ELT code.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inmon) - Star Schema, Snowflake schema, Slowly Changing Dimensions (SCD), Surrogate keys, Normalization/De-normalization..etc.
• Expertise in implementing complex business rules by creating ODI interfaces.
• Extensively used Integration Knowledge modules (IKM) to efficiently transformed data from staging area to the target tables by generating the optimized native SQL
• Very good experience on all ODI components - Topology, Security Manager, Designer and Operator.
• Extensive experience in writing complex SQL Queries and PL/SQL, T-SQL scripts
• Scheduled ETL jobs through ODI-Agents, successfully implemented Load Balancing Concept on the production servers.
• Experience in designing Dimensional Modeling, Creating Relational Database, Data warehouse solutions and understanding Entity Relationship Diagram on several databases and reporting systems.
• Experience in Setting up Dynamic, System and Non-System Variables. Excellent interpersonal and communication skills for efficient client interaction.
• Experience in Business requirements gathering, Define and capture metadata for business rules, creating Physical Infrastructure, System Analysis, Design, Development and User Training associated with the ETL processes.
• Expertise in designing & developing Oracle BI Repository (.rpd), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Expertise in Performance Tuning, Debugging, and Optimizing Analytics Dashboards / Reports and Data Warehouse database.
• Performed all version upgrades, patch upgrades (from OBIEE 10g to 11g, 11g to 12c), run database scripts, user administration and managing monthly release of upgrades.
• Managed projects in a timely manner, ensuring accuracy and that deliverables were met.
• Experience in integrating and configuring industry specific OBIA(Oracle Business Intelligence Applications) for modules Marketing, Sales, Customer Service, Financial Analytics

TECHNICAL SKILLS

OLAP: OBIEE / Siebel Analytics, Microsoft Power BI, Oracle Business Intelligence Cloud Services (BICS), Tibco Spotfire, BO XI, Jasper Report Server/Studio, Pentaho, Essbase, SSAS, SSRS and Tableau

ETL: ODI, Informatica, SSIS, Data Stage

CRM/ERP-Apps: Siebel 8.1, EBS 10.x/11.x, JDE

Data Modeling Tools: Erwin 7.3, MS Visio

Scheduling: DAC, Data Sync

Databases: Oracle 8i/9i/10g/11g, SQL Server, DB2, Teradata

Operating Systems: MS-DOS, Windows family, UNIX (HP, Sun Solaris), Linux

Scripting: Python

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Complex projects of Journalizing/CDC (Near Real Time Extract, Simple and Consistent Mode).
• Developed packages by using ODI interfaces, procedures, variables alongside working on all three layers of the OBIEE repository to facilitate end user reporting.
• Implemented Oracle data integrator static control for data cleansing, data validation, data transformation for the data in designer's model folder.
• Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary.
• Use of Golden Gate and Journalizing interfaces to populate data from OLTP system to Data Marts.
• Created interfaces, Procedures and Packages, generated scenarios using Oracle Data Integrator Designer.
• Created the Load plans and specified exception behavior and exception step to the load plan scenarios.
• Oracle Data Integrator topology manger administrative tasks.
• Customized LKM and IKM knowledge modules for better performance of interfaces.
• Heavily using J$ tables to keep in sync with the Source data
• Performance Tuning of ETL jobs by providing appropriate knowledge modules.
• Ability to modify the knowledge modules as per the requirement.
• Perform unit testing at various levels of the ETL.
• Worked on the OBIEE Repository and created the required reports

Environment: ODI 12c, OBIEE 11g, OBIA, Oracle PL/SQL, Golden Gate, Teradata, SSIS

Confidential

Sr. Analytics Consultant

Responsibilities:

• Working with client teams in gathering the requirements and delivered the content
• Loading the data from Source to Cloud Service (Schema as a Service SaaS) and load the data into DWH table by using the Stored Procedures
• Developing/Architecting the Oracle Business Intelligence Cloud Service
• Customizations to the out of the box OBIEE and ODI Repositories
• Installing ODI and configuring ODI Master and Work Repositories
• Created ODI Agent and configured it for automating the jobs through the ODI.
• Creating/customizing the ODI Interfaces/scenarios to reach the client requirements
• Developed ODI interfaces for loading the dimensions and facts.
• Creating the Packages in SSIS and creating the cubes by using SSAS and creating the reports by using SSRS
• Extensively worked withSSIStool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split,Lookup, Aggregator,Multicastand Derived Column.
• DevelopedSSISTemplates, which can be used to developSSISPackages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Designed SSIS Packages to transfer data from various sources like Excel, DB2, Flat files to SQL Server 2012
• Implemented complicated transformations to be used in SSIS packages.
• Scheduled Jobs for executing the SSIS packages which were developed to update the Database on Hourly/Daily basis
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Converting the Cognos decision streaming data warehouse into SSIS mappings
• Take data from EBS source system and load into DWH without using any of the ETL tools but using the PL-SQL scripts (Packages).
• Installed, configured and Implemented OBIA 11.1.1.8.1 with Enterprise setup on Windows Servers by using JDE Source
• Involved in developing the Accelerate Data warehouse for JDE source and selling it to the clients as a package
• Expertise in BI Publisher, Oracle BICS, SaaS and DBaaS.
• POC on Microsoft Power BI

Confidential, DC

OBIEE Architect

Responsibilities:

• Installed, configured and Implemented OBIEE 11g with Enterprise setup on Windows Servers integrated with Active Directory.
• Lead the team in upgrading from OBIEE 10g to 11g.
• Customize out of the box Siebel OBIEE repository which includes creating new subject areas and redefining joins to improve performance for campaigns
• Maintain and Support DAC repository to include new Subject Areas, Task Groups, Tasks, Indexes and Tables as needed.
• Support and trouble shoot Execution plans that are run through DAC
• Design, develop and maintain mappings in Informatica for loading data into OBIEE data warehouse database
• Make changes to the OBIEE repository to support any new business requirements
• Gather report requirements from business users and translate OBIEE
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Responsible for monitoring jobs, handling tickets and new development of the project.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Extensively worked in fine-tuning of Informatica Mappings.
• Built the RPD against new Data Warehouse for the Case Management Analytics.
• As per the client requirement developed the reports in BI Publisher
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes in Repository & ETL.
• Configure the symbolic URLs and Action Links for 11g reports integration to Siebel Public sector application.
• Implemented security in OBIEE for data visibility (Data Level) and report visibly (Catalog Level) based on user responsibilities.
• Performance tuning databases both Siebel OLTP and data warehouse and developed a strategy by studying the execution plans and designing efficient indexes which helped in faster response times

Environment: OBIEE 11g/10g, DAC, Informatica 8.6, SQL Server, Windows

Confidential, Houston, TX

Tibco Spotfire Solution Architect

Responsibilities:

• Developed ODI interfaces for loading the dimensions and facts.
• Developed ODI Procedures and Packages an implemented the data integrity rules for the load.
• Created ODI Agent and configured it for automating the jobs through the ODI.
• Developed new ODI Package, interfaces, procedures and variables for Policy Monthly Snapshot.
• Installing and configuring the Tibco Spotfire, Web player Server and Automation server
• Understanding the requirements and complete the technical design
• Creating the Data Elements (Data Connections, Tables, Filters, Joins, Information Links)
• Creating the data tables by using the information links and Spread sheets
• Creating the spotfire templates by using the data tables with the different visualizations
• Proposing the visualizations to the client team and based on client comments modify the visualizations
• Creating the Automation Process (sending mails to users)
• Unit testing the Spotfire template
• Deploying the templates in different environments (QA and PROD)

Environment: Spotfire 4.5, Oracle, Windows

Confidential, Atlanta, GA

OBIEE Architect & Onsite Project Lead

Responsibilities:

• Manage multiple projects and review the designs, Technical Design Documents provided by different vendor teams and check for any deviations as per the Confidential OBIEE standards
• Installed, configured and Implemented OBIEE 11g on Windows Servers integrated with Active Directory.
• Involved in OBIEE Upgrade project (10g to 11g) in a consultant role sharing 11g implementation experience.
• Involved in POCs to show case OBIEE 11g capabilities to the business users.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Discover Design and Developed custom OLAP data model for overall project based on Retail and Marketing data.
• Responsible for effective communication with the client. Provide weekly project status to the client.
• Responsible for Cash managements and Metadata changes for improve the performance. Fix data visibilities issue.
• Responsible for preparing and sending the weekly utilization, status reports and detail plans to client team.
• While getting the new projects responsible to prepare the estimations and send it to client team.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Sharing the functional and Technical knowledge gained with the team.
• Preparing documents for deliverables like Unit test plans and results etc
• Translate customer requirements into formal requirements and design documents, establish specific solutions and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Organizing the UI in a format that is easy for end user to use as basis for reporting.
• Performing the unit testing and reviewing the test cases.

Environment: OBIEE 11g/10g, Informatica 8.6.1, Oracle 11g, Windows, Citrix, Erwin, HP Quality Center

Confidential

BI Lead Architect

Responsibilities:

• Analyze data model and requirements from an Application Architecture Repository and Framework standpoint.
• Responsible for creating a prototype of the application, created the Functional Requirements Document (FRD), and demo the prototype for sign off.
• Collaborate with business areas and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution.
• Analyzed the existing marketing system & successfully designed & implemented the OOB Marketing Analytics & Existing Legacy Marketing.
• Analyzed the existing Marketing System & Modeled the star schemas.
• Designed various indexes to improve the performance.
• Estimated work effort based on reporting requirements & developed plan to implement.
• Designed DAC Subject Areas, Execution plans load the data in to the data warehouse.
• Worked extensively with the pre-built OBI Applications & Custom Repositories
• Monitored the Project to make sure that project is running as per the plan.
• Utilize knowledge of functional and Technical experience in OBIEE in conjunction with industry and business skills to deliver solutions to customer.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes in Repository & ETL.
• Designed & Configured the DAC execution Plans.
• Designed, Configured & Published the reports from OBIEE with BI Publisher.
• Extensively worked in fine-tuning of Informatica Mappings.
• Design & Develop front-end, metadata and ETL specification to support business requirements for reporting across the organization.
• Responsible for the design, set up and maintenance of both Production and Non-Production environments.
• Troubleshoot Production issues, identify root cause and migrate fixes.
• Developed reporting standards and best practices to ensure data standardization and consistency.
• Perform data cleansing and data auditing as necessary to ensure data quality. Define and develop physical and logical data models to support departmental and functional reporting needs.
• Create, maintain, and manage documentation for all data warehouse and reporting development efforts.
• Help to create and implement a long-term storage and business continuity strategy including backup & recovery and data storage and archiving.

Environment: OBIEE 10x, OBIA 7.9.5, Informatica 7.1, Oracle 11g, Windows, Erwin, HP Quality Center

Confidential

Siebel Analytics Developer

Responsibilities:

• Gathering, Analyzing and identifying the Gap of Business Reports Requirements.
• Analyze data model and requirements from an Application Architecture Repository and Framework standpoint.
• Worked with the business users to identify their scorecard, dashboard and managed reporting needs.
• Responsible for Infrastructure setup, project estimations, scrum meetings.
• Modeled the schemas to match the requirements with Erwin.
• Modeled the dimensions & cubes to match the requirements.
• Collaborate with business areas and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution.
• Estimated work effort based on reporting requirements & developed plan to implement.
• Responsible for executing the DAC plan to load the data in to the data warehouse
• Also developed Informatica ETL customized mappings.
• Worked extensively with the prebuilt OBI Applications & Custom Repositories
• Designed & implemented the LDAP Security Authentication with OBI Applications.
• Identified & Designed the Weekly, Monthly & Yearly Reports & scheduled them with BI Delivers and iBots.
• Identified, Designed & Implemented Data Level & View Level Security.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.

Environment: Siebel Analytics 7.7, Informatica 7.1, Oracle 11g

Confidential

Siebel Analytics Developer

Responsibilities:

• Conducted business user interviews to gather the requirements.
• Involved in creation of Technical Design specification according to client requirements.
• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Identified and documented all gap and restrictions; make sound technical and tactical recommendation.
• Identified & Created Facts, Dimensions, and Hierarchies of the business model.
• Architected and implemented change data capture and slowly changing dimension design.
• Extensively used Siebel Analytics Administration Tool for Creating and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on Siebel Answers to create the reports as per the client requirements.
• Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard and modeled Slowly Changing dimension data.
• Created proactive agents (iBots) and interactive dashboards to alert the sales rep about the sales of the particular item.
• Maintained effectiveness in creating the dashboards by appropriately including drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.

Environment: Siebel Analytics 7.7, Informatica 6.1, DB2, Windows, HP Quality Center

Confidential

Siebel Analytics Developer

Responsibilities:

• Captured the business requirements, worked on gap analysis and prepared the gap analysis document.
• Identified and documented all gap and restrictions; make sound technical and tactical recommendation.
• Installed Analytics Development, Prototype, Test and Staging environments: Analytics Server, Data warehouse Application Console, Informatica Server and Informatica Repository Server.
• Installed & Configured Data warehouse Application Console.
• Configured analytics repository with logical dimensional modeling using star schema.
• Extensively used Siebel Analytics Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on Siebel Answers to create the reports as per the client requirements.
• Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard and modeled Slowly Changing dimension data.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Configured DAC and registered the custom workflows in DAC.
• Identified Facts, Dimensions, and Hierarchies of the business model.
• Enhanced & Developed Informatica mappings.
• Customized the SDE & SIL mappings to cater the requirements.
• Configured SOAP, Web services for inbound and outbound communication in Analytics
• Unit tested the mappings before including the developed sessions into the already existing batch.

Environment: Siebel Analytics 7.7

Confidential, NJ

Informatica Developer

Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Identified and documented all gap and restrictions; make sound technical and tactical recommendation.
• Identified & Created Facts and Dimensions
• Architected and implemented change data capture and slowly changing dimension design.
• Involved extracting data and transforming the data before loading the data into target (warehouse) Oracle tables
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
• Extensively worked on different transformations viz Source Qualifier, Expression Filter, Lookup, Update Strategy, Stored Procedure, Sequence Generator, Joiner, Router, Aggregator Transformation and SQL override.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Involved in designing & developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.
• Perform data cleansing and data auditing as necessary to ensure data quality. Define and develop physical and logical data models to support departmental and functional reporting needs.

Environment: Informatica 6.1, Oracle, Windows, HP Quality Center

Confidential

Informatica Developer

Responsibilities:

• Responsible for the data mappings from original source tables and columns to new target tables and columns with all associated Business Rules.
• Business Requirements gathering from all internal customers in facilitating the design phase of the fact and dimension tables for the new multidimensional data warehouse.
• Customized the SDE & SIL mappings to cater the requirements.
• Worked on creating SCD Mappings
• Worked on repository to create and manage user profiles.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Environment: Informatica 6.1, Oracle, Windows, HP Quality Center

Confidential

Responsibilities:

• Collecting and storing information from client
• Processing the information and issuing the invoice to the employee
• Generating reports from management.