SUMMARY

• 12 + years of IT experience on analysis, design, development, customization and maintenance of various business applications in an effective way to deliver business solutions.
• Good knowledge on Data Integration/Integrator/Business Intelligence methodologies along with the Strong domain skills and experienced IT project lifecycle in entertainment and banking environments as Dell Boomi middleware, ETL Developer and Business Intelligence Report Developer.
• Expertise in Data Integration (Dell Boomi), Integrator (Informatica 9.0.1 Hot Fix2, ODI 11.1.1.9.0 , DataStage 11.1.1.7), Scheduling tools (Autosys and DAC.), Business Intelligence (Power BI, OBIEE 12c, BI Publisher, Tableau).
• Experience in Designing and Developing data integrations with Cloud based data sources such as Salesforce, SAP SuccessFactors to Azure SQL, SQL Server to Elasticsearch, Lynx to Salesforce, Excel Files to database in Dell Boomi and many more.
• Experience in Dell Boomi integration with Boomi API Management, SOAP and RESTful web service and SAP.
• Expertise Document cache, Map components, Process properties and Dynamic Process properties by using Dell Boomi.
• Worked with big clients like Confidential Theatre Support Center, Bank of America, SunTrust Bank, British Telecom with respective domains like Theatre entertainment Banking, Telecom, Mortgage and Health care.
• Responsibility includes involvement in gathering business requirements, analysis, design, data modeling, development, which include in designing ETL Process, building and configuring repository.
• Complete Life Cycle (Gathering Business Requirements, GAPS Analysis, identifying & analyzing the source/feeder systems, Design & Data Modeling, Data Integration, Development, and Testing) Production implementation experience of Enterprise Business Intelligence (EBI) using Oracle BI.
• Implemented Business Intelligence securities on Object Level security for the objects like Dashboards and Reports, and Data Level Security using BI Session Variables.
• Rewriting all the OBIAPPS code into DataStage11.7 .1.0. as a subject matrix expert, led the team into the correct approach and successfully completed some phases. Worked closely with Architects and DA’s, QA’s team on deliverables .
• Configured LDAP security in BI Console for the newly created provider as per as the business rules.
• Played a major role in upgrading from OBIA Apps and manually migrated all custom Informatica mapping to ODI interfaces and created scenarios and ran the load plans.
• Developing dynamic and interactive Dashboards with drill - down drill-across capabilities, and Web Catalog using Business Intelligence Tool.
• Interacted with Business Analyst to understand the business requirements and designed the ETL Mapping specifications for ETL Mappings of Data warehouse and integrated by using Dell Boomi with other various systems.
• Designed many Multi Source Single Target mappings and vice versa. Developed transformation logic and designed various Complex Mappings by using ETL tools.
• Experienced with designing ETL execution plans and scheduling tasks using DAC.
• Improved the advanced concepts of concurrent running of the workflow, session level partitioning techniques and pushdown optimization in ETL mappings.
• Good at prioritizing along critical paths, meeting project milestones and deliverable dates.
• Active participation in Presentation of Project concept, status, plans and progress
• Excellent interpersonal and communication skills and is experienced in working with senior level managers and developers across multiple disciplines.

TECHNICAL SKILLS

Middleware Tool: Dell Boomi

ETL Tool: Informatica 9.0.1 HotFix2, DataStage 11.7.1.0, ODI 11.1.1.9.0

ETL Scheduling tool: Autosys, DAC 10.1.3.3.1 , ODI agents

Reporting Tool: Power BI, Tableau 9.0 Desktop and Server,OBIEE12c/11g/10g, BI Publisher, EBS, OBIEE Apps (7.9.6.3/ 11.1.1.10.1 )

Databases: Oracle 12C/11g/10g, DB2, flat files, Oracle EBS 11i/R12.

Languages: Python, SQL, PL/SQL and Unix Shell Scripting.

Operating Systems: Windows,UNIX

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Consultant

Responsibilities:

