Anurag Guli

•Creating the new online Oracle open system relation architecture to accommodate all Railroad Commission of Texas's applications like Fields, Lease, Organization Reports, Underground Injection control , Well-bore and many others. •Migrating the data using Informatica mappings that are replacing existing scripts, which load the data from Mainframe IMS Segments into Oracle tables. •Installed PowerExchange on Mainframe to perform CDC between VSAM, IMS, Oracle, and MySQL objects.

1.Building mapping routines using Informatica by pulling data out of Model N (revenue management software) to Flat Files. 2.Used Informatica to create mapping routines that will trigger and API call into Anaplan (Planning Platform). 3.Worked with Anaplan support team to configure Anaplan script to upload single and multiple extract files into Anaplan server

An accelerator is provided for DataHub 8.3 demonstrating how it can be used as a staging layer in support of data migration for PolicyCenter 8.0.3. The work includes extensions to the DataHub data model; extensions to the OOTB ETL code which loads DataHub from PolicyCenter, encompassing those DataHub extensions; and new ETL code and data structures to extract data from DataHub and form XML “payloads” for migrating both Accounts and conversion on renewal Personal Auto policies.

Gathered the business requirements from Business Analyst. Worked on analyzing Source to Target mapping Excel document. Data integration with SFDC and Microsoft Dynamics CRM using Informatica cloud. Design, Development, Testing and Implementation of ETL processes using Informatica Cloud. Convert specifications to programs and data mapping in an ETL Informatica Cloud environment. Specialized technical knowledge of the MongoDB platform or similar NoSQL technologies.

• Working as ETL Developer in understanding the requirements of the End Users/Business Analysts and developing applications for ETL Process using Ab Initio process. • Participated in business, Detail design and Technical specification documentation for Client’s standards, procedures and naming conventions. • Involved in data quality, source to target mappings, applying various validations and business rules associated with ETL processes.

Responsible for stability of Coventry data warehouse also. I work on any defects as well as any new development changes going into production. I do all of this, while handling a small production run team of size 5 with two weeks per month on-call rotation.

The project here will implement a customer master repository to manage all the essential customer master data elements in one central database. The project is cantered on the Informatica MDM platform and will utilize capabilities of Informatica data quality tools, data integration tools and Informatica data virtualization technology.

Database Management & Data Warehousing, ASP & C#, Webservices, Java, OOPS, SDLC, AI, Cloud.

RDBMS, JAVA, C, C++, .Net, HTML, CSS, JavaScript.