Software Consultant Informatica

Rajeshwar Gonepalli

Mobile: 009***********

Email: ************@*****.***

Professional Summary:

Working as Data Warehouse Consultant with over 18+ Years of Experience in Data Warehousing Technologies.

5+ Years of experience in ETL technologies using Informatica.

13+ Years of experience in ETL technologies using SQL Server SSIS.

Working on Cognos Framework Manager Modeling tool, Report Studio and Analysis Studio.

Expert in INFORMATICA Power Center versions 8.1/7.1/6.2/ 6.1/6.0

7+ Years of Experience on Framework Manager, Analysis Studio.

Sound SQL knowledge in ORACLE 12C/11G/10G/9i/8.x/ RDBMS, SQL Server 2000 & 2005 & 2008 R2/2012.

Strong in Sources & Target Database Objects Tuning.

Experience in Sales, Financial, Banking, Healthcare and Insurance and Government Data Warehousing projects.

Having Knowledge on Unix.

Experience in different Data Sources like Oracle, SQL Server, DB2, Xml, Flat Files and MS Access, Excel.

Strong in Source to Target data Mapping, Slowly Changing Mapping Creation, Star Schema Mapping Creation.

Experience in ETL implementation and Production Support.

Experience in implementing the complex business rules by creating re-usable transformations, MAPPLETS transformations and PL/SQL stored procedures.

Worked on Change Requests based on Priority level.

Strong in Writing the SQL Queries and Optimizing SQL Queries.

Exposure in writing SQL queries, PL/SQL (Oracle 8.x/9i/10g/11g/12c) code (Stored Procedures, Packages, Triggers etc.,) in retrieving data efficiently from database.

Team player with good communication skills and Inter-personal skills.

Strong exposure on SQL Server Reporting Services, SQL Server Analysis Services and Microsoft Power BI.

Strong Exposure on Informatica BDM, Informatica Intelligent Cloud Services.

Knowledge on Python Programming.

Strong Exposure on Azure Data Factory.

Education:

M.Sc. (Computer Science) From Kakatiya University, Warangal.

B.Sc. (Computer Science.) From Kakatiya University, Warangal.

Experience:

Working as Systems Analysis Specialist in Dubai Statistics Center., Dubai from Sep 2008 to Till Date.

Worked as Software Consultant for Esquire Systems., Dubai from Nov 2006 to Apr 2008.

Worked as Software Engineer for Melstar Information Technologies Limited., Mumbai from July 2006 to Nov 2006.

Worked as Software Consultant for TechBizSoft Pvt. Ltd., Bangalore from Nov 2004 to July 2006.

Worked as Software Engineer at Phenomena Software Solutions., Hyderabad from Nov 2002 to Oct 2004.

Technical Expertise:

Languages : C, C++, SQL, PL/SQL.

Operating Systems : Unix, Windows 2000/XP/7 Professionals.

GUI’s : Visual Basic 6.0.

RDBMS : Oracle, SQLServer 2012/2008/2005

ETL Tools :Informatica Power Center 8.1/7.1/ 6.2/6.1/6.0, Workflow Manager, Workflow Monitor, Designer,and Repository Manager and SQL Server Integration Services.

Modeling Tools : Framework Manager 10.x/8.2/8.4/10.1.

OLAP Tools : Cognos 10.x/8.2/8.4/10.1,SSRS,SSAS,Power BI.

Methodologies : Star Schema, Snowflake Star Schema.

PROJECT DETAILS:

e-Statistical System Warehouse Sep 2008-Till Date

Systems Analysis Specialist

The Statistics Center is one of the Government Organization in Dubai.Its maintain historical data for Surveys all the government sectors in Dubai. We have around thirty departments in Dubai to maintain the data, the ETL process is for extracting the data from different systems, convert/transform the data and load the data into our centralized statistical center data warehouse.The ETL system is required to automatically load daily data periodically in a limited time. Furthermore, the system supports the loading of original data and historical data and the demand of extension. For loading the data warehouse, the ETL procedure can be divided into three stages, namely Extract, Transform and Load. The ETL process needed to be slightly different for historical load from incremental load. Almost all the Jobs have been design in order to correctly load the data for historical and incremental as well.