• Tracking Production Issues, SIT Defects, UAT Defects in Quality Center and Fixing, deploying the changes in all the environments with very less time.
• Responsibility includes involvement in gathering business requirements, analysis, design, data modeling, development, which include in designing ETL Process, building and configuring repository.
• Worked with Cloud based data sources such as Salesforce, SAP SuccessFactors to Azure SQL, SQL Server to Elasticsearch, Lynx to Salesforce, Excel Files to database in Dell Boomi and many more.
• Worked extensively on cloud application connector Amazon, Azure,Saleforce and File Transfer connectors like SFTP, Disk, FTP Connector.
• Involved in Dell Boomi integration with Boomi API Management, SOAP and RESTful web service and SAP.
• Involved in creating a framework for error handling, mail formatting.
• Participate in cross-functional team meetings both internal and customer facing.
• Involved in the Project design phase, mapping customer requirements, continuing with configuration, testing and implementation of various modules till supporting the end users in various modules.
• Work closely with the project team to ensure the customer’s successful deployment.
• Provide support in BI architecture of the organization through database design, modeling and implementation
• Anticipate the end-to-end scope of analytical need of the client and design valuable Dell Boomi, BI and ETL solutions accordingly
• Use the best practices of Dell Boomi, business intelligence to design the analytical solutions
• Involve in unit and system testing to maintain the flow and relevancy of the solution
• Understand the future requirements and model concepts of the project
• Maintain and update a unique data storage facility to avail data back-up, recovery and archive
• Learn new business processes of Dell Boomi, ETL and BI Reporting solutions to apply them in the projects
• Train team members on BI Reporting, ETL and OLAP concepts, new techniques and methodologies
• Requirement gathering from stakeholders and prepared documentation for all data and reporting development.
• Communicates objectives and approaches with business and technical team members.
• Design Enterprise and consumer DW structure for an Confidential organizations and HR, Project Allocation & Budget data reporting in Oracle BI Application.
• BI Administration (Weblogic, Enterprise Manager, RPD & Webcatalog)
• Designed & developed star schema & object level security to facilitate the functionality.
• Involving in gathering business requirements, analysis, design, data modeling, development, which include in designing ETL Process, building and configuring repository.
• Rewriting all the OBIAPPS ETL code into DataStage11.7 .1.0. As a subject matrix expert, leaded the team into correct approach and successfully completed some phases. Worked closely with Architects and DA’s, QA’s team on deliverables.
• Involved in the installation, configuration. customization and extension of OBIEE, OBIA, ODI Financial, Procurement, Spend Analytics Project Analytics.
• Designed server architecture for the upgrade as per Oracle recommendation and Installed OBIA 11.1.1.10.3 , OBIEE 11.1.1.9.0 and ODI 11.1.1.9.0 on one sever and applied platform patches and installed OBIEE 12 C on the second server.
• Involved in the configuration by running the Configapps.sh and Config.sh for the OBIA, OBIEE, and ODI.
• Manually migrated all custom Informatica mapping to ODI interfaces and created scenarios and ran the load plans.
• Involved in creating the Master Repository and Work Repository for ODI 11.1.1.9.0 .
• In Topology layer involved in creating the Data Servers, physical server the Physical architecture, Logical architecture schema and Context in ODI 11.1.1.9.0 .
• Setup the Model for the source database and target database and loading the required Data Store by using Reverse Engineering Modules in ODI 11.1.1.9.0 .
• Created scenarios for the Interfaces, Packages, Procedures and Variables and used these scenarios in the load plan in the Topology to schedule the Agents.
• Hands on experience in developing procedures, Packages, interfaces and workflows in ODI.
• Excellent knowledge on the ODI all Knowledge Modules and modified some of Knowledge Modules for auditing purposes.
• Migrating the dev code to by using export methodology and successfully deploying into higher environments
• Performed Three-Way-Merge to embedding the new functionally of RPD
• Building Metadata Repositories (.rpd) Building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool with the new version of the OBIEE and with new techniques.
• DAC changes implementing based on the business requirements.
• Participating in Business Requirement Documents review, HLD, LLD and Data Model reviews to understand the requirements and to prepare the necessary design documents accurate. Participated in GAP analysis, Impact Analysis.
• Developing dynamic and interactive Dashboards with drill-down drill-across capabilities, and Web Catalog using Oracle Business Intelligence Tool.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series & Caching.
• Configured the Multi User Environment on Shared environment and deploying the code from UAT environment to Production environment.
• Configured the Dynamic, System and Non-System Variables according the Confidential security set up.
• Creating and Implementing the BI Publisher to report with real time data for financial users.
• Implemented Data Level and Object Level Security for Confidential and Odeon(UK) users
• Interacting with Business Analyst to understand the business requirements and also designed the ETL Mapping specifications for ETL Mappings of Data warehouse.
• Working with Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager to build the Oracle database for the Reporting
• Designed many Multi Source Single Target mappings and vice versa.
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Informatica Designer tool.
• Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, java and Expression Transformations.
• Effectively developed and tested the type1, type2 (Slowly Changing Dimensions) mappings.
• Improved the advanced concepts of concurrent running of the workflow, session level partitioning techniques and pushdown optimization in ETL mappings.
• Performed the Performance tuning to the ETL code at the Database, Mapping, Session and workflow levels.
• Great at organizing along the basic way, meeting venture achievements, and deliverable dates.
• Designed ETL strategy for various applications in the banking line of business.
• Active participation in Presentation of Project concept, status, plans and progress
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.

