it_user275235

Data Warehousing and Business Intelligence Lead at Bank of America
Has 5-10 Years Of Experience

Badges

User Activity

About 10 years ago

Commented on It can work with any kind of database, including NoSQL ones, but when a database object changes then object definitions do not get refreshed automatically.

GaryM, I understand that automatic refresh can cause data mapping errors, but identifying the changes, notifying the users and letting the user decide how to apply the changes (update, ignore, create a copy of mapping and edit ...). When the object in DB changes, chances…

Over 10 years ago

Answered a question: When evaluating NoSQL Databases, what aspect do you think is the most important to look for?

With any DB, ETL plays a significant role. Being an ETL person, for me, NoSQL DB's compatibility with BI/ETL tools and it's connectivity matters most Secondly NoSQL requires very good programming skills unless a GUI interface can be used to maneuver around the DB, so the…

Over 10 years ago

Answered a question: When evaluating Reporting Software, what aspect do you think is the most important to look for?

Apart from speed with which the data reflects the changes applied to DB, when you make a selection on the report, data related to only that particular selection should reflect in subsequent tabs or applications. For example: if i choose a product on products tab, it's sales…

Over 10 years ago

Commented on It can work with any kind of database, including NoSQL ones, but when a database object changes then object definitions do not get refreshed automatically.

Hello Joop Thank you for your comment. Unfortunately Informatica integration service does not interact with DB to pick up live feeds. So, anytime Insert/Update/Delete occurs on a DB object, it's corresponding definition in Informatica needs to be refreshed manually…

Over 10 years ago

Contributed a review of Informatica PowerCenter: It can work with any kind of database, including NoSQL ones, but when a database object changes then object definitions do not get refreshed automatically.

Almost 11 years ago

Contributed a review of Toad Data Modeler: It allows reusable queries for faster debugging, but it doesn't allow creating multiple pipes in one integrated workflow.

Experience

Reviews

Over 10 years ago

Informatica PowerCenter

It can work with any kind of database, including NoSQL ones, but when a database object changes then object definitions do not get refreshed automatically.

Almost 11 years ago

Toad Data Modeler

It allows reusable queries for faster debugging, but it doesn't allow creating multiple pipes in one integrated workflow.

Answers

Over 10 years ago

NoSQL Databases

When evaluating NoSQL Databases, what aspect do you think is the most important to look for?

Over 10 years ago

Reporting

When evaluating Reporting Software, what aspect do you think is the most important to look for?

Comments

About 10 years ago

Data Integration

It can work with any kind of database, including NoSQL ones, but when a database object changes then object definitions do not get refreshed automatically.

Over 10 years ago

Data Integration

It can work with any kind of database, including NoSQL ones, but when a database object changes then object definitions do not get refreshed automatically.

About me

Tech Lead with expertise in areas of Business Intelligence and Data Warehousing. Demonstrated experience utilizing ETL Tools like Informatica, SAP BODS, SSIS and Data Probe, Informatica as my primary tool of expertise. Strong Leadership experience mentoring interns, providing in-house training and managing/leading technical groups on BI/ETL standards and best practices.

Professional Developments: Trained with SAP on BODS and Trained with Truven Health on Data Probe.

Efficient in SQL Scripts and flexible with different Operating Systems.

Extensively used TOAD , Oracle Developer , SQL Navigator, i-Series Navigator, SQL Showcase Query 7.0 and i-series Emulator for Data Modelling, Data Analysis, Data Manipulation and Data Profiling.

Specialties::

Languages : C, C++, SQL, XML.

ETL tools : Informatica versions 7.1, 8.1, 8.6, 9.1, SAP BODS 3.x, SSIS, Power Exchange 8.X, Truven Health Data Probe.

Database : Oracle 9i/10g/11g, DB2 AS 400, SQL Server 2008, XML, Cobol/VSAM, Flat Files, mongoDB.

Database Tools : TOAD, Oracle Developer, Qlik View, Showcase Query, i-Series Nav and Emulator.

Systems : Windows 98/2000/XP/Vista, UNIX (Sun Solaris), MS-DOS.

Certifications

M102: MongoDB for DBAs
HIPAA_Security_Training_Certificate

Employers

Virginia Tech
Home
Medical Advantage Group
OneAmerica Financial Partners Inc.
Solar Turbines
Dawn Food Products
ACS a XEROX Company
IndSoft

Education

Silicon Valley University - MSCS, CA, USA
Osmania University, BE - Mech, India
Triplaar School of Learning, India
St.Joseph High School, India.