Responsibilities:

Worked on implemented change requests for this project.

Understanding database design schemas for different sources.

Interacting with the client regarding data and functional requirements.

Used Oracle as the target database. Source database is a combination of flat files, Excel, SQL Server tables and Oracle tables.

Working on SQL Server 2005/2008R2/2012 SSIS Packages to load data from Sql server database to Oracle database.

Working on Cognos Framework Manager Modeling tool to design the reports like create dimensions, facts and packages.

Working on Analysis studio for creating reports like crosstab and chart reports.

Used slowly changing dimensions concept to load data into dimensions tables.

Analyzing the Issue if any in flat file and Communicate with concerned person to resolve issue.

Involved in the preparation of various documents such as Source-To-Target Data mappings

Worked on full load and incremental load Jobs.

Analysis of certain existing Jobs, which were producing errors and modifying them to produce correct results.

Involved in Regression Testing and System Testing.

Technical Environment: SQL Server SSIS Packages, Flat Files, Oracle 10g/11g/12C, Toad, Cognos 8.2/8.4/10.x Framework Manager, Report Studio and Analysis Studio, Windows 10 and Linux.

EBG Warehousing Nov‘2006–Apr ‘2008

Software Consultant

Emirates Bank, one of the leading bank Group in UAE, We have no of Branches in UAE, Saudi Arabia and UK. The CDWH, A data warehouse for the bank operations and historic data will have an open architecture that allows for changes. Data is populated in the warehouse using ETL tool as Informatica. Data transformation/cleansing is done and data is loaded into the warehouse and the reports are generated using Cognos Report studio as the reporting tool.

Responsibilities:

Understanding Client Requirements & Requirement gathering.

Created Mappings using Mapping Designer.

Created Sessions, Workflows using Workflow Manager.

Created Tables, Indexes using Sql Server 2000.

Created transformations using Transformation Developer.

Responsible to develop and test the mappings.

Developed various Informatica Mappings & Mapplets to load data from source to staging and loading dimension keys and fact tables using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookups, Update Strategy, Expression,, Xml, Union transformations.

Worked on Informatica client tools Repository manager, Designer, workflow manager, workflow monitor and designer client tools source analyzer,targer developer,transformation developer,mapping designer and mapplet designer.

Used Lookup and Update Strategy to load data into Dimensions and Facts.

Refreshing Cognos reports using Cognos Impromptu, Framework Manager and Report Studio.

Technical Environment: Informatica Power Center 8.1, SQL SERVER 2000, Teradata, Flat Files,DB2,Oracle 10g,Toad,Framework Manager 8.1,Report Studio 8.1, Windows XP Professionals.

BASEL 2 July‘2006-Nov ‘2006

Software Engineer

ABN AMRO, one of the leading bankers in the present banking area. The CDWH, A data warehouse for the bank operations and historic data will have an open architecture that allows for changes, allows for incorporation of new business area’s and allows for both central and de-central implementation. The CDWH will use one file-set for data capturing from source systems. Data is populated in the warehouse using ETL tool as Informatica. Data transformation/cleansing is done and data is loaded into the warehouse and the reports are generated using Business Objects as the reporting tool.

Responsibilities:

Created Mappings using Informatica Designer tool.

Created Sessions, Workflows using Workflow Manager tool.

Created Views, Tables, Indexes using Sql Server 2000.

Created transformation tools using Transformation Developer.

Involved testing environment.

Involved in Extraction, transformation and loading of the data from different Data Sources like Flat files, sql server to the sql server.

Worked on versioning check in, check outs deployment done from personal folder to application folder.

Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, sequence generator and joiner

Scheduling the Workflows using Workflow Manager.

Created Sessions, workflows and worklets for designed mappings.

Written SQL overrides in source Qualifier according to business requirements.

Created Stored Precedures and Functions.

Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.

Technical Environment: Informatica Power Center 7.1, SQL SERVER 2000,Flat Files, Windows XP Professionals.

M.H.I.D.C. Nov’2005-July’2006

