SUMMARY:

• 7 years of Information Technology experience in System Design, Development and Maintenance in Business Intelligence area including Technical and Functional experience in Data Warehousing technologies involving ETL tool - Informatica Power Centre, MS SQL Server SSIS, BO Data Integrator and Reporting tools - Oracle OBIEE 11g, Business Objects, Cognos, Micro Strategy.
• Experience in designing Informatica Solutions around SDFC integrations and using WebService Components.
• Excellent in creating reports using Themes from Microsoft Store at MS Power BI Desktop and publishing in web version and Mobile.
• Developed Data Warehouse roadmap, strategy and architecture, enterprise data warehouse, ODS, dimensional data marts and end user reports.
• Experienced in different stage of ETL processes such as Extraction, Cleaning, Transformation and Loading using Informatica Power Center 9.6/9.5/9.1/8.6/7.1/6.2 (Repository Admin, Rep Manager, Designer, Workflow Manager & Workflow monitor), Siperian, Informatica Power Analyzer &Power Exchange, BO Data Integrator 11.5 (Designer, DI Repository Manager, DI Server Manager).
• Data Migration (from Oracle to salesforce.com) using Data loader &SQL Server.
• Integrated enterprise resource planning (ERP), customer relationship management (CRM) Salesforce.com.
• Supported different integrations of Salesforce with Apex APIs and Webservices.
• Extensively worked on developing Continuous Change Data (CDC).
• Experience in knowledge of APIs (REST/SOAP/Bulk etc.) and usage with ICS (Informatica Cloud Services)
• Experience in working in a cloud project delivery model, cloud automation solutions.
• Involved in Informatica Cloud (ICS & IICS ) development and Migration
• Experience in Oracle Business Intelligence Enterprise Edition (OBIEE) 12c/11g/10.1.3.3.x and Siebel Analytics 7.7.1/7.8.5/ IP 2015.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards with Map viewer/Big Maps/Google Maps, reports and three tier OBIEE architecture.
• Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL, Database designs Methodologies.
• Experienced in Integrating OBIEE with Hyperion Essbase 9.x and in developing RPD and reports against multidimensional databases.
• Experience in databases using Oracle 12c/11g/10g/9i/8i, IBM DB2 UDB 8.0/7.0, Teradata v2r12/v26, MSSQL Server 2012/2008/2005 , Sybase& MS Access.
• Developed code in Informatica to support the VLDB of over 80 TB.
• Experience in Data Modelling using data Modellers, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modelling.
• Experience in Integration of various data sources like Oracle, SQL Server, Sybase, Fixed Width and Delimited Flat Files, DB2, COBOL files, VSAM Files& XML Files.
• Exposure to Job scheduling tools like Autosys and Control-M.
• Experience on database development using SQL Scripts (DDL & DML), Materialized Views, Stored Procedures and Functions.
• Involved in Monthly/Daily production support duties as required.
• Good understanding of Project Life Cycle and gathering requirements for ETL Development.
• Experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy, Java Transformations and Re-usable transformations.
• Developed mappings for SCD (Type1/Type2/Type3) loads.
• Detailed knowledge in Data warehouse Application Console (DAC) and Informatica Servers.
• Designed Technical Documentation using AIM Methodologies (MD50, MD70, CV40 and CV70).
• Extensively worked on Shell scripts and used Bugster to track reporting errors.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in supporting the production system and handling day-to-day issues.
• Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios to enable the testing of system setups.

SKILL:

ETL Tools: Informatica Power Center 9.6/9.5.1/9.1/8.6/8.1/7.1/6.2 , SQL*Plus & SQL*Loader, MS SQL Server Integration Services (SSIS), BO Data Integrator, Informatica Cloud

Change Data Capture (CDC): Oracle Applications

Informatica PowerExchange: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Install Base, Fixed Assets, Cash ManagementPurchase Order, Advanced Pricing, Service Contracts, Purchasing, AOL, System Administrator.

Business Intelligence: Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.2.1/11.1.1. x/ 10.1.3.3.2 , OBIA Apps - Out of box applications - Financial Analytics, HR Analytics, AP, AR, Assets/Serialization data models, Procurement and Spend Analytics

Databases & Tools: Oracle EBS R12, Siebel CRM 8.x/ IP 2015

ERP: Oracle 12c/11g/10g/9i/8i/7.x, TOAD, SQL Navigator, SQL*PLUS, SQL* Loader,DB2, DataLoader, SQL Server Management Studio

Scripting Languages: Unix Shell scripts, K shell, C shell.

Web Applications: Salesforce.com, Informatica Data Services (IDS)

Languages: SQL, PL/SQL, JAVA, XML, C#, HTML, Javascript, Apex.

Operating System: Sun Solaris, Unix, Linux 6.6, Windows 7/2008/NT/XP/2000/98, Windows Server 2008 R2/ 2012, Exalytics