Confidential, Ashburn VA

Senior Software Consultant

Responsibilities:

• Responsibility includes involvement in gathering business requirements, analysis, design, data modeling, development, which include in designing ETL Process, building and configuring repository.
• Gathering Business Requirements, GAPS Analysis, identifying & analyzing the source/feeder systems, Design & Data Modeling, Development and Testing and implementation of Business Intelligence (EBI) using Oracle BI.
• Involved in the installation, configuration. customization and extension of OBIEE, OBIA, ODI Financial, Procurement, Spend Analytics Project Analytics.
• Played major role in upgrading from OBIA 7.9.6.4 to OBIA 11.1.1.10.1 , OBIEE 11.1.1.6.12 to OBIEE 12C and ODI 11.1.1.10.1
• Designed server architecture for the upgrade as per Oracle recommendation for the above versions
• Installed OBIA 11.1.1.10.1 , OBIEE 11.1.1.9.0 and ODI 11.1.19.0 on one sever and applied platform patches and installed OBIEE 12 C on the second server.
• Involved in the configuration by running the Configapps.sh and Config.sh for the OBIA, OBIEE, and ODI.
• Manually migrated all custom Informatica mapping to ODI interfaces and created scenarios and ran the load plans.
• Involved in creating Master Repository and Work Repository for ODI 11.1.1.9.0 .
• In Topology layer involved in creating the Data Servers, physical server the Physical architecture, Logical architecture schema and Context in ODI 11.1.1.9.0 .
• Setup the Model for the source database and target database and loading the required Data Store by using Reverse Engineering Modules in ODI 11.1.1.9.0 .
• Created scenarios for the Interfaces, Packages, Procedures and Variables and used these scenarios in the load plan in the Topology to schedule the Agents.
• Hands on experience in developing procedures, Packages, interfaces and workflows in ODI.
• Excellent knowledge on the ODI Knowledge Modules such as LKM, IKM, CKM, JKM,RKM
• Performed Three-Way-Merge to embedding the new functionally of RPD which comes with OBIA 11.1.1.10.1 with our custom RPD (OBIEE 11.1.1.6.12 ).
• Building Metadata Repositories (.rpd) Building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool with the new version of the OBIEE and with new techniques.
• DAC changes implementing based on the business requirements.
• Participating in Business Requirement Documents review, HLD, LLD and Data Model reviews to understand the requirements and to prepare the necessary design documents accurate. Participated in GAP analysis, Impact Analysis.
• Developing dynamic and interactive Dashboards with drill-down drill-across capabilities, and Web Catalog using Oracle Business Intelligence Tool.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series & Caching.
• Configured the Multi User Environment on Shared environment and deploying the code from UAT environment to Production environment.
• Configured the Dynamic, System and Non-System Variables according the Loudoun Country security set up.
• Creating and Implementing the BI Publisher to report with real time data for financial users.
• Implemented Data Level and Object Level Security using External Table Authentication, as well as Presentation Services for LCPS and GOV users for the Confidential .
• Interacting with Business Analyst to understand the business requirements and also designed the ETL Mapping specifications for ETL Mappings of Data warehouse.
• Working with Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager to build the Oracle database for the Reporting
• Designed many Multi Source Single Target mappings and vice versa.
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Informatica Designer tool.
• Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, java and Expression Transformations.
• Effectively developed and tested the type1, type2 (Slowly Changing Dimensions) mappings.
• Experienced with designing ETL execution plan and scheduling task using DAC.
• Experienced with automation of ETL workflows with Autosys command line tools and GUI iXP tools and experienced FTP protocols in UNIX environment.
• Improved the advanced concepts of concurrent running of the workflow, session level partitioning techniques and pushdown optimization in ETL mappings.
• Performed the Performance tuning to the ETL code at the Database, Mapping, Session and workflow levels.
• Designed ETL strategy for various applications in the banking line of business.
• Good at prioritizing along critical path, meeting project milestones and deliverable dates.
• Active participation in Presentation of Project concept, status, plans and progress
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.