Software Consultant

This Project aimed to implement Data Warehousing for Drugging M.H.I.D.C.(Medical Health Infrastructure Development Corporation). The responsibilities of the above are to purchase drugs, distribute the drugs to district Warehouses, allocate budgets to the hospitals and rising tenders to drug suppliers. All the centers contain all Warehouses for stocking drugs, under each Warehouse there are number of hospitals coming under different organizations.

Responsibilities:

Worked on Informatica-Source Analyzer, Warehouse Designer, Mapping Designer & Mapplets, and Transformations.

Involved in the development of Informatica Mappings.

Created Informatica Mappings with PL/SQL Procedures.

Extensively worked on data base procedures and functions.

Extensively used ETL to load data from oracle, Flat Files to Oracle.

Used most of the transformations such as Source Qualifiers, Aggregators, Filters, Lookups, Update Strategies and Sequence Generators.

Responsible to design, develop and test the mappings

Technical Environment: Informatica Power Center 6.2, Oracle 8i, SQL, PL/SQL, Flat Files, Windows XP Professional.

Advance America Data Warehouse Nov’2004-Oct’2005

Software Consultant

Advance America Data Warehouse is a real time or near real time, extensible performance analysis framework for the Advance America Financial Bank.The goal of this project is to provide performance reports based on transactional data and historical data to address client performance questions, and to identify areas and opportunities for system improvements. It follows star schema principles and Kimball methodology, using Informatica performing the ETL Process and builds Universes that can be accessed for reporting through Business Objects.

Responsibilities:

Worked on Source Analyzer to import relational tables.

Worked on Warehouse Designer to import and created target relational tables.

Worked on Mapping Designer to create mappings.

Understanding Client Requirement.

Involved in the development of Mappings.

Involved in identifying Business requirements and deliver the solutions.

Extensively used ETL to load data from oracle to Oracle.

Created transformations in the mapping designer such as Aggregators, Filters, Lookups, Update Strategies and Sequence Generators.

Technical Environment: Informatica Power Center 6.1, Business Objects 5.1, Oracle 8i, SQL, Windows XP Professional.

WF AFG Data Warehouse (Wells Fargo) Nov’2003-Oct’2004

Software Engineer

The objective of the project is to develop data warehouse for Auto Finance group of Wells Fargo, CA, USA, integrating the enterprise wide distributed data sources. The legacy data, extracted in Flat files, extracted, transformed and loaded into data warehouse using Informatica and Sql Loader and the reports were built using Business Objects.

Responsibilities:

Understanding Client Requirement.

Worked on Designer Tool to import source and target tables and creating mappings.

Involved in the development of Mappings.

Created sessions and batches to run the mappings.

Extensively used ETL to load data from oracle to Oracle.

Created transformations in the mapping designer such as Aggregators, Filters, Lookups, Update Strategies and Sequence Generators.

Technical Environment: Informatica Power Center 6.0, Business Objects 5.1, Oracle 8i, SQL, Windows 2000.

.

Athene Softech Limited Nov’2002-Oct’2003

Software Engineer

Sales to cash provide users the capability to evaluate revenues at various levels of Accounts, starting with the Global Large Amounts (GLAs) or Multi-dimensional Corporation (MNCs) down to the Sales Account. It helps in grouping revenue information from various sources and system to one place in Data Warehouse. It enable user to analyze all revenues information at one place and encapsulate complex data and calculation from end user. Security was implemented at row level as well as report level to maintain confidentiality of data according to user level and groups. Informatica, ETL tool was used to extract data from various sources, cleaning it and loading it to Data Warehouse.

Responsibilities:

Created Oracle Tables and inserted data into the tables.

Created Indexes Using oracle for increase performance.

Created transformations such as Filters, Expressions and Lookups and Update Strategy transformations.

Worked on connected Lookup transformation to look up values in a table.

Involved in the development of Mappings.

Created Target Tables in the Warehouse Designer.

Using ETl to load data from Oracle to Oracle.

Technical Environment: Informatica Power Center 6.0, Oracle 8i, SQL, Windows 2000.

Contact this candidate