Home

Venkatesh R - ETL Informatica / BI Developer

[email protected]

Location: New York City, New York, USA

Relocation: No

Visa: H1B

Summary and Accomplishments 12+ Years of IT experience as a Functional and Technical Software Engineer/Consultant in the development of Data Warehousing/ Data Marts and Reporting environments. Experience in analyzing, designing and modeling data warehouses and star schema data marts for various business verticals like Imports, Unemployment Insurance, Health Care (Pharmacy) and Sales. ETL-Data Warehousing experience using Informatica PowerCenter 9.6.0/9.6.1/10.4.1, Informatica Intelligent Cloud services (IICS), Informatica Developer (BDM), Informatica Data Quality(IDQ), Data Integration Hub (DIH) , SAP Business Objects Data Services 3.2/4.2 (SAP BODS), Workflow Manager, Workflow Monitor, Repository Manager. Conducted job duties and responsibilities according to the organization s business systems development methodology and/or its Systems Development Life Cycle (SDLC) methodology and Agile. Experience in using Business Objects Suite products such as CMC, LCM, Designer/Information Design Tool, Web Intelligence, Deski, Dashboard Manager, Crystal Reports, Live Office, Business Explorer (BEx Query), QAAWS, Xcelsius, Explorer, Information Steward and Lumira. Experience in leading and implementing Client server, Cloud based ETL integration projects using Informatica IICS, Oracle, Microsoft Azure, Informatica BDM, AWS and Hadoop environment Proficient in planning, designing and building Universes using databases like IBM-DB2 UDB, Oracle, TeraData, SQL Server, Personal Data Files and Stored Procedures. Experience in Migrating and Upgrading Universes & Reports from Business Objects XI R2 to XI 3.1 and XI 3.1 to XI 4.0. Managing the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CCM. Participated in ETL requirements gathering meetings with tier-1 data analyst s and suggested the designs in development point of view for building the ETL Specification document. Extracted data from Homogeneous and Heterogeneous sources and developing the mapping needs and to push the data as per ETL Specification document into Target Tables. Has good hands-on knowledge in configuring various transformations like Source Qualifier, Expression, Filter, Joiner, Aggregator, Router, Unconnected and Connected Lookups, Update Strategy, Sequence Generator, Stored Procedure. Created, Generated and Installed SAP R/3 code by connecting SAP Applications through Informatica Powercenter 10.4.1. Handled PRE-SQL and POST-SQL for targets. Implemented SQL Overrides at Source Qualifier and Lookups whenever needed. Created Reusable objects like Transformations (Expression, Stored Procedure, Filter, and Lookup-Unconnected), Mapplets, and Functions. Experience in Informatica s Intelligent Data Management Cloud. Lead the team for Integrating Informatica Intelligent Cloud services to Microsoft Azure application. Strong experience in designing the Design Documents for loading data into Data Warehouse and Data Mart tables. Adept in using of Data Services Designer, Job Server Manager, Repository Management, Access Server, Data Service Management Console in Business Objects Data Services (BODS). Extensively used Data Services Management Console to schedule, publish and execute jobs, manage repositories and perform metadata reporting. Experience in creating Custom Functions, System Configurations and Substitution parameter configurations in BODS Designer. Experience in 24/7 Production Support for Webi, Deski, Crystal Reports Reports, ETL Batch Jobs, Services and Servers. Experience in creating Data Sources for Tableau Dashboards. Expert in documenting business requirements, functional, technical specifications and test cases. Designed and delivered end-user training and training materials, provided technical support as necessary. Excellent team player at all levels with ability to perform independently with exceptional communication, analytical, presentation and problem-solving skills. K.vishnu Bench Sales Recruiter [email protected] Anira Solutions 703 740 0055 Keywords: rlang information technology