PROFESSIONAL EXPERIENCE:

Confidential, Oaks, PA

Till NowInformatica Developer

Responsibilities:

• Provide Technical Architecture and capacity requirements for the Common Development Environment for in accordance with the project requirement.
• Experience in designing Informatica Solutions around SDFC integrations and using WebService Components. Experience in Informatica Administration.
• Extensive experience in application integration using tools like Informatica Webservice Consumer, LDAP and Cloud Connector.
• Experience in knowledge of APIs (REST/SOAP/Bulk etc.) and usage with ICS (Informatica Cloud Services).
• Designed and Built OBIEE RPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs.), test and validate the model.
• Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer with Security settings using LDAP Authentication to setup groups, access and query privileges
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Utilized OBI reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, and Security. etc.).
• Used Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards by using Agents.
• Created Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).
• Created Database Report Layouts Using BI Publisher Desktop (Template Builder) in MS Word.
• Integrating OBIEE and BI Publisher and Scheduling BI Publisher reports and Created BI publisher reports based on various data sources.
• Experience in working in a cloud project delivery model, cloud automation solutions.
• Involved in Informatica Cloud (ICS & IICS ) development and Migration
• Data Migration (from Oracle to salesforce.com) using Data loader &SQL Server.
• Created the Webservice Client class, Wrapper classes for integration.
• Supported different integrations of Salesforce with APIs and Webservices.
• Experienced in Data Cleansing and mapping data from source to target salesforce.com.
• Created the Star Schema, loading Dimension and Facts Tables through Informatica.
• Implemented pipeline partitioning concepts like Hash-key, Round-Robin, Key-Range, Pass Through techniques in mapping transformations
• Implementing Slowly Changing Dimension (SCD type II) design for the Data Warehouse.
• Developing workflows, event waits, assignments, conditional flows and email and command tasks using Workflow manager.
• Perform Full Load and Incremental Load on schedule monthly basis to load the data into the target systems.
• Performance Tuning by identifying the bottlenecks at sources, targets, transformations and sessions.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Determine Extraction and Loading techniques from and to SAP, also from Non-SAP sources to SAP.
• Designed the mappings to satisfy the SAP business requirements and providing validation reports as specified by the Function team.
• Data extracted from Non-SAP sources like Oracle, Excel, and SQLServer, People soft, Lotus notes and XML, Flat Files.
• Transferred files from one server to another server by using FTP.
• Provides oversight of other ETL development activities and unit testing all objects and processes and performs find-tuning and UAT issue resolution.
• Help BI reporting developers with analyzing data source, designing, testing and implementing Analytics reports and dashboards.
• Assists in enforcement of project deadlines and schedules.
• Worked Onsite/Offshore model by coordinating daily status calls by assigning work to the team.

Environment: Informatica PowerExchange (CDC), TOAD, SAP R3, ABAP, OBIEE 11.1.1.9 (Consumer Sector), Informatica PowerCenter 9.6.x/9.5.1, Informatica Cloud, Data Virtualization, DAC 11g, MS SQL Server 2012 R2, Siebel CRM 2015, Interfaces, Informatica Support, Oracle Linux 6, Windows 2008 R2 Server, Unix Shell Scripting, WebLogic Server 12c/10.3.2, EM 12c/11g.

Confidential, Homedell NJ

Informatica Developer

Responsibilities:

• Worked closely with data modelers , business analysts and BI developers to understand requirements, to develop the ETL processes using Informatica PowerCenter .
• Quickly understands the business issues and data challenges of Manheim client business and industry.
• Identifies strengths and weaknesses in existing processes, suggests areas of improvement, and helps enhance existing ETL processes to meet evolving requirements.
• Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems.
• Multiple PowerExchange plug-ins in support of technical requirements, validate specifications , fix issues during testing , and helped QA team with the Unit Testing while migrate code into production.
• Involved in level 2 and level 3production support processes for resolution of ETL related issues in production.
• Develops data mapping and verify mapping and data.
• Help and facilitate the development of test cases for projects.
• Ensures issues are identified, tracked, reported on and resolved in a timely manner.
• Provides oversight of other ETL development activities and unit testing all objects and processes, and performs find-tuning and UAT issue resolution.
• Extensive experience in application integration using tools like Informatica Webservice Consumer.
• Data Migration (from Oracle to salesforce.com) using Data loader &SQL Server.
• Integrated professional services automation software (PSA) Netsuite/OpenAir accounting management, enterprise resource planning, customer relationship management (CRM) Salesforce.com.
• Prepared Design and Admin documents for migration and integration of organizations Legacy Systems to Salesforce.com.
• Supported different integrations of Salesforce with Apex APIs and Webservices.
• Written Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse
• Developed complex Informatica mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target table in efficient manner.
• Extensively worked on developing continuous Change Data (CDC) using Informatica PowerExchange .
• Developed Slowly Changing Dimension Mappings for Type 1 and Type 2.
• Tuned the mappings and ETL procedures both at mapping and session level for the better performance.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Assists in enforcement of project deadlines and schedules.
• Possesses understanding in the areas of application programming, database and system design.
• Identifies critical issues with ease.
• Experience working on Informatica Cloud Real Time (ICRT).
• Exhibits confidence and an extensive knowledge of emerging industry practices when solving business problems.
• Takes input from supervisor and appropriately and accurately applies comments/feedback.
• Seeks and participates in development opportunities above and beyond training.

Environment: Informatica PowerCenter 9.5.1, Power Exchange CDC 9.5.1, Informatica Cloud, Cloud Real Time (ICRT), SQL Developer, TOAD 11g, IBM iSeries DB2 or AS/400,Oracle 11gR2, SQL, PL/SQL,Integration with Salesforce(SDFC), Informatica Webservice Consumer, DataLoader, Salesforce,com, Visual force, Apex, Shell Scripting, Unit and System Testing.

Confidential, Homedell NJ

Informatica Developer

Responsibilities:

• Developed high level design and Low-level design documents and involved in Preparation of Business Requirements Document (BRD).
• Performed Data Profiling and Analysis of Source Systems; provide data exception reports showing critical violations of data/business rules. Assess Data quality & conformance issues between internal source systems and the newly acquired source systems. Determination of cleansing strategy based on the Data Quality Assessment.
• Extracted data from DB2 Mainframes, Cobol Copy books, DL1, XML, VSAM files, Sequential files to Teradata Data warehouse.
• PreparedSource to target mapping document, design of data standardization, de-duplication and Cleansing modules.
• Provide Technical Architecture and capacity requirements for the Common Development Environment for in accordance with the project requirement.
• Experience in designing Informatica Solutions around SDFC integrations and using Webservice Components.
• Experience in LDAP integration with Informatica.
• Experience in Informatica Administration.
• Created the Webservice Client class, Wrapper classes for integration.
• Prepared Design and Admin documents for migration and integration of organizations Legacy Systems to Salesforce.com.
• Worked on various salesforce.com standard objects like Accounts, Contacts, Cases, Leads, Campaigns, Reports and Dashboards.
• Used Informatica B2B data transformation to read unstructured and semi structured data and load them to the target.
• Created the Star Schema, loading Dimension and Facts Tables through Informatica.
• Worked on Control M agent to maintain the scheduling requirements for the project.
• Written Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse
• Developed complex Informatica mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target table in efficient manner.
• Extensively worked on developing Continuous Change Data (CDC).
• Developed Slowly Changing Dimension Mappings for Type 1 and Type 2.
• Tuned the mappings and ETL procedures both at mapping and session level for the better performance.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.

Environment: Informatica Power Center 9.5/9.0, Informatica B2B DT, Integration with Salesforce (SDFC) using Informatica, Informatica Web Service ConsumerLDAP, Oracle 11gR2, SQL, PL/SQL, Control M, AIX.

Confidential

Informatica/OBIEE Developer

Responsibilities:

• Designed Source to Target mappings from primarily Flat files and Oracle and Teradata using Informatica Power Center.
• Analyzed and recommended the creation of a staging area before building the Data Warehouse.
• Used the 3NF data model as a staging area for subsequent data cleansing with Informatica Data.
• Quality and integration and delivery to the target system with Informatica Power Center.
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading.
• Developed transformations to implement complex business logic.
• Worked on Connected and Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, XML, Sequence Generator, etc.
• Implemented SCD - I, SCD-II and created staging tables to do validations against data before loading data into original fact and dimension tables.
• Updated the mapping logic according to changes in the requirements.
• Wrote a number of stored procedures to validate the complex mappings and automated the validation process.
• Used PMCMD and UNIX Shell Scripts for automating Batches and Sessions
• Used Workflow Manager to schedule and run batches, sessions and to check session logs and other session related activities.
• Involved in unit testing entire process flow.
• Loaded filtered data into Teradata as target using fast load connection and multiload connection using Informatica.
• Shared the development effort to design the audit control mechanism to track defects.
• Developed the OBIEE repository definition (physical layer, bmm layer and presentation layer) file using OBIEE Admin tool.
• Designed dashboard pages like Overview, Payments Due, Payment Performance, and Supplier and Customer report in using OBIEE UI.
• Configured OBIEE iBots to deliver analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.
• Involved in implementing the authentication and authorization security model in OBIEE 10g.
• Created Level based measures and dimension hierarchies in the BMM layer of OBIEE .rpd file.
• Involved in testing the OBIEE reports / dashboards and security set up on this analysis.
• Coordinated with testing team for testing the data.

Environment: Informatica 6.1.1, OBIEE 10.1.3.3.2 , Oracle 9i, Teradata v2r6, SQL, PL/SQL, SQL Server, DB2, Sun Solaris